Databricks Certified Data Engineer Associate - Databricks-Certified-Data-Engineer-Associate Free Exam Questions

A. Repartition the dataset to have it be more optimally spread across all nodes.

B. Increase the executor memory for the job.

C. Use coalesce() on the dataset to merge partitions and reduce skew.

D. Increase the number of executors for the job.

A. Switch the cluster

B. Restart the cluster

C. Rerun the pipeline

D. Repair the task

A. SELECT count(member_id) - count_null(member_id) FROM my_table;

B. SELECT null(member_id) FROM my_table;

C. SELECT count(member_id) FROM my_table;

D. SELECT count_if(member_id IS NULL) FROM my_table;

E. SELECT count_null(member_id) FROM my_table;

A. Restart the cluster

B. Repair run

C. Re-run the entire workflow

D. Switch to another cluster

A. Use the lineage feature to visualize a graph that highlights where the table is used only in notebooks.

B. Use the lineage feature to visualize a graph that shows all dependencies, including where the table is used in notebooks, other tables, and reports.

C. Use the lineage feature to visualize a graph that highlights where the table is used only in reports.

D. Do not use the lineage feature as it only tracks activity from the last 3 months and will not provide full details on dependencies.

A. overwrite

B. append

C. errorIfExists

D. ignore

A. Manually create and manage the workflow in UI

B. Databricks Asset Bundles (DAB) + GitHub Integration

C. Maintain workflow_config.json and deploy it using Terraform

D. Maintain workflow_config.json and deploy it using Databricks CLI

A. Records that violate the expectation cause the job to fail.

B. Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.

C. Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.

D. Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.

E. Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.

A. Unity Catalog

B. Auto Loader

C. Delta Live Tables

D. Data Explorer

E. Delta Lake

A. CREATE TABLE

B. CREATE TEMP VIEW

C. CREATE DATABASE

D. CREATE VIEW

A. printSchema

B. getSchema

C. describeSchema

D. showSchema

A. GRANT CREATE ON DATABASE customers TO team;

B. GRANT USAGE ON DATABASE customers TO team;

C. GRANT USAGE ON CATALOG team TO customers;

D. GRANT VIEW ON CATALOG customers TO team;

E. GRANT CREATE ON DATABASE team TO customers;