70-465 Question #147: Real Exam Question with Answer & Explanation

Question

You need to change the ProdDB database. Which two database options should you change to meet the requirements? Each correct answer presents part of the solution. Choose two.

Options

• ACONTAINS FILESTREAM
• BChange recovery model to FULL
• CCONTAINMENT = PARTIAL
• DChange recovery model to BULK_LOGGED
• ECOLLATE IN.MEMORY
• FCONTAINS MEMORY OPTIMIZED DATA

Explanation

To enable In-Memory OLTP and memory-optimized tables in SQL Server, the database must be configured with both a memory-optimized filegroup and the appropriate collation setting for in-memory objects.

Common mistakes.

• A. CONTAINS FILESTREAM is used to store unstructured BLOB data in the file system and is unrelated to In-Memory OLTP or memory-optimized table requirements.
• B. Changing the recovery model to FULL affects transaction log backup behavior and point-in-time recovery capabilities, but is not a requirement for enabling In-Memory OLTP or memory-optimized tables.
• C. CONTAINMENT = PARTIAL enables partially contained databases to manage their own users and settings independently, but this is unrelated to In-Memory OLTP configuration.
• D. The BULK_LOGGED recovery model minimizes log space for bulk operations but does not fulfill any requirement for enabling memory-optimized tables or In-Memory OLTP features.

Concept tested. Configuring SQL Server In-Memory OLTP database options

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/the-memory-optimized-filegroup

No community discussion yet for this question.