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

문제1

You have a non-critical business application running on Google Kubernetes Engine (GKE) in the app-dev VPC. You have created an AllayDB cluster with private Service Access (PSA) and no public IP address in the db-dev VPC. You want your application to securely connect to AllowDB in a cost-effective way. What should you do?

A. Connect by using AlloyDB Auth Proxy installed in the GKE cluster.

B. Set up a high availability VPN between the app-dev and db-dev VPCs. Connect the application directly to AlloyDB.

C. Install a SOCKS proxy in a VM in the db-dev VPC. Install AlloyDB Auth Proxy in your GKE cluster, and connect to the AlloyDB cluster through the SOCKS server and port.

D. Connect by using the private IP address of the AlloyDB cluster directly from the application.

정답: D

문제2

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure.
You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

A. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.

B. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.

C. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.

D. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.

정답: C

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

문제3

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

A. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage.
Upload the changes into BigQuery, and merge them with existing tables.

B. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

C. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

D. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

정답: D

문제4

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 회원만 볼 수 있음)

문제5

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA. You want to follow Google- recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

A. Use interleaving to co-locate parent and child rows.

B. Use granular instance sizing in Cloud Spanner and Autoscaler.

C. Manually scale down the number of nodes after the peak period has passed.

D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

정답: B

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

문제6

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 회원만 볼 수 있음)

문제7

You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us- central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google- recommended practices to minimize performance impact on the currently running instance. What should you do?

A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

C. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

D. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

정답: D

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

문제8

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A. Migrate the databases to Bare Metal Solution for Oracle.

B. Migrate the databases to Cloud Spanner.

C. Migrate the databases to Cloud SQL, and enable a standby database.

D. Migrate the databases to Compute Engine using regional persistent disks.

정답: C

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

문제9

Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow.You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

A. Create secondary indexes on the replica.

B. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re- enable replication and optimize performance by setting flags on the primary instance.

C. Create additional read replicas, and partition your analytics users to use different read replicas.

D. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

E. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

정답: B,C

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

문제10

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

B. Set up all read replicas in the same region as the primary instance with synchronous replication.

C. Set up all read replicas in a different region using asynchronous replication.

D. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

정답: A

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

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

우리와 연락하기

유용한 링크

최신 업데이트