Exam CSCP All Questions

View all questions & answers for the CSCP exam

Exam PL-300 topic 2 question 66 discussion

Actual exam question from APICS's CSCP

Question #: 66
Topic #: 1

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

Suggested Answer: A 🗳️

by jiriz at March 29, 2023, 10:52 a.m.

Comments

Submit Cancel

AnnaBi

Highly Voted 2 years, 3 months ago

A is the correct one ! there's the same quention in previous pages!

upvoted 30 times

...

Rajd1979

Highly Voted 2 years, 3 months ago

Selected Answer: A

A is the correct one

upvoted 9 times

...

539d541

Most Recent 10 months, 3 weeks ago

Selected Answer: A

A is correct

upvoted 1 times

...

rcaliandro

10 months, 4 weeks 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, 2 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

1 year, 2 months 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, 3 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

1 year, 4 months ago

Selected Answer: A

A is the correct answer and duly tested in the power query editor.

upvoted 2 times

...

swaychen

1 year, 4 months ago

Deja Vu

upvoted 4 times

...

Dani_eL

1 year, 4 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, 4 months ago

My bad! it keeps the string format! A is the correct answer

upvoted 2 times

...

lukelin08

1 year, 5 months ago

Selected Answer: A

A is correct

upvoted 2 times

...

applushka

1 year, 6 months ago

Selected Answer: A

A - reproduced with desired outcome

upvoted 1 times

...

Jahanif

1 year, 6 months ago

Selected Answer: A

A is the correct one, obviously.

upvoted 2 times

...

Leiaaaaa

1 year, 8 months ago

Why is the answer always that whole number option???

upvoted 3 times

...

Tammy_07

1 year, 8 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

...