Question 358 of 388
Single answerYou have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.What should you do?
AApply the Parse function from the Data transformations options to the Logged column.
BChange the data type of the Logged column to Date.
✓CSplit the Logged column by using at as the delimiter.
DCreate a column by example that starts with 2018-12-31.
✓
Correct Answer: C
Split the Logged column by using at as the delimiter.
▥
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.