Exit 70-433 TS: Microsoft SQL Server 2008, Database Development
Question 2 of 5
0% complete
Q2 Single choice

You administer a Microsoft SQL Server 2008 database named AdventureWorks that contains a table named Production.Product. The table contains a primary key named PK_Product_ProductID and a non-clustered index named AK_Product_ProductNumber. Both indexes have been created on a single primary partition.

The table has the following definition:

The index has the following definition:

  • A

    Option A

  • B

    Option B

  • C

    Option C

  • D

    Option D

  • E

    Option E

  • F

    Option F

  • G

    Option G

  • H

    Option H

  • I

    Option I

  • J

    Option J

  • K

    Option K

  • L

    Option L

  • M

    Option M

  • N

    Option N

  • O

    Option O

  • P

    Option P

  • Q

    Option Q