Microsoft DP-600 Exam Practice Questions
US$39
Every question with the correct answer and why the other options are wrong.
Card, Apple Pay, Google Pay or PayPal. Your PDF is prepared and emailed to you after checkout, usually within a few hours.
Passed DP-600 first time thanks to this.
Three of the 222 questions in this pack
Question 1
You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables: Table1: A Delta table created by using a shortcut Table2: An external table created by using Spark Table3: A managed table You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?
Show answer and explanation
Correct answer: A. Read Table3.
When connecting to a lakehouse via its SQL endpoint, you can only read managed tables. Table3 is a managed table created and maintained by Fabric, making it readable through the SQL endpoint. Shortcuts (Table1) and external tables created by Spark (Table2) are not accessible through SQL endpoints, as they are not part of the managed table schema. Updates to any tables through SQL endpoints are not permitted; SQL endpoint connections are read-only.
Why the other options are wrong
- B. SQL endpoint connections are read-only and do not permit updates to any data.
- C. External tables created using Spark are not accessible through SQL endpoints.
- D. Delta tables created by shortcuts are not directly accessible through SQL endpoint queries; shortcuts are not included in the SQL schema.
Question 2
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 PowerQuery step to identify the maximum values for the numeric columns. Which function should you include in the step?
Show answer and explanation
Correct answer: D. Table.Profile
Table.Profile returns a table of statistics for every column in the input, including Min, Max, Average, Count and NullCount. Adding it as a step gives the maximum value of each numeric column in one call. This is the Power Query function designed for this kind of column profiling.
Why the other options are wrong
- A. Table.MaxN returns the top N rows based on a comparison criterion, not the maximum value of each column.
- B. Table.Max returns the single row with the largest value for one comparison criterion, not the maximum of every numeric column.
- C. Table.Range returns a set of rows starting at a given offset and does not calculate maximum values.
Question 3
You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the PREDICT function in a Fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
Show answer and explanation
Correct answer: C, D. Spark SQL; PySpark
The PREDICT function in Fabric notebooks can be used with Spark SQL and PySpark to generate predictions from registered machine learning models. Spark SQL allows inline prediction queries within SQL statements, while PySpark provides programmatic access to the PREDICT function for model scoring operations. Both languages integrate with Fabric's ML runtime to execute registered models.
Why the other options are wrong
- A. T-SQL is not available for use in Fabric notebooks for model scoring operations.
- B. DAX is a Power BI language and cannot be used in Fabric notebooks for PREDICT function operations.
5 reviews for Microsoft DP-600 Exam Practice Questions
Only logged in customers who have purchased this product may leave a review.
How much of the Microsoft DP-600 bank is free?
222 questions in the bankEach step includes the one before, so buying only adds new questions.
- You are here10questionsFree sampleThree on this page, all ten as a PDF.Download the sample
- 4420% of the bankPractice pageFree on the site, every answer explained.Go to the practice page
- 5826% of the bankHalf PackFree by email, as one PDF, every answer explained.Get the Half Pack
- 222100%, the whole bankFull pack, US$39Plus the questions-only PDF, monthly updates, refund if you fail.Get the full pack
What’s in the Microsoft DP-600 pack
- 222 questions mapped to the DP-600 exam objectives
- Answers and explanations for every question, including the wrong options
- A questions-only PDF for timed practice runs
- Delivered by email shortly after checkout
- Free monthly updates for as long as the exam is live
- Pass or your money back
A DP-600 attempt costs US$165 in the US. This pack is US$39, paid once.
What makes the DP-600 hard
The DP-600 sits at the intersection of Power BI and Azure data engineering, and that is exactly what catches people out. Microsoft Fabric combines data engineering, warehousing, real-time analytics and BI into one platform, and the DP-600 certifies the people building on top of it: when to use a lakehouse versus a warehouse, how Direct Lake mode falls back to DirectQuery, how DAX behaves under filter context, and how to query event data with KQL. Candidates who know Power BI well consistently underestimate the data engineering side, and that is where most failures come from.
The current blueprint has three domains, and preparing data is the dominant one at 45 to 50%, close to half the exam. A study plan still built on an older domain split is spending time in the wrong place.
The exam runs to 40 to 60 scenario-based questions in 100 minutes, with a pass mark of 700 out of 1000. Microsoft does not test definitions, it tests decisions: the architecture scenarios, pipeline questions and semantic model framing that make up the bulk of the paper.
About the exam
The DP-600 certifies Fabric Analytics Engineers who design, implement and manage analytics solutions using Microsoft Fabric. It bridges data engineering and BI, requiring hands-on SQL, DAX and data modelling skills. No formal prerequisites. Skills measured as of 21 July 2026. Renews annually via a free Microsoft Learn assessment.
Questions before you buy
How quickly do I receive it?
Your PDF is prepared and sent to your email address after checkout, and you get a confirmation as soon as it is on its way.
Are updates included?
Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.
What if I fail the exam?
We refund the pack, or swap it for any other pack if you would rather keep studying. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.
What is your pass rate?
99% of customers who prepare with a CertStash pack pass. If you do not, we refund the pack, or swap it for another pack.
Can I share it with colleagues?
Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.
Related products
-
Microsoft DP-900
323 questionsUpdated Nov 20265.0 (10) US$39 -
Microsoft AB-620
116 questionsUpdated Nov 2026 US$39 -
Microsoft AB-410
174 questionsUpdated Nov 2026 US$39 -
Microsoft DP-700
161 questionsUpdated Nov 20265.0 (11) US$39
Sora –
Passed DP-600 first time thanks to this.
Milan Robin –
Good resource for DP-600.
Okonkwo –
Cleared my DP-600 thanks to this.
Varun Thakur –
DP-600 was challenging, but Cert Stash’s study material simplified everything. Practicing daily helped me grasp analytics concepts better. Felt confident walking into the exam.
Casper Ibarra –
Good for DP-600.