Databricks-DA-Assoc Creating Dashboards and Visualizations Practice Test 2 — 15 Questions

Question 1

When creating a dashboard, an analyst needs to compare two different categories side-by-side. Which visualization is best suited for this task?

Accepted Answer

Grouped Bar Chart. A grouped bar chart is the most effective visualization for comparing distinct categories side-by-side. It allows the viewer to easily perceive differences in magnitude between related items. This is a common requirement in business reporting, where analysts must compare performance across regions, products, or time periods. By selecting the right visualization, the analyst reduces the cognitive effort required for the audience to extract insights from the data.

Answer

Heatmap

Answer

Bubble Chart

Answer

Stacked Area Chart

Question 2

Which of these is a benefit of using a 'parameter' in a Databricks SQL query?

Accepted Answer

It allows users to dynamically filter results without changing the code.. Parameters enable dynamic query execution. By allowing users to provide input at runtime, the same query can serve multiple analytical needs. This reduces the need to create dozens of near-identical queries, simplifying the codebase and making the dashboard much more interactive. It empowers the end-user to drill down into the specific segments they are interested in, which is a key driver for self-service analytics adoption within organizations.

Answer

It permanently changes the data in the underlying table.

Answer

It forces every user to run the exact same query.

Answer

It creates a copy of the database for each user session.

Question 3

Which TWO of the following are true about Databricks SQL Alerts? (Choose two)

Accepted Answer

Alerts can trigger external workflows using webhooks.. Alerts in Databricks SQL are a critical component of a proactive monitoring strategy. By tracking the results of a query, they provide timely notifications that help analysts and business users respond to events immediately. Understanding the configuration of thresholds and notification channels is essential for building a reliable operational dashboard suite that moves beyond passive data reporting to active, event-driven data management.

Answer

Alerts only function if the dashboard is currently open.

Answer

Alerts automatically delete data that triggers the condition.

Answer

Alerts are only compatible with Python-based notebooks.

Question 4

You are visualizing server error logs over time. You want to highlight days where the error count exceeds a specific threshold (e.g., 50 errors). Which visualization feature is best for this?

Accepted Answer

Use conditional formatting on the data series.. Conditional formatting is the standard tool for data highlighting. By applying rules to the visualization, the analyst can automatically change colors or icons based on the data values. This 'at-a-glance' identification of anomalies is crucial for operational monitoring, as it allows users to pinpoint problematic timeframes immediately, reducing the mean time to detect issues without requiring the user to inspect every individual data point manually.

Answer

Add a trend line to the chart.

Answer

Change the chart type to a pie chart.

Answer

Filter out all days with fewer than 50 errors.

Question 5

An analyst is preparing a report and needs to ensure that the dashboard data is always current. What is the most efficient way to achieve this?

Accepted Answer

Set a refresh schedule on the dashboard.. Setting a regular refresh schedule is the correct way to ensure data remains fresh. This automation removes the manual effort of refreshing queries, ensuring that the dashboard always represents the latest state of the business. It is a fundamental operational task that guarantees the dashboard's reliability and relevance, preventing stakeholders from making decisions based on stale or outdated information, which is a major risk in any data-driven environment.

Answer

Manually refresh the dashboard every morning.

Answer

Re-run the SQL queries in a notebook and export the results.

Answer

Ask the SQL warehouse to stay running indefinitely.

Question 6

A data analyst is building a Databricks SQL dashboard to track daily sales. They need to ensure that the dashboard automatically updates every hour to reflect the latest ingestion from Delta tables. Which mechanism should the analyst configure to achieve this requirement?

Accepted Answer

Configure a schedule on the dashboard using a SQL warehouse to run at the desired frequency.. Databricks SQL dashboards include a built-in schedule feature that allows analysts to define an interval for automated refreshes. By configuring a schedule, the dashboard queries run automatically in the background, ensuring stakeholders view current data without manual intervention. This feature is vital for operational reporting where timeliness is critical for business decision-making and performance monitoring across the organization.

Answer

Enable the 'Auto-refresh' toggle within the browser settings of the dashboard viewer.

Answer

Configure a SQL warehouse to 'Auto-stop' every hour to trigger a metadata update.

Answer

Create a Job in the Workflows UI that explicitly opens the dashboard URL every hour.

Question 7

Which visualization type is most appropriate for displaying the distribution of a single numerical variable across continuous intervals in a Databricks SQL dashboard?

Accepted Answer

Histogram. Histograms are the standard statistical tool for visualizing the frequency distribution of numerical data. By binning data into intervals, analysts can easily identify patterns, skewness, or outliers within a dataset. Understanding distribution is fundamental in data analysis for characterizing datasets before applying advanced statistical models or performing deeper exploratory data analysis within the Databricks environment.

Answer

Pie chart

Answer

Scatter plot

Answer

Funnel chart

Question 8

An analyst notices that a dashboard visualization is displaying an incorrect aggregation of total revenue. After reviewing the SQL, the analyst confirms the query logic is correct. What is the most likely cause of this discrepancy in the rendered visualization?

Accepted Answer

The visualization configuration in the dashboard editor has an unintended aggregation setting.. Visualizations in Databricks SQL handle data formatting and aggregation settings independently of the raw SQL output. Sometimes, the 'Plot' settings within the visualization editor define a different aggregation (like 'Average' instead of 'Sum') or apply data formatting that masks the true value. Checking these visualization-specific configurations is the final step in troubleshooting data accuracy issues within the dashboarding workflow.

Answer

The SQL warehouse is currently running in 'Serverless' mode.

Answer

The Unity Catalog metastore is failing to update the table statistics.

Answer

The dashboard is using a legacy version of the Databricks SQL visualizer.

Question 9

Which option is best for sharing a dashboard with internal stakeholders who do not have access to the Databricks workspace?

Accepted Answer

Configure an email subscription to send the dashboard periodically as a snapshot.. Databricks provides a subscription feature to email dashboard snapshots (PDFs or screenshots) to stakeholders. This ensures that users outside the immediate Databricks environment can consume relevant business insights without needing to manage complex identity and access management for the workspace. This is a key requirement for democratization of data, ensuring that executives and non-technical staff stay informed on KPIs regularly.

Answer

Create a temporary personal access token (PAT) for each stakeholder to login.

Answer

Publicly host the dashboard URL on the company intranet.

Answer

Manually export the dashboard as a CSV file to a shared file server.

Question 10

An analyst needs to display a comparison between actual and target sales figures in a dashboard. The data exists in two separate tables. Which approach is best to display this comparison in a single visualization?

Accepted Answer

Use a JOIN operation in the SQL query to combine the tables before visualization.. Combining data from disparate tables within the SQL layer is the recommended best practice for dashboarding in Databricks. By performing a JOIN within the SQL query, the analyst delivers a pre-aggregated, clean dataset to the visualization engine. This approach simplifies the visualization setup, minimizes the processing load on the visualizer, and ensures high performance, which is critical for complex comparative analyses in business intelligence.

Answer

Create two separate visualizations and place them side-by-side on the dashboard.

Answer

Use the visualization's 'secondary data source' feature to link the tables.

Answer

Import both tables into the dashboard's local memory and filter them.

Question 11

A data analyst has built a Databricks SQL dashboard with a bar chart that shows total revenue by region. The dashboard has a parameter named `region_param` that allows the viewer to select one or more regions. The analyst wants the bar chart to update automatically whenever the viewer changes the selected regions, without requiring a manual refresh. What should the analyst do?

Accepted Answer

Reference the parameter in the query using the `{{ region_param }}` syntax and ensure the parameter is added to the dashboard.. Parameters in Databricks SQL allow dynamic values to be passed into queries. By referencing the parameter with double curly braces in the query and adding it to the dashboard, the visualization will automatically update when the parameter value changes. This is the standard mechanism for interactive dashboards in Databricks SQL.

Answer

Create a separate query for each region and add them as individual visualizations to the dashboard.

Answer

Use a dashboard-level filter that applies to all visualizations and set the parameter to a fixed value.

Answer

Add a filter widget to the dashboard and link it to the parameter.

Question 12

An analyst is creating a dashboard in Databricks SQL and wants to display the number of active users per day over the last 30 days. The data is stored in a Delta table with a timestamp column. Which visualization type should the analyst use to best show the trend over time?

Accepted Answer

Line chart. A line chart is the most appropriate visualization for showing trends over time. It connects data points to illustrate changes and patterns, making it easy to interpret the daily active user count over the 30-day period. Other chart types are better suited for different analytical purposes.

Answer

Scatter plot

Answer

Bar chart

Answer

Pie chart

Question 13

A data analyst is building a dashboard in Databricks SQL that includes a visualization showing sales by product category. The analyst wants to ensure that the dashboard is interactive and allows viewers to filter the data by date range and product category. Which TWO of the following actions should the analyst take to enable this interactivity? (Choose two.)

Accepted Answer

Add a date range parameter to the dashboard and reference it in the query's WHERE clause.. To enable interactive filtering by date range and product category, the analyst should use parameters. A date range parameter and a dropdown list parameter for product category, both referenced in the query, allow viewers to dynamically filter the data. This is the standard and most efficient method in Databricks SQL dashboards.

Answer

Embed the dashboard in an iframe and use JavaScript to pass filter values.

Answer

Use a dashboard-level filter that applies to all visualizations and set it to a fixed date range.

Answer

Create a separate visualization for each product category and add them all to the dashboard.

Question 14

A data analyst is building a Databricks SQL dashboard that tracks daily active users across four global regions. The dashboard has a single dataset query, and the analyst wants the region filter to apply to all visualizations on the dashboard without editing each widget's query. Which dashboard feature should the analyst configure?

Accepted Answer

A dashboard-level parameter with the keyword {{region}} applied in the dataset query.. Dashboards in Databricks SQL let analysts define parameters that can be referenced in dataset queries with the {{name}} syntax. A dashboard-level parameter appears as a control for viewers and, because multiple visualizations can share one dataset, changing the parameter re-runs the dataset and updates every widget bound to it. This satisfies the requirement of a single region filter driving all visualizations without editing each widget's SQL.

Answer

A Unity Catalog row filter function attached to the underlying table.

Answer

A separate query snippet embedded in each visualization's SQL that hardcodes the region list.

Answer

A scheduled refresh on the dashboard set to run every five minutes.

Question 15

You are building a Databricks SQL dashboard and have a query that returns columns: order_date (DATE), region (STRING), and total_sales (DECIMAL). You want a single visualization that shows the trend of total_sales over order_date, with a separate line for each region, all on the same chart. Which visualization type should you select?

Accepted Answer

Line chart. The requirement is a temporal trend with one line per region, which is exactly what a line chart provides when a categorical column such as region is used as the series. The other chart types either compare static categories, show parts of a whole, or display point correlations, and none of them express continuous multi-series trends over dates.

Answer

Pie chart

Answer

Scatter chart

Answer

Bar chart