Microsoft
70-459 · Question #2
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…
The correct answer is B. Temporary tables. See the full explanation below for the reasoning.
Question
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?
Options
- ACommon table expressions (CTEs)
- BTemporary tables
- CTable variables
- DTemporary stored procedures
How the community answered
(31 responses)- A3% (1)
- B71% (22)
- C10% (3)
- D16% (5)
Community Discussion
No community discussion yet for this question.