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 12, 2026, 3:38 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 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:

Source:Semantic model connectivity with the XMLA endpoint

Question 2 of 10

Objective Design composite models and large semantic models Implement and manage semantic models

A composite model combines imported HR data with DirectQuery payroll from another country. Before release, the team has tested calculations but not credentials, privacy separation, cross-source cardinality, or query latency. What is required?

Concept tested:

Question 3 of 10

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

A release manager wants a Fabric change to advance only after reconciliation in a validation workspace, with production receiving the same reviewed artifact rather than a manually recreated copy. Which lifecycle feature should organize those environment gates?

Concept tested:

Question 4 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 5 of 10

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

A steward must confirm an item's owner, workspace, certification, sensitivity, lineage, and current permission paths before approving reuse. Where should the steward inspect it?

Concept tested:

Question 6 of 10

Objective Choose Fabric data stores and implement OneLake integration Prepare data

One workload needs ACID T-SQL transactions over a governed relational schema; another needs KQL over streaming telemetry; a third needs Spark over mixed files. How should the architect choose Fabric stores?

Concept tested:

Question 7 of 10

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

A Customer dimension has one row per CustomerKey and filters many Sales rows. Customer should be cached, Sales should query an external database at runtime, and an eligible OneLake Targets table should load into VertiPaq without a full import. Which design fits?

Concept tested:

Question 8 of 10

Objective Create connections, discover data, and choose ingestion or access Prepare data

A Fabric connection successfully authenticates to an ERP source, but a pipeline still lacks required currency transformations and destination users have excessive access. What should the engineer configure next?

Concept tested:

Question 9 of 10

Objective Implement star schemas, denormalization, and aggregations Prepare data

A single fact table stores invoice lines, invoice headers, and monthly customer snapshots. Revenue doubles when users group by product. What is the fundamental correction?

Concept tested:

Question 10 of 10

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

A group-managed application identity must read selected tables through a OneLake security role. Which membership can the administrator use?

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 lakehouse owner plans to remove a table used by unknown downstream notebooks, semantic models, and reports. What should the owner do before the change?

Answer choices

A. Perform impact analysis to identify dependent content and coordinate remediation, for the stated implementation and support requirements.
B. Increase capacity, under the organization’s defined implementation and exception-management process.
C. Apply a different visual theme, for the described technical objective and its associated operational control requirements.
D. Change the sensitivity label only, within the documented operational, security, ownership, and validation requirements.

Correct answer

Perform impact analysis to identify dependent content and coordinate remediation, for the stated implementation and support requirements.

Impact analysis identifies downstream dependencies that a shared lakehouse, warehouse, dataflow, or semantic model change can affect.

Wrong-answer review

B. Increase capacity, under the organization’s defined implementation and exception-management process.: Capacity changes do not inventory dependent analytical content.
C. Apply a different visual theme, for the described technical objective and its associated operational control requirements.: Report styling has no relationship to data dependencies.
D. Change the sensitivity label only, within the documented operational, security, ownership, and validation requirements.: Classification changes cannot identify or repair broken downstream references.

Extra learning features

Why this matters

Failure to perform impact analysis before removing a shared lakehouse table can result in critical downstream analytical content becoming unavailable, disrupting reporting and potentially leading to inaccurate business insights. This directly impacts the reliability of data-driven decision-making.

Objective/domain: Maintain a data analytics solution

Question 2 A composite model combines imported HR data with DirectQuery payroll from another country. Before release, the team has tested calculations but not credentials, privacy separation, cross-source cardinality, or query latency. What is required?

A. Release because one model automatically harmonizes every source, under the organization’s defined implementation and exception-management process.
B. Validate only report colors, for the described technical objective and its associated operational control requirements, within the described operational context.
C. Convert all columns to text, for the described technical objective and its associated operational control requirements, for the specified implementation requirement.
D. Validate each source credential and privacy boundary, confirm relationship cardinality, and test cross-source query performance, for the stated requirement.

Validate each source credential and privacy boundary, confirm relationship cardinality, and test cross-source query performance, for the stated requirement.

Objective/domain: Implement and manage semantic models

Source: Use composite models in Power BI Desktop

Question 3 A release manager wants a Fabric change to advance only after reconciliation in a validation workspace, with production receiving the same reviewed artifact rather than a manually recreated copy. Which lifecycle feature should organize those environment gates?

A. A deployment pipeline with the three workspaces assigned to stages, for the specified implementation requirement.
B. A OneLake shortcut from production to development, within the defined security and accountability boundaries.
C. A dynamic format string for each environment, under the stated decision criteria.
D. An XMLA query that copies workspace roles, for the required outcome.

A deployment pipeline with the three workspaces assigned to stages, for the specified implementation requirement.

Source: Lakehouse Git integration and deployment pipelines

Question 4 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, for the described technical objective and its associated operational control requirements, for the described technical objective.
B. Create a relationship keyed by the warning text, for the described technical objective and its associated operational control requirements, for the specified implementation requirement.
C. Store the filtered result in a variable and use an information function to branch on its state, for the required business outcome.
D. Convert the balance to formatted text before evaluation, for the stated implement and manage semantic models requirement.

Store the filtered result in a variable and use an information function to branch on its state, for the required business outcome.

Source: DAX variables best practices

Question 5 A steward must confirm an item's owner, workspace, certification, sensitivity, lineage, and current permission paths before approving reuse. Where should the steward inspect it?

A. The OneLake catalog item-details page, within the described operational context.
B. A KQL queryset, for the stated requirement.
C. The PBIP report folder, for the specified implementation requirement.
D. A calculation group, within the described operational context.

The OneLake catalog item-details page, within the described operational context.

Source: OneLake catalog item details

Question 6 One workload needs ACID T-SQL transactions over a governed relational schema; another needs KQL over streaming telemetry; a third needs Spark over mixed files. How should the architect choose Fabric stores?

A. Place every workload in the newest Fabric item type, under the organization’s defined implementation and exception-management process.
B. Match Warehouse, Eventhouse, and Lakehouse respectively to the transaction, query-language, data-shape, and latency requirements, for the stated requirement.
C. Use a semantic model as the storage engine for all three, for the described technical objective and its associated operational control requirements, for consideration.
D. Choose whichever store the first developer already knows, for the described technical objective and its associated operational control requirements, for this task.

Match Warehouse, Eventhouse, and Lakehouse respectively to the transaction, query-language, data-shape, and latency requirements, for the stated requirement.

Objective/domain: Prepare data

Source: Data storage options in Microsoft Fabric

Question 7 A Customer dimension has one row per CustomerKey and filters many Sales rows. Customer should be cached, Sales should query an external database at runtime, and an eligible OneLake Targets table should load into VertiPaq without a full import. Which design fits?

A. Put Sales on the one side and Import all tables, as the primary implementation for the described business requirement.
B. Relate Customer one-to-many to Sales; use Import for Customer, DirectQuery for Sales, and Direct Lake for Targets
C. Use KQL storage mode for Customer, for the described technical objective and its associated operational control requirements, under the proposed approach.
D. Make every relationship many-to-many and use PBIP as the table mode, as the primary implementation for the described business requirement.

Relate Customer one-to-many to Sales; use Import for Customer, DirectQuery for Sales, and Direct Lake for Targets

Source: Understand model relationships in Power BI Desktop

Question 8 A Fabric connection successfully authenticates to an ERP source, but a pipeline still lacks required currency transformations and destination users have excessive access. What should the engineer configure next?

A. Implement the transformation logic and destination authorization separately because the connection only supplies source access details, as the recommended response to this scenario.
B. Rename the connection so it generates business rules, for the described technical objective and its associated operational control requirements, within this design.
C. Create a second connection and assume it revokes destination permissions, under the stated technical, operational, and governance constraints.
D. Certify the connection to perform row-level security, for the described technical objective and its associated operational control requirements, as presented.

Implement the transformation logic and destination authorization separately because the connection only supplies source access details, as the recommended response to this scenario.

Source: OneLake catalog overview

Question 9 A single fact table stores invoice lines, invoice headers, and monthly customer snapshots. Revenue doubles when users group by product. What is the fundamental correction?

A. Enable bidirectional filtering everywhere, for the described technical objective and its associated operational control requirements, within the described context.
B. Mark Revenue as text, for the described technical objective and its associated operational control requirements, as configured.
C. Hide the monthly rows from one report, within the documented operational, security, ownership, and validation requirements.
D. Separate observations into fact tables with declared compatible grains and define measures against the appropriate grain, for evaluation.

Separate observations into fact tables with declared compatible grains and define measures against the appropriate grain, for evaluation.

Source: Understand star schema and the importance for Power BI

Question 10 A group-managed application identity must read selected tables through a OneLake security role. Which membership can the administrator use?

A. Only individual human accounts, for the described technical objective and its associated operational control requirements, for this requirement.
B. A Microsoft Entra group or service principal assigned to the scoped role, under organization-wide implementation-governance requirements.
C. A calculation item, as the proposed maintain a data analytics solution approach.
D. A certified endorsement, as the recommended implementation across the complete governed service lifecycle.

A Microsoft Entra group or service principal assigned to the scoped role, under organization-wide implementation-governance requirements.

Source: Create and manage OneLake security roles

DP-600 Practice Test

Unlock the full DP-600 bank

Practice with explanations that teach.

What you get with free practice

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 composite model combines imported HR data with DirectQuery payroll from another country. Before release, the team has tested calculations but not credentials, privacy separation, cross-source cardinality, or query latency. What is required?

A release manager wants a Fabric change to advance only after reconciliation in a validation workspace, with production receiving the same reviewed artifact rather than a manually recreated copy. Which lifecycle feature should organize those environment gates?

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 steward must confirm an item's owner, workspace, certification, sensitivity, lineage, and current permission paths before approving reuse. Where should the steward inspect it?

One workload needs ACID T-SQL transactions over a governed relational schema; another needs KQL over streaming telemetry; a third needs Spark over mixed files. How should the architect choose Fabric stores?

A Customer dimension has one row per CustomerKey and filters many Sales rows. Customer should be cached, Sales should query an external database at runtime, and an eligible OneLake Targets table should load into VertiPaq without a full import. Which design fits?

A Fabric connection successfully authenticates to an ERP source, but a pipeline still lacks required currency transformations and destination users have excessive access. What should the engineer configure next?

A single fact table stores invoice lines, invoice headers, and monthly customer snapshots. Revenue doubles when users group by product. What is the fundamental correction?

A group-managed application identity must read selected tables through a OneLake security role. Which membership can the administrator use?

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?