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.
Your organization is migrating 20 business-critical SQL Server databases to Compute Engine and must align its availability and backup architecture with corporate governance mandates:
Which architecture and Backup and DR configuration should you implement?
This configuration establishes a multi-region hot-standby architecture paired with pre-provisioned Backup and DR appliances in the secondary region and continuous transaction log replication to Cloud Storage Coldline OnVault pools.
Send logs to OnVault Pool enabled when Coldline pools are attached forces Backup and DR to replicate logs at every 15-minute interval and perform daily metadata and expiration checks, resulting in high Cloud Storage Class A and Class B API charges and retrieval fees.This approach would be appropriate if corporate governance classified the workload as Tier 1 mission-critical with a near-zero regional RTO and RPO, and if logs were replicated strictly to Standard storage pools rather than Coldline or Archive pools.
This strategy relies on a single-zone database deployment paired with storage-level Compute Engine instant snapshots and manual restoration procedures, while enabling log replication into a Cloud Storage Archive OnVault pool.
Send logs to OnVault Pool on a resource profile containing Archive storage triggers frequent 15-minute log uploads and daily metadata checks, generating substantial Cloud Storage Class A/B operation fees and early-deletion or retrieval charges.This configuration would fit a low-criticality Tier 3 or development workload that tolerates hours of downtime during zonal outages, provided Send logs to OnVault Pool is disabled for archival buckets.
This solution combines SQL Server Always On availability groups for regional high availability with Backup and DR Service policy controls tailored to tiered Recovery Point Objective (RPO), Recovery Time Objective (RTO), and cost-control mandates. It separates fast zonal failover from cost-optimized regional disaster recovery and archival storage.
Enable Database Log Backup to Yes with a 15-minute RPO enables granular point-in-time recovery (PITR) from local snapshot pools. Setting Send logs to OnVault Pool to No for Coldline and Archive pools prevents the appliance from replicating logs every 15 minutes and running daily metadata reads across archival buckets.Unlike cross-region hot-standby deployments, this design avoids continuous secondary compute, licensing, and cross-region network overhead while still enforcing strict zonal resilience and preventing Backup and DR archival billing spikes.
This option correctly uses an Always On availability group across two zones for high availability, but configures Backup and DR to replicate logs to a shared Coldline and Archive profile while scheduling all 20 database snapshot jobs at the exact same time.
Send logs to OnVault Pool to Yes on a resource profile with Coldline and Archive pools causes Backup and DR to push transaction logs every 15 minutes and run daily metadata reads across every attached pool, creating high Cloud Storage Class A/B operation charges and retrieval fees.Send logs to OnVault Pool must be set to No.This approach would only work if snapshot schedules were staggered across time windows to respect concurrency limits, and if archival pools were isolated from log replication.
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