Question 361 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 a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
BChange the data type of the Logged column to Date.
✓CSplit the Logged column by using at as the delimiter.
DApply the Parse function from the Date transformations options to the Logged column.
✓
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.