Analyzing Queries Questions
Practice questions for Analyzing Queries topic in Databricks Certified Data Analyst Associate. 30 questions covering this domain.
Which Databricks SQL command shows a Delta table's full transaction history, including the version number, timestamp, and operation performed?
Which Databricks SQL feature provides a visual representation of how a query is executed, showing operations like scans, joins, and filters?
An analyst needs to enforce Liquid clustering on an existing unpartitioned Delta table named `transactions` using the `transaction_date` column. Which...
A data analyst notices that a Databricks SQL query against a large Delta table ran much faster last week than it does today, even though the table sch...
An analyst runs a query in Databricks SQL and wants to understand why it is slower than expected. She opens the Query Profile and sees that one node s...
An analyst wants to review all queries run against a specific table in the last 7 days to understand access patterns. Which Databricks feature should ...
An analyst wants to check whether a Databricks SQL query is benefiting from data skipping on a Delta table. Which information in the Query Profile wou...
A team of analysts shares a SQL warehouse and occasionally experiences slow query startup times, with queries waiting in a queue before execution begi...
An analyst runs a query and opens the Query Profile in Databricks SQL. They see that the scan node shows that 850 out of 1,000 total data files were p...
In Delta Lake, what does the operation type "WRITE" recorded in DESCRIBE HISTORY indicate?
A data team wants to monitor all queries run by a specific service principal on their production SQL warehouse over the last 30 days for a security au...
An analyst is tasked with investigating slow query performance on a Delta table that stores clickstream events. The table has 800 billion rows, no par...
An analyst wants to understand which version of a Delta table corresponds to a snapshot from exactly 48 hours ago. Which SQL command helps identify th...
A data analyst notices a query running slowly and uses the Query Profile to investigate. She sees high "spill to disk" bytes on the join node. What do...
What information is captured in the Databricks SQL Query History?
Queries on a busy warehouse spend time waiting in the queue before compute is available. Which `system.query.history` column measures that delay?
A security team wants a system table that records account and workspace audit events such as service name, action name, request parameters, and source...
A region uses customer-managed keys for managed services, and an admin notices `statement_text` and `error_message` are empty in `system.query.history...
Which `system.query.history` field directly indicates that a query result was served from the result cache?
An analyst wants to know whether a statement came from a dashboard, notebook, job, or Genie Space. Which column in `system.query.history` provides tha...
Sign in to see all 30 questions
Create a free account to browse all questions — completely free during our launch phase.