Citrix Exam 1Y0-204 Topic 18 Question 76 Discussion

Actual exam question for Citrix's 1Y0-204 exam

Question #: 76
Topic #: 18

[All 1Y0-204 Questions]

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?

A_100_CI_AS_KS

B_100_CI_AI_WS

C_100_CI_AI_SC

D_CS_AI_AS

Show Suggested Answer

Suggested Answer: A

According to the Citrix Virtual Apps and Desktops 7 Deployment and Administration documentation1, 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 mirroring2.

by Lai at Jul 09, 2024, 06:55 PM

Limited Time Offer

25%

Off

Get Premium 1Y0-204 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Stephen

4 months ago

I read that _100_CI_AI_SC is recommended for mirrored SQL Server databases for better performance.

upvoted 0 times

...

Jose

4 months ago

Why do you think option C is better?

upvoted 0 times

...

An

5 months ago

A, B, C, or D? This is like trying to find the hidden treasure in a Citrix Virtual Desktop!

upvoted 0 times

...

Lorriane

5 months ago

I'm not sure about the differences between these collation sequences, but option A sounds the most technical, so it's probably the right choice.

upvoted 0 times

Carri

4 months ago

User2

upvoted 0 times

...

Carri

5 months ago

User1

upvoted 0 times

...

5 months ago

I think the administrator should use option A) _100_CI_AS_KS.

upvoted 0 times

...