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

質問 1

Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?

（A）Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.

（B）Use Cloud SQL serverless exports.

（C）Create a read replica, and then use the mysqldump utility to export each table.

（D）Use the mysqldump utility on the primary database instance to export the backup.

正解：B 解答を投票する

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

質問 2

You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

（A）Create a clone database from a read replica database, and restore the clone in the same region.

（B）Create a clone database from a read replica database, and restore the clone into a different zone.

（C）Use the Cloud SQL database import feature. Import last week's dump file from Cloud Storage.

（D）Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

正解：D 解答を投票する

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

質問 3

You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

（A）Use Database Migration Service to complete the migration.

（B）Export the data from the existing database, and load the data into a new Cloud SQL database.

（C）Use Migrate for Compute Engine to complete the migration.

（D）Use Datastream to complete the migration.

正解：A 解答を投票する

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

質問 4

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

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

質問 5

You are managing two different applications: Order Management and Sales Reporting. Both applications interact with the same Cloud SQL for MySQL database. The Order Management application reads and writes to the database 24/7, but the Sales Reporting application is read-only. Both applications need the latest dat a. You need to ensure that the Performance of the Order Management application is not affected by the Sales Reporting application. What should you do?

（A）Use a Cloud SQL federated query for the Sales Reporting application.

（B）Queue up all the requested reports in PubSub, and execute the reports at night.

（C）Create a read replica for the Sales Reporting application.

（D）Create two separate databases in the instance, and perform dual writes from the Order Management application.

正解：C 解答を投票する

質問 6

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 メンバーにのみ表示されます)

質問 7

Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

（A）Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

（B）Use Memorystore to handle your low-latency requirements and for real-time analytics.

（C）Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.

（D）Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

正解：D 解答を投票する

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

質問 8

Your hotel booking company is expanding into Country A, where personally identifiable information (PII) must comply with regional data residency requirements and audits. You need to isolate customer data in Country A from the rest of the customer dat a. You want to design a multi-tenancy strategy to efficiently manage costs and operations. What should you do?

（A）Apply an instance data management pattern.

（B）Apply a database data management pattern.

（C）Apply a table data management pattern.

（D）Apply a schema data management pattern.

正解：A 解答を投票する

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

質問 9

You plan to use Database Migration Service to migrate data from a PostgreSQL on-premises instance to Cloud SQL. You need to identify the prerequisites for creating and automating the task. What should you do? (Choose two.)

（A）Ensure that all PostgreSQL tables have a primary key.

（B）Drop or disable all users except database administration users.

（C）Disable all foreign key constraints on the source PostgreSQL database.

（D）Ensure that pglogical is installed on the source PostgreSQL database.

（E）Shut down the database before the Data Migration Service task is started.

正解：A、D 解答を投票する

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

質問 10

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 メンバーにのみ表示されます)

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

弊社を連絡する

関連リンク

トップ試験