100% Free Microsoft DP-600 Practice Test Questions and Answers 2026

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:  

You have a Fabric tenant that contains a warehouse. Several times a day. the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring? 

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

You are creating a semantic model in Microsoft Power Bl Desktop. You plan to make bulk changes to the model by using the Tabular Model Definition Language (TMDL) extension for Microsoft Visual Studio Code. You need to save the semantic model to a file. Which file format should you use? 

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements: Replace Table1 with the schema of the external data. Replace all the data in Table1 with the rows in the external data. You add a Copy data activity to the pipeline. What should you do for the Copy data activity?