Google Professional-Cloud-Database-Engineer Exam Preparation Guide and PDF Download
Verified & Correct Professional-Cloud-Database-Engineer Practice Test Reliable Source Jul 06, 2023 Updated
NEW QUESTION # 39
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 Cloud Spanner with multi-region configuration.
- B. Use Bigtable with multi-region clusters.
- C. Use Cloud SQL for PostgreSQL with cross-region replicas.
- D. Use Memorystore for Redis with multi-zones within a region.
Answer: C
NEW QUESTION # 40
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
- A. Identify whether the database has over 512 tables.
- B. Identify whether the source database uses customer-managed encryption keys (CMEK).
- C. Identify all tables that do not have a primary key.
- D. Identity all tables that do not have at least one foreign key.
- E. Identify whether the source database is encrypted using pgcrypto extension.
Answer: B,D
NEW QUESTION # 41
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
- C. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
- D. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
Answer: C
NEW QUESTION # 42
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?
- A. Perform the gcloud sql operations list command.
- B. Use the Google Cloud Console.
- C. Check the cloudsql.googleapis.com/postgres.log instance log.
- D. Use Cloud Audit Logs to verify the status.
Answer: D
NEW QUESTION # 43
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?
- A. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- B. Use Key Visualizer for Bigtable.
- C. Add more nodes to the Bigtable cluster.
- D. Isolate the data analysts and operations user groups to use different Bigtable instances.
Answer: A
NEW QUESTION # 44
Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?
- A. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- B. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- C. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- D. Edit the instance to change the storage type from HDD to SSD.
Answer: B
NEW QUESTION # 45
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)
- A. If the corruption is significant, use import and export.
- B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- E. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
Answer: B,E
NEW QUESTION # 46
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?
- A. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter for Application C - B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner databaseReader for Application C - C. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupWriter for Application C - D. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseReader for Person B
roles/spanner.backupAdmin for Application C
Answer: D
NEW QUESTION # 47
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?
- A. 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. - B. 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. - C. 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. - D. 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.
Answer: B
NEW QUESTION # 48
Your organization has a busy transactional Cloud SQL for MySQL instance. Your analytics team needs access to the data so they can build monthly sales reports. You need to provide data access to the analytics team without adversely affecting performance. What should you do?
- A. Create a read replica of the database, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
- B. Provide the database IP address, username, and password of the primary database instance to the analytics, team, and grant read access to required tables to the team.
- C. Enable the cloudsql.iam_authentication flag on the primary database instance, and grant read access to required tables to the analytics team.
- D. Create a read replica of the database, enable the cloudsql.iam_authentication flag on the replica, and grant read access to required tables to the analytics team.
Answer: B
NEW QUESTION # 49
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?
- A. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
- B. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
- C. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.
- D. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
Answer: B
NEW QUESTION # 50
Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?
- A. Use replication to roll out changes to higher environments.
- B. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- C. Use Liquibase to roll out changes to higher environments.
- D. Use backup and restore to roll out changes to higher environments.
Answer: D
NEW QUESTION # 51
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use the mysqldump utility and binary logs.
- B. Use external server replication.
- C. Use Data Migration Service.
- D. Use Cloud SQL for MySQL external replica.
Answer: C
NEW QUESTION # 52
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.
- B. Apply a table data management pattern.
- C. Apply a database data management pattern.
- D. Apply an instance data management pattern.
Answer: D
NEW QUESTION # 53
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?
- A. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- B. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- C. Set your production instance's maintenance window to non-business hours.
- D. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
Answer: B
NEW QUESTION # 54
Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?
- A. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- B. Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.
- C. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- D. Use Memorystore to handle your low-latency requirements and for real-time analytics.
Answer: B
NEW QUESTION # 55
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
- A. Use the mysqldump utility on the primary database instance to export the backup.
- B. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- C. Create a read replica, and then use the mysqldump utility to export each table.
- D. Use Cloud SQL serverless exports.
Answer: B
NEW QUESTION # 56
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 dat a. What should you do?
- A. Use VPC Service Controls to create a trusted network for the Bigtable service.
- B. Use Identity and Access Management (IAM) for Bigtable access control.
- C. Use Google Cloud Armor to add IP addresses to an allowlist.
- D. Use customer-managed encryption keys (CMEK).
Answer: A
NEW QUESTION # 57
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.
- B. Set up all read replicas in the same region as the primary instance with synchronous replication.
- C. 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 synchronous replication, and set up read replicas in different regions with asynchronous replication.
Answer: D
NEW QUESTION # 58
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?
- A. Create a new service account, and grant it the Cloud Spanner Database Admin role.
- B. Create a new service account, and grant it the spanner.databases.select permission.
- C. Reuse the existing service account that populates this database.
- D. Create a new service account, and grant it the Cloud Spanner Database Reader role.
Answer: A
NEW QUESTION # 59
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
- A. Use zonal Cloud SQL without high availability (HA).
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a regional configuration.
- D. Use high availability (HA) Cloud SQL with multiple zones.
Answer: B
NEW QUESTION # 60
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to PostgreSQL running on Compute Engine.
- B. Migrate the existing database to Cloud Spanner.
- C. Migrate the existing database to Firestore.
- D. Migrate the existing database to Cloud SQL for PostgreSQL.
Answer: D
NEW QUESTION # 61
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
- B. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
- C. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
- D. Replicate Cloud SQL databases across different zones.
Answer: A
NEW QUESTION # 62
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?
- A. For each application code, set up a common shared user account.
- B. For each application code, set up a dedicated user account.
- C. For the application server, set up a common shared user account.
- D. For the application server, set up a service account.
Answer: B
NEW QUESTION # 63
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?
- A. Use Query Insights to identify idle instances.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Build indexes on heavily accessed tables.
- D. Remove inactive user accounts.
Answer: B
NEW QUESTION # 64
......
Pass Google Professional-Cloud-Database-Engineer exam Dumps 100 Pass Guarantee With Latest Demo: https://lead2pass.guidetorrent.com/Professional-Cloud-Database-Engineer-dumps-questions.html