Black Friday Mega Drop - Up to 75% Off Best Sellers - Ends in 0d 00h 00m 00s - Coupon code: certbig75

DP-900 Exam Dumps - Microsoft Certified: Azure Data Fundamentals Questions and Answers

Question # 44

Match the types of analytics that can be used to answer the business questions.

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

NOTE: Each correct match is worth one point.

Options:

Buy Now
Question # 45

Your company is designing a data store tor internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

Options:

A.

relational

B.

columnar

C.

graph

D.

time series

Buy Now
Question # 46

You need to modify a view in a relational database by adding a new column.

Which statement should you use?

Options:

A.

MERGE

B.

ALTER

C.

INSERT

D.

UPDATE

Buy Now
Question # 47

Which storage solution supports role-based access control (RBAC) at the file and folder level?

Options:

A.

Azure Disk Storage

B.

Azure Data Lake Storage

C.

Azure Blob storage

D.

Azure Queue storage

Buy Now
Question # 48

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Options:

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Buy Now
Question # 49

Select the answer that correctly completes the sentence.

Options:

Buy Now
Question # 50

To complete the sentence, select the appropriate option in the answer area.

Options:

Buy Now
Question # 51

You need to store data by using Azure Table storage.

What should you create first?

Options:

A.

an Azure Cosmos DB instance

B.

a storage account

C.

a blob container

D.

a table

Buy Now
Question # 52

You have the following T-SQL statement.

What is the function of the ON clause?

Options:

A.

to update data in the Order table

B.

to define an alias for the Customer table

C.

to match data in the Customer table to data in the Order Table

D.

to update data in the Customer table

Buy Now
Question # 53

Select the answer that correctly completes the sentence.

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Nov 18, 2026
Questions: 341
DP-900 pdf

DP-900 PDF

$25  $99.99
DP-900 Engine

DP-900 Testing Engine

$28.75  $114.99
DP-900 PDF + Engine

DP-900 PDF + Testing Engine

$37.5  $149.99