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.

View Answer

Answer:

Explanation:

Returning Data by Using OUTPUT Parameters If you specify the OUTPUT keyword for aparameter in the procedure definition, the stored procedure can return the current value of the parameter to the calling program when the stored procedure exits.

SQL Server stored procedures, views and functions are able to use the WITH ENCRYPTION optionto disguise the contents of a particular procedure or function from discovery.

Native Compilation of Tables and Stored Procedures In-Memory OLTP introduces the concept of native compilation. SQL Server can natively compile stored procedures that accessmemory-optimized tables. SQL Server is also able to nativelycompile memory-optimized tables. Native compilation allows faster data access and more efficient query execution than interpreted (traditional) Transact-SQL. Native compilation of tables and stored procedures produce DLLs.

References: https://technet.microsoft.com/en-us/library/ms187004(v=sql.105).aspx https://msdn.microsoft.com/en-us/library/dn249342.aspx