1Y0-A05 · Question #203
Which requirement must be met to set up a Microsoft SQL Server data store?
The correct answer is D. The account used to access the data store must havedb_reader and db_writer permissions to the database. See the full explanation below for the reasoning.
Question
Which requirement must be met to set up a Microsoft SQL Server data store?
Options
- AMicrosoft SQL Server must be installed on the Citrix XenApp server.
- BThe data store database must be created prior to installing the Citrix XenApp servers.
- CThe account used to access the data store must have system administrator account credentials.
- DThe account used to access the data store must havedb_reader and db_writer permissions to the database.
How the community answered
(19 responses)- A5% (1)
- C11% (2)
- D84% (16)
Community Discussion
3
Ola B.Jan 5, 2026The correct answer is D. For a Microsoft SQL Server data store with Citrix XenApp, the account connecting to that database only needs db_reader and db_writer permissions, nothing more. If you spin up a SQL Server instance in a lab and create a test database, you can verify this yourself by granting only those two roles to a service account and running through the XenApp install, it works fine without sysadmin rights. Options A and B describe things that are not actual requirements, and C is flat-out wrong because granting sysadmin to a service account is both unnecessary and a security liability.
Ingrid P.Dec 26, 2025Saw this one and immediately wanted to pick C out of reflex, because "sysadmin" sounds like the obvious brute-force answer for a database setup question, but the XenApp data store only needs db_reader and db_writer on the specific database, not full sysadmin rights. Glad I had a card for this one drilling exactly that distinction, because the exam writers absolutely count on you conflating "needs database access" with "needs system administrator credentials."
Viktor S.Dec 17, 2025Saw this one and almost got suckered by C because "sysadmin sounds powerful enough," but then I remembered the actual install doc says least-privilege, and Citrix only needs db_reader and db_writer, not the keys to the whole SQL kingdom. D is correct, and if you understand why Citrix separates read and write access at the database level rather than handing out sysadmin, you will not confuse this with anything else on the exam.