Free Databricks-Certified-Data-Analyst-Associate: Databricks Certified Data Analyst Associate Exam Questions and Answers

A Genie space owner wants a group of analysts to ask questions and view the results in the space, but not to edit its instructions, datasets or sample questions. Which permission level should the owner assign to the group on the space?

• AA. CAN VIEW
• BB. CAN EDIT
• CC. CAN MANAGE
• DD. CAN RUN

A data analyst needs a third-party weather dataset to enrich sales reports. The analyst wants to find and request the dataset from a provider without building an ingestion pipeline. Which Databricks feature should the analyst use?

• AA. Databricks Marketplace
• BB. Lakehouse Federation
• CC. Partner Connect
• DD. Auto Loader

A data analyst needs the total amount of orders placed since January 1, 2025 for each region, showing only regions whose total is greater than 10000, with the highest total first. Which query should the analyst run?

• AA. SELECT region, SUM(amount) AS total_amount FROM sales WHERE order_date >= '2025-01-01' AND SUM(amount) > 10000 GROUP BY region ORDER BY total_amount DESC;
• BB. SELECT region, SUM(amount) AS total_amount FROM sales WHERE order_date >= '2025-01-01' GROUP BY region HAVING SUM(amount) > 10000 ORDER BY total_amount DESC;
• CC. SELECT region, SUM(amount) AS total_amount FROM sales GROUP BY region HAVING order_date >= '2025-01-01' AND SUM(amount) > 10000 ORDER BY total_amount DESC;
• DD. SELECT region, SUM(amount) AS total_amount FROM sales WHERE order_date >= '2025-01-01' GROUP BY region HAVING SUM(amount) > 10000 ORDER BY total_amount;

A data analyst plans to change a column in the table sales_gold. Before doing so, the analyst wants to see which downstream notebooks and dashboards read from the table. Where in Catalog Explorer can the analyst find this information?

• AA. The Permissions tab of the table
• BB. The Insights tab of the schema
• CC. The Lineage tab of the table
• DD. The Sample Data tab of the table

A query in the SQL Editor returns the columns month (DATE), product_category (STRING) and revenue (DECIMAL). The analyst wants a line chart that shows how revenue changed over time, with a separate line for each product category. Which configuration should the analyst use?

• AA. X column: month; Y column: revenue; Group by: product_category
• BB. X column: month; Y column: product_category; Group by: revenue
• CC. X column: revenue; Y column: month; Group by: product_category
• DD. X column: product_category; Y column: revenue; Group by: month

A data analyst's session uses the catalog main. The analyst needs to join the table customers in main.crm with the table orders in the schema reporting of the catalog sales_prod, without changing the session defaults. Which query should the analyst run?

• AA. SELECT c.customer_id, o.order_total FROM main.crm.customers c JOIN sales_prod.reporting.orders o ON c.customer_id = o.customer_id;
• BB. SELECT c.customer_id, o.order_total FROM crm.customers c JOIN reporting.orders o ON c.customer_id = o.customer_id;
• CC. SELECT c.customer_id, o.order_total FROM main.customers c JOIN sales_prod.orders o ON c.customer_id = o.customer_id;
• DD. SELECT c.customer_id, o.order_total FROM main.crm.customers c JOIN reporting.sales_prod.orders o ON c.customer_id = o.customer_id;

The table orders has a column discount_pct that contains NULL values and some invalid values above 100. A data analyst must return every valid order, showing a NULL discount as 0 and excluding rows where the discount is above 100. Which query meets this requirement?

• AA. SELECT order_id, COALESCE(discount_pct, 0) AS discount_pct FROM orders WHERE discount_pct IS NOT NULL AND discount_pct <= 100;
• BB. SELECT order_id, COALESCE(discount_pct, 0) AS discount_pct FROM orders WHERE discount_pct <= 100 AND discount_pct IS NULL;
• CC. SELECT order_id, COALESCE(discount_pct, 0) AS discount_pct FROM orders WHERE discount_pct <= 100;
• DD. SELECT order_id, COALESCE(discount_pct, 0) AS discount_pct FROM orders WHERE COALESCE(discount_pct, 0) <= 100;

A data analyst is comparing two versions of a query on a SQL Warehouse. Repeated runs of the same statement return in under a second, and Query History shows that the result was served from the cache. Which statement should the analyst run in the session first so that each run reflects actual query execution?

• AA. SET use_cached_result = false;
• BB. REFRESH TABLE sales_orders;
• CC. ANALYZE TABLE sales_orders COMPUTE STATISTICS;
• DD. SET spark.databricks.io.cache.enabled = false;

The web_events table contains several billion rows. A data analyst needs a fast estimate of the number of distinct visitor_id values and will accept a maximum relative standard deviation of 5%. Which query should the analyst run?

• AA. SELECT COUNT(DISTINCT visitor_id, 0.05) FROM web_events;
• BB. SELECT approx_count_distinct(visitor_id, 5) FROM web_events;
• CC. SELECT approx_count_distinct(visitor_id, 0.95) FROM web_events;
• DD. SELECT approx_count_distinct(visitor_id, 0.05) FROM web_events;

A partner organization publishes a table that a data analyst needs to query without copying the data. Which Databricks feature provides secure read access to the shared table using an open protocol?

• AA. Delta Sharing
• BB. COPY INTO
• CC. Auto Loader
• DD. Lakehouse Federation