최신 Professional-Cloud-Database-Engineer 무료덤프 - Google Cloud Certified

문제1

You want to migrate an on-premises mission-critical PostgreSQL database to Cloud SQL. The database must be able to withstand a zonal failure with less than five minutes of downtime and still not lose any transactions. You want to follow Google-recommended practices for the migration. What should you do?

A. Create a read replica in another region, and promote the read replica if a failure occurs.

B. Build a change data capture (CDC) pipeline to read transactions from the primary instance, and replicate them to a secondary instance.

C. Enable high availability (HA) for the database to make it regional.

D. Take nightly snapshots of the primary database instance, and restore them in a secondary zone.

정답: C

문제2

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 Bigtable, and modify your application to offload queries.

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

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

정답: D

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

문제3

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 a cross-region read replica to migrate the databases to Cloud SQL.

B. Use Database Migration Service to migrate the databases to Cloud SQL.

C. Use an external read replica to migrate the databases to Cloud SQL.

D. Use a read replica to migrate the databases to Cloud SQL.

E. Use replication from an external server to migrate the databases to Cloud SQL.

정답: B,E

문제4

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command.
What should you do?

A. Use gcloud sql instances failover <ReplicaInstanceName>.

B. Use gcloud sql instances failover <PrimaryInstanceName>.

C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.

D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.

정답: B

문제5

You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)

A. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.

B. Use a change data capture (CDC) migration strategy.

C. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.

D. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.

E. Move the physical database servers from on-premises to Google Cloud.

정답: B,C

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

문제6

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

A. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance.

B. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance.

C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance.

D. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance.

정답: C

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

문제7

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 mixed storage types.

B. Recommend hard disk drives (HDD).

C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

D. Recommend solid-state drives (SSD).

정답: D

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

문제8

Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?

A. Create a Firestore index on the news story date.

B. Build a Firestore bundle, and deploy bundles to Cloud CDN.

C. Deploy a US multi-region Firestore location.

D. Enable serializable isolation in the Firebase app.

정답: B

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

문제9

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

A. Use Cloud Composer to execute a select * from table(s) query and export results.

B. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

정답: D

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

문제10

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

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

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

정답: C

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

최신 Professional-Cloud-Database-Engineer 무료덤프 - Google Cloud Certified - Professional Cloud Database Engineer

우리와 연락하기

유용한 링크

최신 업데이트