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

出題：1

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

出題：2

Your company wants to move to Google Cloud. Your current data center is closing in six months. You are running a large, highly transactional Oracle application footprint on VMWare. You need to design a solution with minimal disruption to the current architecture and provide ease of migration to Google Cloud. What should you do?

A. Migrate applications to Cloud SQL.

B. Migrate applications and Oracle databases to Google Kubernetes Engine (GKE).

C. Migrate applications and Oracle databases to Compute Engine.

D. Migrate applications and Oracle databases to Google Cloud VMware Engine (VMware Engine).

正解：D 解答を投票する

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

出題：3

You manage a meeting booking application that uses Cloud SQL. During an important launch, the Cloud SQL instance went through a maintenance event that resulted in a downtime of more than 5 minutes and adversely affected your production application. You need to immediately address the maintenance issue to prevent any unplanned events in the future. What should you do?

A. Migrate the Cloud SQL instance to Cloud Spanner to avoid any future disruptions due to maintenance.

B. Contact Support to understand why your Cloud SQL instance had a downtime of more than 5 minutes.

C. Use Cloud Scheduler to schedule a maintenance window of no longer than 5 minutes.

D. Set your production instance's maintenance window to non-business hours.

正解：D 解答を投票する

出題：4

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 Cloud SQL with a customer-managed encryption key (CMEK).

B. Use Cloud Spanner with default encryption.

C. Use Bigtable with default encryption.

D. Use Cloud Spanner with a customer-managed encryption key (CMEK).

正解：D 解答を投票する

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

出題：5

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

出題：6

Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?

A. Migrate to Cloud SQL for SQL Server.

B. Migrate to Google Kubernetes Engine (GKE).

C. Migrate to Compute Engine.

D. Migrate to Cloud SQL for PostgreSQL.

正解：C 解答を投票する

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

出題：7

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 Google Workspace Password Sync to replicate passwords into Google Cloud.

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

C. Use workload identity federation to impersonate a service account.

D. Ask existing users to set their Google password to match their corporate password.

正解：C 解答を投票する

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

出題：8

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

出題：9

You manage a production MySQL database running on Cloud SQL at a retail company. You perform routine maintenance on Sunday at midnight when traffic is slow, but you want to skip routine maintenance during the year-end holiday shopping season. You need to ensure that your production system is available 24/7 during the holidays. What should you do?

A. Define a maintenance window on Sundays between 12 AM and 5 AM, and deny maintenance periods between November 1 and February 15.

B. Define a maintenance window on Sundays between 12 AM and 1 AM, and deny maintenance periods between November 1 and January 15.

C. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

D. Build a Cloud Composer job to start a maintenance window on Sundays between 12 AM and 1AM, and deny maintenance periods between November 1 and January 15.

正解：B 解答を投票する

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

出題：10

Your customer is running a MySQL database on-premises with read replicas. The nightly incremental backups are expensive and add maintenance overhead. You want to follow Google-recommended practices to migrate the database to Google Cloud, and you need to ensure minimal downtime. What should you do?

A. Use the mysqldump utility to take a backup of the existing on-premises database, and then import it into Cloud SQL.

B. Create a Google Kubernetes Engine (GKE) cluster, install MySQL on the cluster, and then import the dump file.

C. Create an external replica, and use Cloud SQL to synchronize the data to the replica.

D. Create a Compute Engine VM, install MySQL on the VM, and then import the dump file.

正解：C 解答を投票する

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

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