最新2024年08月10日リアルなProfessional-Cloud-Database-Engineer試験問題集解答で有効なProfessional-Cloud-Database-Engineer問題集PDF
Google Professional-Cloud-Database-Engineer試験問題集でPDF問題とテストエンジン
Google Professional-Cloud-Database-Enginer認定試験は、Google Cloudプラットフォームでデータベースの管理と設計を担当する専門家のスキルと知識をテストするように設計されています。この認定は、Google Cloud Technologyの使用に関する専門知識を実証した個人を認識しているGoogle Cloud認定プログラムの一部です。
質問 # 79
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. Set your production instance's maintenance window to non-business hours.
- C. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.
- D. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.
正解：B
質問 # 80
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use highly available Cloud SQL with multiple zones.
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a regional configuration.
- D. Use Cloud Spanner in a multi-region configuration.
正解：C
質問 # 81
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. Develop a custom data replication service to send data into BigQuery.
- B. Use Database Migration Service to replicate tables into BigQuery.
- C. Use Cloud SQL federated queries.
- D. Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.
正解：D
解説：
"Datastream is a serverless and easy-to-use Change Data Capture (CDC) and replication service that allows you to synchronize data across heterogeneous databases, storage systems, and applications reliably and with minimal latency. Datastream supports change data streaming from Oracle and MySQL databases to Google Cloud Storage (GCS). The service offers streamlined integration with Dataflow templates to power up to date materialized views in BigQuery for analytics, replicate their databases into Cloud SQL or Cloud Spanner for database synchronization, or leverage the event stream directly from GCS to realize event-driven architectures."
質問 # 82
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
- B. Verify that the new replica is created automatically.
- C. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- D. Start the original primary instance and resume replication.
正解：B
解説：
Recovery Process: Once Zone-B becomes available again, Cloud SQL will initiate the recovery process for the impacted read replica. The recovery process involves the following steps: 1. Synchronization: Cloud SQL will compare the data in the recovered read replica with the primary instance in Zone-A. If there is any data divergence due to the unavailability period, Cloud SQL will synchronize the read replica with the primary instance to ensure data consistency. 2. Catch-up Replication: The recovered read replica will start catching up on the changes that occurred on the primary instance during its unavailability. It will apply the necessary updates from the primary instance's binary logs (binlogs) to bring the replica up to date. 3. Resuming Read Traffic: Once the synchronization and catch-up replication processes are complete, the read replica in Zone-B will resume its normal operation. It will be able to serve read traffic and stay updated with subsequent changes from the primary instance.
質問 # 83
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 Cloud SQL Auth proxy configured with a service account to point to the external (public) IP address of your Cloud SQL instance.
- B. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
- C. Define a connection string using your Google username and password to point to the external (public) 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 internal (private) IP address of your Cloud SQL instance.
正解：D
質問 # 84
You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency. What should you do?
- A. Use direct scaling to implement the Autoscaler-based architecture.
- B. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.
- C. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.
- D. Use linear scaling to implement the Autoscaler-based architecture
正解：C
質問 # 85
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. Isolate the data analysts and operations user groups to use different Bigtable instances.
- B. Check the Cloud Monitoring table/bytes_used metric from Bigtable.
- C. Use Key Visualizer for Bigtable.
- D. Add more nodes to the Bigtable cluster.
正解：C
解説：
https://cloud.google.com/bigtable/docs/performance#troubleshooting
質問 # 86
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Run the cron job on a Compute Engine instance to continue the export.
- B. Create a streaming Datatlow job to export the table.
- C. Set up Cloud Composer, and create a task to export the table daily.
- D. Use Cloud Scheduler and Cloud Functions to run the daily export.
正解：D
解説：
https://cloud.google.com/blog/topics/developers-practitioners/scheduling-cloud-sql-exports-using-cloud-functions-and-cloud-scheduler
質問 # 87
Your organization deployed a new version of a critical application that uses Cloud SQL for MySQL with high availability (HA) and binary logging enabled to store transactional information. The latest release of the application had an error that caused massive data corruption in your Cloud SQL for MySQL database. You need to minimize data loss. What should you do?
- A. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.
- B. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.
- C. Reload the Cloud SQL for MySQL database using the LOAD DATA command to load data from CSV files that were used to initialize the instance.
- D. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.
正解：C
質問 # 88
You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
- A. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.
- B. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
- C. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.
- D. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.
正解：A
質問 # 89
Your company is evaluating Google Cloud database options for a mission-critical global payments gateway application. The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases. You need to select an automatically shardable, fully managed database with 99.999% availability and strong transactional consistency. What should you do?
- A. Select Bare Metal Solution for Oracle.
- B. Select Cloud Spanner.
- C. Select Bigtable.
- D. Select Cloud SQL.
正解：B
解説：
The application must be available 24/7 to users worldwide, horizontally scalable, and support open source databases.
質問 # 90
You need to provision several hundred Cloud SQL for MySQL instances for multiple project teams over a one-week period. You must ensure that all instances adhere to company standards such as instance naming conventions, database flags, and tags. What should you do?
- A. Create the instances using the Google Cloud Console UI.
- B. Create clones from a template Cloud SQL instance.
- C. Automate instance creation by setting up Terraform scripts.
- D. Automate instance creation by writing a Dataflow job.
正解：A
質問 # 91
Your company is developing a new global transactional application that must be ACID-compliant and have 99.999% availability. You are responsible for selecting the appropriate Google Cloud database to serve as a datastore for this new application. What should you do?
- A. Use Bigtable.
- B. Use Cloud Spanner.
- C. Use Firestore.
- D. Use Cloud SQL.
正解：B
質問 # 92
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.
Use Cloud SQL Auth proxy to connect 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.
Use Cloud SQL Auth proxy to connect to the instance. - C. 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. - D. 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.
正解：B
質問 # 93
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
- B. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- C. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- D. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
正解：D
解説：
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.
質問 # 94
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database with Google-managed encryption keys.
- B. Create the database persistent disk with Google-managed encryption keys.
- C. Create the database persistent disk with customer-managed encryption keys.
- D. Create the database with customer-managed encryption keys.
正解：C
質問 # 95
Your organization has a security policy to ensure that all Cloud SQL for PostgreSQL databases are secure. You want to protect sensitive data by using a key that meets specific locality or residency requirements. Your organization needs to control the key's lifecycle activities. You need to ensure that data is encrypted at rest and in transit. What should you do?
- A. Create the database with Google-managed encryption keys.
- B. Create the database persistent disk with Google-managed encryption keys.
- C. Create the database persistent disk with customer-managed encryption keys.
- D. Create the database with customer-managed encryption keys.
正解：D
解説：
https://cloud.google.com/sql/docs/postgres/configure-cmek#createcmekinstance
質問 # 96
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 <PrimaryInstanceName>.
- B. Use gcloud sql instances failover <ReplicaInstanceName>.
- C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
- D. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
正解：D
質問 # 97
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 synchronous replication, and set up read replicas in different regions with asynchronous 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 asynchronous replication, and set up read replicas in different regions with synchronous replication.
正解：B
解説：
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
質問 # 98
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. Use Cloud SQL Auth proxy.
- B. Use customer-managed encryption keys with Cloud SQL.
- C. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
- D. Connect to Cloud SQL using a connection that has SSL encryption.
正解：D
質問 # 99
You have a Cloud SQL instance (DB-1) with two cross-region read replicas (DB-2 and DB-3). During a business continuity test, the primary instance (DB-1) was taken offline and a replica (DB-2) was promoted. The test has concluded and you want to return to the pre-test configuration. What should you do?
- A. Delete DB-2 so that DB-1 automatically reverts to the primary instance.
- B. Bring DB-1 back online.
- C. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
- D. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.
正解：A
質問 # 100
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 synchronous replication, and set up read replicas in different regions with asynchronous 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 asynchronous replication, and set up read replicas in different regions with synchronous replication.
正解：B
解説：
This answer meets the RTO and RPO requirements by using synchronous replication within the same region, which ensures that all writes made to the primary instance are replicated to disks in both zones before a transaction is reported as committed1. This minimizes data loss and downtime in case of a zonal or an instance failure, and allows for a quick failover to the standby instance1.
This answer also meets the high availability and disaster recovery requirements by using asynchronous replication across different regions, which ensures that the data changes made to the primary instance are replicated to the read replicas in other regions with minimal delay2. This provides additional redundancy and backup in case of a regional failure, and allows for a manual failover to the read replica in another region2.
質問 # 101
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. Run the Recommender API to identify overprovisioned instances.
- B. Build indexes on heavily accessed tables.
- C. Use Query Insights to identify idle instances.
- D. Remove inactive user accounts.
正解：A
質問 # 102
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 Cloud SQL for PostgreSQL.
- B. Migrate the existing database to Cloud Spanner.
- C. Migrate the existing database to PostgreSQL running on Compute Engine.
- D. Migrate the existing database to Firestore.
正解：A
解説：
You could migrate to Spanner leveraging the PostgreSQL dialect, but costs need to be minimized so that wouldn't be the cheapest option. Especially since the load doesn't justify Spanner. Again, you could migrate like-for-like to a GCE VM, but that defeats minimizing the migration effort. The cheapest and easiest way to migrate would be Database Migration Service to Cloud SQL for PostgreSQL.
質問 # 103
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
質問 # 104
......
この試験では、データベース管理、データ分析、データ管理など、さまざまなトピックをカバーしています。また、Cloud SQL、Cloud Spanner、Cloud Bigtableなど、さまざまなGoogle Cloudデータベースサービスの使用もカバーしています。試験の目的は、この認定を保持している個人がGoogle Cloudのデータベースサービスを強く理解し、実際のシナリオで効果的に使用できるようにすることです。
信頼できるGoogle Cloud Certified Professional-Cloud-Database-Engineer問題集PDF2024年08月10日最近更新された問題：https://jp.fast2test.com/Professional-Cloud-Database-Engineer-premium-file.html
最新Professional-Cloud-Database-Engineer試験問題集には合格保証付きます：https://drive.google.com/open?id=1dQZfnD40sit9swq1sC90QSyDHaQtrcHe