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

出題：1

Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring.
What should you do?

A. Increase the number of CPUs for your instance.

B. Use many smaller Cloud SQL instances.

C. Increase the storage size for the instance.

D. Use Cloud Spanner instead of Cloud SQL.

正解：B 解答を投票する

出題：2

You are migrating an on-premises database to Spanner. There are a few tables, each with a few hundred records that do not have a primary key on the source database. You need to migrate all of the tables over to the news database while avoiding hot-spotting issues. What should you do-

A. During the migration, swap the order of keys so that the column that contains the monotonically increasing or decreasing value is the first key par.

B. Use the GENERATE_UUID()function to generate universally unique identifier (UUID) values with the STRING(36)data type when you do the migration.

C. Migrate the tables with no primary key to maintain consistency with source.

D. Load the data into Spanner, and designate a primary key later based on business need.

正解：B 解答を投票する

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

出題：3

You are the DBA working at a large bank in Europe. Your business-critical banking application runs on Oracle 12.2 in your on-premises data center. You decided to modernize your on- premises Oracle database by migrating to AlloyDB. You must meet the following requirements:
- Remain on-premises and maintain open-source portability.
- Meet regulatory requirements for data residency.
- Support both OLTP and OLAP workloads.
- Maintain high availability (HA) mode and automatic failover.
What should you do-

A. Deploy AlloyDB Omni in a standalone VM on-premises, and set up disaster recovery (DR) in AlloyDB for PostgreSQL.

B. Migrate to AlloyDB for PostgreSQL by using Database Migration Service.

C. Deploy Kubernetes-based AlloyDB Omni database cluster on-premises. Enable HA by using the AlloyDB Omni Kubernetes operator, and migrate your Oracle database to Omni.

D. Deploy AlloyDB Omni as a docker-based container in your on-premises VM, enable HA for it, and migrate your Oracle database to the Omni container.

正解：C 解答を投票する

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

出題：4

Your team is building an application that stores and analyzes streaming time series financial data.
You need a database solution that can perform time series-based scans with sub-second latency.
The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

A. Use Firestore.

B. Use Cloud Spanner.

C. Use Bigtable

D. Use BigQuery.

正解：C 解答を投票する

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

出題：5

You are developing a Python application that will connect to AlloyDB for PostgreSQL as the backend datastore. Your organization's security requirements do not allow the use of usernames and passwords for database authentication. How should you develop your application-

A. Use the AlloyDB Python connector. Use automated IAM authentication for connectivity.

B. Use the AlloyDB Python connector. Enforce SSL connectivity to AlloyDB by using the gcloud alloydb instance updatecommand with the --ssl-mode=ENCRYPTED_ONLYoption.

C. Use any PostgreSQL-compatible Python client. Connect to the AlloyDB cluster by using Identity- Aware Proxy (IAP).

D. Use any PostgreSQL-compatible Python client. Use a service account name and credential as the username and password respectively during connection.

正解：A 解答を投票する

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

出題：6

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 メンバーにのみ表示されます)

出題：7

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 data. 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 メンバーにのみ表示されます)

出題：8

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

A. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

B. Create your database with one primary node and one read replica in the region.

C. Configure your Cloud SQL instance with high availability enabled.

D. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

正解：D 解答を投票する

出題：9

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A. Migrate the databases to Compute Engine using regional persistent disks.

B. Migrate the databases to Cloud Spanner.

C. Migrate the databases to Bare Metal Solution for Oracle.

D. Migrate the databases to Cloud SQL, and enable a standby database.

正解：C 解答を投票する

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