Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have a BigQuery data warehouse where you need to store all customer data in a single table. You must restrict query access to specific rows and columns, and non-query operations should be blocked.
What should you do? (Choose two.)
A
Create row-level access policies to restrict the result data when you run queries with the filter expression set to TRUE.
B
Configure 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.
C
Create row-level access policies to restrict the result data when you run queries with the filter expression set to FALSE.
D
Configure dynamic data masking rules to control access to columns at query runtime.
E
Create column-level policy tags to control access to columns at query runtime.
