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:

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:

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.
https://technet.microsoft.com/en-us/library/ms187004(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/dn249342.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *