You are updating a database table. You need to partition the table to store only the last 1000 rows of data in the table. What should you do?

Question

Options

• ACreate the partition function and the partition scheme, and update the table.
• BCreate the partition function, the partition scheme, and the distributed partitioned view.
• CCreate the partition function, update the table, and create a filtered index.
• DAdd a secondary file to the primary filegroups, update the table, and create the distributed

• A
  80% (20)
• B
  4% (1)
• C
  4% (1)
• D
  12% (3)

No community discussion yet for this question.