nerdexam
Microsoft

70-433 · Question #467

You are working with a SQL Server 2008 instance that is configured to use the Icelandic_CS_AS collation. You create a database by using code that includes the following statements. You need to…

The correct answer is B. Icelandic_CS_AS. See the full explanation below for the reasoning.

Question

You are working with a SQL Server 2008 instance that is configured to use the Icelandic_CS_AS collation. You create a database by using code that includes the following statements. You need to identify the collation that will be assigned to #AppTempTable. Which collation will be assigned?

Exhibit

70-433 question #467 exhibit

Options

  • AJapanese_CS_AS
  • BIcelandic_CS_AS
  • CThe collation selected by the Windows system locale of the server
  • DNo collation

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    75% (24)
  • C
    16% (5)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice