Microsoft DP-600: Implementing Analytics Solutions Using Microsoft Fabric

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Implement and manage semantic models

   A model needs a measure that calculates total sales only for the current filter context. Which DAX pattern is appropriate?

   1. AA hard-coded literal number typed directly into the measure formula, not a sum
   2. BA calculated column that stores a precomputed total for each row in the table
   3. CA text string built by concatenating the sales values with comma separators and spaces
   4. DA measure using SUM over the sales column, evaluated in filter context
   Show answer and explanationHide answer

   Correct answer: D

   Measures are evaluated in the filter context of each visual, so a SUM measure responds to slicers and filters. Calculated columns store row values, hard-coded numbers do not change, and text concatenation is not a total.

2. Question 2Prepare and serve data

   A data analyst wants to connect a semantic model directly to lakehouse tables with live results and no import copy. Which storage mode fits best?

   1. AManual CSV export
   2. BImport only
   3. CDirectLake
   4. DPrinted snapshot
   Show answer and explanationHide answer

   Correct answer: C

   DirectLake reads Delta tables in OneLake directly for near-real-time results without an import copy. Import mode copies data into the model, and printed or manual exports are not live.

3. Question 3Maintain a data analytics solution

   A team wants to move a Fabric workspace's items from development to test to production with approvals between stages. Which feature provides this?

   1. ACopying items by hand
   2. BA printed release note
   3. CA shared spreadsheet of item names
   4. DDeployment pipelines
   Show answer and explanationHide answer

   Correct answer: D

   Deployment pipelines promote items through stages with controlled deployment and optional approvals. Manual copies, spreadsheets, and printed notes are error-prone and do not enforce stage control.

4. Question 4Explore and analyze data

   A business user wants to explore a semantic model by asking natural-language questions about its data. Which feature supports this?

   1. AA static image of the model
   2. BAn email to the data team with a request
   3. CQ&A or Copilot on the semantic model
   4. DA printed data dictionary
   Show answer and explanationHide answer

   Correct answer: C

   Natural-language features such as Q&A or Copilot let users explore semantic models conversationally. A printed dictionary, static image, and emailed request are not interactive exploration.

5. Question 5Implement and manage semantic models

   A calculation must be stored per row in the fact table and used for filtering. Which kind of DAX object should be used?

   1. AA report theme
   2. BA measure
   3. CA calculated column
   4. DA visual-level filter
   Show answer and explanationHide answer

   Correct answer: C

   Calculated columns are stored per row in the table and can be used for filtering and slicing. Measures are aggregated at query time, visual filters are display-level, and themes are presentation settings.