How are DP-600 questions generated?

dotCreds builds DP-600 practice questions from public exam objectives and Microsoft Learn and exam-objective references. The questions are written for realistic study practice, not copied from exam dumps.

How are explanations sourced?

Each question includes an explanation and, when available, a source link back to the provider documentation or reference used to validate the answer. That keeps the practice tied to study material you can actually review.

The page tracks today's answered count and accuracy for the 10-question daily set, then saves a 7-day score history on this device so you can see your recent practice trend.

The site is the fastest way to start DP-600 practice without installing anything. It is built for daily recall, quick weak-topic discovery, and source-backed explanations you can review immediately.

Free DP-600 Practice Test

DP-600 Practice Test

Start today’s free 10-question DP-600 set with source-backed explanations, local progress, and a fresh rotation every morning.

10 Free Daily Questions Source-backed Explanations 200 Verified Questions

Questions updated at Aug 6, 2026, 10:37 PM CDT

Unlock the full DP-600 bank

200 verified questions Exam Mode Practice Mode Detailed explanations Weak-area review No subscription - one-time unlock

Get the complete source-backed bank with Interview Questions, the full Study Guide, full Course Notes, detailed explanations, weak-area review, and exam-style practice.

Interview Questions Full Study Guide Full Course Notes Exam Mode Practice Mode Guided Course Detailed explanations Weak-area review No subscription

What you get with free practice

10 Free Questions Daily Fresh set every day from the live bank

Detailed Explanations Learn with clear source-backed answers

Track Your Progress Daily history and performance insights

Upgrade Anytime Unlock the full bank when you are ready

Question 1 of 10

Objective Select, filter, and aggregate by using Visual Query Editor, SQL, KQL, and DAX Prepare data

A warehouse query joins a five-year Sales table to Product and then returns only yesterday's online orders. The result is correct but unnecessarily expensive. Which revision is most likely to reduce data processed without changing the answer?

Concept tested:

Source:Visual Query Editor in the Fabric portal

Question 2 of 10

Objective Apply sensitivity labels and endorse analytics items Maintain a data analytics solution

A confidential semantic model has the correct sensitivity label, but a newly hired analyst still receives a permission error. The owner assumes the label should grant access. What is the correct response?

Concept tested:

Question 3 of 10

Objective Write DAX with variables, iterators, table filters, windowing, and information functions Implement and manage semantic models

A measure computes a filtered balance twice and must display a warning when the result is blank, without changing source rows. Which DAX approach fits?

Concept tested:

Question 4 of 10

Objective Perform impact analysis and manage reusable semantic assets through XMLA Maintain a data analytics solution

A lakehouse owner plans to remove a table used by unknown downstream notebooks, semantic models, and reports. What should the owner do before the change?

Concept tested:

Question 5 of 10

Objective Configure Git integration, PBIP projects, and deployment pipelines Maintain a data analytics solution

Two developers must review changes to a Power BI report and semantic model in Git, resolve text-file merge conflicts, and open the project again in Power BI Desktop. Which artifact format should they use?

Concept tested:

Question 6 of 10

Objective Implement workspace, item, row, column, object, and file access controls Maintain a data analytics solution

Legal hires a temporary reviewer for a single litigation dashboard. The surrounding workspace also contains confidential notebooks, pipelines, and unrelated models, while the dashboard's data permissions are already satisfied. What access should the owner provide?

Concept tested:

Question 7 of 10

Objective Choose storage modes and implement star-schema relationships Implement and manage semantic models

Sales relates to Date through active OrderDate and inactive DeliveryDate. A delivery measure needs DeliveryDate, while another shared fact already receives Date filters through its standard path. What should the modeler do?

Concept tested:

Question 8 of 10

Objective Resolve duplicates, nulls, data types, joins, and filters Prepare data

A supposed invoice key begins failing after whitespace cleanup, and a conversion step introduces errors in several amount columns. Before changing the transformation, which capability should reveal error rates and compare distinct with unique values?

Concept tested:

Question 9 of 10

Objective Implement calculation groups, dynamic format strings, and field parameters Implement and manage semantic models

A Margin measure contains the wrong business formula. A developer proposes changing its dynamic format string so the displayed number looks correct. What should happen?

Concept tested:

Question 10 of 10

Objective Implement star schemas, denormalization, and aggregations Prepare data

A source CustomerNumber can change, yet analysts must preserve customer history and filter a Sales fact through a simple predictable model. Which design is appropriate?

Concept tested:

Unlock the full DP-600 bank.

Get the full bank, Exam Mode, Practice Mode, question sets, random tests, readiness tracking, saved box scores, and review tools for this exam.

The PDF versions keep questions first and move the answer review, explanations, and distractor notes to the back of the file.

200 verified exam-style questions Every choice explained Exam Mode and Practice Mode Question sets and random tests Readiness score and trends Previous test box scores

You've answered 0/10 questions in today's set.

Locked: 190 more questions in the full bank.

Locked: exam simulation mode, practice mode, readiness tracking, and saved review history.

Checkout stays on this page, so you can keep practicing, unlock the full bank, and start Exam Mode or Practice Mode when you are ready.

Cheat Sheets

Question 1 A warehouse query joins a five-year Sales table to Product and then returns only yesterday's online orders. The result is correct but unnecessarily expensive. Which revision is most likely to reduce data processed without changing the answer?

Answer choices

A. Apply the required date and channel filters before the expensive join when supported by the source and optimizer
B. Remove the date filter so the optimizer has more rows
C. Move the filtering into a DAX display format
D. Aggregate every year before applying any predicate

Correct answer

Apply the required date and channel filters before the expensive join when supported by the source and optimizer

Early selective filtering can reduce rows entering later joins and aggregations when pushdown is supported. The predicates must still preserve every row required by the intended result.

Wrong-answer review

B. Remove the date filter so the optimizer has more rows: Removing a required predicate increases work and changes the requested result.
C. Move the filtering into a DAX display format: Display formatting cannot constrain rows processed by the warehouse query.
D. Aggregate every year before applying any predicate: Aggregating unnecessary history first performs more work than the scenario requires.

Extra learning features

Why this matters

Unnecessary data processing in a warehouse query significantly increases costs, impacting operational efficiency and potentially leading to higher infrastructure expenses. Optimizing query performance is crucial for maintaining cost-effective data analytics, ensuring resources are used responsibly. This directly affects the business's bottom line. (37 words)

Objective/domain: Prepare data

Question 2 A confidential semantic model has the correct sensitivity label, but a newly hired analyst still receives a permission error. The owner assumes the label should grant access. What is the correct response?

A. Remove the label because labeled items cannot be shared
B. Certify the model because certification automatically grants read access
C. Keep the classification and separately grant the analyst the required item and data permissions
D. Give every analyst workspace Admin to make labels effective

Keep the classification and separately grant the analyst the required item and data permissions

Objective/domain: Maintain a data analytics solution

Source: OneLake catalog item details

Question 3 A measure computes a filtered balance twice and must display a warning when the result is blank, without changing source rows. Which DAX approach fits?

A. Use ISBLANK to replace the source column
B. Create a relationship keyed by the warning text
C. Store the filtered result in a variable and use an information function to branch on its state
D. Convert the balance to formatted text before evaluation

Store the filtered result in a variable and use an information function to branch on its state

Objective/domain: Implement and manage semantic models

Source: DAX variables best practices

Question 4 A lakehouse owner plans to remove a table used by unknown downstream notebooks, semantic models, and reports. What should the owner do before the change?

A. Perform impact analysis to identify dependent content and coordinate remediation
B. Increase capacity
C. Apply a different visual theme
D. Change the sensitivity label only

Perform impact analysis to identify dependent content and coordinate remediation

Source: Semantic model connectivity with the XMLA endpoint

Question 5 Two developers must review changes to a Power BI report and semantic model in Git, resolve text-file merge conflicts, and open the project again in Power BI Desktop. Which artifact format should they use?

A. A screenshot collection committed to Git
B. A Power BI Desktop project (PBIP)
C. A PBIDS connection file only
D. An exported CSV for every model table

A Power BI Desktop project (PBIP)

Source: Lakehouse Git integration and deployment pipelines

Question 6 Legal hires a temporary reviewer for a single litigation dashboard. The surrounding workspace also contains confidential notebooks, pipelines, and unrelated models, while the dashboard's data permissions are already satisfied. What access should the owner provide?

A. Item-level sharing for the report
B. Workspace Contributor
C. Workspace Member
D. Tenant administrator

Item-level sharing for the report

Source: Create and manage OneLake security roles

Question 7 Sales relates to Date through active OrderDate and inactive DeliveryDate. A delivery measure needs DeliveryDate, while another shared fact already receives Date filters through its standard path. What should the modeler do?

A. Enable bidirectional filtering on every Date relationship
B. Make both Sales date relationships active
C. Keep the normal paths single-direction and use USERELATIONSHIP for DeliveryDate only in the delivery measure
D. Delete OrderDate from Sales

Keep the normal paths single-direction and use USERELATIONSHIP for DeliveryDate only in the delivery measure

Source: Understand model relationships in Power BI Desktop

Question 8 A supposed invoice key begins failing after whitespace cleanup, and a conversion step introduces errors in several amount columns. Before changing the transformation, which capability should reveal error rates and compare distinct with unique values?

A. Deployment pipeline history
B. A field parameter
C. Power Query column quality, distribution, and profile views
D. A workspace role

Power Query column quality, distribution, and profile views

Source: Power Query data profiling tools

Question 9 A Margin measure contains the wrong business formula. A developer proposes changing its dynamic format string so the displayed number looks correct. What should happen?

A. Correct the DAX business calculation and use formatting only for presentation
B. Encode the missing arithmetic in a currency symbol
C. Convert the result to text with FORMAT and leave the formula wrong
D. Apply a sensitivity label to alter the value

Correct the DAX business calculation and use formatting only for presentation

Source: Create dynamic format strings for measures

Question 10 A source CustomerNumber can change, yet analysts must preserve customer history and filter a Sales fact through a simple predictable model. Which design is appropriate?

A. Relate Sales to the current CustomerNumber and overwrite history
B. Normalize every customer attribute into a separate chain of dimensions
C. Store all customer attributes repeatedly on every Sales row
D. Create a denormalized Customer dimension with warehouse surrogate keys and relate Sales to the correct historical key

Create a denormalized Customer dimension with warehouse surrogate keys and relate Sales to the correct historical key

Source: Understand star schema and the importance for Power BI

DP-600 Practice Test

Unlock the full DP-600 bank

Practice with explanations that teach.

What you get with free practice

A warehouse query joins a five-year Sales table to Product and then returns only yesterday's online orders. The result is correct but unnecessarily expensive. Which revision is most likely to reduce data processed without changing the answer?

A confidential semantic model has the correct sensitivity label, but a newly hired analyst still receives a permission error. The owner assumes the label should grant access. What is the correct response?

A measure computes a filtered balance twice and must display a warning when the result is blank, without changing source rows. Which DAX approach fits?

A lakehouse owner plans to remove a table used by unknown downstream notebooks, semantic models, and reports. What should the owner do before the change?

Two developers must review changes to a Power BI report and semantic model in Git, resolve text-file merge conflicts, and open the project again in Power BI Desktop. Which artifact format should they use?

Legal hires a temporary reviewer for a single litigation dashboard. The surrounding workspace also contains confidential notebooks, pipelines, and unrelated models, while the dashboard's data permissions are already satisfied. What access should the owner provide?

Sales relates to Date through active OrderDate and inactive DeliveryDate. A delivery measure needs DeliveryDate, while another shared fact already receives Date filters through its standard path. What should the modeler do?

A supposed invoice key begins failing after whitespace cleanup, and a conversion step introduces errors in several amount columns. Before changing the transformation, which capability should reveal error rates and compare distinct with unique values?

A Margin measure contains the wrong business formula. A developer proposes changing its dynamic format string so the displayed number looks correct. What should happen?

A source CustomerNumber can change, yet analysts must preserve customer history and filter a Sales fact through a simple predictable model. Which design is appropriate?

You are viewing today’s free 10. Unlock 190 more questions.

Build your practice session

Set your target once.

Customize your session

Unlock the full DP-600 bank.

7-day score keeper

Keep today’s practice moving

Answer choices

Correct answer

Wrong-answer review

Extra learning features

Why this matters

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

Answer choices

Correct answer

How are DP-600 questions generated?

How are explanations sourced?

What score do I get?

Why use this site?