Get ready to pass the Professional-Cloud-Database-Engineer Exam right now using our Google Cloud Certified Exam Package

A fully updated 2024 Professional-Cloud-Database-Engineer Exam Dumps exam guide from training expert TestSimulate

NEW QUESTION # 72
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

• A. Create a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.
• B. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
• C. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
• D. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

Answer: B

Explanation:
https://cloud.google.com/sql/docs/mysql/import-export#serverless

NEW QUESTION # 73
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. 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.
• B. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
• C. Use Memorystore to handle your low-latency requirements and for real-time analytics.
• D. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

Answer: A

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 with Google-managed encryption keys.
• B. Create the database persistent disk with customer-managed encryption keys.
• C. Create the database persistent disk 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
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

• A. Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east-b.
  Create a read replica in us-east1-c.
• B. Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-central1-b.
  Create a read replica in us-east1-b.
• C. Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-west1-b.
  Create a read replica in us-east1-c.
• D. Provision a Cloud SQL for MySQL instance in us-central1-a.
  Create a multiple-zone instance in us-east1-b.
  Create a read replica in us-central1-b.

Answer: B

NEW QUESTION # 76
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 Cloud SQL for data storage.
• C. Use Bigtable for data storage.
• D. Use Memorystore 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 # 77
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

• A. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
• B. Ask existing users to set their Google password to match their corporate password.
• C. Use workload identity federation to impersonate a service account.
• D. Use Google Workspace Password Sync to replicate passwords into Google Cloud.

Answer: A

NEW QUESTION # 78
Your team uses thousands of connected IoT devices to collect device maintenance data for your oil and gas customers in real time. You want to design inspection routines, device repair, and replacement schedules based on insights gathered from the data produced by these devices. You need a managed solution that is highly scalable, supports a multi-cloud strategy, and offers low latency for these IoT devices. What should you do?

• A. Use Cloud Spanner with Data Studio.
• B. Use Bigtable with Looker.
• C. Use Firestore with Looker.
• D. Use MongoD8 Atlas with Charts.

Answer: D

NEW QUESTION # 79
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 solid-state drives (SSD).
• B. Recommend mixed storage types.
• C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
• D. Recommend hard disk drives (HDD).

Answer: A

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 # 80
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 HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
• B. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
• C. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
• D. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.

Answer: D

Explanation:
https://severalnines.com/blog/how-achieve-postgresql-high-availability-pgbouncer/
https://cloud.google.com/blog/products/databases/using-haproxy-to-scale-read-only-workloads-on-cloud-sql-for-postgresql This answer is correct because PgBouncer is a lightweight connection pooler for PostgreSQL that can help you distribute read requests between the Cloud SQL primary and read replica instances1. PgBouncer can also improve performance and scalability by reducing the overhead of creating new connections and reusing existing ones1. You can install PgBouncer on a Compute Engine instance and configure it to connect to the Cloud SQL instances using private IP addresses or the Cloud SQL Auth proxy2.

NEW QUESTION # 81
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 database patches of Cloud SQI 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 versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
• D. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

Answer: A

NEW QUESTION # 82
Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

• A. Apply a database data management pattern.
• B. Apply a table data management pattern.
• C. Apply a schema data management pattern.
• D. Apply an instance data management pattern.

Answer: D

NEW QUESTION # 83
You want to migrate your on-premises PostgreSQL database to Compute Engine. You need to migrate this database with the minimum downtime possible. What should you do?

• A. Use Database Migration Service to migrate your database.
• B. Create a hot standby on Compute Engine, and use PgBouncer to switch over the connections.
• C. Perform a full backup of your on-premises PostgreSQL, and then, in the migration window, perform an incremental backup.
• D. Create a read replica on Cloud SQL, and then promote it to a read/write standalone instance.

Answer: D

NEW QUESTION # 84
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. Compress the data using a different compression algorithm.
• B. Manually or automatically increase the storage capacity.
• C. Create another schema to load older data.
• D. Normalize the database to the third normal form.

Answer: A

NEW QUESTION # 85
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

• A. C.Deploy the database using Bigtable.
• B. Deploy the database using Cloud SQL.
• C. Use BigQuery, and load data in batches.
• D. Deploy the database using Cloud Spanner.

Answer: A

Explanation:
Bigtable is a scalable, fully managed, and high-performance NoSQL database service that can handle semi-structured data and support real-time monitoring and analysis. Cloud SQL is a relational database service that does not support semi-structured dat a. BigQuery is a data warehouse service that is optimized for batch processing and analytics, not real-time monitoring. Cloud Spanner is a relational database service that supports semi-structured data with JSON data type, but it is more expensive and complex than Bigtable for this use case.

NEW QUESTION # 86
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. Use interleaving to co-locate parent and child rows.
• B. Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.
• C. Manually scale down the number of nodes after the peak period has passed.
• D. Use granular instance sizing in Cloud Spanner and Autoscaler.

Answer: B

NEW QUESTION # 87
You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability. What should you do?

• A. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.
• B. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.
• C. Configure the primary, standby, and read replica instances in zone A, all in the same region.
• D. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

Answer: A

NEW QUESTION # 88
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?

• A. Automate instance creation by writing a Dataflow job.
• B. Create clones from a template Cloud SQL instance.
• C. Automate instance creation by setting up Terraform scripts.
• D. Create the instances using the Google Cloud Console UI.

Answer: C

NEW QUESTION # 89
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?

• A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
• B. Start the original primary instance and resume replication.
• C. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
• D. Verify that the new replica is created automatically.

Answer: C

NEW QUESTION # 90
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?

• A. Bring DB-1 back online.
• B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
• C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
• D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

Answer: D

Explanation:
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback

NEW QUESTION # 91
......

Master 2024 Latest The Questions Google Cloud Certified and Pass Professional-Cloud-Database-Engineer Real Exam!: https://www.testsimulate.com/Professional-Cloud-Database-Engineer-study-materials.html