AZ-303 Exam - Question 151

Question

HOTSPOT -You have the Azure SQL Database servers shown in the following table. You have the Azure SQL databases shown in the following table. You create a failover group named failover1 that has the following settings:✑ Primary server: sqlserver1✑ Secondary server: sqlserver2✑ Read/Write failover policy: Automatic✑ Read/Write grace period (hours): 1 hourFor each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:.

Examice · Accepted Answer

Box 1: Yes -DB1 is on the primary server -Box 2: No -DB3 is on the secondary server. You can put all or several databases within an elastic pool into the same failover group. Box 3: No -A failover group is a named group of databases managed by a single server or within a managed instance that can fail over as a unit to another region in case all or some primary databases become unavailable due to an outage in the primary region. The secondary cannot be in the same region as the primary. Reference:https://docs. microsoft. com/en-us/azure/azure-sql/database/auto-failover-group-overview.

spiraltrip · Answer

To do auto-failover, you must have primary and secondary servers in different regions. If you want to failover databases in an elastic pool, then the secondary server must have the same pool name. You can also failover a database that is not part of a pool to a secondary server.

So answer is correct:
Yes - You can add DB1 (not part of any pool) to failover group.
No - You can't add DB3 to the failover group since it is already part of the secondary server and has the same pool name, to provide failover from the primary.
No - Primary and secondary servers must be in different regions for auto-failover

Ideasky · Answer

The question has issue
I found the important tips from https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
You can create multiple pools on a server, but you can't add databases from different servers into the same pool.

so that means the POOL1 only have 1 sql server

jbadru · Answer

Yes No No is correct

TSMRE · Answer

On exam 6/7/21

RubberenRobbie · Answer

tested, answers are CORRECT

namitt77 · Answer

confusing

UptoU · Answer

I think the answer is NYN, becasue 
"You can put all or several databases within an elastic pool into the same failover group."

arunpaul · Answer

CCCorrect....
Because auto-failover groups involve multiple databases, these databases must be configured on the primary server.

networkingcontrol · Answer

Elastic pool is shared between Pri&Sec SQL servers. See section 3) https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-elastic-pool-tutorial?tabs=azure-portal

syu31svc · Answer

1. You can add failover to a database that is not part of a pool.
2. DB3 is part of sqlserver2. You cannot add DB3 to the failover group.
3. Primary and secondary servers must be in different regions for auto-failover.

https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-elastic-pool-tutorial?tabs=azure-portal

Yes No No is correct

Kubernetes · Answer

Multiple pools can be created on the server, but databases belonging to different servers cannot be added to the same pool.

quantumray · Answer

Question appeared On AZ-303 exam on 08/12/2021 - 49 questions, 4Q - Fabrikan case study

quantumray · Answer

Question appeared On AZ-303 exam on 08/12/2021 - 49 questions, 4Q - Fabrikan case study

AZ-303 Exam - Question 151

Discussion