Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
CREATE OR REPLACE DELTA TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)
B
CREATE OR REPLACE TABLE IF EXISTS transactions (transactionId int, transactionDate timestamp, unitsSold int) FORMAT DELTA
C
CREATE IF EXISTS REPLACE TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)
D
CREATE OR REPLACE TABLE transactions (transactionId int, transactionDate timestamp, unitsSold int)
