Halloween Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

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

Viewing page 3 out of 11 pages
Viewing questions 21-30 out of questions
Questions # 21:

Which command-line tool can you use to query Azure SQL databases?

Options:

A.

sqlcmd


B.

bcp


C.

azdata


D.

Azure CLI


Expert Solution
Questions # 22:

Match the data storage options to the appropriate types of data.

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

NOTE: Each correct match is worth one point.

Question # 22


Expert Solution
Questions # 23:

Which Azure Data Factory component provides the compute environment for activities?

Options:

A.

a linked service


B.

an integration runtime


C.

a control flow


D.

a pipeline


Expert Solution
Questions # 24:

tence.


Expert Solution
Questions # 25:

Your company is designing a data store that will contain student data. The data has the following format.

Question # 25

Which type of data store should you use?

Options:

A.

graph


B.

key/value


C.

object


D.

columnar


Expert Solution
Questions # 26:

match the Azure data factory components to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Question # 26


Expert Solution
Questions # 27:

How is raw data stored in a data lakehoose?

Options:

A.

as tables


B.

as queues


C.

as files


D.

as disks


Expert Solution
Questions # 28:

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

Question # 28


Expert Solution
Questions # 29:

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?

Options:

A.

WHERE


B.

SELECT


C.

JOIN


Expert Solution
Questions # 30:

Select the answer that correctly completes the sentence.

Question # 30


Expert Solution
Viewing page 3 out of 11 pages
Viewing questions 21-30 out of questions