2024年最新のに更新された検証済みのProfessional-Cloud-Database-Engineer問題集と解答で合格保証もしくは全額返金 [Q36-Q53]

4.4/5 - (5 votes)

2024年最新のに更新された検証済みのProfessional-Cloud-Database-Engineer問題集と解答で合格保証もしくは全額返金

Professional-Cloud-Database-EngineerのPDF問題とテストエンジンには134問があります

試験の準備には、受験者は、Google Cloudが提供するオンラインコース、ドキュメント、練習問題などの様々なリソースを利用することができます。彼らはまた、インストラクター主導のトレーニングに参加したり、他の専門家から学んだりするために勉強グループに参加することもできます。

Google Professional-Cloud-Database-Engineer認定試験を受験するには、少なくとも3年間のクラウドプラットフォーム上でのデータベース管理の経験、Google Cloud上でのデータベース設計と実装の経験のうち1年以上が必要です。また、SQL、NoSQL、データベース管理システムなどのデータベースの概念と技術を理解している必要があります。さらに、Cloud SQL、Cloud Spanner、Cloud Bigtableなどのデータベースに関連するGoogle Cloud Platformサービスを実践的に使用した経験がある必要があります。

Google Professional-Cloud-Database-Engineer 試験は、複数選択肢とシナリオに基づく質問から構成され、GCP データベースサービスについての徹底的な理解が必要です。この試験は、実世界のシナリオで GCP データベースを設計、開発、管理する能力をテストするように設計されています。試験はオンラインで実施され、受験者には2時間の時間制限が与えられます。試験の合格スコアは70％であり、認定は2年間有効です。

新問題 36
You are migrating your data center to Google Cloud. You plan to migrate your applications to Compute Engine and your Oracle databases to Bare Metal Solution for Oracle. You must ensure that the applications in different projects can communicate securely and efficiently with the Oracle databases. What should you do?

Set up a Shared VPC, configure multiple service projects, and create firewall rules.

Set up Serverless VPC Access.

Set up Private Service Connect.

Set up Traffic Director.

新問題 37
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?

Create a clone database from a read replica database, and restore the clone in the same region.

Create a clone database from a read replica database, and restore the clone into a different zone.

Use the Cloud SQL point-in-time recovery (PITR) feature. Restore the copy from two hours ago to a new database instance.

Use the Cloud SQL database import feature. Import last week’s dump file from Cloud Storage.

新問題 38
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?

Use external server replication.

Use Data Migration Service.

Use Cloud SQL for MySQL external replica.

Use the mysqldump utility and binary logs.

新問題 39
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?

Use workload identity federation to impersonate a service account.

Ask existing users to set their Google password to match their corporate password.

Migrate the application to Google Cloud, and use Identity and Access Management (IAM).

Use Google Workspace Password Sync to replicate passwords into Google Cloud.

新問題 40
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

新問題 41
Your organization stores marketing data such as customer preferences and purchase history on Bigtable. The consumers of this database are predominantly data analysts and operations users. You receive a service ticket from the database operations department citing poor database performance between 9 AM-10 AM every day. The application team has confirmed no latency from their logs. A new cohort of pilot users that is testing a dataset loaded from a third-party data provider is experiencing poor database performance. Other users are not affected. You need to troubleshoot the issue. What should you do?

Isolate the data analysts and operations user groups to use different Bigtable instances.

Check the Cloud Monitoring table/bytes_used metric from Bigtable.

Use Key Visualizer for Bigtable.

Add more nodes to the Bigtable cluster.

新問題 42
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?

Use a Cloud Function to pull CPU and memory metrics from your Cloud SQL instance and to call a custom service to send alerts.

Use Error Reporting to monitor CPU and memory metrics and to configure SMS notification channels.

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.

Use Cloud Monitoring to set up an alerting policy for CPU and memory metrics and to configure SMS notification channels.

新問題 43
Your organization has hundreds of Cloud SQL for MySQL instances. You want to follow Google-recommended practices to optimize platform costs. What should you do?

Use Query Insights to identify idle instances.

Remove inactive user accounts.

Run the Recommender API to identify overprovisioned instances.

Build indexes on heavily accessed tables.

新問題 44
You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to follow Google-recommended practices to minimize performance impact on the currently running instance. What should you do?

Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.

Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.

Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.

Create a CSV file by running the SQL statement SELECT…INTO OUTFILE, copy the file to a Cloud Storage bucket, and import it into a new instance.

新問題 45
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?

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).

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.

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

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

新問題 46
You use Python scripts to generate weekly SQL reports to assess the state of your databases and determine whether you need to reorganize tables or run statistics. You want to automate this report but need to minimize operational costs and overhead. What should you do?

Create a VM in Compute Engine, and run a cron job.

Create a Cloud Composer instance, and create a directed acyclic graph (DAG).

Create a Cloud Function, and call the Cloud Function using Cloud Scheduler.

Create a Cloud Function, and call the Cloud Function from a Cloud Tasks queue.

新問題 47
You want to migrate an existing on-premises application to Google Cloud. Your application supports semi-structured data ingested from 100,000 sensors, and each sensor sends 10 readings per second from manufacturing plants. You need to make this data available for real-time monitoring and analysis. What should you do?

Deploy the database using Cloud SQL.

Use BigQuery, and load data in batches.

C.Deploy the database using Bigtable.

Deploy the database using Cloud Spanner.

新問題 48
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?

Use replication to roll out changes to higher environments.

Use backup and restore to roll out changes to higher environments.

Use Liquibase to roll out changes to higher environments.

Manually capture detailed DBA audit logs when changes are rolled out to higher environments.

新問題 49
Your team recently released a new version of a highly consumed application to accommodate additional user traffic. Shortly after the release, you received an alert from your production monitoring team that there is consistently high replication lag between your primary instance and the read replicas of your Cloud SQL for MySQL instances. You need to resolve the replication lag. What should you do?

Identify and optimize slow running queries, or set parallel replication flags.

Stop all running queries, and re-create the replicas.

Edit the primary instance to upgrade to a larger disk, and increase vCPU count.

Edit the primary instance to add additional memory.

新問題 50
Your company is using Cloud SQL for MySQL with an internal (private) IP address and wants to replicate some tables into BigQuery in near-real time for analytics and machine learning. You need to ensure that replication is fast and reliable and uses Google-managed services. What should you do?

Develop a custom data replication service to send data into BigQuery.

Use Cloud SQL federated queries.

Use Database Migration Service to replicate tables into BigQuery.

Use Datastream to capture changes, and use Dataflow to write those changes to BigQuery.

新問題 51
You are managing a mission-critical Cloud SQL for PostgreSQL instance. Your application team is running important transactions on the database when another DBA starts an on-demand backup. You want to verify the status of the backup. What should you do?

Check the cloudsql.googleapis.com/postgres.log instance log.

Perform the gcloud sql operations list command.

Use Cloud Audit Logs to verify the status.

Use the Google Cloud Console.

新問題 52
Your organization has a critical business app that is running with a Cloud SQL for MySQL backend database. Your company wants to build the most fault-tolerant and highly available solution possible. You need to ensure that the application database can survive a zonal and regional failure with a primary region of us-central1 and the backup region of us-east1. What should you do?

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-west1-b.
Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-central1-b.
Create a read replica in us-east1-b.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east-b.
Create a read replica in us-east1-c.

Provision a Cloud SQL for MySQL instance in us-central1-a.
Create a multiple-zone instance in us-east1-b.
Create a read replica in us-central1-b.

新問題 53
You are troubleshooting a connection issue with a newly deployed Cloud SQL instance on Google Cloud. While investigating the Cloud SQL Proxy logs, you see the message Error 403: Access Not Configured. What should you do?

Check the app.yaml value cloud_sql_instances for a misspelled or incorrect instance connection name.

Check whether your service account has cloudsql.instances.connect permission.

Enable the Cloud SQL Admin API.

Ensure that you are using an external (public) IP address interface.