What should you do?

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?
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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.