Free Certified Data Analyst Associate Exam Braindumps
Databricks Certified Data Analyst Associate Questions 33–40 (page: 6)

Updated On: 12-May-2026

Which statement about a refresh schedule is incorrect?

  1. A query being refreshed on a schedule does not use a SQL Warehouse (formerly known as SQL Endpoint).
  2. Refresh schedules can be configured in the Query Editor.
  3. A query can be refreshed anywhere from 1 minute to 2 weeks.
  4. You must have workspace administrator privileges to configure a refresh schedule.

Answer(s): A



A data analyst creates a Databricks SQL Query where the result set has the following schema:

region STRING
number_of_customer INT

What type of visualization will be selected by default when the analyst clicks on the "Add visualization" button on the SQL Editor page?

  1. Violin Chart
  2. Line Chart
  3. Bar Chart
  4. Histogram

Answer(s): C


Reference:

https://docs.databricks.com/en/sql/user/visualizations/index.html



A data analyst has created a Query in Databricks SQL, and now wants to create two data visualizations from that Query and add both of those data visualizations to the same Databricks SQL Dashboard.

Which step will the data analyst need to take when creating and adding both data visualizations to the Databricks SQL Dashboard?

  1. Decide on a single data visualization to add to the dashboard.
  2. Alter the Query to return two separate sets of results.
  3. Add two separate visualizations to the dashboard based on the same Query.
  4. Copy the Query and create one data visualization per query.

Answer(s): C



A data analyst has been asked to provide a list of options on how to share a dashboard with a client. It is a security requirement that the client does not gain access to any other information, resources, or artifacts in the database.

Which approach cannot be used to share the dashboard and meet the security requirement?

  1. Set a refresh schedule for the dashboard and enter the client's email address in the "Subscribers" box.
  2. Download the Dashboard as a PDF and share it with the client.
  3. Generate a Personal Access Token that is good for 1 day and share it with the client.
  4. Take a screenshot of the dashboard and share it with the client.

Answer(s): C



A data analyst has been asked to produce a visualization that shows the flow of users through a website.

What kind of tool is utilized for visualising this type of flow?

  1. Pivot Table
  2. Heatmap
  3. Sankey
  4. Choropleth

Answer(s): C



A data analyst writes a query that contains a query parameter. The data analyst then adds 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 statement is correct?

  1. 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.
  2. 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.
  3. The area chart will use whatever value is chosen on the dashboard at the time the area chart is added to the dashboard.
  4. 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.

Answer(s): B



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.

What explains the failure of the Alert to function?

  1. The wrong query parameter is being used. Alerts only work with dropdown list query parameters, not dates.
  2. Queries that use query parameters cannot be used with Alerts.
  3. Queries that return results based on dates cannot be used with Alerts.
  4. The wrong query parameter is being used. Alerts only work with Date and Time query parameters.

Answer(s): B



Which statements about adding visual appeal to visualizations in the Visualization Editor is incorrect?

  1. Visualization scale can be changed.
  2. Data Labels can be formatted.
  3. Tooltips can be formatted.
  4. Borders can be added.

Answer(s): D



Viewing page 6 of 19
Viewing questions 41 - 48 out of 140 questions


Post your Comments and Discuss Databricks Certified Data Analyst Associate exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!