A gaming company uses a Memorystore for Redis cluster to store player session data. They need to ensure that if a primary node fails, the cluster automatically promotes a replica and continues serving without manual intervention. They also want to minimize the risk of data loss during failover. What should they configure?

Set up a cron job that periodically checks the primary node and manually promotes a replica if needed.

Configure synchronous replication to all replicas and disable automatic failover.

Enable automatic failover and ensure the cluster has at least one replica per shard.

Use a standalone Redis instance without replication and rely on the client to reconnect.

A company runs a Cloud SQL for PostgreSQL instance with HA enabled. They are planning a maintenance window and want to test failover without causing downtime. They also want to ensure that the failover is automatic and does not require manual intervention. What should they do?

Trigger a failover using the Cloud SQL API and verify the application reconnects automatically.

Change the instance's machine type and hope it fails over.

Delete the standby instance and recreate it.

Stop the primary instance and manually promote the standby.

A data engineering team processes daily batch files uploaded to Cloud Storage. Occasionally, files are corrupted during upload. They want to automatically detect corrupted files and reprocess them without manual intervention. What should they implement?

Manually inspect files each morning and re-run the pipeline for any that look wrong.

Store files in a different bucket and hope the corruption does not occur.

Use Cloud Functions to validate file checksums and trigger a Cloud Dataflow job to reprocess invalid files.

Set up a Cloud Scheduler job to re-upload all files every day.

A healthcare company stores patient records in Cloud Storage. They need to protect against accidental deletion and corruption. They also want to be able to restore data to a specific point in time. What should they implement?

Use a single bucket and rely on the storage class to prevent deletion.

Create a backup bucket and manually copy files every day.

Enable versioning and set up object lifecycle management to retain versions for a specific period.

Use a different cloud provider for backup.

A data pipeline writes intermediate results to a temporary directory and then moves them to a final location after processing. If the pipeline restarts after a crash, which strategy best ensures no data loss or duplication?

Use idempotent writes and checkpoints so the job can resume from the last successful state

Delete the temporary directory and start the entire job from scratch

Copy the temporary directory to a backup location before processing

Write directly to the final location without any temporary files

Google CloudProfessional Data Engineer

Domain 5Objective 5

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

Part of the Maintaining and automating data workloads domain, which accounts for ~18% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~9–14 in this domain), expect 2–3 from this objective — we provide 25 practice questions to prepare you well beyond it. (estimate)

25questions here

5free pages

8concepts

~18%of the exam

Questions 16–20

16application · medium
A gaming company uses a Memorystore for Redis cluster to store player session data. They need to ensure that if a primary node fails, the cluster automatically promotes a replica and continues serving without manual intervention. They also want to minimize the risk of data loss during failover. What should they configure?
Select an answer first
17expert · hard
A company runs a Cloud SQL for PostgreSQL instance with HA enabled. They are planning a maintenance window and want to test failover without causing downtime. They also want to ensure that the failover is automatic and does not require manual intervention. What should they do?
Select an answer first
18application · medium
A data engineering team processes daily batch files uploaded to Cloud Storage. Occasionally, files are corrupted during upload. They want to automatically detect corrupted files and reprocess them without manual intervention. What should they implement?
Select an answer first
19application · medium
A healthcare company stores patient records in Cloud Storage. They need to protect against accidental deletion and corruption. They also want to be able to restore data to a specific point in time. What should they implement?
Select an answer first
20foundation · easy
A data pipeline writes intermediate results to a temporary directory and then moves them to a final location after processing. If the pipeline restarts after a crash, which strategy best ensures no data loss or duplication?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.