Practice Free Databricks Certified Data Analyst Associate Exam Online Questions
A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?
- A . Delta Lake
- B . Databricks Notebooks
- C . Tableau
- D . Databricks Machine Learning
- E . Databricks SQL
Consider the following two statements:
Statement 1:
Statement 2:
Which of the following describes how the result sets will differ for each statement when they are run in Databricks SQL?
- A . The first statement will return all data from the customers table and matching data from the orders table. The second statement will return all data from the orders table and matching data from the customers table. Any missing data will be filled in with NULL.
- B . When the first statement is run, only rows from the customers table that have at least one match with the orders table on customer_id will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
- C . There is no difference between the result sets for both statements.
- D . Both statements will fail because Databricks SQL does not support those join types.
- E . When the first statement is run, all rows from the customers table will be returned and only the customer_id from the orders table will be returned. When the second statement is run, only those rows in the customers table that do not have at least one match with the orders table on customer_id will be returned.
A data analyst has been asked to configure an alert for a query that returns the income in the accounts_receivable table for a date range. The date range is configurable using a Date query parameter.
The Alert does not work.
Which of the following describes why the Alert does not work?
- A . Alerts don’t work with queries that access tables.
- B . Queries that return results based on dates cannot be used with Alerts.
- C . The wrong query parameter is being used. Alerts only work with Date and Time query parameters.
- D . Queries that use query parameters cannot be used with Alerts.
- E . The wrong query parameter is being used. Alerts only work with drogdown list query parameters, not dates.
Which statement describes descriptive statistics?
- A . A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying 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 countably infinite set of values.
A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?
- A . They can set up an Alert with a custom template.
- B . They can set up an Alert with a new email alert destination.
- C . They can set up an Alert with one-time notifications.
- D . They can set up an Alert with a new webhook alert destination.
- E . They can set up an Alert without notifications.
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?
- 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.
A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every 10 minutes. A data analyst has created a dashboard based on this gold level data. The project stakeholders want to see the results in the dashboard updated within 10 minutes or less of new data becoming available within the gold-level tables.
What is the ability to ensure the streamed data is included in the dashboard at the standard requested by the project stakeholders?
- A . A refresh schedule with an interval of 10 minutes or less
- B . A refresh schedule with an always-on SQL Warehouse (formerly known as SQL Endpoint
- C . A refresh schedule with stakeholders included as subscribers
- D . A refresh schedule with a Structured Streaming cluster
A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute. A data analyst has created a dashboard based on this gold-level dat a. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.
Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?
- A . The required compute resources could be costly
- B . The gold-level tables are not appropriately clean for business reporting
- C . The streaming data is not an appropriate data source for a dashboard
- D . The streaming cluster is not fault tolerant
- E . The dashboard cannot be refreshed that quickly
Which of the following statements describes descriptive statistics?
- A . A branch of statistics that uses summary statistics to quantitatively describe and summarize data.
- B . A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.
- C . A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.
- D . A branch of statistics that uses summary statistics to categorically describe and summarize data.
- E . A branch of statistics that uses quantitative variables that must take on an uncountable set of values.
Data professionals with varying titles use the Databricks SQL service as the primary touchpoint with the Databricks Lakehouse Platform. However, some users will use other services like Databricks Machine Learning or Databricks Data Science and Engineering.
Which of the following roles uses Databricks SQL as a secondary service while primarily using one of the other services?
- A . Business analyst
- B . SQL analyst
- C . Data engineer
- D . Business intelligence analyst
- E . Data analyst