070-487 無料問題集「Microsoft Developing Microsoft Azure and Web Services」
The GetExternalOrders() method must use members of the EntityClient namespace to query the database for
all records in the InboundQueue entity.
You need to modify the GetExternalOrders() method to return the correct 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.)
all records in the InboundQueue entity.
You need to modify the GetExternalOrders() method to return the correct 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.)
正解：
Explanation
You are developing an ASP.NET Core web application by using an Entity Framework code-first approach.
The application uses an Azure SQL Database. The code-first migration is configured to run as part of a
continuous integration build.
You must add an Azure MySQL Database. This database must use the same schema as the existing Azure
SQL Database instance.
You need to configure the migration to ensure that the existing TFS build definition remains unchanged.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
The application uses an Azure SQL Database. The code-first migration is configured to run as part of a
continuous integration build.
You must add an Azure MySQL Database. This database must use the same schema as the existing Azure
SQL Database instance.
You need to configure the migration to ensure that the existing TFS build definition remains unchanged.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正解：B、D
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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? (To answer, drag the appropriate properties to the correct location or locations in the
answer area. Each property 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.)
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? (To answer, drag the appropriate properties to the correct location or locations in the
answer area. Each property 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.)
正解：
Explanation
Airline
Flight
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 data.
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.
You plan to use the table-per-type mapping strategy to store the following data.
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.
正解：
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
You create a web application.
You deploy the application by using a Web Deploy Package.
You need to identify which setting will be created automatically in the SetParameters.xml file during the
package generation.
Which three settings should you identify? Each correct answer presents part of the solution.
You deploy the application by using a Web Deploy Package.
You need to identify which setting will be created automatically in the SetParameters.xml file during the
package generation.
Which three settings should you identify? Each correct answer presents part of the solution.
正解：A、D、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have a web application that was developed by using Microsoft ASP.NET MVC. The application is
deployed to an Azure web app and uses an Azure SQL Database.
From a development environment, you use Microsoft Visual Studio to change the application code, and you
modify the schema of the database.
You need to deploy the changes to Azure.
Which publishing method should you use?
deployed to an Azure web app and uses an Azure SQL Database.
From a development environment, you use Microsoft Visual Studio to change the application code, and you
modify the schema of the database.
You need to deploy the changes to Azure.
Which publishing method should you use?
正解：B
解答を投票する
You are developing an Internet-based ASP.NET Web API application that manages pet data.
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)
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)
正解：
Explanation
