Question 96 of 388
Single answerYou 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.
✓
Correct Answer: D
Split the Date column into two columns, one that contains only the time and another that contains only the date.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.