Databricks Data Engineer Associate Question 92
Single answerYou are working with a Databricks SQL query to read data from a Delta table. The query includes the following line: SELECT * FROM delta.my_database.my_table``. What does the prefix delta. represent in this query?
- A
The data format of the table being queried
- B
The name of the database containing the table
- C
The type of storage system hosting the table
- D
The schema of the table being queried
Show answer and explanation
Correct answer: A
Explanation
In Databricks SQL, the prefix after the FROM keyword indicates the data type or format of the table being queried. The delta. prefix specifies that the table is stored in the Delta Lake format, which is a transactional storage layer built on top of cloud object storage.
- A. Correct.
Correct. The prefix
delta.specifies the data format of the table being queried. In this case, it indicates that the table is stored in the Delta Lake format. - B. Incorrect.
Incorrect. The database name is specified separately as
my_databaseand is not indicated by thedelta.prefix. - C. Incorrect.
Incorrect. The storage system (e.g., cloud storage) is not specified by the
delta.prefix in the query. - D. Incorrect.
Incorrect. The schema refers to the structure of the table (columns and their data types), which is not indicated by the
delta.prefix.