Citrix Exam 1Y0-204 Topic 1 Question 70 Discussion

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

Question #: 70
Topic #: 1

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

by Sherill at Apr 28, 2024, 04:05 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

6 months ago

Thanks for the insights, everyone. I'm leaning towards _100_CI_AS_KS because it covers case and accent sensitivity.

upvoted 0 times

...

6 months ago

But what about _CS_AI_AS? Seems like it covers case sensitivity and accent insensitivity.

upvoted 0 times

...

6 months ago

I heard _100_CI_AI_SC is for supplementary characters. Could be a good choice if that's required.

upvoted 0 times

...

6 months ago

I'm not really sure. Maybe _100_CI_AI_WS would work? AI might stand for accent insensitive, which is helpful sometimes.

upvoted 0 times

...

6 months ago

Yeah, I think the collation should be _100_CI_AS_KS. It's often used for case and accent sensitivity.

upvoted 0 times

...

6 months ago

This Citrix question seems tricky. Anyone got a clue about SQL Server collation sequences?

upvoted 0 times

...