Microsoft
70-451 · Question #82
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 correct answer is D. Create a new denormalized database based on the OLTP database. See the full explanation below for the reasoning.
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.
How the community answered
(37 responses)- A11% (4)
- B3% (1)
- C3% (1)
- D84% (31)
Community Discussion
No community discussion yet for this question.