1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is deploying a new Citrix Virtual Apps and Desktops 7 Site. The organization requires that the Site database be highly available and automatically fail over to a secondary server if the primary fails. The database team has configured SQL Server Always On availability groups. Which action must the administrator take when creating the Site database?
⚠ Common exam trap
The trap here is assuming that specifying the primary SQL Server name is sufficient, or that Database Mirroring is used with Always On. Actually, the listener name is required for Always On.
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
✓
Specify the availability group listener name as the database server.
For SQL Server Always On availability groups, the Delivery Controller must connect to the availability group listener, which routes connections to the current primary replica. This enables automatic failover. Specifying individual server names or enabling other features like Database Mirroring is incorrect and would not provide the required 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.
- ✗
Specify both SQL Server names separated by a comma.
Why it's wrong here
Providing multiple server names in a comma-separated list is not supported for Citrix Site database connections. The Controller expects a single server or listener name. This would cause connection errors. The correct method is to use the availability group listener.
- ✗
Specify the secondary SQL Server name and set it as the principal.
Why it's wrong here
The secondary replica is not writable in an Always On availability group; it is read-only unless configured for read-only routing. Specifying the secondary as the principal would cause failures. The Controller must connect to the listener, not directly to the secondary. This option is incorrect.
- ✓
Specify the availability group listener name as the database server.
Why this is correct
When using SQL Server Always On availability groups, the Delivery Controller should connect to the availability group listener, which abstracts the primary and secondary replicas. This allows automatic failover without reconfiguring the Controller. Specifying the listener name ensures high availability. This is the correct approach.
- ✗
Specify the primary SQL Server name and enable Database Mirroring.
Why it's wrong here
Database Mirroring is a different high-availability feature and is not used with Always On availability groups. Enabling mirroring would be redundant and incorrect. Also, specifying the primary server name without the listener would not provide automatic failover. This option does not meet the requirement.
About these practice questions
This 1Y0-204 question is part of Courseiva's 216-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-204 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-204 exam.