Databricks Certified Data Analyst Associate - Full Practice Exam 1

1. A business analyst needs to discover a shared third-party dataset offered through the Databricks ecosystem. Which feature is designed for this discovery?
2. A customer staging table has multiple records per customer_id. Each has an updated_at timestamp and a unique ingestion_id. Keep the latest timestamp, breaking ties with the highest ingestion_id. Which approach is deterministic?
3. A customers table has one row per customer. An orders table may have no rows for a customer. Which join preserves every customer while attaching matching orders?
4. A dashboard includes a dataset query and a region filter, but the filter does not affect a particular chart. What should be checked first?
5. A dashboard should repeatedly read a stored result of an expensive aggregate query that is refreshed through a managed process. Which object fits this requirement?
6. A dashboard viewer should select a region and have that value affect the underlying SQL query. Which approach is appropriate?
7. A finance team uses the phrase net sales to mean revenue minus returns, excluding tax. Its Genie space interprets the phrase inconsistently. What should the owner add?
8. A finance team wants to understand which upstream tables feed an unfamiliar revenue table before using its totals. What should the analyst inspect first?
9. A Genie response returns a plausible revenue total, but stakeholders report it differs from their validated report. What should the analyst do first?
10. A historical revenue report changed after late corrections. Delta table history still retains version 42, which was used by the original report. Which query best isolates the change while keeping the report logic constant?
11. A lakehouse separates raw source records, cleaned and conformed records, and business aggregates. Where do curated sales KPIs typically belong in this medallion pattern?
12. A manager asks for a contractor's read access to be removed at the end of the engagement. What should the administrator verify?
13. A monitoring query returns the number of failed payments in the last hour. The team needs a notification when the value exceeds 50. What should be configured?
14. A new Genie space has access to hundreds of unrelated tables and produces ambiguous joins. What is an appropriate improvement?
15. A partner needs governed read access to a dataset from its own environment without routine manual CSV transfers. Which Databricks capability is designed for cross-platform data sharing?
16. A payroll view is shared with analysts. They need its approved columns but must not access the raw payroll table. Which grant design best meets this requirement?
17. A query has a substantial slowdown after a recent change. Which evidence best identifies expensive execution stages before tuning?
18. A query is slow because a join multiplies each order by every matching historical address for its customer. What should the analyst investigate first?
19. A query over a large Delta table repeatedly filters by customer_id, and scans far more files than needed. The team is considering a physical layout improvement. Which option is relevant?
20. A sales dashboard must show monthly revenue trends across two years. Which visualization most directly communicates the change over time?
21. A sales table stores missing discount values as NULL. The agreed business rule is to treat missing discounts as zero in a calculation without altering stored rows. Which expression fits?
22. A support team should see operational ticket details but not the full customer tax identifier. What is an appropriate data access design?
23. A table contains multiple transactions for each account. The analyst needs one row per account with the total transaction amount. Which query pattern is appropriate?
24. A table has rows with amounts 20, NULL, and 40. What does SELECT COUNT(*), COUNT(amount) FROM the table return?
25. A team needs ACID transactions and versioned table changes on data stored in cloud object storage. Which technology provides this table-level foundation in Databricks?
26. A team stores raw files in its own S3 bucket and registers them as an external Unity Catalog table. Which statement correctly distinguishes this from a managed table?
27. A team wants stakeholders to receive refreshed dashboard data every morning without an author opening it manually. What should be configured?
28. A team wants to know whether Photon could improve a supported SQL analytical workload. Which statement correctly characterizes Photon?
29. A team wants users to query sales data conversationally while preserving existing data authorization. Which statement is correct?
30. A valid historical Delta table version and all required data files are retained. Which syntax reads version 12?
31. A warehouse model has a central sales fact table connected to customer, product, and date dimensions. What model is this?
32. An analyst changes a dashboard draft and wants consumers to see the reviewed changes. What should the analyst do?
33. An analyst must inspect the sequence of commits and operations performed on a Delta table. Which command is appropriate?
34. An analyst must read finance.reporting.monthly_sales through Unity Catalog and has no relevant existing grants. Which privilege set is appropriate for basic table querying?
35. An analyst must standardize a region field by removing leading and trailing spaces and converting letters to uppercase. Which expression fits?
36. An analyst needs customers that have no matching orders. Which join directly expresses this requirement?
37. An analyst needs departments whose total expenses exceed 100000 after grouping expense rows by department. Which clause filters the aggregate result?
38. An analyst needs one governance layer for permissions, discovery, and lineage across Databricks tables. Which platform component addresses this need?
39. An analyst needs scalable compute to run SQL editor queries against governed tables. Which Databricks resource supplies this compute?
40. An analyst sees a table in Catalog Explorer but receives an authorization error when querying it. What is the best explanation?
41. An analyst tests a dashboard with no matching rows for a filter selection. What should the analyst verify before sharing it?
42. An owner wants to assess whether a Genie space answers recurring business questions correctly after configuration changes. What should be maintained?
43. Orders contain tenant_id and order_id; order_id is unique only within a tenant. Lines contain the same keys. Joining on order_id alone doubles some totals. What is the best correction?
44. Thousands of new JSON files arrive continuously in cloud object storage. The ingestion pipeline must discover new files incrementally rather than reload the whole directory each run. Which capability fits?
45. Two compatible query results contain duplicate rows that must all be retained when combined. Which operation is appropriate?

Comments — 0