You need to explain to a team member the difference between TempDB and InMemory table types.
In which three ways do TempDB table types differ from InMemory table types for reporting? Each correct answer presents part of the solution.
A . TempDB tables have a persistent database schema, and the data is deleted when the table goes out of scope.
B . TempDB tables are created and destroyed upon use, which not take any database schema space.
C . TempDB tables are for the storage of large data sets and do not allow exchanging between RAM and
disk space.
D . TempDB tables are used for small data sets that are under 128 KB in size.
E . TempDB tables are used when you are unsure of the size of the data set returned.
Answer: ACE
Explanation:
Temp DB tables have a persistent schema in the database, but they are configured to delete table data when references to the table go out of scope.
An important thing to remember about in-memory tables is that once the table size exceeds 128 kilobytes, the system begins to allocate additional space between the RAM and disk space, which can cause performance to suffer. Because of this, it is recommended to use temp DB tables to handle larger temporary datasets.
Temp DB tables are often used to store data from reports, as report data is usually temporary and that it is not needed after the report is closed.