Professional-Cloud-Database-EngineerのPDF問題集で2024年12月25日試験問題 有効なProfessional-Cloud-Database-Engineer問題集
究極のProfessional-Cloud-Database-Engineer準備ガイドで無料最新のGoogle練習テスト問題集
この試験は、GCPデータベースの操作経験があり、データベース設計の原則、データモデリング、およびデータベースセキュリティに精通している個人を対象としています。候補者は、Java、Python、GoなどのSQLおよびプログラミング言語の経験があると予想されます。認定試験は、GCPでデータベースソリューションを設計、実装、および管理する候補者の能力をテストする複数選択の質問と実用的なシナリオで構成されています。成功した候補者は、Google Cloud Certified -Professional Cloud Database Engineer認定を受け取ります。これは、GCPデータベースエンジニアリングの分野での専門知識のデモンストレーションとして認識されています。
質問 # 22
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 splitting the Bigtable instance into two instances in order to load balance the concurrent reads.
- B. Recommend solid-state drives (SSD).
- C. Recommend mixed storage types.
- D. Recommend hard disk drives (HDD).
正解：A
質問 # 23
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. Use Memorystore to handle your low-latency requirements and for real-time analytics.
- B. 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.
- C. Write your data into Bigtable and use Dataproc and the Apache Hbase libraries for analysis.
- D. Stream your data into BigQuery and use Dataproc and the BigQuery Storage API to analyze large volumes of data.
正解：C
解説：
Start with the lowest tier and smallest size and then grow your instance as needed. Memorystore provides automated scaling using APIs, and optimized node placement across zones for redundancy. Memorystore for Memcached can support clusters as large as 5 TB, enabling millions of QPS at very low latency
質問 # 24
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 the Cloud Monitoring dashboard with available metrics from Cloud SQL.
- B. Use log messages produced by Cloud SQL.
- C. Use Query Insights for Cloud SQL.
- D. Use Cloud SQL instance monitoring in the Google Cloud Console.
正解：A
質問 # 25
Your company uses Cloud Spanner for a mission-critical inventory management system that is globally available. You recently loaded stock keeping unit (SKU) and product catalog data from a company acquisition and observed hot-spots in the Cloud Spanner database. You want to follow Google-recommended schema design practices to avoid performance degradation. What should you do? (Choose two.)
- A. Promote high-cardinality attributes in multi-attribute primary keys.
- B. Use bit-reverse sequential value as the primary key.
- C. Normalize the data model.
- D. Use an auto-incrementing value as the primary key.
- E. Promote low-cardinality attributes in multi-attribute primary keys.
正解：A、D
質問 # 26
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 <PrimaryInstanceName>.
- B. Use gcloud sql instances promote-replica <ReplicaInstanceName>.
- C. Use gcloud sql instances failover <PrimaryInstanceName>.
- D. Use gcloud sql instances failover <ReplicaInstanceName>.
正解：C
質問 # 27
You are designing a database strategy for a new web application. You plan to start with a small pilot in one country and eventually expand to millions of users in a global audience. You need to ensure that the application can run 24/7 with minimal downtime for maintenance. What should you do?
- A. Use Cloud Spanner in a multi-region configuration.
- B. Use Cloud SQL with cross-region replicas.
- C. Use highly available Cloud SQL with multiple zones.
- D. Use Cloud Spanner in a regional configuration.
正解：D
質問 # 28
You finished migrating an on-premises MySQL database to Cloud SQL. You want to ensure that the daily export of a table, which was previously a cron job running on the database server, continues. You want the solution to minimize cost and operations overhead. What should you do?
- A. Create a streaming Datatlow job to export the table.
- B. Run the cron job on a Compute Engine instance to continue the export.
- C. Set up Cloud Composer, and create a task to export the table daily.
- D. Use Cloud Scheduler and Cloud Functions to run the daily export.
正解：C
質問 # 29
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?
- A. Create and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to another.
- B. Create two Datastream connection profiles, and use them to create a stream from one Cloud SQL instance to another.
- C. 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.
- D. Create a SQL dump file in Cloud Storage using a temporary instance, and then use that file to import into a new instance.
正解：D
質問 # 30
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 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. - B. 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. - C. 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. - 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.
正解：B
解説：
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.
質問 # 31
Your organization is running a low-latency reporting application on Microsoft SQL Server. In addition to the database engine, you are using SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in your on-premises environment. You want to migrate your Microsoft SQL Server database instances to Google Cloud. You need to ensure minimal disruption to the existing architecture during migration. What should you do?
- A. Migrate to Google Kubernetes Engine (GKE).
- B. Migrate to Cloud SQL for PostgreSQL.
- C. Migrate to Compute Engine.
- D. Migrate to Cloud SQL for SQL Server.
正解：C
解説：
https://cloud.google.com/sql/docs/sqlserver/features
質問 # 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 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 - B. 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 - 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 us-central1-b
cluster-c in zone us-east1-a
正解：A
解説：
https://cloud.google.com/bigtable/docs/replication-settings#regional-failover
質問 # 33
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. Create a new service account, and grant it the Cloud Spanner Database Reader role.
- B. Reuse the existing service account that populates this database.
- C. Create a new service account, and grant it the Cloud Spanner Database Admin role.
- D. Create a new service account, and grant it the spanner.databases.select permission.
正解：C
質問 # 34
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?
- A. 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).
- B. Create a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 4 TB of SSD.
- C. Create a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of RAM, and 500 GB of SSD.
- D. 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.
正解：B
解説：
Given that Google SSD performance is related to the size of the disk in an order of 30 IOPS for each GB, ti would require at least 833 GB to handle 25000 IOPS, the only answer that exceeds this value is C. https://cloud.google.com/compute/docs/disks/performance
質問 # 35
You are running a mission-critical application on a Cloud SQL for PostgreSQL database with a multi-zonal setup. The primary and read replica instances are in the same region but in different zones. You need to ensure that you split the application load between both instances. What should you do?
- A. Use PgBouncer to set up database connection pooling between the Cloud SQL primary and read replica instances.
- B. Use the Cloud SQL Auth proxy for database connection pooling between the Cloud SQL primary and read replica instances.
- C. Use HTTP(S) Load Balancing for database connection pooling between the Cloud SQL primary and read replica instances.
- D. Use Cloud Load Balancing for load balancing between the Cloud SQL primary and read replica instances.
正解：A
質問 # 36
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 Firestore.
- B. Use Cloud SQL with an external (public) IP address.
- C. Use Cloud Spanner.
- D. Use an in-app embedded database.
正解：B
質問 # 37
Your application uses Cloud SQL for MySQL. Your users run reports on data that relies on near-real time; however, the additional analytics caused excessive load on the primary database. You created a read replica for the analytics workloads, but now your users are complaining about the lag in data changes and that their reports are still slow. You need to improve the report performance and shorten the lag in data replication without making changes to the current reports. Which two approaches should you implement? (Choose two.)
- A. Create additional read replicas, and partition your analytics users to use different read replicas.
- B. Disable replication on the primary instance, and set the flag for parallel replication on the primary instance. Re-enable replication and optimize performance by setting flags on the read replica.
- C. Create secondary indexes on the replica.
- D. Move your analytics workloads to BigQuery, and set up a streaming pipeline to move data and update BigQuery.
- E. Disable replication on the read replica, and set the flag for parallel replication on the read replica. Re-enable replication and optimize performance by setting flags on the primary instance.
正解：A、D
質問 # 38
You are designing a database strategy for a new web application in one region. You need to minimize write latency. What should you do?
- A. Use high availability (HA) Cloud SQL with multiple zones.
- B. Use Cloud SQL with cross-region replicas.
- C. Use Cloud Spanner in a regional configuration.
- D. Use zonal Cloud SQL without high availability (HA).
正解：B
質問 # 39
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?
- A. Set up Private Service Connect.
- B. Set up Serverless VPC Access.
- C. Set up Traffic Director.
- D. Set up a Shared VPC, configure multiple service projects, and create firewall rules.
正解：D
解説：
https://medium.com/google-cloud/shared-vpc-in-google-cloud-64527e0a409e#:~:text=Unlike%20VPC%20peering%2C%20Shared%20VPC%20connects%20projects%20within%20the%20same%20organization.&text=There%20are%20a%20lot%20of,between%20VPCs%20in%20different%20projects.
質問 # 40
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 Bigtable with default encryption.
- C. Use Cloud Spanner with a customer-managed encryption key (CMEK).
- D. Use Cloud Spanner with default encryption.
正解：A
質問 # 41
......
この試験では、データベースの設計、データモデリング、データベース管理、データのバックアップと回復、パフォーマンスの調整など、データベース管理に関連する幅広いトピックをカバーしています。候補者は、クラウドSQL、クラウドスパナ、BigtableなどのさまざまなGoogleクラウドツールやサービスを使用する機能についてもテストされています。
合格率 取得する秘訣はProfessional-Cloud-Database-Engineer認定試験エンジンPDF：https://www.goshiken.com/Google/Professional-Cloud-Database-Engineer-mondaishu.html
今すぐ試そう！高評価Google Professional-Cloud-Database-Engineer試験問題集：https://drive.google.com/open?id=1axklgxB1KRzFUL0O-mDrjwBRvj7cWpqV