ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 1 question 10 discussion

Actual exam question from Microsoft's DA-100
Question #: 10
Topic #: 1
[All DA-100 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. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  • C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by jiawang6688 at April 30, 2021, 10:08 a.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
DeathCaliberKnight
Highly Voted 4 years ago
is true c
upvoted 35 times
...
Cloudy_Dave
Highly Voted 3 years, 11 months ago
This was in the exam on 28th May
upvoted 7 times
...
RichardOgoma
Most Recent 2 years, 7 months ago
Selected Answer: C
Splitting columns by delimiter " at " is the best option though. Column by examples would do the same.
upvoted 1 times
...
RamzanAnjum
2 years, 9 months ago
Selected Answer: C
C is the right one
upvoted 1 times
...
Soksay
2 years, 10 months ago
Selected Answer: C
C is the right answer
upvoted 1 times
...
midnight93
3 years, 9 months ago
if C is true, then this data column is created by ourselves, not actually contain the info from Logged data of the csv file? How would it connect to the Logged data?
upvoted 2 times
Tomasz1989
2 years, 11 months ago
Because this feature creates dynamic formula based on your example.
upvoted 1 times
...
...
ThierryProsper
3 years, 11 months ago
Pour créer une hiérarchie de date, il faut créer une nouvelle colonne . C est juste.
upvoted 4 times
eurekamike
3 years, 9 months ago
Je suis d'accord
upvoted 1 times
...
...
severalsun
3 years, 11 months ago
Yes, "C" is the correct answer.
upvoted 4 times
...
Jonathan1726
3 years, 11 months ago
I think that the reason for the answer to be C and not A is because of the format "2018-12-31 at 08:59" the "at" word makes the data type string which is not going to be able to parse as Date type.
upvoted 4 times
Canary_2021
3 years, 10 months ago
You are right! Should select C because of "at" word in this column.
upvoted 1 times
...
...
bankijey
3 years, 11 months ago
Think A, just change the column type. Adding new column seems redundant
upvoted 3 times
Massy
3 years, 10 months ago
but there's the "at" word, so A can't work
upvoted 1 times
...
...
[Removed]
3 years, 11 months ago
Why not A?
upvoted 1 times
Amuzinde
3 years, 11 months ago
The best way to optimize dates is to split the columns to enable drill down. no redundancy here
upvoted 2 times
...
...
memo43
3 years, 12 months ago
Yes answer is C https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example
upvoted 4 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago