Question 1

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 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 can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

Options :

A : None of these

B : Data lake

C : Data warehouse

D : All of these

E : Data lakehouse

Answer: E

Question 4

Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?

Options :

A : MERGE INTO table_name

B : COPY INTO table_name

C : UPDATE table_name

D : INSERT INTO OVERWRITE table_name

E : INSERT IF EXISTS table_name

Answer: A

Question 5

Which of the following commands can be used to read a delta table in SQL

Options :

A : Spark.sql(“select * from table_name”)

B : %sql Select * from table_name

C : Both A & B

D : Execute.sql(“select * from table”)

E : Delta.sql(“select * from table”)

Answer: C

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

Buying Options: