1Y0-204 Site Deployment and Configuration Practice Question
A Citrix administrator is setting up a new Citrix Virtual Apps and Desktops 7 Site. The administrator wants to ensure that the Site database is backed up regularly and that the backup does not interfere with the production database. Which built-in SQL Server feature should the administrator use?
⚠ Common exam trap
Test-takers frequently confuse high-availability features with backup solutions. Always On and Mirroring do not replace backups; they replicate data but do not provide historical recovery points.
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
✓
SQL Server Agent job with a backup command
The requirement is to perform regular backups of the Citrix Site database without impacting production. SQL Server Agent jobs can be scheduled to run backup commands, which is the standard approach. Other features like Database Mirroring, Replication, or Always On availability groups are for high availability or data distribution, not for creating backups.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Always On availability groups
Why it's wrong here
Always On availability groups provide high availability and disaster recovery, but they are not a backup mechanism. While they can offload read-only workloads, they do not create backup files. For backups, a separate backup strategy is required. This option does not satisfy the backup requirement.
- ✗
SQL Server Replication
Why it's wrong here
Replication is used to distribute data across multiple servers, not for backup purposes. It can introduce complexity and is not a substitute for regular backups. Replication does not provide point-in-time recovery. Thus, it is not the correct feature for backup.
- ✗
Database Mirroring
Why it's wrong here
Database Mirroring is a high-availability feature, not a backup solution. It maintains a synchronized copy of the database but does not provide historical backups. If data is corrupted or deleted, mirroring will replicate the issue. Therefore, it does not meet the backup requirement.
- ✓
SQL Server Agent job with a backup command
Why this is correct
SQL Server Agent jobs can be scheduled to perform database backups at specified intervals. This is a standard method to back up the Citrix Site database without manual intervention. It uses SQL Server's native backup capabilities and can be configured to run during off-peak hours. This meets 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.