Professional-Cloud-Database-Engineer無料問題集「Google Cloud Certified

質問 1

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

（A）Schedule automated backups.

（B）Set up manual backups.

（C）Configure single zone availability for automated backups.

（D）Enable point-in-time recovery.

（E）Create a PostgreSQL database on-premises as the HA option.

正解：A、D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

（A）Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

（B）Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

（C）Create one regional Cloud SQL instance with a read replica in another region.

（D）Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)

（A）Identify whether the source database uses customer-managed encryption keys (CMEK).

（B）Identity all tables that do not have at least one foreign key.

（C）Identify whether the source database is encrypted using pgcrypto extension.

（D）Identify all tables that do not have a primary key.

（E）Identify whether the database has over 512 tables.

正解：A、B 解答を投票する

質問 4

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

（A）Set up different organizations for each database type, and apply policy constraints at the organization level.

（B）Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

（C）Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

（D）Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

正解：D 解答を投票する

質問 5

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

（A）Set up all read replicas in a different region using asynchronous replication.

（B）Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

（C）Set up all read replicas in the same region as the primary instance with synchronous replication.

（D）Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

（A）Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

（B）Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

（C）Configure the primary, standby, and read replica instances in zone A, all in the same region.

（D）Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over.
What should you do? (Choose two.)

（A）Use a read replica to migrate the databases to Cloud SQL.

（B）Use a cross-region read replica to migrate the databases to Cloud SQL.

（C）Use Database Migration Service to migrate the databases to Cloud SQL.

（D）Use an external read replica to migrate the databases to Cloud SQL.

（E）Use replication from an external server to migrate the databases to Cloud SQL.

正解：C、E 解答を投票する

質問 8

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

（A）Reduce the number of automated backups that are retained to two (2).

（B）Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

（C）Select a different region to store your backups.

（D）Set the automated backups to occur every other day to lower the frequency of backups.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

（A）Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

（B）Place both the application VMs and the Cloud SQL instances in the default network of each project.

（C）Use the default networks, and leverage Cloud VPN to connect the two together.

（D）Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

（A）Use Firestore.

（B）Use Bigtable.

（C）Use Cloud SQL for MySQL

（D）Use Cloud Spanner.

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

Professional-Cloud-Database-Engineer 無料問題集「Google Cloud Certified - Professional Cloud Database Engineer」

弊社を連絡する

関連リンク

トップ試験