Question 210
A date dimension needs one unique record for every calendar day even when there are no sales. Which step should the analyst take?
Explanation
Correct Answer
Unique complete date keys support date relationships and time intelligence. It meets the scenario requirement of complete calendar dimension key.
Incorrect Answers
Descriptive labels are not guaranteed to identify one product. It would instead address stable product model relationship key, not the stated complete calendar dimension key.
Slowly changing dimension versions require distinct keys to retain time-valid attributes. It may be appropriate for history-safe customer dimension key, whereas the current need is complete calendar dimension key.
Both columns determine the fact grain; dropping one creates collisions. This solves unique purchase-line identifier, not the requested complete calendar dimension key.






Microsoft Power BI Data Analyst (PL-300) Practice Tests