ExamGecko
Ask Question

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

List of questions

Question 91

Report
Export
Collapse

You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat

a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

Use Firestore and ensure that the PersistenceEnabled option is set to true.
Use Firestore and ensure that the PersistenceEnabled option is set to true.
Use Memorystore for Memcached.
Use Memorystore for Memcached.
Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
Suggested answer: A

Explanation:

https://firebase.google.com/docs/firestore/manage-data/enable-offline

asked 18/09/2024
ahmed bin shehab
45 questions

Question 92

Report
Export
Collapse

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
Suggested answer: A

Explanation:

'Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. ' https://cloud.google.com/sql/docs/mysql/maintenance

asked 18/09/2024
Fabrizio Leo
38 questions

Question 93

Report
Export
Collapse

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

Use a change data capture (CDC) migration strategy.
Use a change data capture (CDC) migration strategy.
Move the physical database servers from on-premises to Google Cloud.
Move the physical database servers from on-premises to Google Cloud.
Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
Suggested answer: A, E

Explanation:

https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer

asked 18/09/2024
Mohand TIMSILINE
41 questions

Question 94

Report
Export
Collapse

You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

Automate instance creation by writing a Dataflow job.
Automate instance creation by writing a Dataflow job.
Automate instance creation by setting up Terraform scripts.
Automate instance creation by setting up Terraform scripts.
Create the instances using the Google Cloud Console UI.
Create the instances using the Google Cloud Console UI.
Create clones from a template Cloud SQL instance.
Create clones from a template Cloud SQL instance.
Suggested answer: B
asked 18/09/2024
Sasaki Hidenobu
32 questions

Question 95

Report
Export
Collapse

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?

Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Keep backups older than one day stored in Actifio OnVault storage.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Keep backups older than one day stored in Actifio OnVault storage.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
Suggested answer: B

Explanation:

This answer meets the RTO and RPO requirements by using flash storage for the database and standard storage for the local backup copy.It also meets the cost-effectiveness requirement by using Actifio OnVault storage, which is a low-cost, high-performance, and scalable storage solution that integrates with Google Cloud Backup and DR Service1.

asked 18/09/2024
BISWARUP KUNDU
41 questions

Question 96

Report
Export
Collapse

You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:

Can read tables, views, and DDL

Can write rows to the tables

Can add columns and indexes

Cannot drop the database

What should you do?

Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
Assign the Cloud Spanner Database Admin role.
Assign the Cloud Spanner Database Admin role.
Assign the Cloud Spanner Database User role.
Assign the Cloud Spanner Database User role.
Assign the Cloud Spanner Admin role.
Assign the Cloud Spanner Admin role.
Suggested answer: C

Explanation:

https://cloud.google.com/spanner/docs/iam#spanner.databaseUser

asked 18/09/2024
Elias Lopez III
44 questions

Question 97

Report
Export
Collapse

Your project is using Bigtable to store data that should not be accessed from the public internet under any circumstances, even if the requestor has a valid service account key. You need to secure access to this data. What should you do?

Use Identity and Access Management (IAM) for Bigtable access control.
Use Identity and Access Management (IAM) for Bigtable access control.
Use VPC Service Controls to create a trusted network for the Bigtable service.
Use VPC Service Controls to create a trusted network for the Bigtable service.
Use customer-managed encryption keys (CMEK).
Use customer-managed encryption keys (CMEK).
Use Google Cloud Armor to add IP addresses to an allowlist.
Use Google Cloud Armor to add IP addresses to an allowlist.
Suggested answer: B

Explanation:

''Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data.'' https://cloud.google.com/vpc-service-controls

asked 18/09/2024
giancarlo bagnetti srl
42 questions

Question 98

Report
Export
Collapse

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?

Cloud SQL
Cloud SQL
BigQuery
BigQuery
Cloud Spanner
Cloud Spanner
Bigtable
Bigtable
Suggested answer: B
asked 18/09/2024
André Batista
39 questions

Question 99

Report
Export
Collapse

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down by an order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

Become a Premium Member for full access
  Unlock Premium Member

Question 100

Report
Export
Collapse

Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

Become a Premium Member for full access
  Unlock Premium Member
Total 132 questions
Go to page: of 14
Search

Related questions