A company uses Cloud SQL for MySQL for their transactional database. They want to ensure that data is not lost if the primary instance fails. They also want to minimize downtime. What should they configure?

Use a single instance and rely on automatic backups.

Create a read replica and promote it manually when the primary fails.

Use a different database engine that does not support HA.

Enable high availability (HA) configuration on the instance.

When configuring Cloud SQL for high availability, what is the role of the standby instance?

To serve read traffic alongside the primary

To automatically take over as the primary instance if the primary fails

To run backups of the primary's data

To provide additional storage for the primary

In a Redis cluster with replication, what is the primary purpose of having replica shards?

To provide failover capability if a primary shard fails

To increase the total memory capacity of the cluster

To store data that does not fit on the primary shard

What is the primary purpose of using checkpointing in a long-running data processing job?

To enable the job to resume from a known state after a failure or restart

To automatically scale the job across more workers

To reduce the amount of data that needs to be processed

To increase the speed of individual processing steps

What is a key trade-off when choosing asynchronous replication over synchronous replication?

Asynchronous replication provides lower write latency but may lose recent data if the primary fails

Asynchronous replication is more complex to configure

Asynchronous replication provides stronger durability but higher latency

Asynchronous replication requires more storage space

Google CloudProfessional Data Engineer

Domain 5Objective 5

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

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 1–5

1application · medium
A company uses Cloud SQL for MySQL for their transactional database. They want to ensure that data is not lost if the primary instance fails. They also want to minimize downtime. What should they configure?
Select an answer first
2foundation · easy
When configuring Cloud SQL for high availability, what is the role of the standby instance?
Select an answer first
3foundation · easy
In a Redis cluster with replication, what is the primary purpose of having replica shards?
Select an answer first
4foundation · easy
What is the primary purpose of using checkpointing in a long-running data processing job?
Select an answer first
5foundation · easy
What is a key trade-off when choosing asynchronous replication over synchronous replication?
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.