1. Which of the following is NOT a use case for parameters in Looker Studio? (Multiple choice)
A. User-provided goals and targets B. Custom calculations with user-provided values C. Forecasting and projections D. Uploading images
Correct answer: D
2. What can be done with parameters in Looker Studio that couldn't be done before their introduction? (Multiple choice)
A. Meeting with clients to discuss their goals B. Allowing clients to change their input values at any time C. Manually adjusting the report for each client D. Hardcoding values into reports
Correct answer: B
3. True or False: Parameters can only be used with BigQuery datasets.
False
4. True or False: Parameters can enable users to change the dimensions and metrics applied to charts.
True
5. Which of the following is a benefit of using parameters for custom calculations? (Multiple choice)
A. Reducing the need for manual data entry B. Allowing users to input their own values C. Automatically updating the report based on new data D. Connecting to various data sources without coding
Correct answer: B
6. True or False: Parameters can be used to create dynamic queries with BigQuery.
True
7. In Looker Studio, to create a mini tool for forecasting different scenarios, you can use ______.
A. filters B. data sources C. parameters D. dimensions
Correct answer: C
8. When using parameters for custom calculations, some of the input values may come from _______, while others might be provided by the user.
A. hardcoded values B. live data sources C. charts D. A and B
Correct answer: D
9. (Scenario-based) Your client wants to explore different scenarios by changing their marketing budget to see how it impacts their projected revenue. What feature of Looker Studio can help them achieve this goal? (Open-ended question)
Example of a correct answer: Parameters can be used to create a mini tool that allows the client to input different marketing budget values and explore different scenarios. By adjusting the input values, the client can forecast the potential impact on their projected revenue based on various budget scenarios.
10. (Scenario-based) You are creating a report for a client who wants to compare their monthly sales against a sales target they provide. How can you use parameters to meet their needs while minimizing manual adjustments to the report? (Multiple choice)
A. Create a control on the page for the client to input their sales target B. Use a filter to allow the client to select a predefined sales target C. Write a custom field that incorporates the client's input value as a parameter D. Connect to the client's data source and automatically retrieve their sales target
Correct answer: A and C