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?

The correct answer is D. Split the Date column into two columns, one that contains only the time and another that contains. We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. 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…

Submitted by yuriko_h· Apr 18, 2026Model the data

Question

Options

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

How the community answered

(36 responses)

A
6% (2)
C
3% (1)
D
92% (33)

Explanation

We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. 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 https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

Topics

#Data Model Optimization#Data Size Reduction#DateTime Data Types#Column Splitting

Community Discussion

No community discussion yet for this question.

Full PL-300 Practice