Google Professional-Cloud-Database-Engineer 問題集

質問 1：
Which connection method should applications use to connect to a regional Cloud Memorystore for Redis instance to keep 99th percentile latency under 4 milliseconds while minimizing operational overhead?
A. Use a regional load balancer in front of Redis
B. Private Service Connect
C. Use the Redis private IP in the same VPC and region
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Your company's mission-critical, globally available application is supported by a Cloud Spanner database. Experienced users of the application have read and write access to the database, but new users are assigned read-only access to the database. You need to assign the appropriate Cloud Spanner Identity and Access Management (IAM) role to new users being onboarded soon.
What roles should you set up?
A. roles/spanner.databaseUser
B. roles/spanner.backupWriter
C. roles/spanner.databaseReader
D. roles/spanner.viewer
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
How should you export approximately 40 million Firestore documents to BigQuery while ensuring fault tolerance, automatic scaling, and the option to apply transformations?
A. Cloud Dataflow with Apache Beam
B. BigQuery Data Transfer Service
C. Firestore export to Cloud Storage and BigQuery load
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
A. Migrate the existing database to Cloud SQL for PostgreSQL.
B. Migrate the existing database to Cloud Spanner.
C. Migrate the existing database to PostgreSQL running on Compute Engine.
D. Migrate the existing database to Firestore.
正解：A

質問 5：
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 database data management pattern.
C. Apply a table data management pattern.
D. Apply a schema data management pattern.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You run a 24x7 online travel agency using Spanner. Your company provides services to book hotels, flights, and local attractions which are fulfilled by your partners. You need to enable your partners to access their respective booking data for reconciliation and analysis in real time. You need a solution that provides your partners secure access, the ability to run ad hoc SQL read queries with minimal to no disruption to your existing reservation platform. You want to keep costs to a minimum.
What should you do?
A. Create a view for each partner by using federated queries in BigQuery, and grant each partner IAM access on their view.
B. Create a view on Spanner for each partner, and grant each partner IAM access on their view.
C. Batch export each partner's data as a CSV file into separate Cloud Storage buckets.
D. Use a change stream to replicate data into BigQuery for ad hoc reporting needs.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?
A. Use VPC Service Controls to create a trusted network for the Bigtable service.
B. Use Identity and Access Management (IAM) for Bigtable access control.
C. Use customer-managed encryption keys (CMEK).
D. Use Google Cloud Armor to add IP addresses to an allowlist.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Riverton Analytics runs Microsoft SQL Server on premises with two read-only replicas, and the nightly differential backups for 28 databases have become expensive and difficult to manage.
They plan to move to Google Cloud following recommended practices and they must keep the cutover window under 20 minutes with minimal disruption. What should you do?
A. Configure Cloud SQL for SQL Server as a subscriber to the on premises publisher and replicate continuously until you cut over
B. Create a Google Kubernetes Engine cluster, deploy SQL Server, and restore the backup file
C. Create a Compute Engine VM, install SQL Server, and import the backup file
D. Take a native SQL Server backup to Cloud Storage and restore it into a new Cloud SQL for SQL Server instance
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
A. Ensure that all PostgreSQL tables have a primary key.
B. Drop or disable all users except database administration users.
C. Shut down the database before the Data Migration Service task is started.
D. Disable all foreign key constraints on the source PostgreSQL database.
E. Ensure that pglogical is installed on the source PostgreSQL database.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)