Professional-Cloud-Database-Engineer by Google Valid Free Exam Practice Test

Question 1

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

A. Use external server replication. B. Use the mysqldump utility and binary logs. C. Use Data Migration Service. D. Use Cloud SQL for MySQL external replica.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

Your company's rapidly growing ecommerce application uses Cloud SQL for MySQL.
Performance issues are surfacing during peak traffic periods. You need to ensure that the database can handle the load while minimizing downtime. What should you do-

A. Vertically scale the primary instance by significantly increasing compute resources, such as vCPUs and memory. B. Increase storage size on the existing instance and implement client-side caching for frequently accessed data. C. Migrate to a Cloud SQL for PostgreSQL database for better performance during high load. D. Use read replicas for query offloading, configure automatic failover, and test failover procedures regularly.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?

A. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region. B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions. C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides. D. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

Correct Answer: D

Question 4

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

A. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance. B. Export the data from the existing instance, and import the data into a new instance with solid- state drives (SSDs). C. Create a read replica of the instance with SSDs, and perform a failover to the new instance D. Edit the instance to change the storage type from HDD to SSD.

Correct Answer: B

Question 5

Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

A. Migrate all the databases to Cloud SQL. B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine. C. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle. D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

Correct Answer: C

Question 6

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 Firestore. B. Use Cloud SQL for MySQL C. Use Bigtable. D. Use Cloud Spanner.

Correct Answer: D

Question 7

Your retail company is currently using DynamoDB to store product catalog data. Due to increasing data volumes and the need for better scalability, cost efficiency, and AI features; you have decided to migrate your data to Bigtable. You want a cost-effective migration, with minimal downtime and minimal effort, while ensuring data consistency between the two databases. What should you do-

A. Create a Dataflow pipeline using the DynamoDBIO and BigtableIO connectors to stream data from DynamoDB to Bigtable in near real time. B. Export the DynamoDB data to CSV files, upload them to Cloud Storage, and use the cbtCLI to import the data into Bigtable. C. Use Dataproc to export the data from DynamoDB and load it into Bigtable. D. Develop a custom script using the DynamoDB and Bigtable APIs to directly transfer data between the two databases.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

A. Use Cloud Spanner in a multi-region configuration. B. Use Cloud SQL with cross-region replicas. C. Use Cloud Spanner in a regional configuration. D. Use highly available Cloud SQL with multiple zones.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

A. Use Cloud SQL federated queries. B. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery. C. Develop a custom data replication service to send data into BigQuery. D. Use Database Migration Service to replicate tables into BigQuery.

Correct Answer: B

Question 10

Your organization's databases are running in Cloud SQL. Due to data residency regulations, your organization mandates that backups are stored in a specific region. You are also required to make sure that the databases have monthly full backups, which are retained until your Cloud SQL instance is deleted, along with daily backups. What should you do-

A. Schedule daily and monthly on-demand backups. B. Schedule automated backups for Cloud SQL with a retention period of 365-days. C. Schedule automated backups, and create on-demand monthly backups to custom backup locations. D. Create an Organization Policy Service resource location constraint. Schedule automated backups with the retention period of 30-days.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer Exam Practice Test