Microsoft DP-600 Answers

Which type of data store should you recommend in the AnalyticsPOC workspace?  

You have a Fabric tenant that contains a takehouse named lakehouse1. Lakehouse1 contains a Delta table named Customer. When you query Customer, you discover that the query is slow to execute. You suspect that maintenance was NOT performed on the table. You need to identify whether maintenance tasks were performed on Customer. Solution: You run the following Spark SQL statement: DESCRIBE HISTORY customer Does this meet the goal? 

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point. 

You have a Fabric tenant named Tenant! that contains a lakehouse named Lakehouse1.

You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The

solution must minimize development effort.

What should you use to add the data?

HOTSPOT You have a Fabric tenant that contains a warehouse named WH1. You run the following T-SQL query against WH1.

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