Free Microsoft DP-600 Exam Questions

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?

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step? 

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. Thesolution must minimize development effort.What should you use to add the data?

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. Thesolution must minimize development effort.What should you use to add the data?

You have a Fabric tenant that contains a workspace named Workspace^ Workspacel is assigned to a Fabric capacity. You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege. Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.