nerdexam
Microsoft

70-433 · Question #179

You administer a SQL Server 2008 instance. The instance contains a database table named Sales.SalesOrderDetail. The table has the following definition: You need to enable row compression for the…

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

Question

You administer a SQL Server 2008 instance. The instance contains a database table named Sales.SalesOrderDetail. The table has the following definition:

You need to enable row compression for the index. Which Transact-SQL statement or statements should you use?

Exhibits

70-433 question #179 exhibit 1
70-433 question #179 exhibit 2

Options

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

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    76% (19)
  • C
    8% (2)
  • D
    12% (3)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice