The Microsoft test 70-561 is designed to measure an individual’s ability to design and develop ADO.NET applications by using the Microsoft .NET Framework 3.5. Before taking the 70-561 test, you should practice the following:
- Manage connection string and use the ConnectionStringBuilder.
- Leverage the ConfigurationManager and protect the connection string.
- Use Security Support Provider Interface (SSPI) or SQL Server authentication and address the SQL Server instance.
- Manage “User Instance” and AttachDBfilename.
- Manage connection objects, connection state, and connection pool.
- Implement persistent data connections and Multiple Active Result Sets (MARS).
- Encrypt and decrypt data.
- Work with data providers such as ODBC, Microsoft OLE Db, SqlClient, etc.
- Identify the limitations, behaviors, performance, installation issues, and deployment issues of data providers.
- Manage providers, native providers, and third-party providers.