Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
B or D, as long as we have to chose only one answer, it would be D then
If you delete DATE table and Date Key, then you eliminate a lot of redundant data
D. Remove MovementDate column as the data details are already included in the DateKey column therefore MovementDate information is redundant. By defaultI expect DateKey to be Don't Summarize but anyway, in the question it's not mentioned anything about Summarization. Removing relationship would make impossible to set any analysis based on date (you could split DateKey column and get from there day, month and year but this would increase data model size) Changing UnitCost to Integer (this category doesn't exist in PBI but Whole Number!!!) would result in lost of information as values in this column are all decimals