You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment. ABC.com subscribes to
SQL Azure, which hosts a ABC.com database.
You have received instructions to create a new application for ABC.com. The new application
must be configured to store data in the ABC.com database on a temporary basis.
To achieve this, you have to pinpoint the database object type that should be employed for hosting
the application data. You are then informed that your strategy allows for the application to modify
the schema of a temporary object during a session.
Which of the following actions should you take?
A.
You should consider making use of Partitioned Tables.
B.
You should consider making use of System Tables.
C.
You should consider making use of Temporary Tables.
D.
You should consider making use of Wide Tables.
Explanation:
http://technet.microsoft.com/en-us/library/ms186986(v=sql.105).aspx
Answer shoud be D. We need to have flexible schema and still store data.
?