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 de-normalized database based on the OLTP database.