Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Neilsy
Highly Voted 1 year, 8 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, 6 months ago
true, I have tested this myself as well
upvoted 6 times
...
...
Sandy2010
Highly Voted 1 year, 7 months ago
Selected Answer: B
B seems the right transformation
upvoted 12 times
...
Endeetheanalyst
Most Recent 2 months, 3 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
2 months, 3 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
3 months 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
3 months ago
Selected Answer: B
B - Split the Logged column by using at as the delimiter is the correct answer!
upvoted 1 times
...
Sindhukanchibhotla
3 months, 1 week 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
8 months, 3 weeks ago
Wth?? This same question gets different answers every time.
upvoted 6 times
...
guatemonica
9 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
9 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
10 months, 1 week ago
Selected Answer: B
Tested, B is correct. A doesn't work and gives an error
upvoted 3 times
...
08b2ddd
10 months, 3 weeks ago
deja vu again
upvoted 2 times
...
asnygen
11 months, 1 week ago
chatgpt> correct is A
upvoted 2 times
...
Aero_1898
1 year, 1 month ago
repeated question
upvoted 3 times
...
Tammy_07
1 year, 1 month 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, 1 month ago
Selected Answer: B
Repeat Question
upvoted 1 times
...
Igetmyrole
1 year, 2 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, 3 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...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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