Home » Microsoft » 70-762 » Which programming object should you use for each module?
HOTSPOT
You have a database that contains both disk-based and memory-optimized tables.
You need to create two modules. The modules must meet the requirements described in the following table.
Which programming object should you use for each module? To answer, select the appropriate object types in the answer area.
Hot Area:
Correct Answer:
Explanation/Reference:
Module 1: Interpreted stored procedure
An interpreted stored procedure can access both disk-based and memory-optimized tables.
Module 2: Natively compiled stored procedure
Natively compiled stored procedures are Transact-SQL stored procedures compiled to native code that access memory-optimized tables. Natively compiled stored procedures allow for efficient execution of the queries and business logic in the stored procedure.
References: https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/natively-compiled-stored-procedures?view=sql-server-2017