1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is preparing the first Delivery Controller installation for a new Site. The database team will not allow the Citrix service account to create databases and insists that all databases be created in advance with a specific collation and recovery model. Which approach should the administrator take during Site creation?
⚠ Common exam trap
The trap here is believing that pre-creating empty databases is enough, when the Citrix schema and permissions must be created by the supplied scripts.
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
✓
Use the Studio wizard and select the option to generate database scripts, then hand them to the database team
The supported answer when the service account cannot create databases is to have the Create Site wizard generate the SQL scripts. The database team executes them to build the schema with the mandated collation and recovery model, and the administrator then completes Site creation by selecting the existing databases. Temporarily elevating privileges, pre-creating empty databases, or trying to attach a database later through Director all fail the stated constraints.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create empty databases with the required settings and let the wizard populate them without scripts
Why it's wrong here
Creating empty databases alone is not sufficient; the schema, tables, and permissions must be created, and the wizard does not populate arbitrary empty databases on its own in this constrained scenario. Without running the generated scripts, the Site database will lack the required objects and Site creation will fail or produce an incomplete configuration.
- ✓
Use the Studio wizard and select the option to generate database scripts, then hand them to the database team
Why this is correct
When the account cannot create databases, the Create Site wizard can generate the SQL scripts instead of creating the schema directly. The database team runs those scripts to create the databases with the required collation and recovery model, and then the administrator completes the wizard by pointing it at the existing databases, meeting the team's constraints.
- ✗
Install the Delivery Controller without a Site database and attach it later using Citrix Director
Why it's wrong here
A Delivery Controller must be joined to a Site whose database already exists; there is no supported path to install a Controller without a Site database and later attach it through Director. Director is a monitoring and troubleshooting console, not a database provisioning tool, so this approach cannot satisfy the database team's pre-creation requirement.
- ✗
Grant the Citrix service account sysadmin on the SQL Server temporarily so the wizard can create the databases
Why it's wrong here
Granting sysadmin bypasses the database team's control and contradicts their requirement that databases be created in advance with specific settings. It also leaves excessive privileges in place if not revoked, and the wizard would create the databases with default collation and recovery model rather than the required ones, so the approach fails the stated constraints.
About these practice questions
Courseiva writes every 1Y0-204 question from scratch — 216 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-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.