070-516 무료 덤프문제 온라인 액세스

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.
The conceptual schema definition language (CSDL) file contains the following XML fragment.
<EntityType Name="Contact"> ... <Property Name="EmailPhoneComplexProperty"
Type="AdventureWorksModel.EmailPhone" Nullable="false" />
</EntityType>
...
<ComplexType Name="EmailPhone">
<Property Type="String" Name="EmailAddress" MaxLength="50" FixedLength="false" Unicode="true" />
<Property Type="String" Name="Phone" MaxLength="25" FixedLength="false" Unicode="true" /> </ComplexType>
You write the following code segment. (Line numbers are included for reference only.)
01 using (EntityConnection conn = new EntityConnection("name=AdvWksEntities"))
02 {
03 conn.Open();
04 string esqlQuery = @"SELECT VALUE contacts FROM
05 AdvWksEntities.Contacts AS contacts
06 WHERE contacts.ContactID == 3";
07 using (EntityCommand cmd = conn.CreateCommand())
08 {
09 cmd.CommandText = esqlQuery;
10 using (EntityDataReader rdr = cmd.ExecuteReader())
11 {
12 while (rdr.Read())
13
{
14
...
15
}
16
}
17
}
18 conn.Close(); 19 }
You need to ensure that the code returns a reference to a ComplexType entity in the model named
EmailPhone.
Which code segment should you insert at line 14?

• A.IExtendedDataRecord record = rdr["EmailPhone"]as IExtendedDataRecord; int FldIdx = 0; return record.GetValue(FldIdx);
• B.int FldIdx = 0; EntityKey key = record.GetValue(FldIdx) as EntityKey; foreach (EntityKeyMember keyMember in key.EntityKeyValues)
  {
  return keyMember.Key + " : " + keyMember.Value;
  }
• C.int fieldCount = rdr["EmailPhone"].DataRecordInfo.FieldMetadata.Count; for (int FldIdx = 0; FldIdx < fieldCount; FldIdx++) {
  rdr.GetName(FldIdx);
  if (rdr.IsDBNull(FldIdx) == false)
  {
  return rdr["EmailPhone"].GetValue(FldIdx).ToString();
  }
  }
• D.DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord; return nestedRecord;

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().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", 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().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You create stored procedures by using the following signatures:
CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price
float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp
timestamp)
CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit:

You need to map the Product and Order entities to the stored procedures. To which two procedures should
you add the @productId parameter?
(Each correct answer presents part of the solution. Choose two.)

• A.Order_Update
• B.Product_Delete
• C.Product_Update
• D.Order_Delete

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.
The application allows users to make changes while disconnected from the data store.
Changes are submitted to the data store by using the SubmitChanges method of the DataContext object.
You receive an exception when you call the SubmitChanges method to submit entities that a user has
changed in offline mode.
You need to ensure that entities changed in offline mode can be successfully updated in the data store.
What should you do?

• A.Call the SubmitChanges method of DataContext with a value of System.Data.Linq.ConflictMode.ContinueOnConflict.
• B.Set the ObjectTrackingEnabled property of DataContext to true.
• C.Call the SaveChanges method of DataContext with a value of false.
• D.Set the DeferredLoadingEnabled property of DataContext to true.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the Entity Framework Designer to create an Entity Data Model (EDM).
You need to create a database creation script for the EDM. What should you do?

• A.Run the Generate Database command.
• B.Select Run Custom Tool from the solution menu.
• C.Drag entities to Server Explorer.
• D.Use a new Self-Tracking Entities template.