1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is preparing to create a new Citrix Virtual Apps and Desktops 7 Site using Citrix Studio. The database team has pre-created the three required databases and granted the Citrix service account the necessary permissions. Which TWO connection details must the administrator supply in the Site creation wizard so that the Controllers can reach the pre-created databases? (Choose two.)
⚠ Common exam trap
It's easy for candidates to confuse database connection details the wizard collects with SQL Server internals such as licensing and service account passwords that Citrix never asks for.
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
✓
Credentials for an account with access to the databases
When databases are pre-created, the Site creation wizard needs the SQL Server instance address and credentials that can access those databases. The wizard then connects and uses the existing schema. SQL license keys, physical file details, and the SQL Server service account password are not collected by the wizard and are irrelevant to establishing the Citrix database connection.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The Microsoft SQL Server product license key
Why it's wrong here
SQL Server licensing is handled separately by the organization's database team and is not entered into the Citrix Studio Site creation wizard. The wizard collects connection information such as the instance name and credentials, but licensing keys are outside the scope of Citrix Site configuration.
- ✓
Credentials for an account with access to the databases
Why this is correct
The wizard requires credentials that can connect to the SQL Server and access the pre-created databases, because Citrix uses them for the Site database connection. Without valid credentials, Site creation cannot complete even if the databases already exist and are correctly configured.
- ✓
The address of the SQL Server instance hosting the databases
Why this is correct
The wizard must know which SQL Server instance holds the pre-created databases, so the administrator supplies the instance address or name. The Controllers and Studio use this to locate and connect to the Site, monitoring, and configuration logging databases that the database team created.
- ✗
The names of the individual database files and their filegroups
Why it's wrong here
Physical database file names and filegroup layouts are chosen by the database team when they create the databases, and Citrix Studio does not prompt for them. The wizard only needs to know the instance and database names and the credentials, so supplying file-level details is unnecessary and not part of the supported flow.
- ✗
The SQL Server service account password used by the database engine
Why it's wrong here
The password of the SQL Server service account is internal to the database server and is never required by the Citrix Site creation wizard. The administrator supplies credentials for a login that can access the Citrix databases, not the password for the service account under which the SQL Server engine runs.
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.