최신Google Cloud Certified - Professional Cloud Database Engineer - Professional-Cloud-Database-Engineer무료샘플문제
문제1
Your organization runs a high-volume, low-latency application on Bigtable. You need to reduce costs without compromising performance. What should you do-
Your organization runs a high-volume, low-latency application on Bigtable. You need to reduce costs without compromising performance. What should you do-
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
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?
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
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
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?
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?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command. What should you do?
You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You need to test the high availability of your Cloud SQL instance by performing a failover. You want to use the cloud command. What should you do?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제5
You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. In the event of a complete regional outage, the application will failover to another region. You want to ensure that the Memorystore instance in the new region does not start from an empty cache after failover. What should you do-
You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. In the event of a complete regional outage, the application will failover to another region. You want to ensure that the Memorystore instance in the new region does not start from an empty cache after failover. What should you do-
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. Recently, your application is experiencing sudden spikes in latency when interacting with the Memorystore for Redis instance. Upon checking the logs, you discover a high number of "evicted keys" messages. You want to reduce the occurrences of latency spikes and their impact on the application. What should you do-
You are using Memorystore for Redis to cache frequently accessed data and improve your application's performance. Recently, your application is experiencing sudden spikes in latency when interacting with the Memorystore for Redis instance. Upon checking the logs, you discover a high number of "evicted keys" messages. You want to reduce the occurrences of latency spikes and their impact on the application. What should you do-
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
You have several on-premises Percona Server for MySQL 8.0 instances used for mission-critical applications. The workload is read-heavy with 80%+ reads and each instance has several TBs of data. You want to migrate to Google Cloud with minimal downtime and the fewest changes possible.
What should you do-
You have several on-premises Percona Server for MySQL 8.0 instances used for mission-critical applications. The workload is read-heavy with 80%+ reads and each instance has several TBs of data. You want to migrate to Google Cloud with minimal downtime and the fewest changes possible.
What should you do-
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제8
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?
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?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제9
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?
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?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제10
You are configuring a new application that has access to an existing Cloud Spanner database.
The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?
You are configuring a new application that has access to an existing Cloud Spanner database.
The new application reads from this database to gather statistics for a dashboard. You want to follow Google-recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?
정답: A
설명: (KoreaDumps 회원만 볼 수 있음)
문제11
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?
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?
정답: B
문제12
You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64-GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables. You need to specify the most cost-effective machine size you need when migrating to Cloud SQL for MySQL. What should you do-
You want to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64-GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables. You need to specify the most cost-effective machine size you need when migrating to Cloud SQL for MySQL. What should you do-
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제13
You are a database administrator for a rapidly growing startup running on Google Cloud. As your company expands, the Cloud SQL for PostgreSQL database workload is increasing exponentially. You need to implement a proactive strategy to continuously assess and optimize the cost of your database solution while ensuring it meets performance requirements.
What should you do?
You are a database administrator for a rapidly growing startup running on Google Cloud. As your company expands, the Cloud SQL for PostgreSQL database workload is increasing exponentially. You need to implement a proactive strategy to continuously assess and optimize the cost of your database solution while ensuring it meets performance requirements.
What should you do?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제14
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?
정답: B