Model the data Questions

For a one-to-many relationship with single cross-filter direction, filters normally propagate from which side?

For eligible DirectQuery tables in the same source group, what changes when Assume referential integrity is enabled?

A report author wants to use time intelligence quick measures with a custom date table. What preparation is required?

What happens if refresh loads duplicate values into the column on the one side of a one-to-many relationship?

In DAX query view, what does a DEFINE MEASURE statement create before you update the model?

A sales model must support simultaneous filtering by Order Date and Ship Date without relying on many duplicate measures. Which design does Microsoft ...

In a star schema, what is the primary role of a fact table?

How does CALCULATE behave when you add a filter on a column that is already in the filter context and you do not use KEEPFILTERS?

A measure should compute Sales for the current selection but ignore filters from the Promotion table. Which DAX construct fits?

An analyst is troubleshooting an ambiguous filter path because of two relationship paths between fact and dimension. Microsoft's recommended fix is:

Which feature enables grouping multiple measures together with a single attribute (e.g., YTD, MTD) applied to many measures via slicer selection?

Which type of relationship cardinality should typically be set between a fact table and a dimension table on the dimension's primary key?

An analyst wants to create a calculated table that lists distinct dates between 1/1/2020 and 12/31/2030. Which DAX function generates this?

Which DAX measure returns total Sales for the same period last year, given a marked date table?

Which DAX function would a measure use to retrieve a value from the one-side of an existing relationship?