ExamGecko
Login
Ask Question

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

List of questions

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?

Use Bigtable with multi-region clusters.
Use Bigtable with multi-region clusters.
Use Memorystore for Redis with multi-zones within a region.
Use Memorystore for Redis with multi-zones within a region.
Use Cloud SQL for PostgreSQL with cross-region replicas.
Use Cloud SQL for PostgreSQL with cross-region replicas.
Use Cloud Spanner with multi-region configuration.
Use Cloud Spanner with multi-region configuration.
Suggested answer: C
asked 18/09/2024
Nathan Davies
38 questions

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?

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
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.
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.
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.
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.
Suggested answer: B

Explanation:

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

asked 18/09/2024
Mukesh Kumar
33 questions

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?

Set up all read replicas in a different region using asynchronous replication.
Set up all read replicas in a different region using asynchronous replication.
Set up all read replicas in the same region as the primary instance with synchronous replication.
Set up all read replicas in the same region as the primary instance with synchronous replication.
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.
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.
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.
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.
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.

asked 18/09/2024
Judith Persons
43 questions

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?

Apply a schema data management pattern.
Apply a schema data management pattern.
Apply an instance data management pattern.
Apply an instance data management pattern.
Apply a table data management pattern.
Apply a table data management pattern.
Apply a database data management pattern.
Apply a database data management pattern.
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

asked 18/09/2024
Firasat Siddiqui
43 questions

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?

Use linear scaling to implement the Autoscaler-based architecture
Use linear scaling to implement the Autoscaler-based architecture
Use direct scaling to implement the Autoscaler-based architecture.
Use direct scaling to implement the Autoscaler-based architecture.
Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
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

asked 18/09/2024
Martin Schwarz
35 questions

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?

Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
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.
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.
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.
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.
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

asked 18/09/2024
John Atkinson
38 questions

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

Set up manual backups.
Set up manual backups.
Create a PostgreSQL database on-premises as the HA option.
Create a PostgreSQL database on-premises as the HA option.
Configure single zone availability for automated backups.
Configure single zone availability for automated backups.
Enable point-in-time recovery.
Enable point-in-time recovery.
Schedule automated backups.
Schedule automated backups.
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.

asked 18/09/2024
Fronzino Franco
35 questions

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?

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

Explanation:

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

asked 18/09/2024
Paul Hackett
38 questions

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?

Use query parameters to speed up frequently executed queries.
Use query parameters to speed up frequently executed queries.
Change the Cloud Spanner configuration from multi-region to single region.
Change the Cloud Spanner configuration from multi-region to single region.
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
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.

asked 18/09/2024
Justin Schowalter
34 questions

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?

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

Explanation:

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

asked 18/09/2024
Jerin cherian
37 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?