This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What cardinality type should you set to create a relationship between a dimension table to a fact table?
Many-to-many
One-to-many
One-to-one
Which statement about hierarchies is true?
A hierarchy orders column values.
At most, only one hierarchy can be added to a model table.
Hierarchy levels must be based on columns from a single model table.
What type of object can you add to a model to summarize data?
Hierarchy
Measure
Parameter
You must answer all questions before checking your work.
Was this page helpful?