Microsoft
MB6-894 · Question #45
MB6-894 Question #45: Real Exam Question with Answer & Explanation
Sign in or unlock MB6-894 to reveal the answer and full explanation for question #45. The question stem and answer options stay visible for context.
Question
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 correctanswer presents part of the solution.
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.
Unlock MB6-894 to see the answer
You've previewed enough free MB6-894 questions. Unlock MB6-894 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.