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

出題：1

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 Cloud Functions to run the export in text format.

B. Use Cloud Functions to run the export in Avro format.

C. Use Dataflow to run the export in text format.

D. Use Dataflow to run the export in Avro format.

正解：D 解答を投票する

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

出題：2

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

A. Use Cloud Composer to execute a select * from table(s) query and export results.

B. Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

C. Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

D. Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

正解：C 解答を投票する

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

出題：3

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. Disable all foreign key constraints on the source PostgreSQL database.

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

C. Ensure that all PostgreSQL tables have a primary key.

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

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

正解：C,D 解答を投票する

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

出題：4

You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?

A. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.

B. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.

C. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.

D. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.

正解：B 解答を投票する

出題：5

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. Bring DB-1 back online.

B. Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

C. Delete DB-2 so that DB-1 automatically reverts to the primary instance.

D. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.

正解：D 解答を投票する

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

出題：6

You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?

A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.

B. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.

C. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.

D. Use the default configuration for the automated backups location.

正解：A 解答を投票する

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

出題：7

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

出題：8

Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

A. Recommend hard disk drives (HDD).

B. Recommend solid-state drives (SSD).

C. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

D. Recommend mixed storage types.

正解：B 解答を投票する

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

出題：9

You need to issue a new server certificate because your old one is expiring. You need to avoid a restart of your Cloud SQL for MySQL instance. What should you do in your Cloud SQL instance?

A. Create a new server certificate, and download it.

B. Reset your SSL configuration, and download your server certificate.

C. Create a new client certificate, and download it.

D. Issue a rollback, and download your server certificate.

正解：A 解答を投票する

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

出題：10

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

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