DA-100 Exam Dumps | You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains

<< Prev Question Next Question >>

Question 39/43

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant 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.
D18912E1457D5D1DDCBD40AB3BF70D5D
What should you do?

A. Apply a transform to extract the first 11 characters of the Logged column.

B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
.

C. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

D. Change the data type of the Logged column to Date.

Question 39/43

LEAVE A REPLY

Download PDF File