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: 174
-
Updated On: Jun 16, 2026
-
Rated: 4.9 |
-
Online Users: 348
-
Question 1
-
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?
Answer: B
-
-
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. 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
Answer: A
-
-
Question 4
-
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 5
-
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?
Answer: D
-