Microsoft MTA Software Development Fundamentals - 98-361 Exam Practice Test

This question requires that you evaluate the underlined text to determine if it is correct.
A data dictionary that describes the structure of a database is called metadata.
Select the correct answer if the underlined text does not make the statement correct.
Select "No change is needed" if the underlined text makes the statement correct.

You need to update the Products table and remove all discontinued products.
When the products are discontinued, the value of the field Discontinued is set to true.
Which of the following SQL statements should you use to make changes to the Products table?

Two classes named Circle and Square inherit from the Shape class.
Circle and Square both inherit Area from the Shape class, but each computes Area differently.
Which term is used to describe this object-oriented concept?

You have a Windows Service running in the context of an account that acts as a non- privileged user on the local computer.
The account presents anonymous credentials to any remote server.
What is the security context of the Windows Service?

You are writing a C# program that iterates through a collection such as arrays and lists.
You need to make sure that you process each item in the collection once.
You also need to ensure that your code is easy to read and debug.
Which of the following C# statements provide the best solution for this requirement?

As you design a database for your company, you review the normalization rules for the database tables.
You need to ensure that your table design meets the requirements for the third normal form. Which of the following statements must be true for your tables? (Choose all that apply.)

You execute the following code.

How many times will the word Hello be printed?

You are developing a program that performs frequent insert and delete operations on the data.
Your requirement also dictates the capability to access previous and next records when the user clicks the previous or next button.
Which of the following data structures will best suit your requirements?

This question requires that you evaluate the underlined text to determine if it is correct.
Unit testing is the final set of tests that must be completed before a feature or product can be considered finished.
Select the correct answer if the underlined text does not make the statement correct.
Select "No change is needed'' if the underlined text makes the statement correct.

Hotspot Question
The ASP.NET MVC page lifecycle is shown in the following graphic:

Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.

In this XHTML code sample, what will cause an error?

You have a class with a property.
You need to ensure that consumers of the class can write to the value of the property.
Which keyword should you use?

You create an ASP.NET Web Service that tracks the shipment of orders.
The Web service includes a class nemed StatusService, which contains the following method:
Public string GetStatus()
{
/* additional code here */
}
You note that you can instantiate the StatusService class from a Web service client project, but the GetStatus method is not available.
What could be the problem?

Which three items are benefits of encapsulation? (Choose three.)