Fabric Analytics Engineer Semantic Model Design Quiz

1. Which cardinality type represents one record in the dimension table matching multiple records in the fact table?

One-to-one

Many-to-many

One-to-many

Many-to-one

2. In semantic modeling, conformed dimensions are shared across multiple fact tables to ensure consistency. True or false?

True

False

Submit

4. What is the primary difference between active and inactive relationships in Fabric semantic models?

Active relationships are used in filters; inactive relationships require explicit reference

Active relationships store data; inactive relationships do not

Inactive relationships are faster than active relationships

Active relationships support many-to-many cardinality only

5. A grain in a fact table defines the lowest level of detail captured. True or false?

True

False

Submit

7. Which approach improves semantic model performance by storing pre-calculated results?

Denormalization

Materialization

Normalization

Segmentation

Submit

9. What is the primary benefit of using row-level security (RLS) in a semantic model?

Increase query performance

Restrict data visibility based on user roles

Reduce storage requirements

Simplify DAX expressions

10. In semantic modeling, a bridge table is used to resolve many-to-many relationships. True or false?

True

False

11. What is the primary purpose of a star schema in semantic modeling?

Normalize data to reduce redundancy

Organize data into fact and dimension tables for analytical queries

Encrypt sensitive business data

Compress large datasets for faster storage

Submit

13. What does a slowly changing dimension (SCD) track in a semantic model?

Changes in dimension attributes over time

Fact table growth rates

Query execution delays

Relationship cardinality changes

14. Implicit measures in a semantic model are automatically generated when you drag numeric fields to a visualization. True or false?

True

False

15. Which optimization technique reduces query time by pre-calculating aggregated values?

Indexing

Aggregation tables

Data compression

Column reordering

Submit

17. What is a surrogate key in dimension table design?

A composite key combining multiple columns

An artificially generated unique identifier independent of business data

A key that references the source system directly

A slowly changing dimension attribute

18. A many-to-one relationship in a semantic model connects a fact table to a dimension table. True or false?

True

False

19. Which DAX function calculates the sum of values in a column filtered by context?

SUMIF

SUM

CALCULATE

AGGREGATE

20. In a semantic model, what type of table typically contains transactional measures like sales revenue?

Dimension table

Fact table

Bridge table

Lookup table

Fabric Analytics Engineer Semantic Model Design Quiz

1. Which cardinality type represents one record in the dimension table matching multiple records in the fact table?

2.

What first name or nickname would you like us to use?

2. In semantic modeling, conformed dimensions are shared across multiple fact tables to ensure consistency. True or false?

3. The ______ view in Power BI displays relationships between tables visually.

4. What is the primary difference between active and inactive relationships in Fabric semantic models?

5. A grain in a fact table defines the lowest level of detail captured. True or false?

6. In DAX, the ______ function filters data based on specified conditions and recalculates measures.

7. Which approach improves semantic model performance by storing pre-calculated results?

8. The ______ property determines the default aggregation behavior for numeric columns in visualizations.

9. What is the primary benefit of using row-level security (RLS) in a semantic model?

10. In semantic modeling, a bridge table is used to resolve many-to-many relationships. True or false?

11. What is the primary purpose of a star schema in semantic modeling?

12. The ______ function in DAX returns the distinct count of values in a column.

13. What does a slowly changing dimension (SCD) track in a semantic model?

14. Implicit measures in a semantic model are automatically generated when you drag numeric fields to a visualization. True or false?

15. Which optimization technique reduces query time by pre-calculating aggregated values?

16. In Fabric, the ______ view allows you to define relationships and configure table properties.

17. What is a surrogate key in dimension table design?

18. A many-to-one relationship in a semantic model connects a fact table to a dimension table. True or false?

19. Which DAX function calculates the sum of values in a column filtered by context?

20. In a semantic model, what type of table typically contains transactional measures like sales revenue?