Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Apics 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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
AnnaBi
Highly Voted 1 year, 7 months ago
A is the correct one ! there's the same quention in previous pages!
upvoted 30 times
...
Rajd1979
Highly Voted 1 year, 7 months ago
Selected Answer: A
A is the correct one
upvoted 9 times
...
539d541
Most Recent 3 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
rcaliandro
3 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
7 months 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
7 months, 1 week 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
8 months 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
8 months, 2 weeks ago
Selected Answer: A
A is the correct answer and duly tested in the power query editor.
upvoted 2 times
...
swaychen
9 months ago
Deja Vu
upvoted 4 times
...
Dani_eL
9 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
9 months ago
My bad! it keeps the string format! A is the correct answer
upvoted 2 times
...
...
lukelin08
10 months, 1 week ago
Selected Answer: A
A is correct
upvoted 2 times
...
applushka
10 months, 1 week ago
Selected Answer: A
A - reproduced with desired outcome
upvoted 1 times
...
Jahanif
10 months, 2 weeks ago
Selected Answer: A
A is the correct one, obviously.
upvoted 2 times
...
Leiaaaaa
1 year ago
Why is the answer always that whole number option???
upvoted 3 times
...
Tammy_07
1 year, 1 month 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, 1 month ago
B, because when u add coulme by example, powerBI automatically detect datatype after 1st step here.
upvoted 3 times
applushka
10 months, 1 week ago
this step ends up in the column still in Text format
upvoted 2 times
...
...
thomas_90
1 year, 1 month ago
It is so clear with A is correct answer here.
upvoted 2 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