Question 1

Which of the following section in the UI can be used to manage permissions and grants to tables?

Options :

A : User Settings

B : Admin UI

C : Workspace admin settings

D : User access control lists

E : Data Explorer

Answer: A

Question 2

The data engineering team is using a SQL query to review data completeness every day to monitor the ETL job, and query output is being used in multiple dashboards which of the following approaches can be used to set up a schedule and automate this process?

Options :

A : They can schedule the query to run every day from the Jobs UI.

B : They can schedule the query to refresh every day from the query’s page in Databricks SQL

C : They can schedule the query to run every 12 hours from the Jobs UI.

D : They can schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.

E : They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL

Answer: B

Question 3

Which of the following locations hosts the driver and worker nodes of a Databricks-managed cluster?

Options :

A : Data plane

B : Control plane

C : Databricks Filesystem

D : JDBC data source

E : Databricks web application

Answer: A

Question 4

You are tasked to setup a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department how do you go about to setup this in job?

Options :

A : Use a single notebook as task in the job and use dbutils.notebook.run to run each notebook with parameter in a different cell

B : A task in the job cannot take an input parameter, create six notebooks with hardcoded dept number and setup six tasks with linear dependency in the job

C : A task accepts key-value pair parameters, creates six tasks pass department number as parameter foreach task with no dependency in the job as they can all run in parallel.

D : A parameter can only be passed at the job level, create six jobs pass department number to each job with linear job dependency

E : A parameter can only be passed at the job level, create six jobs pass department number to each job with no job dependency

Answer: C

Question 5

Which type of workloads are compatible with Auto Loader?

Options :

A : Streaming workloads

B : Machine learning workloads

C : Serverless workloads

D : Batch workloads

E : Dashboard workloads

Answer: A