Google Professional Data Engineer Question 208
Select 3Google Cloud PlatformYou are a Data Engineer tasked with creating a sales dashboard for your organization using Google Cloud. The dashboard needs to display insights from BigQuery datasets and update automatically when new data is ingested. Which combination of tools and features should you use to publish the reports and visualizations effectively?
- A
Use Looker Studio to create visualizations and set up a direct connection with BigQuery for real-time updates.
- B
Export the BigQuery data into CSV files and upload them into Google Sheets to create the visualizations.
- C
Use Looker Studio with scheduled data refresh settings to query BigQuery periodically.
- D
Leverage Dataflow to transform the data, then use Looker Studio to connect to the transformed data for visualization.
- E
Publish the reports using Cloud Pub/Sub to distribute them to stakeholders.
Show answer and explanation
Correct answers: A, C, D
Explanation
To publish reports and visualizations effectively in Google Cloud, Looker Studio is the recommended tool for connecting directly to BigQuery, offering real-time updates and customizable dashboards. Scheduled refresh settings in Looker Studio can ensure periodic updates for datasets. Additionally, Dataflow can preprocess or transform data before visualization when necessary. These options align with best practices for creating automated, dynamic dashboards in Google Cloud.
- A. Correct.
Correct: Looker Studio provides a seamless way to connect to BigQuery datasets directly and allows for real-time data visualization, which is crucial for dynamic dashboards.
- B. Incorrect.
Incorrect: Exporting BigQuery data into CSV files and using Google Sheets is not efficient for real-time or automated updates. This does not align with the requirements of the scenario.
- C. Correct.
Correct: Looker Studio supports scheduled data refreshes, which can be a practical way to query BigQuery periodically and ensure data accuracy without manual intervention.
- D. Correct.
Correct: Dataflow can be used to preprocess or transform the data before connecting it to Looker Studio, making it a viable option for more complex pipelines.
- E. Incorrect.
Incorrect: Cloud Pub/Sub is a messaging service and is not designed for publishing visual dashboards or reports to stakeholders. It’s not relevant to this specific use case.