Exam PL-300 topic 1 question 10 discussion

Answer C is best approach Split the Logged column by using "at" as the delimiter.

C, You should split the Logged column by using "at" as the delimiter. This will allow you to separate the date and time into separate columns, which will enable you to analyze the complaints by date and use a built-in date hierarchy. Alternatively, you could also use a transformation to extract the date and time from the Logged column and set the data type of the new columns to Date and Time, respectively. Option A is incorrect because it only extracts the last 11 characters of the Logged column, which would not include the date. Option B is incorrect because the data in the Logged column is in a non-standard date format and cannot be directly converted to the Date data type. Option D is incorrect because it only extracts the first 11 characters of the Logged column, which would not include the time.

Splitting the Logged column by the delimiter "at" separates the date and time into different columns, allowing you to convert the date part into a proper Date type and use Power BI’s built-in date hierarchy for analysis.

I think C

1. The question didnt asked for time, it asked for date only. 2. When using a delimited, there are two spaces before and after "at". 3. C result still requires cleanup as it will give two columns one of them is the time. So the answer is D for sure.

Both answers C and D are correct, both get the job done since the question doesnt specify you need to keep the time. The time is meaningless, so keeping it is unnecesary. I guess i understand why people would like both columns, but it's better to just get rid of unnecesary columns to improve the model

Correct answer

The Correct Answer is D for two main reasons 1) The question is only interested in creating a DATE hierarchy, so time is irrelevant here, extracting the first 11 characters covers the entire Date. 2) the 'at' delimiter of option C will include the spaces as suffix and prefix, in the new split columns

Split the logged column with the delimiter space

D. Apply a transformation to extract the first 11 characters of the Logged column. Extracting the first 11 characters will give you 2018-12-31, which is the date part. You can then set the data type of this new column to Date. This is the most straightforward and efficient approach.

Explanation: The Logged column format is "2018-12-31 at 08:59". To analyze by date and use a built-in date hierarchy, you need to extract just the date part. The first 11 characters ("2018-12-31") represent the date. Once extracted, you can convert this new column into a Date data type for proper analysis and use of the date hierarchy. This ensures that the data is in a suitable format for date-based analysis.

Answer is correct. Tried and tested.

I have seen the same question in the Microsoft pl-300 preparation course on coursera and here is the answer to that question: You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do? - Split the logged column using ‘at’ as a delimiter. - You can use the same column as the date hierarchy. - Apply transformation to extract the column's first characters that only contain the date. - Change the data type of the logged column to Date. ✔

I have seen the same question in the Microsoft pl-300 preparation course on coursera and here is the answer to that question: You have a CSV file that contains user complaints. The table contains a column called Logged, which has data and the time of each complaint. The data is logged in the following format: 2022-12-21 at 08:35. You want to analyze the complaints by the logged date and utilize Power BI’s built-in date hierarchy. What should you do? 1- Split the logged column using ‘at’ as a delimiter. 2- You can use the same column as the date hierarchy. 3- Apply transformation to extract the column's first characters that only contain the date. 4- Change the data type of the logged column to Date. ✔

My bad, A is talking about the last 11 characters, so my choice is D.

And yeah you should change the data type after D so the correct answer should be A

I've tried in PBI desktop, and D works well.