Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 9 / 10
Total 313 questions

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

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

A.

a scalar function

B.

a table

C.

an index

D.

a view

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

You manage an application that stores data in a shared folder on a Windows server.

You need to move the shared folder to Azure Storage.

Which type of Azure Storage should you use?

A.

queue

B.

blob

C.

file

D.

table

You have the following two tables of customer data.

Which type of data do the tables contain?

A.

non-relational

B.

structured

C.

semi-structured

D.

unstructured

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

A.

a linked service

B.

an integration runtime

C.

a control flow

D.

a pipeline

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.