Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Your Product dimension uses a natural composite key: ProductCode (text) and CountryCode (2-letter ISO). The Sales fact table stores both columns. In Power BI Desktop you attempt to create a relationship but discover you can select only one column. Without altering the source systems, how can you create a single active one-to-many relationship between Product and Sales?

  • Enable bidirectional cross-filtering between ProductCode and CountryCode so Power BI treats the two columns as a composite key automatically.

  • Generate a surrogate integer key in the Sales fact table by hashing ProductCode and CountryCode and relate it to the original columns in the Product table.

  • Add a calculated column to both tables that concatenates ProductCode and CountryCode, then create a one-to-many relationship on that new column.

  • Create two separate relationships, one on ProductCode and one on CountryCode, and set both to active.

Microsoft Power BI Data Analyst
Prepare the data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot