更新された2023年06月テストエンジンに練習Professional-Cloud-Database-Engineerテスト問題
Professional-Cloud-Database-Engineerリアル試験問題テストエンジン問題集トレーニングには120問あります
質問 # 16
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?
- A. Use Cloud SQL instance monitoring in the Google Cloud Console.
- B. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- C. Use Query Insights for Cloud SQL.
- D. Use log messages produced by Cloud SQL.
正解：B
質問 # 17
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. Create a new service account, and grant it the spanner.databases.select permission.
- B. Create a new service account, and grant it the Cloud Spanner Database Admin role.
- C. Create a new service account, and grant it the Cloud Spanner Database Reader role.
- D. Reuse the existing service account that populates this database.
正解：B
質問 # 18
You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google-recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible. What should you do?
- A. For the application server, set up a service account.
- B. For each application code, set up a dedicated user account.
- C. For the application server, set up a common shared user account.
- D. For each application code, set up a common shared user account.
正解：B
質問 # 19
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 SQL Server.
- B. Migrate to Cloud SQL for PostgreSQL.
- C. Migrate to Compute Engine.
- D. Migrate to Google Kubernetes Engine (GKE).
正解：B
質問 # 20
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. Create a PostgreSQL database on-premises as the HA option.
- B. Schedule automated backups.
- C. Enable point-in-time recovery.
- D. Set up manual backups.
- E. Configure single zone availability for automated backups.
正解：A、C
質問 # 21
Your organization is running a critical production database on a virtual machine (VM) on Compute Engine. The VM has an ext4-formatted persistent disk for data files. The database will soon run out of storage space. You need to implement a solution that avoids downtime. What should you do?
- A. In the Google Cloud Console, increase the size of the persistent disk, and use the fdisk command to verify that the new space is ready to use
- B. In the Google Cloud Console, increase the size of the persistent disk, and use the resize2fs command to extend the disk.
- C. In the Google Cloud Console, create a snapshot of the persistent disk, restore the snapshot to a new larger disk, unmount the old disk, mount the new disk, and restart the database service.
- D. In the Google Cloud Console, create a new persistent disk attached to the VM, and configure the database service to move the files to the new disk.
正解：D
質問 # 22
You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?
- A. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a - B. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b - C. Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b - D. Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b
正解：B
質問 # 23
You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?
- A. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- B. Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.
- C. Configure your Cloud SQL instance with high availability enabled.
- D. Create your database with one primary node and one read replica in the region.
正解：B
質問 # 24
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- B. Move the physical database servers from on-premises to Google Cloud.
- C. Use a change data capture (CDC) migration strategy.
- D. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- E. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
正解：A、C
質問 # 25
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?
- A. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- B. Use customer-managed encryption keys with Cloud SQL.
- C. Use Cloud SQL Auth proxy.
- D. Connect to Cloud SQL using a connection that has SSL encryption.
正解：D
質問 # 26
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-west1-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-east1-b.
Create a read replica in us-central1-b. - C. 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. - D. 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.
正解：C
質問 # 27
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in text format.
- B. Use Dataflow to run the export in Avro format.
- C. Use Cloud Functions to run the export in Avro format.
- D. Use Cloud Functions to run the export in text format.
正解：B
質問 # 28
During an internal audit, you realized that one of your Cloud SQL for MySQL instances does not have high availability (HA) enabled. You want to follow Google-recommended practices to enable HA on your existing instance. What should you do?
- A. Shut down your existing Cloud SQL for MySQL instance, and enable HA.
- B. Create a new Cloud SQL for MySQL instance, enable HA, and use Cloud Data Fusion to migrate your data.
- C. Use the gcloud instances patch command to update your existing Cloud SQL for MySQL instance.
- D. Create a new Cloud SQL for MySQL instance, enable HA, and use the export and import option to migrate your data.
正解：D
質問 # 29
You have a large Cloud SQL for PostgreSQL instance. The database instance is not mission-critical, and you want to minimize operational costs. What should you do to lower the cost of backups in this environment?
- A. Select a different region to store your backups.
- B. Reduce the number of automated backups that are retained to two (2).
- C. Change the storage tier of the automated backups from solid-state drive (SSD) to hard disk drive (HDD).
- D. Set the automated backups to occur every other day to lower the frequency of backups.
正解：D
質問 # 30
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. Update a MySQL database flag to increase the number of vCPUs.
- B. Issue a gcloud compute instances update command to increase the number of vCPUs.
- C. Back up the database, create an instance with additional vCPUs, and restore the database.
- D. Issue a gcloud sql instances patch command to increase the number of vCPUs.
正解：D
質問 # 31
Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?
- A. Set up all read replicas in the same region as the primary instance with synchronous replication.
- B. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.
- C. Set up all read replicas in a different region using asynchronous replication.
- D. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.
正解：D
質問 # 32
You are designing a new gaming application that uses a highly transactional relational database to store player authentication and inventory data in Google Cloud. You want to launch the game in multiple regions. What should you do?
- A. Use BigQuery to deploy the database
- B. Use Cloud SQL with a regional read replica to deploy the database.
- C. Use Bigtable with clusters in multiple regions to deploy the database
- D. Use Cloud Spanner to deploy the database.
正解：A
質問 # 33
Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?
- A. Use Cloud Spanner.
- B. Use Bigtable.
- C. Use Cloud SQL for MySQL
- D. Use Firestore.
正解：C
質問 # 34
Your organization is running a MySQL workload in Cloud SQL. Suddenly you see a degradation in database performance. You need to identify the root cause of the performance degradation. What should you do?
- A. Use Error Reporting to count, analyze, and aggregate the data.
- B. Use Logs Explorer to analyze log data.
- C. Use Cloud Debugger to inspect the state of an application.
- D. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.
正解：D
質問 # 35
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. Set up bring your own IP (BYOIP) in your VPC.
- B. Setup a static external IP address in your VPC network.
- C. Set up Cloud NAT service.
- D. Set up a Cloud NAT gateway on the Compute Engine VM.
正解：D
質問 # 36
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?
- A. Use Cloud Spanner.
- B. Use Cloud SQL with an external (public) IP address.
- C. Use an in-app embedded database.
- D. Use Firestore.
正解：B
質問 # 37
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?
- A. Use Cloud SQL federated queries.
- B. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
- C. Use Database Migration Service to replicate tables into BigQuery.
- D. Develop a custom data replication service to send data into BigQuery.
正解：B
質問 # 38
......
Google Professional-Cloud-Database-Engineer 試験は、複数選択肢とシナリオに基づく質問から構成され、GCP データベースサービスについての徹底的な理解が必要です。この試験は、実世界のシナリオで GCP データベースを設計、開発、管理する能力をテストするように設計されています。試験はオンラインで実施され、受験者には2時間の時間制限が与えられます。試験の合格スコアは70％であり、認定は2年間有効です。
Professional-Cloud-Database-Engineer実際の問題解答PDFには100%カバー率リアル試験問題：https://www.passtest.jp/Google/Professional-Cloud-Database-Engineer-shiken.html
Professional-Cloud-Database-Engineer試験問題解答：https://drive.google.com/open?id=1eAyWkn6hcJyNyP1O5CrA1X6E5VlXfoTk