Professional-Cloud-Database-Engineer試験無料問題集（134題）「Google Cloud Certified

出題：1

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

A. Develop a custom data replication service to send data into BigQuery.

B. Use Cloud SQL federated queries.

C. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

D. Use Database Migration Service to replicate tables into BigQuery.

正解：C 解答を投票する

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

出題：2

You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?

A. Use high availability (HA) Cloud SQL with multiple zones.

B. Use zonal Cloud SQL without high availability (HA).

C. Use Cloud Spanner in a regional configuration.

D. Use Cloud SQL with cross-region replicas.

正解：C 解答を投票する

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

出題：3

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 synchronous replication, and set up read replicas in different regions with asynchronous replication.

B. Set up all read replicas in a different region using asynchronous replication.

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

D. Set up all read replicas in the same region as the primary instance with synchronous replication.

正解：A 解答を投票する

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

出題：4

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

B. Use granular instance sizing in Cloud Spanner and Autoscaler.

C. Manually scale down the number of nodes after the peak period has passed.

D. Use interleaving to co-locate parent and child rows.

正解：B 解答を投票する

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

出題：5

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?

A. Use gcloud sql instances promote-replica <ReplicaInstanceName>.

B. Use gcloud sql instances failover <PrimaryInstanceName>.

C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.

D. Use gcloud sql instances failover <ReplicaInstanceName>.

正解：B 解答を投票する

出題：6

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 external server replication.

B. Use Data Migration Service.

C. Use Cloud SQL for MySQL external replica.

D. Use the mysqldump utility and binary logs.

正解：C 解答を投票する

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

出題：7

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

C. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

D. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

正解：B 解答を投票する

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

出題：8

You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

A. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

B. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.

C. Use Database Migration Service to migrate your database.

D. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.

正解：D 解答を投票する

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

出題：9

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.

B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences

C. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

D. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.

正解：D 解答を投票する

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

出題：10

Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?

A. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance.

B. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance.

C. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.

D. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance.

正解：B 解答を投票する

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

Professional-Cloud-Database-Engineer試験無料問題集「Google Cloud Certified - Professional Cloud Database Engineer 認定」