1Y1-300 · Question #66
Which two steps should a Citrix Engineer perform to conduct a database failover test? (Choose two.)
The correct answer is B. Take the primary SQL database offline. D. Execute Get-BrokerServiceStatus on the Delivery Controller. See the full explanation below for the reasoning.
Question
Which two steps should a Citrix Engineer perform to conduct a database failover test? (Choose two.)
Options
- ARestart the SQL Server.
- BTake the primary SQL database offline.
- CExecute Get-BrokerServiceStatus on the SQL Server.
- DExecute Get-BrokerServiceStatus on the Delivery Controller.
How the community answered
(40 responses)- A8% (3)
- B78% (31)
- C15% (6)
Community Discussion
4B and D. To test database failover, you take the primary SQL database offline (B) to simulate the actual failure condition, then you run Get-BrokerServiceStatus on the Delivery Controller (D), not the SQL Server, because that cmdlet lives on the Delivery Controller and tells you whether the broker services have successfully reconnected to the mirror or secondary database.
Solid breakdown, though worth noting that before you yank the primary offline you should confirm high availability is actually configured and the mirror or AG listener is healthy, otherwise you are just inducing an outage with nowhere to fail over to.
This exact question showed up on mine last week and I almost picked A because restarting SQL sounded like the obvious way to simulate a failure, but then I caught myself and remembered the point is to take the primary database offline and then run Get-BrokerServiceStatus on the Delivery Controller to see how it responds. Went with B and D and walked out with a pass.
Thought B was obvious but almost picked A until I remembered you test failover by taking the DB offline, then run Get-BrokerServiceStatus on the Delivery Controller, not the SQL box, to confirm services queued up properly.