Answer-first summary for fast verification
Answer: Ensure each table is included in a dataset for a region., Adjust the settings for each dataset to allow a related region-based security group view access.
The correct answer to enforce the regional access policy in Google BigQuery is to ensure each table is included in a dataset for a region (option B) and adjust the settings for each dataset to allow a related region-based security group view access (option E). By organizing data into region-specific datasets and configuring access controls at the dataset level, you can maintain segregation and enforce regional access policies effectively. Adjusting settings at the dataset level also provides scalability and ease of management compared to table-level configurations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have developed a new report for your extensive team within Google Data Studio 360, leveraging Google BigQuery as the data source. Company policy mandates that employees can only view data relevant to their specific region, prompting you to create and populate individual tables for each region. To enforce the regional access policy for this data, which two actions should you take? (Choose two.)
A
Ensure all the tables are included in global dataset.
B
Ensure each table is included in a dataset for a region.
C
Adjust the settings for each table to allow a related region-based security group view access.
D
Adjust the settings for each view to allow a related region-based security group view access.
E
Adjust the settings for each dataset to allow a related region-based security group view access.