Citrix Virtual Apps and Desktops 7 Administration — Question 1

A Citrix Administrator is trying to configure a XenDesktop site for use with a mirrored SQL Server database.
Which collation sequence should be used when creating an empty database on the principal SQL Server?

Answer options

• A. _100_CI_AS_KS
• B. _100_CI_AI_SC
• C. _100_CI_AI_WS
• D. _CS_AI_AS

Correct answer: A

Explanation

The correct collation sequence for a XenDesktop site with a mirrored SQL Server database is _100_CI_AS_KS, as it supports case-insensitive and accent-sensitive comparisons. The other options do not meet the necessary requirements for compatibility with XenDesktop, leading to potential issues in database operations.