Hotspot Question You use Veripaq Analyzer to analyze a model. The relationships tab contains the results shown in the following exhibit. Use the drop-down menus to select the answer choice that…

Question

Explanation

This question tests your ability to interpret the Veripaq Analyzer Relationships tab to identify data model relationship properties - including cardinality, cross-filter direction, referential integrity, and blank row injection - and draw conclusions about model behavior or data quality.

Approach. In Veripaq Analyzer's Relationships tab, each row describes a relationship between two tables. Key columns to read are: Cardinality (e.g., 1:M, M:M, 1:1), Cross Filter Direction (Single vs. Both), Active (whether the relationship is used by default), and Referential Integrity (whether missing foreign-key values force the engine to inject a blank row into the 'one' side). A blank row being added means there are foreign-key values in the 'many' table with no matching row in the lookup/dimension table - this is a data quality problem. Many-to-many (M:M) cardinality or bidirectional cross-filtering are often flagged as performance or ambiguity risks. The correct approach is to match each drop-down statement to the relationship property visible in the exhibit (e.g., 'The relationship between Sales and Date is [One-to-Many]' or 'The model contains [a blank row / no blank row] in the Product table').

Concept tested. Interpreting Veripaq Analyzer Relationships tab output - specifically reading cardinality, cross-filter direction, active/inactive status, and referential integrity (blank row injection) to assess data model correctness and performance characteristics in Power BI / Analysis Services tabular models.

Reference. Microsoft Learn - Use Veripaq Analyzer to analyze a data model (PL-300 / DP-600 exam objectives); DAX Studio documentation on Veripaq Analyzer relationship metadata

No community discussion yet for this question.