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

出題：1

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. Use Cloud Scheduler and Cloud Functions to run the daily export.

B. Set up Cloud Composer, and create a task to export the table daily.

C. Run the cron job on a Compute Engine instance to continue the export.

D. Create a streaming Datatlow job to export the table.

正解：A 解答を投票する

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

出題：2

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 promote-replica <ReplicaInstanceName>.

B. Use gcloud sql instances failover <PrimaryInstanceName>.

C. Use gcloud sql instances promote-replica <PrimaryInstanceName>.

D. Use gcloud sql instances failover <ReplicaInstanceName>.

正解：B 解答を投票する

出題：3

You have deployed a Cloud SQL for SQL Server instance. In addition, you created a cross-region read replica for disaster recovery (DR) purposes. Your company requires you to maintain and monitor a recovery point objective (RPO) of less than 5 minutes. You need to verify that your cross-region read replica meets the allowed RPO. What should you do?

A. Use Cloud SQL logs.

B. Use Cloud SQL instance monitoring.

C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.

D. Use the SQL Server Always On Availability Group dashboard.

正解：D 解答を投票する

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

出題：4

Your organization has an existing app that just went viral. The app uses a Cloud SQL for MySQL backend database that is experiencing slow disk performance while using hard disk drives (HDDs). You need to improve performance and reduce disk I/O wait times. What should you do?

A. Create a read replica of the instance with SSDs, and perform a failover to the new instance

B. Edit the instance to change the storage type from HDD to SSD.

C. Create a high availability (HA) failover instance with SSDs, and perform a failover to the new instance.

D. Export the data from the existing instance, and import the data into a new instance with solid-state drives (SSDs).

正解：D 解答を投票する

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

出題：5

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 internal (private) IP address of your Cloud SQL instance.

B. Define a connection string using your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

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

D. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.

正解：A 解答を投票する

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

出題：6

You are configuring the networking of a Cloud SQL instance. The only application that connects to this database resides on a Compute Engine VM in the same project as the Cloud SQL instance. The VM and the Cloud SQL instance both use the same VPC network, and both have an external (public) IP address and an internal (private) IP address. You want to improve network security. What should you do?

A. Disable and remove the internal IP address assignment.

B. Specify an authorized network with the CIDR range of the VM.

C. Disable and remove the external IP address assignment.

D. Disable both the external IP address and the internal IP address, and instead rely on Private Google Access.

正解：C 解答を投票する

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

出題：7

You are designing a physician portal app in Node.js. This application will be used in hospitals and clinics that might have intermittent internet connectivity. If a connectivity failure occurs, the app should be able to query the cached dat a. You need to ensure that the application has scalability, strong consistency, and multi-region replication. What should you do?

A. Use Table.read with the exactStaleness option to perform a read of rows in Cloud Spanner.

B. Use Firestore and ensure that the PersistenceEnabled option is set to true.

C. Use Pub/Sub to synchronize the changes from the application to Cloud Spanner.

D. Use Memorystore for Memcached.

正解：B 解答を投票する

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

出題：8

Your company is migrating their MySQL database to Cloud SQL and cannot afford any planned downtime during the month of December. The company is also concerned with cost, so you need the most cost-effective solution. What should you do?

A. Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

B. Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

C. Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

D. Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

正解：D 解答を投票する

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

出題：9

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

A. Use Memorystore for data storage.

B. Use Bigtable for data storage.

C. Use Cloud SQL for data storage.

D. Use Cloud Spanner for data storage.

正解：D 解答を投票する

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

出題：10

Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

A. Cloud Spanner

B. BigQuery

C. Bigtable

D. Cloud SQL

正解：B 解答を投票する

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