ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam CSCP All Questions

View all questions & answers for the CSCP exam
Go to Exam

Exam PL-300 topic 2 question 66 discussion

Actual exam question from APICS's CSCP
Question #: 66
Topic #: 1
[All CSCP 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. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  • B. Create a column by example that starts with 2018-12-31
  • C. Apply a transformation to extract the last 11 characters of the Logged column
  • D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by jiriz at March 29, 2023, 10:52 a.m.

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
Submit Cancel
AnnaBi
Highly Voted 2 years, 1 month ago
A is the correct one ! there's the same quention in previous pages!
upvoted 30 times
...
Rajd1979
Highly Voted 2 years, 1 month ago
Selected Answer: A
A is the correct one
upvoted 9 times
...
539d541
Most Recent 8 months, 3 weeks ago
Selected Answer: A
A is correct
upvoted 1 times
...
rcaliandro
9 months ago
Selected Answer: A
A. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
upvoted 1 times
...
Zach0308
1 year ago
Selected Answer: A
How do they get away with people paying money for them to constantly put the wrong answers lol
upvoted 4 times
...
9f73003
1 year ago
Wow, every time they get this wrong. I wonder if it changed, and they never updated it to the correct answer A?? I paid for this!!! Wow.
upvoted 3 times
...
AZFabio
1 year, 1 month ago
Selected Answer: A
B would be correct if the original column was Date/Time (ie. 2018-12-31 11:00:00). In this case the new column would automaticaly be set to Date. But since the original column is Text, the column by example would keep the format (Text) although it will have a "date content".
upvoted 1 times
...
Rhugved
1 year, 2 months ago
Selected Answer: A
A is the correct answer and duly tested in the power query editor.
upvoted 2 times
...
swaychen
1 year, 2 months ago
Deja Vu
upvoted 4 times
...
Dani_eL
1 year, 2 months ago
Selected Answer: B
B is the correct answer because when you split, PBI automatically detects the date format and applies it, including the hierarchy
upvoted 2 times
Dani_eL
1 year, 2 months ago
My bad! it keeps the string format! A is the correct answer
upvoted 2 times
...
...
lukelin08
1 year, 4 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
applushka
1 year, 4 months ago
Selected Answer: A
A - reproduced with desired outcome
upvoted 1 times
...
Jahanif
1 year, 4 months ago
Selected Answer: A
A is the correct one, obviously.
upvoted 2 times
...
Leiaaaaa
1 year, 6 months ago
Why is the answer always that whole number option???
upvoted 3 times
...
Tammy_07
1 year, 6 months ago
Selected Answer: A
It will be A only. People who are mentioning that Power BI will detect data type automatically. Please note that in this case when you are using "Column from example" to get the date part, power BI will convert it into next. You need to then convert it into date type
upvoted 4 times
...
RMUK
1 year, 7 months ago
B, because when u add coulme by example, powerBI automatically detect datatype after 1st step here.
upvoted 3 times
applushka
1 year, 4 months ago
this step ends up in the column still in Text format
upvoted 2 times
...
...
thomas_90
1 year, 7 months ago
It is so clear with A is correct answer here.
upvoted 2 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago