Professional-Cloud-Database-Engineer Dumps with Free 365 Days Update Fast Exam Updates
Verified Professional-Cloud-Database-Engineer dumps Q&As - 2024 Latest Professional-Cloud-Database-Engineer Download
The Google Professional-Cloud-Database-Engineer exam consists of several sections that cover various topics such as designing and implementing a database solution using Google Cloud Platform, optimizing database performance, troubleshooting database issues, and ensuring data security and compliance. Candidates are assessed on their ability to apply cloud-native technologies that enable businesses to manage their data on Google Cloud Platform efficiently. Those who pass the exam effectively demonstrate their ability to design, develop, and manage cloud-based database solutions using Google Cloud Platform.
NEW QUESTION # 24
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- C. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- D. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
Answer: A
Explanation:
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.
NEW QUESTION # 25
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?
- A. Use query parameters to speed up frequently executed queries.
- B. Use SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
- C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
- D. Change the Cloud Spanner configuration from multi-region to single region.
Answer: D
NEW QUESTION # 26
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. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- C. Edit the instance to change the storage type from HDD to SSD.
- D. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
Answer: D
NEW QUESTION # 27
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 solid-state drives (SSD).
- C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- D. Recommend hard disk drives (HDD).
Answer: C
NEW QUESTION # 28
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 the same region as the primary instance with synchronous replication.
- B. 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.
- C. Set up all read replicas in a different region using asynchronous 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 # 29
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?
- A. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status using pg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.
- B. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.
- C. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .
- D. Restore the Cloud SQL instance from the automatic backups in region 3.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#disaster_recovery
NEW QUESTION # 30
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 BigQuery to deploy the database
- B. Use Cloud Spanner to deploy the database.
- C. Use Bigtable with clusters in multiple regions to deploy the database
- D. Use Cloud SQL with a regional read replica to deploy the database.
Answer: A
NEW QUESTION # 31
You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?
- A. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.
- B. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.
- C. Use Cloud Composer to execute a select * from table(s) query and export results.
- D. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.
Answer: B
NEW QUESTION # 32
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Manually scale down the number of nodes after the peak period has passed.
- B. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
- C. Use interleaving to co-locate parent and child rows.
- D. Use granular instance sizing in Cloud Spanner and Autoscaler.
Answer: B
NEW QUESTION # 33
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
- A. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance. - B. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance. - C. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance. - D. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance.
Answer: B
NEW QUESTION # 34
Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?
- A. Create an external replica, and use Cloud SQL to synchronize the data to the replica.
- B. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- C. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
- D. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external
NEW QUESTION # 35
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. Reuse the existing service account that populates this database.
- C. Create a new service account, and grant it the spanner.databases.select permission.
- D. Create a new service account, and grant it the Cloud Spanner Database Reader role.
Answer: A
NEW QUESTION # 36
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
- A. Set the automated backups to occur every other day to lower the frequency of backups.
- B. Reduce the number of automated backups that are retained to two (2).
- C. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- D. Select a different region to store your backups.
Answer: B
Explanation:
By default, for each instance, Cloud SQL retains seven automated backups, in addition to on-demand backups. You can configure how many automated backups to retain (from 1 to 365). We charge a lower rate for backup storage than for other types of instances. https://cloud.google.com/sql/docs/mysql/backup-recovery/backups
NEW QUESTION # 37
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 Cloud Spanner in a regional configuration.
- B. Use zonal Cloud SQL without high availability (HA).
- C. Use high availability (HA) Cloud SQL with multiple zones.
- D. Use Cloud SQL with cross-region replicas.
Answer: A
Explanation:
https://docs.google.com/forms/d/e/1FAIpQLSfZ77ZnuUL0NpU-bOtO5QUkC0cnRCe5YKMiubLXwfV3abBqkg/viewform
NEW QUESTION # 38
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. Turn on automated backup, and turn off transaction log retention.
- B. Take no backups, and turn off transaction log retention.
- C. Take one manual backup per day, and turn off transaction log retention.
- D. Turn on automated backup, and turn on transaction log retention.
Answer: C
NEW QUESTION # 39
Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?
- A. Manually or automatically increase the storage capacity.
- B. Compress the data using a different compression algorithm.
- C. Normalize the database to the third normal form.
- D. Create another schema to load older data.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen
NEW QUESTION # 40
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: B
Explanation:
https://cloud.google.com/bigtable/docs/performance#troubleshooting
NEW QUESTION # 41
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Increase the amount of memory allocated to your instance.
- B. Ensure that the service account has the Storage Admin role.
- C. Close idle connections or restart the instance before beginning the import operation.
- D. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
Answer: B
NEW QUESTION # 42
You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?
- A. Manually scale down the number of nodes after the peak period has passed.
- B. Use granular instance sizing in Cloud Spanner and Autoscaler.
- C. Use interleaving to co-locate parent and child rows.
- D. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
Answer: B
Explanation:
Granular instance is available in Public Preview. With this feature, you can run workloads on Spanner at as low as 1/10th the cost of regular instances, https://cloud.google.com/blog/products/databases/get-more-out-of-spanner-with-granular-instance-sizing
NEW QUESTION # 43
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. Ensure that you are using an external (public) IP address interface.
- B. Enable the Cloud SQL Admin API.
- C. Check whether your service account has cloudsql.instances.connect permission.
- D. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
Answer: D
NEW QUESTION # 44
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
- A. Use Database Migration Service to replicate tables into BigQuery.
- B. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- C. Use Cloud SQL federated queries.
- D. Develop a custom data replication service to send data into BigQuery.
Answer: B
NEW QUESTION # 45
You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue. What should you do first?
- A. Increase the number of processing units.
- B. Shard data required by the application into multiple instances.
- C. Modify the database schema, and add additional indexes.
- D. Decrease the number of processing units.
Answer: A
NEW QUESTION # 46
......
Updated Google Study Guide Professional-Cloud-Database-Engineer Dumps Questions: https://www.braindumpquiz.com/Professional-Cloud-Database-Engineer-exam-material.html
Dumps Questions [2024] Pass for Professional-Cloud-Database-Engineer Exam: https://drive.google.com/open?id=1RtxD4i7vJuO6ImhIf8Kxy2XVnjG48S0Y