Databricks Data Engineer Associate Question 509
Single answerYou are working on a Databricks project where data is organized in a three-layer namespace. The database is named sales_db, the schema is transactions, and the table is monthly_data. How can you query the table in this namespace?
- A
SELECT * FROM sales_db.transactions.monthly_data;
- B
SELECT * FROM transactions.monthly_data;
- C
SELECT * FROM sales_db.monthly_data;
- D
SELECT * FROM sales_db.transactions.monthly_data USING delta;
Show answer and explanation
Correct answer: A
Explanation
A three-layer namespace in Databricks requires specifying the database, schema, and table in the format database.schema.table. This structure ensures that the correct table is accessed within the hierarchical organization of data in Databricks. The query SELECT * FROM sales_db.transactions.monthly_data; adheres to this format and is the appropriate way to query the table.
- A. Correct.
Correct. In Databricks, the three-layer namespace requires you to specify the database, schema, and table in the format
database.schema.table. This query adheres to that format and will successfully query the table. - B. Incorrect.
Incorrect. This query omits the database layer (
sales_db) and only includes the schema and table. A three-layer namespace requires all three layers. - C. Incorrect.
Incorrect. This query omits the schema layer (
transactions) and only includes the database and table. A three-layer namespace requires all three layers. - D. Incorrect.
Incorrect. While this query includes a valid three-layer namespace, the addition of
USING deltais not a valid syntax for a standardSELECTquery. The clauseUSING deltais used in other operations likeCREATE TABLE.