ExamGecko
Search Search Login
Home Home / Google / Professional Cloud Database Engineer

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

Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
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?
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. 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 work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. 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 has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?
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?
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?
You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

Question 11

Report
Export
Collapse

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

A.
Use Bigtable with multi-region clusters.
A.
Use Bigtable with multi-region clusters.
Answers
B.
Use Memorystore for Redis with multi-zones within a region.
B.
Use Memorystore for Redis with multi-zones within a region.
Answers
C.
Use Cloud SQL for PostgreSQL with cross-region replicas.
C.
Use Cloud SQL for PostgreSQL with cross-region replicas.
Answers
D.
Use Cloud Spanner with multi-region configuration.
D.
Use Cloud Spanner with multi-region configuration.
Answers
Suggested answer: C

Question 12

Report
Export
Collapse

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

A.
Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
A.
Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Answers
B.
Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
B.
Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
Answers
C.
Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
C.
Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
Answers
D.
Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
D.
Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
Answers
Suggested answer: B

Explanation:

https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr

Question 13

Report
Export
Collapse

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A.
Set up all read replicas in a different region using asynchronous replication.
A.
Set up all read replicas in a different region using asynchronous replication.
Answers
B.
Set up all read replicas in the same region as the primary instance with synchronous replication.
B.
Set up all read replicas in the same region as the primary instance with synchronous replication.
Answers
C.
Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
C.
Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
Answers
D.
Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
D.
Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
Answers
Suggested answer: C

Explanation:

This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1.This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.

This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2.This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.

Question 14

Report
Export
Collapse

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat

a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

A.
Apply a schema data management pattern.
A.
Apply a schema data management pattern.
Answers
B.
Apply an instance data management pattern.
B.
Apply an instance data management pattern.
Answers
C.
Apply a table data management pattern.
C.
Apply a table data management pattern.
Answers
D.
Apply a database data management pattern.
D.
Apply a database data management pattern.
Answers
Suggested answer: B

Explanation:

https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner#multi-tenancy-data-management-patterns

https://cloud.google.com/solutions/implementing-multi-tenancy-cloud-spanner

Question 15

Report
Export
Collapse

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?

A.
Use linear scaling to implement the Autoscaler-based architecture
A.
Use linear scaling to implement the Autoscaler-based architecture
Answers
B.
Use direct scaling to implement the Autoscaler-based architecture.
B.
Use direct scaling to implement the Autoscaler-based architecture.
Answers
C.
Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
C.
Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
Answers
D.
Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
D.
Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Answers
Suggested answer: A

Explanation:

Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount. https://cloud.google.com/spanner/docs/autoscaling-overview#linear

Question 16

Report
Export
Collapse

You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?

A.
Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
A.
Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answers
B.
Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
B.
Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
Answers
C.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
C.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
Answers
D.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
D.
Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
Answers
Suggested answer: C

Explanation:

The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md

Question 17

Report
Export
Collapse

Your digital-native business runs its database workloads on Cloud SQL. Your website must be globally accessible 24/7. You need to prepare your Cloud SQL instance for high availability (HA). You want to follow Google-recommended practices. What should you do? (Choose two.)

A.
Set up manual backups.
A.
Set up manual backups.
Answers
B.
Create a PostgreSQL database on-premises as the HA option.
B.
Create a PostgreSQL database on-premises as the HA option.
Answers
C.
Configure single zone availability for automated backups.
C.
Configure single zone availability for automated backups.
Answers
D.
Enable point-in-time recovery.
D.
Enable point-in-time recovery.
Answers
E.
Schedule automated backups.
E.
Schedule automated backups.
Answers
Suggested answer: D, E

Explanation:

D) Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.

Question 18

Report
Export
Collapse

Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

A.
Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
A.
Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
Answers
B.
Migrate applications and Oracle databases to Compute Engine.
B.
Migrate applications and Oracle databases to Compute Engine.
Answers
C.
Migrate applications to Cloud SQL.
C.
Migrate applications to Cloud SQL.
Answers
D.
Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
D.
Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
Answers
Suggested answer: A

Explanation:

https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve

Question 19

Report
Export
Collapse

Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?

A.
Use query parameters to speed up frequently executed queries.
A.
Use query parameters to speed up frequently executed queries.
Answers
B.
Change the Cloud Spanner configuration from multi-region to single region.
B.
Change the Cloud Spanner configuration from multi-region to single region.
Answers
C.
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
C.
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Answers
D.
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
D.
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
Answers
Suggested answer: C

Explanation:

To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.

Question 20

Report
Export
Collapse

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

A.
Use Database Migration Service to migrate all databases to Cloud SQL.
A.
Use Database Migration Service to migrate all databases to Cloud SQL.
Answers
B.
Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
B.
Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
Answers
C.
Use data replication tools and CDC tools to enable migration.
C.
Use data replication tools and CDC tools to enable migration.
Answers
D.
Use a combination of Database Migration Service and partner tools to support the data migration strategy.
D.
Use a combination of Database Migration Service and partner tools to support the data migration strategy.
Answers
Suggested answer: A

Explanation:

https://cloud.google.com/blog/products/databases/tips-for-migrating-across-compatible-database-engines

Total 132 questions
Go to page: of 14
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms