Professional-Cloud-Database-Engineer試験無料問題集（144題）「Google Cloud Certified

出題：1

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 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

C. 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.

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 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

A. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

C. Migrate all the databases to Cloud SQL.

D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

正解：D 解答を投票する

出題：3

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 Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

B. 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.

C. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

D. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional data. 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 10PM. 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. Create your database with one primary node and one read replica in the region.

C. Configure your Cloud SQL instance with high availability enabled.

D. 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.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

You want to migrate an existing on-premises application to Google Cloud. Your application supports semi- structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

A. Deploy the database using Cloud SQL.

B. Deploy the database using Cloud Spanner.

C. Deploy the database using Bigtable.

D. Use BigQuery, and load data in batches.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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. Automate instance creation by writing a Dataflow job.

B. Automate instance creation by setting up Terraform scripts.

C. Create the instances using the Google Cloud Console UI.

D. Create clones from a template Cloud SQL instance.

正解：B 解答を投票する

出題：7

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 Cloud Debugger to inspect the state of an application.

B. Use Cloud Monitoring to monitor CPU, memory, and storage utilization metrics.

C. Use Logs Explorer to analyze log data.

D. Use Error Reporting to count, analyze, and aggregate the data.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

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. 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.

B. Open the Google Cloud Console, navigate to SQL > Backups, and select the last version of the automated backup before the corruption.

C. Perform a point-in-time recovery of your Cloud SQL for MySQL database, selecting a date and time before the data was corrupted.

D. Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

A. Migrate the databases to Compute Engine using regional persistent disks.

B. Migrate the databases to Cloud Spanner.

C. Migrate the databases to Bare Metal Solution for Oracle.

D. Migrate the databases to Cloud SQL, and enable a standby database.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

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 Firestore.

C. Use Cloud Spanner.

D. Use Cloud SQL.

正解：C 解答を投票する

Professional-Cloud-Database-Engineer試験無料問題集「Google Cloud Certified - Professional Cloud Database Engineer 認定」