Question 111
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 Bigtable
C. Use BigQuery.
D. Use Cloud Spanner.
Question 112
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
A. Use Cloud Spanner to deploy the database.
B. Use Bigtable with clusters in multiple regions to deploy the database
C. Use BigQuery to deploy the database
D. Use Cloud SQL with a regional read replica to deploy the database.
Question 113
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
A. Use Cloud SQL with cross-region replicas.
B. Use high availability (HA) Cloud SQL with multiple zones.
C. Use zonal Cloud SQL without high availability (HA).
D. Use Cloud Spanner in a regional configuration.
Question 114
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
A. Migrate to Compute Engine.
B. Migrate to Bare Metal Solution for Oracle.
C. Migrate to Google Kubernetes Engine (GKE)
D. Migrate to Google Cloud VMware Engine
Question 115
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
A. Migrate the existing database to Firestore.
B. Migrate the existing database to Cloud SQL for PostgreSQL.
C. Migrate the existing database to Cloud Spanner.
D. Migrate the existing database to PostgreSQL running on Compute Engine.
Question 116
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
A. Use workload identity federation to impersonate a service account.
B. Ask existing users to set their Google password to match their corporate password.
C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
D. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
Question 117
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
A. Disable and remove the internal IP address assignment.
B. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
C. Specify an authorized network with the CIDR range of the VM.
D. Disable and remove the external IP address assignment.
Question 118
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest data. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
A. Create a read replica for the Sales Reporting application.
B. Create two separate databases in the instance, and perform dual writes from the Order Management application.
C. Use a Cloud SQL federated query for the Sales Reporting application.
D. Queue up all the requested reports in PubSub, and execute the reports at night.
Question 119
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process data. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
A. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
B. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
D. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
Question 120
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
A. Use the native export and import functionality of the source database.
B. Create a database on Google Cloud, and use database links to perform the migration.
C. Create a database on Google Cloud, and use Dataflow for database migration.
D. Use Database Migration Service.
