Home » Microsoft » 70-466 v.2 » 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?
A. Common table expressions (CTEs)
B. Table variables
C. Temporary tables
D. Temporary stored procedures
Correct Answer: C
Explanation/Reference:
Explanation:
There are two types of temporary tables: local and global. Local temporary tables are visible only to their creators during the same connection to an instance of SQL Server as when the tables were first created or referenced. Local temporary tables are deleted after the user disconnects from the instance of SQL Server.
Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the table disconnect from the instance of SQL Server.
References: https://technet.microsoft.com/en-us/library/ms186986(v=sql.105).aspx