Refined 70-487 Exam Questions and Answers 2021

NEW QUESTION 1
You need to configure DNS for the Event service. How many DNS entries should you create?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: C

Explanation: Scenario: Regional access to the Event Service API
Data for partners in Germany and Brazil must be served from Azure datacenters in their respective geographies unless there is a regional Azure outage. All other partners must use the US West Azure datacenter.

NEW QUESTION 2
DRAG DROP
The service has been deployed to Windows Azure.
Trey Research has provided version 1.3.0.0 of the assembly to support a change in the serialization format. The service must remain available during the transition to the new serialization format.
You need to ensure that the service is using the new assembly.
Which configuration setting should you add to the web.config? (To answer, drag the appropriate configuration elements to the correct location or locations in the answer area. Each configuration 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:
See: http://msdn.microsoft.com/en-us/library/7wd6ex19.aspx

NEW QUESTION 3
DRAG DROP
You are developing the following applications. All applications will be hosted in Azure and data will be stored using Azure storage.

All data must be stored using the binary large object (blob) hot storage tier. You need to select the blob storage type for each application.
Which blob storage types should you use? To answer, drag the appropriate blob types to the correct applications. Each blob type 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 Logging: append blob
An append blob is comprised of blocks and is optimized for append operations. When you modify an append blob, blocks are added to the end of the blob only, via the Append Block operation.
Box 2 VM Manager: block blob
Block blobs let you upload large blobs efficiently. Box 3: Accounting: page blob
Page blobs are a collection of 512-byte pages optimized for random read and write operations.
References: https://docs.microsoft.com/en-us/rest/api/storageservices/understanding-block-blobs--append-blobs--and-page-blobs

NEW QUESTION 4
DRAG DROP
You need to create the ShippingContext class in the ShippingAddress.es file 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 5
HOTSPOT
ReportApp will shut down every night. However, data from the searches performed during the night must still be collected.
Based on the security requirements, which line of code should you insert into the WebApiConfig file? To answer, select the appropriate options in the answer area.

Answer:

Explanation: Scenario: The Web API must only accept one data format.
The MVC front-end layer and the Web API will communicate by using JSON.
The most common approach to support JSON only is to clear other formatters and leave only JsonMediaTypeFormatter around.
Given an instance of HttpConfiguration you’d simply clear all and re-add JsonMediaTypeFormatter:
configuration.Formatters.Clear();
configuration.Formatters.Add(new JsonMediaTypeFormatter());
References: http://www.strathweb.com/2013/06/supporting-only-json-in-asp-net-web-api- the-right-way/

NEW QUESTION 6
You are building an ADO.NET Entity Framework application.
You need to validate the conceptual schema definition language (CSDL), store schema definition language (SSDL), and mapping specification language (MSL) files.
Which Entity Data Model tool can you use? (Each correct answer presents a complete solution. Choose all that apply.)

• A. EDM Generator (EdmGen.exe)
• B. ADO.NET Entity Data Model Designer
• C. Entity Data Model Wizard
• D. Update Model Wizard

Answer: AB

NEW QUESTION 7
You are developing an ASP.NET MVC application that displays a report. The report includes large images that are stored in a database. Members of the EntityClient namespace are used to access the database through the ADO.NET Entity Framework data model.
You need to prevent memory exceptions while generating a report using the EntityDataRcader type.
Which CommandBehavior type should you use?

• A. FastForwardReadOnly
• B. SequentialAccess
• C. SingleResult
• D. SingleRow

Answer: B

Explanation: SequentialAccess
Provides a way for the DataReader to handle rows that contain columns with large binary values. Rather than loading the entire row, SequentialAccess enables the DataReader to load data as a stream.

NEW QUESTION 8
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity in all situations that use transactions.

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

Answer: C

NEW QUESTION 9
The PurchaseOrders.xml file contains all of the purchase orders for the day. You need to query the XML file for all of the shipping addresses.
Which code segment should you use?

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

Answer: B

NEW QUESTION 10
DRAG DROP
You are developing an Internet-based ASP.NET Web API application that manages pet dat a.
You install an SSL certificate on the web server to encrypt calls to the API. You create a class named PetAuthorization, which inherits from a type named AuthorizeAttribute, and implements the OnAuthorization() method.
You need to implement basic authentication for the API.
What should you do? (To answer, drag the appropriate words to the correct targets in the answer area. Words 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 11
DRAG DROP
An XML file must be produced by the SaveFeaturedBooks() method of the Book class. The schema of the resulting XML file must be identical to the FeaturedBooks.xml file.
You need to write the code to produce the file. You have the following code:

Which code segments should you include in Target 1, Target 2 and Target 3 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 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
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 14
You are developing a library management application that uses the ADO.NET Entity Framework against a SQL Server database. The application has a method that returns check outs filtered by date.
The Book class is shown below.

You must filter the data on the SQL server before it is returned to the application server. You need to return books checked out more recently than the entered date.
Which code segment should you use?

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

Answer: A

Explanation: The difference is that IQueryable<T> is the interface that allows LINQ-to-SQL (LINQ.-to-anything really) to work. So if you further refine your query on an IQueryable<T>, that query will be executed in the database, if possible.
For the IEnumerable<T> case, it will be LINQ-to-object, meaning that all objects matching the original query will have to be loaded into memory from the database.

NEW QUESTION 15
DRAG DROP
You are developing an ASP.NET Web API action method.
The action method must return the following JSON in the message body.
{" Name ":" Fabrikam", "Vendor Id": 9823, "Items": ["Apples", "Oranges"] } You need to return an anonymous object that is serialized to JSON.
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: Box 1: return new List<string>
Box 2: "Fabrikam", VendorNumber=9823, Box 3: new list<string>{"Apples", "oranges"}

NEW QUESTION 16
HOTSPOT
You are updating an existing multitenant ASP.NET MVC application for medical clinics. The application aggressively uses output caching to improve performance by caching content for 36 hours. The application uses a query string parameter named "clinicID" that contains the clinic that the user is currently viewing.
Users report that they are occasionally seeing data for the wrong clinic. Users also report that
sensitive data is stored in the browser cache folder on their computers. You need to configure web.config to resolve the reported problems. You have the following markup:

Which markup segments should you include in Target 1, Target 2 and Target 3 to complete the markup? (To answer, select the correct markup segment from each drop-down list in the answer area.)

Answer:

Explanation:

NEW QUESTION 17
DRAG DROP
You are developing a self-hosted WCF service to display data about books. The solution contains a service named BookService that implements the IBookService interface.
You need to expose the metadata in the service host programmatically. You have the following code:

Which code segments should you include in Target 1, Target 2, Target 3, Target 4 and Target 5 to build the service host? (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 18
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.

Answer:

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 19
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 all orders along with customer information. Lazy loading has been disabled.
The Order class is shown below.

You need to return the orders and customer information in a single round trip to the database. Which code segment should you use?

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

Answer: A