Professional Cloud Database Engineer Free Practice Questions — Page 9
Question 81
Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?
A. Migrate the Oracle databases to Cloud Spanner.
B. Migrate the Oracle databases to Compute Engine.
C. Migrate the Oracle databases to Cloud SQL.
D. Migrate the Oracle databases to Bare Metal Solution for Oracle.
Show Answer
Correct Answer: D
Explanation: To migrate Oracle RAC with minimal or no application changes, you need an environment that fully supports Oracle and RAC. Google Cloud Bare Metal Solution for Oracle provides dedicated Oracle-certified hardware, supports Oracle RAC, and allows lift-and-shift migration. Other options either require major application changes (Cloud Spanner), do not support Oracle or RAC (Cloud SQL), or are not licensed/supported for Oracle RAC in this context (Compute Engine).
Question 82
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command. What should you do?
A. Use gcloud sql instances failover <PrimaryInstanceName>.
B. Use gcloud sql instances failover <ReplicaInstanceName>.
C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
Show Answer
Correct Answer: A
Explanation: To test high availability failover in Cloud SQL for PostgreSQL, you initiate a failover on the **primary HA-enabled instance**. The `gcloud sql instances failover` command is designed for HA configurations and is run against the primary instance name, triggering a switch to the standby. The `promote-replica` command applies only to read replicas, not HA standby instances, and specifying a replica name for failover is incorrect.
Question 83
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?
A. Create a VM in Compute Engine, and run a cron job.
B. Create a Cloud Composer instance, and create a directed acyclic graph (DAG).
C. Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.
D. Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.
Show Answer
Correct Answer: C
Explanation: The goal is to automate a weekly Python-based report while minimizing cost and operational overhead. A Cloud Function is serverless and runs only when invoked, so there is no idle cost or infrastructure to manage. Cloud Scheduler provides a cron-like mechanism to trigger the function weekly. Compute Engine (A) and Cloud Composer (B) introduce unnecessary cost and management overhead, and Cloud Tasks (D) is designed for asynchronous task queues rather than time-based scheduling. Therefore, using a Cloud Function triggered by Cloud Scheduler is the most efficient solution.
Question 84
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. Develop a custom data replication service to send data into BigQuery.
B. Use Cloud SQL federated queries.
C. Use Database Migration Service to replicate tables into BigQuery.
D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
Show Answer
Correct Answer: D
Explanation: The requirement is near–real-time replication from Cloud SQL for MySQL (private IP) into BigQuery using Google‑managed services. Datastream is Google’s serverless CDC service for MySQL that captures changes with low latency, and Dataflow provides managed streaming pipelines and templates to transform and load those changes into BigQuery reliably. Federated queries do not replicate data, Database Migration Service does not target BigQuery, and building a custom service contradicts the managed‑service requirement.
Question 85
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached data. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
B. Use Memorystore for Memcached.
C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
D. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Show Answer
Correct Answer: A
Explanation: The application must work with intermittent connectivity by querying cached data, while also providing scalability, strong consistency, and multi-region replication. Cloud Firestore natively supports multi-region replication and strong consistency, and when offline persistence is enabled, it automatically caches data locally and serves reads during connectivity failures, synchronizing when connectivity is restored. The other options do not provide built-in offline access with strong consistency and global replication.
Question 86
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
A. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
D. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Show Answer
Correct Answer: A
Explanation: Cloud SQL supports configuring a weekly maintenance window (fixed to a single one-hour window) and defining maintenance deny periods of up to 90 days during which no maintenance is scheduled. Setting the regular Sunday 12–1 AM window handles routine maintenance, and defining a deny period from November 1 to January 15 prevents maintenance during the holiday season while staying within the 90-day limit. Other options are invalid because Cloud SQL cannot start maintenance via Scheduler/Composer or define longer windows or deny periods beyond limits.
Question 87
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
A. Use a change data capture (CDC) migration strategy.
B. Move the physical database servers from on-premises to Google Cloud.
C. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
Show Answer
Correct Answer: A, E
Explanation: A 100 TB database cannot be transferred within 48 hours over a 1 Gbps or 2 Gbps link using an offline migration. At 10 Gbps, 100 TB can be transferred within the allowed downtime window. Using a change data capture (CDC) strategy allows you to perform an initial bulk transfer and then synchronize ongoing changes, minimizing downtime and ensuring data consistency.
Question 88
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
A. Automate instance creation by writing a Dataflow job.
B. Automate instance creation by setting up Terraform scripts.
C. Create the instances using the Google Cloud Console UI.
D. Create clones from a template Cloud SQL instance.
Show Answer
Correct Answer: B
Explanation: Provisioning hundreds of Cloud SQL instances with consistent naming, flags, and tags requires repeatable, declarative automation. Terraform provides infrastructure-as-code with templates, variables, and policy enforcement, making it ideal for large-scale, standardized deployments. Dataflow is for data processing, the Console UI is manual and error-prone at scale, and cloning instances does not reliably enforce full standards across many projects.
Question 89
Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?
A. 1 Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on all flash storage. 3. Keep backups older than one day stored in Actifio OnVault storage.
B. 1 Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on standard storage. 3. Keep backups older than one day stored in Actifio OnVault storage.
C. 1. Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on standard storage. 3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
D. 1. Create the database on a Bare Metal Solution server with the database running on flash storage. 2. Keep a local backup copy on all flash storage. 3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
Show Answer
Correct Answer: B
Explanation: The requirements call for fast restores (RTO 2 hours), frequent backups (RPO 15 minutes), 5‑year retention, and cost efficiency. Running the database on flash storage meets performance needs. Keeping recent local backups on standard storage provides sufficiently fast restore at much lower cost than all‑flash. Using Actifio OnVault for older backups is designed for long‑term retention and efficient incremental‑forever backups, reducing storage and transfer costs while still supporting enterprise recovery workflows. Options using all‑flash backups are unnecessarily expensive, and options relying on RMAN to object/archival storage risk slower restores and do not best meet the RTO for a 50 TB database.
Question 90
Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?
A. Use Identity and Access Management (IAM) for Bigtable access control.
B. Use VPC Service Controls to create a trusted network for the Bigtable service.
C. Use customer-managed encryption keys (CMEK).
D. Use Google Cloud Armor to add IP addresses to an allowlist.
Show Answer
Correct Answer: B
Explanation: The requirement is to prevent access from the public internet even if valid credentials are leaked. IAM only controls who can access, not from where. CMEK controls encryption, not network access. Cloud Armor protects HTTP(S) endpoints and is not applicable to Bigtable’s control/data plane. VPC Service Controls create a security perimeter around Bigtable so requests originating outside trusted VPC networks are denied, mitigating data exfiltration even with valid service account keys.
$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.