You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements: - Procedure1 must take a parameter that ensures that multiple rows of data can pass in

Submitted by rania.sa· Mar 5, 2026Implementing Programmability Objects in SQL Server / Designing and Implementing Stored Procedures using appropriate SQL Server technologies

Question

You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements: - Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure. - Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly. You need to identify the appropriate technology for each stored procedure. Which technologies should you identify? To answer, drag the appropriate technology to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.) Answer:

Exhibit

Options

ACommon language runtime (CLR)
BExtensible Markup Language (XML)
Ca table-valued parameter (TVP)

Explanation

Procedure1 should use a Table-Valued Parameter (TVP) because TVPs are specifically designed to allow multiple rows of data to be passed into a stored procedure as a structured table, which directly satisfies the requirement. Procedure2 should use Common Language Runtime (CLR) integration because CLR stored procedures allow .NET Framework assemblies to be referenced and executed within SQL Server, enabling business logic written in managed code (C#, VB.NET, etc.) to run inside the database engine. XML could technically pass multiple rows of data but is not the purpose-built, efficient solution that TVPs provide for this use case.

Topics

#SQL Server Stored Procedures#Table-Valued Parameters#CLR Integration#T-SQL Design

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice