nerdexam
Microsoft

70-433 · Question #207

You need to create a column that allows you to create a unique constraint. Which two column definitions should you choose? (Each correct answer presents a complete solution. Choose two.)

The correct answer is A. nvarchar(100) NULL C. nvarchar(100) NOT NULL. See the full explanation below for the reasoning.

Question

You need to create a column that allows you to create a unique constraint. Which two column definitions should you choose? (Each correct answer presents a complete solution. Choose two.)

Options

  • Anvarchar(100) NULL
  • Bnvarchar(max) NOT NULL
  • Cnvarchar(100) NOT NULL
  • Dnvarchar(100) SPARSE NULL

How the community answered

(60 responses)
  • A
    75% (45)
  • B
    8% (5)
  • D
    17% (10)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice