Free Professional-Cloud-Database-Engineer Exam Files Downloaded Instantly 100% Dumps & Practice Exam
Free Exam Updates Professional-Cloud-Database-Engineer dumps with test Engine Practice
NEW QUESTION # 66
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- B. Migrate applications to Cloud SQL.
- C. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- D. Migrate applications and Oracle databases to Compute Engine.
Answer: A
NEW QUESTION # 67
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. Export the data from the existing database, and load the data into a new Cloud SQL database.
- C. Use Database Migration Service to complete the migration.
- D. Use Datastream to complete the migration.
Answer: C
Explanation:
https://www.cloudskillsboost.google/focuses/22792?parent=catalog
NEW QUESTION # 68
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 Google Cloud Armor to add IP addresses to an allowlist.
- B. Use customer-managed encryption keys (CMEK).
- C. Use Identity and Access Management (IAM) for Bigtable access control.
- D. Use VPC Service Controls to create a trusted network for the Bigtable service.
Answer: D
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 # 69
Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?
- A. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).
- B. Migrate applications to Cloud SQL.
- C. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
- D. Migrate applications and Oracle databases to Compute Engine.
Answer: A
Explanation:
https://cloud.google.com/blog/products/databases/migrate-databases-to-google-cloud-vmware-engine-gcve
NEW QUESTION # 70
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 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.
- B. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.
- C. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.
- D. 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.
Answer: B
Explanation:
https://cloud.google.com/sql/docs/mysql/maintenance?hl=fr
NEW QUESTION # 71
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. Shard data required by the application into multiple instances.
- B. Increase the number of processing units.
- C. Decrease the number of processing units.
- D. Modify the database schema, and add additional indexes.
Answer: B
Explanation:
In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU%20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20you%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance. Refer : https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema
NEW QUESTION # 72
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 high availability (HA) Cloud SQL with multiple zones.
- B. Use zonal Cloud SQL without high availability (HA).
- C. Use Cloud SQL with cross-region replicas.
- D. Use Cloud Spanner in a regional configuration.
Answer: C
NEW QUESTION # 73
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
- A. Use Cloud Spanner.
- B. Use an in-app embedded database.
- C. Use Cloud SQL with an external (public) IP address.
- D. Use Firestore.
Answer: D
Explanation:
https://firebase.google.com/docs/firestore
NEW QUESTION # 74
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database persistent disk with customer-managed encryption keys.
- B. Create the database persistent disk with Google-managed encryption keys.
- C. Create the database with Google-managed encryption keys.
- D. Create the database with customer-managed encryption keys.
Answer: D
Explanation:
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance
NEW QUESTION # 75
You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?
- A. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
- B. Configure Firestore, and modify your application to offload queries.
- C. Configure Memorystore, and modify your application to offload queries.
- D. Configure Bigtable, and modify your application to offload queries.
Answer: C
NEW QUESTION # 76
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. Set up manual backups.
- C. Enable point-in-time recovery.
- D. Schedule automated backups.
- E. Configure single zone availability for automated backups.
Answer: A,C
NEW QUESTION # 77
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- B. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- C. Move the physical database servers from on-premises to Google Cloud.
- D. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- E. Use a change data capture (CDC) migration strategy.
Answer: D,E
Explanation:
https://cloud.google.com/architecture/migration-to-google-cloud-transferring-your-large-datasets#online_versus_offline_transfer
NEW QUESTION # 78
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 the Cloud SQL instance monitor for CPU utilization metrics.
- B. Watch the Cloud SQL recommenders for overprovisioned instances.
- C. Watch Cloud Trace for application requests that are failing.
- D. Watch Query Insights for long running queries.
Answer: D
NEW QUESTION # 79
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 granular instance sizing in Cloud Spanner and Autoscaler.
- D. Use interleaving to co-locate parent and child rows.
Answer: C
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 # 80
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. Ensure that pglogical is installed on the source PostgreSQL database.
- B. Drop or disable all users except database administration users.
- C. Ensure that all PostgreSQL tables have a primary key.
- 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: A,E
NEW QUESTION # 81
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
- A. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- B. Use Cloud SQL serverless exports.
- C. Create a read replica, and then use the mysqldump utility to export each table.
- D. Use the mysqldump utility on the primary database instance to export the backup.
Answer: B
Explanation:
https://cloud.google.com/blog/products/databases/introducing-cloud-sql-serverless-exports
NEW QUESTION # 82
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 Cloud Spanner.
- B. Use BigQuery.
- C. Use Firestore.
- D. Use Bigtable
Answer: D
Explanation:
Financial data, such as transaction histories, stock prices, and currency exchange rates.
https://cloud.google.com/bigtable/docs/overview#what-its-good-for
With SSD:
Reads - up to 10,000 rows per second
Writes - up to 10,000 rows per second
Scans - up to 220 MB/s
https://cloud.google.com/bigtable/docs/performance#typical-workloads
NEW QUESTION # 83
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
- A. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- B. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
- C. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
- D. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
Answer: C
NEW QUESTION # 84
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: C
Explanation:
if you plan to store extensive historical data for a large number of remote-sensing devices and then use the data to generate daily reports, the cost savings for HDD storage might justify the performance tradeoff. On the other hand, if you plan to use the data to display a real-time dashboard, it probably would not make sense to use HDD storage-reads would be much more frequent in this case, and reads that are not scans are much slower with HDD storage.
NEW QUESTION # 85
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 a different region using asynchronous replication.
- B. 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.
- C. Set up all read replicas in the same region as the primary instance with synchronous replication.
- D. 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.
Answer: B
Explanation:
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
NEW QUESTION # 86
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For the application server, set up a common shared user account.
- B. For each application code, set up a common shared user account.
- C. For the application server, set up a service account.
- D. For each application code, set up a dedicated user account.
Answer: D
NEW QUESTION # 87
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 a Biglable cluster with autoscaling.
- D. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
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 # 88
......
Provide Valid Dumps To Help You Prepare For Google Cloud Certified - Professional Cloud Database Engineer Exam: https://www.testkingit.com/Google/latest-Professional-Cloud-Database-Engineer-exam-dumps.html
Updated Verified Professional-Cloud-Database-Engineer dumps Q&As - 100% Pass Guaranteed: https://drive.google.com/open?id=1gI826u7-cLB6xmkeY6kzX7j3fIkRva3R