You have been tasked with creating or overwriting an existing Delta table to store transaction data. Which of the following SQL commands correctly accomplishes this?

Real Exam

CREATE OR REPLACE DELTA TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)

13.0%

CREATE OR REPLACE TABLE IF EXISTS transactions (transactionId int, transactionDate timestamp, unitsSold int) FORMAT DELTA

13.6%

CREATE IF EXISTS REPLACE TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)

5.1%

CREATE OR REPLACE TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)

68.4%

Databricks Certified Data Engineer - Associate