ExamGecko
Login
Ask Question

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

List of questions

Question 61

Report
Export
Collapse

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?

Configure Firestore, and modify your application to offload queries.
Configure Firestore, and modify your application to offload queries.
Configure Bigtable, and modify your application to offload queries.
Configure Bigtable, and modify your application to offload queries.
Configure Cloud SQL for PostgreSQL read replicas to offload queries.
Configure Cloud SQL for PostgreSQL read replicas to offload queries.
Configure Memorystore, and modify your application to offload queries.
Configure Memorystore, and modify your application to offload queries.
Suggested answer: D

Explanation:

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

asked 18/09/2024
Federico Miliacca
33 questions

Question 62

Report
Export
Collapse

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
Suggested answer: C

Explanation:

Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance

asked 18/09/2024
Maurice Nicholson
43 questions

Question 63

Report
Export
Collapse

You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?

Take no backups, and turn off transaction log retention.
Take no backups, and turn off transaction log retention.
Take one manual backup per day, and turn off transaction log retention.
Take one manual backup per day, and turn off transaction log retention.
Turn on automated backup, and turn off transaction log retention.
Turn on automated backup, and turn off transaction log retention.
Turn on automated backup, and turn on transaction log retention.
Turn on automated backup, and turn on transaction log retention.
Suggested answer: C

Explanation:

https://cloud.google.com/sql/docs/mysql/backup-recovery/backups

asked 18/09/2024
Pranoy Bej
33 questions

Question 64

Report
Export
Collapse

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

Set your production instance's maintenance window to non-business hours.
Set your production instance's maintenance window to non-business hours.
Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Suggested answer: A
asked 18/09/2024
Natcha Koopipat
42 questions

Question 65

Report
Export
Collapse

You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?

Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
Suggested answer: A

Explanation:

https://cloud.google.com/sql/docs/mysql/quotas#table_limit

asked 18/09/2024
Kevin Suckiel
48 questions

Question 66

Report
Export
Collapse

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?

Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
Use Cloud Composer to execute a select * from table(s) query and export results.
Use Cloud Composer to execute a select * from table(s) query and export results.
Suggested answer: B

Explanation:

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

asked 18/09/2024
Ishan Rathnayaka
36 questions

Question 67

Report
Export
Collapse

You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?

Use Cloud SQL with read replicas for throughput.
Use Cloud SQL with read replicas for throughput.
Use Firestore, and rely on automatic serverless scaling.
Use Firestore, and rely on automatic serverless scaling.
Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
Use Bigtable, and add nodes as necessary to achieve the required throughput.
Use Bigtable, and add nodes as necessary to achieve the required throughput.
Suggested answer: D

Explanation:

https://cloud.google.com/memorystore/docs/redis/redis-overview

asked 18/09/2024
Mohamed Ismail
49 questions

Question 68

Report
Export
Collapse

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

Use Cloud Spanner with a customer-managed encryption key (CMEK).
Use Cloud Spanner with a customer-managed encryption key (CMEK).
Use Cloud Spanner with default encryption.
Use Cloud Spanner with default encryption.
Use Cloud SQL with a customer-managed encryption key (CMEK).
Use Cloud SQL with a customer-managed encryption key (CMEK).
Use Bigtable with default encryption.
Use Bigtable with default encryption.
Suggested answer: A

Explanation:

Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.

asked 18/09/2024
lakshmi potla
30 questions

Question 69

Report
Export
Collapse

You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
Verify that the new replica is created automatically.
Verify that the new replica is created automatically.
Start the original primary instance and resume replication.
Start the original primary instance and resume replication.
Suggested answer: C

Explanation:

Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.

asked 18/09/2024
Christodoulos Chiras
29 questions

Question 70

Report
Export
Collapse

You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?

Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
Suggested answer: C

Explanation:

The best answer is deploy an HA configuration and have a read replica you could promote to the primary in a different region

asked 18/09/2024
hamza reza
49 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?