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?

Real Exam

CREATE OR REPLACE TABLE inventory USING DELTA LOCATION ‘dbfs:/user/username/retail‘

32.7%

CREATE inventory TABLE USING DELTA LOCATION ‘dbfs:/user/username/retail‘

6.8%

CREATE TABLE inventory AS DELTA LOCATION ‘dbfs:/user/username/retail‘

20.9%

CREATE UNMANAGED TABLE inventory USING DELTA LOCATION ‘dbfs:/user/username/retail‘

30.0%

CREATE inventory LOCATION ‘dbfs:/user/username/retail‘

9.5%

Databricks Certified Data Engineer - Associate