Executing queries using Databricks SQL and Databricks SQL Warehouses Questions
Practice questions for Executing queries using Databricks SQL and Databricks SQL Warehouses topic in Databricks Certified Data Analyst Associate. 40 questions covering this domain.
An analyst writes a query that joins an orders table with a customers table and wants to include all orders regardless of whether the customer record ...
An analyst needs to create a view in Databricks SQL that aggregates sales data by region. Other analysts on the team should be able to query this view...
An analyst needs to assign a sequential rank to each sale within each sales region, ordered by sale amount descending, without gaps in the ranking whe...
A Databricks SQL analyst needs to find all customers who placed more than 5 orders in 2024. Which query correctly uses a GROUP BY with a HAVING clause...
Which type of SQL warehouse does Databricks recommend for optimal price and performance due to instant and elastic compute?
An analyst runs a query in Databricks SQL and receives results. She then modifies a filter condition and runs the query again within a few seconds. Th...
Which SQL function in Databricks SQL returns the current timestamp at the time the query starts executing?
An analyst runs the following query and receives incorrect totals. The analyst suspects a NULL handling issue.\n\n```sql\nSELECT department, SUM(salar...
An analyst is running a complex query in Databricks SQL that joins three large tables and takes 10 minutes to complete. A colleague suggests adding a ...
What is a Databricks SQL Warehouse?
An analyst is querying a large fact table with 500 million rows in Databricks SQL. The table uses Liquid clustering on the `customer_segment` and `ord...
A data analyst wants to calculate a 7-day rolling average of daily sales for each product, ordered by date. Which SQL component is required to impleme...
What does the Scaling configuration on a SQL warehouse control?
A data analyst needs to retrieve the top 3 highest-paid employees from each department. Which SQL approach correctly uses a window function for this?
Which SQL function in Databricks SQL correctly extracts the year from a date or timestamp column named `order_date`?
Which SQL warehouse permission level should be assigned to a business analyst who only needs to run queries and view results, without the ability to m...
An analyst writes a query that uses a CASE expression to classify orders. Which syntax correctly uses a searched CASE expression in Databricks SQL?
An analyst needs to combine the result sets of two queries: one returning 2024 sales and another returning 2025 sales, without any duplicate rows. Whi...
A query analyst at a company runs the same complex analytical query multiple times per day on a large Delta table. The first run takes 4 minutes; subs...
An analyst runs the following query and wants to return all employees along with their manager's name. The manager_id in the employees table reference...
Sign in to see all 40 questions
Create a free account to browse all questions — completely free during our launch phase.