DATABRICKS CERTIFIED DATA
ANALYST PRACTICE QUESTIONS &
ANSWERS SOLVED 100% CORRECT!!
1 of
122
Term
When you drop an unmanaged table, you also delete the underlying data. Is
this true or false?
True
False
Give this one a try later!
B A
, C False
Don't know?
2 of 122
Term
You have a critical project with tight timelines and would
like to know when the job run is completed at the earliest.
Is it possible to trigger the alert with a frequency of as less
as 1 min?
A) No, it is not possible to have such frequent alerts
B) It is possible, however, Databricks only supports
scheduling alerts with frequency for as low as 5 mins
C) It is possible, however, the smallest interval for which
alerts can be scheduled in Databricks is 1 min
D) Databricks can trigger alerts on hourly basis only
Give this one a try later!
B C
D A
Don't know?
3 of 122
,Term
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.
Give this one a try later!
B D
A C
Don't know?
, 4 of 122
Term
ANALYST PRACTICE QUESTIONS &
ANSWERS SOLVED 100% CORRECT!!
1 of
122
Term
When you drop an unmanaged table, you also delete the underlying data. Is
this true or false?
True
False
Give this one a try later!
B A
, C False
Don't know?
2 of 122
Term
You have a critical project with tight timelines and would
like to know when the job run is completed at the earliest.
Is it possible to trigger the alert with a frequency of as less
as 1 min?
A) No, it is not possible to have such frequent alerts
B) It is possible, however, Databricks only supports
scheduling alerts with frequency for as low as 5 mins
C) It is possible, however, the smallest interval for which
alerts can be scheduled in Databricks is 1 min
D) Databricks can trigger alerts on hourly basis only
Give this one a try later!
B C
D A
Don't know?
3 of 122
,Term
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.
Give this one a try later!
B D
A C
Don't know?
, 4 of 122
Term
