070-459 Latest Exam Braindumps
Question 1: You plan to design an application that temporarily stores data in a SQL Azure database.You need to identify which types of database objects can be used to store data for the application.
The solution must ensure that the application can make changes to the schema of a temporary object
during a session.
Which type of objects should you identify?
A. Common table expressions (CTEs)
B. Temporary tables
C. Table variables
D. Temporary stored procedures
Correct Answer: B
Explanation:
References: http://msdn.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/en-us/library/ms189084.aspx http://msdn.microsoft.com/en-
us/library/ms175010.aspx http://msdn.microsoft.com/en-us/library/bb510489.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx
http://zacksfiasco.com/post/2010/01/21/SQL-Server-Temporary-Stored-Procedures.aspx
