1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is installing the first Delivery Controller in a new Citrix Virtual Apps and Desktops 7 Site. During the installation, the administrator is prompted to specify a Site database. Which action should the administrator take to create the database?
⚠ Common exam trap
The trap here is thinking that Citrix Studio is used to create the Site database, when in fact database creation occurs during Delivery Controller installation or via SQL scripts beforehand.
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
✓
Select the option to create a new database and provide SQL Server credentials with dbcreator rights.
When installing the first Delivery Controller, the administrator can choose to create a new Site database. The account used must have dbcreator rights on the SQL Server to create the database. Alternatively, the database can be pre-created, but the question asks for the action to create it during installation, which is to select the create option and provide appropriate credentials.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use the Citrix Studio console to create the database after the Delivery Controller installation.
Why it's wrong here
Citrix Studio is used to manage the Site after the Delivery Controller is installed. It does not create the Site database; that is done during the Delivery Controller installation or beforehand. Studio requires an existing database to connect to.
- ✓
Select the option to create a new database and provide SQL Server credentials with dbcreator rights.
Why this is correct
During the initial Delivery Controller installation, the administrator can choose to create a new Site database. The account used must have dbcreator rights on the SQL Server instance to create the database. This is the standard procedure for a new Site deployment.
- ✗
Manually create the database using SQL Server Management Studio before running the installer.
Why it's wrong here
While manual creation is possible, it is not required. The Citrix installer can create the database automatically if the account has the necessary permissions. Manual creation is often used in environments with strict database policies, but it is not the action required here unless specified.
- ✗
Configure the Delivery Controller to use a local SQL Express database automatically.
Why it's wrong here
SQL Express is not automatically used unless explicitly selected during installation. For production Sites, a full SQL Server instance is recommended. The installer does not default to SQL Express without the administrator choosing it, and it may not meet scalability requirements.
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.