What should you do?

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?
A. Create the partition function, the partition scheme, and the distributed partitioned view.
B. Create the partition function and the partition scheme, and update the table.
C. Add a secondary file to the primary filegroups, update the table, and create the distributed partitioned view.
D. Create the partition function, update the table, and create a filtered index.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.