070-523 by Microsoft Actual Free Exam Questions And Answers

Question 1

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application uses the ADO.NET Entity Framework to model entities. The application allows users to make
changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the
application meets the following requirements:
*Changes made to the local data store in disconnected mode are preserved.
*Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data.
What should you do?

A. Call the query's Execute method by using the MergeOptions.OverwriteChanges option.

B. Call the query's Execute method by using the MergeOptions.AppendOnly option.

C. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins method.

D. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.

Discussion 0

Correct Answer: C Vote an answer

Question 2

A Windows Communication Foundation (WCF) service has the following contract.
[ServiceContract(Namespace="http://contoso.com")]
public interface IShipping
{ [OperationContract] string DoWork(int id);
}
This is one of several service contracts hosted by your application. All endpoints use SOAP 1.2 bindings
with WS-Addressing 1.0. The System.ServiceModel.MessageLogging trace source in the system.
diagnostics configuration section is configured with one listener.
You need to make sure that only the messages that are returned from the DoWork operation are logged.
Which XML segment should you add to the system.serviceModel/diagnostics/messageLogging/filters
configuration element?

A. <add xmlns:addr="http://www.w3.org/2005/08/addressing"> //addr:Action[text() = 'http://contoso.com/IShipping/DoWorkResponse'] </add>

B. <add xmlns:addr="http://www.w3.org/2005/08/addressing"> //addr:Action[text() = 'http://contoso.com/IShipping/DoWork'] </add>

C. <add xmlns:soap="http://www.w3.org/2003/05/soap-envelope"> //soap:Action[text() = 'http://contoso.com/IShipping/DoWorkResponse'] </add>

D. <add xmlns:soap="http://www.w3.org/2003/05/soap-envelope"> //soap:Action[text() = 'http://contoso.com/IShipping/DoWork'] </add>

Discussion 0

Correct Answer: A Vote an answer

Question 3

You create a page in an ASP.NET Web application. The page retrieves and displays data from a Microsoft SQL Server database. You need to create a data source that can connect to the database. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A. Use an XmlDataSource control together with an Xml control that represents the database.

B. Use an ObjectDataSource control and set its TypeName property to System.Data.SqlClient. SqlConnection.

C. Use a SqlDataSource control and configure its ConnectionString in the web.config file.

D. Use a LinqDataSource control with entity classes that represent the elements in the database.

Discussion 0

Correct Answer: C,D Vote an answer

Question 4

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

A. Trace.WriteLine(productQuery.ToString());

B. Trace.WriteLine(productQuery.ToTraceString());

C. Trace.WriteLine(productQuery.CommandText);

D. Trace.WriteLine(((IQueryable)productQuery).Expression);

Discussion 0

Correct Answer: B Vote an answer

Question 5

You are creating a Windows Communication Foundation (WCF) service that implements operations in a
RESTful manner.
You need to add a delete operation.
You implement the delete method as follows.
string void DeleteItems(string id);
You need to configure WCF to call this method when the client calls the service with the HTTP DELETE
operation. What should you do?

A. Add the HttpDelete attribute to the operation.

B. Replace the return type with RemovedActivityAction.

C. Replace the string parameter with a RemovedActivityAction parameter.

D. Add the WebInvoke(UriTemplate = "/Items/{id}",Method="DELETE") attribute to the operation.

Discussion 0

Correct Answer: D Vote an answer

Question 6

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You are
creating the data layer of the application. You write the following code segment. (Line numbers are included
for reference only.)
01 public static SqlDataReader GetDataReader(string sql){
02 SqlDataReader dr;
03
04 return dr;
05 }
You need to ensure that the following requirements are met:
*The SqlDataReader returned by the GetDataReader method can be used to retrieve rows from the
database.
*SQL connections opened within the GetDataReader method will close when the SqlDataReader is closed.
Which code segment should you insert at line 03?

A. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
dr = cmd.ExecuteReader();
}
finally {
cnn.Close();
}

B. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch {
cnn.Close();
throw;
}

C. SqlConnection cnn=new SqlConnection(strCnn); SqlCommand cmd =new SqlCommand(sql, cnn); cnn.Open(); try {
dr = cmd.ExecuteReader();
cnn.Close();
}
catch {
throw;
}

D. using (SqlConnection cnn=new SqlConnection(strCnn)){
try {
SqlCommand cmd =new SqlCommand(sql, cnn);
cnn.Open();
dr = cmd.ExecuteReader();
}
catch {
throw;
}
}

Discussion 0

Correct Answer: B Vote an answer

Question 7

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use the ADO.NET Entity Data Model (EDM) to define a Customer entity. You need to add a new Customer to the data store without setting all the customer's properties. What should you do?

A. Call the Create method of the Customer object.

B. Override the SaveChanges method for the Customer object.

C. Call the CreateObject method of the Customer object.

D. Override the Create method for the Customer object.

Discussion 0

Correct Answer: C Vote an answer

Question 8

You use Microsoft Visual Studio 2010 and Microsoft. NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. You use Entity SQL of the ADO.NE Entity Framework to retrieve data from the database. You need to define a custom function in the conceptual model. You also need to ensure that the function calculates a value based on properties of the object. Which two XML element types should you use? (Each correct answer presents part of the solution. Choose two.)

A. Dependent

B. DefiningExpression

C. Function

D. FunctionImport

E. Association

Discussion 0

Correct Answer: B,C Vote an answer

Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev - 070-523 Exam Practice Test

Contact Us

Useful Links

Latest Updated