ExamGecko
Login
Ask Question

Google Professional Cloud Database Engineer Practice Test - Questions Answers, Page 4

List of questions

Question 31

Report
Export
Collapse

You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

Use log messages produced by Cloud SQL.
Use log messages produced by Cloud SQL.
Use Query Insights for Cloud SQL.
Use Query Insights for Cloud SQL.
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Use Cloud SQL instance monitoring in the Google Cloud Console.
Use Cloud SQL instance monitoring in the Google Cloud Console.
Suggested answer: B

Explanation:

https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction

asked 18/09/2024
Jaap van Veldhuizen
45 questions

Question 32

Report
Export
Collapse

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Suggested answer: C

Explanation:

Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.

asked 18/09/2024
Raphael Oliveir
42 questions

Question 33

Report
Export
Collapse

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

Create secondary indexes on the replica.
Create secondary indexes on the replica.
Create additional read replicas, and partition your analytics users to use different read replicas.
Create additional read replicas, and partition your analytics users to use different read replicas.
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.
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.
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.
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.
Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
Suggested answer: B, C

Explanation:

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

asked 18/09/2024
Harieswaran Ramesh
37 questions

Question 34

Report
Export
Collapse

You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:

configure where data is stored

control where the encryption keys are stored

govern the access to data

What should you do?

Replicate Cloud SQL databases across different zones.
Replicate Cloud SQL databases across different zones.
Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
Suggested answer: D

Explanation:

https://cloud.google.com/blog/products/identity-security/meet-data-residency-requirements-with-google-cloud

asked 18/09/2024
Bartosz Szewczyk
37 questions

Question 35

Report
Export
Collapse

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Create an external replica, and use Cloud SQL to synchronize the data to the replica.
Suggested answer: D

Explanation:

https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external

asked 18/09/2024
Darin Ambrose
40 questions

Question 36

Report
Export
Collapse

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

Export the data from the existing database, and load the data into a new Cloud SQL database.
Export the data from the existing database, and load the data into a new Cloud SQL database.
Use Migrate for Compute Engine to complete the migration.
Use Migrate for Compute Engine to complete the migration.
Use Datastream to complete the migration.
Use Datastream to complete the migration.
Use Database Migration Service to complete the migration.
Use Database Migration Service to complete the migration.
Suggested answer: D

Explanation:

https://www.cloudskillsboost.google/focuses/22792?parent=catalog

asked 18/09/2024
Aline Oliveira
40 questions

Question 37

Report
Export
Collapse

You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?

Set the automated backups to occur every other day to lower the frequency of backups.
Set the automated backups to occur every other day to lower the frequency of backups.
Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
Select a different region to store your backups.
Select a different region to store your backups.
Reduce the number of automated backups that are retained to two (2).
Reduce the number of automated backups that are retained to two (2).
Suggested answer: D

Explanation:

By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

asked 18/09/2024
Jaroslaw Walaszek
37 questions

Question 38

Report
Export
Collapse

You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?

Shut down and restart each application.
Shut down and restart each application.
Write a utility to scan database query logs.
Write a utility to scan database query logs.
Write a utility to scan application logs.
Write a utility to scan application logs.
Use query tags to add application-centric database monitoring.
Use query tags to add application-centric database monitoring.
Suggested answer: D

Explanation:

https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags

asked 18/09/2024
Victor Platonov
34 questions

Question 39

Report
Export
Collapse

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?

Use Cloud Spanner in a regional configuration.
Use Cloud Spanner in a regional configuration.
Use Cloud Spanner in a multi-region configuration.
Use Cloud Spanner in a multi-region configuration.
Use Cloud SQL with cross-region replicas.
Use Cloud SQL with cross-region replicas.
Use highly available Cloud SQL with multiple zones.
Use highly available Cloud SQL with multiple zones.
Suggested answer: A

Explanation:

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

asked 18/09/2024
John Hammonds
31 questions

Question 40

Report
Export
Collapse

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?

Migrate the Oracle databases to Cloud Spanner.
Migrate the Oracle databases to Cloud Spanner.
Migrate the Oracle databases to Compute Engine.
Migrate the Oracle databases to Compute Engine.
Migrate the Oracle databases to Cloud SQL.
Migrate the Oracle databases to Cloud SQL.
Migrate the Oracle databases to Bare Metal Solution for Oracle.
Migrate the Oracle databases to Bare Metal Solution for Oracle.
Suggested answer: D

Explanation:

This answer is correct because Bare Metal Solution for Oracle is a service that provides dedicated physical servers and networking infrastructure for running Oracle databases on Google Cloud1.Bare Metal Solution for Oracle supports Oracle RAC, which is a cluster database that provides high availability, scalability, and performance for Oracle workloads2.By using Bare Metal Solution for Oracle, you can migrate your Oracle databases with minimal to no changes to the applications, and you can leverage the native Google Cloud services and interconnectivity1.

asked 18/09/2024
Antonio Carlos Figueiredo Junior
50 questions
Total 132 questions
Go to page: of 14
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
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?
Your application follows a microservices architecture and uses a single large Cloud SQL instance, which is starting to have performance issues as your application grows. in the Cloud Monitoring dashboard, the CPU utilization looks normal You want to follow Google-recommended practices to resolve and prevent these performance issues while avoiding any major refactoring. What should you do?
You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
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?
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
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.)
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?