Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

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
[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. 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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
tranquanghuy2111
Highly Voted 1 year, 1 month ago
Selected Answer: C
this question is repeat many times
upvoted 27 times
...
mycorgiart
Most Recent 2 months, 3 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
3 months, 1 week ago
Selected Answer: C
Again?
upvoted 1 times
...
NaudeDucon
4 months 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
4 months ago
correct answer
upvoted 2 times
...
Deva_1
6 months, 3 weeks ago
Selected Answer: C
I have completed all the steps with dummy data, and yes, answer C is correct.
upvoted 2 times
...
Mcisneros
8 months ago
Not again..... C.
upvoted 1 times
...
AZFabio
8 months, 2 weeks ago
Selected Answer: C
split by at delimiter
upvoted 2 times
...
28485e1
9 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
9 months, 4 weeks 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
11 months, 1 week ago
Selected Answer: C
As many have said, this question is repeated many times.
upvoted 2 times
...
ElieG
12 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
noone420
10 months, 1 week ago
wrong answer before probably. correct is to split using at as delimiter. check the discussions for the correct answer always
upvoted 1 times
...
...
vikjos4
12 months ago
Why Not A
upvoted 2 times
[Removed]
9 months, 4 weeks ago
It's not A because it is about extracting the last 11 characters rather than the first ones.
upvoted 2 times
...
...
madyjoe21
1 year ago
Deja vu
upvoted 3 times
...
TrustMyAnswers
1 year ago
Selected Answer: C
Answer C is correct. Duplicate question.
upvoted 1 times
...
IrynaVilner
1 year, 1 month ago
Answer C
upvoted 1 times
...
SwapnJ
1 year, 1 month ago
Option C, This question was in Exam
upvoted 3 times
...
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
Loading ...