PrepAway - Latest Free Exam Questions & Answers

You need to implement a degenerate dimension

You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure SQL Database data warehouse.
You need to implement a degenerate dimension.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the fact table as the data source for the dimension.

B.
Create snowflake dimension tables based on normalized views of the fact table in the data source.

C.
Create a junk dimension table based on the fact table in the data source.

D.
Add a surrogate key to the fact table and use it as the degenerate dimension key.


Leave a Reply