Professional-Cloud-Database-Engineer試験無料問題集（134題）「Google Cloud Certified

出題：1

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. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).

B. Reduce the number of automated backups that are retained to two (2).

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.

正解：B 解答を投票する

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

出題：2

You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?

A. Migrate to Google Kubernetes Engine (GKE)

B. Migrate to Bare Metal Solution for Oracle.

C. Migrate to Google Cloud VMware Engine

D. Migrate to Compute Engine.

正解：B 解答を投票する

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

出題：3

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

A. Take one manual backup per day, and turn off transaction log retention.

B. Take no backups, and turn off transaction log retention.

C. Turn on automated backup, and turn off transaction log retention.

D. Turn on automated backup, and turn on transaction log retention.

正解：C 解答を投票する

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

出題：4

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

A. Add more read-write replicas.

B. Place the bulk of the read and write workloads closer to the default leader region.

C. Use staleness of at least 15 seconds.

D. Keep the total CPU utilization under 45% in each region.

正解：B 解答を投票する

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

出題：5

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

A. Use Firestore in Datastore mode.

B. Use a Bigtable instance with clusters in multiple regions.

C. Use Cloud SQL for PostgreSQL with both cross-region read replicas.

D. Use Cloud Spanner in a multi-region configuration.

正解：D 解答を投票する

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

出題：6

Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

A. Run the Recommender API to identify overprovisioned instances.

B. Use Query Insights to identify idle instances.

C. Build indexes on heavily accessed tables.

D. Remove inactive user accounts.

正解：A 解答を投票する

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

出題：7

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

A. Use Cloud SQL with a regional read replica to deploy the database.

B. Use Cloud Spanner to deploy the database.

C. Use BigQuery to deploy the database

D. Use Bigtable with clusters in multiple regions to deploy the database

正解：B 解答を投票する

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

出題：8

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

A. Apply an instance data management pattern.

B. Apply a table data management pattern.

C. Apply a database data management pattern.

D. Apply a schema data management pattern.

正解：A 解答を投票する

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

出題：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. Place both the application VMs and the Cloud SQL instances in the default network of each project.

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

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.

正解：B 解答を投票する

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

出題：10

You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?

A. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.

B. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.

C. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.

D. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

正解：D 解答を投票する

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

Professional-Cloud-Database-Engineer試験無料問題集「Google Cloud Certified - Professional Cloud Database Engineer 認定」