Microsoft 70-487 Dumps Questions 2021

NEW QUESTION 1
DRAG DROP
You are developing a WCF Data Services service in Visual Studio 2012 to display movie information from a SQL Server database that changes every 24 hours. The service is defined in the following class.

The application contains the following Entity Framework model.

The service must only return data for movies that are currently in theaters.
You need to add a method to the MovieService class to filter the dat a.
How should you build the method? (To answer, drag the appropriate code segments to the correct location or locations in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

Answer:

Explanation:

NEW QUESTION 2
Errors occasionally occur when saving data using the FlightInfoContext ADO.NET Entity Framework context. Updates to the data are being lost when an error occurs.
You need to ensure that data is still saved when an error occurs by retrying the operation. No
more than five retries should be performed.
With which code segment should you replace the body of the SaveChanges() method in the FlightInfoContext.es file?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

Explanation:
EntitySqlException: Represents errors that occur when parsing Entity SQL command text. This exception is thrown when syntactic or semantic rules are violated.
SqlException: The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited.
EntityCommandExecutionException : Represents errors that occur when the underlying storage provider could not execute the specified command. This exception usually wraps a provider-specific exception.

Case Study: 2
ASP.NET MVC
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used to process orders.
Business Requirements
The application contains the following three pages:
✑ A page that queries an external database for orders that are ready to be processed. The user can then process the order.
✑ A page to view processed orders.
✑ A page to view vendor information.
The application consumes three WCF services to retrieve external data.
Technical Requirements Visual Studio Solution:
The solution contains the following four projects.
✑ ExternalQueue: A WCF service project used to communicate with the external order database.
✑ OrderProcessor: An ASP.NET MVC project used for order processing and logging order metadata.
✑ OrderUpload: A WCF service project used to submit order data to an external data source.
✑ Shipping: A WCF service project used to acquire shipping information.
ExternalQueue Project:
Entity Framework is used for data access. The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

The project contains two services defined in the following files.
✑ IExternalQueueService.es
✑ ExternalQueueService.svc.
The ExternalQueue.Helpers namespace contains a definition for a class named OrderNotFound Exception.
OrderProcessor Project:
Entity Framework is used for data access. The entities are defined in the ProcessedOrders.edmx file as shown in the following diagram.

The classes are contained in the OrderProcessor.Entities namespace. The project contains the following two controllers.
✑ InboundQueueController.es
✑ ProcessedOrderController.es
WCF service proxies to the ExternalQueue, Shipping and OrderUpload services have been generated by using the command prompt. The ExecuteCommandProcedure() method in the ExternalQueueService.svc file must run asynchronously.
The ProcessedOrderController controller has the following requirements.
The GetVendorPolicy() method must enforce a 10 minute absolute cache expiration policy. The GetProcessedOrders() method must return a view of the 10 most recently processed orders.
OrderUpload Project:
The project contains two services defined in the following files:
✑ IUploadCallbackService.es
✑ UploadCallbackService.svc
Data Access is maintained in a file named UploadOrder.es.
Shipping Project:
Entity Framework is used for data access. The entities are defined in the ExternalOrders.edmx file as shown in the following diagram.

The Custom Tool property for ExternalOrders.edmx has been removed.
POCO classes for the Entity Model are located in the ShippingAddress.es file. The POCO entity must be loaded by using lazy loading.
The project contains two services defined in the following files.
✑ IShippingService.es
✑ ShippingService.svc.
The IShippingService contract must contain an operation that receives an order number as a parameter. The operation must return a class named ShippingInfo that inherits from a class named State.
Application Structure

NEW QUESTION 3
DRAG DROP
You are developing a web application that uses the Entity Framework.
You plan to use the table-per-type mapping strategy to store the following dat a.

You need to implement a mapping strategy that will store the data.
How should you complete the code? To answer, drag the appropriate methods to the correct locations. Each method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: OnModelCreating
Box 2: Entity
Box 3: ToTable
Mapping an Entity Type to a Specific Table in the Database Example:
All properties of Department will be mapped to columns in a table called t_ Department. modelBuilder.Entity<Department>()
ToTable("t_Department"); Box 4: Entity
Box 5: ToTable
Mapping the Table-Per-Type (TPT) Inheritance
In the TPT mapping scenario, all types are mapped to individual tables. Properties that belong solely to a base type or derived type are stored in a table that maps to that type. Tables that map to derived types also store a foreign key that joins the derived table with the base table.
modelBuilder.Entity<Course>().ToTable("Course"); modelBuilder.Entity<OnsiteCourse>().ToTable("OnsiteCourse");
References: https://msdn.microsoft.com/en-us/library/jj591617(v=vs.113).aspx

NEW QUESTION 4
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have developed a .NET Standard Library. You need to produce a NuGet package. Solution: Run the dotnet pack command Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Package the component with the NuGet pack command.
References: https://docs.microsoft.com/en-us/nuget/guides/create-net-standard-packages- vs2015

NEW QUESTION 5
DRAG DROP
You are developing an ASP.NET MVC Web API application.
The methods of the Web API must return details about the result of the operation. You need to create methods to update and delete products.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5 to complete the code? (To answer, drag the appropriate code segments to the correct targets in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

Answer:

Explanation:

NEW QUESTION 6
You are designing an ASP.NET Web API application.
You need to select an HTTP verb to allow blog administrators to moderate a comment. Which HTTP verb should you use?

• A. GET
• B. POST
• C. DELETE
• D. PUT

Answer: D

NEW QUESTION 7
You are developing a .NET application that uses the HttpClient type to call an ASP.NET Web API application. The API call returns a list of customers in JSON format and logs the results. The URI for the API call is in a variable named address.
You need to make the API call without blocking. Which code segment should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: A

Explanation: Example:
// Create an HttpClient instance
11: HttpClient client = new HttpClient(); 12:
13: // Send a request asynchronously continue when complete 14: client.GetAsync(_address).ContinueWith(
15: (requestTask) =>
16: {
17: // Get HTTP response from completed task.
18: HttpResponseMessage response = requestTask.Result; 19:
20: // Check that response was successful or throw exception 21: response.EnsureSuccessStatusCode();
22:
23: // Read response asynchronously as JsonValue and write out top facts for each country
24: response.Content.ReadAsAsync<JsonArray>().ContinueWith(
25: (readTask) =>

NEW QUESTION 8
You deploy a RESTful ASP.NET Web API to manage order processing.
You are developing an Azure App Services Web App to consume the API and allow customers to order products. You use the HttpClient object to process order entries. The API throws SocketException errors when the Web App experiences a high volume of concurrent users.
You need to resolve the errors. What should you do?

• A. Implement a Using statement block when declaring the HttpClient object.
• B. Increase the value of the Timeout property when declaring the HttpClient object.
• C. Use the static modifier to declare the HttpClient object.
• D. Create a new HttpClient instance for each API request and use asynchronous method calls.

Answer: C

Explanation: If the class that wraps the external resource is shareable and thread-safe, create a shared singleton instance or a pool of reusable instances of the class.
The following example uses a static HttpClient instance, thus sharing the connection across all requests.
public class SingleHttpClientInstanceController : ApiController
{
private static readonly HttpClient httpClient; static SingleHttpClientInstanceController()
{
httpClient = new HttpClient();
}
// This method uses the shared instance of HttpClient for every call to GetProductAsync. public async Task<Product> GetProductAsync(string id)
{
var hostName = HttpContext.Current.Request.Url.Host;
var result = await httpClient.GetStringAsync(string.Format("http://{0}:8080/api/...", hostName));
return new Product { Name = result };
}
}
References: https://docs.microsoft.com/en-us/azure/architecture/antipatterns/improper- instantiation/

NEW QUESTION 9
You need to choose the appropriate data access technology for the children's book area of the web application.
Which data access technology should you choose?

• A. Web Service
• B. LINQ to SQL
• C. ADO.NET Entity Framework
• D. WCF Data Services

Answer: C

NEW QUESTION 10
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity including retrieving identical sets across reads in all situations that use transactions.
Which isolation level should you use?

• A. Repeatable
• B. Serializable
• C. ReadUncommitted
• D. ReadCommitted

Answer: A

Explanation: REPEATABLE READ
Specifies that statements cannot read data that has been modified but not yet committed by other transactions and that no other transactions can modify data that has been read by the current transaction until the current transaction completes.

NEW QUESTION 11
HOTSPOT
You are developing an application.
The application must be deployed from Team Foundation Server after a successful build is completed. The Process tab of the Build Definition screen is shown in the exhibit. (Click the Exhibit button.)

You need to configure the automated deployment.
In which section should you define the parameters for the automated deployment? (To answer, select the appropriate section in the answer area.)

Answer:

Explanation:

NEW QUESTION 12
DRAG DROP
You are developing a .NET application that uses the HttpClient type to access an ASP.NET Web API application.
You need to add a header to ensure that data is returned as XML. You have the following code:

Which segments should you include in Target 1 and Target 2 to complete the code? (To answer, drag the appropriate code segments to the correct targets in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

Answer:

Explanation: References: http://codecaster.nl/blog/2015/11/webclient-httpwebrequest-httpclient-perform-web-requests-net/#headers

NEW QUESTION 13
You are developing an ASP.NET MVC application. The application is an order processing system that uses the ADO.NET Entity Framework against a SQL Server database. It has a controller that loads a page that displays customers. Customers are filtered on Country and, if provided, on CompanyName.
You have an Entity Framework context named db. The Customer class is shown below.

You need to execute a single deferred query to return the filtered list of customers. Which code segment should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 14
DRAG DROP
The GetQueueItems() action in the InboundQueueController controller is not populating the view with data. The action must populate the view with data by calling the GetExternalOrders() method in the ExternalQueueService service using the ChannelFactory class.
You need to modify the action to populate the view with data.
What should you do? (To answer, drag the appropriate code segments to the correct location or locations in the answer area. Each code segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.)

Answer:

Explanation:

NEW QUESTION 15
HOTSPOT
You have a Windows Communication Foundation (WCF) service named Service1.
You deploy the WCF service at the root level of a website in Azure. The address of the Azure website is http://service1.azurewebsites.net/.
You need to generate a .cs file that can be used to interact with Service1.
What command should you run? To answer, select the appropriate options in the answer area.

Answer:

Explanation: References: https://stackoverflow.com/questions/23997821/how-to-generate-wcf-service- with-svcutil-exe

NEW QUESTION 16
You are developing a WCF service.
A new service instance must be created for each client request. You need to choose an instancing mode.
Which instancing mode should you use?

• A. Single
• B. PerRequest
• C. PerCall
• D. Multiple
• E. PerSession

Answer: C

NEW QUESTION 17
You need to recommend a data access technology to the contractor to retrieve data from the new data source.
Which data access technology should you recommend?

• A. LINQ to XML
• B. ADO.NET Entity Framework
• C. ADO.NET DataSets
• D. WCF Data Services

Answer: D

NEW QUESTION 18
You need to update the ImportBooks() method to use database transactions. Which code segment should you use?

• A. SqlConnection.BeginTransaction(IsolationLevel.RepeatableRead);
• B. SqlConnection.BeginTransaction(IsolationLeve.ReadUnconvnited);
• C. SqlConneetion.BeginTransaction(IsolationLevel.Serializable);
• D. SqlConnection.BeginTransaction(IsolationLevel.Snapshot);

Answer: B

Explanation:
* scenario: The ImportBooks() method must keep a copy of the data that can be accessed while new books are being imported without blocking reads.
* ReadUncommitted
A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored.

NEW QUESTION 19
The DeleteExternalOrder() method in the ExternalQueueService service is not throwing a FaultException exception as defined by the FaultContractAttribute attribute in the IExternalQueueService.cs file.
You need to throw the FaultException exception.
Which code segments can you insert at line EQ45 to achieve this goal? (Each correct answer presents a complete solution. Chose all that apply)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: BC