Online Access Free Professional-Cloud-Database-Engineer Practice Test

Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?

• A.Create the database with customer-managed encryption keys.
• B.Create the database with Google-managed encryption keys.
• C.Create the database persistent disk with customer-managed encryption keys.
• D.Create the database persistent disk with Google-managed encryption keys.

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?

• A.Use Bigtable.
• B.Use Firestore.
• C.Use Cloud Spanner.
• D.Use Cloud SQL for MySQL

Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

• A.Cloud SQL
• B.Cloud Spanner
• C.Bigtable
• D.BigQuery

Which Google Cloud pairing offers a fully managed MongoDB service with live migration that supports continuous schema changes, data validation, rapid rollback, and cutover in under 20 minutes?

• A.Cloud Dataflow with MongoDB connector and Firestore in Native mode
• B.MongoDB Atlas Live Migration and MongoDB Atlas on Google Cloud
• C.Database Migration Service and AlloyDB for PostgreSQL

Your team is building an application that stores and analyzes streaming time series financial data.
You need a database solution that can perform time series-based scans with sub-second latency.
The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?

• A.Use Firestore.
• B.Use Cloud Spanner.
• C.Use Bigtable
• D.Use BigQuery.