Exam 70-765 topic 4 question 28 discussion

Actual exam question from Microsoft's 70-765

Question #: 28
Topic #: 4

You have an on-premises Microsoft SQL Server instance.
You create a database named DB1.
You need to configure DB1 to support In-Memory OLTP.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Enable In-Memory OLTP for the instance.
B. Configure a new file group for memory-optimized data.
C. Enable FILESTREAM for the instance.
D. Configure a new file for a file group.
E. Configure a new file group for FILESTREAM data.

Show Suggested Answer

Suggested Answer: AB 🗳️
References:
https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/survey-of-initial-areas-in-in-memory-oltp?view=sql-server-ver15

by MelKr at June 11, 2020, 5:09 p.m.

Comments

Submit Cancel

MelKr

Highly Voted 5 years ago

BD is correct. You cannot enable In-Memory OLTP on the instance. You need to create an In-Memory OLTP-Filegroup and a file within that filegroup see: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/the-memory-optimized-filegroup?view=sql-server-ver15

upvoted 7 times

jolsca

4 years, 9 months ago

Is correct, MEMORY_OPTIMIZED_DATA option is enabled for the database, not at the Instance level

upvoted 1 times

...