Professional-Cloud-Database-Engineer問題集、Google実際の試験問題

質問 1

You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process data. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.

B. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.

C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

D. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.

正解: B

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

質問 2

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

A. Configure Memorystore, and modify your application to offload queries.

B. Configure Firestore, and modify your application to offload queries.

C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.

D. Configure Bigtable, and modify your application to offload queries.

正解: A

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

質問 3

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?

A. Increase the amount of memory allocated to your instance.

B. Close idle connections or restart the instance before beginning the import operation.

C. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

D. Ensure that the service account has the Storage Admin role.

正解: B

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

質問 4

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, standby, and read replica instances in zone A, all in the same region.

B. 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.

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

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

正解: B

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

質問 5

Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

A. Identify and optimize slow running queries, or set parallel replication flags.

B. Edit the primary instance to add additional memory.

C. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

D. Stop all running queries, and re-create the replicas.

正解: A

質問 6

You work for a financial services company that wants to use fully managed database services.
Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

A. Use direct scaling to implement the Autoscaler-based architecture.

B. Use linear scaling to implement the Autoscaler-based architecture

C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

正解: B

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

質問 7

Your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL.
As a part of the migration, you need to convert schema and other database code objects, such as procedures, functions, and triggers, from Oracle to PostgreSQL. The database migration needs to be accomplished with minimal application code changes and manual intervention. What is the Google-recommended approach you should do-

A. Manually rewrite both the Oracle schema and queries to be compatible with PostgreSQL syntax and semantics.

B. Use Database Migration Service code conversion workspace, then review and refactor as needed.

C. Migrate the data directly from Oracle to PostgreSQL without any conversion. Rely on application- level compatibility layers to handle any syntax or semantic differences.

D. Use a schema conversion tool to automatically convert the Oracle schema to PostgreSQL schema, then manually rewrite all queries.

正解: B

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

質問 8

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. Load the data into Spanner, and designate a primary key later based on business need.

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

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

D. 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.

正解: C

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

質問 9

You are configuring a new application that has access to an existing Cloud Spanner database.
The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A. Create a new service account, and grant it the Cloud Spanner Database Admin role.

B. Reuse the existing service account that populates this database.

C. Create a new service account, and grant it the Cloud Spanner Database Reader role.

D. Create a new service account, and grant it the spanner.databases.select permission.

正解: C

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

質問 10

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AlloyDB cluster with Private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AlloyDB in a cost-effective way. What should you do-

A. Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.

B. Connect by using the private IP address of the AlloyDB cluster directly from the application.

C. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.

D. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

正解: D

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

質問 11

Your e-learning platform runs on a Cloud SQL for PostgreSQL instance (16 VCPUs, 60 GB memory and 1TB SSD) serving users in North America. Your analytics team runs complex reporting queries that often consume 80% of CPU resources, causing slow response times for student transactions during peak hours. Current workload includes 8,000 transactions per second with 60% reads and 40% writes. The reporting queries involve JOIN operations across multiple large tables with millions of rows requiring highly efficient analytical processing. The platform also experiences sudden spikes in analytical reporting demand, requiring an elastic scaling of read capacity. You need to improve the query performance for your analytics team to run their reports efficiently without impacting transactional users. You also need to plan for future traffic growth.
What should you do-

A. Upgrade to Cloud SAL for PostgreSQL Enterprise Edition and route transaction and analytical queries to the primary instance.

B. Upgrade the Cloud SQL for PostgreSQL instance to db-n1-highmem-32and implement connection pooling with PgBouncerto handle increased load.

C. Migrate to AlloyDB for PostgreSQL and upgrade the machine type of the primary instance to 32 vCPU. Create materialized views for common analytical queries.

D. Migrate to AlloyDB for PostgreSQL with a 16 vCPU primary instance and enable columnar engine for analytical workloads, using read pools for query isolation.

正解: D

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

Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer 模擬練習