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

Y 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: 4

For this question, refer to the TerramEarth case study.

TerramEarth's CTO wants to use the raw data from connected vehicles to help identify approximately when a vehicle in the development team to focus their failure. You want to allow analysts to centrally query the vehicle data. Which architecture should you recommend?

AOption

BOption

COption

DOption

Show Answer

Question: 5

For this question, refer to the Mountkirk Games case study. Which managed storage option meets Mountkirkâ€™s technical requirement for storing game activity in a time series database service?

ACloud Bigtable

BCloud Spanner

CBigQuery

DCloud Datastore

Show Answer

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