You are creating the following two stored procedures:

A natively-compiled stored procedure

An interpreted stored procedure that accesses both disk-based and m

emory-optimized tables

Both stored procedures run within transactions.

You need to ensure that cross-container transactions are possible.

Which setting or option should you use?

A. the

SET TRANSACTION_READ_COMMITTED

isolation level for the connection

B. the

SERIALIZABLE

table hint on disk-based tables

C. the

SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=ON

option for the database

D. the

SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=OFF

option for the database

Explanation:

Provide a supported isolation

level for the memory-optimized table using a table hint, such as WITH (SNAPSHOT). The need for the WITH (SNAPSHOT) hint can be avoided through the use of the database option MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT. When this option is set to ON, access to a

memory-optimized table under a lower isolation level is automatically elevated to SNAPSHOT isolation.

Incorrect Answers:

B: Accessing memory optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. It is not

supported for explicit or implicit transactions.

References: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/transactions-with-memory-optimized-tables?view=sql-server-2017