1Y0-200 · Question #124
Which console could a Citrix Administrator use to back up a XenDesktop database?
The correct answer is D. SQL Management Studio. See the full explanation below for the reasoning.
Question
Which console could a Citrix Administrator use to back up a XenDesktop database?
Options
- ACitrix Studio
- BCitrix Director
- CCitrix XenCenter
- DSQL Management Studio
How the community answered
(60 responses)- A3% (2)
- B5% (3)
- C12% (7)
- D80% (48)
Community Discussion
12
Thekla S.Nov 20, 2025D is correct. The XenDesktop site database is a Microsoft SQL Server database, so backing it up is a SQL Server operation done through SQL Server Management Studio, not through any Citrix console like Studio, Director, or XenCenter, which have no native database backup functionality.
Luis F.Jan 10, 2026D is your answer here. The XenDesktop database runs on SQL Server, so you go into SQL Server Management Studio to handle backups, not any of the Citrix consoles like Studio or Director, those are for managing desktops and sessions, not the underlying database engine.
Brenda K.Nov 29, 2025Saw this exact one on my sitting two years ago and I almost burned three minutes second-guessing myself before I remembered the core principle: XenDesktop stores its site data in a SQL Server database, which means the tool that owns the database backup job is a SQL tool, not a Citrix tool. Citrix Studio lets you configure and manage your desktop delivery setup but it has no native database backup interface. Citrix Director is a monitoring console, period, and XenCenter is your XenServer hypervisor management layer, so neither of those even come close. The second I reminded myself "who owns the SQL database," I circled D, SQL Management Studio, and moved on in under 45 seconds. This is a quick win if you know your role separation, flag it only if you blanked on what tool class owns SQL backups, otherwise bank the time and keep moving.
Samuel O.Dec 1, 2025That role-separation framing is exactly right, and I'll add that if you also remember the XenDesktop installer literally creates a SQL Server instance during setup, it makes it even more obvious why SQL Server Management Studio is the answer and not anything in the Citrix toolset.
Samuel O.Dec 10, 2025The question is asking about backing up the actual database, not managing the XenDesktop site, and that distinction matters a lot. Citrix Studio is where you go to configure and manage your XenDesktop environment, so it trips people up here because it feels like the right answer if you read too fast. But Studio has no database backup functionality baked in, it just talks to the database, it does not manage it. The XenDesktop database is a SQL Server database under the hood, so backing it up is a SQL Server job, which means you are sitting in SQL Server Management Studio running a backup task like you would for any other SQL workload. D is your answer.
Carlos M.Feb 2, 2026The wording "which console could a Citrix Administrator use" is a little loose because it implies one of the Citrix-branded tools, but backing up the XenDesktop database is a SQL Server operation and you do that in SQL Management Studio, not Studio, Director, or XenCenter. D is correct.
Grace U.Nov 9, 2025D is the one, and it makes sense once you think about what the XenDesktop database actually is. It runs on SQL Server, so the tool that knows how to back it up is SQL Server Management Studio, not anything in the Citrix console family. Citrix Studio is great for managing your site configuration, and Director is your helpdesk and monitoring view, but neither of them has a backup mechanism for the underlying database itself. If you got tripped up by Studio, that is a very common place to land, because it feels like the "home base" for XenDesktop administration, just remember it manages the environment, not the SQL layer beneath it.
Brenda K.Nov 10, 2025Grace nailed the SQL layer point, and the only thing worth adding is that SSMS handles the backup but you still need to know which databases to target, specifically the Site, Monitor, and Logging databases, or you will back up SQL Server without actually capturing your XenDesktop config.
Yusuf A.Nov 16, 2025Got burned on this one, almost picked Studio until my mentor reminded me the database lives in SQL.
Brenda K.Nov 16, 2025Good save by your mentor, and that is the exact kind of detail that costs you 2 minutes if you freeze on it, so lock in the rule now: any time you see "relational data" or "tables" in the stem, your brain should already be moving toward RDS or Aurora before you finish reading the options.
Ingrid P.Jan 21, 2026D is the one that trips people up because the other three options all sound plausible if you are not careful about what each tool actually owns. Citrix Studio manages the delivery infrastructure, Director is your monitoring and helpdesk console, and XenCenter handles the hypervisor layer, but none of them have a direct interface into the SQL backend where the XenDesktop site database actually lives. The database itself is a standard SQL Server database, so backup and restore operations go through SQL Server tooling, specifically SQL Server Management Studio, just like any other SQL workload in your environment. Quick question for anyone who has done this in practice: when you set up your XenDesktop site, did you put the site database, monitoring database, and configuration logging database all on the same SQL instance, or did you split them across instances? Curious whether that changes how people approach the backup job setup in SSMS.
Carlos M.Jan 22, 2026We put all three on the same instance to keep the backup schedule simple, but splitting them out would let you set different retention policies since the monitoring DB grows way faster than the site DB.