Microsoft
70-516 · Question #87
You want to set up a secure connection between your application and SQL Server. SQL Server has a trusted certificate that is set up properly. What must you do?
The correct answer is B. Add Encrypt=true to the connection string. See the full explanation below for the reasoning.
Question
You want to set up a secure connection between your application and SQL Server. SQL Server has a trusted certificate that is set up properly. What must you do?
Options
- AExecute BeginTransaction on the command object.
- BAdd Encrypt=true to the connection string.
- CEncrypt the CommandText property on the command object.
- DClose the connection before sending the command.
How the community answered
(38 responses)- A8% (3)
- B71% (27)
- C16% (6)
- D5% (2)
Community Discussion
No community discussion yet for this question.