Enhance your career with Professional-Cloud-Database-Engineer PDF Dumps - True Google Exam Questions
New (2023) Download free Professional-Cloud-Database-Engineer PDF for Google Practice Tests
NEW QUESTION 45
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. Create a new service account, and grant it the Cloud Spanner Database Reader role.
- D. Reuse the existing service account that populates this database.
Answer: A
NEW QUESTION 46
You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?
- A. Migrate to Compute Engine.
- B. Migrate to Google Cloud VMware Engine
- C. Migrate to Google Kubernetes Engine (GKE)
- D. Migrate to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION 47
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?
- A. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
- B. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- C. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
- D. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
Answer: C
NEW QUESTION 48
Your retail organization is preparing for the holiday season. Use of catalog services is increasing, and your DevOps team is supporting the Cloud SQL databases that power a microservices-based application. The DevOps team has added instrumentation through Sqlcommenter. You need to identify the root cause of why certain microservice calls are failing. What should you do?
- A. Watch Cloud Trace for application requests that are failing.
- B. Watch the Cloud SQL recommenders for overprovisioned instances.
- C. Watch the Cloud SQL instance monitor for CPU utilization metrics.
- D. Watch Query Insights for long running queries.
Answer: D
NEW QUESTION 49
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. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- D. Edit the instance to change the storage type from HDD to SSD.
Answer: C
NEW QUESTION 50
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?
- A. 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.
- B. 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.
- C. 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.
- D. 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.
Answer: B
NEW QUESTION 51
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Issue a gcloud compute instances update command to increase the number of vCPUs.
- B. Update a MySQL database flag to increase the number of vCPUs.
- C. Back up the database, create an instance with additional vCPUs, and restore the database.
- D. Issue a gcloud sql instances patch command to increase the number of vCPUs.
Answer: D
NEW QUESTION 52
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use Bigtable with clusters in multiple regions to deploy the database
- B. Use Cloud Spanner to deploy the database.
- C. Use Cloud SQL with a regional read replica to deploy the database.
- D. Use BigQuery to deploy the database
Answer: D
NEW QUESTION 53
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
- B. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
Answer: B
NEW QUESTION 54
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. Check the cloudsql.googleapis.com/postgres.log instance log.
- C. Use Cloud Audit Logs to verify the status.
- D. Perform the gcloud sql operations list command.
Answer: C
NEW QUESTION 55
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
- A. Use a cross-region read replica to migrate the databases to Cloud SQL.
- B. Use a read replica to migrate the databases to Cloud SQL.
- C. Use replication from an external server to migrate the databases to Cloud SQL.
- D. Use Database Migration Service to migrate the databases to Cloud SQL.
- E. Use an external read replica to migrate the databases to Cloud SQL.
Answer: B,C
NEW QUESTION 56
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 mixed storage types.
- B. Recommend hard disk drives (HDD).
- C. Recommend solid-state drives (SSD).
- D. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
Answer: D
NEW QUESTION 57
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?
- A. Use Firestore and ensure that the PersistenceEnabled option is set to true.
- B. Use Memorystore for Memcached.
- C. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
- D. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
Answer: D
NEW QUESTION 58
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. Use Memorystore to handle your low-latency requirements and for real-time analytics.
- C. 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.
- D. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
Answer: C
NEW QUESTION 59
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?
- A. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Enable the Cloud SQL Admin API.
- D. Ensure that you are using an external (public) IP address interface.
Answer: A
NEW QUESTION 60
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. Create a PostgreSQL database on-premises as the HA option.
- C. Configure single zone availability for automated backups.
- D. Enable point-in-time recovery.
- E. Schedule automated backups.
Answer: B,D
NEW QUESTION 61
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?
- A. Cloud Spanner
- B. Cloud SQL
- C. BigQuery
- D. Bigtable
Answer: C
NEW QUESTION 62
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in text format.
- B. Use Cloud Functions to run the export in Avro format.
- C. Use Cloud Functions to run the export in text format.
- D. Use Dataflow to run the export in Avro format.
Answer: D
NEW QUESTION 63
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Cloud SQL with cross-region replicas.
- C. Use highly available Cloud SQL with multiple zones.
- D. Use Cloud Spanner in a regional configuration.
Answer: D
NEW QUESTION 64
......
Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
100% Free Professional-Cloud-Database-Engineer Files For passing the exam Quickly: https://www.dumpsmaterials.com/Professional-Cloud-Database-Engineer-real-torrent.html
Professional-Cloud-Database-Engineer Dumps Questions Study Exam Guide : https://drive.google.com/open?id=1DFs2p2T5miXxNd9ufAdcgXvs_fmlcxss
