Implement and manage semantic models
Domain 3 of DP-600 accounts for 25-30% of the exam. EarnYourCert has 105 original questions for this domain, all with explanations: 64 multiple choice, 16 yes/no and 25 completion or ordering items, like the real exam.
Domain 3 sample questions
8 questions from our 105-question bank for this domain. Try to answer before revealing the solution.
1. Which DAX construct stores an intermediate value for reuse and improves readability?
- DEFINE only
- TOPN
- VAR ... RETURN
- EVALUATE
Show answer
Correct answer: C. Variables are evaluated once and reused.
2. Which DAX function returns a table filtered by a condition and is often used as a CALCULATE filter argument?
- FORMAT
- FILTER
- LEN
- VALUE
Show answer
Correct answer: B. FILTER returns rows meeting a predicate.
3. Which feature lets report users switch which measure or column a visual displays by using a slicer?
- Calculation groups
- Git integration
- Field parameters
- Mirroring
Show answer
Correct answer: C. Field parameters create a selectable list of fields.
4. Which feature should you enable when a semantic model might grow beyond the default size limit and needs efficient large-model handling?
- Large semantic model storage format
- Template apps with incremental refresh
- Dynamic data masking
- Sensitivity labels on large tables
Show answer
Correct answer: A. The large format lets models grow up to the capacity limits.
5. A report author wants to extend an existing certified semantic model with extra tables from an Excel file without changing the original. Which approach fits?
- Build a composite model on top of the semantic model (DirectQuery to the model)
- Apply a sensitivity label
- Copy the model into a PBIX and delete the original
- Create a Git branch
Show answer
Correct answer: A. Composite models can extend shared semantic models.
6. Why is it recommended to disable Auto date/time for large models that already have a date table?
- It enables Direct Lake
- It avoids hidden date tables that add size
- It encrypts the model
- It creates relationships automatically
Show answer
Correct answer: B. Auto date/time creates a hidden table per date column.
7. Which Direct Lake behavior setting forces queries to fail instead of falling back to DirectQuery?
- DirectLakeOnly
- DirectQueryOnly
- ImportOnly
- Automatic
Show answer
Correct answer: A. DirectLakeOnly disables fallback.
8. Which Delta table characteristic helps Direct Lake performance by compressing and sorting data for fast reads?
- Endorsement
- V-Order
- Dynamic data masking
- Git branching
Show answer
Correct answer: B. V-Order optimizes Parquet files for fast reads.