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 29/49

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.
What should you do?

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

B. Apply a transform 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. Apply a transform to extract the first 11 characters of the Logged column.

Question 29/49

LEAVE A REPLY

Download PDF File