DP-600 mock exam: 25 free practice questions

Q1 / 25

What happens when City is added to both SELECT and GROUP BY in the quarterly sales example?

1. AThe result shows a quarterly sales total for each city.
2. BThe result ranks every city by list price within each year.
3. CThe result returns ten arbitrary sales rows for each quarter.
4. DThe result becomes one sales total for each product category.

Q2 / 25

What join behavior does Assume referential integrity request across a relationship?

1. ALEFT OUTER joins instead of INNER joins
2. BFULL OUTER joins instead of one-to-many relationships
3. CCROSS joins instead of inactive relationship paths
4. DINNER joins instead of LEFT OUTER joins

Q3 / 25

A Sales Order column repeats an order identifier on multiple line items. A measure must return the number of business orders, not the number of lines. Which function fits?

1. ADISTINCTCOUNT over the Sales Order column
2. BSUM over the Sales Order column
3. CCOUNTROWS over the Sales table
4. DCOUNT over the Sales Order column

Q4 / 25

What can a user with the Viewer workspace role do by default?

1. AShare listed workspace content with underlying OneLake data access
2. BView listed workspace content without underlying OneLake data access
3. CCreate new workspace content with underlying SQL data access
4. DModify listed workspace content without underlying SQL data access

Q5 / 25

Which pair of Power Query operations is documented for handling null values?

1. AFilter null-bearing rows or replace nulls with defaults
2. BMerge null-bearing rows or append nulls as columns
3. CPivot null-bearing rows or rename nulls as errors
4. DGroup null-bearing rows or convert nulls into queries

Q6 / 25

What is the primary purpose of a calculation group?

1. AReplace one source table with a calculated table
2. BChoose one field from a group for a visual
3. CApply one calculation pattern across multiple measures
4. DDefine one numeric range for a report slicer

Q7 / 25

Which clause filters groups after aggregate values have been calculated?

1. ASELECT alias
2. BINNER JOIN
3. CWHERE
4. DHAVING

Q8 / 25

Which Git providers can a Fabric workspace connect to through Git integration?

1. AFabric REST or XMLA endpoints
2. BPower BI Desktop or local project folders
3. CAzure DevOps or GitHub repositories
4. DDevelopment or Test workspaces

Q9 / 25

A lakehouse must combine a table owned by another Fabric team with local tables. The source must remain in place and stay synchronized. What should you create?

1. AA mirrored copy authenticated by an external cloud connection
2. BAn internal OneLake shortcut to the source table
3. CA report connected directly to the source semantic model
4. DUpload a copy into the target

Q10 / 25

How do the first and subsequent service refreshes differ under an incremental policy?

1. AThe first removes retained history; later runs disable partitioning
2. BThe first loads configured history; later runs update the recent window
3. CThe first updates Desktop samples; later runs ignore service partitions
4. DThe first loads only recent data; later runs reload all history

Q11 / 25

What makes one stored procedure reusable for different monthly refresh periods?

1. AA complete table clone created for each execution
2. BA separate view definition created for each month
3. CYear and month parameters supplied at execution
4. DA fixed period embedded in every procedure statement

Q12 / 25

Which tool is designed for interactive DAX query testing against a published semantic model?

1. ASemPy list_columns()
2. BDAX Studio
3. CTabular Editor BPA
4. DALM Toolkit

Q13 / 25

Which destination pairing is supported when a Dataflow Gen2 query must produce a Fabric table?

1. ADelta table in a lakehouse or schema-aware table in a warehouse
2. BStored procedure in a lakehouse or M function in a warehouse
3. CRead-only view in a lakehouse or temporary result in a warehouse
4. DApplied step in a lakehouse or query preview in a warehouse

Q14 / 25

When should the OneLake tables path be preferred over the SQL analytics endpoint?

1. AWhen cross-database queries must combine several sources
2. BWhen row-level security is defined in the SQL layer
3. CWhen straightforward data resides in one Fabric data store
4. DWhen SQL views are required as semantic-model sources

Q15 / 25

What does the Certified endorsement indicate?

1. AA write user marked an item ready for one team's reuse
2. BA designated user marked core data as the single source of truth
3. CAn authorized reviewer verified organization-level quality standards
4. DA Purview administrator assigned a sensitivity classification

Q16 / 25

Rows with a null AccountID cannot be used downstream and should not reach the destination. Which remediation meets the requirement?

1. AFilter the query to remove rows with a null AccountID
2. BExport the query before inspecting the AccountID field
3. CMark the query as preview-only and keep every row
4. DReplace null AccountID values with an arbitrary default

Q17 / 25

A model uses Delta tables in OneLake. Reports need current updates without scheduled refresh, while retaining fast interactive queries. Which storage mode should you choose first?

1. ADirect Lake, because it reads the Delta tables without an Import refresh
2. BImport, because its cached copy changes whenever the Delta tables change
3. CDirectQuery, because it always provides the fastest in-memory query performance
4. DComposite, because every Fabric-native model requires mixed table storage modes

Q18 / 25

A shared semantic model column will be renamed, and several reports may consume it. What should the team do first?

1. ARun impact analysis and review downstream consumers
2. BUse lineage view only after reports have broken
3. CRename the column and wait for refresh failures
4. DPromote the model and review its commit authors

Q19 / 25

A warehouse fact load receives customer IDs from staging, but the fact table must reference warehouse-generated customer keys. Which loading pattern is appropriate?

1. ACopy the source customer IDs into every descriptive dimension attribute
2. BJoin staging to the customer dimension and insert the matched surrogate keys
3. CInsert customer names into the measure columns and omit all keys
4. DAggregate staging first and discard the customer relationship before loading

Q20 / 25

Which storage mode is the default for semantic models created in Microsoft Fabric?

1. AComposite
2. BDirectQuery
3. CImport
4. DDirect Lake

Q21 / 25

Which workspace role can create and modify all content without adding sharing or permission-management capabilities?

1. AMember
2. BViewer workspace role
3. CAdmin
4. DContributor

Q22 / 25

A warehouse dashboard repeatedly reads monthly sales by region. Recomputing the summary from daily transactions is expensive, and the result should be stored. Which implementation fits?

1. AUse a view so the daily aggregation is recalculated when queried
2. BNormalize region attributes into additional tables before querying
3. CUse CTAS to materialize a monthly regional aggregate table
4. DUse a window function so each daily transaction row remains

Q23 / 25

How are fact and dimension tables divided in a semantic star schema?

1. AFacts hold refresh schedules; dimensions hold query translations
2. BFacts hold descriptive context; dimensions hold measurable events
3. CFacts hold storage modes; dimensions hold source connections
4. DFacts hold measurable events; dimensions hold descriptive context

Q24 / 25

How does the pipeline comparison identify content that differs between stages?

1. AIt marks the item with a synced status
2. BIt marks the item with a green icon
3. CIt marks the item with an orange icon
4. DIt marks the item with a branch name

Q25 / 25

A semantic model contains Import tables, DirectQuery tables, measures, and calculation groups. What does OneLake integration export?

1. AThe Import-mode tables as Delta tables
2. BThe complete model in Direct Lake mode
3. CThe DirectQuery tables with their measures
4. DThe measures and calculation-group tables