Databricks
Databricks Certified Data Analyst Associate
Q1:
A data analyst has been asked to count the number of customers in each region and has written the following query:
If there is a mistake in the query, which of the following describes the mistake?
○
A
The query is using count('). which will count all the customers in the customers table, no matter the region.○
B
The query is missing a GROUP BY region clause.○
C
The query is using ORDER BY. which is not allowed in an aggregation.○
D
There are no mistakes in the query.○
E
The query is selecting region but region should only occur in the ORDER BY clause.
Databricks
Databricks Certified Data Analyst Associate
Q2:
Which of the following benefits of using Databricks SQL is provided by Data Explorer?
○
A
It can be used to run UPDATE queries to update any tables in a database.○
B
It can be used to view metadata and data, as well as view/change permissions.○
C
It can be used to produce dashboards that allow data exploration.○
D
It can be used to make visualizations that can be shared with stakeholders.○
E
It can be used to connect to third party Bl cools.
Databricks
Databricks Certified Data Analyst Associate
Q3:
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
○
A
ACID transactions○
B
Flexible schemas○
C
Data deletion○
D
Scalable storage○
E
Open-source formats
Databricks
Databricks Certified Data Analyst Associate
Q4:
Delta Lake stores table data as a series of data files, but it also stores a lot of other information.
Which of the following is stored alongside data files when using Delta Lake?
○
A
None of these○
B
Table metadata, data summary visualizations, and owner account information○
C
Table metadata○
D
Data summary visualizations○
E
Owner account information
Databricks
Databricks Certified Data Analyst Associate
Q5:
Which of the following should data analysts consider when working with personally identifiable information (PII) data?
○
A
Organization-specific best practices for Pll data○
B
Legal requirements for the area in which the data was collected○
C
None of these considerations○
D
Legal requirements for the area in which the analysis is being performed○
E
All of these considerations