Google Professional Data Engineer Question 257
Select 2Google Cloud PlatformYou are a data engineer at a company that has recently launched a new application hosted on Google Cloud. The application has a BigQuery dataset that is queried frequently by analysts. To monitor and control planned usage and costs, you need to set up alerts while ensuring that the analysts are not interrupted during their work. Which of the following steps should you take?
- A
Set up a budget in Cloud Billing and configure alerts for when spending approaches predefined thresholds.
- B
Enable BigQuery slot reservations to limit the number of concurrent queries.
- C
Use Cloud Monitoring to create custom metrics that track BigQuery query costs in real time.
- D
Implement query quotas to restrict the number of queries analysts can run daily.
- E
Enable Cloud Audit Logs to log all access and queries to the BigQuery dataset.
Show answer and explanation
Correct answers: A, C
Explanation
To monitor planned usage while ensuring analysts are not interrupted, you should focus on tracking costs and setting up alerts without enforcing hard limits. Setting a budget in Cloud Billing with alerts helps you manage costs effectively, and using Cloud Monitoring for custom metrics provides detailed visibility into query expenses. These steps allow proactive cost management without restricting user activity.
- A. Correct.
Setting up a budget in Cloud Billing and configuring alerts allows you to monitor and manage costs by notifying you when spending nears or exceeds planned thresholds, without impacting user activity.
- B. Incorrect.
BigQuery slot reservations are used to allocate dedicated resources for query execution but do not directly help in monitoring or controlling planned usage.
- C. Correct.
Creating custom metrics in Cloud Monitoring can provide detailed insight into query costs in near real-time, helping you track spending effectively.
- D. Incorrect.
While query quotas can limit usage, they may disrupt analysts' work, which goes against the requirement to ensure uninterrupted work.
- E. Incorrect.
Cloud Audit Logs are useful for auditing and security purposes but do not directly help in monitoring or controlling planned usage.