Google Professional-Cloud-Database-Engineerリアル試験問題テストエンジン問題集トレーニングには120問あります
Professional-Cloud-Database-Engineer実際の問題解答PDFには100%カバー率リアル試験問題
試験は、候補者の様々なデータベース技術の知識とその知識を実際のシナリオに適用する能力をテストするために設計された、多肢選択問題と多重選択問題から構成されています。試験は、データベース設計、データモデリング、データベース移行、レプリケーション、バックアップとリカバリ、パフォーマンスの最適化、およびセキュリティなどのトピックをカバーしています。候補者はSQLに深い理解を持っていることが期待され、MySQL、PostgreSQL、Oracleなどのさまざまなデータベース管理システムに精通している必要があります。
質問 # 30
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. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Use Cloud SQL Auth proxy to connect to the instance. - B. Create your instance with a specified internal (private) IP address.
Choose the VPC with private service connection configured.
Configure the Serverless VPC Access connector in the same VPC network as your Cloud SQL instance.
Connect to the instance using a connection pool to best manage connections to the instance. - C. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Use Cloud SQL Auth proxy to connect to the instance. - D. Create your instance with a specified external (public) IP address.
Choose the VPC and create firewall rules to allow only connections from Cloud Run into your instance.
Connect to the instance using a connection pool to best manage connections to the instance.
正解：A
質問 # 31
You want to migrate an on-premises 100 TB Microsoft SQL Server database to Google Cloud over a 1 Gbps network link. You have 48 hours allowed downtime to migrate this database. What should you do? (Choose two.)
- A. Increase the network bandwidth to 10 Gbps, and then perform an offline data migration.
- B. Keep the network bandwidth at 1 Gbps, and then perform an offline data migration.
- C. Use a change data capture (CDC) migration strategy.
- D. Increase the network bandwidth to 2 Gbps, and then perform an offline data migration.
- E. Move the physical database servers from on-premises to Google Cloud.
正解：C、D
質問 # 32
You work for a large retail and ecommerce company that is starting to extend their business globally. Your company plans to migrate to Google Cloud. You want to use platforms that will scale easily, handle transactions with the least amount of latency, and provide a reliable customer experience. You need a storage layer for sales transactions and current inventory levels. You want to retain the same relational schema that your existing platform uses. What should you do?
- A. Store your data in Firestore in a multi-region location, and place your compute resources in one of the constituent regions.
- B. Deploy a Bigtable instance with a cluster in one region and a replica cluster in another geographic region.
- C. Deploy Cloud Spanner using a multi-region instance, and place your compute resources close to the default leader region.
- D. Build an in-memory cache in Memorystore, and deploy to the specific geographic regions where your application resides.
正解：C
質問 # 33
You are managing a set of Cloud SQL databases in Google Cloud. Regulations require that database backups reside in the region where the database is created. You want to minimize operational costs and administrative effort. What should you do?
- A. Configure the automated backups to use a regional Cloud Storage bucket as a custom location.
- B. Disable automated backups, and configure serverless exports to a regional Cloud Storage bucket.
- C. Disable automated backups, and create an on-demand backup routine to a regional Cloud Storage bucket.
- D. Use the default configuration for the automated backups location.
正解：C
質問 # 34
Your company has PostgreSQL databases on-premises and on Amazon Web Services (AWS). You are planning multiple database migrations to Cloud SQL in an effort to reduce costs and downtime. You want to follow Google-recommended practices and use Google native data migration tools. You also want to closely monitor the migrations as part of the cutover strategy. What should you do?
- A. Use data replication tools and CDC tools to enable migration.
- B. Use a combination of Database Migration Service and partner tools to support the data migration strategy.
- C. Use Database Migration Service to migrate all databases to Cloud SQL.
- D. Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.
正解：D
質問 # 35
You are designing a payments processing application on Google Cloud. The application must continue to serve requests and avoid any user disruption if a regional failure occurs. You need to use AES-256 to encrypt data in the database, and you want to control where you store the encryption key. What should you do?
- A. Use Cloud SQL with a customer-managed encryption key (CMEK).
- B. Use Cloud Spanner with default encryption.
- C. Use Bigtable with default encryption.
- D. Use Cloud Spanner with a customer-managed encryption key (CMEK).
正解：A
質問 # 36
You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?
- A. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
- C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
- D. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
正解：D
質問 # 37
Your company is shutting down their data center and migrating several MySQL and PostgreSQL databases to Google Cloud. Your database operations team is severely constrained by ongoing production releases and the lack of capacity for additional on-premises backups. You want to ensure that the scheduled migrations happen with minimal downtime and that the Google Cloud databases stay in sync with the on-premises data changes until the applications can cut over. What should you do? (Choose two.)
- A. Use replication from an external server to migrate the databases to Cloud SQL.
- B. Use Database Migration Service to migrate the databases to Cloud SQL.
- C. Use an external read replica to migrate the databases to Cloud SQL.
- D. Use a cross-region read replica to migrate the databases to Cloud SQL.
- E. Use a read replica to migrate the databases to Cloud SQL.
正解：A、E
質問 # 38
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 zones with a standby instance in another region.
- B. Create two read-write Cloud SQL instances in two different regions with a standby instance in another zone.
- C. Create one regional Cloud SQL instance with a read replica in another region.
- D. Create one regional Cloud SQL instance in one zone with a standby instance in another zone in the same region.
正解：A
質問 # 39
Your team is running a Cloud SQL for MySQL instance with a 5 TB database that must be available 24/7. You need to save database backups on object storage with minimal operational overhead or risk to your production workloads. What should you do?
- A. Create a read replica, and then use the mysqldump utility to export each table.
- B. Clone the Cloud SQL instance, and then use the mysqldump utlity to export the data.
- C. Use Cloud SQL serverless exports.
- D. Use the mysqldump utility on the primary database instance to export the backup.
正解：B
質問 # 40
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 SQL for PostgreSQL with cross-region replicas.
- B. Use Memorystore for Redis with multi-zones within a region.
- C. Use Bigtable with multi-region clusters.
- D. Use Cloud Spanner with multi-region configuration.
正解：A
質問 # 41
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
- A. Identity all tables that do not have at least one foreign key.
- B. Identify whether the database has over 512 tables.
- C. Identify whether the source database uses customer-managed encryption keys (CMEK).
- D. Identify all tables that do not have a primary key.
- E. Identify whether the source database is encrypted using pgcrypto extension.
正解：A、C
質問 # 42
Your organization has a production Cloud SQL for MySQL instance. Your instance is configured with 16 vCPUs and 104 GB of RAM that is running between 90% and 100% CPU utilization for most of the day. You need to scale up the database and add vCPUs with minimal interruption and effort. What should you do?
- A. Update a MySQL database flag to increase the number of vCPUs.
- B. Issue a gcloud compute instances update command to increase the number of vCPUs.
- C. Back up the database, create an instance with additional vCPUs, and restore the database.
- D. Issue a gcloud sql instances patch command to increase the number of vCPUs.
正解：D
質問 # 43
You are evaluating Cloud SQL for PostgreSQL as a possible destination for your on-premises PostgreSQL instances. Geography is becoming increasingly relevant to customer privacy worldwide. Your solution must support data residency requirements and include a strategy to:
configure where data is stored
control where the encryption keys are stored
govern the access to data
What should you do?
- A. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
- B. Allow application access to data only if the users are in the same region as the Google Cloud region for the Cloud SQL for PostgreSQL database.
- C. Replicate Cloud SQL databases across different zones.
- D. Create a Cloud SQL for PostgreSQL instance on Google Cloud for the data that does not need to adhere to data residency requirements. Keep the data that must adhere to data residency requirements on-premises. Make application changes to support both databases.
正解：B
質問 # 44
You are managing a Cloud SQL for MySQL environment in Google Cloud. You have deployed a primary instance in Zone A and a read replica instance in Zone B, both in the same region. You are notified that the replica instance in Zone B was unavailable for 10 minutes. You need to ensure that the read replica instance is still working. What should you do?
- A. Use the Google Cloud Console or gcloud CLI to manually create a new clone database.
- B. Start the original primary instance and resume replication.
- C. Verify that the new replica is created automatically.
- D. Use the Google Cloud Console or gcloud CLI to manually create a new failover replica from backup.
正解：D
質問 # 45
You are running an instance of Cloud Spanner as the backend of your ecommerce website. You learn that the quality assurance (QA) team has doubled the number of their test cases. You need to create a copy of your Cloud Spanner database in a new test environment to accommodate the additional test cases. You want to follow Google-recommended practices. What should you do?
- A. Use Dataflow to run the export in text format.
- B. Use Cloud Functions to run the export in Avro format.
- C. Use Cloud Functions to run the export in text format.
- D. Use Dataflow to run the export in Avro format.
正解：D
質問 # 46
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. Enable maintenance notifications for users, and reschedule maintenance activities to a specific time after notifications have been sent.
- B. 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.
- C. Create your database with one primary node and one read replica in the region.
- D. Configure your Cloud SQL instance with high availability enabled.
正解：B
質問 # 47
Your organization is running a Firestore-backed Firebase app that serves the same top ten news stories on a daily basis to a large global audience. You want to optimize content delivery while decreasing cost and latency. What should you do?
- A. Enable serializable isolation in the Firebase app.
- B. Create a Firestore index on the news story date.
- C. Build a Firestore bundle, and deploy bundles to Cloud CDN.
- D. Deploy a US multi-region Firestore location.
正解：C
質問 # 48
Your organization is currently updating an existing corporate application that is running in another public cloud to access managed database services in Google Cloud. The application will remain in the other public cloud while the database is migrated to Google Cloud. You want to follow Google-recommended practices for authentication. You need to minimize user disruption during the migration. What should you do?
- A. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).
- B. Ask existing users to set their Google password to match their corporate password.
- C. Use workload identity federation to impersonate a service account.
- D. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
正解：A
質問 # 49
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 Bigtable, and modify your application to offload queries.
- B. Configure Memorystore, and modify your application to offload queries.
- C. Configure Firestore, and modify your application to offload queries.
- D. Configure Cloud SQL for PostgreSQL read replicas to offload queries.
正解：B
質問 # 50
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 promote-replica <ReplicaInstanceName>.
- B. Use gcloud sql instances failover <ReplicaInstanceName>.
- C. Use gcloud sql instances failover <PrimaryInstanceName>.
- D. Use gcloud sql instances promote-replica <PrimaryInstanceName>.
正解：A
質問 # 51
You are managing a small Cloud SQL instance for developers to do testing. The instance is not critical and has a recovery point objective (RPO) of several days. You want to minimize ongoing costs for this instance. What should you do?
- A. Take one manual backup per day, and turn off transaction log retention.
- B. Turn on automated backup, and turn on transaction log retention.
- C. Take no backups, and turn off transaction log retention.
- D. Turn on automated backup, and turn off transaction log retention.
正解：A
質問 # 52
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. Shut down the database before the Data Migration Service task is started.
- B. Ensure that pglogical is installed on the source PostgreSQL database.
- C. Ensure that all PostgreSQL tables have a primary key.
- D. Disable all foreign key constraints on the source PostgreSQL database.
- E. Drop or disable all users except database administration users.
正解：B、D
質問 # 53
......
Google Professional-Cloud-Database-Engineer試験は、Google Cloudが提供する認定試験であり、Google Cloud Platform上でスケーラブルで高可用性のデータベースソリューションを設計、構築、管理する能力を証明したい個人向けのものです。この認定試験は、移行、メンテナンス、設定、最適化を含むデータベース操作を実行するために必要なスキルと知識を認証します。
Fast2test Professional-Cloud-Database-Engineer試験練習テスト問題：https://jp.fast2test.com/Professional-Cloud-Database-Engineer-premium-file.html
Professional-Cloud-Database-Engineer試験問題解答：https://drive.google.com/open?id=1EZ6bFdxx24M0URMtz3THQpi0is3U-m7O