Databricks Certified Data Engineer Associate - Blueprint Practice Exam 1

1. A branch must run only when an upstream quality count exceeds a threshold. Which feature fits?
2. A bronze table should support later reprocessing after business rules change. Which design best supports this?
3. A daily revenue query should produce one row per region and day. Which operation is required?
4. A developer needs isolated feature work without changing the shared main branch. Which Git operation is appropriate?
5. A gold dataset precomputes regional daily totals for BI users. What is its primary purpose?
6. A governed external location connects cloud storage with authorization. What does it associate?
7. A job is slower after a change. Which evidence is most useful initially?
8. A job should start when new files arrive rather than at a fixed clock time. Which trigger is appropriate?
9. A multi-task job fails after its first task successfully writes output. What must retry design consider?
10. A nested events column contains an array that needs one output row per element. Which function is suitable?
11. A pipeline needs to ingest changes from a supported operational database through a managed connector. Which option should be evaluated?
12. A query needs duplicate rows preserved when combining two compatible datasets. Which SQL operation fits?
13. A recurring production job currently runs under a departing employee's identity. What is the best correction?
14. A shared analytics platform needs consistent governance across tables and workspaces. Which component is designed for this?
15. A silver layer should exclude records with missing mandatory order IDs. Which transformation is appropriate?
16. A source may send the same transaction in several different files. Why is file-level ingestion tracking insufficient?
17. A source provides nested JSON arrays and an ingestion timestamp is needed for lineage. What is appropriate?
18. A Spark task is much slower than its peers because one join key dominates the data. What should be investigated?
19. A standalone Auto Loader stream must resume after a restart. What should be preserved?
20. A table has many tiny data files and slow reads. Which operation is designed to reduce file fragmentation?
21. A target table needs existing customer rows updated and new customer rows inserted from one batch. Which operation fits?
22. A team needs to discover which upstream tables feed a governed reporting table. Which capability is relevant?
23. A team uses COPY INTO repeatedly to load new immutable files. What behavior supports incremental ingestion?
24. A team wants one codebase deployed to dev and prod with different catalog names. Which approach fits?
25. A team wants reliable tables on cloud storage with transactional updates and analytics access. Which technology supplies the transactional table layer?
26. A transformation casts malformed numeric text and needs to identify failures without aborting the query. Which approach is suitable?
27. A transformation must keep every customer, including those with no orders. Which join fits?
28. A transformation task must run only after ingestion succeeds. How should this be represented?
29. A transient network error should retry a task a bounded number of times. Which configuration is relevant?
30. A user has SELECT on a table but cannot traverse its parent catalog and schema. What additional privileges are typically needed?
31. A user should query a table but not modify it. Which grant is the most appropriate starting point?
32. An append-only batch contains duplicate rows by order_id. What does dropDuplicates(["order_id"]) address?
33. An engineer finds a production storage key embedded in a shared notebook. What should be done?
34. An engineer uses Auto Loader inside a managed Lakeflow pipeline. Which concern is commonly managed by the pipeline framework?
35. An executor runs out of memory while the driver remains healthy. What should the engineer inspect?
36. An ingestion stream encounters an unexpected source field. What should be planned explicitly?
37. New JSON files arrive continuously in a large cloud storage directory. Which source is designed for scalable incremental file discovery?
38. What should a CI pipeline do before deploying a Declarative Automation Bundle?
39. Which name identifies a Unity Catalog table using its standard three-level namespace?
40. Why should a deployment pipeline use a service principal rather than a shared personal token?

Comments — 0