最新的Google Cloud Certified認證 Professional-Cloud-Database-Engineer考試題庫

問題1

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

A. Use Cloud Spanner with default encryption.

B. Use Bigtable with default encryption.

C. Use Cloud Spanner with a customer-managed encryption key (CMEK).

D. Use Cloud SQL with a customer-managed encryption key (CMEK).

正確答案: C

問題2

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3).
During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

A. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

B. Delete DB-2 so that DB-1 automatically reverts to the primary instance.

C. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

D. Bring DB-1 back online.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題3

BrightTrail Outfitters is moving an order processing platform from its data center to Google Cloud.
The application depends on a MySQL backend that must remain highly available because it supports mission critical transactions. The business requires a recovery time objective and a recovery point objective of no more than 12 minutes during a regional incident. You will use a Google managed database service. What should you implement to achieve the highest possible uptime for this workload?

A. Provision Cloud SQL for MySQL with regional high availability and create a cross region read replica that you can promote to primary if the region fails

B. Migrate the database to multi region Cloud Spanner and refactor the schema and application so that a regional outage does not interrupt service

C. Deploy Cloud SQL for MySQL as a single zone instance and add a read replica in another zone and a second replica in a distant region for disaster recovery

D. Set up Cloud SQL for MySQL with regional high availability and rely on scheduled backups to restore a new instance in a different region when a disaster occurs

正確答案: A

說明：（僅 VCESoft 成員可見）

問題4

You are building a point of sale (POS) application to deploy in your retail company's stores. The application needs to run on a mobile device, but with the ability to keep catalog, pricing, and product data current with frequent updates from a central location. The network at the stores may not be reliable, so the application must be able to run without connectivity. You want to minimize development time and costs.
What should you do?

A. Create a web application with Cloud Run and Cloud SQL.

B. Create a Firebase application with Firestore as the database.

C. Create a native solution, supporting Android and iOS, by using SQLite, and develop a synchronization API with a central AlloyDB database.

D. Create a native solution using AlloyDB Omni in the mobile device and synchronizing with AlloyDB in Google Cloud.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題5

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. Use the Google Cloud Console.

C. Use Cloud Audit Logs to verify the status.

D. Perform the gcloud sql operations list command.

正確答案: D

問題6

Larkspur Systems is building a browser based workspace where teams coauthor very large documents in real time. Each document can reach 25 MB and the system must handle about
60,000 edits per minute from users spread across three regions and it must keep a complete version timeline for every file with strong consistency. Which managed database on Google Cloud best satisfies these requirements?

A. Cloud SQL with read replicas

B. Firestore in Datastore mode

C. Cloud Bigtable

D. Cloud Spanner

正確答案: D

說明：（僅 VCESoft 成員可見）

問題7

You are a database administrator for a rapidly growing startup running on Google Cloud. As your company expands, the Cloud SQL for PostgreSQL database workload is increasing exponentially. You need to implement a proactive strategy to continuously assess and optimize the cost of your database solution while ensuring it meets performance requirements.
What should you do?

A. Use Query Insights to identify and address performance bottlenecks, then adjust instance sizes based on recommendations.

B. Review Cloud Billing reports every month, and adjust instance sizes based on observed usage patterns.

C. Implement a combination of automated scripts to analyze usage patterns and Cloud Monitoring custom metrics to track performance. Manage scaling based on defined thresholds.

D. Set up budget alerts in Cloud Billing to notify you when spending exceeds predefined thresholds.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題8

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA).
You want to follow Google-recommended practices. What should you do? (Choose two.)

A. Create a PostgreSQL database on-premises as the HA option.

B. Configure single zone availability for automated backups.

C. Enable point-in-time recovery.

D. Set up manual backups.

E. Schedule automated backups.

正確答案: C,E

說明：（僅 VCESoft 成員可見）

問題9

Your company is rapidly expanding its user base across North America, nearly doubling in the last 6-months. This expansion causes a substantial increase in query volume on your mission- critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do-

A. Evaluate the application connection pooling configuration settings.

B. Create two Cloud SQL instances, and split the workload between them.

C. Migrate the database to Spanner.

D. Review Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage utilization metrics.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題10

You are the Cloud Database Engineer for a retail analytics startup that runs a production Cloud SQL for MySQL instance supporting a product search API. Over the last 72 hours the average query latency during busy periods rose from about 90 ms to roughly 260 ms while CPU and memory metrics remain stable. You need a single step that most directly improves query execution without changing application code. What should you do?

A. Add more read replicas to the Cloud SQL instance

B. Scale the Cloud SQL instance to a larger machine type with more vCPU and memory

C. Convert tables from InnoDB to MyISAM

D. Review the slow query log and create or refine indexes for the worst performing queries

正確答案: D

說明：（僅 VCESoft 成員可見）

問題11

You are migrating your critical production database from Amazon RDS for MySQL to Cloud SQL for MySQL by using Google Cloud's Database Migration Service. You want to keep disruption to your production database to a minimum and, at the same time, optimize migration performance.
What should you do-

A. Upgrade the Amazon RDS for MySQL primary instance to an instance with more vCPUs and memory, and then run Google Cloud's Database Migration Service.

B. Create a single Database Migration Service migration job with initial load parallelism configured to maximum on the source Amazon RDS for MySQL read replica.

C. Create a single Database Migration Service migration job with initial Load Parallelism configured to Maximum on the Amazon RDS for MySQL primary instance.

D. Create and start multiple Database Migration Service jobs to migrate your database to the target Cloud SQL for MySQL instance.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題12

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real- time monitoring and analysis. What should you do-

A. Deploy the database using Bigtable.

B. Use BigQuery, and load data in batches.

C. Deploy the database using Cloud Spanner.

D. Deploy the database using Cloud SQL.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題13

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL- compliant database. What should you do?

A. Use Cloud Spanner with multi-region configuration.

B. Use Memorystore for Redis with multi-zones within a region.

C. Use Bigtable with multi-region clusters.

D. Use Cloud SQL for PostgreSQL with cross-region replicas.

正確答案: D

最新的Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer免費考試真題

最新更新

站內鏈接

聯系我們