Microsoft Developing Microsoft Azure and Web Services (070-487) Free Practice Test
Question 1
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?
You need to ensure transactional data integrity.
Which isolation level should you use?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
You need to modify the ExecuteCommandProcedure() method to meet the technical requirements.
Which code segment should you use?

Which code segment should you use?

Correct Answer:

Explanation

Question 3
You develop an application. You are using the ServiceModel Metadata Utility Tool (svcutil.exe) to generate
service bindings.
The service bindings must use stringent security and require full control over the Windows Communication
Foundation (WCF) messaging stack.
You need to configure the service bindings.
Which values should you use? To answer, configure the appropriate options in the dialog box in the answer
area.
NOTE: Each correct selection is worth one point.

service bindings.
The service bindings must use stringent security and require full control over the Windows Communication
Foundation (WCF) messaging stack.
You need to configure the service bindings.
Which values should you use? To answer, configure the appropriate options in the dialog box in the answer
area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: WSHttpBinding
A secure and interoperable binding that is suitable for non-duplex service contracts.
Incorrect: Always select a binding that includes security. By default, all bindings except the
<basicHttpBinding> element have security enabled.
Box 2: Sign
Sign. The protected part is digitally signed. This ensures detection of any tampering with the protected
message part.
Box 3: <wsHttpBing>
References:
https://docs.microsoft.com/en-us/dotnet/framework/wcf/system-provided-bindings
https://docs.microsoft.com/en-us/dotnet/framework/wcf/understanding-protection-level
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? (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.)

Correct Answer:

Explanation
Airline
Flight
Question 5
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?
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?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 6
You need to implement a solution that meets the logging requirements.
Which class should you use?
Which class should you use?
Correct Answer: B
Question 7
You are developing a Windows Communication Foundation (WCF) service named WCF1.
WCF1 will use a certificate to secure the communication channel.
You need to ensure that the WCF service uses a certificate to secure the communication channel.
How should you complete the code? To answer, drag the appropriate code blocks to the correct locations. Each
code block 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.

WCF1 will use a certificate to secure the communication channel.
You need to ensure that the WCF service uses a certificate to secure the communication channel.
How should you complete the code? To answer, drag the appropriate code blocks to the correct locations. Each
code block 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.

Correct Answer:

Explanation

Target 1: ClientCredentialType
Target 2: MessageCredentialType.Certificate
Set the ClientCredential property to an appropriate value. The following code sets the property to Certificate.
WSHttpBinding b = new WSHttpBinding();
b.Security.Mode = SecurityMode.Message;
b.Security.Message.ClientCredentialType = MessageCredentialType.Certificate;
Target 3: SetCertificate
On the client class, set the ClientCredentials property of the ClientBase<TChannel> class to an appropriate
value.
Example: // Set the certificate for the client.
cc.ClientCredentials.ClientCertificate.SetCertificate(
StoreLocation.LocalMachine,
StoreName.My,
X509FindType.FindBySubjectName,
"cohowinery.com");
References: https://docs.microsoft.com/en-us/dotnet/framework/wcf/how-to-set-the-security-mode
https://docs.microsoft.com/en-us/dotnet/framework/wcf/how-to-specify-client-credential-values
Question 8
You need to configure the Windows Azure service definition to enable Consolidated Messenger to upload
files.
What should you do? (To answer, drag the appropriate configuration items to the correct location or locations.
Each configuration item 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.)

files.
What should you do? (To answer, drag the appropriate configuration items to the correct location or locations.
Each configuration item 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.)

Correct Answer:

Explanation

Question 9
You are developing an ASP.NET MVC Web API image management application.
The application must meet the following requirements:
* It must send or receive image data without the use of a buffer.
* It must allow up to 4 MB of image data to be received.
* It must allow up to 3 MB of image 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.)

The application must meet the following requirements:
* It must send or receive image data without the use of a buffer.
* It must allow up to 4 MB of image data to be received.
* It must allow up to 3 MB of image 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.)

Correct Answer:

Explanation

Question 10
You are developing a ASP.NET Core MVC web application that processes sensitive data.
Users in an Azure Active Directory (Azure AD) group named DataAdmins must be able to see all data in
human readable form. Sensitive data must be masked from all other users that handle the data store.
You need to implement storage for the application.
What should you implement?
Users in an Azure Active Directory (Azure AD) group named DataAdmins must be able to see all data in
human readable form. Sensitive data must be masked from all other users that handle the data store.
You need to implement storage for the application.
What should you implement?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 11
You are developing a Windows Communication Foundation (WCF) service for a company. The service will
be used for bidirectional communications between the company's physical offices.
You plan to implement Azure Service Bus.
You need to configure the WCF service.
Which type of binding should you use?
be used for bidirectional communications between the company's physical offices.
You plan to implement Azure Service Bus.
You need to configure the WCF service.
Which type of binding should you use?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).