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

Questions 6–10

1. 6application · medium

   A marketing analyst creates a SQL query to report daily ad spend. They want to reuse the same query for different date ranges without editing the SQL each time. The analyst adds a widget to the dashboard that lets viewers pick a start date. What is the correct way to reference this widget value inside the SQL query?

   • AHard-code the date in the query and ask viewers to edit the SQL before running.
   • BUse the literal text `{{ start_date }}` directly in the WHERE clause.
   • CUse the function `getParameter('start_date')` in the WHERE clause.
   • DUse a SQL variable declared with `DECLARE start_date DATE;` at the top of the query.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which widget type in a Databricks dashboard is best for letting users choose from a predefined list of values for a parameter?

   • ADate
   • BNumber
   • CDropdown
   • DText
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A data analyst is creating a dashboard for a sales team. The dashboard has a parameter `{{ sales_rep }}` with a dropdown widget. The analyst wants to ensure that the dropdown only shows sales reps who are currently active. What is the best way to achieve this?

   • AUse a text box and instruct users to type only active sales reps.
   • BUse a query to populate the dropdown options, filtering for active sales reps.
   • CManually type the list of active sales reps in the widget configuration.
   • DCreate a separate dashboard for active and inactive sales reps.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A data analyst is testing a dashboard parameter `{{ region }}`. They notice that when they type a value like 'North' in the widget, the query returns results, but when they type 'north' (lowercase), it returns no results. What is the most likely reason?

   • AThe widget is not connected to the query.
   • BThe dashboard is in 'View' mode.
   • CThe parameter is defined as an integer.
   • DThe underlying data has case-sensitive values, and the query is doing an exact match.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   After changing a parameter value in a dashboard widget, what should you do to verify the dashboard reflects the new value?

   • AEdit the SQL query to hardcode the new value
   • BRefresh the dashboard or wait for it to re-run the queries
   • CRestart the Databricks workspace
   • DCreate a new dashboard
   Reveal Solution Discussion Select an answer first