In Databricks, Snowflake's query pushdown is enabled by default.

• A. It is enabled only in some regions
• B. It is not enabled at all
• C. True
• D. Only in premium plans

Answer: (C)

Query pushdown means the Databricks-Snowflake connector translates eligible Spark operations—like filters and projections—into Snowflake SQL so that Snowflake runs the work directly, only returning the necessary data. This offloads work to Snowflake’s engine, reducing data movement and usually speeding up queries. The default behavior of the connector is to enable this pushdown, so the statement is correct: pushdown happens by default without extra configuration. The other choices aren’t accurate because pushdown isn’t gated by region, isn’t disabled entirely, and isn’t limited to premium plans. Keep in mind that not every operation can be pushed down; some complex expressions or unsupported constructs may still be evaluated after data is fetched, but the default remains enabled.