Microsoft
70-451 · Question #137
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…
The correct answer is D. table partitioning. See the full explanation below for the reasoning.
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
How the community answered
(26 responses)- A12% (3)
- B4% (1)
- C4% (1)
- D81% (21)
Community Discussion
No community discussion yet for this question.