Microsoft
70-451 · Question #82
70-451 Question #82: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Question
You are designing a database for a reporting solution that is based on data from an Online Transaction Processing (OLTP) database. The reports will contain aggregated data. You need to ensure that the reports will not affect query performance on the OLTP database. The solution must minimize the use of joins when performing the aggregate calculations. What should you do?
Options
- AAdd a persisted computed column.
- BCreate indexed views in the OLTP database.
- CCreate partitioned tables in the OLTP database.
- DCreate a new denormalized database based on the OLTP database.
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.