ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Security Engineer All Questions

View all questions & answers for the Professional Cloud Security Engineer exam
Go to Exam

Exam Professional Cloud Security Engineer topic 1 question 206 discussion

Actual exam question from Google's Professional Cloud Security Engineer
Question #: 206
Topic #: 1
[All Professional Cloud Security Engineer Questions]

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? (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.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by K1SMM at Aug. 4, 2023, 2:11 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
pfilourenco
Highly Voted 8 months, 3 weeks ago
Selected Answer: 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
upvoted 6 times
...
Xoxoo
Most Recent 7 months, 1 week ago
Selected Answer: CE
Bumping this up (credit to pfilourenco): 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
upvoted 2 times
...
pradoUA
7 months, 2 weeks ago
Selected Answer: CE
CE is ok
upvoted 1 times
...
cyberpunk21
8 months, 1 week ago
Selected Answer: CE
CE looks good
upvoted 2 times
...
pfilourenco
8 months, 4 weeks ago
Selected Answer: AE
A - 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
upvoted 1 times
gcp4test
8 months, 3 weeks ago
Non-query operations should >>>not<<< be supported so it has to be FALSE Correct CE
upvoted 1 times
pfilourenco
8 months, 3 weeks ago
Yes, you are correct again :)
upvoted 2 times
...
...
...
K1SMM
8 months, 4 weeks ago
CD is correct !
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago