Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Professional Cloud Database Engineer practice bank has an additional 769 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A database team manages mission-critical Cloud SQL for PostgreSQL high-availability (HA) instances within a Google Cloud project. To protect database availability, the team needs immediate, automated alerts when:
Which monitoring configuration should the team implement?
SQL-based alerting policies in Observability Analytics run scheduled SQL queries via the BigQuery engine against trace data stored in a linked BigQuery dataset (such as the _AllSpans view in the _Trace observability bucket) and trigger alerts when query results meet a row count threshold or boolean condition.
The team needed periodic aggregate analytics over distributed Cloud Trace span data rather than real-time alerting on Cloud SQL availability metrics and failover logs.
Any time series violates) for disk usage and availability, linked to both Slack and PagerDuty channels with closure notifications enabled.Cloud Monitoring alerting policies evaluate time-series metrics and Cloud Logging entries in real time, opening an incident and dispatching notifications whenever specified availability or performance conditions are violated.
SCHEDULED or STARTED states).Any time series violates triggers as soon as a single database instance stops reporting metric data for the configured retest window.Combining log-based and metric-based alerting policies in Cloud Monitoring covers both discrete operational events and continuous resource health, delivering immediate, redundant visibility into every threat to Cloud SQL availability.
Database Center provides a centralized dashboard for viewing database fleet inventory, configuration health, and resource utilization across Google Cloud. While its Alerts tab surfaces project-level incidents and alerting policies, the policies themselves are managed in Cloud Monitoring (Google Cloud Observability).
The goal was to centrally inspect fleet-wide health issues, verify high-availability and enhanced backup compliance across projects, and perform regular manual health checks rather than receiving automated, real-time incident alerts.
For automated availability awareness, engineers must define project-level Cloud Monitoring policies paired with redundant notification channels rather than expecting Database Center to emit alerts natively.
A forecasted metric-value condition predicts whether a metric will cross a threshold within an upcoming window (1 hour to 7 days), while a metric-absence condition with All time series violate fires only when every monitored time series stops reporting data simultaneously.
All time series violate means that if one Cloud SQL instance becomes unavailable while others remain healthy, no alert is triggered; only a project-wide failure of all instances would open an incident.Any time series violates vs. All time series violate: Individual database availability requires Any time series violates so any single failed instance triggers an alert.The requirement was solely to predict multi-day disk capacity trends and alert only when an entire cluster of resources went offline together.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated