Question 1

Which statement describes Delta Lake optimized writes?

Options :

A : Before a Jobs cluster terminates, OPTIMIZE is executed on all tables modified during the most recent job.

B : An asynchronous job runs after the write completes to detect if files could be further compacted; if yes, an OPTIMIZE job is executed toward a default of 1 GB.

C : Data is queued in a messaging bus instead of committing data directly to memory; all data is committed from the messaging bus in one batch once the job is complete.

D : Optimized writes use logical partitions instead of directory partitions; because partition boundaries are only represented in metadata, fewer small files are written.

E : A shuffle occurs prior to writing to try to group similar data together resulting in fewer files instead of each executor writing multiple files based on directory partitions.

Answer: E

Question 2

A data engineer wants to join a stream of advertisement impressions (when an ad was shown) with another stream of user clicks on advertisements to correlate when impressions led to monetizable clicks.

In the code below, Impressions is a streaming DataFrame with a watermark ("event_time", "10 minutes")

The data engineer notices the query slowing down significantly.

Which solution would improve the performance?

Options :

A : Joining on event time constraint: clickTime >= impressionTime AND clickTime <= impressionTime interval 1 hour

B : Joining on event time constraint: clickTime + 3 hours < impressionTime - 2 hours

C : Joining on event time constraint: clickTime == impressionTime using a leftOuter join

D : Joining on event time constraint: clickTime >= impressionTime - interval 3 hours and removing watermarks

Answer: A

Question 3

A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI. Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job. They attempt to transfer "Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task. Which statement explains what is preventing this privilege transfer?

Options :

A : Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group

B : The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.

C : Other than the default "admins" group, only individual users can be granted privileges on jobs.

D : A user can only transfer job ownership to a group if they are also a member of that group

E : Only workspace administrators can grant "Owner" privileges to a group.

Answer: A

Question 4

Which statement regarding Spark configuration on the Databricks platform is true?

Options :

A : The Databricks REST API can be used to modify the Spark configuration properties for an interactive cluster without interrupting jobs currently running on the cluster.

B : Spark configurations set within a notebook will affect all SparkSessions attached to the same interactive cluster.

C : When the same Spark configuration property is set for an interactive cluster and a notebook attached to that cluster, the notebook setting will always be ignored.

D : Spark configuration properties set for an interactive cluster with the Clusters UI will impact all notebooks attached to that cluster.

Answer: D

Question 5

A workspace admin has created a new catalog called finance_data and wants to delegate permission management to a finance team lead without giving them full admin rights. Which privilege should be granted to the finance team lead?

Options :

A : ALL PRIVILEGES on the finance_data catalog.

B : Make the finance team lead a metastore admin.

C : GRANT OPTION privilege on the finance_data catalog.

D : MANAGE privilege on the finance_data catalog.

Answer: D

Confidently Practice Online with Free Databricks-Certified-Professional-Data-Engineer Exam Cram

Buying Options: