Grab latest Google Professional-Cloud-Database-Engineer Dumps as PDF Updated on 2022
Newly Released Professional-Cloud-Database-Engineer Dumps for Google Cloud Certified Certified
NEW QUESTION 27
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?
- A. Increase the number of CPUs for your instance.
- B. Use many smaller Cloud SQL instances.
- C. Use Cloud Spanner instead of Cloud SQL.
- D. Increase the storage size for the instance.
Answer: C
NEW QUESTION 28
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
- C. Use Firestore in Datastore mode.
- D. Use a Bigtable instance with clusters in multiple regions.
Answer: B
NEW QUESTION 29
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. Remove inactive user accounts.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Use Query Insights to identify idle instances.
- D. Build indexes on heavily accessed tables.
Answer: B
NEW QUESTION 30
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. 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.
- B. 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.
- 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, provide the database IP address, username, and password to the analytics team, and grant read access to required tables to the team.
Answer: A
NEW QUESTION 31
Your team is building an application that stores and analyzes streaming time series financial dat a. You need a database solution that can perform time series-based scans with sub-second latency. The solution must scale into the hundreds of terabytes and be able to write up to 10k records per second and read up to 200 MB per second. What should you do?
- A. Use Bigtable
- B. Use Cloud Spanner.
- C. Use Firestore.
- D. Use BigQuery.
Answer: D
NEW QUESTION 32
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. Set your production instance's maintenance window to non-business hours.
- B. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- C. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- D. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
Answer: D
NEW QUESTION 33
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?
- A. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- B. 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.
- C. 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.
- D. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
Answer: B
NEW QUESTION 34
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Cloud SQL for MySQL
- B. Use Bigtable.
- C. Use Cloud Spanner.
- D. Use Firestore.
Answer: A
NEW QUESTION 35
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?
- A. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- B. Recommend mixed storage types.
- C. Recommend hard disk drives (HDD).
- D. Recommend solid-state drives (SSD).
Answer: A
NEW QUESTION 36
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
- A. Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.
- B. Create a clone database from a read replica database, and restore the clone into a different zone.
- C. Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.
- D. Create a clone database from a read replica database, and restore the clone in the same region.
Answer: C
NEW QUESTION 37
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 Liquibase to roll out changes to higher environments.
- B. Use backup and restore to roll out changes to higher environments.
- C. Use replication to roll out changes to higher environments.
- D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
Answer: B
NEW QUESTION 38
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
- B. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
- C. Set up different organizations for each database type, and apply policy constraints at the organization level.
- D. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
Answer: C
NEW QUESTION 39
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.)
- A. Set up manual backups.
- B. Configure single zone availability for automated backups.
- C. Create a PostgreSQL database on-premises as the HA option.
- D. Enable point-in-time recovery.
- E. Schedule automated backups.
Answer: C,D
NEW QUESTION 40
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?
- A. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a - B. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b - C. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b - D. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b
Answer: D
NEW QUESTION 41
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?
- A. Take one manual backup per day, and turn off transaction log retention.
- B. Turn on automated backup, and turn off transaction log retention.
- C. Turn on automated backup, and turn on transaction log retention.
- D. Take no backups, and turn off transaction log retention.
Answer: A
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. Use the Google Cloud Console.
- B. Use Cloud Audit Logs to verify the status.
- C. Perform the gcloud sql operations list command.
- D. Check the cloudsql.googleapis.com/postgres.log instance log.
Answer: B
NEW QUESTION 43
......
Latest Professional-Cloud-Database-Engineer Exam Dumps Google Exam from Training: https://www.dumpsfree.com/Professional-Cloud-Database-Engineer-valid-exam.html
Updated Verified Professional-Cloud-Database-Engineer dumps Q&As - 100% Pass: https://drive.google.com/open?id=1-bi76gPicQTv1mrVnOKkzbOb0rWZO3-n