Question 79 of 388
Single answerYou plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format.What should you do in the model before you create the relationship?
AChange the Data Type of ActivityStart to Date.
BCreate a measure in ActivityLog that uses the FORMAT DAX function.
CChange the Data Type of DateID to Date.
✓DCreate a calculated column in ActivityLog that uses the FORMAT DAX function.
✓
Correct Answer: D
Create a calculated column in ActivityLog that uses the FORMAT DAX function.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.