Real Professional-Cloud-Database-Engineer Exam Questions are the Best Preparation Material
Practice on 2024 LATEST Professional-Cloud-Database-Engineer Exam Updated 134 Questions
The Google Professional-Cloud-Database-Engineer exam tests candidates' knowledge in various areas, including database design, data modeling, database security, and database migration. Candidates are also expected to have a deep understanding of the different Google Cloud database services, such as Cloud SQL, Cloud Spanner, and Cloud Bigtable. Professional-Cloud-Database-Engineer exam assesses candidates' ability to design and implement highly available, scalable, and secure database solutions using Google Cloud.
Google Professional-Cloud-Database-Engineer exam is a certification offered to professionals who have the expertise in designing, developing, and managing Google Cloud Platform (GCP) databases. Google Cloud Certified - Professional Cloud Database Engineer certification is aimed towards individuals who have a deep understanding of database architecture, data modeling, and data management using GCP services. Professional-Cloud-Database-Engineer exam tests the candidate’s ability to design, develop, and administer GCP databases, as well as their knowledge of GCP database services such as Cloud SQL, Cloud Spanner, and Cloud Bigtable.
Google Professional-Cloud-Database-Engineer certification exam measures the candidate's ability to perform essential database engineer tasks such as configuring database systems, ensuring data availability, optimizing database performance, and managing database security. Professional-Cloud-Database-Engineer exam also evaluates the candidate's ability to design and implement database solutions that meet specific business requirements. Professional-Cloud-Database-Engineer exam consists of multiple-choice and scenario-based questions that assess the candidate's practical skills and knowledge of Google Cloud Platform's database services. Passing Professional-Cloud-Database-Engineer exam demonstrates that the candidate has the skills and knowledge required to excel in a database engineering role on Google Cloud Platform.
NEW QUESTION # 25
You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. You are planning a gradual rollout of the system to a few stores each week. You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?
- A. Use sharded Cloud SQL instances with one or more stores per database instance.
- B. Use Cloud Spanner with a custom autoscaling solution.
- C. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- D. Use a Biglable cluster with autoscaling.
Answer: B
Explanation:
https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud
NEW QUESTION # 26
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 replication to roll out changes to higher environments.
- C. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.
- D. Use backup and restore to roll out changes to higher environments.
Answer: A
Explanation:
To satisfy audit reporting you would need a way to record what was changed and when. The best answer is one which uses some kind of source code control system (SCCS). That rules out A and B. Any mention of anything manual in a cloud environment should look suspicious, which leave option C. As it happens, Liquibase is an SCCS and can be integrated with Spanner. https://cloud.google.com/spanner/docs/use-liquibase
NEW QUESTION # 27
Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?
- A. Use Cloud Spanner for data storage.
- B. Use Memorystore for data storage.
- C. Use Bigtable for data storage.
- D. Use Cloud SQL for data storage.
Answer: A
Explanation:
google Cloud Spanner is a highly scalable, reliable, and fully managed relational database service that runs on Google's infrastructure. It's designed to handle large amounts of data and provide high availability, even in the face of failures. Spanner can be used to store and manage data for a variety of applications, including e-commerce websites. Spanner is a good choice for this scenario because it can handle high write throughput and provides 99.99% uptime. It's also a good fit for applications that need to be highly available, even in the face of failures.
NEW QUESTION # 28
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
- B. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- C. Create additional read replicas, and partition your analytics users to use different read replicas.
- D. Create secondary indexes on the replica.
- E. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
Answer: B,C
NEW QUESTION # 29
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?
- A. Use Migrate for Compute Engine to complete the migration.
- B. Use Datastream to complete the migration.
- C. Export the data from the existing database, and load the data into a new Cloud SQL database.
- D. Use Database Migration Service to complete the migration.
Answer: C
NEW QUESTION # 30
Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?
- A. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.
- B. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.
- C. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
- D. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
Answer: C
NEW QUESTION # 31
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 # 32
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. Update a MySQL database flag to increase the number of vCPUs.
- B. Back up the database, create an instance with additional vCPUs, and restore the database.
- C. Issue a gcloud compute instances update command to increase the number of vCPUs.
- D. Issue a gcloud sql instances patch command to increase the number of vCPUs.
Answer: D
NEW QUESTION # 33
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 the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
- B. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
- 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 database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
Answer: D
NEW QUESTION # 34
You are the primary DBA of a Cloud SQL for PostgreSQL database that supports 6 enterprise applications in production. You used Cloud SQL Insights to identify inefficient queries and now need to identify the application that is originating the inefficient queries. You want to follow Google-recommended practices. What should you do?
- A. Write a utility to scan application logs.
- B. Shut down and restart each application.
- C. Write a utility to scan database query logs.
- D. Use query tags to add application-centric database monitoring.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/using-query-insights#filter_by_query_tags
NEW QUESTION # 35
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 Compute Engine VM, install MySQL on the VM, and then import the dump file.
- C. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.
- D. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external
NEW QUESTION # 36
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 Cloud SQL for PostgreSQL.
- B. Migrate the existing database to Cloud Spanner.
- C. Migrate the existing database to Firestore.
- D. Migrate the existing database to PostgreSQL running on Compute Engine.
Answer: A
Explanation:
You could migrate to Spanner leveraging the PostgreSQL dialect, but costs need to be minimized so that wouldn't be the cheapest option. Especially since the load doesn't justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.
NEW QUESTION # 37
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. Ensure that the service account has the Storage Admin role.
- B. Close idle connections or restart the instance before beginning the import operation.
- C. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- D. Increase the amount of memory allocated to your instance.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#troubleshooting
NEW QUESTION # 38
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- C. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- D. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Answer: B
NEW QUESTION # 39
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 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.
- B. 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.
- C. 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.
- D. 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
Answer: C
NEW QUESTION # 40
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?
- A. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
Schedule downtime to run each Cloud Data Fusion pipeline.
Verify that the migration was successful.
Re-point the applications to the Cloud SQL for MySQL instance. - B. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in CSV format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - C. Pause the on-premises applications.
Use the mysqldump utility to dump the database content in compressed format.
Run gsutil -m to move the dump file to Cloud Storage.
Use the Cloud SQL for MySQL import option.
After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance. - D. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
Answer: A
NEW QUESTION # 41
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
- A. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- B. Set up Traffic Director.
- C. Set up Private Service Connect.
- D. Set up Serverless VPC Access.
Answer: A
NEW QUESTION # 42
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
- A. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- D. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
Answer: B
NEW QUESTION # 43
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 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.
- B. 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.
- C. 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.
- D. 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
Answer: C
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 # 44
You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)
- A. Drop or disable all users except database administration users.
- B. Disable all foreign key constraints on the source PostgreSQL database.
- C. Ensure that all PostgreSQL tables have a primary key.
- D. Shut down the database before the Data Migration Service task is started.
- E. Ensure that pglogical is installed on the source PostgreSQL database.
Answer: C,E
Explanation:
https://cloud.google.com/database-migration/docs/postgres/faq
NEW QUESTION # 45
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- C. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- D. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Answer: D
Explanation:
Creating a new instance and migrating data can be time-consuming and disruptive to your application's availability. Shutting down the existing instance is not a recommended approach, as it will cause downtime for your application.
The recommended approach is to use the gcloud instances patch command to enable high availability on your existing Cloud SQL for MySQL instance. This command updates the instance's configuration to enable the failover replica, configure it, and enable automatic failover.
By following this approach, you can ensure minimal downtime, and your application can continue to operate during the process.
NEW QUESTION # 46
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
- A. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
- C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- D. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
Answer: A
Explanation:
Cloud Monitoring collects metrics, events, and metadata from Google Cloud, Amazon Web Services (AWS), hosted uptime probes, and application instrumentation. Using the BindPlane service, you can also collect this data from over 150 common application components, on-premise systems, and hybrid cloud systems.
NEW QUESTION # 47
......
Authentic Professional-Cloud-Database-Engineer Exam Dumps PDF - Jan-2024 Updated: https://www.2pass4sure.com/Google-Cloud-Certified/Professional-Cloud-Database-Engineer-actual-exam-braindumps.html
Download Latest Professional-Cloud-Database-Engineer Dumps with Authentic Real Exam QA's: https://drive.google.com/open?id=1BAje7hmdVPXkXuZzS4WkoEq5i_4mYpjt