100% Latest & Updated Databricks Certified Data Engineer Associate Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 210
A risk team needs all combinations of five scenario assumptions and six stress categories. Which setup step most directly realizes the proposed design?
- Validate the bounded dimensions and crossJoin the two small frames.
- Partition by customer_id, order by timestamp and event sequence descending, and keep row_number=1.
- Implement an amount >= 0 validation and define an explicit fail or quarantine action.
- Group the relevant rows and apply approx_count_distinct to device_id.
Explanation
Correct Answer
A:Validate the bounded dimensions and crossJoin the two small frames. The result contains exactly thirty combinations with no missing assumption-category pair.
Incorrect Answers
B:When a customer dataset must retain the latest update per business key even when events arrive out of order, “Partition by customer_id, order by timestamp and event sequence descending, and keep row_number=1” could be relevant. Validate the bounded dimensions and crossJoin the two small frames.
C:If a payments silver table must never have negative approved transaction amounts, “Implement an amount >= 0 validation and define an explicit fail or quarantine action” may be the appropriate response. Validate the bounded dimensions and crossJoin the two small frames.
D:A reporting table must count unique devices across billions of events with an acceptable approximation. In those circumstances, “Group the relevant rows and apply approx_count_distinct to device_id” fits. Validate the bounded dimensions and crossJoin the two small frames.
Question 211
A risk team needs all combinations of five scenario assumptions and six stress categories. What is the most relevant verification evidence for this case?
- The impossible reading is segregated, valid floats remain queryable, and counts reconcile with bronze.
- A known input yields the expected two columns and malformed records are accounted for.
- Repeated dashboard queries read the materialized result and updates follow the refresh SLA.
- The result contains exactly thirty combinations with no missing assumption-category pair.
Explanation
Correct Answer
D:The result contains exactly thirty combinations with no missing assumption-category pair.
Incorrect Answers
A:When an IoT bronze dataset contains temperatures as strings and an impossible reading that must not contaminate hourly gold summaries, “The impossible reading is segregated, valid floats remain queryable, and counts reconcile with bronze” could be relevant. The result contains exactly thirty combinations with no missing assumption-category pair.
B:If a source field packs a city and postal code with a single pipe delimiter, “A known input yields the expected two columns and malformed records are accounted for” may be the appropriate response. The result contains exactly thirty combinations with no missing assumption-category pair.
C:A busy BI dashboard repeatedly runs an expensive grouped query and tolerates refresh-based staleness. In those circumstances, “Repeated dashboard queries read the materialized result and updates follow the refresh SLA” fits. The result contains exactly thirty combinations with no missing assumption-category pair.
Question 212
A risk team needs all combinations of five scenario assumptions and six stress categories. The team observes: The result has fewer than thirty combinations despite complete inputs. What is the most likely mechanism behind the observed defect?
- An equijoin or filtering condition unintentionally removed Cartesian pairs.
- The job counted raw messages without key-level deduplication.
- The silver transformation joined rates without the effective-date condition.
- The denominator included rows without a valid numeric price.
Explanation
Correct Answer
A:An equijoin or filtering condition unintentionally removed Cartesian pairs. Validate the bounded dimensions and crossJoin the two small frames.
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. An equijoin or filtering condition unintentionally removed Cartesian pairs.
C:When 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” could be relevant. An equijoin or filtering condition unintentionally removed Cartesian pairs.
D:If a sales dashboard needs mean transaction value per region while excluding null prices, “The denominator included rows without a valid numeric price” may be the appropriate response. An equijoin or filtering condition unintentionally removed Cartesian pairs.
Question 213
A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. Which approach most directly satisfies the requirement?
- Parse timestamps with an agreed zone convention and preserve the original raw value for audit.
- Evaluate the supported input and execution partitioning strategy for available parallelism.
- Use a documented data quality constraint with a quarantine or reject accounting strategy.
- Explode the product-code array into one output row per array element.
Explanation
Correct Answer
D:Explode the product-code array into one output row per array element. An order with four items creates four rows with the correct shared order_id.
Incorrect Answers
A:A payroll bronze table has event timestamps saved as arbitrary text from two time zones. In those circumstances, “Parse timestamps with an agreed zone convention and preserve the original raw value for audit” fits. Explode the product-code array into one output row per array element.
B:When a Spark job has many tiny input partitions and inefficient parallel task utilization, “Evaluate the supported input and execution partitioning strategy for available parallelism” could be relevant. Explode the product-code array into one output row per array element.
C:If a silver quality gate must reject records missing a transaction identifier, but analysts still need an error count, “Use a documented data quality constraint with a quarantine or reject accounting strategy” may be the appropriate response. Explode the product-code array into one output row per array element.
Question 214
A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. Which configuration or engineering action would most directly implement the requirement?
- Read the bronze Delta table with PySpark, use explicit casts and normalization, quarantine invalid keys, and write a separate governed silver table.
- Use try_cast or a controlled parser, range predicates, and a quarantined invalid-record output before saving silver.
- Supply both key equality predicates to the Spark join condition.
- Apply explode to the array and retain the parent order identifier in each generated row.
Explanation
Correct Answer
D:Apply explode to the array and retain the parent order identifier in each generated row. An order with four items creates four rows with the correct shared order_id.
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, “Read the bronze Delta table with PySpark, use explicit casts and normalization, quarantine invalid keys, and write a separate governed silver table” could be relevant. Apply explode to the array and retain the parent order identifier in each generated row.
B:If an IoT bronze dataset contains temperatures as strings and an impossible reading that must not contaminate hourly gold summaries, “Use try_cast or a controlled parser, range predicates, and a quarantined invalid-record output before saving silver” may be the appropriate response. Apply explode to the array and retain the parent order identifier in each generated row.
C:A customer match requires both organization identifier and customer identifier, since a customer number is reused by different businesses. In those circumstances, “Supply both key equality predicates to the Spark join condition” fits. Apply explode to the array and retain the parent order identifier in each generated row.
Question 215
A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. Which test would establish that the change worked as intended?
- A sample with two completed and one failed delivery reports 2 complete of 3 attempted.
- The executed plan shows a broadcast join and no large dimension repartition overhead.
- An order with four items creates four rows with the correct shared order_id.
- Equivalent instants from different offsets compare equal and raw source text remains available.
Explanation
Correct Answer
C:An order with four items creates four rows with the correct shared order_id.
Incorrect Answers
A:If a service operations report must count completed deliveries separately from all attempted deliveries, “A sample with two completed and one failed delivery reports 2 complete of 3 attempted” may be the appropriate response. An order with four items creates four rows with the correct shared order_id.
B:A small static country table enriches a huge events DataFrame and a large shuffle must be avoided when eligible. In those circumstances, “The executed plan shows a broadcast join and no large dimension repartition overhead” fits. An order with four items creates four rows with the correct shared order_id.
D:If a payroll bronze table has event timestamps saved as arbitrary text from two time zones, “Equivalent instants from different offsets compare equal and raw source text remains available” may be the appropriate response. An order with four items creates four rows with the correct shared order_id.
Question 216
A line-item DataFrame contains an array of product codes per order and downstream rows must be per product. The team observes: The flattened table has just one row for a four-item order. Which configuration or design gap best explains the symptom?
- Partitioning is too coarse for the available worker parallelism.
- The transform interpreted local clock text without its source offset.
- Invalid numeric values passed through or were coerced incorrectly rather than isolated at silver.
- The transform stored the whole array as a scalar rather than expanding it.
Explanation
Correct Answer
D:The transform stored the whole array as a scalar rather than expanding it. Apply explode to the array and retain the parent order identifier in each generated row.
Incorrect Answers
A:A Spark job has many tiny input partitions and inefficient parallel task utilization. In those circumstances, “Partitioning is too coarse for the available worker parallelism” fits. The transform stored the whole array as a scalar rather than expanding it.
B:When a payroll bronze table has event timestamps saved as arbitrary text from two time zones, “The transform interpreted local clock text without its source offset” could be relevant. The transform stored the whole array as a scalar rather than expanding it.
C: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 transform stored the whole array as a scalar rather than expanding it.
Question 217
A source field packs a city and postal code with a single pipe delimiter. Which architecture or engineering decision best fits this scenario?
- Use a streaming table or incremental pipeline target rather than a manually overwritten static table.
- Keep all landing events in bronze while writing validated and keyed latest records into silver.
- Use an approximate distinct-count aggregate when the agreed error tolerance allows it.
- Split the field into separate city and postal-code columns with a validated schema.
Explanation
Correct Answer
D:Split the field into separate city and postal-code columns with a validated schema. A known input yields the expected two columns and malformed records are accounted for.
Incorrect Answers
A:When a downstream pipeline needs incremental consumption of a continuous events feed into a governed table, “Use a streaming table or incremental pipeline target rather than a manually overwritten static table” could be relevant. Split the field into separate city and postal-code columns with a validated schema.
B:If a health feed has duplicate late-arrival patient observations but raw arrivals must remain reviewable, “Keep all landing events in bronze while writing validated and keyed latest records into silver” may be the appropriate response. Split the field into separate city and postal-code columns with a validated schema.
C:A reporting table must count unique devices across billions of events with an acceptable approximation. In those circumstances, “Use an approximate distinct-count aggregate when the agreed error tolerance allows it” fits. Split the field into separate city and postal-code columns with a validated schema.
Question 218
A source field packs a city and postal code with a single pipe delimiter. Which implementation step is most appropriate before production use?
- Join by currency and effective date, reject unmatched rates, and create typed base-currency amount columns.
- Apply a documented timestamp parser and timezone normalization while writing typed silver columns.
- Use split with the literal delimiter, trim both elements, and handle malformed input explicitly.
- Apply the supported broadcast hint to the small dimension on a compatible equijoin.
Explanation
Correct Answer
C:Use split with the literal delimiter, trim both elements, and handle malformed input explicitly. A known input yields the expected two columns and malformed records are accounted for.
Incorrect Answers
A:If a marketing bronze feed arrives with mixed currency columns, but conversion rates are supplied in a governed reference table, “Join by currency and effective date, reject unmatched rates, and create typed base-currency amount columns” may be the appropriate response. Use split with the literal delimiter, trim both elements, and handle malformed input explicitly.
B:A payroll bronze table has event timestamps saved as arbitrary text from two time zones. In those circumstances, “Apply a documented timestamp parser and timezone normalization while writing typed silver columns” fits. Use split with the literal delimiter, trim both elements, and handle malformed input explicitly.
D:If a small static country table enriches a huge events DataFrame and a large shuffle must be avoided when eligible, “Apply the supported broadcast hint to the small dimension on a compatible equijoin” may be the appropriate response. Use split with the literal delimiter, trim both elements, and handle malformed input explicitly.
Question 219
A source field packs a city and postal code with a single pipe delimiter. Which acceptance test provides the strongest evidence that the intended outcome has been achieved?
- Each observation key has one selected silver version and inspectors can find every original bronze arrival.
- An audit sample reproduces each converted value using the effective-date exchange rate.
- A known input yields the expected two columns and malformed records are accounted for.
- The two state spellings group together and optional phone absence does not reject otherwise valid customers.
Explanation
Correct Answer
C:A known input yields the expected two columns and malformed records are accounted for.
Incorrect Answers
A:A health feed has duplicate late-arrival patient observations but raw arrivals must remain reviewable. In those circumstances, “Each observation key has one selected silver version and inspectors can find every original bronze arrival” fits. A known input yields the expected two columns and malformed records are accounted for.
B:When a marketing bronze feed arrives with mixed currency columns, but conversion rates are supplied in a governed reference table, “An audit sample reproduces each converted value using the effective-date exchange rate” could be relevant. A known input yields the expected two columns and malformed records are accounted for.
D:A CRM ingestion contains two representations of the same state name and optional phone fields that are sometimes null. In those circumstances, “The two state spellings group together and optional phone absence does not reject otherwise valid customers” fits. A known input yields the expected two columns and malformed records are accounted for.
Question 220
A source field packs a city and postal code with a single pipe delimiter. The team observes: The postal code retains the city prefix after transformation. Which root cause should be addressed first given this evidence?
- The quality transform filtered rows without recording rejected records.
- An inner join unintentionally dropped unmatched left rows.
- The split expression or output indexing was incorrect.
- The pipeline used duplicate-eliminating UNION rather than UNION ALL semantics.
Explanation
Correct Answer
C:The split expression or output indexing was incorrect. Use split with the literal delimiter, trim both elements, and handle malformed input explicitly.
Incorrect Answers
A:When a silver quality gate must reject records missing a transaction identifier, but analysts still need an error count, “The quality transform filtered rows without recording rejected records” could be relevant. The split expression or output indexing was incorrect.
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 split expression or output indexing was incorrect.
D:When two quarterly datasets have identical columns but their records must be vertically appended and duplicates preserved, “The pipeline used duplicate-eliminating UNION rather than UNION ALL semantics” could be relevant. The split expression or output indexing was incorrect.
Certified Data Engineer Associate Practice Tests