[2022年最新] 高合格率なProfessional-Cloud-Database-EngineerテストアンサーかつGoogle Professional-Cloud-Database-EngineerテストPDF
完璧Professional-Cloud-Database-Engineer問題集試験問題と解答でパス保証されます
Google Professional-Cloud-Database-Engineer 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
質問 52
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 the mysqldump utility on the primary database instance to export the backup.
- C. Use Cloud SQL serverless exports.
- D. Create a read replica, and then use the mysqldump utility to export each table.
正解: A
質問 53
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?
- A. Remove inactive user accounts.
- B. Run the Recommender API to identify overprovisioned instances.
- C. Build indexes on heavily accessed tables.
- D. Use Query Insights to identify idle instances.
正解: B
質問 54
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 and Oracle databases to Compute Engine.
- C. Migrate applications to Cloud SQL.
- D. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).
正解: A
質問 55
You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?
- A. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
- B. Create one regional Cloud SQL instance with a read replica in another region.
- C. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- D. Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.
正解: D
質問 56
You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?
- A. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.
- B. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.
- C. Use Firestore and ensure that the PersistenceEnabled option is set to true.
- D. Use Memorystore for Memcached.
正解: A
質問 57
You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?
- A. Set up different organizations for each database type, and apply policy constraints at the organization level.
- B. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.
- C. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.
- D. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.
正解: A
質問 58
You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?
- A. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance. - B. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance. - C. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance. - D. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance.
正解: C
質問 59
You are migrating an on-premises application to Google Cloud. The application requires a high availability (HA) PostgreSQL database to support business-critical functions. Your company's disaster recovery strategy requires a recovery time objective (RTO) and recovery point objective (RPO) within 30 minutes of failure. You plan to use a Google Cloud managed service. What should you do to maximize uptime for your application?
- A. Deploy Cloud SQL for PostgreSQL in a regional configuration. Create a read replica in a different zone in the same region and a read replica in another region for disaster recovery.
- B. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Create a cross-region read replica, and promote the read replica as the primary node for disaster recovery.
- C. Migrate the PostgreSQL database to multi-regional Cloud Spanner so that a single region outage will not affect your application. Update the schema to support Cloud Spanner data types, and refactor the application.
- D. Deploy Cloud SQL for PostgreSQL in a regional configuration with HA enabled. Take periodic backups, and use this backup to restore to a new Cloud SQL for PostgreSQL instance in another region during a disaster recovery event.
正解: B
質問 60
You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?
- A. Specify an authorized network with the CIDR range of the VM.
- B. Disable and remove the internal IP address assignment.
- C. Disable and remove the external IP address assignment.
- D. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.
正解: D
質問 61
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
- A. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- B. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- C. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- D. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
正解: D
質問 62
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. Setup a static external IP address in your VPC network.
- B. Set up bring your own IP (BYOIP) in your VPC.
- C. Set up a Cloud NAT gateway on the Compute Engine VM.
- D. Set up Cloud NAT service.
正解: C
質問 63
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 insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- B. If the corruption is significant, use import and export.
- C. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
- D. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- E. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.
正解: A,C
質問 64
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?
- A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- B. Use the default configuration for the automated backups location.
- C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- D. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
正解: D
質問 65
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. Review application logs to identify database calls.
- B. White a Logs Explorer query to identify database queries with high execution times.
- C. Use the Query Insights dashboard to identify high execution times.
- D. View Cloud SQL operations to view historical query information.
正解: C
質問 66
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
- A. Use replication from an external server to migrate the databases to Cloud SQL.
- B. Use a read replica to migrate the databases to Cloud SQL.
- C. Use an external read replica to migrate the databases to Cloud SQL.
- D. Use Database Migration Service to migrate the databases to Cloud SQL.
- E. Use a cross-region read replica to migrate the databases to Cloud SQL.
正解: A,B
質問 67
You are choosing a database backend for a new application. The application will ingest data points from IoT sensors. You need to ensure that the application can scale up to millions of requests per second with sub-10ms latency and store up to 100 TB of history. What should you do?
- A. Use Firestore, and rely on automatic serverless scaling.
- B. Use Memorystore for Memcached, and add nodes as necessary to achieve the required throughput.
- C. Use Bigtable, and add nodes as necessary to achieve the required throughput.
- D. Use Cloud SQL with read replicas for throughput.
正解: B
質問 68
......
Professional-Cloud-Database-Engineer試験問題高合格率なProfessional-Cloud-Database-Engineer問題集PDF：https://jp.fast2test.com/Professional-Cloud-Database-Engineer-premium-file.html
Professional-Cloud-Database-EngineerのPDF問題集最近更新された問題：https://drive.google.com/open?id=1dQZfnD40sit9swq1sC90QSyDHaQtrcHe