Prepare with Microsoft : 070-516 exam braindumps as your best preparation materials

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
You plan to deploy the application to several shared client computers. You write the following code
segment.
(Line numbers are included for reference only.)
01 Configuration config = ConfigurationManager.OpenExeConfiguration
(exeConfigName);
02 ...
03 config.Save();
04 ...
You need to encrypt the connection string stored in the .config file. Which code segment should you insert at line 02?

• A. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
• B. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
• C. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
• D. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");

The application must provide a component part list for any product. The component part list must give the
quantity of
each distinct part that is required to manufacture that product.
You need to create a LINQ expression that delivers a a result of type IEnumerable<Tuple<int,Part>> to
meet the requirements.
Which expression should you use?

• A. IEnumerable<Tuple<int, Part>> result = part.Children .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• B. IEnumerable<Tuple<int, Part>> result = part.Descendants .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• C. IEnumerable<Tuple<int, Part>> result = part.Descendants .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• D. IEnumerable<Tuple<int, Part>> result = part.Children .Distinct() .GroupBy(p => p) .Select(g => Tuple.Create(g.Count(), g.Key));
• E. IEnumerable<Tuple<int, Part>> result = part.Descendants .ToDictionary(c => c) .Select(d => Tuple.Create(d.Value.Children.Count(), d.Key));

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a multi-tier application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
The model contains entities named SalesOrderHeader and SalesOrderDetail.
For performance considerations in querying SalesOrderHeader, you detach SalesOrderDetail entities from
ObjectContext.
You need to ensure that changes made to existing SalesOrderDetail entities updated in other areas of your
application are persisted to the database.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Set the MergeOption of SalesOrderDetail to MergeOptions.OverwriteChanges.
• B. Set the MergeOption of SalesOrderDetail to MergeOptions.NoTracking.
• C. Re-attach the SalesOrderDetail entities.
• D. Call ObjectContext.ApplyCurrentValue.
• E. Call ObjectContext.ApplyOriginalValue.

The database contains a table named Categories. The Categories table has a primary key identity column
named CategoryID.
The application inserts new records by using the following stored procedure.
CREATE PROCEDURE dbo.InsertCategory @CategoryName nvarchar(15), @Identity int OUT
AS INSERT INTO Categories (CategoryName) VALUES(@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You write the following code segment.
SqlDataAdapter adapter = new SqlDataAdapter("SELECT categoryID, CategoryName
FROM dbo.Categories",connection);
adapter.InsertCommand = new SqlCommand("dbo.InsertCategory", connection);
adapter.InsertCommand.CommandType = commandType.StoredProcedure;
adapter.InsertCommand.Parameters.Add(new SqlParameter("@CategoryName",
SqlDbType.NVarChar, 15,"CategoryName"));
You need to retrieve the identity value for the newly created record. Which code segment should you add?

• A. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
• B. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
• C. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;
• D. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;

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 uses the ADO.NET Entity
Framework to manage order data.
The application makes a Web service call to obtain orders from an order-tracking system.
You need to ensure that the orders are added to the local data store. Which method should you call on the
ObjectContext?

• A. Attach
• B. ApplyCurrentValues
• C. AddObject
• D. AttachTo