Free Preparation Discussions
MENU
Microsoft DP-600 Exam Questions
- Topic 1: Maintain a data analytics solution: This section of the exam measures the skills of administrators and covers tasks related to enforcing security and managing the Power BI environment. It involves setting up access controls at both workspace and item levels, ensuring appropriate permissions for users and groups. Row-level, column-level, object-level, and file-level access controls are also included, alongside the application of sensitivity labels to classify data securely. This section also tests the ability to endorse Power BI items for organizational use and oversee the complete development lifecycle of analytics assets by configuring version control, managing Power BI Desktop projects, setting up deployment pipelines, assessing downstream impacts from various data assets, and handling semantic model deployments using XMLA endpoint. Reusable asset management is also a part of this domain.
- Topic 2: Prepare data: This section of the exam measures the skills of engineers and covers essential data preparation tasks. It includes establishing data connections and discovering sources through tools like the OneLake data hub and the real-time hub. Candidates must demonstrate knowledge of selecting the appropriate storage type—lakehouse, warehouse, or eventhouse—depending on the use case. It also includes implementing OneLake integrations with Eventhouse and semantic models. The transformation part involves creating views, stored procedures, and functions, as well as enriching, merging, denormalizing, and aggregating data. Engineers are also expected to handle data quality issues like duplicates, missing values, and nulls, along with converting data types and filtering. Furthermore, querying and analyzing data using tools like SQL, KQL, and the Visual Query Editor is tested in this domain.
- Topic 3: Implement and manage semantic models: This section of the exam measures the skills of architects and focuses on designing and optimizing semantic models to support enterprise-scale analytics. It evaluates understanding of storage modes and implementing star schemas and complex relationships, such as bridge tables and many-to-many joins. Architects must write DAX-based calculations using variables, iterators, and filtering techniques. The use of calculation groups, dynamic format strings, and field parameters is included. The section also includes configuring large semantic models and designing composite models. For optimization, candidates are expected to improve report visual and DAX performance, configure Direct Lake behaviors, and implement incremental refresh strategies effectively.
Free Microsoft DP-600 Exam Actual Questions
Note: Premium Questions for DP-600 were last updated On Feb. 26, 2026 (see below)
You have a Microsoft Power Bl project that contains a semantic model. You plan to use Azure DevOps for version control.
You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?
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 Power Query step to identify the maximum values for the numeric columns.
Which function should you include in the step?
The Table.Max function should be used in a Power Query step to identify the maximum values for the numeric columns. This function is designed to calculate the maximum value across each column in a table, which suits the requirement of finding maximum values for numeric columns. Reference = For detailed information on Power Query functions, including Table.Max, please refer to Power Query M function reference.
You have a Microsoft Power BI semantic model that contains a measure named TotalSalesAmount. TotalSalesAmount returns a sales revenue amount that is translated into a selected currency.
You need to ensure that the value returned by TotalSalesAmount is formatted to use the correct currency symbol.
What should you include in the solution?
Scenario:
Semantic model contains a measure: TotalSalesAmount.
This measure returns sales revenue translated into a selected currency.
Requirement: Format the result using the correct currency symbol dynamically.
Analysis:
Dynamic format string in DAX is specifically designed for applying formats (like currency symbols) dynamically based on slicers or calculation context.
WINDOW function used for windowing calculations, not formatting.
Linguistic schema used for Q&A natural language, not for formatting.
Field parameter used to swap fields/measures dynamically, not for formatting.
Correct Answer: A. A dynamic format string
You have a Fabric tenant that contains a warehouse.
You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).
You need to recommend which columns to add to the table. The columns must NOT already exist in the source.
Which three types of columns should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
For a Type 2 slowly changing dimension (SCD), you typically need to add the following types of columns that do not exist in the source system:
An effective start date and time (E): This column records the date and time from which the data in the row is effective.
An effective end date and time (A): This column indicates until when the data in the row was effective. It allows you to keep historical records for changes over time.
A surrogate key (C): A surrogate key is a unique identifier for each row in a table, which is necessary for Type 2 SCDs to differentiate between historical and current records.
What should you recommend using to ingest the customer data into the data store in the AnatyticsPOC workspace?
For ingesting customer data into the data store in the AnalyticsPOC workspace, a dataflow (D) should be recommended. Dataflows are designed within the Power BI service to ingest, cleanse, transform, and load data into the Power BI environment. They allow for the low-code ingestion and transformation of data as needed by Litware's technical requirements. Reference = You can learn more about dataflows and their use in Power BI environments in Microsoft's Power BI documentation.
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Kayleigh
7 days agoWilda
15 days agoHarley
22 days agoKimbery
29 days agoJosefa
1 month agoJade
1 month agoNathalie
2 months agoDustin
2 months agoDaren
2 months agoJennifer
2 months agoRaymon
3 months agoRoslyn
3 months agoCiara
3 months agoAileen
3 months agoMollie
4 months agoLinsey
4 months agoLayla
4 months agoDick
4 months agoBette
5 months agoTerrilyn
5 months agoStefania
5 months agoBeckie
5 months agoKendra
6 months agoRashida
6 months agoJudy
8 months agoDeane
9 months agoCarlee
10 months agoJacquelyne
12 months agoAndra
1 year agoLeandro
1 year agoGermaine
1 year agoAdela
1 year agoMerrilee
1 year agoReita
1 year agoTyisha
1 year agoLaquanda
1 year agoLeonor
1 year agoLeota
1 year agoLachelle
1 year agoFletcher
1 year agoMarla
1 year agoKrystal
1 year agoJacki
2 years agoValene
2 years agoLauran
2 years agoKaron
2 years agoMarge
2 years agoTamekia
2 years agoMary
2 years agoStephaine
2 years agoLing
2 years agoJonelle
2 years agoKerry
2 years agoNobuko
2 years agoalison
2 years agoAlex
2 years agopereexe
2 years agokorey
2 years agoAsuncion
2 years agoAlexas
2 years ago