A business intelligence engineer needs to reduce the size of a data model for reporting purposes. The data set contains more than one million rows, and the table has a date-time column named Date…

The correct answer is D. Split the Date column into two columns--time and date. Separate date and time, if bound together. If any of your tables have columns that combine date and time, make sure that you separate them into distinct columns before importing them into Power BI. This approach will increase compression abilities.

Data Concepts and Environments

Question

A business intelligence engineer needs to reduce the size of a data model for reporting purposes. The data set contains more than one million rows, and the table has a date-time column named Date. Which of the following should the analyst do to complete this task?

Options

AChange the data type of the Date column to text.
BTrim the date.
CRound the hour of the Date column to the start of the hour.
DSplit the Date column into two columns--time and date.

How the community answered

(27 responses)

A
11% (3)
B
4% (1)
C
7% (2)
D
78% (21)

Explanation

Separate date and time, if bound together. If any of your tables have columns that combine date and time, make sure that you separate them into distinct columns before importing them into Power BI. This approach will increase compression abilities.

Topics

#Data Modeling#Data Optimization#Data Types#Storage Efficiency

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice