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 organization runs multiple Cloud SQL for PostgreSQL instances storing cardholder data regulated by PCI DSS. To meet security and compliance standards, you must implement the following requirements:
Which set of configurations should you implement?
This option enforces basic SSL encryption, turns on VPC Firewall Rules Logging for network traffic inspection, attempts to manually enable Admin Activity audit logs, and assigns the Certificate Manager Viewer (roles/certificatemanager.viewer) role to the auditor.
log_connections flag.roles/certificatemanager.viewer role grants read-only access to Certificate Manager resources, not Cloud Audit Logs.roles/logging.privateLogViewer.The goal was solely to audit network-level firewall traffic entering a VPC and allow a compliance user to inspect TLS certificate inventory in Certificate Manager rather than database audit logs.
This approach sets up DNS Certification Authority Authorization (CAA) records, enables Data Access audit logs with field-level access controls for analysis in Observability Analytics, and creates a Cloud Monitoring dashboard to visualize configuration events.
log_connections flag for invalid login attempts and does not grant roles/logging.privateLogViewer to the auditor.pki.goog or letsencrypt.org), not internal Cloud SQL client-certificate enforcement.LogEntry fields (such as PII) but disable Observability Analytics on that log bucket.You were securing public web domains against unauthorized public CA issuance and building a visual dashboard rather than enforcing Cloud SQL mTLS, automated alerting, and Observability Analytics.
This configuration enables basic SSL/TLS encryption in transit, relies on the default Cloud Audit Logs behavior, logs PostgreSQL checkpoint operations via log_checkpoints, and grants the standard Logs Viewer (roles/logging.viewer) IAM role.
log_checkpoints flag records database checkpoint statistics rather than authentication events. Capturing invalid logical access attempts requires enabling the log_connections flag.roles/logging.viewer role grants read access to Admin Activity and System Event logs, but it does not allow viewing Data Access audit logs.roles/logging.privateLogViewer) role.The organization only needed server-side SSL encryption without client certificate authentication, did not require Data Access audit logs, and only wanted the auditor to inspect Admin Activity logs.
This solution combines mutual TLS (mTLS) enforcement in Cloud SQL with comprehensive Cloud Audit Logs, database-level connection logging, automated log-based alerting, and least-privilege IAM auditing permissions to satisfy strict regulatory controls such as PCI DSS.
log_connections flag logs all connection attempts, including invalid logical access attempts.roles/logging.privateLogViewer allows the compliance auditor to inspect both Admin Activity and Data Access audit logs without granting administrative privileges.Unlike passive dashboards or network-only logging, this approach directly enforces certificate-based database authentication, captures database-level login failures, and ensures auditors have the exact IAM role required to review sensitive Data Access audit logs.
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