Work with Parameters in SQL Queries and Dashboards, Including Defining, Configuring, and Testing Parameters. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A marketing analyst has a dashboard with a parameter `{{ campaign }}`. The query uses the parameter in a WHERE clause. The analyst wants to allow users to select multiple campaigns. They change the widget to a multi-select dropdown. However, the query still returns results for only one campaign. What is the most likely reason?

   • AThe widget is still in single-select mode.
   • BThe query uses `=` instead of `IN` to compare the parameter.
   • CThe parameter name in the query is different from the widget name.
   • DThe dashboard is in 'View' mode.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   An analyst creates a dashboard with a parameter `{{ product_category }}`. After adding the widget, they run the query with a specific value and it returns data. However, when they change the value in the widget, the dashboard visualization does not update. What is the most likely cause?

   • AThe dashboard is in 'View' mode instead of 'Edit' mode.
   • BThe query is cached and needs to be refreshed manually.
   • CThe parameter name in the widget does not match the one in the query.
   • DThe widget is not connected to the query parameter.
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data analyst creates a dashboard with a parameter `{{ min_revenue }}` used in a query. Before publishing the dashboard, the analyst wants to verify that the query returns different results when the parameter value changes. What is the most efficient way to test this in Databricks?

   • ACreate a new query for each value and compare the results.
   • BUse the 'Run' button without changing the parameter value.
   • CPublish the dashboard and ask a colleague to test it with different values.
   • DRun the query in the SQL editor, changing the parameter value in the 'Parameters' panel each time.
   Reveal Solution Discussion Select an answer first
5. 4expert · medium

   A sales analyst is creating a dashboard for regional managers. The dashboard has a parameter `{{ region }}` with a dropdown widget. The analyst wants to ensure that when a manager selects a region, the dashboard automatically updates without requiring a manual refresh. What is the correct configuration?

   • ASet the widget to 'Text' and rely on the query to auto-detect changes.
   • BInstruct managers to click the 'Run' button after selecting a region.
   • CCreate a separate dashboard for each region.
   • DEnable 'Auto-refresh' on the dashboard and set the widget to apply changes immediately.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A supply chain analyst wants to create a query that filters orders by a date range. They plan to add two widgets: `{{ start_date }}` and `{{ end_date }}`. What is the correct SQL syntax to use both parameters in the WHERE clause?

   • A`WHERE order_date BETWEEN {{ start_date }} AND {{ end_date }}`
   • B`WHERE order_date = {{ start_date }} OR order_date = {{ end_date }}`
   • C`WHERE order_date > {{ start_date }} AND order_date < {{ end_date }}`
   • D`WHERE order_date IN ({{ start_date }}, {{ end_date }})`
   Reveal Solution Discussion Select an answer first