You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
The application connects to a Microsoft SQL Server database.
You need to find out whether the application is explicitly closing or disposing SQL connections. Which code
segment should you use?

• A. string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• B. string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• C. string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• D. string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application retreives data from Microsoft SQL Server 2008 database named AdventureWorks. The AdventureWorks.dbo.ProductDetails table contains a column names ProductImages that uses a varbinary(max) data type.
You write the following code segment. (Line numbers are included for reference only.)
01 SqlDataReader reader = command.ExecureReader(--empty phrase here --);
02 while(reader.Read())
03 {
04 pubID = reader.GetString(0);
05 stream = new FileStream(...);
06 writer = new BinaryWriter(stream);
07 startIndex = 0;
08 retval = reader.GetBytes(1, startIndex, outByte, 0, bufferSize);
09 while(retval == bufferSize)
10 {
11 ...
12 }
13 writer.Write(outbyte, 0, (int)retval-1);
14 writer.Flush();
15 writer.Close();
16 stream.Close();
17 }
You need to ensure that the code supports streaming data from the ProductImages column. Which code segment should you insert at the empty phrase in line 01?

• A. CommandBehavior.SequentialAccess
• B. CommandBehavior.KeyInfo
• C. CommandBehavior.Default
• D. CommandBehavior.SingleResult

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that uses the Entity Framework.
The build configuration is set to Release. The application must be published by using Microsoft Visual Studio 2010, with the following requirements:
-The database schema must be created on the destination database server.
-The Entity Framework connection string must be updated so that it refers to the destination database server.
You need to configure the application to meet the requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Include the source database entry in the Package/Publish SQL tab and update the connection string for the destination database.
• B. Generate the DDL from the Entity Framework Designer and include it in the project. Set the action for the DDL to ApplicationDefinition.
• C. Set Items to deploy in the Package/Publish Web tab to All files in this Project Folder for the release configuration.
• D. Use the web.config transform file to modify the connection string for the release configuration.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML document:
<bib> <book title="TCP/IP Illusrated" year="1994">
<author>Author1</author>
</book>
<book title="Programming in UNIX" year="1992">
<author>Author1</author>
<author>Author2</author>
<author>Author3</author>
</book>
<book title="Data on the web" year="2000">
<author>Author4</author>
<author>Author3</author>
</book> </bib>
You add the following code fragment. (Line numbers are included for reference only.)
01 public IEnumerable<XElement> GetBooks(string xml)
02 {
03 XDocument doc = XDocument.Parse(xml);
04 ...
05 }
You need to return a list of book XML element that are authored by Author1. Which code segment should you insert at line 04?

• A. return doc.Elements("bib").Elements()
  .Where(e1 => e1.Elements().Any(e2 => e2.Equals(new XElement("author", "Author1"))));
• B. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => (string)e2 == "Author1"));
• C. return doc.Elements("bib").Elements() .Where(e1 => e1.Elements().Any(e2 => (string)e2 == "Author1"));
• D. return doc.Element("bib").Elements() .SelectMany(el => el.Elements() .Where(e2 => e2.Equals(new XElement("author", "Author1"))));