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…

Common table expressions are inline query constructs that exist only for the duration of a single statement and cannot be altered or persist data across multiple statements in a session.

Table variables (@table) are declared with a fixed schema at the point of declaration and do not support ALTER TABLE statements, so their structure cannot be changed once declared.

Temporary tables (#table) are created in tempdb and persist for the duration of the session or connection that created them. Unlike table variables, they fully support DDL statements such as ALTER TABLE during the session, allowing the application to add, drop, or modify columns after the object has been created - directly meeting the requirement for runtime schema changes.

Temporary stored procedures store executable Transact-SQL code rather than data and are not a mechanism for storing or restructuring application data during a session.