Google Cloud Associate Data Practitioner — Question 20

You work for a home insurance company. You are frequently asked to create and save risk reports with charts for specific areas using a publicly available storm event dataset. You want to be able to quickly create and re-run risk reports when new data becomes available. What should you do?

Answer options

• A. Export the storm event dataset as a CSV file. Import the file to Google Sheets, and use cell data in the worksheets to create charts.
• B. Copy the storm event dataset into your BigQuery project. Use BigQuery Studio to query and visualize the data in Looker Studio.
• C. Reference and query the storm event dataset using SQL in BigQuery Studio. Export the results to Google Sheets, and use cell data in the worksheets to create charts.
• D. Reference and query the storm event dataset using SQL in a Colab Enterprise notebook. Display the table results and document with Markdown, and use Matplotlib to create charts.

Correct answer: B

Explanation

The correct answer is B because importing the dataset into BigQuery allows for efficient querying and visualization using Looker Studio, making it easy to update reports with new data. Options A and C rely on Google Sheets, which may not handle large datasets as efficiently as BigQuery. Option D, while plausible, involves additional steps and tools that complicate the process without providing significant benefits over using BigQuery directly with Looker Studio.