Creating Dashboards and Visualizations

Which visualization type is most appropriate for displaying the distribution of a single continuous numerical variable, such as transaction amounts, in a Databricks Dashboard?

An analyst is creating a visualization of daily sales trends over the past year. They notice that the chart is cluttered and difficult to interpret due to the high volume of individual data points. Which action should the analyst take to improve readability?

Which TWO of the following are valid ways to improve the performance of a slow-loading Databricks SQL dashboard? (Choose two)

Which visualization type is most appropriate for showing the distribution of a single continuous variable, such as the spread of customer ages?

An analyst wants to publish a dashboard for the executive team. The dashboard contains sensitive data that should only be accessible to specific users. What is the correct way to handle access control?

Which THREE of the following steps are necessary to create an interactive dashboard in Databricks SQL? (Choose three)

Refer to the exhibit. An analyst notices that widget 2 is displaying incorrect trends. Based on the configuration provided, what is the most likely cause?

Which feature in Databricks allows an analyst to automatically send a dashboard snapshot to a stakeholder's email on a recurring schedule?

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

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

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

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?

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?

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?

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

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?

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

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?

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?

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?

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.)

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?

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?

An analyst is designing a dashboard in Databricks SQL to monitor key performance indicators (KPIs). The dashboard will be viewed by executives who need to quickly see the current value of each KPI and whether it is meeting its target. Which visualization type is most appropriate for displaying a single KPI value along with its target?

A data analyst has created a Databricks SQL dashboard with a visualization that uses a query with a parameter. The analyst wants to share the dashboard with a colleague who should be able to view the dashboard but not modify the queries or the dashboard itself. The colleague also needs to be able to change the parameter values to explore the data. What should the analyst do?

An analyst has a Databricks SQL dashboard with a table visualization showing the top 20 customers by lifetime value. The stakeholder wants the same numbers represented as proportional horizontal bars so differences between customers are easier to compare visually. Which visualization type should the analyst choose?

An analyst is creating a Databricks SQL dashboard and wants to give viewers a single numeric value that stands out, such as total revenue for the current quarter. Which visualization type should the analyst use?

An analyst is preparing a Databricks SQL dashboard for an executive review and needs to ensure the numbers shown are trustworthy and reproducible. The analyst wants to document the data lineage and make the dashboard resilient to schema changes in the source tables. Which TWO actions should the analyst take? (Choose two.)

You are configuring a Databricks SQL dashboard that includes a filter widget based on a query parameter. Which TWO statements correctly describe how parameters and filter widgets behave in this dashboard? (Choose two.)

A Databricks SQL dashboard uses a counter visualization to display total revenue for the current month. The analyst notices that the counter shows a value even when the underlying query returns zero rows for the selected filter. Which behavior explains this and what should the analyst do to make the counter reflect the empty result set correctly?

A data analyst is creating a Databricks SQL dashboard to display a single key performance indicator: the total number of active subscriptions for the current day. The value must be prominent and readable at a glance, with no axes or categories. Which visualization type should the analyst choose?

An analyst is preparing a Databricks SQL dashboard for an executive review. The dashboard contains several visualizations built from different queries. The analyst wants to ensure that viewers can change a single value, such as a fiscal quarter, and have all relevant visualizations update consistently. Which TWO approaches allow the analyst to achieve this interactive filtering across multiple visualizations? (Choose two.)

An analyst has a Databricks SQL dashboard with a table visualization showing order details, including an order_date column. A stakeholder wants to see only orders from the last 30 days but also wants the ability to change the date range without editing the query. The analyst adds a date-range parameter to the query and a parameter widget to the dashboard. After publishing, the stakeholder reports that changing the parameter does not affect the table. Which action should the analyst take to resolve this?

A dashboard author wants viewers to click a bar in a Databricks SQL chart and have the dashboard display a second chart filtered to that bar's category. Which feature should the author configure to achieve this interactive behavior?

A data analyst is building a Databricks SQL dashboard that includes a line chart of daily active users over the past year. The stakeholder wants to hover over the line to see the exact date and user count for each point. The analyst notices that the tooltip currently shows only the user count and not the date. What should the analyst do to include the date in the tooltip?

A data analyst built a Databricks SQL dashboard with a chart showing monthly revenue. During a presentation, an executive asks to see only the months where revenue exceeded $100,000. The analyst wants to apply this condition directly in the visualization without rewriting the underlying query. Which Databricks SQL dashboard feature should the analyst use?