DP-900 Free Practice Test

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

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

1. A. WHERE
2. B. SELECT
3. C. JOIN

Correct Answer: B

Match the types of activities to the appropriate Azure Data Factory activities.
To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact.
What should you do on the SQL pool?

1. A. Scale down the data warehouse units (DWUs).
2. B. Pause the pool.
3. C. Create a user-defined restore point.
4. D. Delete the pool

Correct Answer: B

Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A