Summer Sale Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75

Pass the Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with Dumpstech

Exam DP-900 Premium Access

View all detail and faqs for the DP-900 exam

Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions
Questions # 31:

Select the answer that correctly completes the sentence.

Question # 31

Options:

Questions # 32:

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Options:

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Cosmos DB

D.

SQL Server on Azure virtual machines

Questions # 33:

Select the answer that correctly completes the sentence.

Options:

Questions # 34:

Select the answer that correctly completes the sentence.

Options:

Questions # 35:

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

Options:

A.

Microsoft SQL Server Data Tools (SSDT)

B.

Microsoft SQL Server Management Studio (SSMS)

C.

Azure Databricks

D.

Azure Data Studio

Questions # 36:

What can you use to create data ingestion pipelines?

Options:

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Data Factory

D.

Azure Cosmos DB

Questions # 37:

You need to create a visualization of running sales totals per quarter as shown in the following exhibit.

Question # 37

What should you create in Power BI Desktop?

Options:

A.

a waterfall chart

B.

a ribbon chart

C.

a bar chart

D.

a decomposition tree

Questions # 38:

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one point.

Options:

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Questions # 39:

Match the datastore services to the appropriate descriptions.

To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Question # 39

Options:

Questions # 40:

Select the answer that correctly completes the sentence.

Question # 40

Options:

Viewing page 4 out of 10 pages
Viewing questions 31-40 out of questions