5.5 Maintaining Awareness of Failures and Mitigating Impact PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 5)

Questions 21–25

1. 21foundation · easy

   Which component is essential for a failover mechanism to work in a managed service?

   • AA larger primary instance
   • BA standby instance that can take over the primary's role
   • CA separate network for each instance
   • DA load balancer to distribute traffic
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A company runs a critical application that depends on a Cloud SQL for PostgreSQL instance. They need to ensure that if the primary instance fails, the application can continue with minimal downtime. They also want to avoid any manual steps during the failover. What should they do?

   • AConfigure the application to use the instance's private IP address and rely on the database's automatic failover.
   • BCreate a read replica and manually promote it when the primary fails.
   • CSet up a cron job to check the primary instance and switch the application's connection string if it fails.
   • DUse a connection string that points to a different instance in another project.
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A media company runs a video transcoding job using Cloud Dataflow. The job must complete within a specific time window, and they want to ensure it can continue if a zone fails. What is the best approach?

   • ARun the job in a single zone and rely on Dataflow's automatic restart.
   • BUse a regional Dataflow job that runs across multiple zones.
   • CUse a single VM to run the transcoding job.
   • DManually monitor the job and restart it if it fails.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   A data engineering team is designing a batch processing pipeline that must continue producing results even if one of its worker nodes fails mid-job. Which design principle directly addresses this requirement?

   • ALoad balancing — distributing incoming requests evenly across all workers
   • BAutomatic recovery — detecting the failure and restarting the failed worker immediately
   • CGraceful degradation — reducing the quality of output when a failure occurs
   • DRedundancy — running multiple worker replicas so the job can be retried on healthy nodes
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is the primary purpose of maintaining backups of a dataset in a data pipeline?

   • ATo improve query performance
   • BTo reduce storage costs
   • CTo enable recovery of data if it is corrupted or lost
   • DTo automatically scale the pipeline
   Reveal Solution Discussion Select an answer first