Microsoft
70-451 · Question #147
70-451 Question #147: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #147. The question stem and answer options stay visible for context.
Question
You are a SQL Server 2008 developer. You create an online transaction processing (OLTP) database by using SQL Server 2008 in an enterprise environment. The database contains a table named SalesDetails. Each record in the table contains data in any one of the following pairs of nullable columns: - InternetSalesTargets and InternetSales - ResellerSalesTargets and ResellerSales - ForeignSalesTargets and ForeignSales The table also contains three NOT NULL key columns. A large number of records are inserted on a daily basis into the SalesDetails table. Summary reports are generated from the SalesDetails table. Each report is based on aggregated data from any one of the pairs of nullable columns. You need to design a view or views to meet the following requirements: - The SalesDetails table cannot be directly modified. - The performance of the reports is maximized. - The amount of storage space for each report is minimized. What should you do?
Options
- ACreate an indexed view from the SalesDetails table that contains aggregated data of all the
- BCreate multiple indexed views from the SalesDetails table so that each view contains
- CCreate multiple Report tables from the SalesDetails table so that each Report table contains
- DPerform a quick transfer of aggregated new records to a staging table at the end of each
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.