Free Microsoft DP-600 Exam Questions
Absolute Free DP-600 Exam Practice for Comprehensive Preparation
-
Microsoft DP-600 Exam Questions
-
Provided By: Microsoft
- Exam: Microsoft Certified: Fabric Analytics Engineer Associate
- Certification: Microsoft Azure
-
Total Questions: 209
-
Updated On: Oct 02, 2026
-
Rated: 4.9 |
-
Online Users: 418
-
Question 1
-
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?
Answer: A
-
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?
-
Question 2
-
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?
Answer: B
-
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?
-
Question 3
-
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?
Answer: B
-
-
Question 4
-
You have a Fabric tenant that contains a new semantic model in OneLake. You use a Fabric notebook to read the data into a Spark DataFrame. You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns. Solution: You use the following PySpark expression: df.show() Does this meet the goal?
Answer: B
-
-
Question 5
-
You have a Fabric tenant that contains two workspaces named Woritspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse! contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers. You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables. What should you use?
Answer: A
-