Question 1

A data engineer has created a new database using the following command: CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?

Accepted Answer

dbfs:/user/hive/warehouse - which is the default location

Question 2

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE
LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?

Accepted Answer

The CREATE STREAMING LIVE TABLE syntax is used when you want to create Delta Live Tables (DLT) tables that are designed for processing data
incrementally. This is typically used when your data pipeline involves streaming or incremental data updates, and you want the table to stay up to date as new data
arrives. It allows you to define tables that can handle data changes incrementally without the need for full table refreshes.

Question 3

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this
issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering
team notices that each of the team’s queries uses the same SQL endpoint.
Which of the following approaches can the data engineering team use to improve the latency of the team’s queries?

Accepted Answer

When many users are running small queries simultaneously on a SQL endpoint, the database can become overloaded, causing slow query execution times. By
increasing the cluster size of the SQL endpoint, the database can handle more simultaneous queries, resulting in faster query execution times.

Question 4

Which of the following must be specified when creating a new Delta Live Tables pipeline?

Accepted Answer

https://docs.databricks.com/en/delta-live-tables/tutorial-pipelines.html

Question 5

A data engineer is working with two tables. Each of these tables is displayed below in its entirety.

From SurePassExam
https://www.surepassexam.com/Databricks-Certified-Data-Engineer-Associate-exam-dumps.html (88 New Questions)
The data engineer runs the following query to join these tables together:
Which of the following will be returned by the above query?

Accepted Answer

Correct answer: C

Question 6

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data
engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

Accepted Answer

https://www.databricks.com/blog/2022/03/10/top-5-databricks-performance- tips.html

Question 7

A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period
is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

Accepted Answer

This statement will check if the variable day_of_week is equal to 1 and if the variable review_period evaluates to a truthy value. The use of the double equal sign
(==) in the comparison of day_of_week is important, as a single equal sign (=) would be used to assign a value to the variable instead of checking its value. The
use of a single ampersand (&) instead of the keyword and is not valid syntax in Python. The use of quotes around True in options B and C will result in a string
comparison, which will not evaluate to True even if the value of review_period is True.

Question 8

A new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist.
The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

Accepted Answer

The GRANT statement is used to grant privileges on a database, table, or view to a user or role. The ALL PRIVILEGES option grants all possible privileges on the
specified object, such as CREATE, SELECT, MODIFY, and USAGE. The syntax of the GRANT statement is:
GRANT privilege_type ON object TO user_or_role;
Therefore, to grant full permissions on the database customers to the new data engineering team, the command should be:
GRANT ALL PRIVILEGES ON DATABASE customers TO team;

Question 9

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The
job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be
notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales
is greater than zero?

Accepted Answer

Correct answer: D

Question 10

Which of the following is hosted completely in the control plane of the classic Databricks architecture?

Accepted Answer

In the classic Databricks architecture, the control plane includes components like the Databricks web application, the Databricks REST API, and the Databricks
Workspace. These components are responsible for managing and controlling the Databricks environment, including cluster provisioning, notebook management,
access control, and job scheduling. The other options, such as worker nodes, JDBC data sources, Databricks Filesystem (DBFS), and driver nodes, are typically
part of the data plane or the execution environment, which is separate from the control plane. Worker nodes are responsible for executing tasks and computations,
JDBC data sources are used to connect to external databases, DBFS is a distributed file system for data storage, and driver nodes are responsible for coordinating
the execution of Spark jobs.

From SurePassExam
https://www.surepassexam.com/Databricks-Certified-Data-Engineer-Associate-exam-dumps.html (88 New Questions)