You are developing an ADO.NET 4.0 application that interacts with a Microsoft SQL Server 2008 server
through the SQL Server Native Client.
You create a trace DLL registry entry and you register all of the trace schemas.
You need to trace the application data access layer. Which control GUID file should you use?

• A. ctrl.guid.snac10
• B. ctrl.guid.mdac
• C. ctrl.guid.msdadiag
• D. ctrl.guid.adonet

The database contains orphaned Color records that are no longer connected to Part records.
You need to clean up the orphaned records. You have an existing ContosoEntities context object named
context.
Which code segment should you use?

• A. var unusedColors = context.Colors.Where(c => !c.Parts.Any()); context.DeleteObject(unusedColors); context.SaveChanges();
• B. context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges();
• C. context.Colors.ToList().RemoveAll(c => !c.Parts.Any()); context.SaveChanges();
• D. var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){
  context.DeleteObject(unused)
  }
  context.SaveChanges();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities. You create an entity as shown in
the following code fragment.
<EntityType Name="ProductCategory">
<Key>
<PropertyRef Name="ProductCategoryID" />
</Key>
<Property Name="ProductCategoryID" Type="int" Nullable="false" StoreGeneraedPattern="Identity" />
<Property Name="ParentProductCategoryID" Type="int" />
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
...
</EntityType>
You need to provide two entity-tracking fields:
-rowguid that is automatically generated when the entity is created
-ModifiedDate that is automatically set whenever the entity is updated. Which code fragment should you add to the .edmx file?

• A. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
• B. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
• C. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>
• D. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
WCF Data Services uses an authentication scheme that requires an HTTP request that has the following
header format:
GET /Odata.svc/Products(1)
Authorization: WRAP access_token="123456789"
The application includes the following code. (Line numbers are included for reference only.)
01 public class program
02 {
03 Public void GetProducts()
04 {
05 var proxy = new MyDataServiceContext("...");
06 ...
07 }
08 }
You need to ensure that the correct authentication header is present when requests are made by using
MyDataServiceContext.
What should you do?

• A. Insert the following code segment at line 06:
  Proxy.Credentials = new NetworkCredential("Authorization", "WRAP
  access_token=\"123456789"\"");
• B. Insert the following code segmen at line 06:
  Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
  (proxy_SendingRequest);
  Insert the following code segmen at line 09:
  void proxy_SendingRequest(object sender, SendingRequestEventArgs e){
  e.RequestsHeaders.Add("WRAP access_token", "123456789");
  }
• C. Insert the following code segmen at line 06:
  Proxy.Credentials = new NetworkCredential("WRAP access_token", "123456789");
• D. Insert the following code segment at line 06:
  Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
  (proxy_SendingRequest);
  Insert the following code segment at line 09:
  void proxy_SendingRequest(object sender, SendingRequestEventArgs e){ e.RequestsHeaders.Add("Authorization","WRAP access_token", "123456789"); }

You use Microsoft .NET Framework 4.0 to develop an application that connects to a local Microsoft SQL
Server 2008 database.
The application can access a high-resolution timer. You need to display the elapsed time, in sub-
milliseconds (<1 millisecond),
that a database query takes to execute. Which code segment should you use?

• A. Stopwatch sw = Stopwatch.StartNew(); command.ExecuteNonQuery() ; sw.Stop() ; Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.TotalMilliseconds);
• B. Stopwatch sw = new Stopwatch(); sw.Start() ; command.ExecuteNonQuery(); sw.Stop(); Console.WriteLine("Time Elapsed: {0:N} ms", sw.Elapsed.Milliseconds);
• C. DateTime Start = DateTime.UtcNow; command.ExecuteNonQuery(); TimeSpan Elapsed = DateTime.UtcNow - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed.Milliseconds);
• D. int Start = Environment.TickCount; command.ExecuteNonQuery(); int Elapsed = (Environment.TickCount) - Start; Console.WriteLine("Time Elapsed: {0:N} ms", Elapsed);