Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Professional Cloud Database Engineer practice bank has an additional 769 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
A financial services company is deploying a new Cloud SQL for PostgreSQL database to store sensitive payment card data. To satisfy strict compliance and data governance mandates, the solution must meet the following requirements:
Which configuration should the database engineer implement?
Automatic key rotation in Cloud KMS periodically generates a new primary key version to encrypt new data or new DEKs. Disabling a key version prevents it from performing any decrypt operations, while TLS 1.0 fallback allows clients to negotiate deprecated cryptographic protocols.
There is no compliant scenario where immediately disabling active previous key versions without re-encryption or allowing TLS 1.0 fallback is safe or recommended.
For software-backed keys, a 90-day rotation schedule (or 365 days for Cloud HSM keys) is recommended while keeping older key versions enabled until all dependent data is retired or re-encrypted. Simultaneously, database flags and SSL policies must strictly enforce TLS 1.2 or higher.
Customer-Managed Encryption Keys (CMEK) in Cloud Key Management Service (Cloud KMS) provide full customer ownership and lifecycle control over the Key Encryption Keys (KEKs) used in an envelope encryption model to wrap Data Encryption Keys (DEKs) protecting database storage and backups. Pairing CMEK with mandatory SSL/TLS at the database layer ensures end-to-end encryption both at rest and in transit.
ENCRYPT_DECRYPT key (GOOGLE_SYMMETRIC_ENCRYPTION) enables automatic key rotation on a defined schedule without exposing raw key material outside Cloud KMS.roles/cloudkms.cryptoKeyEncrypterDecrypter strictly to the Cloud SQL service agent ensures the database can perform cryptographic operations without granting destructive permissions.Unlike approaches that rely on Google default encryption, over-privileged roles, or weak transport protocols, this architecture applies defense-in-depth across key management, IAM, and network transport while configuring CMEK at instance creation, when managed databases require key assignment.
The global Cloud KMS location hosts keys not bound to a specific region, while roles/cloudkms.admin is a powerful administrative IAM role permitting full lifecycle management of keys, including key destruction and IAM policy changes. Leaving SSL/TLS optional allows clients inside the VPC to connect using plaintext database sessions.
global key cannot be used for regional database CMEK integration and violates data residency controls.roles/cloudkms.admin to a service agent gives it unnecessary authority to modify policies or schedule key version destruction instead of limiting it to roles/cloudkms.cryptoKeyEncrypterDecrypter.roles/cloudkms.admin grants cloudkms.cryptoKeyVersions.destroy and setIamPolicy permissions.There is no valid production scenario where a service agent should hold roles/cloudkms.admin or where a regional Cloud SQL instance can use a global CMEK key.
Best practices recommend isolating KMS keys in a centralized security project and assigning only roles/cloudkms.cryptoKeyEncrypterDecrypter to service agents.
Google default encryption automatically encrypts data at rest using Google-owned and Google-managed keys stored in Google's internal Keystore service. Media Access Control Security (MACsec) provides transparent Layer 2 encryption across Google Cloud's physical networking backbone and between VMs within a Virtual Private Cloud (VPC).
The organization had no regulatory mandate for customer-owned keys, had not yet deployed the database, and accepted Google-managed infrastructure encryption without application-level TLS enforcement.
When strict compliance frameworks govern payment card data, both CMEK (configured at creation) and mandatory database-level SSL/TLS are required to establish verifiable cryptographic boundaries.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated