Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 1 question 10 discussion

Actual exam question from Microsoft's DA-100

Question #: 10
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. 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

Suggested Answer: C 🗳️

by jiawang6688 at April 30, 2021, 10:08 a.m.

Comments

Submit Cancel

DeathCaliberKnight

Highly Voted 4 years, 3 months ago

is true c

upvoted 35 times

...

Cloudy_Dave

Highly Voted 4 years, 2 months ago

This was in the exam on 28th May

upvoted 7 times

...

RichardOgoma

Most Recent 2 years, 10 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

3 years ago

Selected Answer: C

C is the right one

upvoted 1 times

...

Soksay

3 years, 1 month ago

Selected Answer: C

C is the right answer

upvoted 1 times

...

midnight93

4 years 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

3 years, 2 months ago

Because this feature creates dynamic formula based on your example.

upvoted 1 times

...

ThierryProsper

4 years, 2 months ago

Pour créer une hiérarchie de date, il faut créer une nouvelle colonne . C est juste.

upvoted 4 times

eurekamike

4 years ago

Je suis d'accord

upvoted 1 times

...

severalsun

4 years, 2 months ago

Yes, "C" is the correct answer.

upvoted 4 times

...

Jonathan1726

4 years, 2 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