1Y0-312 Advanced Site Architecture Practice Question
A Citrix architect is designing a new Citrix Virtual Apps and Desktops 7 Site that will use a single SQL Server Always On availability group for the Site database. During a planned failover of the database, the Delivery Controllers must continue to function without manual reconfiguration. Which database connection method should the architect configure on the Delivery Controllers?
⚠ Common exam trap
The trap here is assuming that any SQL Server high-availability feature provides transparent client redirection, when only an availability group listener gives the Controllers a single stable name that follows the primary replica.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
An Always On availability group listener name
The Delivery Controller must be able to reconnect to the database after a failover without administrative changes. An Always On availability group listener provides a stable virtual network name and automatically routes connections to the active replica, so the Controllers keep working through the role change. Other SQL Server high-availability options either need manual steps or do not present a single transparent endpoint to the Controllers.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A direct connection to each SQL Server node with a comma-separated server list
Why it's wrong here
The Delivery Controller database connection string does not support a comma-separated list of SQL Server nodes for automatic failover. While some applications allow multiple server names in a connection string, Citrix Studio and the Controller configuration expect a single database server or listener name, so this approach would not provide automatic redirection during a failover.
- ✓
An Always On availability group listener name
Why this is correct
Connecting the Delivery Controllers to the Always On availability group listener provides a single virtual name that automatically redirects connections to the current primary replica after a failover. This satisfies the requirement because the Controllers do not need to be reconfigured when the database role moves, and the listener abstracts the underlying replica topology.
- ✗
SQL Server log shipping to a standby server
Why it's wrong here
Log shipping copies transaction logs to a secondary server but does not provide automatic client redirection or a shared virtual name. A failover with log shipping requires manual intervention to bring the secondary database online and to reconfigure the Delivery Controllers, which directly contradicts the requirement for uninterrupted operation during a planned failover.
- ✗
SQL Server mirroring with a witness server
Why it's wrong here
Database mirroring with a witness is a legacy high-availability option that requires manual failover or client-side retry logic, and it is not the recommended method for a Citrix Virtual Apps and Desktops 7 Site database. It also does not automatically present a single stable name to the Delivery Controllers, so it fails the requirement for transparent failover without reconfiguration.
About these practice questions
Courseiva writes every 1Y0-312 question from scratch — 186 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Citrix exam blueprint
This 1Y0-312 practice question is part of Courseiva's free Citrix certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 1Y0-312 exam.