100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 230
An account table has three irrelevant vendor-internal columns that must not reach the published silver table. Which configuration or engineering action would most directly implement the requirement?
- Join accounts LEFT OUTER JOIN payments on account_id and preserve missing payment fields.
- Use dropDuplicates on event_id after defining the desired event window or batch boundary.
- Group by service area and aggregate conditional SUM for completed rows and COUNT for attempts.
- Use select on an allowlist or drop the disallowed columns before writing the table.
Explanation
Correct Answer
D:Use select on an allowlist or drop the disallowed columns before writing the table. The published schema contains only the approved fields despite extra bronze columns.
Incorrect Answers
A:If a subscriptions dataset must preserve every account even when no payment has arrived, “Join accounts LEFT OUTER JOIN payments on account_id and preserve missing payment fields” may be the appropriate response. Use select on an allowlist or drop the disallowed columns before writing the table.
B:A click event feed contains retries with identical event_id and should count each business event once. In those circumstances, “Use dropDuplicates on event_id after defining the desired event window or batch boundary” fits. Use select on an allowlist or drop the disallowed columns before writing the table.
C:When a service operations report must count completed deliveries separately from all attempted deliveries, “Group by service area and aggregate conditional SUM for completed rows and COUNT for attempts” could be relevant. Use select on an allowlist or drop the disallowed columns before writing the table.
Question 231
An account table has three irrelevant vendor-internal columns that must not reach the published silver table. Which test would establish that the change worked as intended?
- The published schema contains only the approved fields despite extra bronze columns.
- The approximate count is within the accepted tolerance of an exact sample benchmark.
- Spill bytes and wall time improve in a comparable run without OOM errors.
- The result contains exactly thirty combinations with no missing assumption-category pair.
Explanation
Correct Answer
A:The published schema contains only the approved fields despite extra bronze columns.
Incorrect Answers
B:When a reporting table must count unique devices across billions of events with an acceptable approximation, “The approximate count is within the accepted tolerance of an exact sample benchmark” could be relevant. The published schema contains only the approved fields despite extra bronze columns.
C:If a large join spills to disk repeatedly although executor memory pressure is high, “Spill bytes and wall time improve in a comparable run without OOM errors” may be the appropriate response. The published schema contains only the approved fields despite extra bronze columns.
D:A risk team needs all combinations of five scenario assumptions and six stress categories. In those circumstances, “The result contains exactly thirty combinations with no missing assumption-category pair” fits. The published schema contains only the approved fields despite extra bronze columns.
Question 232
An account table has three irrelevant vendor-internal columns that must not reach the published silver table. The team observes: A newly added internal debugging field appears in silver automatically. Which configuration or design gap best explains the symptom?
- The pipeline wrote raw strings and permitted null business keys into silver without validation.
- An inner join unintentionally dropped unmatched left rows.
- The quality transform filtered rows without recording rejected records.
- The transformation used SELECT * or passed through all source fields.
Explanation
Correct Answer
D:The transformation used SELECT * or passed through all source fields. Use select on an allowlist or drop the disallowed columns before writing the table.
Incorrect Answers
A:When a retail bronze orders table contains string totals, inconsistent country codes and missing order identifiers before a silver SLA can begin, “The pipeline wrote raw strings and permitted null business keys into silver without validation” could be relevant. The transformation used SELECT * or passed through all source fields.
B:If a subscriptions dataset must preserve every account even when no payment has arrived, “An inner join unintentionally dropped unmatched left rows” may be the appropriate response. The transformation used SELECT * or passed through all source fields.
C:A silver quality gate must reject records missing a transaction identifier, but analysts still need an error count. In those circumstances, “The quality transform filtered rows without recording rejected records” fits. The transformation used SELECT * or passed through all source fields.
Question 233
A bronze telemetry table must expose only current readings above a threshold for a dashboard. Which architecture or engineering decision best fits this scenario?
- Apply a business-rule assertion before promoting data to silver or gold.
- Apply a row filter with a typed comparison before serving the data.
- Standardize state labels and treat an optional null independently of required identity fields.
- Validate source-to-target row and amount reconciliation at the business grain.
Explanation
Correct Answer
B:Apply a row filter with a typed comparison before serving the data. Every returned row satisfies the threshold and timestamp freshness condition.
Incorrect Answers
A:If a payments silver table must never have negative approved transaction amounts, “Apply a business-rule assertion before promoting data to silver or gold” may be the appropriate response. Apply a row filter with a typed comparison before serving the data.
C:When a CRM ingestion contains two representations of the same state name and optional phone fields that are sometimes null, “Standardize state labels and treat an optional null independently of required identity fields” could be relevant. Apply a row filter with a typed comparison before serving the data.
D:If an insurance gold fact table combines multiple silver sources with different dates and must remain reconcilable, “Validate source-to-target row and amount reconciliation at the business grain” may be the appropriate response. Apply a row filter with a typed comparison before serving the data.
Question 234
A bronze telemetry table must expose only current readings above a threshold for a dashboard. Which implementation step is most appropriate before production use?
- Create the appropriate Unity Catalog view with an explicit stable SELECT.
- Select compatible columns and apply unionByName with an explicit schema contract.
- Cast the measurement to numeric and use filter on the validated threshold predicate.
- Compare approved source totals and unique keys to the aggregated gold results under the same time window.
Explanation
Correct Answer
C:Cast the measurement to numeric and use filter on the validated threshold predicate. Every returned row satisfies the threshold and timestamp freshness condition.
Incorrect Answers
A:A finance dashboard reads a curated metric that should always reflect the latest base table without storing a separately maintained aggregate. In those circumstances, “Create the appropriate Unity Catalog view with an explicit stable SELECT” fits. Cast the measurement to numeric and use filter on the validated threshold predicate.
B:When two quarterly datasets have identical columns but their records must be vertically appended and duplicates preserved, “Select compatible columns and apply unionByName with an explicit schema contract” could be relevant. Cast the measurement to numeric and use filter on the validated threshold predicate.
D:An insurance gold fact table combines multiple silver sources with different dates and must remain reconcilable. In those circumstances, “Compare approved source totals and unique keys to the aggregated gold results under the same time window” fits. Cast the measurement to numeric and use filter on the validated threshold predicate.
Question 235
A bronze telemetry table must expose only current readings above a threshold for a dashboard. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?
- The accepted plus rejected counts reconcile to the original source batch.
- Two payload retries with the same event identifier contribute one event to the count.
- Every returned row satisfies the threshold and timestamp freshness condition.
- Sample control totals match by period and partition without unexplained duplicate keys.
Explanation
Correct Answer
C:Every returned row satisfies the threshold and timestamp freshness condition.
Incorrect Answers
A:When a silver quality gate must reject records missing a transaction identifier, but analysts still need an error count, “The accepted plus rejected counts reconcile to the original source batch” could be relevant. Every returned row satisfies the threshold and timestamp freshness condition.
B:If a click event feed contains retries with identical event_id and should count each business event once, “Two payload retries with the same event identifier contribute one event to the count” may be the appropriate response. Every returned row satisfies the threshold and timestamp freshness condition.
D:When an insurance gold fact table combines multiple silver sources with different dates and must remain reconcilable, “Sample control totals match by period and partition without unexplained duplicate keys” could be relevant. Every returned row satisfies the threshold and timestamp freshness condition.
Question 236
A bronze telemetry table must expose only current readings above a threshold for a dashboard. The team observes: Lexical string comparison lets a low numeric reading through the threshold. Which root cause should be addressed first given this evidence?
- The filter compared string values or omitted the intended predicate.
- The job counted raw messages without key-level deduplication.
- A batch overwrite replaced the persistent incremental streaming target.
- Invalid numeric values passed through or were coerced incorrectly rather than isolated at silver.
Explanation
Correct Answer
A:The filter compared string values or omitted the intended predicate. Cast the measurement to numeric and use filter on the validated threshold predicate.
Incorrect Answers
B:A click event feed contains retries with identical event_id and should count each business event once. In those circumstances, “The job counted raw messages without key-level deduplication” fits. The filter compared string values or omitted the intended predicate.
C:When a downstream pipeline needs incremental consumption of a continuous events feed into a governed table, “A batch overwrite replaced the persistent incremental streaming target” could be relevant. The filter compared string values or omitted the intended predicate.
D:If an IoT bronze dataset contains temperatures as strings and an impossible reading that must not contaminate hourly gold summaries, “Invalid numeric values passed through or were coerced incorrectly rather than isolated at silver” may be the appropriate response. The filter compared string values or omitted the intended predicate.
Question 237
A click event feed contains retries with identical event_id and should count each business event once. Which technical design is most appropriate for the stated constraint?
- Explode the product-code array into one output row per array element.
- Standardize state labels and treat an optional null independently of required identity fields.
- Deduplicate on the stable event_id rather than the entire raw row.
- Tune shuffle partition count using observed data volume and task metrics rather than a fixed guess.
Explanation
Correct Answer
C:Deduplicate on the stable event_id rather than the entire raw row. Two payload retries with the same event identifier contribute one event to the count.
Incorrect Answers
A:A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. In those circumstances, “Explode the product-code array into one output row per array element” fits. Deduplicate on the stable event_id rather than the entire raw row.
B:When a CRM ingestion contains two representations of the same state name and optional phone fields that are sometimes null, “Standardize state labels and treat an optional null independently of required identity fields” could be relevant. Deduplicate on the stable event_id rather than the entire raw row.
D:A heavily shuffled ETL join creates thousands of tiny shuffle partitions while tasks spend time scheduling. In those circumstances, “Tune shuffle partition count using observed data volume and task metrics rather than a fixed guess” fits. Deduplicate on the stable event_id rather than the entire raw row.
Question 238
A click event feed contains retries with identical event_id and should count each business event once. Which action should the engineer perform to establish the intended control?
- Join accounts LEFT OUTER JOIN payments on account_id and preserve missing payment fields.
- Use dropDuplicates on event_id after defining the desired event window or batch boundary.
- Apply explode to the array and retain the parent order identifier in each generated row.
- Use withColumnRenamed or an equivalent SELECT alias and update the governed silver target.
Explanation
Correct Answer
B:Use dropDuplicates on event_id after defining the desired event window or batch boundary. Two payload retries with the same event identifier contribute one event to the count.
Incorrect Answers
A:When a subscriptions dataset must preserve every account even when no payment has arrived, “Join accounts LEFT OUTER JOIN payments on account_id and preserve missing payment fields” could be relevant. Use dropDuplicates on event_id after defining the desired event window or batch boundary.
C:A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. In those circumstances, “Apply explode to the array and retain the parent order identifier in each generated row” fits. Use dropDuplicates on event_id after defining the desired event window or batch boundary.
D:When a customer schema is changing from old_customer_id to customer_id while dashboards expect the new name, “Use withColumnRenamed or an equivalent SELECT alias and update the governed silver target” could be relevant. Use dropDuplicates on event_id after defining the desired event window or batch boundary.
Question 239
A click event feed contains retries with identical event_id and should count each business event once. Which observation best proves the workload meets its requirement?
- The published schema contains only the approved fields despite extra bronze columns.
- An audit sample reproduces each converted value using the effective-date exchange rate.
- Two payload retries with the same event identifier contribute one event to the count.
- The combined row count equals the sum of both inputs when no filter is applied.
Explanation
Correct Answer
C:Two payload retries with the same event identifier contribute one event to the count.
Incorrect Answers
A:If an account table has three irrelevant vendor-internal columns that must not reach the published silver table, “The published schema contains only the approved fields despite extra bronze columns” may be the appropriate response. Two payload retries with the same event identifier contribute one event to the count.
B:A marketing bronze feed arrives with mixed currency columns, but conversion rates are supplied in a governed reference table. In those circumstances, “An audit sample reproduces each converted value using the effective-date exchange rate” fits. Two payload retries with the same event identifier contribute one event to the count.
D:If two quarterly datasets have identical columns but their records must be vertically appended and duplicates preserved, “The combined row count equals the sum of both inputs when no filter is applied” may be the appropriate response. Two payload retries with the same event identifier contribute one event to the count.
Question 240
A click event feed contains retries with identical event_id and should count each business event once. The team observes: Retry duplicates inflate the unique-event dashboard count. Which underlying cause most directly explains this failure?
- The transform stored the whole array as a scalar rather than expanding it.
- The transformation used SELECT * or passed through all source fields.
- The silver transformation joined rates without the effective-date condition.
- The job counted raw messages without key-level deduplication.
Explanation
Correct Answer
D:The job counted raw messages without key-level deduplication. Use dropDuplicates on event_id after defining the desired event window or batch boundary.
Incorrect Answers
A:A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. In those circumstances, “The transform stored the whole array as a scalar rather than expanding it” fits. The job counted raw messages without key-level deduplication.
B:When an account table has three irrelevant vendor-internal columns that must not reach the published silver table, “The transformation used SELECT * or passed through all source fields” could be relevant. The job counted raw messages without key-level deduplication.
C:If a marketing bronze feed arrives with mixed currency columns, but conversion rates are supplied in a governed reference table, “The silver transformation joined rates without the effective-date condition” may be the appropriate response. The job counted raw messages without key-level deduplication.
Certified Data Engineer Associate Practice Tests