Databricks Data Analyst Associate Certification: Exam Prep and Q&A

DATABRICKS DATA ANALYST –
ASSOCIATE EXAM PREP NEWEST
QUESTIONS AND
CORRECT ANSWERS GRADED A+




How do you check the Query Profile for a select query run on
D
O


Databricks SQL Editor?
N


A) On the Query History Tab
O


B) On the Data Tab
T


C) On the SQL Editor Tab
C
O


D) On the SQL Warehouses Tab - ✔✔✔ Correct Answer > A) On the Query
PY


History Tab


When managing data quality with Delta Live Tables, which of the
following is not considered Delta Live Tables expectations?
A) A description, which acts as a unique identifier and allows you to
track metrics for the constraint
B) An action to take when a record fails the expectation, meaning the
boolean returns false.
C) No action is taken when meaning the boolean returns true.

,D) A boolean statement that always returns true or false based on some
stated condition. - ✔✔✔ Correct Answer > C) No action is taken when
meaning the boolean returns true.


Which of the following is incorrect about how we can check if the query
results were read from the cache?
A) Under SQL Editor > Check the Run stats on the bottom of the page
for Current Execution> Hover on the run time, shows the stats
B) Under Query History > Go to the Query > Check the IO section
D


C) Under SQL Warehouses > Go to Query History > Check the IO
O


section
N


D) Under Queries > Check in the Admin View - ✔✔✔ Correct Answer > D)
O


Under
T


Queries > Check in the Admin View
C
O


Which join is to be used between two tables A and B when the resultant
PY


table needs rows from A and B that matches the condition and rows from
A that do not match the condition?
A) Outer Join
B) Inner Join
C) None of the above
D) Cross Join - ✔✔✔ Correct Answer > A) Outer Join

,What is Data Imputation?
A) This is a process that involves moving the data from bronze layer to
silver layer
B) This is a process that involves filling in missing data
C) This is a process that involves adding additional information to the
data
D) This is a process that involves identifying or correcting the errors in
the data - ✔✔✔ Correct Answer > B) This is a process that involves filling
in missing data
D
O


A data analyst created and is the owner of the managed table my_ table.
N


They now want to change ownership of the table to a single other user
O


using Data Explorer.Which of the following approaches can the analyst
T


use to complete the task?
C


A. Edit the Owner field in the table page by removing their own account
O


B. Edit the Owner field in the table page by selecting All Users
PY


C. Edit the Owner field in the table page by selecting the new owner's
account
D. Edit the Owner field in the table page by selecting the Admins group
E. Edit the Owner field in the table page by removing all access - ✔✔✔
Correct Answer > C. Edit the Owner field in the table page by selecting the
new owner's account


What are the various permission option(s) available at the database table
level?

, A) ALL, SELECT, MODIFY, READ_METADATA
B) None of the above
C) ALL, SELECT, MODIFY, READ_METADATA, USAGE, CREATE
D) ALL, SELECT, MODIFY, GRANT - ✔✔✔ Correct Answer > A) ALL,
SELECT,
MODIFY, READ_METADATA


Which layer tables are "project specific" in nature?
A) Platinum
D
O


B) Bronze
N


C) Gold
O


D) Silver - ✔✔✔ Correct Answer > C) Gold
T
C
O


Can you manipulate files in managed tables directly using tools outside
PY


of Databricks?
A) Only if you have the necessary permissions
B) It depends on the file format used
C) Yes, it is recommended to use external tools
D) No, you should not use tools outside of Databricks - ✔✔✔ Correct Answer
> D) No, you should not use tools outside of Databricks



Which of the following do we see on the Queries landing page