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?
A.
Add a persisted computed column.
B.
Create indexed views in the OLTP database.
C.
Create partitioned tables in the OLTP database.
D.
Create a new denormalized database based on the OLTP database.