DP-300 Question #463: Real Exam Question with Answer & Explanation

Question

You have an Azure subscription that contains an Azure SQL database named SQLDB1 in the Hyperscale service tier. SQLDB1 has zone-redundant storage (ZRS) enabled. You need to create a copy of SQLDB1 in the paired Azure region. The solution must minimize administrative effort. What should you do first?

Options

• ACreate another Azure SQL database in the Hyperscale service tier.
• BExport SQLDB1.
• CModify the Backup storage redundancy setting for SQLDB1.
• DCreate a logical server for Azure SQL Database.

Explanation

Configure active geo-replication and failover (Azure SQL Database) Active geo-replication is configured per database. Step 1: Add a secondary database The secondary database has the same name as the primary database and has, by default, the same service tier and compute size. The secondary database can be a single database or a pooled database. After the secondary is created and seeded, data begins replicating from the primary database to the new secondary database. If your secondary replica is used only for disaster recovery (DR), and doesn't have any read or write workloads, you can save on licensing costs by designating the database for standby when you configure a new active geo-replication relationship. (Step 2: Initiate a failover) The secondary database can be switched to become the primary. The command immediately switches the secondary database into the primary role. This process normally should complete within 30 seconds or less. Both databases are unavailable, for up to 25 seconds, while the roles are switched. If the primary database has multiple secondary databases, the command automatically reconfigures the other secondaries to connect to the new primary. The entire operation should take less than a minute to complete under normal circumstances. https://docs.azure.cn/en-us/azure-sql/database/active-geo-replication-configure-portal

No community discussion yet for this question.