Google Professional Data Engineer Question 206
Select 3Google Cloud PlatformYou are a data engineer working for a retail company that uses BigQuery as its data warehouse. Your team has created a sales performance dashboard using Looker Studio. You want to share this dashboard with stakeholders, ensuring they have access to the latest data while maintaining proper security and cost controls. What steps should you take to publish and share this report effectively?
- A
Use Looker Studio's sharing settings to grant stakeholders 'Viewer' access to the dashboard.
- B
Enable the 'Public on the Web' sharing option to simplify access for all stakeholders.
- C
Ensure that the underlying BigQuery dataset has the appropriate permissions for the stakeholders.
- D
Use scheduled email delivery in Looker Studio to send PDF snapshots of the dashboard to stakeholders.
- E
Configure the BigQuery billing export to monitor query costs associated with the dashboard usage.
Show answer and explanation
Correct answers: A, C, E
Explanation
To effectively publish and share reports or visualizations like a Looker Studio dashboard, it is crucial to maintain proper access controls, ensure the underlying data permissions are configured correctly, and monitor costs associated with dashboard usage. Granting 'Viewer' access provides secure access to stakeholders, while configuring BigQuery billing export allows you to track and control query costs. Avoid using insecure sharing methods like 'Public on the Web' and static formats like PDFs if real-time data is required.
- A. Correct.
Granting 'Viewer' access in Looker Studio ensures stakeholders can view the dashboard without editing it, maintaining security and data integrity.
- B. Incorrect.
Enabling 'Public on the Web' sharing option is not recommended for sensitive business data as it compromises security. It should be avoided unless the data is explicitly intended for public use.
- C. Correct.
Ensuring correct permissions for the underlying BigQuery dataset is essential so stakeholders can access the data powering the dashboard without encountering permissions errors.
- D. Incorrect.
Sending PDF snapshots does not ensure stakeholders access the latest data, as snapshots are static and do not update automatically.
- E. Correct.
Configuring BigQuery billing export helps monitor query costs, ensuring that the dashboard’s usage remains within budget and avoids unexpected billing surprises.