You use Microsoft .NET framework 4 to develop an application that connects to a Microsoft SQL
Serve 2008database named AdventureWorksLT. The database resides on an instance named INSTA
on a server named SQL01. You need to configure the application to connect to the database.
A.
Data Source=SQL01; Initial Catalog=INSTA;
Integrated Security=true;
Application Name=AdventureWorksLT;
B.
Data Source=SQL01;
Initial Catalog=AdventureWorksLT;
Integrated Security=true;
Application Name=INSTA;
C.
Data Source=SQL01\INSTA;
Initial Catalog=AdventureWorksLT;
Integrated Security=true;
D.
Data Source=AdventureWorksLT;
Initial Catalog=SQL01\INSTA;
Integrated Security=true;
Explanation:
CHAPTER 2 ADO.NET Connected Classes
Lesson 1: Connecting to the Data Store
Configuring an SQL Server Connection String (page 70-71)