Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) eBook

Download the DP-600 Practice Exam EBook:https://cloudcertificationstore.com/b/FzZcW

Download the Study Guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Practice Exam Questions - Preview 20 out of 400+ Questions

Question 1

You have a Fabric tenant. You plan to create a data pipeline named Pipeline1. Pipeline1 will include two activities that execute in sequence. You need to ensure that a failure of the first activity will not block the second activity. Which conditional path should you configure between the first activity and the second activity?

A. Upon Failure

B. Upon Completion

C. Upon Skip

D. Upon Success

✅ Correct answer: B. Upon Completion

📌 Configuring the Upon Completion dependency ensures that the downstream activity runs regardless of whether the preceding activity succeeds, fails, or is skipped. This behavior is required when failures must not block pipeline execution. It is commonly used in cleanup, logging, or compensating activities in Fabric and Azure Data Factory pipelines.

Incorrect answers:

❌ A. Upon Failure – This triggers the second activity only if the first fails, which does not satisfy the requirement to always continue.

❌ C. Upon Skip – This runs only when the prior activity is skipped, not when it fails or succeeds.

❌ D. Upon Success – This blocks execution when the first activity fails, directly violating the requirement.

Question 2

You have a Microsoft Power BI semantic model. You need to identify surrogate key columns in the model that have the Summarize By property set to a value other than None. The solution must minimize effort. What should you use?

A. DAX Formatter in DAX Studio

B. Model explorer in Power BI Desktop

C. Model view in Power BI Desktop

D. Best Practice Analyzer in Tabular Editor

✅ Correct answer: D. Best Practice Analyzer in Tabular Editor

📌 Tabular Editor’s Best Practice Analyzer automatically detects modeling anti-patterns such as surrogate keys that are incorrectly summarized. It provides immediate, rule-based diagnostics across the entire model, minimizing manual inspection effort.

Incorrect answers:

❌ A. DAX Formatter in DAX Studio – This formats DAX code and does not analyze column properties.

❌ B. Model explorer in Power BI Desktop – This requires manual inspection and does not automatically flag issues.

❌ C. Model view in Power BI Desktop – While useful for relationships, it does not efficiently surface summarize settings violations.

Question 3

Several times per day, the performance of all warehouse queries degrades. You suspect that Fabric is throttling the compute used by the warehouse. What should you use to identify whether throttling is occurring?

A. Capacity settings

B. Monitoring hub

C. Dynamic management views (DMVs)

D. Microsoft Fabric Capacity Metrics app

✅ Correct answer: D. Microsoft Fabric Capacity Metrics app

📌 The Fabric Capacity Metrics app provides detailed insights into capacity usage, throttling events, and overages across workloads. It is the primary tool for diagnosing performance degradation caused by capacity contention.

Incorrect answers:

❌ A. Capacity settings – These configure limits but do not provide historical throttling diagnostics.

❌ B. Monitoring hub – Useful for activity tracking, but insufficient for detailed capacity throttling analysis.

❌ C. Dynamic management views (DMVs) – DMVs expose query-level details but not capacity-level throttling trends.

Question 4

You have a Fabric tenant that contains a warehouse. A report that usually renders in two minutes has been running for 45 minutes. You need to identify what is preventing the report query from completing. Which DMV should you use?

A. sys.dm_exec_requests

B. sys.dm_exec_sessions

C. sys.dm_exec_connections

D. sys.dm_pdw_exec_requests

✅ Correct answer: A. sys.dm_exec_requests

📌 The sys.dm_exec_requests DMV shows currently executing queries, wait types, blocking sessions, and execution states, making it ideal for identifying long-running or blocked queries.

Incorrect answers:

❌ B. sys.dm_exec_sessions – Provides session-level metadata but not execution blockers.

❌ C. sys.dm_exec_connections – Focuses on connection details, not query execution status.

❌ D. sys.dm_pdw_exec_requests – Used in dedicated SQL pools, not Fabric warehouses.

Question 5

You have a Fabric workspace that contains a DirectQuery semantic model querying a data source with 500 million rows. You need to reduce query execution time for visuals across all report pages. Which two features can you use?

A. User-defined aggregations

B. Automatic aggregations

C. Query caching

D. OneLake integration

✅ Correct answers: B and C

📌 Automatic aggregations reduce query load by precomputing summary tables, while query caching reuses previously executed results. Together, they significantly reduce execution time in DirectQuery scenarios.

Incorrect answers:

❌ A. User-defined aggregations – Require manual configuration and are less scalable than automatic aggregations.

❌ D. OneLake integration – Improves data access but does not directly optimize DirectQuery execution paths.

Question 6

You have a Fabric tenant that contains a lakehouse named Lakehouse1. You need to prevent new tables added to Lakehouse1 from being automatically added to the default semantic model. What should you configure?

A. SQL analytics endpoint settings

B. Semantic model settings

C. Workspace settings

D. Lakehouse settings

✅ Correct answer: D. Lakehouse settings

📌 Lakehouse settings control automatic table discovery and inclusion in the default semantic model. Disabling this behavior prevents unintended schema changes from propagating.

Incorrect answers:

❌ A. SQL analytics endpoint settings – These control SQL access, not semantic model population.

❌ B. Semantic model settings – Do not govern automatic table additions.

❌ C. Workspace settings – Apply at a broader scope and lack this granular control.

Question 7

You are creating an Azure Data Factory pipeline. A stored procedure returns the number of active customers and their average sales for the current month. The returned values must be available to downstream activities. Which activity should you use?

A. Switch

B. Copy data

C. Append variable

D. Lookup

✅ Correct answer: D. Lookup

📌 The Lookup activity executes a query or stored procedure and exposes the returned values for use in subsequent pipeline activities via dynamic content.

Incorrect answers:

❌ A. Switch – Controls conditional logic but does not execute stored procedures.

❌ B. Copy data – Moves data but does not expose scalar outputs.

❌ C. Append variable – Requires values to already be available.

Question 8

You are exploring a new semantic model from Power Query and need to view column quality, distribution, and profiling details. Which three Data view options should you enable?

A. Show column value distribution

B. Enable details pane

C. Enable column profile

D. Show column quality details

E. Show column profile in details pane

✅ Correct answers: A, C, and D

📌 These three options collectively surface data quality metrics, value distribution, and profiling statistics directly in Power Query’s data preview.

Incorrect answers:

❌ B. Enable details pane – Provides metadata but not profiling visuals by itself.

❌ E. Show column profile in details pane – Redundant when column profiling is already enabled.

Question 9

You have a Fabric warehouse with a table containing one row per SalesOrderID and ProductID. You need to calculate the proportion of each product’s quantity relative to the total quantity of the sales order. Which T-SQL construct should you use?

A. GROUP BY with SUM

B. Window function with OVER(PARTITION BY)

C. CROSS APPLY

D. Recursive CTE

✅ Correct answer: B. Window function with OVER(PARTITION BY)

📌 Window functions allow per-row calculations relative to grouped totals without collapsing result sets, making them ideal for proportional calculations.

Incorrect answers:

❌ A. GROUP BY with SUM – Aggregates rows and loses per-product detail.

❌ C. CROSS APPLY – Not suited for analytic aggregation patterns.

❌ D. Recursive CTE – Unnecessary and inefficient for this use case.

Question 10

You need to recommend a Fabric capacity SKU for the Research division. The capacity must support per-minute billing and dedicated on-demand usage. Which SKU should you recommend?

A. A

B. EM

C. P

D. F

✅ Correct answer: D. F

📌 F-series Fabric capacities support dedicated, on-demand usage with per-minute billing, aligning precisely with the Research division requirements.

Incorrect answers:

❌ A. A – Not a valid Fabric capacity SKU.

❌ B. EM – Embedded capacity lacks full Fabric workload support.

❌ C. P – Power BI Premium capacity uses fixed monthly pricing.

Question 11

You have a Fabric tenant that contains a warehouse. You need to determine which queries are consuming the most CPU during execution. Which DMV should you query?

A. sys.dm_exec_connections

B. sys.dm_exec_sessions

C. sys.dm_exec_requests

D. sys.dm_pdw_exec_requests

✅ Correct answer: C. sys.dm_exec_requests

📌 This DMV exposes active queries along with CPU time, elapsed time, waits, and execution status, making it the primary source for identifying resource-intensive queries in Fabric warehouses.

Incorrect answers:

❌ A. sys.dm_exec_connections – Shows connection metadata, not CPU usage.

❌ B. sys.dm_exec_sessions – Focuses on sessions, not individual query resource consumption.

❌ D. sys.dm_pdw_exec_requests – Used for dedicated SQL pools, not Fabric warehouses.

Question 12

You have a Fabric workspace that contains a lakehouse. You want to allow users to query lakehouse tables using T-SQL without granting notebook access. What should you enable?

A. Direct Lake mode

B. SQL analytics endpoint

C. Semantic model auto-generation

D. Delta table optimization

✅ Correct answer: B. SQL analytics endpoint

📌 The SQL analytics endpoint enables T-SQL access to lakehouse tables while maintaining security boundaries and avoiding notebook permissions.

Incorrect answers:

❌ A. Direct Lake mode – Applies to semantic models, not SQL access.

❌ C. Semantic model auto-generation – Creates models but does not enable SQL querying.

❌ D. Delta table optimization – Improves performance, not access.

Question 13

You need to ensure that a Fabric workspace supports Git-based version control with branching. Where should you configure this?

A. Tenant settings

B. Capacity settings

C. Workspace settings

D. Semantic model settings

✅ Correct answer: C. Workspace settings

📌 Git integration for Fabric items is configured at the workspace level, allowing repository binding and branching workflows.

Incorrect answers:

❌ A. Tenant settings – Control feature availability, not repository binding.

❌ B. Capacity settings – Govern compute allocation.

❌ D. Semantic model settings – Do not support version control configuration.

Question 14

You have a Dataflow Gen2 that loads data into a Fabric warehouse. You want to validate data quality by identifying nulls, errors, and distinct values. Which Power Query feature should you use?

A. Table.Schema

B. Column distribution

C. Data profiling

D. Query diagnostics

✅ Correct answer: C. Data profiling

📌 Data profiling surfaces column-level quality indicators including valid values, errors, nulls, and distribution statistics directly in Power Query.

Incorrect answers:

❌ A. Table.Schema – Shows metadata only.

❌ B. Column distribution – Partial view without quality metrics.

❌ D. Query diagnostics – Focuses on performance, not data quality.

Question 15

You are designing a Fabric analytics solution where business users frequently create reports but should not be allowed to change relationships, measures, or refresh settings in the semantic model. What permission should you assign to these users?

A. Read

B. Build

C. Write

D. Admin

✅ Correct Answer: B. Build

📌 Build permission allows users to create new reports based on an existing semantic model without modifying its structure, relationships, or measures. This enables governed self-service analytics while protecting shared business logic. It is the recommended permission for analysts who consume and extend models through reporting. This balance between flexibility and control is a common DP-600 scenario.

❌ Why not the other options?

A. Read: Read-only access prevents users from creating new reports, limiting self-service capabilities.

C. Write: Write permission allows modifying the semantic model, which violates the requirement.

D. Admin: Admin grants full control over all workspace assets and is overly permissive.

Question 16

You have a Fabric pipeline with multiple activities. You want an activity to execute only if the previous activity fails. Which dependency condition should you use?

A. Upon Completion

B. Upon Success

C. Upon Failure

D. Upon Skip

✅ Correct answer: C. Upon Failure

📌 The Upon Failure condition ensures that downstream activities run only when the preceding activity fails, commonly used for error handling or alerts.

Incorrect answers:

❌ A. Upon Completion – Runs regardless of outcome.

❌ B. Upon Success – Executes only on success.

❌ D. Upon Skip – Executes only when skipped.

Question 17

You are modeling a star schema in Fabric. Which type of key should be used as the primary key in dimension tables?

A. Natural key

B. Composite key

C. Foreign key

D. Surrogate key

✅ Correct answer: D. Surrogate key

📌 Surrogate keys are stable, system-generated identifiers that improve performance and avoid issues caused by changing natural keys.

Incorrect answers:

❌ A. Natural key – Can change and cause maintenance issues.

❌ B. Composite key – Increases complexity and reduces performance.

❌ C. Foreign key – Used in fact tables, not dimensions.

Question 18

You need to calculate a running total in a Fabric warehouse using T-SQL. Which feature should you use?

A. GROUP BY

B. Window functions

C. CROSS JOIN

D. Recursive CTE

✅ Correct answer: B. Window functions

📌 Window functions such as SUM() OVER (ORDER BY ...) allow running totals without collapsing result sets.

Incorrect answers:

❌ A. GROUP BY – Aggregates rows and loses row-level detail.

❌ C. CROSS JOIN – Produces Cartesian products.

❌ D. Recursive CTE – Overly complex and inefficient.

Question 19

You have a semantic model with row-level security (RLS). You want to verify how data appears for a specific user. What should you do?

A. Test as role

B. Test as role and user

C. Publish and share the report

D. Filter visuals manually

✅ Correct answer: B. Test as role and user

📌 Testing as both role and user validates role logic and user membership, ensuring accurate RLS behavior.

Incorrect answers:

❌ A. Test as role – Does not validate user assignment.

❌ C. Publish and share – Does not help validate logic.

❌ D. Filter visuals manually – Bypasses RLS logic.

Question 20

You have a Fabric warehouse with frequent concurrent queries. Which feature helps prevent repeated execution of identical queries?

A. Incremental refresh

B. Query caching

C. Partitioning

D. Indexing

✅ Correct answer: B. Query caching

📌 Query caching reuses previously executed query results, reducing load and improving performance in high-concurrency scenarios.

Incorrect answers:

❌ A. Incremental refresh – Optimizes refresh, not query execution.

❌ C. Partitioning – Improves scan efficiency but not reuse.

❌ D. Indexing – Improves lookup speed but does not cache results.

.

.

. 

(more questions here)

Question 406

You want sensitivity labels applied to propagate to reports that consume a semantic model. What must be true?

A. Reports must be in the same workspace

B. Label inheritance must be supported and enabled

C. Users must be workspace admins

D. Reports must use DirectQuery

✅ Correct Answer: B. Label inheritance must be supported and enabled

📌 Sensitivity label inheritance ensures that downstream artifacts carry the same classification. This supports consistent governance and compliance. Without inheritance, labels remain isolated. Understanding label propagation is important for DP-600.



❌ Why not the other options?

A. Same workspace: Inheritance is not workspace-dependent.

C. Workspace admins: User role does not affect inheritance.

D. DirectQuery: Storage mode does not affect labels.

(... and that was the last preview question)

Get the Full Version at https://cloudcertificationstore.com/b/FzZcW

#DP600 #MicrosoftFabric #FabricAnalyticsEngineer #DataAnalytics #AnalyticsEngineering #OneLake #Lakehouse #FabricWarehouse #PowerBI #SemanticModel #DAX #DirectLake #EnterpriseAnalytics #ModernDataPlatform #DataGovernance #AnalyticsArchitecture #FabricPipelines #DataEngineering #BusinessIntelligence #MicrosoftAnalytics #AzureData #BIEngineering #AnalyticsSolutions #DataModeling #SQLAnalytics #DataAtScale #CapacityPlanning #AnalyticsPerformance #ExamPrep #PracticeExam #CertificationTraining #MicrosoftCertification #AzureCertifications #DataCareers #AnalyticsCareers #SelfPacedLearning #DigitalDownload #EbookDownload #CloudCertificationStore #GetItDoneCertified #PassTheFirstTime #StudySmartNotHard #DataProfessional #AnalyticsProfessional #DataUpskilling #ExamReadiness #FinalReviewChecklist #AnalyticsStrategy #EnterpriseBI #FabricSkills