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

質問 1

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）Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job between November 1 and January 15.

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

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

正解：D 解答を投票する

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

質問 2

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 Google Kubernetes Engine (GKE).

（B）Migrate to Compute Engine.

（C）Migrate to Cloud SQL for SQL Server.

（D）Migrate to Cloud SQL for PostgreSQL.

正解：B 解答を投票する

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

質問 3

Your company is migrating all legacy applications to Google Cloud. All on-premises applications are using legacy Oracle 12c databases with Oracle Real Application Cluster (RAC) for high availability (HA) and Oracle Data Guard for disaster recovery. You need a solution that requires minimal code changes, provides the same high availability you have today on-premises, and supports a low latency network for migrated legacy applications. What should you do?

（A）Migrate the databases to Compute Engine using regional persistent disks.

（B）Migrate the databases to Bare Metal Solution for Oracle.

（C）Migrate the databases to Cloud SQL, and enable a standby database.

（D）Migrate the databases to Cloud Spanner.

正解：B 解答を投票する

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

質問 4

You host an application in Google Cloud. The application is located in a single region and uses Cloud SQL for transactional dat a. Most of your users are located in the same time zone and expect the application to be available 7 days a week, from 6 AM to 10 PM. You want to ensure regular maintenance updates to your Cloud SQL instance without creating downtime for your users. What should you do?

（A）Create your database with one primary node and one read replica in the region.

（B）Configure your Cloud SQL instance with high availability enabled.

（C）Configure a maintenance window during a period when no users will be on the system. Control the order of update by setting non-production instances to earlier and production instances to later.

（D）Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.

正解：C 解答を投票する

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

質問 5

Your team is building a new inventory management application that will require read and write database instances in multiple Google Cloud regions around the globe. Your database solution requires 99.99% availability and global transactional consistency. You need a fully managed backend relational database to store inventory changes. What should you do?

（A）Use Firestore.

（B）Use Bigtable.

（C）Use Cloud SQL for MySQL

（D）Use Cloud Spanner.

正解：D 解答を投票する

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

質問 6

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）Delete DB-1, and re-create DB-1 as a read replica in the same region as DB-1.

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

（C）Bring DB-1 back online.

（D）Delete DB-2 so that DB-1 automatically reverts to the primary instance.

正解：B 解答を投票する

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

質問 7

You are the database administrator of a Cloud SQL for PostgreSQL instance that has pgaudit disabled. Users are complaining that their queries are taking longer to execute and performance has degraded over the past few months. You need to collect and analyze query performance data to help identity slow-running queries. What should you do?

（A）View Cloud SQL operations to view historical query information.

（B）White a Logs Explorer query to identify database queries with high execution times.

（C）Review application logs to identify database calls.

（D）Use the Query Insights dashboard to identify high execution times.

正解：D 解答を投票する

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

質問 8

You need to redesign the architecture of an application that currently uses Cloud SQL for PostgreSQL. The users of the application complain about slow query response times. You want to enhance your application architecture to offer sub-millisecond query latency. What should you do?

（A）Configure Memorystore, and modify your application to offload queries.

（B）Configure Firestore, and modify your application to offload queries.

（C）Configure Cloud SQL for PostgreSQL read replicas to offload queries.

（D）Configure Bigtable, and modify your application to offload queries.

正解：A 解答を投票する

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

質問 9

You are configuring a brand new PostgreSQL database instance in Cloud SQL. Your application team wants to have an optimal and highly available environment with automatic failover to avoid any unplanned outage. What should you do?

（A）Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.

（B）Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.

（C）Create one regional Cloud SQL instance with a read replica in another region.

（D）Create two read-write Cloud SQL instances in two different zones with a standby instance in another region.

正解：B 解答を投票する

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

質問 10

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 your Google username and password to point to the external (public) IP address of your Cloud SQL instance.

（B）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.

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

正解：B 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験