Microsoft Power BI Data Analyst PL-300 Question # 41 Topic 5 Discussion

Microsoft Power BI Data Analyst PL-300 Question # 41 Topic 5 Discussion

PL-300 Exam Topic 5 Question 41 Discussion:
Question #: 41
Topic #: 5

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?


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.


Get Premium PL-300 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.