Google Professional-Cloud-Database-Engineer 問題集

質問 1：
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
A. Use Firestore.
B. Use Cloud SQL with an external (public) IP address.
C. Use Cloud Spanner.
D. Use an in-app embedded database.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
A. Use Data Migration Service.
B. Use external server replication.
C. Use Cloud SQL for MySQL external replica.
D. Use the mysqldump utility and binary logs.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
A. Create a read replica, and then use the mysqldump utility to export each table.
B. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
C. Use Cloud SQL serverless exports.
D. Use the mysqldump utility on the primary database instance to export the backup.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
A. Use Memorystore for data storage.
B. Use Cloud SQL for data storage.
C. Use Cloud Spanner for data storage.
D. Use Bigtable for data storage.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
A. Write a utility to scan application logs.
B. Write a utility to scan database query logs.
C. Shut down and restart each application.
D. Use query tags to add application-centric database monitoring.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
A. Use Bigtable with multi-region clusters.
B. Use Cloud Spanner with multi-region configuration.
C. Use Memorystore for Redis with multi-zones within a region.
D. Use Cloud SQL for PostgreSQL with cross-region replicas.
正解：D

質問 7：
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?
A. Decrease the number of processing units.
B. Modify the database schema, and add additional indexes.
C. Increase the number of processing units.
D. Shard data required by the application into multiple instances.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
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. Build indexes on heavily accessed tables.
C. Remove inactive user accounts.
D. Use Query Insights to identify idle instances.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
A. Ask existing users to set their Google password to match their corporate password.
B. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
C. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
D. Use workload identity federation to impersonate a service account.
正解：D
解説: (Topexam メンバーにのみ表示されます)