Professional-Cloud-Database-Engineer無料問題集「Google Cloud Certified

質問 1

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

（A）Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Keep backups older than one day stored in Actifio OnVault storage.

（B）Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.

（C）Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on all flash storage.
Keep backups older than one day stored in Actifio OnVault storage.

（D）Create the database on a Bare Metal Solution server with the database running on flash storage.
Keep a local backup copy on standard storage.
Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.

正解：A 解答を投票する

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

質問 2

Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?

（A）Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

（B）Use data replication tools and CDC tools to enable migration.

（C）Use a combination of Database Migration Service and partner tools to support the data migration strategy.

（D）Use Database Migration Service to migrate all databases to Cloud SQL.

正解：D 解答を投票する

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

質問 3

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

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

正解：B 解答を投票する

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

質問 4

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

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

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

質問 5

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

（C）Migrate the existing database to Cloud Spanner.

（D）Migrate the existing database to Cloud SQL for PostgreSQL.

正解：D 解答を投票する

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

質問 6

You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?

（A）Use Bigtable with default encryption.

（B）Use Cloud Spanner with a customer-managed encryption key (CMEK).

（C）Use Cloud Spanner with default encryption.

（D）Use Cloud SQL with a customer-managed encryption key (CMEK).

正解：B 解答を投票する

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

質問 7

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

（A）Configure Memorystore, and modify your application to offload queries.

（B）Configure Firestore, and modify your application to offload queries.

（C）Configure Cloud SQL for PostgreSQL read replicas to offload queries.

（D）Configure Bigtable, and modify your application to offload queries.

正解：A 解答を投票する

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

質問 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）Fail over to the Cloud SQL for MySQL HA instance. Use that instance to recover the transactions that occurred before the corruption.

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

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

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

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

質問 9

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 SQL for PostgreSQL with both cross-region read replicas.

（B）Use Firestore in Datastore mode.

（C）Use Cloud Spanner in a multi-region configuration.

（D）Use a Bigtable instance with clusters in multiple regions.

正解：C 解答を投票する

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

質問 10

Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?

（A）Use workload identity federation to impersonate a service account.

（B）Use Google Workspace Password Sync to replicate passwords into Google Cloud.

（C）Ask existing users to set their Google password to match their corporate password.

（D）Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

正解：A 解答を投票する

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

Professional-Cloud-Database-Engineer 無料問題集「Google Cloud Certified - Professional Cloud Database Engineer」

弊社を連絡する

関連リンク

トップ試験