[Dec 31, 2024] Professional-Cloud-Database-Engineer Questions Truly Valid For Your Google Exam!
Professional-Cloud-Database-Engineer Actual Questions - Instant Download Tests Free Updated Today!
Google Cloud Certified - Professional Cloud Database Engineer certification exam is a credential offered by Google to validate the skills and expertise of professionals who design and manage databases on Google Cloud. Google Cloud Certified - Professional Cloud Database Engineer certification exam is designed for individuals who have experience in designing, implementing, and managing databases on Google Cloud Platform. Professional-Cloud-Database-Engineer exam tests the candidate's knowledge of database concepts, cloud-native database services, database design and implementation, automation, and security.
NEW QUESTION # 23
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
- A. Use log messages produced by Cloud SQL.
- B. Use Query Insights for Cloud SQL.
- C. Use Cloud SQL instance monitoring in the Google Cloud Console.
- D. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction
NEW QUESTION # 24
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. Create a PostgreSQL database on-premises as the HA option.
- B. Configure single zone availability for automated backups.
- C. Set up manual backups.
- D. Schedule automated backups.
- E. Enable point-in-time recovery.
Answer: D,E
Explanation:
D) Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.
NEW QUESTION # 25
You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?
- A. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.
- B. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.
- C. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.
- D. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.
Answer: D
Explanation:
"Deny maintenance period. A block of days in which Cloud SQL does not schedule maintenance. Deny maintenance periods can be up to 90 days long. " https://cloud.google.com/sql/docs/mysql/maintenance
NEW QUESTION # 26
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. Ensure that all PostgreSQL tables have a primary key.
- C. Ensure that pglogical is installed on the source PostgreSQL database.
- D. Shut down the database before the Data Migration Service task is started.
- E. Disable all foreign key constraints on the source PostgreSQL database.
Answer: C,E
NEW QUESTION # 27
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, use backup and restore, and specify a recovery timestamp.
- C. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
Answer: D,E
NEW QUESTION # 28
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Enable serializable isolation in the Firebase app.
- B. Deploy a US multi-region Firestore location.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Create a Firestore index on the news story date.
Answer: C
NEW QUESTION # 29
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 SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
- B. Change the Cloud Spanner configuration from multi-region to single region.
- C. Use query parameters to speed up frequently executed queries.
- D. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
Answer: D
Explanation:
To troubleshoot high read latency, you can use SQL statements to analyze the SPANNER_SYS.READ_STATS* tables. These tables contain statistics about read operations in Cloud Spanner, including the number of reads, read latency, and the number of read errors. By analyzing these tables, you can identify the cause of the high read latency and take appropriate action to resolve the issue. Other options, such as using query parameters to speed up frequently executed queries or changing the Cloud Spanner configuration from multi-region to single region, may not be directly related to the issue of high read latency. Similarly, analyzing the SPANNER_SYS.QUERY_STATS* tables, which contain statistics about query operations, may not be relevant to the issue of high read latency.
NEW QUESTION # 30
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Cloud Spanner with default encryption.
- B. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- C. Use Cloud SQL with a customer-managed encryption key (CMEK).
- D. Use Bigtable with default encryption.
Answer: B
Explanation:
Yes default encryption comes with AES-256 but the question states that you need to control where you store the encryption keys. that can be achieved by CMEK.
NEW QUESTION # 31
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 Identity and Access Management (IAM) for Bigtable access control.
- B. Use VPC Service Controls to create a trusted network for the Bigtable service.
- C. Use Google Cloud Armor to add IP addresses to an allowlist.
- D. Use customer-managed encryption keys (CMEK).
Answer: B
Explanation:
"Users can define a security perimeter around Google Cloud resources such as Cloud Storage buckets, Bigtable instances, and BigQuery datasets to constrain data within a VPC and control the flow of data." https://cloud.google.com/vpc-service-controls
NEW QUESTION # 32
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
- A. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
- B. Use linear scaling to implement the Autoscaler-based architecture
- C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- D. Use direct scaling to implement the Autoscaler-based architecture.
Answer: B
Explanation:
Linear scaling is best used with load patterns that change more gradually or have a few large peaks. The method calculates the minimum number of nodes or processing units required to keep utilization below the scaling threshold. The number of nodes or processing units added or removed in each scaling event is not limited to a fixed step amount. https://cloud.google.com/spanner/docs/autoscaling-overview#linear
NEW QUESTION # 33
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. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
- C. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- D. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
Answer: B
NEW QUESTION # 34
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. Back up the database, create an instance with additional vCPUs, and restore the database.
- B. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- C. Issue a gcloud compute instances update command to increase the number of vCPUs.
- D. Update a MySQL database flag to increase the number of vCPUs.
Answer: B
Explanation:
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
NEW QUESTION # 35
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 Spanner.
- B. Use Cloud SQL for MySQL
- C. Use Firestore.
- D. Use Bigtable.
Answer: B
NEW QUESTION # 36
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 Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- B. Use sharded Cloud SQL instances with one or more stores per database instance.
- C. Use a Biglable cluster with autoscaling.
- D. Use Cloud Spanner with a custom autoscaling solution.
Answer: D
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 # 37
Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?
- A. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.
- B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.
- C. Migrate all the databases to Cloud SQL.
- D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.
Answer: A
NEW QUESTION # 38
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. Use Cloud Spanner instead of Cloud SQL.
- B. Increase the storage size for the instance.
- C. Increase the number of CPUs for your instance.
- D. Use many smaller Cloud SQL instances.
Answer: A
NEW QUESTION # 39
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 Firestore.
- B. Migrate the existing database to PostgreSQL running on Compute Engine.
- C. Migrate the existing database to Cloud SQL for PostgreSQL.
- D. Migrate the existing database to Cloud Spanner.
Answer: C
NEW QUESTION # 40
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?
- A. Edit the primary instance to add additional memory.
- B. Edit the primary instance to upgrade to a larger disk, and increase vCPU count.
- C. Identify and optimize slow running queries, or set parallel replication flags.
- D. Stop all running queries, and re-create the replicas.
Answer: B
NEW QUESTION # 41
You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest dat a. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?
- A. Use a Cloud SQL federated query for the Sales Reporting application.
- B. Queue up all the requested reports in PubSub, and execute the reports at night.
- C. Create two separate databases in the instance, and perform dual writes from the Order Management application.
- D. Create a read replica for the Sales Reporting application.
Answer: D
NEW QUESTION # 42
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
- A. roles/cloudsql.client and roles/spanner.databaseReader
- B. roles/cloudsql.editor and roles/spanner.admin
- C. roles/cloudsql.instanceUser and roles/spanner.databaseUser
- D. roles/cloudsql.viewer and roles/spanner.databaseUser
Answer: A
NEW QUESTION # 43
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
- A. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
- B. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
- C. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
- D. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.
Answer: A
NEW QUESTION # 44
You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?
- A. Set up bring your own IP (BYOIP) in your VPC.
- B. Setup a static external IP address in your VPC network.
- C. Set up a Cloud NAT gateway on the Compute Engine VM.
- D. Set up Cloud NAT service.
Answer: C
NEW QUESTION # 45
You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?
- A. Use Identity and Access Management (IAM) authentication.
- B. Use Cloud SQL federated queries.
- C. Use Managed Active Directory authentication.
- D. Use PostgreSQL database's built-in authentication.
Answer: A
Explanation:
https://cloud.google.com/sql/docs/postgres/authentication
NEW QUESTION # 46
......
Google Professional-Cloud-Database-Engineer certification exam is recognized globally as a mark of excellence in the field of cloud-based database management. It is an excellent way for professionals to demonstrate their expertise and commitment to their field, and to enhance their credibility with employers and clients. By earning this certification, professionals can position themselves as leaders in their industry and open up new opportunities for career growth and advancement.
Google Professional-Cloud-Database-Engineer certification is an essential credential for professionals seeking to demonstrate their expertise in designing, developing, and managing cloud-based databases on Google Cloud Platform. Google Cloud Certified - Professional Cloud Database Engineer certification provides candidates with the skills, knowledge, and credibility required to advance their careers in the cloud database industry. If you are interested in becoming a Google Cloud Certified Professional-Cloud-Database-Engineer, start preparing today by reviewing the exam objectives, taking practice exams, and gaining hands-on experience with Google Cloud Platform.
Get instant access of 100% real exam questions with verified answers: https://pass4lead.newpassleader.com/Google/Professional-Cloud-Database-Engineer-exam-preparation-materials.html