In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?

• A.When the target table cannot contain duplicate records
• B.When the source table can be deleted
• C.When the location of the data needs to be changed
• D.When the source is not a Delta table
• E.When the target table is an external table

Comment: *

Name: *

Email: *

Verification: *

A platform team is creating a standardized template for Databricks Asset Bundles to support CI/CD. The template must specify defaults for artifacts, workspace root paths, and a run identity, while allowing a "dev" target to be the default and override specific paths.
How should the team use databricks.yml to satisfy these requirements?

• A.Use deployment, builds, context, identity, and environments; set dev as default environment and override paths under builds.
• B.Use roots, modules, profiles, actor, and targets; where profiles contain workspace and artifacts defaults and actor sets run identity.
• C.Use project, packages, environment, identity, and stages; set dev as default stage and override workspace under environment.
• D.Use bundle, artifacts, workspace, run_as, and targets at the top level; set one target with default: true and override workspace paths or artifacts under that target.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?

• A.Parquet files can be partitioned
• B.CREATE TABLE AS SELECT statements cannot be used on files
• C.Parquet files have a well-defined schema
• D.Parquet files have the ability to be optimized
• E.Parquet files will become Delta tables

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the number of null values in the member_id column?

• A.SELECT count(member_id) FROM my_table;
• B.SELECT count(member_id) - count_null(member_id) FROM my_table;
• C.SELECT count_if(member_id IS NULL) FROM my_table;
• D.SELECT null(member_id) FROM my_table;
• E.SELECT count_null(member_id) FROM my_table;

Comment: *

Name: *

Email: *

Verification: *

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

• A.trigger("5 seconds")
• B.trigger()
• C.trigger(once="5 seconds")
• D.trigger(processingTime="5 seconds")
• E.trigger(continuous="5 seconds")

Comment: *

Name: *

Email: *

Verification: *