Microsoft Exam DA-100 Topic 16 Question 20 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 20
Topic #: 16

[All DA-100 Questions]

You have a large dataset that contains more than 1 million rows. The table has a datetime column named

Date.

You need to reduce the size of the data model.

What should you do?

ARound the hour of the Date column to startOfHour.

BChange the data type of the Date column to Text.

CTrim the Date column.

DSplit the Date column into two columns, one that contains only the time and another that contains only the date.

Show Suggested Answer

Suggested Answer: D

Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.

https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

by Shenika at May 06, 2022, 09:52 PM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!