ExamTopics Logo
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 62 discussion

Actual exam question from APICS's CSCP
Question #: 62
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. 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 Hide Answer
Suggested Answer: B 🗳️
by GuerreiroJunior at Jan. 10, 2023, 8:26 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Neilsy
Highly Voted 1 year, 10 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
1 year, 8 months ago
true, I have tested this myself as well
upvoted 6 times
...
...
Sandy2010
Highly Voted 1 year, 8 months ago
Selected Answer: B
B seems the right transformation
upvoted 12 times
...
Endeetheanalyst
Most Recent 4 months, 2 weeks 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
4 months, 2 weeks 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
4 months, 3 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
4 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
5 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
10 months, 1 week ago
Wth?? This same question gets different answers every time.
upvoted 6 times
...
guatemonica
10 months, 3 weeks 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
10 months, 3 weeks ago
Selected Answer: B
split by custom delimiter then PBI will automatically recognize the date format for the date column
upvoted 1 times
...
lukelin08
12 months ago
Selected Answer: B
Tested, B is correct. A doesn't work and gives an error
upvoted 3 times
...
08b2ddd
1 year ago
deja vu again
upvoted 2 times
...
asnygen
1 year ago
chatgpt> correct is A
upvoted 2 times
...
Aero_1898
1 year, 2 months ago
repeated question
upvoted 3 times
...
Tammy_07
1 year, 2 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, 2 months ago
Selected Answer: B
Repeat Question
upvoted 1 times
...
Igetmyrole
1 year, 4 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, 4 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...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago