Professional Cloud Database Engineer Free Practice Questions — Page 8
Question 71
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
A. Use linear scaling to implement the Autoscaler-based architecture
B. Use direct scaling to implement the Autoscaler-based architecture.
C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Show Answer
Correct Answer: A
Explanation: The requirement is for a fully managed, automated way to increase Cloud Spanner capacity as traffic grows steadily with occasional spikes. Autoscaler is therefore required, eliminating manual upgrades. Among autoscaling methods, linear scaling is designed for workloads with gradual growth and a few large peaks, calculating the required capacity to keep utilization under the target threshold. This best matches the described traffic pattern.
Question 72
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
A. Isolate the data analysts and operations user groups to use different Bigtable instances.
B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
C. Use Key Visualizer for Bigtable.
D. Add more nodes to the Bigtable cluster.
Show Answer
Correct Answer: C
Explanation: The issue affects only a new cohort using a newly loaded third‑party dataset and occurs at a specific time window, which strongly suggests a Bigtable hot‑spot or poor row‑key design rather than overall capacity or application latency. The correct first step in Bigtable performance troubleshooting is to use Key Visualizer, which shows read/write access patterns across tablets and nodes and helps identify hot tablets and uneven load. Adding nodes or isolating users would not address a hot‑spot, and basic storage metrics like table/bytes_used do not diagnose performance contention.
Question 73
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
A. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
B. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
D. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
Show Answer
Correct Answer: B
Explanation: To avoid impacting the busy transactional workload, the analytics team should query a read replica rather than the primary instance. Using a read replica offloads read-heavy analytics queries. Enabling IAM database authentication on the replica avoids sharing database passwords and allows centralized, secure access management via IAM while still granting read-only database privileges at the MySQL level. Option C and D impact the primary instance, and A is functional but less secure due to password distribution.
Question 74
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
A. Use Firestore.
B. Use Cloud Spanner.
C. Use Cloud SQL.
D. Use Bigtable.
Show Answer
Correct Answer: B
Explanation: The application requires global scale, strong ACID transactions, and 99.999% availability. Cloud Spanner is a globally distributed, horizontally scalable relational database that provides strong consistency, full ACID transactions across regions, and up to 99.999% availability in multi‑region configurations. Firestore lacks full relational transactional semantics for complex workloads, Cloud SQL cannot meet global scale or five‑nines availability, and Bigtable is not ACID‑compliant.
Question 75
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
A. Identify whether the database has over 512 tables.
B. Identify all tables that do not have a primary key.
C. Identity all tables that do not have at least one foreign key.
D. Identify whether the source database is encrypted using pgcrypto extension.
E. Identify whether the source database uses customer-managed encryption keys (CMEK).
Show Answer
Correct Answer: B, E
Explanation: Database Migration Service for PostgreSQL has known limitations you must assess before migrating. Tables without a primary key have restricted support: only the initial snapshot and INSERTs are migrated automatically, while UPDATE and DELETE operations require manual handling, so identifying such tables is essential (B). Additionally, if the source database is encrypted with customer-managed encryption keys (CMEK) and DMS does not have access to those keys, the database cannot be migrated at all, making this a critical limitation to assess (E). Encryption via the pgcrypto extension is supported by Cloud SQL and therefore does not block migration.
Question 76
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
A. Enable serializable isolation in the Firebase app.
B. Deploy a US multi-region Firestore location.
C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
D. Create a Firestore index on the news story date.
Show Answer
Correct Answer: C
Explanation: The app serves the same small set of read‑only content (top ten news stories) to a large global audience. Firestore bundles allow you to prepackage this data and serve it via Cloud CDN, dramatically reducing Firestore read costs and lowering latency by delivering content from edge locations. Serializable isolation, additional indexes, or simply choosing a multi‑region database do not address global content distribution as effectively or cost‑efficiently as CDN‑backed bundles.
Question 77
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
A. Export the data from the existing database, and load the data into a new Cloud SQL database.
B. Use Migrate for Compute Engine to complete the migration.
C. Use Datastream to complete the migration.
D. Use Database Migration Service to complete the migration.
Show Answer
Correct Answer: D
Explanation: Database Migration Service is designed to migrate PostgreSQL databases into Cloud SQL with minimal downtime by using continuous replication (change data capture) and a controlled cutover. Export/import causes significant downtime for a 1 TB database, Migrate for Compute Engine works at the VM level rather than the database level, and Datastream is primarily for streaming data into analytics targets, not full Cloud SQL migrations.
Question 78
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
A. Set the automated backups to occur every other day to lower the frequency of backups.
B. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
C. Select a different region to store your backups.
D. Reduce the number of automated backups that are retained to two (2).
Show Answer
Correct Answer: D
Explanation: In Cloud SQL, automated backups have a fixed daily frequency and fixed storage type, and changing regions does not reduce backup storage cost. However, you can configure how many automated backups are retained (default is seven). Since the instance is not mission-critical, reducing the retention count directly lowers backup storage usage and cost. Therefore, reducing retained backups to two is the correct cost-optimization choice.
Question 79
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
A. Shut down and restart each application.
B. Write a utility to scan database query logs.
C. Write a utility to scan application logs.
D. Use query tags to add application-centric database monitoring.
Show Answer
Correct Answer: D
Explanation: Google recommends using Query Insights with query tags (for example via sqlcommenter) to attribute SQL queries to the originating application. Query tags allow application-centric monitoring so you can directly identify which application is generating inefficient queries, without restarting apps or building custom log-scanning utilities.
Question 80
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 Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Show Answer
Correct Answer: D
Explanation: Cloud SQL is a fully managed service that supports MySQL, PostgreSQL, and Microsoft SQL Server, making it the best fit for those databases. Cloud SQL does not support Oracle, so Oracle databases should be migrated to Bare Metal Solution for Oracle, which is the recommended Google Cloud option for running Oracle workloads. Other options either place supported engines on less managed Compute Engine or attempt to use Cloud SQL for Oracle, which is not supported.
$19
Get all 167 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.