exam questions

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam

Exam Professional Data Engineer topic 1 question 141 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 141
Topic #: 1
[All Professional Data Engineer Questions]

Data Analysts in your company have the Cloud IAM Owner role assigned to them in their projects to allow them to work with multiple GCP products in their projects. Your organization requires that all BigQuery data access logs be retained for 6 months. You need to ensure that only audit personnel in your company can access the data access logs for all projects. What should you do?

  • A. Enable data access logs in each Data Analyst's project. Restrict access to Stackdriver Logging via Cloud IAM roles.
  • B. Export the data access logs via a project-level export sink to a Cloud Storage bucket in the Data Analysts' projects. Restrict access to the Cloud Storage bucket.
  • C. Export the data access logs via a project-level export sink to a Cloud Storage bucket in a newly created projects for audit logs. Restrict access to the project with the exported logs.
  • D. Export the data access logs via an aggregated export sink to a Cloud Storage bucket in a newly created project for audit logs. Restrict access to the project that contains the exported logs.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
SteelWarrior
Highly Voted 4 years, 1 month ago
Answer D is correct. Aggregated log sink will create a single sink for all projects, the destination can be a google cloud storage, pub/sub topic, bigquery table or a cloud logging bucket. without aggregated sink this will be required to be done for each project individually which will be cumbersome. https://cloud.google.com/logging/docs/export/aggregated_sinks
upvoted 30 times
AzureDP900
1 year, 10 months ago
D is right
upvoted 1 times
...
...
[Removed]
Highly Voted 4 years, 7 months ago
Correct: D https://cloud.google.com/iam/docs/roles-audit-logging#scenario_external_auditors
upvoted 12 times
daghayeghi
3 years, 7 months ago
https://cloud.google.com/iam/docs/job-functions/auditing#scenario_operational_monitoring
upvoted 3 times
...
Rajuuu
4 years, 3 months ago
The above link shows BigQuery as a sink for aggregated exports and not Cloud Storage.
upvoted 3 times
...
...
pbtpratik
Most Recent 7 months ago
D is the correct ans
upvoted 1 times
...
barnac1es
1 year, 1 month ago
Selected Answer: D
D. Here's why this option is recommended: Aggregated Export Sink: By using an aggregated export sink, you can consolidate data access logs from multiple projects into a single location. This simplifies log management and retention policies. Newly Created Project for Audit Logs: Creating a dedicated project for audit logs allows you to centralize access control and manage logs separately from individual Data Analyst projects. Access Restriction: By restricting access to the project containing the exported logs, you ensure that only authorized audit personnel have access to the logs while preventing Data Analysts from accessing them.
upvoted 1 times
...
midgoo
1 year, 7 months ago
Selected Answer: D
To create the Log Router, at step 3 to define the logs (Source), we can include logs from many projects (aggregated)
upvoted 1 times
...
zellck
1 year, 11 months ago
Selected Answer: D
D is the answer. https://cloud.google.com/logging/docs/export/aggregated_sinks Aggregated sinks combine and route log entries from the Google Cloud resources contained by an organization or folder. For instance, you might aggregate and route audit log entries from all the folders contained by an organization to a Cloud Storage bucket.
upvoted 2 times
...
dffffff
2 years, 6 months ago
D is correct
upvoted 1 times
...
MaxNRG
2 years, 9 months ago
Selected Answer: D
D: https://cloud.google.com/logging/docs/export/aggregated_exports You can create an aggregated export sink that can export log entries from all the projects, folders, and billing accounts of an organization. As an example, you might use this feature to export audit log entries from an organization's projects to a central location.
upvoted 4 times
...
Chelseajcole
3 years ago
The auditor needs to audit data analyst's behaviors (how they access multiple projects in BQ ). So, the key is, multiple projects. According to Google doc project-level sinks: https://cloud.google.com/logging/docs/export/configure_export_v2 However, the Cloud Console can only create or view sinks in Cloud projects. To create sinks in organizations, folders, or billing accounts using the gcloud command-line tool or Cloud Logging API, see Aggregated sinks. Obviously, the auditor needs to check all projects accessed by data analyst which is not project-level, a higher level like folder or organization level, this can only be done via the aggregate sink. So D is the answer.
upvoted 4 times
...
sumanshu
3 years, 3 months ago
A - eliminated , because logs needs to be retained for 6 months (So, some storage require) B - eliminated, because if we store in same project then, Data Analyst can also access (But in question it's mention, ONLY audit personnel needs access) C - Wrong (No need to restrict project as well as logs separately) - wording does not look okay. D - Correct (If we restrict the project, then all resources get restricted) Vote for D
upvoted 6 times
sumanshu
3 years, 3 months ago
Option 'C' - I guess said - restrict access to the project with the exported logs. (i.e. restrict access of that project from where we took logs) - If I am not wrong... Thus it's INCORRECT
upvoted 2 times
at99
2 years, 9 months ago
Sinks are different from Aggregate Sinks, refer https://cloud.google.com/logging/docs/export/configure_export_v2#api
upvoted 1 times
...
...
...
septiandy
3 years, 6 months ago
what is the difference between C and D? I think it's same.
upvoted 3 times
FP77
1 year, 2 months ago
I think the key difference is that D talks about aggregated sinks.
upvoted 1 times
...
...
haroldbenites
4 years, 2 months ago
D is correct
upvoted 3 times
...
saurabh1805
4 years, 2 months ago
D is correct answer, refer below link for more information.
upvoted 3 times
...
VishalB
4 years, 3 months ago
Ans : D Aggregated Exports, which allows you to set up a sink at the Cloud IAM organization or folder level, and export logs from all the projects inside the organization or folder.
upvoted 5 times
...
[Removed]
4 years, 7 months ago
Answer D
upvoted 4 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