Provisioning SQL Databases — Question 34

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.

Answer options

• 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.

Correct answer: A, B

Explanation

The correct answers, A and B, are necessary steps to enable In-Memory OLTP for DB1. Enabling In-Memory OLTP for the instance (A) allows the database to utilize this feature, and configuring a new file group for memory-optimized data (B) is required to store the in-memory tables. The other options do not pertain directly to setting up In-Memory OLTP functionality.