Question 161
Your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL. As a part of the migration, you need to convert schema and other database code objects, such as procedures, functions, and triggers, from Oracle to PostgreSQL. The database migration needs to be accomplished with minimal application code changes and manual intervention. What is the Google-recommended approach you should do?
A. Manually rewrite both the Oracle schema and queries to be compatible with PostgreSQL syntax and semantics.
B. Use a schema conversion tool to automatically convert the Oracle schema to PostgreSQL schema, then manually rewrite all queries.
C. Migrate the data directly from Oracle to PostgreSQL without any conversion. Rely on application-level compatibility layers to handle any syntax or semantic differences.
D. Use Database Migration Service code conversion workspace, then review and refactor as needed.
Question 162
You are using Memorystore for Redis to cache frequently accessed data and improve your application’s performance. In the event of a complete regional outage, the application will failover to another region. You want to ensure that the Memorystore instance in the new region does not start from an empty cache after failover. What should you do?
A. Use Memorystore Standard Tier. Disable read replicas.
B. Use Memorystore Standard Tier. Configure at least one read replica.
C. Schedule exports of the Memorystore instance. Specify a dual-region Cloud Storage bucket as the export destination.
D. Enable Redis RDB snapshots for Memorystore.
Question 163
Your organization runs a high-volume, low-latency application on Bigtable. You need to reduce costs without compromising performance. What should you do?
A. Reduce replication factor across clusters.
B. Consolidate multiple small clusters into a single large cluster.
C. Analyze application access patterns to strategically redesign the schema and adjust the node count.
D. Switch to a lower-performance storage type for all clusters.
Question 164
Your company is using a multi-region Spanner instance. The instance stores data from an application which does a lot of writes without reading the data. You are noticing a lot of latency regression. You want to reduce latency and improve performance. What should you do?
A. Enable leader-aware routing in the client library.
B. Add additional indexes to the table.
C. Disable leader-aware routing in the client library.
D. Increase the number of Spanner nodes.
Question 165
You are designing a new ecommerce application on Google Cloud. You expect high and bursty write volumes during peak sales periods. You need to configure Spanner to ensure consistent database performance during this sales period. What should you do?
A. Implement sharding to distribute the write load across multiple Spanner instances.
B. Configure read-only transactions to improve read performance during peak periods.
C. Use interleaved tables to reduce the number of cross-node transactions.
D. Enable autoscaling in the Spanner instance, and set the maximum number of nodes to match the peak write volume.
Question 166
Your application uses a Cloud SQL for MySQL instance. Recently, you have noticed performance degradation during peak hours, leading to slow response times and frustrated users. You suspect that inefficient queries might be contributing to these issues. You want to pinpoint and analyze these problematic queries and pass them to the application team for optimizations. What should you do?
A. Use the underprovisioned instance recommender.
B. Increase the Cloud SQL instance read_buffer_size flag.
C. Enable and use Query Insights.
D. Create a Cloud Monitoring alert based on the database/mysql/queries metric.
Question 167
You are migrating your on-premises PostgreSQL database to Spanner. You need to identify a solution for handling existing integer-based table primary keys. You want minimal changes to the applications while also following Google-recommended practices. What should you do?
A. Use application generated sequential integer values as primary keys.
B. Update default primary key values to max(primary_key) + 1.
C. Use a UUID function that generates UUID Version 4 values as primary keys.
D. Generate values by using BIT_REVERSED_POSITIVE sequences.
Question 168
You have a Cloud SQL for MySQL instance with a table of product information including a column of product descriptions. Your application development team is building a customer facing chatbot and would like to find the product that most closely matches a freeform text description provided by the customer. How should you enable this functionality?
A. Create a stored procedure that uses a regular expression to match the customer’s search text to values in the product description column.
B. Create and populate a column of product description embeddings on the product table and perform an approximate nearest neighbor search using the customer’s search text.
C. Use the LIKE operator to match the customer’s search text to the product description and return similar rows.
D. Create a SQL script that compares the product description and the customer’s search text by using the SOUNDEX function.
Question 169
You have a Cloud SQL for MySQL Enterprise instance with four read replicas. Your next scheduled maintenance event is scheduled tomorrow at 6 PM. Your security team identifies an important security vulnerability. You are notified by your management at 8 PM today to update your primary instance and all four read replicas during approved business downtime today at 11 PM. What should you do?
A. Reschedule the upcoming scheduled maintenance to happen today at 11 PM.
B. Perform self-service maintenance on the selected read replicas.
C. Perform self-service maintenance on the primary instance during scheduled business downtime.
D. Reschedule the upcoming scheduled maintenance of the primary instance to apply updates immediately.
Question 170
Your company has implemented a multi-regional, highly available (HA) PostgreSQL database cluster on Google Cloud by using Cloud SQL and regional persistent disks. You need to assess the effectiveness of your disaster recovery plan and validate the system's ability to recover from a regional outage. What should you do?
A. Promote the cross-region replica and verify that the application can still access the database.
B. Initiate a failover test to the HA standby instance and verify that the application can still access the database.
C. Create a backup of the database and restore it to a new Cloud SQL instance in a different region to test the backup and restore process.
D. Conduct a chaos engineering experiment by randomly terminating virtual machines in the primary region and observing the system's behavior.
