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:

  1. Manage connection string and use the ConnectionStringBuilder.
  2. Leverage the ConfigurationManager and protect the connection string.
  3. Use Security Support Provider Interface (SSPI) or SQL Server authentication and address the SQL Server instance.
  4. Manage “User Instance” and AttachDBfilename.
  5. Manage connection objects, connection state, and connection pool.
  6. Implement persistent data connections and Multiple Active Result Sets (MARS).
  7. Encrypt and decrypt data.
  8. Work with data providers such as ODBC, Microsoft OLE Db, SqlClient, etc.
  9. Identify the limitations, behaviors, performance, installation issues, and deployment issues of data providers.
  10. Manage providers, native providers, and third-party providers.
  11. Continue reading