Home » Microsoft » 70-469 » 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. A view
B. A temporary table
C. A table variable
D. A function
Correct Answer: A
Explanation/Reference:
* 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.
CREATE TABLE (SQL Server)
