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 4 years, 3 months agoThaboS
Highly Voted 4 years, 3 months agoSamuel77
Most Recent 2 years, 11 months agoTrevorK
2 years, 12 months agoNUYO
3 years agoknigmich
3 years agopimni
3 years agodmnantilla9
3 years, 3 months agovineyvinni
3 years, 3 months agoPowerBIAddict
3 years, 4 months agoTechDiva
3 years, 4 months agoDarhmiee
3 years agoLetsgo9999
3 years, 5 months agobattenarajesh
3 years, 6 months agoAjitk27
3 years, 6 months agocreditiridium
3 years, 7 months agokwanalytics
3 years, 7 months agoDatBI
3 years, 7 months ago