LFC Databricks SQL & Warehousing 2

Question 1

Which SQL Warehouse type in Databricks is best suited for ad-hoc queries by business analysts who need fast startup with no idle cost?

Accepted Answer

Serverless SQL Warehouse

Answer

Serverless SQL Warehouses start in seconds and have no idle cost because compute is fully managed by Databricks.

Question 2

In Databricks SQL, what does the CLUSTER BY clause do when used in a CREATE TABLE statement with liquid clustering enabled?

Accepted Answer

Defines clustering keys for incremental file reorganization without full rewrites

Answer

Liquid clustering uses CLUSTER BY to define keys for incremental, background reorganization of data files, replacing traditional partitioning.

Question 3

A Databricks SQL query uses PIVOT to transform rows into columns. Which SQL keyword is required within the PIVOT clause to define the aggregation?

Accepted Answer

An aggregate function such as SUM or AVG

Answer

The PIVOT clause requires an aggregate function (e.g., SUM, COUNT, AVG) to compute the values for each pivoted column.

Question 4

What is the default behavior of Databricks SQL when a query references a table that does not exist in the current catalog?

Accepted Answer

It raises a TABLE_OR_VIEW_NOT_FOUND error

Answer

Databricks SQL raises TABLE_OR_VIEW_NOT_FOUND if the table is not found in the current catalog and schema.

Question 5

Which feature of Databricks SQL Warehouses allows multiple queries from different users to share a single running warehouse without performance degradation?

Accepted Answer

Query queuing with auto-scaling

Answer

SQL Warehouses use query queuing combined with auto-scaling clusters to handle concurrent users efficiently.

(LFC) Lakehouse Fundamentals Certification Practice Test

(LFC) Lakehouse Fundamentals Certification Practice Test

LFC Databricks SQL & Warehousing 2