最新Google Cloud Certified Professional-Cloud-Database-Engineer考試題庫，Google Professional-Cloud-Database-Engineer課程的擬真試題下載

問題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. Use Database Migration Service to replicate tables into BigQuery.

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

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

D. Use Cloud SQL federated queries.

正確答案: C

問題2
You are configuring a new application that has access to an existing Cloud Spanner database.
The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A. Reuse the existing service account that populates this database.

B. Create a new service account, and grant it the spanner.databases.select permission.

C. Create a new service account, and grant it the Cloud Spanner Database Admin role.

D. Create a new service account, and grant it the Cloud Spanner Database Reader role.

正確答案: D

說明：（僅 NewDumps 成員可見）

問題3
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hotspots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)

A. Promote high-cardinality attributes in multi-attribute primary keys.

B. Promote low-cardinality attributes in multi-attribute primary keys.

C. Use bit-reverse sequential value as the primary key.

D. Normalize the data model.

E. Use an auto-incrementing value as the primary key.

正確答案: A,C

說明：（僅 NewDumps 成員可見）

問題4
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. Decrease the number of processing units.

C. Shard data required by the application into multiple instances.

D. Modify the database schema, and add additional indexes.

正確答案: A

問題5
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. 1. Create migration job using Database Migration Service.
2. 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.
3. Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
4. Update your application connections to the new instance.

B. 1. Create migration job using Database Migration Service.
2. Set the migration job type to One-time, and perform this migration during a maintenance window.
3. 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.
4. Update your application connections to the new instance.

C. 1. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
2. 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.
3. Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance.

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

正確答案: A

問題6
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403:
Access Not Configured. What should you do?

A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

B. Ensure that you are using an external (public) IP address interface.

C. Enable the Cloud SQL Admin API.

D. Check whether your service account has cloudsql.instances.connect permission.

正確答案: C

說明：（僅 NewDumps 成員可見）

問題7
You have a regional Spanner instance with no autoscaler that is serving a production workload.
You observed a surge in write activities to the database during an ongoing promotional event.
You received an alert that the database is close to the storage limit. Based on the storage utilization trend, the database will run out of storage in the next few hours. You want to resolve this issue as soon as possible. What should you do-

A. Create a custom instance configuration and add a custom read-only replica to the Spanner instance.

B. Archive and delete historical data from the database.

C. Increase the compute capacity of the Spanner instance.

D. Move the Spanner instance to a multi-regional configuration.

正確答案: B

說明：（僅 NewDumps 成員可見）

問題8
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 the mysqldump utility and binary logs.

B. Use external server replication.

C. Use Cloud SQL for MySQL external replica.

D. Use Data Migration Service.

正確答案: C

說明：（僅 NewDumps 成員可見）

問題9
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

A. Set up a Cloud NAT gateway on the Compute Engine VM.

B. Set up bring your own IP (BYOIP) in your VPC.

C. Setup a static external IP address in your VPC network.

D. Set up Cloud NAT service.

正確答案: A

說明：（僅 NewDumps 成員可見）

問題10
You are migrating your on-premises Oracle database to Cloud SQL for PostgreSQL by using Database Migration Service. You observed one of your important production tables DML changes are not getting replicated on the target. All other tables are getting migrated to the target without any errors.
What could be the problem and what should you do to resolve it?

A. Supplemental logging has not been enabled for the database. Enable supplemental logging.

B. The table is an index-organized table. Change it to a normal heap-organized table.

C. The table has a column of type NCLOB. Drop the column.

D. The Oracle table does not have a primary key created. Create a primary key on the table.

正確答案: D

說明：（僅 NewDumps 成員可見）

問題11
Your company uses a custom application to service thousands of users. The application is running on a Compute Engine and a Cloud SQL for PostgreSQL database. The company requires database passwords to be changed every 60-days. You need to ensure that the credentials used by the web application to connect to the database are managed securely. What should you do-

A. 1. Store the credentials in a text file in a Cloud Storage bucket.
2. Modify the application to download the text file and retrieve the credentials on startup.
3. Update the text file every 60-days.

B. 1. Store the credentials to the database in Secret Manager.
2. Modify the application to retrieve the credentials from Secret Manager on startup.
3. Configure the rotation interval to 60-days.

C. 1. Configure IAM database authentication for the application to connect to the database.
2. Create an IAM user and map it to a separate database user for each application user.

D. 1. Store the credentials in an encrypted text file in the application.
2. Use Cloud Key Management Service (Cloud KMS) to store the key for decrypting the text file.
3. Modify the application to decrypt the text file and retrieve the credentials on startup.
4. Update the text file every 60-days.

正確答案: B

說明：（僅 NewDumps 成員可見）

問題12
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 Cloud SQL for PostgreSQL read replicas to offload queries.

B. Configure Firestore, and modify your application to offload queries.

C. Configure Bigtable, and modify your application to offload queries.

D. Configure Memorystore, and modify your application to offload queries.

正確答案: D

說明：（僅 NewDumps 成員可見）

問題13
HelioBank is deploying Cloud SQL for MySQL in europe-west1 to support payment processing for example.com. The compliance team requires that data at rest be encrypted with a key that they own and manage in a specific European location, and they must control the key lifecycle including rotation and disablement. They also need all client connections to be encrypted from end to end.
What should they configure?

A. Create the Cloud SQL for MySQL instance with Google managed encryption keys and secure access using VPC Service Controls

B. Create the Cloud SQL for MySQL instance using customer managed encryption keys and place it behind Cloud VPN for all client connectivity

C. Create the Cloud SQL for MySQL instance using customer managed encryption keys from Cloud KMS in the required region and require SSL or TLS for client connections

D. Create the Cloud SQL for MySQL instance with Google managed encryption keys and require SSL or TLS

正確答案: C

說明：（僅 NewDumps 成員可見）

問題14
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 SQL with cross-region replicas.

D. Use Cloud Spanner in a regional configuration.

正確答案: D

問題15
Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

A. Set Terraform deletion_protection to true.

B. Rerun terraform apply.

C. Create a read replica.

D. Use point-in-time-recovery (PITR) to recover the database.

正確答案: A

說明：（僅 NewDumps 成員可見）

先試後買

購買之前，你可以先嘗試下載一個試用版本。目前我們只提供PDF版本的試用DEMO，軟件版本只提供截圖。

專業認證

品質保證

輕松通過

Try Before Buy

最新的真實試題

相關鏈接

聯繫我們