DP-900 Practice Test

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