Dimension_city table used in the visualization has which two columns?

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

Dimension_city table used in the visualization has which two columns?

Explanation:
Dimension City is meant to describe place-level attributes used to slice and group data. The two columns in this table are the city name and the sales territory it belongs to. This pairing lets the visualization analyze and filter results by both specific cities and the business region (territory) they reside in, providing meaningful geographic and organizational context for sales metrics. A date attribute belongs in a time dimension, and revenue is a metric from the fact table, not a descriptive attribute. While country could be present in some models, the structure here uses Sales Territory as the primary geographic grouping, so City and Sales Territory are the two attributes captured.

Dimension City is meant to describe place-level attributes used to slice and group data. The two columns in this table are the city name and the sales territory it belongs to. This pairing lets the visualization analyze and filter results by both specific cities and the business region (territory) they reside in, providing meaningful geographic and organizational context for sales metrics. A date attribute belongs in a time dimension, and revenue is a metric from the fact table, not a descriptive attribute. While country could be present in some models, the structure here uses Sales Territory as the primary geographic grouping, so City and Sales Territory are the two attributes captured.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy