Databricks Databricks-Certified-Data-Analyst-Associate Practice Exam Questions

Databricks Databricks-Certified-Data-Analyst-Associate Sample Question Answers

Question # 1

Query History provides Databricks SQL users with a lot of benefits. A data analyst has been asked toshare all of these benefits with their team as part of a training exercise. One of the benefitstatements the analyst provided to their team is incorrect.Which statement about Query History is incorrect?

A. It can be used to view the query plan of queries that have run. 
B. It can be used to debug queries. 
C. It can be used to automate query execution on multiple warehouses (formerly endpoints). 
D. It can be used to troubleshoot slow running queries. 

Show Answer

Question # 2

A data analyst has created a Query in Databricks SQL, and now wants to create two datavisualizations from that Query and add both of those data visualizations to the same Databricks SQLDashboard.Which step will the data analyst need to take when creating and adding both data visualizations tothe Databricks SQL Dashboard?

A. Copy the Query and create one data visualization per query. 
B. Add two separate visualizations to the dashboard based on the same Query. 
C. Decide on a single data visualization to add to the dashboard. 
D. Alter the Query to return two separate sets of results. 

Show Answer

Question # 3

What is used as a compute resource for Databricks SQL? 

A. Single-node clusters 
B. Downstream BI tools integrated with Databricks SQL 
C. SQL warehouses 
D. Standard clusters 

Show Answer

Question # 4

A data analyst wants the following output:customer_name number_of_ordersJohn Doe 388Zhang San 234Which statement will produce this output?

A. SELECT customer_name, count(order_id) AS number_of_ordersFROM customersJOIN ordersON customers.customer_id = orders.customer_idGROUP BY customer_name;
B. SELECT customer_name, count(order_id) number_of_ordersFROM customersJOIN ordersON customers.customer_id = orders.customer_id USE customer_name;
C. SELECT customerjiame, (order_id) number_of_ordersFROM customersJOIN ordersON customers.customer_id = orders.customer_id;
FROM customersJOIN ordersON customers.customer_id = orders.customer_id GROUP BY customerjiame;

Show Answer

Question # 5

Which statement describes descriptive statistics? 

A. A branch of statistics that uses a variety of data analysis techniques to infer properties of anunderlying distribution of probability
B. A branch of statistics that uses summary statistics to categorically describe and summarize data. 
C. A branch of statistics that uses summary statistics to quantitatively describe and summarize data. 
D. A branch of statistics that uses quantitative variables that must take on a finite or countablyinfinite set of values.

Show Answer

Question # 6

In which circumstance will there be a substantial difference between the variable-s mean and medianvalues?

A. When the variable is of the categorical type 
B. When the variable is of the boolean type 
C. When the variable contains no outliers 
D. When the variable contains a lot of extreme outliers 

Show Answer

Question # 7

A data analyst wants to create a Databricks SQL dashboard with multiple data visualizations andmultiple counters. What must be completed before adding the data visualizations and counters tothe dashboard?

A. All data visualizations and counters must be created using Queries.
B. A SQL warehouse (formerly known as SQL endpoint) must be turned on and selected. 
C. A markdown-based tile must be added to the top of the dashboard displaying the dashboard's name. 
D. The dashboard owner must also be the owner of the queries, data visualizations, and counters. 

Show Answer

Question # 8

Which location can be used to determine the owner of a managed table? 

A. Review the Owner field in the table page using Catalog Explorer 
B. Review the Owner field in the database page using Data Explorer 
C. Review the Owner field in the schema page using Data Explorer 
D. Review the Owner field in the table page using the SQL Editor 

Show Answer

Question # 9

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

A. A quantitative variable that never stops changing 
B. A quantitative variable Chat can take on a finite or countably infinite set of values 
C. A quantitative variable that can take on an uncountable set of values 
D. A categorical variable in which the number of categories continues to increase over time 

Show Answer

Question # 10

A data analyst needs to share a Databricks SQL dashboard with stakeholders that are not permittedto have accounts in the Databricks deployment. The stakeholders need to be notified every time thedashboard is refreshed.Which approach can the data analyst use to accomplish this task with minimal effort/

A. By granting the stakeholders' email addresses permissions to the dashboard 
B. By adding the stakeholders' email addresses to the refresh schedule subscribers list 
C. By granting the stakeholders' email addresses to the SQL Warehouse (formerly known asendpoint) subscribers list
D. By downloading the dashboard as a PDF and emailing it to the stakeholders each time it isrefreshed

Show Answer