nerdexam
Databricks

CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #29

A Data analyst has been tasked with optimizing a Databricks SQL query for a large dataset. What should you consider when trying to improve query performance?

Sign in or unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to reveal the answer and full explanation for question #29. The question stem and answer options stay visible for context.

Question

A Data analyst has been tasked with optimizing a Databricks SQL query for a large dataset. What should you consider when trying to improve query performance?

Options

  • AIncreasing the size of the cluster to handle the data
  • BPartitioning the data into smaller chunks
  • CUsing a higher level of parallelism for the query
  • DIncreasing the timeout for the query

Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE to see the answer

You've previewed enough free CERTIFIED-DATA-ANALYST-ASSOCIATE questions. Unlock CERTIFIED-DATA-ANALYST-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full CERTIFIED-DATA-ANALYST-ASSOCIATE Practice