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

問題1

Your company is launching a new globally distributed application with strict requirements for low latency, strong consistency, zero downtime, and high availability (HA). You need to configure a scalable database solution to support anticipated rapid growth and optimal application performance. What should you do?

A. Create a spanner instance across regions for optimal performance.

B. Create a Cloud SQL instance in HA mode with a cross-region read replica.

C. Implement Bigtable with replication across multiple regions and configure to prioritize data accuracy.

D. Create an AlloyDB instance in HA mode with a cross-region read replica.

正確答案: A

問題2

Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

A. Use Google Workspace Password Sync to replicate passwords into Google Cloud.

B. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

C. Use workload identity federation to impersonate a service account.

D. Ask existing users to set their Google password to match their corporate password.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題3

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 number of CPUs for the instance to ensure that it can handle the additional import operation.

C. Increase the amount of memory allocated to your instance.

D. Ensure that the service account has the Storage Admin role.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題4

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

A. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

B. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

C. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

D. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題5

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

A. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.

B. Use Cloud SQL with read replicas for throughput.

C. Use Bigtable, and add nodes as necessary to achieve the required throughput.

D. Use Firestore, and rely on automatic serverless scaling.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題6

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

問題7

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7.
You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

A. Use the mysqldump utility on the primary database instance to export the backup.

B. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

C. Use Cloud SQL serverless exports.

D. Create a read replica, and then use the mysqldump utility to export each table.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題8

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure.
You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

A. Create the database persistent disk with customer-managed encryption keys.

B. Create the database persistent disk with Google-managed encryption keys.

C. Create the database with customer-managed encryption keys.

D. Create the database with Google-managed encryption keys.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題9

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

A. Migrate to Cloud SQL for SQL Server.

B. Migrate to Cloud SQL for PostgreSQL.

C. Migrate to Google Kubernetes Engine (GKE).

D. Migrate to Compute Engine.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題10

You are deploying a Cloud SOL for MySQL database to serve a non-critical application. The database size is
10 GB and will be updated every night with data stored in a Cloud Storage bucket. The database serves read- only traffic from the application during the day. The data locally requirement of This application mandates that data must reside in a single region. You want to minimize the cost of running this database while maintaining an RTO of 1 day. What should you do?

A. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Configure automated backups of the Cloud SQL instance and use a custom backup location to store backups in a Cloud Storage bucket in the same region.

B. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in the same zone.

C. Create a Cloud SQL for MySQL instance with high availability (HA) disabled. Create a read replica in a second region.

D. Create a Cloud SQL for MySQL instance with high availability (HA) enabled. Configure automated backups of the Cloud SQL instance and use the default backup location.

正確答案: A

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

最新更新

站內鏈接

聯系我們