無料Google Professional-Cloud-Database-Engineerプレミアム試験エンジンPDFをダウンロード 更新された134問があります
検証済みProfessional-Cloud-Database-Engineerリアル試験問題集PDF豪華お試しセット
Google Professional-Cloud-Database-Engineer試験は、Google Cloud Platform（GCP）データベースの設計、開発、および管理に専門知識を持つプロフェッショナルに提供される認定です。この認定は、データベースアーキテクチャ、データモデリング、およびGCPサービスを使用したデータ管理について深い理解を持つ個人を対象としています。この試験は、候補者のGCPデータベースを設計、開発、および管理する能力、およびCloud SQL、Cloud Spanner、およびCloud BigtableなどのGCPデータベースサービスに関する知識をテストします。
質問 # 53
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. Schedule automated backups.
- B. Enable point-in-time recovery.
- C. Configure single zone availability for automated backups.
- D. Create a PostgreSQL database on-premises as the HA option.
- E. Set up manual backups.
正解：A、B
解説：
D) Enable point-in-time recovery - This feature allows you to restore your database to a specific point in time. It helps protect against data loss and can be used in the event of data corruption or accidental data deletion. E. Schedule automated backups - Automated backups allow you to take regular backups of your database without manual intervention. You can use these backups to restore your database in the event of data loss or corruption.
質問 # 54
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
- B. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- C. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
- D. Create additional read replicas, and partition your analytics users to use different read replicas.
- E. Create secondary indexes on the replica.
正解：B、D
質問 # 55
Your company wants to migrate its MySQL, PostgreSQL, and Microsoft SQL Server on-premises databases to Google Cloud. You need a solution that provides near-zero downtime, requires no application changes, and supports change data capture (CDC). What should you do?
- A. Create a database on Google Cloud, and use Dataflow for database migration.
- B. Use the native export and import functionality of the source database.
- C. Create a database on Google Cloud, and use database links to perform the migration.
- D. Use Database Migration Service.
正解：C
質問 # 56
You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS. You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?
- A. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- B. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.
- C. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).
- D. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
正解：B
質問 # 57
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 single-cluster routing.
- B. Create a custom app profile with multi-cluster routing.
- C. Use the default app profile with single-cluster routing.
- D. Use the default app profile with multi-cluster routing.
正解：B
解説：
https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile The question states that a single cluster existed first, then a second cluster was added. Google's documentation states, "if you created the instance with one cluster, the default app profile uses single-cluster routing. This ensures that adding additional clusters later does not change the behavior of your existing applications". Simply adding a second cluster does not change the default profile from single-cluster routing to multi-cluster routing. Since you need multi-cluster routing, you're going to need a custom app profile. So C is correct. https://cloud.google.com/bigtable/docs/app-profiles#default-app-profile
質問 # 58
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, use backup and restore, and specify a recovery timestamp.
- B. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
- C. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
- D. If the corruption is significant, use import and export.
- E. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
正解：B、E
質問 # 59
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?
- A. Use gcloud sql instances failover <ReplicaInstanceName>.
- B. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
- C. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
- D. Use gcloud sql instances failover <PrimaryInstanceName>.
正解：C
質問 # 60
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. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- C. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
- D. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
正解：B
質問 # 61
You are choosing a new database backend for an existing application. The current database is running PostgreSQL on an on-premises VM and is managed by a database administrator and operations team. The application data is relational and has light traffic. You want to minimize costs and the migration effort for this application. What should you do?
- A. Migrate the existing database to PostgreSQL running on Compute Engine.
- B. Migrate the existing database to Cloud SQL for PostgreSQL.
- C. Migrate the existing database to Cloud Spanner.
- D. Migrate the existing database to Firestore.
正解：B
質問 # 62
You are developing a new application on a VM that is on your corporate network. The application will use Java Database Connectivity (JDBC) to connect to Cloud SQL for PostgreSQL. Your Cloud SQL instance is configured with IP address 192.168.3.48, and SSL is disabled. You want to ensure that your application can access your database instance without requiring configuration changes to your database. What should you do?
- A. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- B. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.
- C. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the internal (private) IP address of your Cloud SQL instance.
- D. Define a connection string using Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
正解：C
解説：
The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md
質問 # 63
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. Schedule automated backups.
- B. Enable point-in-time recovery.
- C. Configure single zone availability for automated backups.
- D. Create a PostgreSQL database on-premises as the HA option.
- E. Set up manual backups.
正解：B、D
質問 # 64
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Back up the database, create an instance with additional vCPUs, and restore the database.
- B. Issue a gcloud sql instances patch command to increase the number of vCPUs.
- C. Update a MySQL database flag to increase the number of vCPUs.
- D. Issue a gcloud compute instances update command to increase the number of vCPUs.
正解：B
解説：
https://cloud.google.com/sdk/gcloud/reference/sql/instances/patch
質問 # 65
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
質問 # 66
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?
- A. Set up Serverless VPC Access.
- B. Set up Traffic Director.
- C. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
- D. Set up Private Service Connect.
正解：C
解説：
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
質問 # 67
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 zonal Cloud SQL without high availability (HA).
- B. Use Cloud SQL with cross-region replicas.
- C. Use high availability (HA) Cloud SQL with multiple zones.
- D. Use Cloud Spanner in a regional configuration.
正解：B
質問 # 68
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 two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- 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 zones with a standby instance in another region.
- D. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
正解：C
質問 # 69
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?
- A. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
- B. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
- C. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.
- D. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
正解：D
質問 # 70
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. Enable the Cloud SQL Admin API.
- C. Check whether your service account has cloudsql.instances.connect permission.
- D. Ensure that you are using an external (public) IP address interface.
正解：B
解説：
https://cloud.google.com/sql/docs/mysql/connect-auth-proxy#troubleshooting C because in docs it says "Make sure to enable the Cloud SQL Admin API. If it is not, you see output like Error 403: Access Not Configured in your Cloud SQL
質問 # 71
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 BigQuery.
- B. Use Cloud Spanner.
- C. Use Firestore.
- D. Use Bigtable
正解：A
質問 # 72
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. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).
- B. Edit the instance to change the storage type from HDD to SSD.
- C. Create a read replica of the instance with SSDs, and perform a failover to the new instance
- D. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.
正解：D
質問 # 73
You are starting a large CSV import into a Cloud SQL for MySQL instance that has many open connections. You checked memory and CPU usage, and sufficient resources are available. You want to follow Google-recommended practices to ensure that the import will not time out. What should you do?
- A. Increase the number of CPUs for the instance to ensure that it can handle the additional import operation.
- B. Increase the amount of memory allocated to your instance.
- C. Ensure that the service account has the Storage Admin role.
- D. Close idle connections or restart the instance before beginning the import operation.
正解：C
質問 # 74
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
- A. Use Bigtable with multi-region clusters.
- B. Use Cloud Spanner with multi-region configuration.
- C. Use Cloud SQL for PostgreSQL with cross-region replicas.
- D. Use Memorystore for Redis with multi-zones within a region.
正解：C
質問 # 75
You are responsible for designing a new database for an airline ticketing application in Google Cloud. This application must be able to:
Work with transactions and offer strong consistency.
Work with structured and semi-structured (JSON) data.
Scale transparently to multiple regions globally as the operation grows.
You need a Google Cloud database that meets all the requirements of the application. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Firestore in Datastore mode.
- C. Use a Bigtable instance with clusters in multiple regions.
- D. Use Cloud SQL for PostgreSQL with both cross-region read replicas.
正解：D
質問 # 76
......
あなたを合格させるGoogle試験にProfessional-Cloud-Database-Engineer試験問題集：https://jp.fast2test.com/Professional-Cloud-Database-Engineer-premium-file.html
Professional-Cloud-Database-Engineer問題集PDF最新 [2024年最新] 究極の学習ガイド：https://drive.google.com/open?id=1EZ6bFdxx24M0URMtz3THQpi0is3U-m7O