Realistic 70-487 Exam Questions and Answers 2021

NEW QUESTION 1
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to prevent the application from reading data that is locked by other transactions. You also need to prevent exclusive range locks.
Which isolation level should you use?

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

Answer: A

NEW QUESTION 2
DRAG DROP
You have two methods named F1 and F2. F2 takes a sting as a parameter.
You need to create a method named F3. F3 must retrieve a string value asynchronously. The string must call F2. During the asynchronous load of the string, F1 must run.
Which five code blocks should you use? Develop the solution by selecting and arranging the required code blocks in the correct order.
NOTE: You will not need all of the code blocks.

Answer:

Explanation: References: https://docs.microsoft.com/en-us/dotnet/csharp/programming- guide/concepts/async/

NEW QUESTION 3
You are developing a WCF service that compares several data sources. The service takes a long time to complete.
The service must meet the following requirements:
The client must be able to continue processing while the service is running.
The service must initiate communication with the client application when processing is complete.
You need to choose a message pattern to meet the requirements. Which message pattern should you choose?

• A. One Way
• B. Streaming
• C. Duplex
• D. Request/Reply

Answer: C

NEW QUESTION 4
You need to implement a solution that meets the logging requirements.
Which class should you use?

• A. RouteAttribute
• B. RoutePrefixAttribute
• C. AcceptVerbsAttribute
• D. ActionFilterAttribute

Answer: D

NEW QUESTION 5
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 need to ensure that testing, development, and end user access requirements are met.
Solution: Add Web App backend endpoints to Azure Traffic Manager and use weighted routing.
Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Scenario: All testing must interact directly with the Web App backend. Automated testing of the solution is performed using a remote third-party testing solution.

NEW QUESTION 6
You need to create an OData query expression to return the ten books with the largest number of sales.

Which query expression should you use?

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

Answer: C

Explanation: Order by desc(ending) to get the posts with the largest number of sales at the top. Specify to display the top 10 posts.

Case Study: 4
Adventure Works Cycles
General Overview
Adventure Works Cycles is a travel agency for cycling enthusiast. In recent years, Adventure Works Cycles has begun renting exotic cars to its clients.
You are developing a new web application that will provide Adventure Works Cycles customers with the ability to locate and rent exotic throughout the world.
Application Overview
The web application will be hosted in Azure. The application will provide users with the ability to search for a car by using advanced filtering options, such as the car brand, model, year, and price. All of this information will be stored as strings and will be displayed as drop- down lists.
The brand and model lists that will be displayed on the home page of the web application will be retrieved from Windows Communication Foundation (WCF) services hosted in the on- premises environment.
The home page will be named home.aspx and will be developed by using Microsoft ASP.NET MVC. The business logic will be developed by using ASP.NET Web API.
The MVC front-end layer and the Web API will communicate by using JSON. The business logic will have a call to an assembly named CarBusinessLogic.dll.
For responding, you are creating a worker role named ReportApp in Azure that will collect data from all of the searches made by using the web application. The application will communicate with ReportApp by using messages.
Requirements
Security Requirements
Adventure Works Cycles identifies the following security requirements for the web application:
The Web API must only accept one data format.
The CarBusinessLogic.dll assembly must be strongly-named.
Communication between the on-premises WCF service and Azure must be encrypted. Logging Requirements
In the Web API, you plan to create a controller named CarController. Before any action in
CarController is executed, the following line of code must execute first. Debug.WriteLine(“pre-processing logging”);
Performance Requirements
Adventure Works Cycles identifies the following performance requirements for the web application:
After the initial deployment, any changes to the business logic of the Web API must cause minimal downtime to the web application in the production environment.
The action in the Web API that returns the car brand must be asynchronous, while all other actions must be synchronous.
When home.aspx is displayed, the rendered page must be cached for 10 minutes.
The web application will be deployed to multiple instances. Financial Requirements
ReportApp will shut down every night. However, data from the searches performed during the night must still be collected.

NEW QUESTION 7
HOTSPOT
You are supporting an application that uses the ADO.NET Entity Framework to query and access data.
The latest version of Entity Framework contains bug fixes that will improve performance. You need to update Entity Framework.
Which Visual Studio 2012 menu item should you choose? (To answer, select the appropriate menu item in the answer area.)

Answer:

Explanation:

NEW QUESTION 8
DRAG DROP
You have a UI element library.
You need to build a NuGet package to integrate the library into your projects.
What should you do? (To answer, drag the appropriate code elements to the correct location or locations in the answer area. Each code element 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: Reference: Creating and Publishing a Package http://docs.nuget.org/create/creating-and-publishing-a-package

NEW QUESTION 9
HOTSPOT
You plan to create several .NET applications that will read from Microsoft SQL Server 2014 databases by using Microsoft ADO.NET.
The relevant requirements for the applications are described in the following table.

Typically, the applications will read thousands of rows of data at a time.
You need to identify which object to use to retrieve data for each application. The solution must minimize the amount of memory used on the application server.
What should you identify? To answer, select the appropriate options in the answer area.

Answer:

Explanation: App1: DataReader App2: DataReader App3: DataAdapter
Need to use a DataAdapter since the data could be modified. Note:
You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. Results are returned as the query executes, and are stored in the network buffer on the client until you request them using the Read method of the DataReader. Using the DataReader can increase application performance both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory, reducing system overhead.
A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source. The DataAdapter uses the Connection object of the .NET Framework data provider to connect to a data source, and it uses Command objects to retrieve data from and resolve
changes to the data source.
References: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/dataadapters-and-datareaders

NEW QUESTION 10
ReportApp will shut down every night. However, data from the searches performed during the night must still be collected.
You need to recommend a solution to meet the performance requirements for home.aspx. What should you recommend?

• A. ViewState
• B. MemoryCache
• C. OutputCache
• D. ApplicationCache

Answer: C

Explanation: Scenario: When home.aspx is displayed, the rendered page must be cached for 10 minutes. Page output caching
The output of an action method on a controller can be cached using the [OutputCache]attribute on the method. Actions methods that return views will have the rendered page cached, while methods returning JSON data will have that data saved. A number of properties on the OutputCacheAttribute class control how data is cached.
CacheProfile- If a number of methods will have the same cache settings, it makes sense to use the web.config file to create a cache profile that can be used across all these methods.
The Duration attribute of the CacheProfile determines how long, in seconds, the output should be cached. To save an item for 10 minutes, duration would be set to 600.
[OutputCache(Duration=600)]
References: http://failedturing.blogspot.se/2014/10/microsoft-70-486-design-caching- strategy.html

NEW QUESTION 11
DRAG DROP
You have the following code.

File.xml contains the following XML markup.

You need to write code to display Item1 in the console output.
Which five code blocks should you use? Develop the solution by selecting and arranging the required code blocks in the correct order.
NOTE: You will need all of the code blocks.

Answer:

Explanation:

NEW QUESTION 12
You are developing a Microsoft Azure web application. The application will be deployed to 10 web role instances. A minimum of 8 running instances is needed to meet scaling requirements.
You need to configure the application so that upgrades are performed as quickly as possible, but do not violate scaling requirements.
How many upgrade domains should you use?

• A. 1
• B. 2
• C. 5
• D. 10

Answer: B

Explanation: The .csdef is only used for Cloud Services, not for VMs. So regardless of what you set or even how you try to do it, Azure VM UDs come in groups of 5. With 8 VMs, that means you’ll have 2 UDs.

NEW QUESTION 13
You are adding a new REST service endpoint to the FlightDataController controller. It returns flights from the consolidated data sources only for flights that are late.
You need to write a LINQ to Entities query to extract the required dat a.
Which code segment should you use?

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

Answer: D

Explanation: Explanation/Reference:
D is right because you send result as REST so if you use “AsQueryable” the result is deferred to the next enumeration of your result.
D is not optimized but will works. A will break at runtime.
Credits to Rem

NEW QUESTION 14
DRAG DROP
You are developing an ASP.NET MVC Web API application. The application must meet the following requirements:
It must send or receive data without the use of a buffer.
It must allow up to 1 MB of data to be received.
It must allow up to 2 MB of data to be sent. You need to complete the code to meet the requirements.
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
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 develop a REST API that uses Node.js. The API will store data in Azure Cosmos DB. You plan to deploy the API to a new Azure App Services Web App. You create a new Web App by using the Azure portal.
The API must be deployed by using SFTP.
You need to provide the proper deployment credentials to deploy the API. Solution: Use your assigned Azure Active Directory (Azure AD) credentials. Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Get FTP publishing profile and query for publish URL and credentials.
References: https://docs.microsoft.com/en-us/azure/app-service/scripts/app-service-cli- deploy-ftp

NEW QUESTION 16
You are developing an ASP.NET MVC web application that contains the following HTML.
<table id= “customer” ></table>
You also have an ASP.NET Web API application that contains a call for retrieving customers. You must send and retrieve the data in the most compact format possible.
You need to update the HTML for the customers table to contain data from the Web API application.
Which script segment should you use?

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

Answer: A

NEW QUESTION 17
DRAG DROP
You need to modify the ExecuteCommandProcedure() method to meet the technical requirements.
Which code segment should you use?

Answer:

Explanation:

NEW QUESTION 18
You need to compile CarBusinesLogic.dll by using Microsoft Visual Studio.
Which attribute should you add before you compile the dynamic-link library (DLL)?

• A. System.Reflection.AssemblyConfigurationAttribute
• B. System.Reflection.AssemblyKeyFileAttribute
• C. AssemblyFlagsAttribute
• D. System.Reflection.AssemblyAlgorithmIdAttribute

Answer: B

Explanation: Scenario: The CarBusinessLogic.dll assembly must be strongly-named.
One way to sign an assembly with a strong name is by using assembly attributes to insert the strong name information into your code. You can use either the AssemblyKeyFileAttribute or the AssemblyKeyNameAttribute attribute, depending on where the key file to be used is located.
Note: To sign an assembly with a strong name by using attributes
References: https://msdn.microsoft.com/en-us/library/xc31ft41(v=vs.110).aspx

NEW QUESTION 19
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 deploy an ASP.NET Core web application to Azure App Services. You are using Azure Event Hubs to collect the telemetry data for the application.
You need to configure Event Hubs to automatically deliver the telemetry data stream to a persistent data store.
Solution: Configure Azure Event Hubs Capture to deliver data to Azure SQL Database. Does the solution meet the goal?

• A. Yes
• B. No

Answer: B

Explanation: Use Azure Blob storage to store the telemetry data.
References: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-capture- overview