Databricks Certified Data Analyst Associate Exam Questions Instant Access

Question 1

Which of the following approaches can be used to ingest data directly from cloud-based object storage?

ACreate an external table while specifying the DBFS storage path to FROM

BCreate an external table while specifying the DBFS storage path to PATH

CIt is not possible to directly ingest data from cloud-based object storage

DCreate an external table while specifying the object storage path to FROM

ECreate an external table while specifying the object storage path to LOCATION
External tables are tables that are defined in the Databricks metastore using the information stored in a cloud object storage location. External tables do not manage the data, but provide a schema and a table name to query the data. To create an external table, you can use the CREATE EXTERNAL TABLE statement and specify the object storage path to the LOCATION clause. For example, to create an external table named ext_table on a Parquet file stored in S3, you can use the following statement:
SQL
CREATE EXTERNAL TABLE ext_table (
col1 INT,
col2 STRING
)
STORED AS PARQUET
LOCATION 's3://bucket/path/file.parquet'
AI-generated code. Review and use carefully.More info on FAQ.

Answer : E

Question 2

In which circumstance will there be a substantial difference between the variable's mean and median values?

AWhen the variable is of the categorical type

BWhen the variable is of the boolean type

CWhen the variable contains no outliers

DWhen the variable contains a lot of extreme outliers

Answer : D

The mean is sensitive to extreme values, often called outliers, which can significantly skew the average away from the true center of the data. The median, however, is a measure of central tendency that is resistant to such outliers because it only considers the middle value(s) when the data is ordered. Therefore, when a variable contains many extreme outliers, there will be a substantial difference between the mean and the median. According to Databricks data analysis materials, this is a fundamental concept when choosing summary statistics for reporting.

Question 3

A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set.

What describes a continuous variable?

AA quantitative variable that never stops changing

BA quantitative variable Chat can take on a finite or countably infinite set of values

CA quantitative variable that can take on an uncountable set of values

DA categorical variable in which the number of categories continues to increase over time
A continuous variable is a type of quantitative variable that can assume an infinite number of values within a given range. This means that between any two possible values, there can be an infinite number of other values. For example, variables such as height, weight, and temperature are continuous because they can be measured to any level of precision, and there are no gaps between possible values. This is in contrast to discrete variables, which can only take on specific, distinct values (e.g., the number of children in a family). Understanding the nature of continuous variables is crucial for data analysts, especially when selecting appropriate statistical methods and visualizations, such as histograms, to accurately represent and analyze the data.

Answer : C

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

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked to share all of these benefits with their team as part of a training exercise. One of the benefit statements the analyst provided to their team is incorrect.

Which statement about Query History is incorrect?

AIt can be used to view the query plan of queries that have run.

BIt can be used to debug queries.

CIt can be used to automate query execution on multiple warehouses (formerly endpoints).

DIt can be used to troubleshoot slow running queries.

Answer : C

Query History in Databricks SQL is intended for reviewing executed queries, understanding their execution plans, and identifying performance issues or errors for debugging purposes. It allows users to analyze query duration, resources used, and potential bottlenecks. However, Query History does not provide any capability to automate the execution of queries across multiple warehouses; automation must be handled through jobs or external orchestration tools, not through the Query History feature itself.

Question 6

Where in the Databricks SQL workspace can a data analyst configure a refresh schedule for a query when the query is not attached to a dashboard or alert?

AData bxplorer

BThe Visualization editor

CThe Query Editor

DThe Dashboard Editor
In Databricks SQL, to configure a refresh schedule for a query that is not attached to a dashboard or alert, a data analyst should use the Query Editor. Within the Query Editor, there is an option to set up scheduled executions for queries. This feature enables the query to run at specified intervals, ensuring that the results are updated regularly. By scheduling queries in this manner, analysts can automate data refreshes and maintain up-to-date query results without manual intervention.

Answer : C

Question 7

A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:

Which query did the analyst execute in order to get this result?

AOption A

BOption B

COption C

DOption D

Answer : B