Google Professional Cloud Database Engineer Quiz 1 Topic 10 Questions 1-5

Question: 1

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

AUse Bigtable.

BUse Firestore.

CUse Cloud SQL for MySQL

DUse Cloud Spanner.

Show Answer

Question: 2

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

ADeploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.

BDeploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.

CDeploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.

DDeploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.

Show Answer

Question: 3

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

ASetup a static external IP address in your VPC network.

BSet up bring your own IP (BYOIP) in your VPC.

CSet up a Cloud NAT gateway on the Compute Engine VM.

DSet up Cloud NAT service.

Show Answer

Question: 4

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?

AMaintain 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

BMaintain 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

CMaintain 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

DMaintain 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

Show Answer

Question: 5

You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?

AUse Cloud Spanner to deploy the database.

BUse Bigtable with clusters in multiple regions to deploy the database

CUse BigQuery to deploy the database

DUse Cloud SQL with a regional read replica to deploy the database.

Show Answer

Google Professional Cloud Database Engineer Quiz:1 Topic:10 Questions:1-5