Microsoft Power BI Data Analyst — Question 120

You 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?

Answer options

• A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
• B. Change the data type of the Logged column to Date.
• C. Split the Logged column by using at as the delimiter.
• D. Apply a transformation to extract the first 11 characters of the Logged column.

Correct answer: C

Explanation

The correct answer is C because splitting the Logged column using 'at' as the delimiter separates the date from the time, allowing for accurate date analysis. Option A is incorrect since extracting the last 11 characters would only yield the time, not the date. Option B would not enable the use of a date hierarchy because the time is still included in the data type. Option D incorrectly focuses on the first 11 characters, which only captures the date part but does not address the need to separate it from the time.