Exam CSCP All Questions

View all questions & answers for the CSCP exam

Exam PL-300 topic 2 question 62 discussion

Actual exam question from APICS's CSCP

Question #: 62
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. Change the data type of the Logged column to Date.
B. Split the Logged column by using at as the delimiter.
C. 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.
D. Apply the Parse function from the Date transformations options to the Logged column.

Show Suggested Answer

Suggested Answer: B 🗳️

by GuerreiroJunior at Jan. 10, 2023, 8:26 p.m.

Comments

Submit Cancel

Neilsy

Highly Voted 2 years, 4 months ago

B is correct. Splitting using custom delimiter " at " creates two fields and powerbi automatically recognizes the date as a date type , hence the date hierarchy will be available

upvoted 34 times

luisnc

2 years, 2 months ago

true, I have tested this myself as well

upvoted 6 times

...

Sandy2010

Highly Voted 2 years, 2 months ago

Selected Answer: B

B seems the right transformation

upvoted 12 times

...

Endeetheanalyst

Most Recent 10 months, 1 week ago

Why split the column and create an extra column when you can just change the data type to Date. Remember that you always want to optimize your model so creating a time column that will NOT be used is unnecessary. My answer is A

upvoted 1 times

Endeetheanalyst

10 months, 1 week ago

My bad, A wouldn't work it is a text column. I agree that B is the most appropriate answer in this scenario.

upvoted 1 times

...

539d541

10 months, 2 weeks ago

Selected Answer: B

Who is generating these incorrect answers? C makes no sense! B is correct, once you split the column, the data types are auto selected by Power Query.

upvoted 2 times

...

rcaliandro

10 months, 3 weeks ago

Selected Answer: B

B - Split the Logged column by using at as the delimiter is the correct answer!

upvoted 1 times

...

Sindhukanchibhotla

11 months ago

After splitting the column, you'll have two columns: one containing the date and the other containing the time. You can then change the data type of the date column to Date, which will allow you to utilize the built-in date hierarchy features in your analysis

upvoted 1 times

...

28485e1

1 year, 4 months ago

Wth?? This same question gets different answers every time.

upvoted 6 times

...

guatemonica

1 year, 4 months ago

Someone who took the exam recently, do you know which answer they are looking for? I don't even care what's right at this point

upvoted 4 times

...

Dani_eL

1 year, 4 months ago

Selected Answer: B

split by custom delimiter then PBI will automatically recognize the date format for the date column

upvoted 1 times

...

lukelin08

1 year, 5 months ago

Selected Answer: B

Tested, B is correct. A doesn't work and gives an error

upvoted 3 times

...

08b2ddd

1 year, 6 months ago

deja vu again

upvoted 2 times

...

asnygen

1 year, 6 months ago

chatgpt> correct is A

upvoted 2 times

...

Aero_1898

1 year, 8 months ago

repeated question

upvoted 3 times

...

Tammy_07

1 year, 8 months ago

Selected Answer: B

People who have mentioned D should actually need to do transformation in PBI before putting incorrect options here.

upvoted 3 times

...

Sessiz

1 year, 8 months ago

Selected Answer: B

Repeat Question

upvoted 1 times

...

Igetmyrole

1 year, 10 months ago

D is the correct answer for transforming the "Logged" column into a Date data type that can be used effectively for date-based analysis and creating date hierarchies.

upvoted 1 times

...

Vijay_Krisin

1 year, 10 months ago

Selected Answer: B

We need to split the date column so that we can retrieve the date.You cannot do transformation to date as this would throw error because of "at"

upvoted 1 times

...

Load full discussion...