Exam CSCP All Questions

View all questions & answers for the CSCP exam

Exam PL-300 topic 1 question 30 discussion

Actual exam question from APICS's CSCP

Question #: 30
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. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Apply the Parse function from the Date transformations options to the Logged column.

Show Suggested Answer

Suggested Answer: C 🗳️

by tranquanghuy2111 at Oct. 5, 2023, 3:39 p.m.

Comments

Submit Cancel

tranquanghuy2111

Highly Voted 1 year, 8 months ago

Selected Answer: C

this question is repeat many times

upvoted 27 times

...

mycorgiart

Most Recent 9 months, 2 weeks ago

Just in case, this may help some of us who wonder why the same question was repeated three times (#10, #27 and #30), so I went back to all three questions, and noticed that a combination of answers is slightly different among them. Does this question keep coming back to test us with a different answer scenario...? For example, #10 D said "Apply a transformation to extract..." but #30 has the same A, B and C answers as #10, but #30 D is different; "Apply the Parse function...", not "transformation." Then #27 B and C answers are the same answers as #10 C, D and #30 C, D, and #27 A is the same answer as #30 D (Parse), but #27 D uses a new answer ("Create a column by..."), which is not appeared in #10 and #30.

upvoted 1 times

...

rcaliandro

10 months ago

Selected Answer: C

Again?

upvoted 1 times

...

NaudeDucon

10 months, 3 weeks ago

Selected Answer: C

Again. But let's test in PBI, you'll see using delimiter with just "at". no need to include any space still work perfectly

upvoted 1 times

...

Kiran37

10 months, 3 weeks ago

correct answer

upvoted 2 times

...

Deva_1

1 year, 1 month ago

Selected Answer: C

I have completed all the steps with dummy data, and yes, answer C is correct.

upvoted 2 times

...

Mcisneros

1 year, 2 months ago

Not again..... C.

upvoted 1 times

...

AZFabio

1 year, 3 months ago

Selected Answer: C

split by at delimiter

upvoted 2 times

...

28485e1

1 year, 3 months ago

This is the 3rd time this question has appeared. Now the answer is delimiter, with the presence of 11-char. 2/3 delimiter, 1 against 11-char. I think it is safe to say the answer to this question will always be delimiter.

upvoted 3 times

...

svbz

1 year, 4 months ago

Option A says , Extract the last 11 characters here, as opposed to First 11 in the Question 10 . therefore C is Correct.

upvoted 4 times

...

Dsbuff

1 year, 5 months ago

Selected Answer: C

As many have said, this question is repeated many times.

upvoted 2 times

...

ElieG

1 year, 6 months ago

This question is the same as Question 10, can anyone please explain the difference between the answers given? (In Question 10 the answer given was to extract the first 11 characters)

upvoted 1 times