Free Microsoft DP-600 Exam Questions

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a lakehouse 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:

REFRESH TABLE customer -

Does this meet the goal?

You have a Fabric tenant. You are creating a Fabric Data Factory pipeline. You have a stored procedure that returns the number of active customers and their average sales for the current month. You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline. Which type of activity should you add?Script

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 workspace named Workspace1 and a warehouse named Warehouse1. Workspace1contains a user named User1. User1 is assigned the Viewer role for Workspace1.You need to ensure that User1 can share Warehouse1 with other users. The solution must follow theprinciple of least privilege.Which role should you assign to User1?

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?