Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should accept a parameter that guarantees numerous rows of data can pass into the
stored procedure. ABCSPB should be configured to make use of business logic, which exists in a
Microsoft .NET Framework assembly.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should accept a parameter that guarantees numerous rows of data can pass into the
stored procedure. ABCSPB should be configured to make use of business logic, which exists in a
Microsoft .NET Framework assembly.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)

A.
You should consider configuring the use of a table-valued parameter for ABCSPA.

B.
You should consider configuring the use of a table-valued parameter for ABCSPB.

C.
You should consider configuring the use of common language runtime (CLR) for ABCSPA.

D.
You should consider configuring the use of common language runtime (CLR) for ABCSPB.

Explanation:



Leave a Reply 1

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