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

出題：1

You are managing a Cloud SQL for PostgreSQL instance in Google Cloud. You have a primary instance in region 1 and a read replica in region 2. After a failure of region 1, you need to make the Cloud SQL instance available again. You want to minimize data loss and follow Google-recommended practices. What should you do?

A. Restore the Cloud SQL instance from the automatic backups in region 3.

B. Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .

C. Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

D. Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance.
Check the replication status usingpg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

正解：D 解答を投票する

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

出題：2

You are migrating an on-premises application to Compute Engine and Cloud SQL. The application VMs will live in their own project, separate from the Cloud SQL instances which have their own project. What should you do to configure the networks?

A. Place both the application VMs and the Cloud SQL instances in the default network of each project.

B. Create a Shared VPC that both the application VMs and Cloud SQL instances will use.

C. Use the default networks, and leverage Cloud VPN to connect the two together.

D. Create a new VPC network in each project, and use VPC Network Peering to connect the two together.

正解：B 解答を投票する

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

出題：3

You are using Compute Engine on Google Cloud and your data center to manage a set of MySQL databases in a hybrid configuration. You need to create replicas to scale reads and to offload part of the management operation. What should you do?

A. Use external server replication.

B. Use Data Migration Service.

C. Use Cloud SQL for MySQL external replica.

D. Use the mysqldump utility and binary logs.

正解：C 解答を投票する

解説: (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

You work for a financial services company that wants to use fully managed database services. Traffic volume for your consumer services products has increased annually at a constant rate with occasional spikes around holidays. You frequently need to upgrade the capacity of your database. You want to use Cloud Spanner and include an automated method to increase your hardware capacity to support a higher level of concurrency.
What should you do?

A. Use linear scaling to implement the Autoscaler-based architecture

B. Upgrade the Cloud Spanner instance on a periodic basis during the scheduled maintenance window.

C. Use direct scaling to implement the Autoscaler-based architecture.

D. Set up alerts that are triggered when Cloud Spanner utilization metrics breach the threshold, and then schedule an upgrade during the scheduled maintenance window.

正解：A 解答を投票する

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

出題：6

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of data. You are planning a gradual rollout of the system to a few stores each week.
You need to design an SQL database architecture that minimizes costs and user disruption during each regional rollout and can scale up or down on nights and holidays. What should you do?

A. Use sharded Cloud SQL instances with one or more stores per database instance.

B. Use Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.

C. Use a Biglable cluster with autoscaling.

D. Use Cloud Spanner with a custom autoscaling solution.

正解：D 解答を投票する

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

出題：7

You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the discovery phase of your project, you notice that your on-premises server peaks at around 25,000 read IOPS.
You need to ensure that your Cloud SQL instance is sized appropriately to maximize read performance. What should you do?

A. Create a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104 GB of RAM, and 200 GB of SSD.

B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.

C. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.

D. Create a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM, and 800 GB of solid-state drive (SSD).

正解：B 解答を投票する

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

出題：8

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

出題：9

You are designing for a write-heavy application. During testing, you discover that the write workloads are performant in a regional Cloud Spanner instance but slow down byan order of magnitude in a multi-regional instance. You want to make the write workloads faster in a multi-regional instance. What should you do?

A. Add more read-write replicas.

B. Place the bulk of the read and write workloads closer to the default leader region.

C. Use staleness of at least 15 seconds.

D. Keep the total CPU utilization under 45% in each region.

正解：B 解答を投票する

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

出題：10

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

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