Question 1180
A security team must solve this operational problem: A multinational dataset must restrict employees to rows for their employing subsidiary. Which implementation is the most direct fit?
Explanation
Correct Answer
BigQuery row-level security addresses this case by the following supported operation: Define supported row access policies for appropriate principals and row-filter predicates. For this scenario (a multinational dataset must restrict employees to rows for their employing subsidiary), verify that a subsidiary user cannot query rows from another business unit despite table access.
Incorrect Answers
Sensitive Data Protection pseudonymization has a distinct purpose: Use an appropriate deterministic de-identification transformation with controlled secret or key material where applicable. It instead applies when analysts must join customer events across days without seeing raw customer identifiers, not the current requirement (a multinational dataset must restrict employees to rows for their employing subsidiary). Here, verify that a subsidiary user cannot query rows from another business unit despite table access.
Data classification before external sharing has a distinct purpose: Use Sensitive Data Protection inspection and a defined release gate that blocks unresolved high-risk findings. It instead applies when a data lake export may contain bank account numbers not approved for delivery to a partner, not the current requirement (a multinational dataset must restrict employees to rows for their employing subsidiary). Here, verify that a subsidiary user cannot query rows from another business unit despite table access.
Secret Manager rotation version control has a distinct purpose: Add a new secret version and update consumers to an approved version alias or version reference. It instead applies when a vendor credential rotates every month without requiring an application image rebuild, not the current requirement (a multinational dataset must restrict employees to rows for their employing subsidiary). Here, verify that a subsidiary user cannot query rows from another business unit despite table access.






Professional Cloud Security Engineer Practice Tests