DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCI…
Q: 1
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?
Options
Q: 2
A data analyst has created a user-defined function using the following line of code:
CREATE FUNCTION price(spend DOUBLE, units DOUBLE)
RETURNS DOUBLE
RETURN spend / units;
Which of the following code blocks can be used to apply this function to the customer_spend and
customer_units columns of the table customer_summary to create column customer_price?
Options
Q: 3
A data analyst creates a Databricks SQL Query where the result set has the following schema:
region STRING
number_of_customer INT
When the analyst clicks on the "Add visualization" button on the SQL Editor page, which of the
following types of visualizations will be selected by default?
Options
Q: 4
An analyst writes a query that contains a query parameter. They then add an area chart visualization
to the query. While adding the area chart visualization to a dashboard, the analyst chooses
"Dashboard Parameter" for the query parameter associated with the area chart.
Which of the following statements is true?
Options
Q: 5
Which of the following is a benefit of Databricks SQL using ANSI SQL as its standard SQL dialect?
Options
Q: 6
Which statement describes descriptive statistics?
Options
Q: 7
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 dat
a. 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?
Options
Q: 8
Which of the following describes how Databricks SQL should be used in relation to other business
intelligence (BI) tools like Tableau, Power BI, and looker?
Options
Q: 9
A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL
endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the
endpoint while managing costs?
Options
Q: 10
A data analyst has created a Query in Databricks SQL, and now they want to create two data
visualizations from that Query and add both of those data visualizations to the same Databricks SQL
Dashboard.
Which of the following steps will they need to take when creating and adding both data visualizations
to the Databricks SQL Dashboard?
Options
Question 1 of 10
