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…

Question

Options

• ATempDB tables have a persistent database schema, and the data is deleted when the table
• BTempDB tables are created and destroyed upon use, which not take any database schema
• CTempDB tables are for the storage of large data sets and do not allow exchanging between
• DTempDB tables are used for small data sets that are under 128 KB in size.
• ETempDB tables are used when you are unsure of the size of the data set returned.

• A
  75% (15)
• B
  20% (4)
• D
  5% (1)

Explanation

Temp DB tables have a persistent schema in the database, but they areconfigured to delete table datawhen 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 RAMand disk space, which can causeperformance to suffer. Because of this, it is recommended to usetemp DB tables to handle largertemporary datasets. Temp DB tables are often used to store data from reports, as report data is usually temporary and that it isnot needed after the report is closed.

No community discussion yet for this question.