BenchMark Quizzes by MDFT Pro

Optimize Data Model By Converting Date/Time Columns

You have a large dataset at MDFT Pro with a Date/Time/Timezone column. The academy wants to create day-by-day views and optimize performance for reporting and analysis.

What should you do to ensure the data model is efficient and supports your reporting needs?

Choose the correct answer from the options below.

Explanations for each answer:

Convert the column to Date. is correct. Using the Date data type reduces model size and optimizes performance when only the date is needed.
Convert the column to Text. is incorrect. Text is not efficient for date operations and increases storage requirements.
Convert the column to Date/Time. is incorrect. Date/Time stores unnecessary time information, increasing model size.
Convert the column to Duration. is incorrect. Duration is for time intervals, not for storing dates.

Learn more about optimizing data types in Power BI:

Power BI Data Types

Exam Preparation Quiz

Optimize Data Model By Converting Date/Time Columns