A Citrix Administrator is configuring a Citrix Virtual Desktops Site for use with a mirrored SQL Server database. Which collation sequence should the administrator use when creating an empty…

The correct answer is A. _100_CI_AS_KS. The collation sequence for the site database should be _100_CI_AS_KS. This collation sequence is case-insensitive, accent-sensitive, kana-sensitive, and width-insensitive. It is also compatible with the SQL Server mirroring feature. Other collation sequences might cause errors…

Manage a Citrix Virtual Apps and Desktops Site

Question

A Citrix Administrator is configuring a Citrix Virtual Desktops Site for use with a mirrored SQL Server database. Which collation sequence should the administrator use when creating an empty database on the principal SQL Server?

Options

A_100_CI_AS_KS
B_100_CI_AI_WS
C_100_CI_AI_SC
D_CS_AI_AS

How the community answered

(34 responses)

A
71% (24)
B
3% (1)
C
9% (3)
D
18% (6)

Explanation

The collation sequence for the site database should be _100_CI_AS_KS. This collation sequence is case-insensitive, accent-sensitive, kana-sensitive, and width-insensitive. It is also compatible with the SQL Server mirroring feature. Other collation sequences might cause errors or unexpected behavior when using SQL Server mirroring.

Topics

#SQL Server collation#mirrored database#Site database#high availability

Community Discussion

No community discussion yet for this question.

Full 1Y0-204 Practice