[Jan-2023] Professional-Cloud-Database-Engineer Dumps are Available for Instant Access from ExamPrepAway
Study resources for the Valid Professional-Cloud-Database-Engineer Braindumps!
NEW QUESTION 37
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 a Biglable cluster with autoscaling.
- C. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
- D. Use Cloud Spanner with a custom autoscaling solution.
Answer: A
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. Take no backups, and turn off transaction log retention.
- B. Turn on automated backup, and turn on transaction log retention.
- C. Take one manual backup per day, and turn off transaction log retention.
- D. Turn on automated backup, and turn off transaction log retention.
Answer: C
NEW QUESTION 39
You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?
- A. Use the Query Insights dashboard to identify high execution times.
- B. View Cloud SQL operations to view historical query information.
- C. Review application logs to identify database calls.
- D. White a Logs Explorer query to identify database queries with high execution times.
Answer: A
NEW QUESTION 40
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. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
- B. Ask existing users to set their Google password to match their corporate password.
- C. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- D. Use workload identity federation to impersonate a service account.
Answer: C
NEW QUESTION 41
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
- A. Migrate to Cloud SQL for PostgreSQL.
- B. Migrate to Compute Engine.
- C. Migrate to Cloud SQL for SQL Server.
- D. Migrate to Google Kubernetes Engine (GKE).
Answer: A
NEW QUESTION 42
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. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- B. 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.
- C. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
- D. Use Memorystore to handle your low-latency requirements and for real-time analytics.
Answer: B
NEW QUESTION 43
You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?
- A. Use Data Migration Service.
- B. Use external server replication.
- C. Use the mysqldump utility and binary logs.
- D. Use Cloud SQL for MySQL external replica.
Answer: A
NEW QUESTION 44
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. Use Key Visualizer for Bigtable.
- B. Add more nodes to the Bigtable cluster.
- C. Isolate the data analysts and operations user groups to use different Bigtable instances.
- D. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
Answer: D
NEW QUESTION 45
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. Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.
- B. Check whether your service account has cloudsql.instances.connect permission.
- C. Enable the Cloud SQL Admin API.
- D. Ensure that you are using an external (public) IP address interface.
Answer: A
NEW QUESTION 46
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 two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- D. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
Answer: B
NEW QUESTION 47
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 Bigtable with Looker.
- B. Use Firestore with Looker.
- C. Use MongoD8 Atlas with Charts.
- D. Use Cloud Spanner with Data Studio.
Answer: C
NEW QUESTION 48
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. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
- B. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- C. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- D. Edit the instance to change the storage type from HDD to SSD.
Answer: A
NEW QUESTION 49
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 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
- B. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
- C. 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.
- D. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
Answer: D
NEW QUESTION 50
Your company is migrating the existing infrastructure for a highly transactional application to Google Cloud. You have several databases in a MySQL database instance and need to decide how to transfer the data to Cloud SQL. You need to minimize the downtime for the migration of your 500 GB instance. What should you do?
- A. Create migration job using Database Migration Service.
Set the migration job type to One-time, and perform this migration during a maintenance window.
Stop all write workloads to the source database and initiate the dump. Wait for the dump to be loaded into the Cloud SQL destination database and the destination database to be promoted to the primary database.
Update your application connections to the new instance. - B. Use the mysqldump utility to manually initiate a backup of MySQL during the application maintenance window.
Move the files to Cloud Storage, and import each database into your Cloud SQL instance.
Continue to dump each database until all the databases are migrated.
Update your application connections to the new instance. - C. Create a Cloud SQL for MySQL instance for your databases, and configure Datastream to stream your database changes to Cloud SQL.
Select the Backfill historical data check box on your stream configuration to initiate Datastream to backfill any data that is out of sync between the source and destination.
Delete your stream when all changes are moved to Cloud SQL for MySQL, and update your application to use the new instance. - D. Create migration job using Database Migration Service.
Set the migration job type to Continuous, and allow the databases to complete the full dump phase and start sending data in change data capture (CDC) mode.
Wait for the replication delay to minimize, initiate a promotion of the new Cloud SQL instance, and wait for the migration job to complete.
Update your application connections to the new instance.
Answer: A
NEW QUESTION 51
You have an application that sends banking events to Bigtable cluster-a in us-east. You decide to add cluster-b in us-central1. Cluster-a replicates data to cluster-b. You need to ensure that Bigtable continues to accept read and write requests if one of the clusters becomes unavailable and that requests are routed automatically to the other cluster. What deployment strategy should you use?
- A. Create a custom app profile with multi-cluster routing.
- B. Use the default app profile with single-cluster routing.
- C. Use the default app profile with multi-cluster routing.
- D. Create a custom app profile with single-cluster routing.
Answer: B
NEW QUESTION 52
You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?
- A. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.
- B. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
- C. Set your production instance's maintenance window to non-business hours.
- D. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
Answer: A
NEW QUESTION 53
......
Google Professional-Cloud-Database-Engineer Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
| Topic 12 |
|
Updated Professional-Cloud-Database-Engineer Tests Engine pdf - All Free Dumps Guaranteed: https://www.examprepaway.com/Google/braindumps.Professional-Cloud-Database-Engineer.ete.file.html
Latest Google Cloud Certified Professional-Cloud-Database-Engineer Actual Free Exam Questions: https://drive.google.com/open?id=1oVOiyjXLFZHwz-As_d7iR4cBZDkVPPP2