Câu 42: 70-762: Developing SQL Databases

You are creating the following two stored procedures: ✑ A natively-compiled stored procedureAn 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?

1. A. the BEGIN TRANSACTION AND COMMIT OR ROLLBACK TRANSACTION statements for the connection — đáp án hiện tại
2. B. the SERIALIZABLE table hint on memory-optimized tables
3. C. the CONTAINS MEMORY_OPTIMIZED_DATA option for the file group
4. D. the SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=OFF option for the database