You need to create a Delta table in databricks video

October 01, 2025  ·  PT1H46M27S  ·  EN

data-engineer-associate video for you need to create a Delta table in Databricks to store user login records. The table should have: userId : An integer

Question 1 Be Honest

« Back   Next data-engineer-associate Certification Question »

Answer

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?