nerdexam
Microsoft

70-433 · Question #189

You administer a Microsoft SQL Server 2008 R2 instance configured to use Windows Authentication. The database contains a table named CustomerTransaction that has the following definition: You define…

The correct answer is D. Option D. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2008 R2 instance configured to use Windows Authentication. The database contains a table named CustomerTransaction that has the following definition:

You define the following table:

You need to ensure that the following requirements are met:

Which Transact-SQL statement or statements should you use?

Exhibits

70-433 question #189 exhibit 1
70-433 question #189 exhibit 2
70-433 question #189 exhibit 3

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(28 responses)
  • A
    14% (4)
  • B
    4% (1)
  • C
    7% (2)
  • D
    75% (21)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice