1. What is a dynamic query in the context of BigQuery?
A. A pre-defined query with fixed parameters. B. A query that can be modified by the user in real-time. C. A custom SQL query that can involve joining multiple tables, filtering data, and more. D. A query that updates itself automatically based on new data.
Correct answer: C
2. In Looker Studio, how do parameters affect the visualization of data?
A. Parameters have no impact on the visualization. B. Parameters can be used to filter the data based on specific conditions. C. Parameters allow users to explore data and gain insights on-the-fly. D. Both B and C.
Correct answer: D
3. What is the primary benefit of using parameters in dynamic queries?
A. To reduce the complexity of the SQL code. B. To enable users to explore data and gain insights interactively. C. To automate the data extraction process. D. To increase the speed of data retrieval.
Correct answer: B
4. True or False: Parameters can only be used with BigQuery data sources.
Correct answer: False
5. True or False: In Looker Studio, you can define parameters and obtain their values from the user.
Correct answer: True
6. True or False: Looker Studio can reverse geocode latitude and longitude values to obtain an address.
Correct answer: False
7. When using geographic functions in SQL, the purpose is to calculate the ________ of each record to a given point.
Correct answer: distance
8. Dynamic queries in Looker Studio can be written against your whole ________ in BigQuery.
Correct answer: project
9. (Scenario-based, high difficulty) A real estate company wants to use Looker Studio to analyze the population density around potential sites for new apartment buildings. They need to be able to input the latitude and longitude of each site and a search radius. How would you use parameters and dynamic queries to achieve this?
Correct answer (example):
First, create a custom SQL query in Looker Studio that uses the input latitude, longitude, and search radius as parameters. The query should calculate the distance between each record in the database and the given coordinates using geographic functions. It should then return only the records that fall within the specified radius. Finally, create a visualization in Looker Studio that displays the resulting data, allowing the user to interactively explore population density around potential sites.
10. (Open-ended, scenario-based, high difficulty) Your client wants to analyze the number of schools within a certain distance of a proposed commercial property. Explain how you would create a Looker Studio visualization using parameters and dynamic queries to provide this information.
Correct answer (example):
To create a Looker Studio visualization for this scenario, follow these steps:
- Obtain the latitude and longitude of the proposed commercial property using an external mapping tool.
- Create a custom SQL query that takes the latitude, longitude, and search distance