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 without losing access to any data. What should you do?
A.
Round the hour of the Date column to startOfHour.
B.
Change the data type of the Date column to Text.
C.
Trim the Date column.
D.
Split the Date column into two columns, one that contains only the time and another that contains only the date.
This section is not available anymore. Please use the main Exam Page.DA-100 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
DeathCaliberKnight
Highly Voted 3 years, 12 months agoThaboS
Highly Voted 4 years agoSamuel77
Most Recent 2 years, 8 months agoTrevorK
2 years, 8 months agoNUYO
2 years, 8 months agoknigmich
2 years, 9 months agopimni
2 years, 9 months agodmnantilla9
2 years, 12 months agovineyvinni
3 years agoPowerBIAddict
3 years, 1 month agoTechDiva
3 years, 1 month agoDarhmiee
2 years, 9 months agoLetsgo9999
3 years, 1 month agobattenarajesh
3 years, 3 months agoAjitk27
3 years, 3 months agocreditiridium
3 years, 4 months agokwanalytics
3 years, 4 months agoDatBI
3 years, 4 months ago