[2026] Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer 무료 시험 문제

문제1

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

B. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

C. Use the default configuration for the automated backups location.

D. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제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 Cloud SQL with cross-region replicas.

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

D. Use Cloud Spanner in a regional configuration.

정답: D

문제3

Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information.
The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?

A. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

B. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.

C. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

D. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

정답: A

문제4

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
- Work with transactions and offer strong consistency.
- Work with structured and semi-structured (JSON) data.
- Scale transparently to multiple regions globally as the operation
grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?

A. Use a Bigtable instance with clusters in multiple regions.

B. Use Cloud SQL for PostgreSQL with both cross-region read replicas.

C. Use Firestore in Datastore mode.

D. Use Cloud Spanner in a multi-region configuration.

정답: D

문제5

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle.
Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

A. 1 Create the database on a Bare Metal Solution server with the database running on flash storage.
2. Keep a local backup copy on all flash storage.
3. Keep backups older than one day stored in Actifio OnVault storage.

B. 1 Create the database on a Bare Metal Solution server with the database running on flash storage.
2. Keep a local backup copy on standard storage.
3. Keep backups older than one day stored in Actifio OnVault storage.

C. 1. Create the database on a Bare Metal Solution server with the database running on flash storage.
2. Keep a local backup copy on standard storage.
3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.

D. 1. Create the database on a Bare Metal Solution server with the database running on flash storage.
2. Keep a local backup copy on all flash storage.
3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제6

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

A. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b

B. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b

C. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a

D. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b

정답: D

문제7

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

A. Edit the instance to change the storage type from HDD to SSD.

B. Export the data from the existing instance, and import the data into a new instance with solid- state drives (SSDs).

C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

D. Create a read replica of the instance with SSDs, and perform a failover to the new instance

정답: B

문제8

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

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

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

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

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제9

You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?

A. Use Cloud Scheduler and Cloud Functions to run the daily export.

B. Run the cron job on a Compute Engine instance to continue the export.

C. Create a streaming Datatlow job to export the table.

D. Set up Cloud Composer, and create a task to export the table daily.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제10

You are setting up a new AlloyDB instance and want users to be able to use their existing Identity and Access Management (IAM) identities to connect to AlloyDB. You have performed the following steps:
- Manually enabled IAM authentication on the AlloyDB instance
- Granted the alloydb.databaseUserand serviceusage.serviceUsageconsumerIAM roles to the users
- Created new AlloyDB database users based on corresponding IAM identities Users are able to connect but are reporting that they are not able to SELECTfrom application tables. What should you do-

A. Grant the new database users access privileges to the appropriate tables.

B. Grant the alloydb.viewerIAM role to each user.

C. Grant the alloydb.clientIAM role to each user.

D. Grant the alloydb.alloydbreplicaIAM role to each user.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트