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

出題：1

You are writing an application that will run on Cloud Run and require a database running in the Cloud SQL managed service. You want to secure this instance so that it only receives connections from applications running in your VPC environment in Google Cloud. What should you do?

A. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Use Cloud SQL Auth proxy to connect to the instance.

B. 1. Create your instance with a specified external (public) IP address.
2. Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
3. Connect to the instance using a connection pool to best manage connections to the instance.

C. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Use Cloud SQL Auth proxy to connect to the instance.

D. 1. Create your instance with a specified internal (private) IP address.
2. Choose the VPC with private service connection configured.
3. Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
4. Connect to the instance using a connection pool to best manage connections to the instance.

正解：D 解答を投票する

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

出題：2

Your organization has strict policies on tracking rollouts to production and periodically shares this information with external auditors to meet compliance requirements. You need to enable auditing on several Cloud Spanner databases. What should you do?

A. Use Liquibase to roll out changes to higher environments.

B. Use replication to roll out changes to higher environments.

C. Use backup and restore to roll out changes to higher environments.

D. Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

正解：A 解答を投票する

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

出題：3

Your company is shutting down their on-premises data center and migrating their Oracle databases using Oracle Real Application Clusters (RAC) to Google Cloud. You want minimal to no changes to the applications during the database migration. What should you do?

A. Migrate the Oracle databases to Bare Metal Solution for Oracle.

B. Migrate the Oracle databases to Cloud Spanner.

C. Migrate the Oracle databases to Cloud SQL.

D. Migrate the Oracle databases to Compute Engine.

正解：A 解答を投票する

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

出題：4

Your DevOps team is using Terraform to deploy applications and Cloud SQL databases. After every new application change is rolled out, the environment is torn down and recreated, and the persistent database layer is lost. You need to prevent the database from being dropped. What should you do?

A. Use point-in-time-recovery (PITR) to recover the database.

B. Rerun terraform apply.

C. Create a read replica.

D. Set Terraform deletion_protection to true.

正解：D 解答を投票する

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

出題：5

Your company wants you to migrate their Oracle, MySQL, Microsoft SQL Server, and PostgreSQL relational databases to Google Cloud. You need a fully managed, flexible database solution when possible. What should you do?

A. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Compute Engine, and migrate the Oracle databases to Bare Metal Solution for Oracle.

B. Migrate the Oracle, MySQL, and Microsoft SQL Server databases to Cloud SQL, and migrate the PostgreSQL databases to Compute Engine.

C. Migrate all the databases to Cloud SQL.

D. Migrate the MySQL, Microsoft SQL Server, and PostgreSQL databases to Cloud SQL, and migrate the Oracle databases to Bare Metal Solution for Oracle.

正解：D 解答を投票する

出題：6

You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?

A. Use Cloud Spanner with multi-region configuration.

B. Use Memorystore for Redis with multi-zones within a region.

C. Use Bigtable with multi-region clusters.

D. Use Cloud SQL for PostgreSQL with cross-region replicas.

正解：D 解答を投票する

出題：7

You are migrating a telehealth care company's on-premises data center to Google Cloud. The migration plan specifies:
PostgreSQL databases must be migrated to a multi-region backup configuration with cross-region replicas to allow restore and failover in multiple scenarios.
MySQL databases handle personally identifiable information (PII) and require data residency compliance at the regional level.
You want to set up the environment with minimal administrative effort. What should you do?

A. Set up different projects for PostgreSQL and MySQL databases, and apply organizational policy constraints at a project level.

B. Set up Pub/Sub to ingest data from Cloud Logging, send an alert every time a new database instance is created, and manually validate the region.

C. Set up Cloud Logging and Cloud Monitoring with Cloud Functions to send an alert every time a new database instance is created, and manually validate the region.

D. Set up different organizations for each database type, and apply policy constraints at the organization level.

正解：A 解答を投票する

出題：8

You are running a large, highly transactional application on Oracle Real Application Cluster (RAC) that is multi-tenant and uses shared storage. You need a solution that ensures high-performance throughput and a low-latency connection between applications and databases. The solution must also support existing Oracle features and provide ease of migration to Google Cloud. What should you do?

A. Migrate to Google Kubernetes Engine (GKE)

B. Migrate to Bare Metal Solution for Oracle.

C. Migrate to Google Cloud VMware Engine

D. Migrate to Compute Engine.

正解：B 解答を投票する

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

出題：9

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

出題：10

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?

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