GCP_PDE_Cloud_Spanner

Your department is experimenting with using Cloud Spanner for a globally accessible database. You are starting with a pilot project using a regional instance. You would like to follow Google’s recommendations for the maximum sustained CPU utilization of a regional instance. What is the maximum CPU utilization that you would target?

• 50%

• 65%

• 45%

• 70%

You are planning to migrate a MySQL database to the managed Cloud SQL database for Google Cloud. You have Compute Engine virtual machine instances that will connect with this Cloud SQL instance. You do not want to whitelist IPs for the Compute Engine instances to be able to access Cloud SQL. What should you do?

• Enable private IP for the Cloud SQL instance.

• Whitelist a project to access Cloud SQL, and add Compute Engine instances in the whitelisted project.

• Create a role in Cloud SQL that allows access to the database from external instances, and assign the Compute Engine instances to that role.

• Create a CloudSQL instance on one project. Create Compute engine instances in a different project. Create a VPN between these two projects to allow internal access to CloudSQL.

A Cloud Spanner database is being deployed in us-west1 and will have to store up to 20 TB of data. What is the minimum number of nodes required?

• 10

• 20

• 5

• 2

A multinational corporation is building a global inventory database. The database will support OLTP type transactions at a global scale. Which of the following would you consider as possible databases for the system?

• Cloud SQL only

• Cloud Spanner only

• Cloud SQL and Cloud Spanner

• Cloud Storage

An airline is moving its luggage-tracking applications to Google Cloud. There are many

requirements, including support for SQL and strong consistency. The database will

be accessed by users in the United States, Europe, and Asia. The database will store

approximately 50 TB in the first year and grow at approximately 10 percent a year after

that. What managed database service would you recommend?

• Cloud SQL

• Bigquery

• Bigtable

• Cloud Spanner