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

出題：1

You are deploying a new Cloud SQL instance on Google Cloud using the Cloud SQL Auth proxy. You have identified snippets of application code that need to access the new Cloud SQL instance. The snippets reside and execute on an application server running on a Compute Engine machine. You want to follow Google- recommended practices to set up Identity and Access Management (IAM) as quickly and securely as possible.
What should you do?

A. For each application code, set up a dedicated user account.

B. For the application server, set up a common shared user account.

C. For each application code, set up a common shared user account.

D. For the application server, set up a service account.

正解：D 解答を投票する

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

出題：2

You currently have a MySQL database running on Cloud SQL with a read replica in a different zone for non- mission critical analytics workloads. You want to enable high availability (HA) for the analytic workloads while keeping costs low. What should you do?

A. Create a new HA instance in the same zone db lie primary.

B. Increase the size of the read replica Instance and enable MA.

C. Enable HA on the current read replica.

D. Create a new MA Instance in a different region than the primary.

正解：C 解答を投票する

出題：3

You are configuring a new application that has access to an existing Cloud Spanner database. The new application reads from this database to gather statistics for a dashboard. You want to follow Google- recommended practices when granting Identity and Access Management (IAM) permissions. What should you do?

A. Reuse the existing service account that populates this database.

B. Create a new service account, and grant it the spanner.databases.select permission.

C. Create a new service account, and grant it the Cloud Spanner Database Reader role.

D. Create a new service account, and grant it the Cloud Spanner Database Admin role.

正解：C 解答を投票する

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

出題：4

You are configuring a brand new Cloud SQL for PostgreSQL database instance in Google Cloud. Your application team wants you to deploy one primary instance, one standby instance, and one read replica instance. You need to ensure that you are following Google-recommended practices for high availability.
What should you do?

A. Configure the primary instance in zone A, the standby instance in zone C, and the read replica in zone B, all in the same region.

B. Configure the primary, standby, and read replica instances in zone A, all in the same region.

C. Configure the primary instance in one region, the standby instance in a second region, and the read replica in a third region.

D. Configure the primary and standby instances in zone A and the read replica in zone B, all in the same region.

正解：A 解答を投票する

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

出題：5

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

A. Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database.

B. Use Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

C. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage.
Upload the changes into BigQuery, and merge them with existing tables.

D. Use Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

正解：B 解答を投票する

出題：6

Your company uses the Cloud SQL out-of-disk recommender to analyze the storage utilization trends of production databases over the last 30 days. Your database operations team uses these recommendations to proactively monitor storage utilization and implement corrective actions. You receive a recommendation that the instance is likely to run out of disk space. What should you do to address this storage alert?

A. Create another schema to load older data.

B. Normalize the database to the third normal form.

C. Manually or automatically increase the storage capacity.

D. Compress the data using a different compression algorithm.

正解：C 解答を投票する

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

出題：7

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

出題：8

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 one regional Cloud SQL instance with a read replica in another region.

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

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

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

正解：B 解答を投票する

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

出題：9

Your online delivery business that primarily serves retail customers uses Cloud SQL for MySQL for its inventory and scheduling application. The required recovery time objective (RTO) and recovery point objective (RPO) must be in minutes rather than hours as a part of your high availability and disaster recovery design. You need a high availability configuration that can recover without data loss during a zonal or a regional failure. What should you do?

A. Set up read replicas in different zones of the same region as the primary instance with synchronous replication, and set up read replicas in different regions with asynchronous replication.

B. Set up all read replicas in a different region using asynchronous replication.

C. Set up read replicas in different zones of the same region as the primary instance with asynchronous replication, and set up read replicas in different regions with synchronous replication.

D. Set up all read replicas in the same region as the primary instance with synchronous replication.

正解：A 解答を投票する

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