MCQOPTIONS
Saved Bookmarks
| 1. |
You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01._x005F_x000D_ The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication._x005F_x000D_ You want to add a page to your ASP.NET application to display inventory data from FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use? |
| A. | ?Server=XYZ01;Data Source=Factory; Initial Catalog=FactoryDB;Integrated Security=SSPI? |
| B. | ?Server=XYZ01;Data Source=Factory; Database=FactoryDB;Integrated Security=SSP1? |
| C. | ?Data Source=XYZ01\Factory; Initial Category=Factory; Integrated Security=SSP1? |
| D. | ?Data Source=XYZ01\Factory; Database=FactoryDB; Integrated Security=SSP1? |
| Answer» E. | |