PCDBE practice questions 111–120

1. Question 111 · 170 in bank

   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?

   • AMigrate the Oracle databases to Cloud Spanner.
   • BMigrate the Oracle databases to Compute Engine.
   • CMigrate the Oracle databases to Cloud SQL.
   • DMigrate the Oracle databases to Bare Metal Solution for Oracle.

   Show answer

   Answer: D

   Explanation

   D. In theory you could migrate Oracle to Spanner for PostgreSQL, but that would entail application changes which the questions says can’t happen. Eliminate A. Oracle is not licensed or supported in GCE. Eliminate B. Cloud SQL doesn’t support Oracle. Eliminate C. That leaves D on which you can configure and run RAC.

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation

   Next question

2. Question 112 · 170 in bank

   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?

   • AMigrate all the databases to Cloud SQL.
   • BMigrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
   • CMigrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
   • DMigrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

   Show answer

   Answer: D

   Explanation

   D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

   Source: Adapted from community discussion — badrisrinivas9

   Next question

3. Question 113 · 170 in bank

   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?

   • AUse gcloud sql instances failover <PrimaryInstanceName>.
   • BUse gcloud sql instances failover <ReplicaInstanceName>.
   • CUse gcloud sql instances promote-replica <PrimaryInstanceName>.
   • DUse gcloud sql instances promote-replica <ReplicaInstanceName>.

   Show answer

   Answer: A

   Explanation

   A. We are not promoting a read replica to be the primary instance. Eliminate C and D. When HA is enabled you only deal with the primary instance name, so B doesn’t make sense. That leaves A.

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation

   Next question

4. Question 114 · 170 in bank

   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?

   • ACreate a VM in Compute Engine, and run a cron job.
   • BCreate a Cloud Composer instance, and create a directed acyclic graph (DAG).
   • CCreate a Cloud Function, and call the Cloud Function using Cloud Scheduler.
   • DCreate a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

   Show answer

   Answer: C

   Explanation

   Minimal Cost Approach: 1. Put the python script on the Cloud Function 2. Schedule weekly trigger using Cloud Scheduler Compute Engine and Cloud Composer would increase the cost and making it complex

   Source: Adapted from community discussion — isribalaji

   References

   • Google Cloud documentation

   Next question

5. Question 115 · 170 in bank

   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?

   • ADevelop a custom data replication service to send data into BigQuery.
   • BUse Cloud SQL federated queries.
   • CUse Database Migration Service to replicate tables into BigQuery.
   • DUse Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

   Show answer

   Answer: D

   Explanation

   D. Anytime you see words like “develop” or “manually” be suspicious given this is cloud and everything is supposed to be automated and point-and-click easy. Eliminate A. Federated queries are SQL queries initiated FROM BigQuery to Cloud Spanner or Cloud SQL databases. So B doesn’t make sense. The Database Migration Service does not support BigQuery as a destination database engine. Eliminate C. That leaves D. From Google’s documentation, “Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures.”

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation
   • Google Cloud documentation
   • Google Cloud documentation

   Next question

6. Question 116 · 170 in bank

   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?

   • AUse Firestore and ensure that the PersistenceEnabled option is set to true.
   • BUse Memorystore for Memcached.
   • CUse Pub/Sub to synchronize the changes from the application to Cloud Spanner.
   • DUse Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

   Show answer

   Answer: A

   Explanation

   A: Use Firestore and ensure that the PersistenceEnabled ***** option is set to true. Cloud Firestore is a NoSQL document database that lets you easily store, sync, and query data for your mobile and web apps - at global scale. To use offline persistence, you don't need to make any changes to the code that you use to access Cloud Firestore data. With offline persistence enabled, the Cloud Firestore client library automatically manages online and offline data access and synchronizes local data when the device is back online.

   Source: Adapted from community discussion — pk349

   References

   • Google Cloud documentation

   Next question

7. Question 117 · 170 in bank

   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?

   • ADefine a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
   • BDefine a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
   • CBuild 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.
   • DCreate 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

   Answer: A

   Explanation

   A. This is a maintenance deny question, so eliminate C and D. Maintenance deny periods can be set that last up to 90 days. That eliminates B since the period mentioned would be 107 days. B is also eliminated because the maintenance windows are an hour. You can't set a maintenance window in Cloud SQL to be 5 hours. A is the answer.

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation

   Next question

8. Question 118 · 170 in bank

   Select 2

   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.)

   • AUse a change data capture (CDC) migration strategy.
   • BMove the physical database servers from on-premises to Google Cloud.
   • CKeep the network bandwidth at 1 Gbps, and then perform an offline data migration.
   • DIncrease the network bandwidth to 2 Gbps, and then perform an offline data migration.
   • EIncrease the network bandwidth to 10 Gbps, and then perform an offline data migration.

   Show answer

   Answer: AC

   Explanation

   A, E. According to Google’s data transfer chart, 100 TB across a 1 Gbps link would take 12 days. I don’t think you can physically move your own equipment into a Google DC. Eliminate B. Increasing the bandwidth to 2 Gbps and doing an offline migration anyway wouldn’t help. The Google Transfer Appliance comes in 7 TB, 40 TB and 300 TB sizes. However, the turnaround time (Google ships the appliance to you, you load it with data, you ship it back, Google unloads it to a Cloud Storage bucket) is approximately 3 weeks. Eliminate C and D. That leaves A and E. A 10 Gbps link would transfer 100 TB in 30 hours. That leaves 18 hours for a CDC solution to sync the data. https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

   Source: Adapted from community discussion — dynamic_dba

   References

   • Google Cloud documentation

   Next question

9. Question 119 · 170 in bank

   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?

   • AAutomate instance creation by writing a Dataflow job.
   • BAutomate instance creation by setting up Terraform scripts.
   • CCreate the instances using the Google Cloud Console UI.
   • DCreate clones from a template Cloud SQL instance.

   Show answer

   Answer: B

   Explanation

   B. The scale of the problem suggests automation. Eliminate C and D. Dataflow concerns data, not instances. The only answer which makes sense is to use Terraform.

   Source: Adapted from community discussion — dynamic_dba

   Next question

10. Question 120 · 170 in bank

    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?

    • A1 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.
    • B1 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.
    • C1. 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.
    • D1. 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

    Answer: D

    Explanation

    Keeping local storage on flash drive would meet the requirement for RTO. And moving older backups to Archival storage is the cost-effective option.

    Source: Adapted from community discussion — Jay_Krish

    References

    • Google Cloud documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PCDBE practice, question 111. 170 questions available.