• ホーム
  • ブログ
  • [2024年08月]更新のProfessional-Cloud-Database-Engineer問題集本日限定！無料アクセス可能に！PassTestで試そう [Q30-Q53]

[2024年08月]更新のProfessional-Cloud-Database-Engineer問題集本日限定！無料アクセス可能に！PassTestで試そう [Q30-Q53]

Share

[2024年08月]更新のProfessional-Cloud-Database-Engineer問題集本日限定！無料アクセス可能に！PassTestで試そう

学習材料は有効Professional-Cloud-Database-Engineer効率的問題集！


Google Professional-Cloud-Database-Enginer試験は、Google Cloudプラットフォームを使用してクラウドベースのデータベースソリューションの設計、開発、管理における個人の知識とスキルをテストするGoogle Cloudが提供する認定試験です。この認定は、データベース管理、データベース開発、クラウドコンピューティングの経験がある個人向けに設計されています。


Google Professional-Cloud-Database-Enginer認定試験の対象となるには、候補者はGoogle Cloudプラットフォームでデータベースの設計と管理の経験が必要です。また、データモデリング、データベース設計、SQL、およびその他のデータベース管理の概念を深く理解する必要があります。

 

質問 # 30
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

  • A. Use Cloud SQL with an external (public) IP address.
  • B. Use Cloud Spanner.
  • C. Use Firestore.
  • D. Use an in-app embedded database.

正解：C

解説：
https://firebase.google.com/docs/firestore


質問 # 31
Your company uses Bigtable for a user-facing application that displays a low-latency real-time dashboard. You need to recommend the optimal storage type for this read-intensive database. What should you do?

  • A. Recommend solid-state drives (SSD).
  • B. Recommend hard disk drives (HDD).
  • C. Recommend mixed storage types.
  • D. Recommend splitting the Bigtable instance into two instances in order to load balance the concurrent reads.

正解：D


質問 # 32
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 europe-west1-d
    cluster-c in zone asia-east1-b
  • B. 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
  • C. 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
  • D. 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

正解：D


質問 # 33
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. Turn on automated backup, and turn off transaction log retention.
  • B. Take one manual backup per day, and turn off transaction log retention.
  • C. Take no backups, and turn off transaction log retention.
  • D. Turn on automated backup, and turn on transaction log retention.

正解：A

解説：
https://cloud.google.com/sql/docs/mysql/backup-recovery/backups


質問 # 34
You are building an Android game that needs to store data on a Google Cloud serverless database. The database will log user activity, store user preferences, and receive in-game updates. The target audience resides in developing countries that have intermittent internet connectivity. You need to ensure that the game can synchronize game data to the backend database whenever an internet network is available. What should you do?

  • A. Use Cloud SQL with an external (public) IP address.
  • B. Use Cloud Spanner.
  • C. Use an in-app embedded database.
  • D. Use Firestore.

正解：A


質問 # 35
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 external (public) IP address of your Cloud SQL instance.
  • C. Define a connection string using a database username and password to point to the internal (private) IP address of your Cloud SQL instance.
  • D. 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.

正解：D

解説：
The Cloud SQL connectors are libraries that provide encryption and IAM-based authorization when connecting to a Cloud SQL instance. They can't provide a network path to a Cloud SQL instance if one is not already present. Other ways to connect to a Cloud SQL instance include using a database client or the Cloud SQL Auth proxy. https://cloud.google.com/sql/docs/postgres/connect-connectors https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory/blob/main/docs/jdbc-postgres.md


質問 # 36
Your organization operates in a highly regulated industry. Separation of concerns (SoC) and security principle of least privilege (PoLP) are critical. The operations team consists of:
Person A is a database administrator.
Person B is an analyst who generates metric reports.
Application C is responsible for automatic backups.
You need to assign roles to team members for Cloud Spanner. Which roles should you assign?

  • A. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseUser for Person B
    roles/spanner.backupWriter for Application C
  • B. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseUser for Person B
    roles/spanner databaseReader for Application C
  • C. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseReader for Person B
    roles/spanner.backupAdmin for Application C
  • D. roles/spanner.databaseAdmin for Person A
    roles/spanner.databaseReader for Person B
    roles/spanner.backupWriter for Application C

正解：C


質問 # 37
You are the DBA of an online tutoring application that runs on a Cloud SQL for PostgreSQL database. You are testing the implementation of the cross-regional failover configuration. The database in region R1 fails over successfully to region R2, and the database becomes available for the application to process dat a. During testing, certain scenarios of the application work as expected in region R2, but a few scenarios fail with database errors. The application-related database queries, when executed in isolation from Cloud SQL for PostgreSQL in region R2, work as expected. The application performs completely as expected when the database fails back to region R1. You need to identify the cause of the database errors in region R2. What should you do?

  • A. Determine whether the database patches of Cloud SQI for PostgreSQL in regions R1 and R2 are different.
  • B. Determine whether Cloud SQL for PostgreSQL in region R2 is a near-real-time copy of region R1 but not an exact copy.
  • C. Determine whether the versions of Cloud SQL for PostgreSQL in regions R1 and R2 are different.
  • D. Determine whether the failover of Cloud SQL for PostgreSQL from region R1 to region R2 is in progress or has completed successfully.

正解：B

解説：
Verify that the replica has processed all the transactions it has received from the primary. This ensures that when promoted, the replica reflects all transactions that were received before the primary became unavailable. https://cloud.google.com/sql/docs/postgres/replication/cross-region-replicas#verify_failover_criteria


質問 # 38
Your company wants to migrate an Oracle-based application to Google Cloud. The application team currently uses Oracle Recovery Manager (RMAN) to back up the database to tape for long-term retention (LTR). You need a cost-effective backup and restore solution that meets a 2-hour recovery time objective (RTO) and a 15-minute recovery point objective (RPO). What should you do?

  • A. Migrate the Oracle databases to Compute Engine, and store backups on tapes on-premises.
  • B. Migrate the Oracle databases to Bare Metal Solution for Oracle, and back up the Oracle databases to Cloud Storage using the Standard Storage class.
  • C. Migrate the Oracle databases to Bare Metal Solution for Oracle, and store backups on tapes on-premises.
  • D. Migrate the Oracle databases to Bare Metal Solution for Oracle, and use Actifio to store backup files on Cloud Storage using the Nearline Storage class.

正解：D

解説：
https://www.actifio.com/solutions/cloud/google/


質問 # 39
You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:
Can read tables, views, and DDL
Can write rows to the tables
Can add columns and indexes
Cannot drop the database
What should you do?

  • A. Assign the Cloud Spanner Database Admin role.
  • B. Assign the Cloud Spanner Database User role.
  • C. Assign the Cloud Spanner Admin role.
  • D. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.

正解：B


質問 # 40
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 Oracle Real Application Cluster (RAC) databases on Bare Metal Solution for Oracle.
  • B. Use Cloud Spanner with a custom autoscaling solution.
  • C. Use a Biglable cluster with autoscaling.
  • D. Use sharded Cloud SQL instances with one or more stores per database instance.

正解：B

解説：
https://cloud.google.com/spanner/docs/autoscaling-overview
1. CloudSQL max out at 64TB, so unable to told 100TB of data. https://cloud.google.com/sql/docs/quotas#metrics_collection_limit 2. Scale is done manually on SQL Cloud


質問 # 41
Your organization needs to migrate a critical, on-premises MySQL database to Cloud SQL for MySQL. The on-premises database is on a version of MySQL that is supported by Cloud SQL and uses the InnoDB storage engine. You need to migrate the database while preserving transactions and minimizing downtime. What should you do?

  • A. Pause the on-premises applications.
    Use the mysqldump utility to dump the database content in CSV format.
    Run gsutil -m to move the dump file to Cloud Storage.
    Use the Cloud SQL for MySQL import option.
    After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
  • B. Pause the on-premises applications.
    Use the mysqldump utility to dump the database content in compressed format.
    Run gsutil -m to move the dump file to Cloud Storage.
    Use the Cloud SQL for MySQL import option.
    After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.
  • C. Use Database Migration Service to connect to your on-premises database, and choose continuous replication.
    After the on-premises database is migrated, promote the Cloud SQL for MySQL instance, and connect applications to your Cloud SQL instance.
  • D. Build a Cloud Data Fusion pipeline for each table to migrate data from the on-premises MySQL database to Cloud SQL for MySQL.
    Schedule downtime to run each Cloud Data Fusion pipeline.
    Verify that the migration was successful.
    Re-point the applications to the Cloud SQL for MySQL instance.

正解：C

解説：
https://cloud.google.com/database-migration/docs/mysql/configure-source-database To migrate the database while preserving transactions and minimizing downtime, you should use Database Migration Service. This service will allow you to migrate the database in a way that is transparent to your users and applications. It will also allow you to test the migration before you make it live, so that you can be sure that everything will work as expected.


質問 # 42
You need to migrate a 1 TB PostgreSQL database from a Compute Engine VM to Cloud SQL for PostgreSQL. You want to ensure that there is minimal downtime during the migration. What should you do?

  • A. Use Datastream to complete the migration.
  • B. Use Migrate for Compute Engine to complete the migration.
  • C. Export the data from the existing database, and load the data into a new Cloud SQL database.
  • D. Use Database Migration Service to complete the migration.

正解：C


質問 # 43
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. Bring DB-1 back online.
  • C. Create DB-4 as a read replica in the same region as DB-1, and promote DB-4 to primary.
  • D. Delete DB-2 so that DB-1 automatically reverts to the primary instance.

正解：C

解説：
If you need to have the primary instance in the zone that had the outage, you can do a failback. A failback performs the same steps as the failover, only in the opposite direction, to reroute traffic back to the original instance. To perform a failback, use the procedure in Initiating failover. https://cloud.google.com/sql/docs/mysql/high-availability#failback


質問 # 44
Your organization works with sensitive data that requires you to manage your own encryption keys. You are working on a project that stores that data in a Cloud SQL database. You need to ensure that stored data is encrypted with your keys. What should you do?

  • A. Export data periodically to a Cloud Storage bucket protected by Customer-Supplied Encryption Keys.
  • B. Use customer-managed encryption keys with Cloud SQL.
  • C. Connect to Cloud SQL using a connection that has SSL encryption.
  • D. Use Cloud SQL Auth proxy.

正解：C


質問 # 45
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. 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.
  • C. Create a Cloud Scheduler job to start maintenance at 12 AM on Sundays. Pause the Cloud Scheduler job 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.

正解：A


質問 # 46
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 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. 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. 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.
  • D. 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.

正解：B


質問 # 47
You released a popular mobile game and are using a 50 TB Cloud Spanner instance to store game data in a PITR-enabled production environment. When you analyzed the game statistics, you realized that some players are exploiting a loophole to gather more points to get on the leaderboard. Another DBA accidentally ran an emergency bugfix script that corrupted some of the data in the production environment. You need to determine the extent of the data corruption and restore the production environment. What should you do? (Choose two.)

  • A. If the corruption is insignificant, perform a stale read and specify a recovery timestamp. Write the results back.
  • B. If the corruption is significant, perform a stale read and specify a recovery timestamp. Write the results back.
  • C. If the corruption is significant, use import and export.
  • D. If the corruption is significant, use backup and restore, and specify a recovery timestamp.
  • E. If the corruption is insignificant, use backup and restore, and specify a recovery timestamp.

正解：A、B


質問 # 48
You are managing multiple applications connecting to a database on Cloud SQL for PostgreSQL. You need to be able to monitor database performance to easily identify applications with long-running and resource-intensive queries. What should you do?

  • A. Use log messages produced by Cloud SQL.
  • B. Use Query Insights for Cloud SQL.
  • C. Use the Cloud Monitoring dashboard with available metrics from Cloud SQL.
  • D. Use Cloud SQL instance monitoring in the Google Cloud Console.

正解：B

解説：
https://cloud.google.com/sql/docs/mysql/using-query-insights#introduction


質問 # 49
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. Normalize the database to the third normal form.
  • B. Compress the data using a different compression algorithm.
  • C. Manually or automatically increase the storage capacity.
  • D. Create another schema to load older data.

正解：C

解説：
https://cloud.google.com/sql/docs/mysql/instance-settings#storage-capacity-2ndgen


質問 # 50
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. Use Google Workspace Password Sync to replicate passwords into Google Cloud.
  • 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. Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

正解：C

解説：
Updating passwords represents user disruption. Eliminate B. Eliminate C for the same reason. D doesn't make sense, leaves A. From Google's documentation, "Traditionally, applications running outside Google Cloud can use service account keys to access Google Cloud resources. However, service account keys are powerful credentials, and can present a security risk if they are not managed correctly. With identity federation, you can use Identity and Access Management (IAM) to grant external identities IAM roles, including the ability to impersonate service accounts. This approach eliminates the maintenance and security burden associated with service account keys." https://cloud.google.com/iam/docs/workload-identity-federation


質問 # 51
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 Cloud SQL for MySQL
  • B. Use Bigtable.
  • C. Use Cloud Spanner.
  • D. Use Firestore.

正解：C

解説：
Spanner covers the SLA


質問 # 52
Your ecommerce application connecting to your Cloud SQL for SQL Server is expected to have additional traffic due to the holiday weekend. You want to follow Google-recommended practices to set up alerts for CPU and memory metrics so you can be notified by text message at the first sign of potential issues. What should you do?

  • A. Use Cloud Logging to set up a log sink for CPU and memory metrics and to configure a sink destination to send a message to Pub/Sub.
  • B. Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.
  • C. Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.
  • D. Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

正解：B


質問 # 53
......

最新のProfessional-Cloud-Database-Engineer試験エンジンPDFで全部無料問題集保証：https://www.passtest.jp/Google/Professional-Cloud-Database-Engineer-shiken.html

最新Google Cloud Certified Professional-Cloud-Database-Engineer実際の無料試験解答：https://drive.google.com/open?id=1KBzFVfDjv_8Nx_iplJIYYky5zsBZJ35M

関するブログ

もっと
Professional-Cloud-Database-Engineer 無料問題集