Google Professional Data Engineer Question 203
Select 3Google Cloud PlatformYou are a Data Engineer at a retail company that wants to share its sales data publicly for analysts and researchers. The dataset is stored in BigQuery. To ensure the dataset is published securely and adheres to best practices, which steps should you take?
- A
Enable dataset-level permissions and grant the 'roles/bigquery.dataViewer' role to the public.
- B
Disable access to the dataset for all users except yourself to prevent unauthorized access.
- C
Ensure sensitive information is removed or anonymized within the dataset before publishing.
- D
Use Cloud Identity and Access Management (IAM) to set permissions for specific groups instead of publishing the dataset publicly.
- E
Add metadata and relevant descriptions to the dataset to help users understand its contents and purpose.
Show answer and explanation
Correct answers: A, C, E
Explanation
To securely and effectively publish a dataset from BigQuery, you must grant appropriate permissions (e.g., 'roles/bigquery.dataViewer') to the public, ensure sensitive data is anonymized or removed, and add metadata and descriptions to make the dataset understandable. Disabling access or restricting it to specific groups would conflict with the goal of public sharing.
- A. Correct.
Correct: Granting the 'roles/bigquery.dataViewer' role at the dataset level allows public users to view the dataset while maintaining appropriate access control.
- B. Incorrect.
Incorrect: Disabling access for all users contradicts the goal of publishing the dataset publicly. This would make the dataset inaccessible.
- C. Correct.
Correct: Removing or anonymizing sensitive data is a crucial step to ensure compliance with data privacy regulations and to protect sensitive information.
- D. Incorrect.
Incorrect: Using IAM to restrict access to specific groups does not align with the requirement of making the dataset publicly accessible.
- E. Correct.
Correct: Adding metadata and descriptions improves usability and ensures that analysts and researchers can understand the dataset's context and purpose.