You have a relational data warehouse that contains 1 TB of data. You have a stored procedure named usp_sp1 that 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 NOLOCK option.
B.
Execute the DBCC UPDATEUSAGE statement.
C.
Use the max worker threads option.
D.
Use a table-valued parameter.
E.
Set SET ALLOW_SNAPSHOT_ISOLATION to ON.
F.
Set SET XACT_ABORT to ON.
G.
Execute the ALTER TABLE T1 SET (LOCK_ESCALATION = AUTO); statement.
Suggested Answer:G🗳️
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
Using output parameters is the only way to return data to a variable that is not an integer,
and is the only way to return more than one value to a variable, no matter the type.
This section is not available anymore. Please use the main Exam Page.70-762 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
EdwardWang
Highly Voted 5 years, 4 months agoJohnFan
5 years, 2 months agocaeesz
Most Recent 4 years, 3 months agoFawzy
4 years, 3 months ago