Databricks Certified Data Analyst Associate (DATABRICKS-CERTIFIED-DATA-ANALYST-ASSOCIATE) - DataBricks Actual Exam Questions
Last updated on May 13, 2026
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?
Reduce the SQL endpoint cluster size
Increase the SQL endpoint cluster size
Turn off the Auto stop feature
Increase the minimum scaling value
Use a Serverless SQL endpoint
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which statement describes descriptive statistics?
A branch of statistics that uses a variety of data analysis techniques to infer properties of an underlying distribution of probability.
A branch of statistics that uses summary statistics to categorically describe and summarize data.
A branch of statistics that uses summary statistics to quantitatively describe and summarize data.
A branch of statistics that uses quantitative variables that must take on a finite or countably infinite set of values.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
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?
The area chart will use whatever is selected in the Dashboard Parameter while all or the other visualizations will remain changed regardless of their parameter use.
The area chart will use whatever is selected in the Dashboard Parameter along with all of the other visualizations in the dashboard that use the same parameter.
The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
The area chart will use whatever value is input by the analyst when the visualization is added to the dashboard. The parameter cannot be changed by the user afterwards.
The area chart will convert to a Dashboard Parameter.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
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
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 refresh schedule with an interval of 10 minutes or less
A refresh schedule with an always-on SQL Warehouse (formerly known as SQL Endpoint
A refresh schedule with stakeholders included as subscribers
A refresh schedule with a Structured Streaming cluster
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following statements about a refresh schedule is incorrect?
A query can be refreshed anywhere from 1 minute lo 2 weeks
Refresh schedules can be configured in the Query Editor.
A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).
A refresh schedule is not the same as an alert.
You must have workspace administrator privileges to configure a refresh schedule
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.