EnglishDeutschFrançaisEspañolPortuguês

Microsoft · DP-600 · Associate

Implementing Analytics Solutions Using Microsoft Fabric (DP-600) — Practice Questions and Mock Exam

The DP-600 certification validates expertise in implementing analytics solutions using Microsoft Fabric.

Practice for freeTry a practice question first
Try a practice question firstPractice for free
Start practicing DP-600 freeBuy DP-600 access for $29.99
50Questions per Pass-IT mock exam
100minPass-IT mock exam time limit

Official DP-600 exam: 700 out of 1000 points to pass.

Checked against Microsoft · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a DP-600 sample question and read the explanation with its source. Right here, with no sign-up.

Prepare data2 / 5

You are implementing a medallion architecture in a Fabric lakehouse. Raw data lands in the Bronze layer as CSV files. You need to clean, deduplicate, and convert the data to Delta tables in the Silver layer using PySpark. Which Fabric item should you use?

AlexFull explanation from Alex

For Bronze-to-Silver transformations requiring PySpark, a Spark notebook is the correct choice. Notebooks provide full programmatic control for cleaning, deduplication, type casting, schema enforcement, and writing Delta tables. Why not the others? A SQL stored procedure operates in the Warehouse, not the Lakehouse. Dataflow Gen2 is low-code and doesn't natively support PySpark. A KQL queryset is for Real-Time Intelligence, not lakehouse ETL. In Fabric's medallion architecture, notebooks are the primary tool for complex transformations between layers. Ref: learn.microsoft.com/fabric/onelake/onelake-medallion-lakehouse-architecture

Sourcelearn.microsoft.com

Implement and manage semantic models3 / 5

In a semantic model, you are viewing the Model view in Power BI Desktop. You need to identify where to configure the relationship cardinality between two tables. Identify the correct interface element.

AlexFull explanation from Alex

In Power BI Desktop's Model view, relationships between tables appear as visual lines connecting the related columns. To configure relationship cardinality (1:1, 1:many, many:many) and cross-filter direction, double-click the relationship line to open the properties dialog. This shows cardinality, filter direction (single/both), and active/inactive status. You can create relationships by dragging a column from one table to another. The Manage Relationships dialog is an alternative interface. Ref: learn.microsoft.com/power-bi/transform-model/desktop-relationships-understand

Sourcelearn.microsoft.com

Prepare data4 / 5

In the Fabric portal, identify where you access the Real-Time hub to discover streaming data sources and event streams.

AlexFull explanation from Alex

The Real-Time hub is a centralized discovery surface in the Fabric portal, accessible from the left navigation pane. It lets you browse available streaming data sources, create event streams, and connect to external sources like Azure Event Hubs, Kafka, and custom applications. It is part of Fabric's Real-Time Intelligence workload alongside Eventhouse, KQL Database, and Eventstreams. The hub eliminates the need to manually search for streaming sources across the organization. Ref: learn.microsoft.com/fabric/real-time-intelligence/real-time-hub-overview

Sourcelearn.microsoft.com

Prepare data5 / 5

A Fabric data pipeline fails with "Insufficient permissions" when a Notebook activity tries to write to a lakehouse in a different workspace. What should you verify?

AlexFull explanation from Alex

Fabric workspace roles control write access to lakehouses, warehouses, notebooks, and pipelines. Viewer is read-only for these operations. Notebook activities can be configured with an authentication method such as Fabric workspace identity. In cross-workspace scenarios, grant the execution/authentication identity the necessary target workspace role; Git integration, Spark pool selection, and capacity admin permissions do not replace workspace data permissions.

Sourcelearn.microsoft.com

How to prepare for DP-600 with Pass-IT.

Currently 304 practice questions for DP-600, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Meet Alex →

Conversation preview · DP-600

Dynamic row security

  1. You

    How can the model show each manager only their own region’s rows?

  2. Alex · AI tutor

    Compare RegionManager with USERPRINCIPALNAME() in the row-level security filter.

    Read the Microsoft documentation ↗
  3. You

    What must the RegionManager column contain?

  4. Alex · AI tutor

    The manager’s user principal name, so the comparison matches the signed-in identity.

    Read the Microsoft documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

DP-600 · Question excerpt

Dynamic row security

View the full question

You need to implement dynamic row-level security (RLS) on a Fabric semantic model so that each sales manager sees only rows where the Sales[RegionManager] column stores that manager's user principal name. Which DAX Boolean filter expression should you use in the RLS role definition?

Understand the correct answer.

[RegionManager] = USERPRINCIPALNAME()

The filter compares the row’s manager identity with USERPRINCIPALNAME().

Read the Microsoft documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your DP-600 mock exam

Questions
50
Minutes
100

Illustration of an exam session

  1. Start
  2. Answer questions
  3. Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for DP-600.

Exam topics, relevant practice and sources you can check.

Maintaining analytics assets25–30% of the exam83 QuestionsPass-IT questions

This section covers access, governance and controlled changes to Fabric analytics assets.

  • Set access at workspace, item, row, column, object and file level, and use sensitivity labels and endorsements to identify protected or trusted content.
  • Manage workspace version control, Power BI Desktop projects (.pbip) and deployment pipelines.
  • Assess the downstream impact of changes to lakehouses, warehouses, dataflows and semantic models, and deploy or manage models through the XMLA endpoint.
  • Create and update reusable Power BI templates (.pbit), data source files (.pbids) and shared semantic models.
Official Microsoft objectives
Preparing and querying data45–50% of the exam120 QuestionsPass-IT questions

Understand how Fabric finds, connects, reshapes and queries data for analysis.

  • Create connections, discover data in OneLake catalog and Real-Time hub, choose data stores, and ingest or access data, including OneLake integration for Eventhouse and semantic models.
  • Build views, functions and stored procedures; enrich data with columns or tables and organize lakehouses or warehouses using a star schema and denormalization.
  • Merge, join, aggregate and filter data, convert column types, and resolve duplicates, missing values and nulls.
  • Select, filter and aggregate data with Visual Query Editor, SQL, Kusto Query Language (KQL) and Data Analysis Expressions (DAX).
Official Microsoft objectives
Building and optimizing semantic models25–30% of the exam101 QuestionsPass-IT questions

This section covers model structure, calculations and performance at enterprise scale.

  • Choose storage modes and build star schemas, composite models, bridge tables and many-to-many relationships; configure large semantic model storage when appropriate.
  • Write DAX calculations using variables, iterators, table filters, window functions and information functions.
  • Implement calculation groups, dynamic format strings and field parameters to make calculations and presentation reusable.
  • Improve query, report-visual and DAX performance, and implement incremental refresh for semantic models.
  • Configure Direct Lake fallback and refresh behavior, and choose between Direct Lake on OneLake and on the SQL analytics endpoint.
Official Microsoft objectives
Question formats you can practice
Multiple Choice
Select one answer.
Multiple Response
Select multiple applicable answers.
True / False
Decide whether statements are true or false.
Drag & Drop
Match items to the appropriate targets.
Ordering
Put steps in the correct order.
Dropdown
Choose the appropriate entry from a dropdown list.

These are Pass-IT practice formats. Check the Microsoft certification page for the official exam information.

The ranges describe the weighting of exam topics. See Official Microsoft objectives for the current exam objectives.

Frequently asked questions

Your preparation

How much study time should I plan for DP-600?

For planning, Pass-IT estimates roughly 30–75 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Microsoft or a promise that you will be exam-ready within that time.

Do you need experience with Fabric before DP-600?

Microsoft sets no prerequisite, so nothing blocks the booking. The catalog budget is around 50 hours, and the preparation weighting means most of it goes on hands-on work in a Fabric workspace. Power BI experience transfers to the semantic model section but not to the rest.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Microsoft for the languages available for the official exam.

How long does my DP-600 access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the DP-600 exam

Where can I take the DP-600 exam?

Pearson VUE online proctored or at authorized testing centers worldwide.

How long is the Implementing Analytics Solutions Using Microsoft Fabric exam?

The DP-600 exam has 50 questions and a 100-minute time limit.

DP-600 or DP-700 — which Fabric exam?

DP-600 is the analytics engineering exam: preparing data and building semantic models that people report on. DP-700 is the data engineering one, weighted evenly across implementing, ingesting and optimizing an analytics solution. If your output is a model other people query, take DP-600; if it is a pipeline, take DP-700.

How often does DP-600 need renewing?

Annually, through the free renewal assessment on Microsoft Learn. It opens six months before the expiry date and has to be passed before it. Fabric changes fast enough that the yearly check is more than a formality.

Your preparation for DP-600

$29.99one-time

12 months of access for DP-600 · No automatic renewal

Buy DP-600 access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days.

Full guarantee terms →

Related certifications

Administering Information Security in Microsoft 365Administering Microsoft Azure SQL SolutionsAdministering Windows ServerCollaboration Communications Systems EngineerAll Microsoft certifications →