What should you do?

You have a relational data warehouse that contains 1 TB of data.

You have a stored procedure named usp_sp1that generated an HTML fragment. The HTML fragment contains color and font style.

You need to return the HTML fragment.

What should you do?
A . Use the NOLOCKoption.
B . Execute the DBCC UPDATEUSAGEstatement.
C . Use the max worker threads option.
D . Use a table-valued parameter.
E . Set SET ALLOW_SNAPSHOT_ISOLATIONto O
G . Set SET XACT_ABORTto O
. Execute the ALTER TABLE T1 SET (LOCK_ESCALATION = AUTO);statement.
. Use the OUTPUTparameters.

View Answer

Answer: G

Explanation:

A SQL Server stored procedure that you can call is one that returns one or more OUT parameters, which are parameters that the stored procedure uses to return data back to the calling application.

References: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-a-stored-procedure-with-output­parameters?view=sql-server-2017