Free Microsoft 70-516 Exam Dumps Questions & Answers

You use Microsoft .NET Framework 4.0 to develop an ASP.NET 4 Web application.
You need to encrypt the connection string information that is stored in the web.config file. The application is
deployed to multiple servers.
The encryption keys that are used to encrypt the connection string information must be exportable and
importable on all the servers.
You need to encrypt the connection string section of the web.config file so that the file can be used on all of
the servers.
Which code segment should you use?

• A.Configuration config = WebConfigurationManager.OpenWebConfiguration("~") ; ConnectionStringsSection section = (ConnectionStringsSection)config.GetSection("connectionStrings"); section.Sectionlnformation.ProtectSection("RsaProtectedConfigurationProvider"); config.Save();
• B.Configuration config = WebConfigurationManager.OpenMachineConfiguration("~"); ConnectionStringsSection section = (ConnectionStringsSection)config.GetSection("connectionStrings"); section.Sectionlnformation.ProtectSection("RsaProtectedConfigurationProvider'*); config.Save();
• C.Configuration config = WebConfigurationManager.OpenMachineConfiguration ("~") ; ConnectionStringsSection section = (ConnectionStringsSection)config.GetSection ("connectionStrings") ; section.Sectionlnformation.ProtectSection("DpapiProtectedConfigurationProvider"); config.Save () ;
• D.Configuration config = WebConfigurationHanager.OpenWebConfiguration ("~") ; ConnectionStringsSection section = (ConnectionStringsSection)config.GetSection ("connectionStrings") ; section.Sectionlnformation.ProtectSection("DpapiProtectedConfigurationProvider"); config.Save ();

You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4.0 application. You create an Entity Data Model for the database tables shown in the following diagram.

You need to modify the .edmx file so that a many-to-many association can exist between the Address and
Customer entities.
Which storage Model section of the .edmx file should you include?

• A.<EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50" />
  </EntityType>
• B.<EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false" />
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"
  DefaultValue="Home" />
  </EntityType>
• C.<EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerAddressID" />
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• D.<EntityType Name="CustomerAddress"> <Key>
  <PropertyRef Name="CustomerAddressID" /> </Key> <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>

The entity data model must be configured to provide a way you cal the sp_FindObsolete stored procedure. The returned data must implement the Descendants property.
In Visual Studio 2010, you open the Add functions Import dialog box from the EDMX diagram and enter the information shown in the following graphic.

You need to complete the configuration in the dialog box. What should you do?

• A.In the Returns a Collection Of area, click Scalars and then, in the Scalars list, click Int32
• B.Click the Get Column Information button, click Create New Complex Type and then, in the Complex box, enter Parts.
• C.In the Returns a Collection Of area, click Scalars and then, in the Scalars list, click string
• D.In the Returns a Collection Of area, click Entities and then, in the Entities list, click Component

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",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• B.string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• C.string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• D.string instanceName = Assembly.GetEntryAssembly().GetName().Name; 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.
The application connects to a Microsoft SQL Server database.
The application has two DataTable objects that reference the Customers and Orders tables in the
database.
The application contains the following code segment. (Line numbers are included for reference only.)
01 DataSet customerOrders = new DataSet();
02 customerOrders.EnforceConstraints = true;
03 ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04 customerOrders.Tables
["Customers"].Columns["CustomerID"],
05 customerOrders.Tables["Orders"].Columns
["CustomerID"]);
06 ...
07 customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have related Order records.
Which code segment should you insert at line 06?

• A.ordersFK.DeleteRule = Rule.SetDefault;
• B.ordersFK.DeleteRule = Rule.SetNull;
• C.ordersFK.DeleteRule = Rule.Cascade;
• D.ordersFK.DeleteRule = Rule.None;