Valid 70-762 Dumps shared by ExamDiscuss.com for Helping Passing 70-762 Exam! ExamDiscuss.com now offer the newest 70-762 exam dumps, the ExamDiscuss.com 70-762 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-762 dumps with Test Engine here:
You are creating the following two stored procedures: A natively-compiled stored procedure An interpreted stored procedure that accesses both disk-based and memory-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?
Correct Answer: C
Explanation/Reference: 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