Question 1

You are configuring a new application that has access to an existing Cloud Spanner database. The new

application reads from this database to gather statistics for a dashboard. You want to follow

Google-recommended practices when granting Identity and Access Management (IAM) permissions. What

should you do?

Options :

A :

Reuse the existing service account that populates this database.

B :

Create a new service account, and grant it the Cloud Spanner Database Admin role.

C :

Create a new service account, and grant it the Cloud Spanner Database Reader role.

D :

Create a new service account, and grant it the spanner.databases.select permission.

Answer: C

Question 2

Your company is developing a global ecommerce website on Google Cloud. Your development team is

working on a shopping cart service that is durable and elastically scalable with live traffic. Business

disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the

application needs to have very low latency writes. You need a data storage solution that has high write

throughput and provides 99.99% uptime. What should you do?

Options :

A : Use Cloud SQL for data storage.

B : Use Cloud Spanner for data storage.

C : Use Memorystore for data storage.

D : Use Bigtable for data storage.

Answer: B

Question 3

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

Options :

A : Create a read replica for the Sales Reporting application.

B :

Create two separate databases in the instance, and perform dual writes from the Order Management application.

C : Use a Cloud SQL federated query for the Sales Reporting application.

D : Queue up all the requested reports in PubSub, and execute the reports at night.

Answer: A

Question 4

You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

Options :

A : Bring DB-1 back online.

B : Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C : Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D : Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer: D

Question 5

You are responsible for designing a new database for an airline ticketing application in Google Cloud. This

application must be able to:

Work with transactions and offer strong consistency.

Work with structured and semi-structured (JSON) data.

Scale transparently to multiple regions globally as the operation grows.

You need a Google Cloud database that meets all the requirements of the application. What should you do?

Options :

A : Use Cloud SQL for PostgreSQL with both cross-region read replicas.

B : Use Cloud Spanner in a multi-region configuration.

C : Use Firestore in Datastore mode.

D : Use a Bigtable instance with clusters in multiple regions.

Answer: B

Higher Test Marks with Free Online Professional-Cloud-Database-Engineer Exam Practice

Buying Options: