Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

Exam PL-300 topic 1 question 27 discussion

Actual exam question from Microsoft's PL-300
Question #: 27
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 the Parse function from the Data transformations options to the Logged column.
  • B. Change the data type of the Logged column to Date.
  • C. Split the Logged column by using at as the delimiter.
  • D. Create a column by example that starts with 2018-12-31.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by tranquanghuy2111 at Oct. 5, 2023, 3:28 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
tranquanghuy2111
Highly Voted 7 months, 2 weeks ago
Selected Answer: C
A: cause error. C: correct, although it lacks step change data type
upvoted 14 times
bsdk_jinx
2 months, 2 weeks ago
Datatype is changed automatically you need not do it manually :)
upvoted 3 times
...
Kish1604
7 months ago
Change Data Type step is not required since the data type gets updated automatically after splitting the column by delimiter
upvoted 8 times
bdub1976
5 months, 1 week ago
Yep, the answer is C and using delimiter "at" is the easiest path and will automatically adjust the column to date format upon hitting Ok. Also, this method retains the time column in time format. If time was not a requirement, then you might be better using Extract Table Using Examples to minimize the data imported.
upvoted 3 times
...
...
...
momo1165
Highly Voted 4 months, 2 weeks ago
Question appears multiple times with different answer options, in this set of answers, C is correct.
upvoted 9 times
...
jsav1
Most Recent 1 week, 1 day ago
Selected Answer: C
C is the more reliable option
upvoted 1 times
...
yaya32
1 week, 2 days ago
Selected Answer: C
C for me
upvoted 1 times
...
Sheree_Data
1 week, 6 days ago
Microsoft Fabric said choice D.
upvoted 1 times
...
shazzzy
2 weeks, 1 day ago
ANS. C I tested D and it didn't change the data type to Date, it remained as text. I also tested C without using spaces before and after the 'at' and it DID change the data type to date. The fact that there are two questions like this but C is common to both questions makes extra sure it is correct. C!
upvoted 1 times
...
Deva_1
2 weeks, 5 days ago
Selected Answer: D
D. Create a column by example that starts with 2018-12-31 is the correct answer bcz if you add column from example(i.e. 2018-12-31) then it gives only data format. Answer C is wrong bcz if we use "at as delimiter then the space before at will be added in the data format so the column will not automatically detect as a date format.
upvoted 1 times
Bhanu__prakash
2 weeks, 1 day ago
Have you even tried? The space before 'at' will be removed automatically, that's the beauty of intelligence in Power BI. I've tried, both C and D options work. But for option D, the data type will be set to text and we need to add additional step to change data type, wherein for option C, Power BI automatically recognizes and changes the data type.
upvoted 1 times
...
...
KRISTINMERIEANN
1 month ago
Selected Answer: D
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example
upvoted 2 times
...
TrainingCA06
2 months ago
be careful, this is the same question #10, and in 10 the right answer was D and here C. crazy
upvoted 1 times
sdfokjwov
1 month, 3 weeks ago
They've got different answers - In #10, D is the simplest, in this Q, C is
upvoted 1 times
...
...
28485e1
2 months, 3 weeks ago
There is another question verbatim like this one and the answer is, "extract the first 11 characters." Delimiter answer appears on both. Is it saying that extracting the characters is a better option if available? I don't understand.
upvoted 4 times
...
Dani_eL
2 months, 4 weeks ago
Tested in PBI with dummy data : A & B will cause an error in the data --> you will read "error" instead of original data D will truncate the date correctly but will keep the original string format (no hierarchy possible) C will split correctly and apply correct format on the fly, date for date and time for time
upvoted 4 times
...
user28272615
3 months ago
Was at the exam on February 12th 2024
upvoted 4 times
...
JohnChung
4 months, 2 weeks ago
Selected Answer: D
I tried. D is correct. It is easy to create a new column only contains the date with Examples
upvoted 4 times
momo1165
4 months, 2 weeks ago
D adds another column, C does not
upvoted 2 times
Adja_Fall
3 months, 3 weeks ago
C divise la colonne en 2 donc il y a bien une nouvelle colonne
upvoted 2 times
...
...
...
bbshu0801
4 months, 2 weeks ago
Selected Answer: C
Same question with #10, Topic 1. So the answer should be same which is C.
upvoted 5 times
...
Dsbuff
5 months ago
Selected Answer: C
C is correct. By splitting the Logged column, you can separate the date and time into two columns.
upvoted 3 times
...
fellywashe
5 months ago
Just checking is at a delimeter?? someone please assist
upvoted 1 times
...
XAPT_Kft
5 months, 1 week ago
Selected Answer: C
C is absulutely correct. Split sets the data type for the date field automatically. In the case of D solution, additinal step is needed to change data type of the new column.
upvoted 4 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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