AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: You need to create a Delta table in databricks video

Question 1
« Back   Next data-engineer-associate Certification Question »

Full Certification Question

You need to create a Delta table in Databricks to store user login records. The table should have: userId : An integer representing the unique user ID. loginTime : A TIMESTAMP column storing the exact login time. loginDate : A calculated column that automatically extracts and stores the DATE from loginTime . You would like to create a calculated column that converts the loginTime column from TIMESTAMP to DATE and stores it. Which of the following SQL statements correctly defines the loginDate column?