ExamGecko
Login
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
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?