1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is deploying a new Citrix Virtual Apps and Desktops 7 Site. The company requires that the Site database be highly available. The administrator plans to use SQL Server Always On availability groups. Which two actions must the administrator perform to configure the Site database for high availability with Always On availability groups? (Choose two.)
⚠ Common exam trap
The trap here is thinking that additional client-side configuration or a different high-availability technology is required, when the key steps are creating the database in the availability group and using the listener name.
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
✓
Configure the Delivery Controllers to connect to the availability group listener name instead of the SQL Server instance name.
To configure the Site database for high availability with SQL Server Always On availability groups, the administrator must create the Site database on the primary replica and add it to the availability group, and then configure the Delivery Controllers to connect to the availability group listener name. These two actions ensure that the database is replicated and that the Controllers can connect to the active replica after a failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Install the SQL Server Native Client on each Delivery Controller and configure it to use a specific secondary replica.
Why it's wrong here
The SQL Server Native Client is already installed as part of the Delivery Controller installation. Configuring it to connect to a specific secondary replica is not correct because secondary replicas are read-only and do not accept writes. The Controllers must connect to the listener, which directs them to the primary replica.
- ✗
Enable the MultiSubnetFailover parameter in the connection string for the Delivery Controllers.
Why it's wrong here
While MultiSubnetFailover can improve failover speed in multi-subnet environments, it is not a mandatory action for configuring the Site database for Always On availability groups. The essential steps are creating the database in the availability group and using the listener name. This parameter may be optional depending on the network configuration.
- ✗
Configure the Site database to use SQL Server mirroring with a witness server instead of Always On availability groups.
Why it's wrong here
The question specifies that the administrator plans to use Always On availability groups. Configuring SQL Server mirroring is a different high-availability technology and would not meet the requirement. This action would be incorrect because it contradicts the stated plan and does not configure Always On availability groups.
- ✓
Configure the Delivery Controllers to connect to the availability group listener name instead of the SQL Server instance name.
Why this is correct
When using Always On availability groups, clients connect to the availability group listener, which routes connections to the active replica. The Delivery Controllers must be configured with the listener name so that they can automatically connect to the current primary replica after a failover.
- ✓
Create the Site database on the primary replica and add it to the availability group.
Why this is correct
The Site database must be created on the primary replica of the availability group. After creation, it should be added to the availability group so that it replicates to the secondary replicas. This ensures that the database is part of the Always On configuration and can fail over.
About these practice questions
One of 216 original 1Y0-204 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-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.