exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 10 discussion

Actual exam question from Microsoft's PL-300
Question #: 10
Topic #: 1
[All PL-300 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
_Jay_
Highly Voted 2 years, 6 months ago
Selected Answer: C
Answer C is best approach Split the Logged column by using "at" as the delimiter.
upvoted 98 times
SylUK
1 month, 3 weeks ago
correct answer
upvoted 1 times
...
GuerreiroJunior
2 years, 2 months ago
Agreed with you Jay
upvoted 3 times
...
Jay_98_11
2 years, 3 months ago
agreed
upvoted 2 times
...
red_02
1 year, 11 months ago
If you choose to split it will create 2 columns but extract will give 1 column.
upvoted 9 times
...
...
Meebler
Highly Voted 2 years, 2 months ago
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.
upvoted 40 times
AFarag
2 years, 1 month ago
delimiter uses only one character, so "at" is not valid
upvoted 3 times
cabbagepie
2 years ago
You actually can do that if you click on the "Select or enter delimiter" in the "Split Column by Delimiter" window that pops up after you click on "Split Column" in the "Transform" tab on top of your Power BI window. After you select the --Custom-- option from the drop down menu in the "Select or enter delimiter" drop down list, you can write "at" in the text box that appears below the drop down list.
upvoted 11 times
...
dodoinparis
1 year, 8 months ago
Correct answer
upvoted 1 times
...
...
...
Kbo05
Most Recent 2 days, 21 hours ago
Selected Answer: C
Split the logged column with the delimiter space
upvoted 1 times
...
teenthabo
1 month, 3 weeks ago
Selected Answer: D
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.
upvoted 2 times
...
Shrav95
1 month, 3 weeks ago
Selected Answer: D
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.
upvoted 2 times
...
MANANDAVEY
2 months ago
Selected Answer: C
Answer is correct. Tried and tested.
upvoted 1 times
...
Bilalwaris786
2 months, 2 weeks ago
Selected Answer: B
Correct answer is "Change the data type of the Logged column to Date." as question is saying "You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy." if you select split option, column will be still in text format, so we have to change Logged column to a date format.
upvoted 1 times
...
BIFakeGuru
2 months, 3 weeks ago
Selected Answer: B
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. ✔
upvoted 3 times
...
BIFakeGuru
2 months, 3 weeks ago
Selected Answer: D
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. ✔
upvoted 1 times
...
AlexBear
2 months, 3 weeks ago
Selected Answer: D
My bad, A is talking about the last 11 characters, so my choice is D.
upvoted 1 times
...
AlexBear
2 months, 3 weeks ago
Selected Answer: A
And yeah you should change the data type after D so the correct answer should be A
upvoted 1 times
...
AlexBear
2 months, 3 weeks ago
Selected Answer: D
I've tried in PBI desktop, and D works well.
upvoted 1 times
...
YuanQingTan
3 months ago
Selected Answer: C
Tried it in power query. splitting the column by delimiter at indeed will result in a space character after the date as in 2018-12-31[space] however the space does not prevent power query from automatically converting the data type to date. If we chose to extract the first 11 characters, power query will still treat them as text. It does not become a date data type.
upvoted 1 times
...
GraceKHE
4 months ago
Selected Answer: A
Tested. Yes, delimiter can customized by delimiting "at" but the column format is still Text. answer A automatically change the column format to Date hierarchy.
upvoted 2 times
...
Madhu155
5 months, 1 week ago
Option D
upvoted 1 times
...
Bob_38
5 months, 2 weeks ago
CCCCCCCCCCCCCCCCC! No Brainer!
upvoted 1 times
...
Dani_eL
5 months, 3 weeks ago
Selected Answer: D
answer is D, apply a TRANSFORMATION; using a demo. create a csv with complaint id, complaint date(use the date format described in the example) Create new report -> transform data : opens Power Query editor New Sources -> csv Here comes the tricky part: when you import a csv, you can apply TRANSFORMATION on the fly; there is a button at the bottom left part of the window : Extract table using examples click that button, here comes the TRANSFORMATION You are presented with a form allowing you to pick up the fields and the data you want by example. Name your headers according to the csv headers and in the first data row, type the kind of data you want. For the logged column, you will type the date only. After import you will see that Query editor imported and converted your field in Date format. Finally, go to report view and expand your imported csv in the Data pane. You will see that Power BI created a date hierarchy
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago