Google Professional-Cloud-Database-Engineer 問題集

質問 1：
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
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your team is building an application that stores and analyzes streaming time series financial dat a. 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 BigQuery.
C. Use Bigtable
D. Use Cloud Spanner.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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 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.
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 different organizations for each database type, and apply policy constraints at the organization level.
D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
正解：D

質問 4：
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
A. Migrate to Compute Engine.
B. Migrate to Cloud SQL for PostgreSQL.
C. Migrate to Google Kubernetes Engine (GKE).
D. Migrate to Cloud SQL for SQL Server.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
A. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
B. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
C. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
D. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
A. For the application server, set up a common shared user account.
B. For the application server, set up a service account.
C. For each application code, set up a common shared user account.
D. For each application code, set up a dedicated user account.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. 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. Configure your Cloud SQL instance with high availability enabled.
B. Create your database with one primary node and one read replica in the region.
C. 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. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
A. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
B. Use data replication tools and CDC tools to enable migration.
C. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
D. Use Database Migration Service to migrate all databases to Cloud SQL.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
A. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
B. Use Memorystore for Memcached.
C. Use Firestore and ensure that the PersistenceEnabled option is set to true.
D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
正解：C
解説: (Topexam メンバーにのみ表示されます)