Google Google Certifications PROFESSIONAL-CLOUD-DATABASE-ENGINEER Questions & Answers

• Question 61:

  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.

  Correct Answer: C

  Cloud Scheduler triggers actions at regular fixed intervals, whereas Cloud Tasks triggers actions based on how the individual task object is configured. Reference: https://cloud.google.com/tasks/docs/comp-tasks-sched

• Question 62:

  Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster

  recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications.

  What should you do?

  A. Migrate the databases to Cloud Spanner.

  B. Migrate the databases to Cloud SQL, and enable a standby database.

  C. Migrate the databases to Compute Engine using regional persistent disks.

  D. Migrate the databases to Bare Metal Solution for Oracle.

  Correct Answer: D

  BMS is the only Google database service which supports Oracle aside from GCVE. It allows you to use all native Oracle features including RAC. Since GCVE isn't mentioned, it has to be D -Bare Metal Solution.

• Question 63:

  Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)

  A. Create secondary indexes on the replica.

  B. Create additional read replicas, and partition your analytics users to use different read replicas.

  C. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.

  D. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.

  E. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.

  Correct Answer: BC

  Replication lag and slow report performance. E is eliminated because using BigQuery would mean changes to the current reports. Report slowness could be the result of poor indexing or just too much read load (or both!). Since excessive load is mentioned in the question, creating additional read replicas and spreading the analytics workload around makes B correct and eliminates A as a way to speed up reporting. That leaves the replication problem. Cloud SQL enables single threaded replication by default, so it stands to reason enabling parallel replication would help the lag. To do that you disable replication on the replica (not the primary), set flags on the replica and optionally set flags on the primary instance to optimize performance for parallel replication. That makes C correct and D incorrect. https://cloud.google.com/sql/docs/mysql/replication/manage-replicas#configuring-parallel-replication

• Question 64:

  Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

  A. Normalize the database to the third normal form.

  B. Compress the data using a different compression algorithm.

  C. Manually or automatically increase the storage capacity.

  D. Create another schema to load older data.

  Correct Answer: C

  https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen

• Question 65:

  You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?

  A. Use Cloud Spanner in a regional configuration.

  B. Use Cloud Spanner in a multi-region configuration.

  C. Use Cloud SQL with cross-region replicas.

  D. Use highly available Cloud SQL with multiple zones.

  Correct Answer: A

  https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform

• Question 66:

  You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

  A. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

  B. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

  C. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

  D. Use Cloud Composer to execute a select * from table(s) query and export results.

  Correct Answer: B

  https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler

• Question 67:

  Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

  A. Use replication to roll out changes to higher environments.

  B. Use backup and restore to roll out changes to higher environments.

  C. Use Liquibase to roll out changes to higher environments.

  D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

  Correct Answer: C

  To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner. https://cloud.google.com/spanner/docs/use-liquibase

• Question 68:

  Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

  A. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.

  B. Use Cloud SQL Auth proxy.

  C. Connect to Cloud SQL using a connection that has SSL encryption.

  D. Use customer-managed encryption keys with Cloud SQL.

  Correct Answer: D

• Question 69:

  Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

  A. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

  B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

  C. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.

  D. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

  Correct Answer: D

  Cloud Monitoring collects metrics, events, and metadata from Google Cloud, Amazon Web Services (AWS), hosted uptime probes, and application instrumentation. Using the BindPlane service, you can also collect this data from over 150 common application components, on-premise systems, and hybrid cloud systems.

• Question 70:

  You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

  A. Configure Firestore, and modify your application to offload queries.

  B. Configure Bigtable, and modify your application to offload queries.

  C. Configure Cloud SQL for PostgreSQL read replicas to offload queries.

  D. Configure Memorystore, and modify your application to offload queries.

  Correct Answer: D

  "sub-millisecond latency" always involves Memorystore. Furthermore, as we are talking about a relational DB (Cloud SQL), BigTable is not a solution to be considered.