1. What is the main purpose of dynamic dimensions in Looker Studio? (Multiple Choice) a) To create tables with a fixed dimension b) To allow users to filter tables by date range c) To allow users to change table dimensions d) To create a dropdown menu for selecting dimensions
Answer: c
2. What type of parameter is used to create a dropdown menu with allowed values? (Multiple Choice) a) Numeric parameter b) Text-based parameter c) Date-based parameter d) None of the above
Answer: b
3. Which function is used to change table dimensions based on the selected value of a parameter? (Multiple Choice) a) SWITCH b) CONCAT c) CASE d) IF
Answer: c
4. To implement dynamic dimensions in tables, you need to create a custom field called: (Fill in the blank) a) table_breakdown b) dynamic_dimension c) custom_field
Answer: a
5. What is the purpose of creating an additional table with no header, metric, or row numbers? (Multiple Choice) a) To display the selected dimension as the title b) To create a new metric for the table c) To make the table transparent d) None of the above
Answer: a
6. Dynamic dimensions can be applied to charts as well as tables. (True/False)
Answer: True
7. The CASE function can only be used with text-based parameters. (True/False)
Answer: False
8. In order to change the table title based on the selected dimension, you need to create a custom metric. (True/False)
Answer: False
9. A marketing analyst wants to create a table that allows their team to switch between dimensions such as sessions by source, medium, campaign, or country. What should they use to achieve this? (Long Answer)
Example of a correct answer: The marketing analyst should use dynamic dimensions in Looker Studio by creating a text-based parameter for the dropdown menu, utilizing the CASE function to change the table dimensions based on user selection, creating a custom field for the table breakdown, and implementing an additional table with no header or metric to display the selected dimension as the title.
10. Your team wants to create a report that allows users to choose between revenue by region, revenue by product category, or revenue by sales representative. What steps would you take to implement this in Looker Studio? (Scenario-based, Multiple Choice)
a) Create a numeric parameter and a dropdown menu
b) Create a text-based parameter and a dropdown menu, then use the CASE function to change table dimensions
c) Create a date