Google Professional Cloud Architect Quiz 5 Topic 7 Questions 21-25

Question: 1

The database administration team has asked you to help them improve the performance of their new database server running on Google Compute Engine. The database is for importing and normalizing their performance statistics and is built with MySQL running on Debian Linux. They have an n1-standard-8 virtual machine with 80 GB of SSD persistent disk. What should they change to get better performance from this system?

AIncrease the virtual machine's memory to 64 GB.

BCreate a new virtual machine running PostgreSQL.

CDynamically resize the SSD persistent disk to 500 GB.

DMigrate their performance metrics warehouse to BigQuery.

EModify all of their batch jobs to use bulk inserts into the database.

Show Answer

Question: 2

As part of implementing their disaster recovery plan, your company is trying to replicate their production

MySQL database from their private data center to their GCP project using a Google Cloud VPN connection.

They are experiencing latency issues and a small amount of packet loss that is disrupting the replication. What should they do?

AConfigure their replication to use UDP.

BConfigure a Google Cloud Dedicated Interconnect.

CRestore their database daily using Google Cloud SQL.

DAdd additional VPN connections and load balance them.

ESend the replicated transaction to Google Cloud Pub/Sub.

Show Answer

Question: 3

You need to upload files from your on-premises environment to Cloud Storage. You want the files to be

encrypted on Cloud Storage using customer-supplied encryption keys. What should you do?

ASupply the encryption key in a .boto configuration file. Use gsutil to upload the files.

BSupply the encryption key using gcloud config. Use gsutil to upload the files to that bucket.

CUse gsutil to upload the files, and use the flag --encryption-key to supply the encryption key.

DUse gsutil to create a bucket, and use the flag --encryption-key to supply the encryption key. Use gsutil to upload the files to that bucket.

Show Answer

Question: 4

You are using Cloud SQL as the database backend for a large CRM deployment. You want to scale as usage increases and ensure that you donâ€™t run out of storage, maintain 75% CPU usage cores, and keep replication

lag below 60 seconds. What are the correct steps to meet your requirements?

A1. Enable automatic storage increase for the instance.
2. Create a Stackdriver alert when CPU usage exceeds 75%, and change the instance type to reduce
CPU usage.
3. Create a Stackdriver alert for replication lag, and shard the database to reduce replication time.

B1. Enable automatic storage increase for the instance.
2. Change the instance type to a 32-core machine type to keep CPU usage below 75%.
3. Create a Stackdriver alert for replication lag, and shard the database to reduce replication time.

C1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on the
instance to create more space.
2. Deploy memcached to reduce CPU load.
3. Change the instance type to a 32-core machine type to reduce replication lag.

D1. Create a Stackdriver alert when storage exceeds 75%, and increase the available storage on the
instance to create more space.
2. Deploy memcached to reduce CPU load.
3. Create a Stackdriver alert for replication lag, and change the instance type to a 32-core machine type to reduce replication lag.

Show Answer

Question: 5

You are analyzing and defining business processes to support your startupâ€™s trial usage of GCP, and you donâ€™t yet know what consumer demand for your product will be. Your manager requires you to minimize GCP

service costs and adhere to Google best practices. What should you do?

AUtilize free tier and sustained use discounts. Provision a staff position for service cost management.

BUtilize free tier and sustained use discounts. Provide training to the team about service cost management.

CUtilize free tier and committed use discounts. Provision a staff position for service cost management.

DUtilize free tier and committed use discounts. Provide training to the team about service cost management.

Show Answer

Google Professional Cloud Architect Quiz:5 Topic:7 Questions:21-25