Microsoft DP-900 Practice Test Questions

For each of the following statements. select Yes if the statement is true. Otherwise, select No. NOTE Each correct selection is worth one point.

What are two uses of data visualization? Each correct answer present a complete solution.
NOTE: Each correct selection is worth one point.

A.

Represent trends and patterns over time.

B.

Communicate the significance of data.

C.

implement machine learning to predict future values.

D.

Consistently implement business logic across reports

Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may
be used once, more than once, or not at all.
NOTE: Each correct match is worth one point

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 persist the SQL query so that other users can use the query. What should you create?

A.

a table

B.

an index

C.

scalar function

D.

a view

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

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

You have a table named Sales that contains the following data.

For each of the following statements, select Yes if the statement is true. Otherwise select No.
NOTE: Each correct selection is worth one point.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

A.

Azure Queue storage

B.

Azure Data Lake Storage

C.

Azure table storage

D.

Azure Files