PrepAway - Latest Free Exam Questions & Answers

Which type of objects should you identify?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Common table expressions (CTEs)

B.
Temporary stored procedures

C.
Temporary tables

D.
Table variables

Explanation:

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


Leave a Reply