With what should you recommend replacing Table1?

You need to recommend a solution to minimize the amount of time it takes to execute USP_1.

With what should you recommend replacing Table1?
A . An indexed view
B . A function
C . A table variable
D . A temporary table

View Answer

Answer: D

Explanation:

Scenario: A stored procedure named USP_1 generates millions of rows of data for multiple reports. USP_1 combines data from five different tables from the Sales and Customers databases in a table named Table1.

After Table1 is created, the reporting process reads data from a table in the Products database and searches for information in Table1 based on input from the Products table. After the process is complete, Table1 is deleted.