Google Professional-Cloud-Database-Engineer 試験概要:
| 認定ベンダー: | Google Cloud |
|---|---|
| 試験名: | Professional Cloud Database Engineer |
| 試験番号: | Professional-Cloud-Database-Engineer |
| 試験形式: | 選択式(複数選択), 選択式(単一選択), シナリオベース問題 |
| 対応言語: | English |
| 関連資格: | Google Cloud Certified - Professional Cloud Data Engineer Google Cloud Certified - Associate Cloud Engineer |
| 受験料: | 200米ドル(該当する場合は別途消費税などが発生) |
| 認定の有効期間: | 2年間 |
| 出題数: | 50-60 |
| 合格点: | 非公開(合否判定のスケールドスコア方式) |
| 試験時間: | 120 分 |
| 推奨トレーニング: | Google Cloud データベースドキュメント Google Cloud Skills Boost - Database Engineer ラーニングパス |
| 受験申し込み: | Google Cloud 認定資格公式ポータル Cloud Database Engineer 認定資格ページ |
| サンプル問題: | Google Professional-Cloud-Database-Engineer サンプル問題 |
| 受験方法: | オンライン監視型試験または試験会場での対面試験 |
| 前提条件: | 必須の前提条件はありません。推奨:5年以上のデータベース/IT経験(うち2年以上のGoogle Cloudデータベース経験を含む)。 |
| 公式シラバスのURL: | https://cloud.google.com/learn/certification/cloud-database-engineer |
Google Professional-Cloud-Database-Engineer 認定試験の出題範囲:
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
参照:https://cloud.google.com/certification/cloud-database-engineer
Google Cloud Certified - Professional Cloud Database Engineer 認定 Professional-Cloud-Database-Engineer 試験問題:
問題 #1
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.databaseReader for Person B
roles/spanner.backupWriter for Application C
B. roles/spanner.databaseAdmin for Person A
roles/spanner.databaseUser for Person B
roles/spanner.backupWriter 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.databaseUser for Person B
roles/spanner databaseReader for Application C
問題 #2
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. Replicate Cloud SQL databases across different zones.
B. 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.
C. 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.
D. Use features like customer-managed encryption keys (CMEK), VPC Service Controls, and Identity and Access Management (IAM) policies.
問題 #3
You are designing a highly available (HA) Cloud SQL for PostgreSQL instance that will be used by 100 databases. Each database contains 80 tables that were migrated from your on-premises environment to Google Cloud. The applications that use these databases are located in multiple regions in the US, and you need to ensure that read and write operations have low latency. What should you do?
A. Deploy 4 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-central1, us-east1, and us-west1.
B. Deploy 2 Cloud SQL instances in the us-central1 region with HA enabled, and create read replicas in us-east1 and us-west1.
C. Deploy 2 Cloud SQL instances in the us-central1 region, and create read replicas in us-east1 and us-west1.
D. Deploy 4 Cloud SQL instances in the us-central1 region, and create read replicas in us-central1, us-east1 and us-west1.
問題 #4
You are migrating your on-premises PostgreSQL database to Spanner. You need to identify a solution for handling existing integer-based table primary keys. You want minimal changes to the applications while also following Google-recommended practices. What should you do-
A. Use application generated sequential integer values as primary keys.
B. Use a UUID function that generates UUID Version 4 values as primary keys.
C. Generate values by using BIT_REVERSED_POSITIVEsequences.
D. Update default primary key values to max(primary_key) + 1.
問題 #5
You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?
A. Use Cloud SQL federated queries.
B. Use PostgreSQL database's built-in authentication.
C. Use Managed Active Directory authentication.
D. Use Identity and Access Management (IAM) authentication.
解説:
| 問題 #1 正解: A | 問題 #2 正解: D | 問題 #3 正解: A | 問題 #4 正解: C | 問題 #5 正解: D |














1203 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99%の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
