Databricks Certified Data Analyst Practice questions with complete solutions

Databricks Certified Data Analyst Practice questions with
complete solutions

A Data Analyst has joined your team, however, he is not
familiar with Databricks SQL. Which of the following steps will
allow him to locate Data Explorer?

A) Go to SQL Warehouse, and click on the "Data Explore"
button
B) Go to SQL Editor, next to Schema Explore, and click on Data
Explore to access Data Explorer
C)Click "Data" in the sidebar menu to access the Data Explorer
D) On Databricks SQL, landing page, under SQL, click on
"Data Explore" next to "SQL Query Editor" to access Data
Explorer Correct Answer C

A data analyst has noticed that their Databricks SQL queries are
running very slowly. They claim that this issue is impacting all
of their sequentially run queries. They ask the data engineering
team for help. The data engineering team notices that each of the
queries uses the same SQL endpoint, but the SQL endpoint is
not used by any other user.

Which of the following approaches can the data engineering
team use to improve the latency of the data analyst's queries?

A) They can turn on the Auto Stop feature for the SQL endpoint.
B) They can increase the cluster size of the SQL endpoint.
C) They can increase the maximum bound of the SQL
endpoint's scaling range.

,D) They can turn on the Serverless feature for the SQL endpoint
and change the Spot Instance Policy to "Reliability Optimized."
E) They can turn on the Serverless feature for the SQL endpoint.
Correct Answer B

A data analyst wants to horizontally combine two tables as part
of a query. They want to use a shared column as a key column
and only want the query output to contain rows where the value
in the key column is present in both tables.
Which of the following SQL commands can they use to
accomplish this task?
A) OUTER JOIN
B) LEFT JOIN
C) COPY INTO
D) INNER JOIN Correct Answer D

A new data analyst has been assigned
to a Reporting project in your organization.
You Manager has asked you to provide the new data analyst full
privileges on the table sales to manage the project entirely.
Which of the following commands can grant full permissions on
the table to the new data analyst?


A) GRANT ALL PRIVILEGES ON TABLE
TO sales;
B) GRANT SELECT ON TABLE sales TO
;
C) GRANT ALL PRIVILEGES ON TABLE sales TO
;

,D) GRANT SELECT CREATE MODIFY ON TABLE sales TO
;
E) GRANT USAGE ON TABLE sales TO
; Correct Answer C

A new data analyst has joined your team. He has recently been
added to the company's Databricks workspace as
. The data analyst should be able to
query the table sales in the database retail. The new data analyst
has been granted USAGE on the database retail already.
Which of the following commands can be used to grant the
appropriate permission to the new data analyst?

A)
GRANT SELECT ON TABLE sales TO
;

B)
GRANT USAGE ON TABLE sales TO
;

C)
GRANT SELECT ON TABLE TO
sales;

D)
GRANT CREATE ON TABLE sales TO
.

E)

, GRANT USAGE ON TABLE TO
sales; Correct Answer A

A new data analyst has joined your team. He has recently been
added to the company's Databricks workspace as
. The data analyst should be able to
query the table sales in the database retail. The new data analyst
has been granted USAGE on the database retail already.
Which of the following commands can be used to grant the
appropriate permission to the new data analyst?

A) GRANT USAGE ON TABLE sales TO
;
B) GRANT USAGE ON TABLE TO
sales;
C) GRANT SELECT ON TABLE
TO sales;
D) GRANT SELECT ON TABLE sales TO
;
E) GRANT CREATE ON TABLE sales TO
; Correct Answer D

Account-level management of the Unity Catalog metastore
means:

A) schema, saved queries, and dashboard can be shared across
Databricks workspaces.
B) databases, tables, and views can be shared across Databricks
workspaces.
C) Delta lake will store meta information about declared schema
or database