PrepAway - Latest Free Exam Questions & Answers

So what should you do to insert a new client record in the table

You work in an international company which is named TXTWIN. And you’re in charge of the company network and use Microsoft BizTalk Server 2006 R2.
You store all client information in a single table by using Microsoft SQL Server 2005. The structure of the table never changes. But in the database, the security policy forbids new stored procedures to be created. The use of dynamic SQL is not allowed either. So what should you do to insert a new client record in the table?

PrepAway - Latest Free Exam Questions & Answers

A.
You should send updategrams by using the SQL adapter.

B.
You should call the sp_executeSQL stored procedure by using the SQL adapter.

C.
You should configure the SQL adapters ConnectionString property and make the usage of Trusted Security included.

D.
You should configure the SQL adapters ConnectionString property and make the usage of Security Support Provider Interface (SSPI) included.

Explanation:
BURGOS: mnemo: “security policy forbids” = “updategrams”


Leave a Reply