Professional Cloud Database Engineer 시험 - Google실제시험문제와 답 - 120문항

Question No : 1

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency .
What should you do?

A.Configure Firestore, and modify your application to offload queries.
B.Configure Bigtable, and modify your application to offload queries.
C.Configure Cloud SQL for PostgreSQL read replicas to offload queries.
D.Configure Memorystore, and modify your application to offload queries.

정답:

Question No : 2

You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices .
What should you do?

A.Use Cloud Functions to run the export in Avro format.
B.Use Cloud Functions to run the export in text format.
C.Use Dataflow to run the export in Avro format.
D.Use Dataflow to run the export in text format.

정답:

Question No : 3

You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases .
What should you do?

A.Set up a Shared VPC, configure multiple service projects, and create firewall rules.
B.Set up Serverless VPC Access.
C.Set up Private Service Connect.
D.Set up Traffic Director.

정답:

Question No : 4

You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out .
What should you do?

A.Close idle connections or restart the instance before beginning the import operation.
B.Increase the amount of memory allocated to your instance.
C.Ensure that the service account has the Storage Admin role.
D.Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.

정답:

Question No : 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 significant, use backup and restore, and specify a recovery timestamp.
B.If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
C.If the corruption is significant, use import and export.
D.If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
E.If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.

정답:

Question No : 6

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 an in-app embedded database.
D.Use Cloud Spanner.

정답:

Question No : 7

Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1 .
What should you do?

A.Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-west1-b. Create a read replica in us-east1-c.
B.Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-central1-b. Create a read replica in us-east1-b.
C.Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east-b. Create a read replica in us-east1-c.
D.Provision a Cloud SQL for MySQL instance in us-central1-a. Create a multiple-zone instance in us-east1-b. Create a read replica in us-central1-b.

정답:

Question No : 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 solid-state drives (SSD).
B.Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
C.Recommend hard disk drives (HDD).
D.Recommend mixed storage types.

정답:

Question No : 9

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.Increase the number of processing units.
B.Modify the database schema, and add additional indexes.
C.Shard data required by the application into multiple instances.
D.Decrease the number of processing units.

정답:

Question No : 10

You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup .
What should you do?

A.Check the cloudsql.googleapis.com/postgres.log instance log.
B.Perform the gcloud sql operations list command.
C.Use Cloud Audit Logs to verify the status.
D.Use the Google Cloud Console.

정답:

Question No : 11

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space .
What should you do to address this storage alert?

A.Normalize the database to the third normal form.
B.Compress the data using a different compression algorithm.
C.Manually or automatically increase the storage capacity.
D.Create another schema to load older data.

정답:

Question No : 12

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 a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQ
B.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.
C.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.
D.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.
E.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.

정답:

Question No : 13

Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over .
What should you do? (Choose two.)

A.Use Database Migration Service to migrate the databases to Cloud SQ
B.Use a cross-region read replica to migrate the databases to Cloud SQ
C.Use replication from an external server to migrate the databases to Cloud SQ
D.Use an external read replica to migrate the databases to Cloud SQ
E.Use a read replica to migrate the databases to Cloud SQ

정답:

Question No : 14

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.

정답:

Question No : 15

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.Drop or disable all users except database administration users.
B.Disable all foreign key constraints on the source PostgreSQL database.
C.Ensure that all PostgreSQL tables have a primary key.
D.Shut down the database before the Data Migration Service task is started.
E.Ensure that pglogical is installed on the source PostgreSQL database.

정답:

Google Professional Cloud Database Engineer 시험