804 お客様のコメント
質問 1：
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 Cloud Spanner for data storage.
B. Use Bigtable for data storage.
C. Use Cloud SQL for data storage.
D. Use Memorystore for data storage.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2：
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 each application code, set up a dedicated user account.
B. For the application server, set up a common shared user account.
C. For the application server, set up a service account.
D. For each application code, set up a common shared user account.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3：
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
A. Create the database with Google-managed encryption keys.
B. Create the database persistent disk with Google-managed encryption keys.
C. Create the database with customer-managed encryption keys.
D. Create the database persistent disk with customer-managed encryption keys.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 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 instance in one region, the standby instance in a second region, and the read replica in a third region.
B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C. 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.
D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
A. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
C. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
D. If the corruption is significant, use import and export.
E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
正解：B,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 6：
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 Bigtable
B. Use Cloud Spanner.
C. Use Firestore.
D. Use BigQuery.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)
質問 7：
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
A. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
B. Set up all read replicas in the same region as the primary instance with synchronous replication.
C. Set up all read replicas in a different region using asynchronous replication.
D. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 8：
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
A. Recommend mixed storage types.
B. Recommend solid-state drives (SSD).
C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
D. Recommend hard disk drives (HDD).
正解：B
解説: (Pass4Test メンバーにのみ表示されます)
質問 9：
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 storage size for the instance.
B. Use Cloud Spanner instead of Cloud SQL.
C. Increase the number of CPUs for your instance.
D. Use many smaller Cloud SQL instances.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
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 Cloud Spanner for data storage.
B. Use Bigtable for data storage.
C. Use Cloud SQL for data storage.
D. Use Memorystore for data storage.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2：
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 each application code, set up a dedicated user account.
B. For the application server, set up a common shared user account.
C. For the application server, set up a service account.
D. For each application code, set up a common shared user account.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3：
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
A. Create the database with Google-managed encryption keys.
B. Create the database persistent disk with Google-managed encryption keys.
C. Create the database with customer-managed encryption keys.
D. Create the database persistent disk with customer-managed encryption keys.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 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 instance in one region, the standby instance in a second region, and the read replica in a third region.
B. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
C. 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.
D. Configure the primary, standby, and read replica instances in zone A, all in the same region.
正解：C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5：
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
A. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
B. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
C. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
D. If the corruption is significant, use import and export.
E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
正解：B,C
解説: (Pass4Test メンバーにのみ表示されます)
質問 6：
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 Bigtable
B. Use Cloud Spanner.
C. Use Firestore.
D. Use BigQuery.
正解：A
解説: (Pass4Test メンバーにのみ表示されます)
質問 7：
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
A. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
B. Set up all read replicas in the same region as the primary instance with synchronous replication.
C. Set up all read replicas in a different region using asynchronous replication.
D. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
質問 8：
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
A. Recommend mixed storage types.
B. Recommend solid-state drives (SSD).
C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
D. Recommend hard disk drives (HDD).
正解：B
解説: (Pass4Test メンバーにのみ表示されます)
質問 9：
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 storage size for the instance.
B. Use Cloud Spanner instead of Cloud SQL.
C. Increase the number of CPUs for your instance.
D. Use many smaller Cloud SQL instances.
正解：D
解説: (Pass4Test メンバーにのみ表示されます)
Sakurai -
GoogleさんのProfessional-Cloud-Database-Engineerの問題集を使用し、2週間で2回回すことで難問に足を引っ張らなくなり無事合格できました。