McAfee Secured

Databricks Certified Data Engineer Associate Bundle

Exam Code: Certified Data Engineer Associate

Exam Name Certified Data Engineer Associate

Certification Provider: Databricks

Corresponding Certification: Databricks Certified Data Engineer Associate

Databricks Certified Data Engineer Associate Bundle $44.99

Pass Databricks Certified Data Engineer Associate with Real Questions From Testking

Download Web's Best Certified Data Engineer Associate Exam Preparation Materials Today

  • Questions & Answers

    Certified Data Engineer Associate Questions & Answers

    280 Questions & Answers

    Questions & Answers Testing Engine software allows you to practice questions and answers in real Certified Data Engineer Associate exam environment.

  • Certified Data Engineer Associate Video Course

    Certified Data Engineer Associate Video Course

    38 Video Lectures

    Certified Data Engineer Associate Video Course is developed by Databricks Professionals to help you pass Certified Data Engineer Associate exam.

    Description

    This course will improve your knowledge and skills required to pass Certified Data Engineer Associate exam.
  • Study Guide

    Certified Data Engineer Associate Study Guide

    432 PDF Pages

    Study Guide will give you a practical experience regarding the subject and provide an academic background. Certified Data Engineer Associate Study Guide is available in PDF format.

Certified Data Engineer Associate Practice Tests

Satisfaction Guaranteed

Money Back Guarantee

Testking provides hassle-free money back guarantee with our products. That is because we have 100% trust in the abilities of our professional and experience product team, and our record is a proof of that.

99.6% PASS RATE
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • Questions & Answers

    Questions & Answers

    280 Questions

    $124.99
  • Certified Data Engineer Associate Video Course

    Video Course

    38 Video Lectures

    $39.99
  • Study Guide

    Study Guide

    432 PDF Pages

    $29.99

Databricks Certified Data Engineer Associate Practice Test 20

Question 190

A cleaning notebook must normalize nullable country fields to an explicit "unknown" category while keeping known country values unchanged. Which expression fits?

  1. coalesce(col("country"), lit("unknown"))
  2. orderBy("country")
  3. countDistinct("country")
  4. dropna(subset=["country"])

Explanation

Correct Answer

A:

coalesce chooses the existing non-null country value and otherwise emits the specified default.

Incorrect Answers

B:

Sorting does not change nulls into the desired category.

C:

Distinct count summarizes countries rather than filling row-level null values.

D:

Dropping null-country rows loses them instead of supplying the requested explicit category.

Question 191

A data quality check must ensure `amount >= 0` on a curated dataset. Which action meets the stated rule without silently changing invalid source values?

  1. Cast all negative values to their absolute value before quality testing
  2. Ignore the quality rule when a job succeeds
  3. Multiply every negative value by -1
  4. Flag or quarantine rows where amount is negative and publish validated rows

Explanation

Correct Answer

D:

An explicit predicate separates violations and avoids inventing replacement values.

Incorrect Answers

A:

Taking absolute values changes invalid source amounts silently rather than identifying negative amounts for quarantine and review.

B:

Technical execution success does not establish compliance with business-domain constraints.

C:

Turning invalid refunds or data errors into positive values changes business meaning without review.

Question 192

A gold metric requires the number of unique invoice IDs per day, not the number of billed line items. Which aggregation is correct?

  1. groupBy(date).agg(countDistinct("invoice_id"))
  2. groupBy(date).agg(count("invoice_id"))
  3. groupBy(date).agg(sum("invoice_id"))
  4. groupBy(date).agg(max("invoice_id"))

Explanation

Correct Answer

A:

Distinct invoice count prevents multiple line items from inflating per-day invoice totals.

Incorrect Answers

B:

A raw row count double-counts invoices that have multiple lines.

C:

Summing identifier values has no meaningful invoice-cardinality semantics.

D:

Maximum identifier is not the count of unique invoices.

Question 193

A large ETL joins a small product dimension to an enormous purchase fact. The query unexpectedly shuffles both sides. What optimization should be evaluated?

  1. Converting numeric product IDs into free-text descriptions
  2. A forced cross join of dimension and fact
  3. A supported broadcast hint on the small dimension
  4. Repartitioning the large fact into one partition

Explanation

Correct Answer

C:

Broadcasting the small side can avoid a two-sided shuffle when memory and join conditions allow it.

Incorrect Answers

A:

Changing join keys into text does not resolve the shuffling root cause.

B:

Cross join multiplies records and usually increases processing cost.

D:

Single-partition execution can severely reduce throughput.

Question 194

A data engineer has a Spark DataFrame with a `metrics` struct containing `cpu` and `memory`. The silver output needs a top-level `cpu` field. Which expression fits?

  1. orderBy("metrics")
  2. count("metrics")
  3. col("metrics.cpu").alias("cpu")
  4. explode("metrics")

Explanation

Correct Answer

C:

Dot-field access extracts the nested struct field into a separately named output column.

Incorrect Answers

A:

Sorting a struct does not create a top-level cpu column.

B:

COUNT measures non-null structs, not the cpu attribute.

D:

explode expects an array or map rather than a scalar struct in this case.

Question 195

A table stores repeated string tags separated by commas in one field. The output needs one row per tag for each original record. Which sequence is suitable?

  1. split the string into an array then explode that array
  2. countDistinct on the original string
  3. LEFT ANTI JOIN with the same table
  4. Use split() to keep the array as one nested column without exploding it into multiple rows

Explanation

Correct Answer

A:

Split constructs elements from the delimiter and explode emits a row for each element.

Incorrect Answers

B:

Distinct string count does not produce a per-tag row representation.

C:

An anti join detects missing key matches rather than parsing and expanding tags.

D:

Splitting creates array elements but cannot by itself produce the requested separate output row for each tag.

Question 196

A customer dimension and an order fact both contain an `id` field with different meanings. What should the engineer do to avoid an accidental ambiguous join?

  1. Use CROSS JOIN with no conditions
  2. Alias each DataFrame and join on the explicit intended customer key
  3. Drop all ID columns before joining
  4. Join on every column named id without checking semantics

Explanation

Correct Answer

B:

Qualified references make the join predicate unambiguous and preserve the correct key relationship.

Incorrect Answers

A:

This would multiply rows instead of matching customers.

C:

Removing identifiers prevents the required customer relationship.

D:

Same column names do not guarantee they represent the same business key.

Question 197

A gold dataset should always reflect a current silver Delta table but analysts must not receive a separately stored refreshed copy. Which object is appropriate?

  1. A manually exported CSV file
  2. A disconnected notebook result table
  3. A materialized view when no stored results are permitted
  4. A governed SQL view over the silver table

Explanation

Correct Answer

D:

A standard view exposes a query definition and reads the current underlying data at query time.

Incorrect Answers

A:

An exported file is an independent snapshot and may become stale.

B:

Notebook output does not provide the requested governed live SQL view.

C:

Materialized views maintain computed results and may not satisfy the no-materialization requirement.

Question 198

A BI model executes a costly stable aggregation repeatedly and can tolerate managed refresh semantics rather than recomputing on every query. Which gold object is relevant?

  1. A Delta Sharing recipient with no underlying table
  2. Run an ordinary SELECT with the full GROUP BY aggregation on every BI request
  3. A materialized view with an appropriate refresh strategy
  4. A plain view that always recomputes the full aggregate

Explanation

Correct Answer

C:

A materialized view stores derived results and can lower repeated query costs when refresh behavior fits.

Incorrect Answers

A:

A sharing recipient does not calculate the desired gold aggregation.

B:

Recomputing the same heavy aggregate on each request does not provide the managed persisted result and refresh semantics requested.

D:

A regular view does not itself materialize aggregate results.

Question 199

A near-real-time derived gold table must be incrementally maintained as source changes arrive under a supported pipeline. Which table class should be evaluated?

  1. A streaming table in the appropriate managed pipeline
  2. Recompute and fully overwrite the gold table manually only when an analyst opens the notebook
  3. A Git pull request without a data job
  4. A one-time manually exported workbook

Explanation

Correct Answer

A:

A streaming table is designed for incremental processing of new inputs under its supported execution framework.

Incorrect Answers

B:

Ad hoc full replacement is not an incrementally maintained source-driven derived table and can violate near-real-time freshness.

C:

A code review event does not process arriving source records.

D:

A static extract cannot incrementally reflect new source data.

Question 200

A raw bronze field has values " US ", "us", and "Us" that should represent the same country code in silver. Which transformation is appropriate?

  1. Concat a random suffix to each code
  2. Drop every country containing lowercase letters
  3. trim then upper-case the field
  4. countDistinct before normalization

Explanation

Correct Answer

C:

Whitespace trimming and case normalization map these three representations to the common code US.

Incorrect Answers

A:

Adding suffixes increases rather than removes inconsistency.

B:

That would discard otherwise valid records.

D:

This reports three distinct strings and does not create a consistent country code.