Question 1

The following code has been migrated to a Databricks notebook from a legacy workload:

The code executes successfully and provides the logically correct results, however, it takes over 20 minutes to extract and load around 1 GB of data. Which statement is a possible explanation for this behavior?

Options :

A : %sh triggers a cluster restart to collect and install Git. Most of the latency is related to cluster startup time

B :

Instead of cloning, the code should use %sh pip install so that the Python code can get executed in parallel across all nodes in a cluster.

C : %sh does not distribute file moving operations; the final line of code should be updated to use %fs instead.

D :

Python will always execute slower than Scala on Databricks. The run.py script should be refactored to Scala

E :

%sh executes shell code on the driver node. The code does not take advantage of the worker nodes or Databricks optimized Spark.

Answer: C

Question 2

A data engineer uses the following SQL query:

GRANT USAGE ON DATABASE sales_db TO finance_team

Which of the following is the benefit of the USAGE privilege ?

Options :

A : Gives read access on the database

B : Gives full permissions on the entire database

C : Gives the ability to view database objects and their metadata

D : No effect! but it-s required to perform any action on the database

E : USAGE privilege is not part of the Databricks governance model

Answer: D

Question 3

When using CLI or REST API to get results from jobs with multiple tasks, which statement correctly describes the response structure?

Options :

A : Each run of a job will have a unique job_id; all tasks within this job will have a unique job_id

B : Each run of a job will have a unique job_id; all tasks within this job will have a unique task_id

C : Each run of a job will have a unique orchestration_id; all tasks within this job will have a unique run_id

D : Each run of a job will have a unique run_id; all tasks within this job will have a unique task_id

E : Each run of a job will have a unique run_id; all tasks within this job will also have a unique run_id

Answer: D

Question 4

A developer has successfully configured their credentials for Databricks Repos and cloned a remote Git repository. They do not have privileges to make changes to the main branch, which is the only branch currently visible in their workspace.

Which approach allows this user to share their code updates without the risk of overwriting the work of their teammates?

Options :

A : Use Repos to create a new branch, commit all changes, and push changes to the remote Git repository.

B : Use Repos to create a fork of the remote repository, commit all changes, and make a pull request on the source repository.

C : Use Repos to pull changes from the remote Git repository; commit and push changes to a branch that appeared as changes were pulled.

D : Use Repos to merge all differences and make a pull request back to the remote repository.

Answer: A

Question 5

The Databricks workspace administrator has configured interactive clusters for each of the data engineering groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to execute workloads against their assigned clusters at any time of the day.

Assuming users have been added to a workspace but not granted any permissions, which of the following describes the minimal permissions a user would need to start and attach to an already configured cluster.

Options :

A : "Can Manage" privileges on the required cluster

B : Workspace Admin privileges, cluster creation allowed, "Can Attach To" privileges on the required cluster

C : Cluster creation allowed, "Can Attach To" privileges on the required cluster

D : "Can Restart" privileges on the required cluster

E : Cluster creation allowed, "Can Restart" privileges on the required cluster

Answer: D