Exam PL-300 topic 2 question 28 discussion

D is right

looks like a typo - D is good as explained below

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

This requires you to notice that MovementDate and DateKey have the same date. I agree that it doesnt tell you they are ALWAYS the same though.

If D is correct - how can we guarrantee that 'Movementdate' always has the same info as DateKey? i.e. having 5 identical rows does not tell us all rows are the same...

We can remove the movementdate 'cause the same information in kept in the datekey column

D is right one

correct answer

D is correct. We can remove it since it does not provide new information. We can have these information from DateKey column.

For the Guys and Girls, At this page, you will no longer find any free questions from Examtopics. However, if you're hesitant about purchasing Contributor Access, don't hesitate any longer; buy it. It costs only $50 and provides a significant boost to your CV and career. I recently passed with a score of 917 out of 1000. Save yourself time by learning and memorizing all these questions, as 85% of the 50 exam questions were identical to those provided here. Cheers and good luck!

D is correct.

Yeah. There's a typo indeed. As per the explanation the response should be D.

D is correct

You can also remove rows where nothing went in or out

As per the given explanation option D is crearly the answer. We are achieving required functionality without losing information as both the rows contain same information

Dates can be removed from fact tables in a data warehouse or analytical database if you replace them with date keys that are linked to a separate date dimension table. Thus, answer D is correct.