Google Professional Data Engineer
Get started today
Ultimate access to all questions.
You are managing data workflows in a cloud environment and want to closely monitor activity in Google BigQuery. Specifically, you need to keep track of when new data is appended to a particular table by an insert job and receive instant notifications in your monitoring tool for this specific table only. You do not want to be alerted for activities involving other tables. How should you configure Google Stackdriver Logging to achieve this?
You are managing data workflows in a cloud environment and want to closely monitor activity in Google BigQuery. Specifically, you need to keep track of when new data is appended to a particular table by an insert job and receive instant notifications in your monitoring tool for this specific table only. You do not want to be alerted for activities involving other tables. How should you configure Google Stackdriver Logging to achieve this?
Explanation:
The correct answer is D. This option suggests using the Stackdriver API to create a project sink with an advanced log filter to export to Pub/Sub and subscribing to the topic from your monitoring tool. This approach allows you to set up a custom log sink with an advanced filter that targets a specific table. This ensures that you only receive notifications for the table you are interested in, avoiding notifications from other tables. Options A and B do not offer notifications to the monitoring tool, and option C does not provide the necessary filtering to ensure that only relevant logs are sent.