Topic 1 Question 206
2 つ選択You 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?
Create row-level access policies to restrict the result data when you run queries with the filter expression set to TRUE.
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.
Create row-level access policies to restrict the result data when you run queries with the filter expression set to FALSE.
Configure dynamic data masking rules to control access to columns at query runtime.
Create column-level policy tags to control access to columns at query runtime.
ユーザの投票
コメント(6)
- 正解だと思う選択肢: CE
C - Non-query operations should >>>not<<< be supported so it has to be FALSE: https://cloud.google.com/bigquery/docs/using-row-level-security-with-features#the_true_filter E - https://cloud.google.com/bigquery/docs/column-level-security-intro#column-level_security_workflow
👍 3pfilourenco2023/08/05 - 正解だと思う選択肢: CE
CE looks good
👍 2cyberpunk212023/08/23 CD is correct !
👍 1K1SMM2023/08/03
シャッフルモード