You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 server.
You need to ensure that applications authenticate against user information stored in the database before
the application is allowed to use the service.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Configure IIS to allow anonymous access.
• B. Configure IIS to require basic authentication.
• C. Configure IIS to require Windows authentication.
• D. Enable the WCF Authentication Service.
• E. Modify the Data Services service to use a Microsoft ASP.NET membership provider.

You use Microsoft .NET framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database 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. Which connection string should you add
to the .config file?

• A. Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;
• B. Data Source=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;
• C. Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;
• D. Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;

You add a table to the database to track changes to part names. The table stores the following row values:
-the username of the user who made the change
-a part ID
-the new part name
-a DateTime value
You need to ensure detection of unauthorized changes to the row values.
You also need to ensure that database users can view the original row values.

• A. Add a column named signature. Use System.Security.Cryptography.RSA to create a signature for all of the row values. Store the signature in the signature column. Publish only the public key internally.
• B. Add a column named hash. Use System.Security.Cryptography.MD5 to create an MD5 hash of the row values, and store in the hash column.
• C. Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
• D. Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.

You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses
Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server
as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the
number of pools to a minimum.
Which code segment should you use?

• A. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• B. command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• C. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• D. command.CommandText = "exec uspLoginAudit;";
  using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
  connection.Open();
  command.ExecuteNonQuery();
  }

You are developing a new feature in the application to display a list of all bundled products.
You need to write a LINQ query that will return a list of all bundled products. Which query expression should
you use?

• A. context.Parts.Cast<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))
• B. context.Parts.OfType<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))
• C. context.Parts.Cast<Product>() .Where(p => p.Descendants.Any(d => d is Product))
• D. context.Parts.OfType<Product>() .Where(p => p.Descendants.Any(d => d is Product))