Question 203 of 318
Choose 2You manage a BigQuery analytical data warehouse in your organization. You want to keep data for all your customers in a common table while you also restrict query access based on rows and columns permissions. Non-query operations should not be supported.
What should you do? (Choose two.)
ACreate row-level access policies to restrict the result data when you run queries with the filter expression set to TRUE.
BConfigure column-level encryption by using Authenticated Encryption with Associated Data (AEAD) functions with Cloud Key Management Service (KMS) to control access to columns at query runtime.
✓CCreate row-level access policies to restrict the result data when you run queries with the filter expression set to FALSE.
DConfigure dynamic data masking rules to control access to columns at query runtime.
✓ECreate column-level policy tags to control access to columns at query runtime.
✓
Correct Answer: C, E
Create row-level access policies to restrict the result data when you run queries with the filter expression set to FALSE.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.