All About Printable 98-361 Dump

Cause all that matters here is passing the Microsoft 98-361 exam. Cause all that you need is a high score of 98-361 Microsoft MTA Software Development Fundamentals exam. The only one thing you need to do is downloading Certleader 98-361 exam study guides now. We will not let you down with our money-back guarantee.

Online 98-361 free questions and answers of New Version:

Page: 1 / 23
Total 276 questions Full Exam Access
Question 1
- (Topic 2)
In your student directory database, the Students table contains the following fields:
firstName lastName emailAddress telephoneNumber
You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName.
Which statement should you use?
98-361 dumps exhibit
My answer: -
Reference answer: D
Reference analysis:

to sort use: ORDER BY LastName, FirstName

Question 2
- (Topic 2)
In the application life cycle, the revision of an application after it has been deployed is referred to as:
My answer: -
Reference answer: B
Reference analysis:

None

Question 3
- (Topic 1)
You are creating a Web application. The application will be consumed by client computers that run a variety of Web browsers.
Which term is used to describe the process of making the application available for client computers to access?
My answer: -
Reference answer: C
Reference analysis:

You host web applications.

Question 4
- (Topic 1)
You need to create a property in a class. Consumers of the class must be able to read the values of the property. Consumers of the class must be prevented from writing values to the property.
Which property procedure should you include?
My answer: -
Reference answer: B
Reference analysis:

None

Question 5
- (Topic 1)
You need to create a stored procedure that passes in a person's name and age. Which statement should you use to create the stored procedure?
98-361 dumps exhibit
My answer: -
Reference answer: B
Reference analysis:

Example (nvarchar and int are best here):
The following example creates a stored procedure that returns information for a specific employee by passing values for the employee's first name and last name. This procedure accepts only exact matches for the parameters passed.
CREATE PROCEDURE HumanResources.uspGetEmployees
@LastName nvarchar(50),
@FirstName nvarchar(50) AS
SET NOCOUNT ON;
SELECT FirstName, LastName, JobTitle, Department FROM HumanResources.vEmployeeDepartment
WHERE FirstName = @FirstName AND LastName = @LastName; GO

Question 6
- (Topic 2)
This question requires that you evaluate the underlined text to determine if it is correct. Converting an object to a more general type is called upcasting.
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.
My answer: -
Reference answer: A
Reference analysis:

Casting up a hierarchy means casting from a derived object reference to a base object reference.

Question 7
- (Topic 2)
Where must Internet Information Services (IIS) be installed in order to run a deployed ASP. NET application?
My answer: -
Reference answer: C
Reference analysis:

IIS is run on the web server. The web server is hosting the application.

Question 8
- (Topic 1)
This question requires that you evaluate the underlined text to determine if it is correct. Converting an object to a more general type is called upcasting.
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.
My answer: -
Reference answer: :A
Reference analysis:

Casting up a hierarchy means casting from a derived object reference to a base object reference.

Question 9
- (Topic 1)
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?
My answer: -
Reference answer: A
Reference analysis:

You can use polymorphism to in two basic steps:
Create a class hierarchy in which each specific shape class derives from a common base class.
Use a virtual method to invoke the appropriate method on any derived class through a single call to the base class method.

Question 10
- (Topic 1)
Your application must pull data from a database that resides on a separate server.
Which action must you perform before your application can retrieve the data?
My answer: -
Reference answer: D
Reference analysis:

None

Question 11
- (Topic 2)
You are creating an ASP. NET Web application.
Which line of code should you use to require a control to process on the computer that hosts the application?
My answer: -
Reference answer: A
Reference analysis:

None

Question 12
HOTSPOT - (Topic 1)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
98-361 dumps exhibit
Solution:
98-361 dumps exhibit

Does this meet the goal?
My answer: -
Reference answer: A
Reference analysis:

None

Question 13
- (Topic 2)
You have a Microsoft ASP.NET web application.
You need to store a value that can be shared across users on the server.
Which type of state management should you use?
My answer: -
Reference answer: B
Reference analysis:

Application state is a data repository available to all classes in an ASP.NET application. Application state is stored in memory on the server and is faster than storing and retrieving information in a database. Unlike session state, which is specific to a single user session, application state applies to all users and sessions. Therefore, application state is a useful place to store small amounts of often-used data that does not change from one user to another.
Incorrect:
not A: Session State contains information that is pertaining to a specific session (by a particular client/browser/machine) with the server. It's a way to track what the user is doing on the site.. across multiple pages...amid the statelessness of the Web. e.g. the contents of a particular user's shopping cart is session data. Cookies can be used for session state. Not D: Viewstate is a state management technique in asp.net. ASP.NET Viewstate is preserving the data between the requests or postbacks and stored in hidden fields on the page.

Question 14
- (Topic 1)
You are developing a database that other programmers will query to display race results.
You need to provide the ability to query race results without allowing access to other information in the database.
What should you do?
My answer: -
Reference answer: B
Reference analysis:

None

Question 15
HOTSPOT - (Topic 2)
For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
98-361 dumps exhibit
Solution:
98-361 dumps exhibit

Does this meet the goal?
My answer: -
Reference answer: A
Reference analysis:

None

Question 16
- (Topic 2)
You have a class named Truck that inherits from a base class named Vehicle. The Vehicle class includes a protected method named brake ().
How should you call the Truck Class implementation of the brake () method?
My answer: -
Reference answer: A
Reference analysis:

The MyBase keyword behaves like an object variable referring to the base class of the current instance of a class.MyBase is commonly used to access base class members that are overridden or shadowed in a derived class.

Question 17
- (Topic 2)
What are two advantages of normalization in a database? (Choose two.)
My answer: -
Reference answer: CD
Reference analysis:

None

Question 18
- (Topic 2)
You execute the following code.
98-361 dumps exhibit
How many times will the word Hello be printed?
My answer: -
Reference answer: B
Reference analysis:

None

Question 19
- (Topic 1)
You are creating an ASP. NET Web application.
Which line of code should you use to require a control to process on the computer that hosts the application?
My answer: -
Reference answer: D
Reference analysis:

None

Question 20
- (Topic 2)
You need to group all the style settings into a separate file that can be applied to all the pages in a Web application.
What should you do?
My answer: -
Reference answer: A
Reference analysis:

Cascading Style Sheets (CSS) is a style sheet language used for describing
the look and formatting of a document written in a markup language.
CSS is designed primarily to enable the separation of document content from document presentation, including elements such as the layout, colors, and fonts.

Question 21
- (Topic 1)
You are creating an application for a priority help desk center. The most recent call must be handled first.
Which data structure should you use?
My answer: -
Reference answer: C
Reference analysis:

In computer science, a stack is a particular kind of abstract data type or collection in which the principal (or only) operations on the collection are the addition of an entity to the collection, known as push and removal of an entity, known as pop. The relation between the push and pop operations is such that the stack is a Last-In-First-Out (LIFO)
data structure. In a LIFO data structure, the last element added to the structure must be the first one to be removed.

Question 22
- (Topic 2)
You are reviewing a design for a database. A portion of this design is shown in the exhibit. Note that you may choose to view either the Crow's Foot Notation or Chen Notation version of the design. (To view the Crow's Foot Notation, click the Exhibit A button. To view the Chen Notation, click the Exhibit B button.)
98-361 dumps exhibit
98-361 dumps exhibit
Which term is used to describe the relationship between Customer and Order?
My answer: -
Reference answer: C
Reference analysis:

A customer can have many orders.

Page: 1 / 23
Total 276 questions Full Exam Access