Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An enterprise data lake team runs analytical queries against large data lake datasets in BigQuery. The team notices intermittent performance degradation and wants to establish proactive observability to identify bottlenecks and optimize compute resource allocation.
They have the following operational requirements:
Which configuration should the team implement in Cloud Monitoring?
This configuration relies on deploying the Google Cloud Ops Agent on Compute Engine virtual machines to collect host-level process and hardware metrics, alerting when host OS Reported CPU % exceeds an 80% threshold.
The workload were running on a self-managed Hadoop or Spark cluster deployed on raw Compute Engine instances without Dataproc managed agents.
This option uses Synthetic Monitors and broken-link checkers to issue continuous HTTP/HTTPS probes against the BigQuery public REST API endpoint and alert on HTTP error status codes.
The requirement was to validate the external network availability of a public-facing API endpoint or web service.
This approach uses Cloud Logging to create a custom log-based metric tracking the total count of query execution log entries from Cloud Audit Logs, coupled with alerting on overall query throughput and monitoring BigQuery Data Transfer Service (DTS) metrics.
The objective were to track the success and failure counts of automated BigQuery Data Transfer Service configurations or detect sudden spikes in total query submission rates.
Cloud Monitoring natively ingests operational telemetry and performance metrics from BigQuery, allowing administrators to monitor compute consumption, track query latency percentiles, and build customized visualization dashboards.
This approach directly utilizes built-in Google Cloud system metrics and standard statistical aggregators in Cloud Monitoring. It achieves comprehensive query latency and compute slot observability with zero custom agent or data ingestion overhead.
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