070-516 by Microsoft Actual Free Exam Questions And Answers

Question 1

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE dbo.GetClassAndStudents AS BEGIN
SELECT * FROM dbo.Class
SELECT * FROM dbo.Student
END
You create a SqIConnection named conn that connects to the database.
You need to fill a DataSet from the result that is returned by the stored procedure.
The first result set must be added to a DataTable named Class, and the second result set must be added to
a DataTable named Student.
Which code segment should you use?

A. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ds.Tables.Add("Class"); ds.Tables.Add("Student"); ad.Fill(ds);

B. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.MissingMappingAction = MissingMappingAction.Ignore; ad.Fill(ds, "Class"); ad.Fill(ds, "Student");

C. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.TableMappings.Add("Table", "Class"); ad.TableMappings.Add("Table1", "Student") ; ad.Fill(ds) ;

D. DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter("GetClassAndStudents", conn); ad.Fill(ds);

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application updates several Microsoft SQL Server databases within a single transaction.
You need to ensure that after a resource failure, you can manage unresolved transactions. What should
you do?

A. Call the Reenlist method of the TransactionManager class.

B. Call the EnlistDurable method of the Transaction class.

C. Call the EnlistVolatile method of the Transaction class.

D. Call the RecoveryComplete method of the TransactionManager class.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

You add a table to the database to track changes to part names. The table stores the following row values:
-the username of the user who made the change
-a part ID
-the new part name
-a DateTime value
You need to ensure detection of unauthorized changes to the row values.
You also need to ensure that database users can view the original row values.

A. Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.

B. Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.

C. Add a column named signature. Use System.Security.Cryptography.RSA to create a signature for all of the row values. Store the signature in the signature column. Publish only the public key internally.

D. Add a column named hash. Use System.Security.Cryptography.MD5 to create an MD5 hash of the row values, and store in the hash column.

Discussion 0

Correct Answer: C Vote an answer

Question 4

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to create a Plain Old CLR Object (POCO) class that can be used with the
ObjectContext.CreateObject method to create a proxy.
What should you do?

A. Create a custom data class in which all properties and methods are virtual.

B. Create a custom data class that has a Protected constructor that does not have parameters.

C. Create a custom data class that is sealed.

D. Create a custom data class that is abstract.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create the following Entity Data Model.

You write a method named ValidatePostalCode to validate the postal code for the application.
You need to ensure that the ValidatePostalCode method is called before the PostalCode property set
method is completed and before the underlying value has changed.
Which code segment should you place in the entity's partial class?

A. partial void OnPostalCodeChanged(string value) {
PostalCode = GetValidValue<string>(value, "ValidatePostalCode", false, true) ;
}

B. public string ValidatedPostalCode
{
set
{
_PostalCode = StructuralObject.SetValidValue("ValidatePostalCode", false);
}
get
{
return _PostalCode;
}
}

C. public string ValidatedPostalCode
{
set
{
ValidatePostalCode(value);
_PostalCode = value;
}
get
{
return _PostalCode;
}
}

D. partial void OnPostalCodeChanging(string value) {
ValidatePostalCode(value);
}

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

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.mdac

B. ctrl.guid.adonet

C. ctrl.guid.snac10

D. ctrl.guid.msdadiag

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

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 need to create a database from your model. What should you do?

A. Use the Update Model Wizard in Visual Studio.

B. Use the Generate Database Wizard in Visual Studio. Run the resulting script against a Microsoft SQL Server database.

C. Run the edmgen.exe tool in FromSSDLGeneration mode.

D. Run the edmgen.exe tool in FullGeneration mode.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database.
You need to ensure that the application calls a stored procedure that accepts a table-valued parameter.
You create a SqlParameter object. What should you do next?

A. Set the SqlDbType of SqlParameter to Udt.

B. Set the SqlDbType of SqlParameter to Variant.

C. Set the ParameterDirection of SqlParameter to Output.

D. Set the SqlDbType of SqlParameter to Structured. Set the TypeName of SqlParameter to Udt.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

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 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"); }

D. Insert the following code segmen at line 06:
Proxy.Credentials = new NetworkCredential("WRAP access_token", "123456789");

Discussion 0

Correct Answer: C Vote an answer

Question 10

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use Microsoft ADO.NET Entity Data Model (EDM) to model entities.
You create an entity named Person with a schema defined by the following XML fragment.
<EntityType Name="CPerson"> <Key> <PropertyRef Name="PersonId" /> </Key>
<Property Name="PersonId" Type="Int32" Nullable="false" />
<Property Name="CompanyName" Type="String" />
<Property Name="ContactName" Type="String" />
<Property Name="ContactTitle" Type="String" />
<Property Name="Address" Type="String" />
</EntityType>
You need to ensure that entities within the application are able to add properties related to the city, region,
and country of Person's address.
What should you do?

A. Create a new entity named Address. Add a person ID property to filter the results to display only the City, Region, and Country properties for a specific Person entity.

B. Create a view named Name that returns city, region, and country along with person IDs. Add a WHERE clause to filter the results to display only the City, Region and Country properties for a specific Person entity.

C. Create a new complex type named CAddress that contains the properties for city, region, and country. Change the Type of the Address property in CPerson to "Self.CAddress".

D. Create a SubEntity named Address. Map the SubEntity to a stored procedure that retrieves city, region, and country.

Discussion 0

Correct Answer: C Vote an answer

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 - 070-516 Exam Practice Test

Contact Us

Useful Links

Latest Updated