Databricks Certified Data Analyst Associate Exam Questions Instant Access

Question 1

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.

Which command could the data engineering team use to access sales in PySpark?

ASELECT * FROM sales

Bspark.table('sales')

Cspark.sql('sales')

Dspark.delta.table('sales')

Answer : B

Question 2

A managed table and an unmanaged external table were both created in Databricks SQL, and data was ingested into each table. Later, both tables were dropped.

What is the status of data for each of those tables?

AThe data in both tables were deleted.

BThe data in the managed table were deleted, and the data in the unmanaged external table were left untouched.

CThe data in the unmanaged external table were deleted, and the data in the managed table were left untouched.

DThe data in both tables were left untouched.

Answer : B

Question 3

A data analyst has written and saved a series of queries that reveal trends that need to be monitored by several stakeholders.

Which tool should the data analyst use to share the results of all of the queries to be viewed at once?

AA SQL warehouse

BA Query History page

CA dashboard

DA data visualization tab on a Query page

Answer : C

The correct answer is C because a dashboard is designed to collect multiple visualizations and query outputs in one shared reporting interface. A SQL warehouse provides compute for running SQL queries, but it is not a sharing/reporting interface. Query History only shows past query executions. A visualization tab belongs to one query result, while a dashboard can display multiple results together for stakeholders.

Question 4

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permitted to have accounts in the Databricks deployment. The stakeholders need to be notified every time the dashboard is refreshed.

Which approach can the data analyst use to accomplish this task with minimal effort/

ABy granting the stakeholders' email addresses permissions to the dashboard

BBy adding the stakeholders' email addresses to the refresh schedule subscribers list

CBy granting the stakeholders' email addresses to the SQL Warehouse (formerly known as endpoint) subscribers list

DBy downloading the dashboard as a PDF and emailing it to the stakeholders each time it is refreshed
To share a Databricks SQL dashboard with stakeholders who do not have accounts in the Databricks deployment and ensure they are notified upon each refresh, the data analyst can add the stakeholders' email addresses to the dashboard's refresh schedule subscribers list. This approach allows the stakeholders to receive email notifications containing the latest dashboard updates without requiring them to have direct access to the Databricks workspace. This method is efficient and minimizes effort, as it automates the notification process and ensures stakeholders remain informed of the most recent data insights.

Answer : B

Question 5

A table named user_ltv is being used to create a view that will be used by data analysts on various teams. Users in the workspace are configured into groups, which are used for setting up data access using ACLs.

The user_ltv table has the following schema:

email STRING, age INT, ltv INT

The following view definition is executed:

CREATE VIEW user_ltv_no_minors AS

SELECT email, age, ltv

FROM user_ltv

WHERE

CASE

WHEN is_member("auditing") THEN TRUE

ELSE age >= 18

END;

An analyst who is not a member of the auditing group executes the following query:

SELECT * FROM user_ltv_no_minors;

Which statement describes the results returned by this query?

AAll columns will be displayed normally for those records that have an age greater than 17; records not meeting this condition will be omitted.

BAll age values less than 18 will be returned as null values, all other columns will be returned with the values in user_ltv.

CAll values for the age column will be returned as null values, all other columns will be returned with the values in user_ltv.

DAll records from all columns will be displayed with the values in user_ltv.

EAll columns will be displayed normally for those records that have an age greater than 18; records not meeting this condition will be omitted.

Answer : A

Question 6

Which data lakehouse feature results in improved data quality over a traditional data lake?

AA data lakehouse stores data in open formats.

BA data lakehouse allows the use of SQL queries to examine data.

CA data lakehouse provides storage solutions for structured and unstructured data.

DA data lakehouse supports ACID-compliant transactions.

Answer : D

Option D is correct. ACID-compliant transactions improve reliability and data quality because writes are consistent and atomic rather than leaving partially written or corrupted states. Open formats and SQL access are important lakehouse capabilities, but the feature most directly tied to improved data quality over a traditional data lake is ACID transactions. Official Databricks extract: Delta Lake extends Parquet with a transaction log for ''ACID transactions,'' and Databricks states that Delta Lake adds ACID transactions and schema evolution for reliable, high-quality data.

Question 7

A data analyst has come across a column in a table that contains personally identifiable information (PII). The data analyst should not have access to this type of PII data.

How should the data analyst proceed?

AStop working with the data and delete the table and any existing metadata or data files.

BStop working with the data and proceed with the project using other data.

CStop working with the data and notify their supervisor to ensure the data is handled following organizational and legal best practices.

DDrop the column containing PII data and continue with the project without notifying anybody.

Answer : C