Microsoft 70-487 Paper 2021

NEW QUESTION 1
DRAG DROP
You are designing a service layer endpoint named EndPoint1 that will read more than one million rows from a database named DB1, and then update several rows in multiple tables in a database named DB2.
You need to identify a data access strategy that meets the following requirements:
Uses the OData protocol to retrieve data from EndPoint1
Creates a strongly typed object based on the table in BD2
Retrieves data from DB1 as quickly as possible, while minimizing memory use on the application server
What should you identify for each requirement? To answer, drag the appropriate data access strategies to the correct requirements. Each data access strategy 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.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/wcf/wcf-data-services-overview https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/populating-a-dataset-from-a-dataadapter
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/retrieving-data-using-a- datareader

NEW QUESTION 2
You are preparing to write the data access code for the children’s book area of the web site. You need to review the requirements and identify the appropriate data access technology. What should you do?

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

Answer: A

NEW QUESTION 3
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 4
Historical flight information data will be stored in Windows Azure Table Storage using the FlightInfo class as the table entity.
There are millions of entries in the table. Queries for historical flight information specify a set of airlines to search and whether the query should return only late flights. Results should be ordered by flight name.
You need to specify which properties of the FlightInfo class should be used at the partition and row keys to ensure that query results are returned as quickly as possible.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A. Use the WasLate property as the row key.
• B. Use the Airline property as the row key.
• C. Use the WasLate property as the partition key
• D. Use the Arrival property as the row key.
• E. Use the Airline property as the partition key.
• F. Use the Flight property as the row key.

Answer: BF

NEW QUESTION 5
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

NEW QUESTION 6
HOTSPOT
You are creating a streamed Windows Communication Foundation (WCF) service. You implement the following service methods.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
To enable streaming, define the OperationContract appropriately and enable streaming at the transport level.
To stream data, the OperationContract for the service must satisfy two requirements:
References: https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/how-to-enable-streaming

NEW QUESTION 7
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.)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 8
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 a method to add 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.)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 9
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 are developing a RESTful API that uses ASP.NET Core. You plan to host the API in Azure App Services. You provision a development environment in the application service.
Developers must be able to deploy the API to the development environment. You must not share the Azure account credentials with developers.
You need to ensure that developers can deploy the API to the development environment.
Solution: Download the Publish profile for the application service and share it with the developers. Use Microsoft Visual Studio Publishing.
Does the solution meet the goal?

• A. Yes
• B. No

Answer: A

Explanation:
To configure deployment for a web project in Visual Studio, you create one or more publish
profiles using the Publish Web wizard. A publish profile specifies the server you are deploying to, the credentials needed to log on to the server, the databases to deploy, and other deployment options. When you are ready to publish, you choose the profile you want to use and click the Publish button in the wizard or in the Web One Click Publish toolbar.
References: https://msdn.microsoft.com/en-us/library/dd465337(v=vs.110).aspx

NEW QUESTION 10
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 11
You need to regenerate the service proxies to include task-based asynchronous method signatures.
Which command should you use?

• A. aspnet_regiis.exe /t:code http://localhost:62965/UploadCallbackService.svc
• B. svcutil.exe /t:code http://localhost:62965/UploadCallbackService.svc
• C. aspnet_compiler.exe /t:code http://localhost:62965/UploadCallbackService.svc
• D. aspnet_regiis.exe /t:code http://localhost:62965/UploadService.svc
• E. svcutil.exe /t:code http://localhost:62965/UploadService.svc

Answer: B

Explanation:

http://msdn.microsoft.com/en-us/library/aa347733.aspx

NEW QUESTION 12
You are developing an ASP.NET Core web application by using an Entity Framework code-first approach. The application uses a SQLite database.
You make changes to the classes in the model. You must apply the changes to the database. You need to suggest an approach to reliably handle the Entity Framework migrations.
Which three actions should you perform? Each correct answer presents a part of the solution.
NOTE: Each correct selection is worth one point.

• A. Modify the scaffolded migration script to drop the modified tables.
• B. Run the following command: dotnet ef database update
• C. Modify the scaffolded migration script to create new tables with the migration changes.
• D. Modify the scaffolded migration script to drop the existing database and create the new database.
• E. Run the following command: dotnet ef migrations add

Answer: CDE

Explanation:
E: Run dotnet ef migrations add InitialCreate to scaffold a migration and create the initial set of tables for the model.
C: You can workaround some of the SQLite limitations by manually writing code in your migrations to perform a table rebuild. A table rebuild involves renaming the existing table, creating a new table, copying data to the new table, and dropping the old table.
D: SQLite does not support all migrations (schema changes) due to limitations in SQLite. For new development, consider dropping the database and creating a new one rather than using migrations when your model changes.
References:
https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations

NEW QUESTION 13
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 specify that data is returned as JSON. You have the following code:

Which code 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)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

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

• A. SqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);
• B. SqlConnection.BeginTransaction(IsolationLevel.ReadUnconwited);
• C. SqlConnection.BeginTransaction(IsolationLevel.Chaos);
• D. SqlConnection.BeginTransaction(IsolationLevel.Serializable);

Answer: D

Explanation:
* Scenario: The Create MonthlyTotalsReport() method must lock the data and prevent others from updating or inserting new rows until complete.
* Serializable:
A range lock is placed on the DataSet, preventing other users from updating or inserting rows into the dataset until the transaction is complete.

NEW QUESTION 15
DRAG DROP
You are developing an ASP.NET MVC Web API application.
The method names of the Web API must match naming guidelines for RESTful services.
You need to create methods to support standard insert, select, update, and delete operations in an HTTP service.
What should you do? (To answer, drag the appropriate HTTP methods to the correct row in the table in the answer area. Each HTTP 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.)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 16
DRAG DROP
You are developing an ASP.NET Core MVC web application. The application will use Entity Framework Core and a SQLite database.
You rename a property in the Customer data model. You attempt to apply the migration to the SQLite database and receive a NotSupportedException error that includes a table named Customer.
You need to resolve the migration error.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
The SQLite provider has a number of migrations limitations. You can workaround some of these limitations by manually writing code in your migrations to perform a table rebuild. A table rebuild involves renaming the existing table, creating a new table, copying data to the new table, and dropping the old table.
References: https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations

NEW QUESTION 17
The GetExternalOrder() method in the ExternalQueueService service is throwing a runtime error. The method must query the database for a record that matches the orderNum parameter passed to the method.
You need to modify the queryString string to retrieve the record. With which code segment should you replace line EQ64?

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

Answer: C

NEW QUESTION 18
You are developing a web application by using Microsoft .NET Framework 4.5.
You are creating a web client for the application. The web client will make REST calls to several web services.
You need to ensure that the web client meets the following requirements:
Uses the Task class to perform asynchronous operations
Reuses recently resolved DNS lookups
Which object should you include in the solution?

• A. ServiceClient
• B. WebClient
• C. HttpClient
• D. WebRequest

Answer: C

Explanation:
References: https://www.c-sharpcorner.com/article/calling-web-api-using-httpclient/

NEW QUESTION 19
DRAG DROP
You are developing a web application that uses an assembly named MyAssembly.
You need to ensure that when MyAssembly version 1.0.0.0 is requested, version 2.0.0.0 is used.
How should you complete the markup in the Web.config file? To answer, drag the appropriate elements to the correct locations. Each 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.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
Box 1: assemblyBinding
Box 2: bindingRedirect
To redirect one assembly version to another, use the <bindingRedirect> element. Box 3: OldVersion
Box 4: NewVersion
The newVersion attribute should specify a single version. For example, <bindingRedirect oldVersion="1.1.0.0-1.2.0.0" newVersion="2.0.0.0"/> specifies that the runtime should use version 2.0.0.0 instead of the assembly versions between 1.1.0.0 and 1.2.0.0.
Box 5: assemblyBinding
The following code example demonstrates a variety of binding redirect scenarios. The example specifies a redirect for a range of versions for myAssembly, and a single binding redirect for mySecondAssembly.
<configuration>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="mySecondAssembly" publicKeyToken="32ab4ba45e0a69a1" culture="en-us" />
<bindingRedirect oldVersion="1.0.0.0" newVersion="2.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
References: https://docs.microsoft.com/en-us/dotnet/framework/configure-apps/redirect-assembly-versions

NEW QUESTION 20
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 21
DRAG DROP
You are developing a WCF service application.
The application must meet the following requirements:
Operations must have 30 second timeouts.
The service must have a transaction scope.
Transactions must flow from the client to the server.
You need to write a transactional service contract and implementation class to meet the requirements.
You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3 and Target 4 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.)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 22
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 23
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.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 24
You are developing an application that reads and writes data from a SQL Server database.
You need to ensure transactional data integrity. Which isolation level should you use?

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

Answer: C

Explanation:
Serializable provides the highest level of data integrity.
References: https://msdn.microsoft.com/en-us/library/system.data.isolationlevel(v=vs.110)

NEW QUESTION 25
You are developing an application in Visual Studio 2012 to display student information. The application contains the following Entity Framework model.

The application contains a WCF data service named DirectoryService.svc.
You need to create a query expression to display all of the grades for students whose first name is "John"
How should you build the expression?

• A. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName eq 'John' &$expand=Grades
• B. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName eq 'John'/Grades
• C. http://localhost:54946/DirectoryService.svc/Students?$filter=FirstName = 'John' &$expand=Grades
• D. http://localhost:54946/DirectoryService.svc/Grades/Students?$filter=FirstName eq 'John'

Answer: A

NEW QUESTION 26
......