exam questions

Exam Professional Cloud Security Engineer All Questions

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

Exam Professional Cloud Security Engineer topic 1 question 234 discussion

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

Your organization uses BigQuery to process highly sensitive, structured datasets. Following the “need to know” principle, you need to create the Identity and Access Management (IAM) design to meet the needs of these users:
• Business user: must access curated reports.
• Data engineer: must administrate the data lifecycle in the platform.
• Security operator: must review user activity on the data platform.

What should you do?

  • A. Configure data access log for BigQuery services, and grant Project Viewer role to security operator.
  • B. Set row-based access control based on the “region” column, and filter the record from the United States for data engineers.
  • C. Create curated tables in a separate dataset and assign the role roles/bigquery.dataViewer.
  • D. Generate a CSV data file based on the business user's needs, and send the data to their email addresses.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
MisterHairy
Highly Voted 1 year, 5 months ago
Selected Answer: C
Correction. The most correct answer would be C. Create curated tables in a separate dataset and assign the role roles/bigquery.dataViewer. This option directly addresses the needs of the business user who must access curated reports. By creating curated tables in a separate dataset, you can control access to specific data. Assigning the roles/bigquery.dataViewer role allows the business user to view the data in BigQuery. While option A is also a good practice for a security operator, it doesn’t directly address the specific needs of the users mentioned in the question as effectively as option C does. Therefore, if you can only choose one answer, option C would be the most correct.
upvoted 7 times
...
JohnDohertyDoe
Most Recent 3 months, 4 weeks ago
Selected Answer: C
The answers do not fit all the requirements. But the one that addresses is C. A is not right, as even if Data Access logs are enabled, they cannot be viewed by the Security Operator role with `viewer`, they would need `logging.privateLogViewer`.
upvoted 1 times
...
Mr_MIXER007
7 months, 3 weeks ago
Selected Answer: C
C. Create curated tables in a separate dataset and assign the role roles/bigquery.dataViewer.
upvoted 1 times
...
Nkay17
10 months, 3 weeks ago
Answer C: Data Access audit logs—except for BigQuery Data Access audit logs—are disabled by default because audit logs can be quite large.
upvoted 1 times
...
Bettoxicity
1 year ago
Selected Answer: A
A is the correct!
upvoted 1 times
...
dija123
1 year, 1 month ago
Selected Answer: A
Option A (data access logs and Project Viewer for security) offers a simpler path to achieve "need to know" for business users and data engineers while providing the security operator with visibility into user activity.
upvoted 1 times
...
dija123
1 year, 1 month ago
Selected Answer: A
Sorry I wanted to vote for A
upvoted 1 times
...
dija123
1 year, 1 month ago
Selected Answer: C
Both Option A and Option C can be effective for different reasons. Option A offers simplicity and aligns with "need to know" for most users, while Option C provides more granular control over data access but requires additional configuration.
upvoted 1 times
...
MisterHairy
1 year, 5 months ago
Selected Answer: A
A. Configure data access log for BigQuery services, and grant Project Viewer role to security operator. This allows the security operator to review user activity on the data platform. C. Create curated tables in a separate dataset and assign the role roles/bigquery.dataViewer. This allows the business user to access curated reports. The data engineer can administrate the data lifecycle in the platform.
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago