Which of the following is not a requirement for creating an online secondary for SQL Database?
A.
The secondary database must have the same name as the primary.
B.
They must be on separate servers.
C.
They both must be on the different subscription.
D.
The secondary server cannot be a lower performance tier than the primary.
C. Both must be in the same subscription.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
“A secondary database can be created with lower performance level (DTUs) than the primary.”
1
0
Not correct:
Should be C:
https://azure.microsoft.com/pl-pl/blog/azure-sql-database-now-supports-powerful-geo-replication-features-on-all-service-tiers/
Note, the secondary database must be in the same service tier than the primary.
1
0
It should be D. Please read the question carefully.
1
7
Not D, because:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
“Configurable performance level of the secondary database: Both primary and secondary databases are required to have the same service tier. A secondary database can be created with lower performance level (DTUs) than the primary.”
Is C, because:
“Both primary and secondary servers must be in the same subscription”
3
0
As pointed out previously correct answer is C. these are the conditions for a secondary db:
Before you create an online secondary, the following requirements must be met:
■ The secondary database must have the same name as the primary.
■ They must be on separate servers.
■ They both must be on the same subscription.
■ The secondary server cannot be a lower performance tier than the primary.
source: the book.
6
0