nerdexam
Microsoft

70-451 · Question #137

70-451 Question #137: Real Exam Question with Answer & Explanation

Sign in or unlock 70-451 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.

Question

You are designing a table that will store transactions for an online retailer. You anticipate that the online retailer will have an average of 500,000 transactions per day. You need to design a solution for data aging and archiving. The solution must minimize the amount of time it takes to return query results for active data. What should you implement?

Options

  • Aa linked server
  • Ba table schema
  • CService Broker
  • Dtable partitioning

Unlock 70-451 to see the answer

You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-451 Practice