1Y0-312 Advanced Site Architecture Practice Question
A Citrix architect is designing a new Citrix Virtual Apps and Desktops 7 Site. The architect needs to ensure that the Site database is highly available and that the Delivery Controllers can automatically reconnect after a database failover without manual reconfiguration. Which SQL Server feature should the architect use?
⚠ Common exam trap
The trap here is assuming that any SQL Server high-availability feature, such as failover clustering or log shipping, provides the same transparent client redirection as an availability group listener.
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
✓
SQL Server Always On availability groups
Always On availability groups are the recommended SQL Server high-availability feature for Citrix Virtual Apps and Desktops 7. They provide a listener that acts as a single connection point, enabling the Delivery Controllers to automatically reconnect to the new primary replica after a failover. This eliminates manual reconfiguration and ensures database high availability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SQL Server transactional log shipping
Why it's wrong here
Log shipping provides a warm standby but does not offer automatic failover or client redirection. A failover would involve manual steps to bring the secondary database online and to repoint the Delivery Controllers. This does not satisfy the need for automatic reconnection without manual reconfiguration.
- ✗
SQL Server replication
Why it's wrong here
Replication is typically used for data distribution and reporting, not for high availability of the Site database. It does not provide automatic failover or a single virtual endpoint for clients. The Delivery Controllers would still point to a specific server, so a failover would require manual reconfiguration, failing the requirement.
- ✓
SQL Server Always On availability groups
Why this is correct
Always On availability groups provide a highly available database solution with automatic failover and a listener that presents a single virtual name. The Delivery Controllers can connect to the listener, so after a failover, they automatically reconnect to the new primary replica without manual changes. This meets the requirement for high availability and automatic reconnection.
- ✗
SQL Server failover cluster instances
Why it's wrong here
While failover cluster instances provide high availability at the server level, they require shared storage and are not the recommended approach for Citrix Virtual Apps and Desktops 7. They also do not provide the same ease of automatic client redirection as an availability group listener, and they may introduce complexity that the architect wants to avoid.
About these practice questions
One of 186 original 1Y0-312 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.