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

質問 1

You are working on a new centralized inventory management system to track items available in 200 stores, which each have 500 GB of dat a. 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 a Biglable cluster with autoscaling.

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

（C）Use Cloud Spanner with a custom autoscaling solution.

（D）Use sharded Cloud SQL instances with one or more stores per database instance.

正解：C 解答を投票する

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

質問 2

Your ecommerce website captures user clickstream data to analyze customer traffic patterns in real time and support personalization features on your website. You plan to analyze this data using big data tools. You need a low-latency solution that can store 8 TB of data and can scale to millions of read and write requests per second. What should you do?

（A）Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.

（B）Use Memorystore to handle your low-latency requirements and for real-time analytics.

（C）Deploy a Cloud SQL environment with read replicas for improved performance. Use Datastream to export data to Cloud Storage and analyze with Dataproc and the Cloud Storage connector.

（D）Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.

正解：D 解答を投票する

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

質問 3

You are designing an augmented reality game for iOS and Android devices. You plan to use Cloud Spanner as the primary backend database for game state storage and player authentication. You want to track in-game rewards that players unlock at every stage of the game. During the testing phase, you discovered that costs are much higher than anticipated, but the query response times are within the SLA.
You want to follow Google-recommended practices. You need the database to be performant and highly available while you keep costs low. What should you do?

（A）Use granular instance sizing in Cloud Spanner and Autoscaler.

（B）Manually scale down the number of nodes after the peak period has passed.

（C）Use the Cloud Spanner query optimizer to determine the most efficient way to execute the SQL query.

（D）Use interleaving to co-locate parent and child rows.

正解：A 解答を投票する

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

質問 4

Your company is developing a global ecommerce website on Google Cloud. Your development team is working on a shopping cart service that is durable and elastically scalable with live traffic. Business disruptions from unplanned downtime are expected to be less than 5 minutes per month. In addition, the application needs to have very low latency writes. You need a data storage solution that has high write throughput and provides 99.99% uptime. What should you do?

（A）Use Memorystore for data storage.

（B）Use Cloud SQL for data storage.

（C）Use Cloud Spanner for data storage.

（D）Use Bigtable for data storage.

正解：C 解答を投票する

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

質問 5

You recently launched a new product to the US market. You currently have two Bigtable clusters in one US region to serve all the traffic. Your marketing team is planning an immediate expansion to APAC. You need to roll out the regional expansion while implementing high availability according to Google-recommended practices. What should you do?

（A）Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central1-b
cluster-c in zone us-east1-a

（B）Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone us-central2-a
cluster-c in zone asia-northeast1-b
cluster-d in zone asia-east1-b

（C）Maintain a target of 35% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone australia-southeast1-a
cluster-c in zone europe-west1-d
cluster-d in zone asia-east1-b

（D）Maintain a target of 23% CPU utilization by locating:
cluster-a in zone us-central1-a
cluster-b in zone europe-west1-d
cluster-c in zone asia-east1-b

正解：B 解答を投票する

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

質問 6

You are setting up a Bare Metal Solution environment. You need to update the operating system to the latest version. You need to connect the Bare Metal Solution environment to the internet so you can receive software updates. What should you do?

（A）Setup a static external IP address in your VPC network.

（B）Set up bring your own IP (BYOIP) in your VPC.

（C）Set up a Cloud NAT gateway on the Compute Engine VM.

（D）Set up Cloud NAT service.

正解：C 解答を投票する

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

質問 7

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 Compute Engine.

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

（C）Migrate the Oracle databases to Cloud SQL.

（D）Migrate the Oracle databases to Cloud Spanner.

正解：B 解答を投票する

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

質問 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 failover <PrimaryInstanceName>.

（B）Use gcloud sql instances promote-replica <PrimaryInstanceName>.

（C）Use gcloud sql instances promote-replica <ReplicaInstanceName>.

（D）Use gcloud sql instances failover <ReplicaInstanceName>.

正解：A 解答を投票する

質問 9

You work in the logistics department. Your data analysis team needs daily extracts from Cloud SQL for MySQL to train a machine learning model. The model will be used to optimize next-day routes. You need to export the data in CSV format. You want to follow Google-recommended practices. What should you do?

（A）Use Cloud Composer to execute a select * from table(s) query and export results.

（B）Use Cloud Scheduler to trigger a Cloud Function through Pub/Sub to call the cloudsql.instances.export API.

（C）Use Cloud Composer to orchestrate an export by calling the cloudsql.instances.export API.

（D）Use Cloud Scheduler to trigger a Cloud Function that will run a select * from table(s) query to call the cloudsql.instances.export API.

正解：B 解答を投票する

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

質問 10

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 all read replicas in a different region using asynchronous replication.

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

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

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

正解：B 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験