Free DP-600 Practice Test Questions and Answers (2026)

View Mode
Q: 1

HOTSPOT You need to resolve the issue with the pricing group classification. How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Microsoft DP 600 question Microsoft DP 600 question

Your Answer
27 comments in the community discussion
6
C . You're just charting distributions and showing what the customer data looks like, not explaining why churn happened (B) or predicting future churn (D). Unless the question shifted to root causes or forecasting, it's strictly descriptive. Disagree?
1
B tbh, since comparing retained vs lost customers across segments feels like diagnostic analytics to me. You're looking for relationships or reasons behind churn, not just summarizing. I've seen similar wording confuse in practice tests, but could be off here.
Q: 2

HOTSPOT You have a Microsoft Power B1 report and a semantic model that uses Direct Lake mode. From Power Si Desktop, you open Performance analyzer as shown in the following exhibit. Microsoft DP 600 question Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Microsoft DP 600 question

Your Answer
34 comments in the community discussion
5
Automatic and Direct Lake. The fallback trap is DirectQueryOnly, pretty sure that’s not it.
2
Option D saw this type of ask in a recent exam report, BPA is made for this exact scenario.
Q: 3

DRAG DROP You are creating a dataflow in Fabric to ingest data from an Azure SQL database by using a T-SQL statement. You need to ensure that any foldable Power Query transformation steps are processed by the Microsoft SQL Server engine. How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Microsoft DP 600 question

Drag & Drop
23 comments in the community discussion
5
Option A
1
Distinct count for pickupLongitude is less than total rows, so A fits because that means duplicates exist. Pretty sure that's the intent, since D would only work if they asked for the exact number of unique values. Agree?
Q: 4
You are analyzing the data in a Fabric notebook. You have a Spark DataFrame assigned to a variable named df. You need to use the Chart view in the notebook to explore the data manually. Which function should you run to make the data available in the Chart view?
Options
25 comments in the community discussion
4
Nah, statement 3 is a trap since the query filters out zero-sales categories. It's Yes, Yes, No here. Pretty sure from the way the > 0 clause works in KQL.
4
Yeah this is just Yes, Yes, No for those statements. The TotalSales > 0 filter drops any zero-sales categories from the results.
Q: 5
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 uses Pro license mode and contains a semantic model named Model1. You need to ensure that Modell supports XMLA connections. Which setting should you modify?
Options
27 comments in the community discussion
6
CREATE TABLE dbo.POSCustomers AS SELECT is the way to go, since CTAS lets you build a new table with a select query in Fabric warehouses. Then you'll want FROM lakehouse1.dbo.customer so it pulls from the right source using three-part naming. Pretty sure, unless your workspace has some odd permissions setup that blo
5
I don't think CLONE works here. CTAS lets you pick columns and query across Lakehouse to Warehouse, but CLONE would just copy the whole structure, not let you do SELECTs. So it should be CREATE TABLE AS SELECT, from lakehouse1.dbo.customer. Pretty sure that's what Microsoft expects unless there's a new feature I'm miss
Q: 6

HOTSPOT You have a Fabric tenant that contains a warehouse named WH1. You run the following T-SQL query against WH1. Microsoft DP 600 question For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Microsoft DP 600 question

Your Answer
26 comments in the community discussion
6
Import mode with query caching ON is the right combo here. Direct Lake trips people up since it’s super fast, but doesn’t support calculated tables or complex columns using aggregations. Import covers those requirements. If anyone’s seen Direct Lake add this support, let me know.
6
Import mode, query caching ON. Only import supports complex calculations and calculated tables, while caching helps with fast report rendering.
Q: 7
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?
Options
32 comments in the community discussion
5
ResearchReviewersGroup1: ViewerResearchReviewersGroup2: ContributorThis matches least privilege. Group1 just needs to see reports, so Viewer is enough. Group2 edits, so Contributor fits. Pretty sure this is what MS expects here, but open if anyone sees a catch.
3
Saw this in some practice sets-Group1 gets Viewer, Group2 gets Contributor. That lines up with least privilege since only the second group should modify anything. Pretty sure that's right but let me know if anyone read the requirements differently.
Q: 8

HOTSPOT You have the source data model shown in the following exhibit. Microsoft DP 600 question The primary keys of the tables are indicated by a key symbol beside the columns involved in each key. You need to create a dimensional data model that will enable the analysis of order items by date, product, and customer. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Microsoft DP 600 question

Your Answer
29 comments in the community discussion
5
Value to NativeQuery to EnableFolding. This matches how you let SQL Server handle the folding steps in Power Query.
5
Value to NativeQuery to EnableFolding is the right mapping, Optimize is a distractor here since folding's the priority.
Q: 9

DRAG DROP You have a Fabric tenant that contains a semantic model. The model contains data about retail stores. You need to write a DAX query that will be executed by using the XMLA endpoint The query must return a table of stores that have opened since December 1,2023. How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Microsoft DP 600 question

Drag & Drop
29 comments in the community discussion
7
All about join type and aggregate filter here. LEFT OUTER JOIN for preserving all employees, HAVING for filtering after aggregation.
6
LEFT OUTER JOIN, HAVING. Official guide covers this scenario with joins and aggregation. Practice labs help too if this feels tricky, especially on why HAVING goes after GROUP BY. Someone correct me if T-SQL has a newer way but pretty sure that's it.