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

Questions 11–15

1. 11foundation · easy

   What is the purpose of defining a parameter in a Databricks SQL query?

   • ATo encrypt the query text
   • BTo schedule the query to run automatically
   • CTo make the query dynamic so it can be reused with different input values
   • DTo permanently store the query results in a table
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   An HR analyst creates a dashboard with a parameter `{{ department }}`. They want the widget to show a default value of 'Sales' when the dashboard is first opened. How should they configure this?

   • AModify the SQL query to hard-code 'Sales' as the default.
   • BCreate a separate dashboard for the Sales department.
   • CSet the widget to 'Text' and instruct users to type 'Sales'.
   • DSet the 'Default Value' field in the widget configuration to 'Sales'.
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A financial analyst manages a dashboard with a parameter `{{ fiscal_year }}`. The widget is a dropdown with values 2020, 2021, 2022, 2023. The analyst needs to add a new fiscal year (2024) to the dropdown. However, the dashboard is used by multiple teams, and the analyst wants to ensure the change is tested before it goes live. What is the best approach?

   • ACreate a new dashboard with the updated widget and share it with the teams.
   • BModify the underlying SQL query to ignore the parameter and always show 2024 data.
   • CChange the widget to a text box so users can type any year.
   • DEdit the widget's possible values to include 2024, then test the dashboard in 'Edit' mode before publishing.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   When testing a parameterized query in Databricks, what is the purpose of running it with different parameter values?

   • ATo save the query as a new version
   • BTo verify the query returns correct results for each value
   • CTo permanently change the query's default values
   • DTo increase the query's execution speed
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   An analyst is testing a query with a parameter `{{ start_date }}`. They run the query in the SQL editor with the value '2023-01-01' and it works. They then add the query to a dashboard and add a date widget. When they select '2023-01-01' in the widget, the query returns an error. What is the most likely cause?

   • AThe date widget is not supported in dashboards.
   • BThe parameter is used with quotes in the query.
   • CThe widget name does not match the parameter name in the query.
   • DThe query is cached and needs to be refreshed.
   Reveal Solution Discussion Select an answer first