Databricks - Data Engineer Associate Practice Questions & Free Practice Exam
5 free Databricks - Data Engineer Associate practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.
Default auto-termination on a freshly created all-purpose cluster matches which value?
Question 2
Vendor invoices land as PDFs in an S3 prefix that a third-party SaaS already populates outside Databricks. The pipeline must list those files at /Volumes/acme/bronze/invoices/ from a notebook, with access enforced through standard GRANT statements rather than IAM policy edits, and without copying any files. Which object satisfies the requirement?
Question 3
Teams that need an incremental SQL load from cloud storage with file deduplication tracked in the target Delta transaction log should reach for which primitive?
Question 4
SaaS sources delivering about 80,000 paginated REST responses per hour with a 30-minute freshness target must land in bronze. A Lakeflow Connect standard connector covers the source. The platform team values low maintenance, source-to-bronze lineage in Catalog Explorer, and the lowest operational cost among the choices. Which option meets all four constraints?
Question 5
During a join between a 3 TB fact table and a 75 MB dimension table, the Spark UI shows a SortMergeJoin shuffling the fact across the cluster. Stage time has grown beyond the SLA window. Which single change preserves correctness while skipping the shuffle on the fact side?
Ready for the full Databricks - Data Engineer Associate exam simulator?
Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.