Scenario: You are developing a .NET application that needs to connect to a SQL Server database securely. Which attribute in the connection string would you use to achieve this?
- Integrated Security
- Encrypt
- TrustServerCertificate
- Connection Timeout
The correct option is "Encrypt." By setting the Encrypt attribute to true in the connection string, you can ensure that the data exchanged between the .NET application and the SQL Server database is encrypted, enhancing security. This is crucial for protecting sensitive information during transit. Integrating security through encryption helps in safeguarding the confidentiality and integrity of data.
Loading...
Related Quiz
- Explain how Entity Framework handles database migrations and versioning.
- What is the purpose of RowFilter property in a DataView?
- In Entity Framework, optimistic concurrency control helps prevent ___________ conflicts.
- When modifying data in datasets, what does "CRUD" stand for?
- In ADO.NET, you can execute a stored procedure using the ___________ method of the SqlCommand object.