Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineer is tasked with creating an unmanaged table named inventory using an existing directory path dbfs:/user/username/retail where the data files are stored. Which SQL statement correctly creates this external table?
inventory
dbfs:/user/username/retail
A
CREATE OR REPLACE TABLE inventory USING DELTA LOCATION ‘dbfs:/user/username/retail‘
B
CREATE inventory TABLE USING DELTA LOCATION ‘dbfs:/user/username/retail‘
C
CREATE TABLE inventory AS DELTA LOCATION ‘dbfs:/user/username/retail‘
D
CREATE UNMANAGED TABLE inventory USING DELTA LOCATION ‘dbfs:/user/username/retail‘
E
CREATE inventory LOCATION ‘dbfs:/user/username/retail‘
