In the schema with dimGeography and FactSales, which field is used to join the two tables?

Prepare for the DP-600 Fabric Analytics Engineer Exam. Study with flashcards and multiple choice questions, each offering hints and detailed explanations. Enhance your chances of success on the exam!

Multiple Choice

In the schema with dimGeography and FactSales, which field is used to join the two tables?

Explanation:
Joining a dimension to a fact uses the dimension’s surrogate key. In dimGeography, GeographyKey acts as that unique surrogate identifier, and the fact table FactSales stores GeographyKey as a foreign key to connect each sale to its geography. This keeps the join stable and independent from changing business keys. The other fields—GeographyID, LocationKey, and RegionKey—are typically descriptive or natural keys and are not used for the join. So the field that links the two tables is GeographyKey.

Joining a dimension to a fact uses the dimension’s surrogate key. In dimGeography, GeographyKey acts as that unique surrogate identifier, and the fact table FactSales stores GeographyKey as a foreign key to connect each sale to its geography. This keeps the join stable and independent from changing business keys. The other fields—GeographyID, LocationKey, and RegionKey—are typically descriptive or natural keys and are not used for the join. So the field that links the two tables is GeographyKey.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy