Study with 70-516 most valid questions & verified answers

Microsoft 70-516 Exam Overview:

Microsoft 70-516 Exam Syllabus Topics:

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. 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 ();

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database.
CREATE TABLE ObjectCache ( Id INT IDENTITY PRIMARY KEY, SerializedObjectData XML)
You write the following code segment to retreive records from the ObjectCache table. (Line numbers are included for reference only.)
01 string s = GetConnectionStringFromConfigFile("xmldb");
02 using (SqlConnection conn = new SqlConnection(s))
03 using (SqlCommand cmd = new SqlCommand("select * from ObjectCache",
conn))
04 {
05 conn.Open();
06 SqlDataReader rdr = cmd.ExecuteReader();
07 while(rdr.Read())
08 {
09 ...
10 DeserializeObject(obj);
11 }
12 }
You need to retreive the data from the SerializedObjectData column and pass it to a method named
DeserializeObject.
Which line of code should you insert at line 09?

A) SByte obj = (SByte)rdr[1];
B) Type obj = (Type)rdr[1];
C) XmlReader obj = (XmlReader)rdr[1];
D) String obj = (String)rdr[1];

3. 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("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;
B) 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;
C) 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;
D) 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;

4. 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.
You write the following code segment that executes two commands against the database within a
transaction.
(Line numbers are included for reference only.)
01 using(SqlConnection connection = new SqlConnection(cnnStr)) {
02 connnection.Open();
03 SqlTransaction sqlTran = connection.BeginTransaction();
04 SqlCommand command = connection.CreateCommand();
05 command.Transaction = sqlTran;
06 try{
07 command.CommandText = "INSERT INTO Production.ScrapReason(Name)
VALUES('Wrong size')";
08 command.ExecuteNonQuery();
09 command.CommandText = "INSERT INTO Production.ScrapReason(Name)
VALUES('Wrong color')";
10 command.ExecuteNonQuery();
11 ...
l2 }
You need to log error information if the transaction fails to commit or roll back. Which code segment should you insert at line 11?

A) catch (Exception ex){ Trace.WriteLine(ex.Message); try{
sqlTran.Rollback();
}
catch (Exception exRollback){
Trace.WriteLine(exRollback.Message);
}
}
finaly {
sqltran.commit( );
}
B) catch (Exception ex) { sqlTran.Rollback();
Trace.WriteLine(ex.Message);
}
finaly {
try {
sqltran.commit( );
}
catch (Exception exRollback) {
Trace.WriteLine(excommit.Message);
}
}
C) sqlTran.Commit(); } catch (Exception ex) {
sqlTran.Rollback();
Trace.WriteLine(ex.Message);
}
D) sqlTran.Commit(); } catch (Exception ex) {
Trace.WriteLine(ex.Message);
try {
sqlTran.Rollback();
}
catch (Exception exRollback) {
Trace.WriteLine(exRollback.Message);
}
}

5. Refer to the following lines in the case study: PA40 in \Model\Part.cs, PR16 in\Model\Product.cs, and CT14 in \Model\Component.cs
The application must create XML files that detail the part structure for any product. The XML files must use the following format:
<?xml version="1.0" encoding="utf-8"?>
<product name="Brush" description="Brush product" productType="1">
<component name="Handle" description="Handle" partType="2">
<component name="Screw" description="Screw" partType="3">
<component name="Wood" description="Wooden shaft" partType="45">
</component>
<component name="Head" description="Head" partType="5">
<component name="Screw" description="Screw" partType="3">
<component name="Bristles" description="Bristles" partType="4">
</component> </product>
You need to update the application to support the creation of an XElement object having a structure that will
serialize to the format shown above.
What should you do? (Each correct answer presents part of the solution. Choose two.)

A) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XElement("name", this.Name),
new XElement("description", this.Description),
new XElement("productType", this.ProductType));
B) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XElement("name", this.Name),
new XElement("description", this.Description),
new XElement("partType", this.PartType));
C) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XAttribute("name", this.Name),
new XAttribute("description", this.Description),
new XAttribute("productType", this.ProductType));
D) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XAttribute("name", this.Name),
new XElement("description", this.Description),
new XElement("partType", this.PartType));
E) Insert the following code segment at line CT14 in \Model\Component.cs:
return new XElement("component, new XAttribute("name", this.Name),
new XAttribute("description", this.Description),
new XAttribute("partType", this.PartType));
F) Insert the following code segment at line PR16 in \Model\Product.cs:
return new XElement("product, new XAttribute("name", this.Name),
new XElement("description", this.Description),
new XElement("productType", this.ProductType));

Solutions: