98-361 MTA - Advanced

queue

A _______ items are stored in the order they were added.

Queue

A _________ is a first in, first out data structure.

Inheritance

A class named Manager is derived from a parent class named Employee. The Manager class includes characteristics that are unique to managers. Which term is used to describe this object-oriented concept?

metadata

A data dictionary that describes the structure of a database is called _____________.

second

A table whose attributes depend only on the primary key must be at least _______ normal form.

the System.Object class

All objects in .NET inherit from which item?

Event driven

An application presents the user with a graphical interface. The interface includes buttons that the user clicks to perform tasks. Each time the user clicks a button, a method is called that corresponds to that button. Which term is used to describe this programming model?

boxing

Converting a value type to a reference type in an object is called _____________.

Upcasting

Converting an object to a more general type is called ____________.

computer that hosts the application

Internet Information Services (IIS) must be installed on the _________________ in order to run a deployed ASP.NET application

Stub

Used to simulate a called unit in unit testing

Driver

Used to simulate calling a unit in unit testing

Derived class

Which term is used to describe a class that inherits functionality from an existing class?

cookie

Which term is used to describe small units of text that are stored on a client computer and retrieved to maintain state?

Entity

Which term is used to describe the Customer component?

one-to-many

Which term is used to describe the relationship between Customer and Order?

FROM, SELECT, WHERE

Which three are valid SQL keywords? GET, WHAT, FROM, SELECT, WHERE

maintainability, flexibility, restricted access

Which three items are benefits of encapsulation?

Multiple-document interface (MDI)

Which type of Windows application presents a parent window that contains child windows?

Execute code regardless of whether an exception is thrown.

The purpose of the Finally section in an exception handler is to

app bar

The surface displayed after the gesture has been completed is the ______________?

Raise exceptions, rethrow exceptions as a different type

The throw keyword is used to perform which two actions?

70

The value of A is ____________

100

The value that is returned is ______________

indexes

To improve performance, a SQL SELECT statement should use _____________

block size

To minimize the amount of storage used on the hard drive by an application that generates many small files, you should make the __________ as small as possible.

reduces time to create a connection, improved stability, improved performance

Which three phrases are advantages of connection pooling?

the expected result from testing the case, multiple actions combined as a single step to test the case

Which two types of information should you include in an effective test case?

Windows Service

Which type of application has the following characteristics when it is installed? ✑ Runs continuously in the background by default when the startup type is set to automatic ✑ Presents no user interface

a protected virtual member function

Which type of function can a derived class override?

cookie

A piece of text that is 4096 bytes or smaller and is stored on and retrieved from the client computer to maintain state is known as a ____________

It speeds up query execution.

A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide?

No

Does a queue have a limited number of items?

Data warehouse database

Enables business decisions by collecting, consolidating, and organizing data

0

How many parameters can a default constructor have?

DOCTYPE; HTML, head, title, and body tags; and XML namespace attribute in the HTML tag

XHTML mandatory declarations

Yes

Y/N: A linked list can be sorted

No

Y/N: A linked list has a maximum of 100 nodes

Yes

Y/N: An entity relationship diagram contains entities, relationships, and attributes.

No

Y/N: An entity relationship diagram is designed for an object-oriented database.

Yes

Y/N: Both composition and inheritance allow you to create sub-objects

Yes

Y/N: Cardinality refers to how one table is linked to another table; as one-to-many.

No

Y/N: The "has a" relationship between classes refers to inheritance

No

Y/N: The "is a" relationship between classes refers to composition

Yes

Y/N: XHTML attribute minimization is forbidden

No

Y/N: XHTML attribute names must be in uppercase.

Yes

Y/N: XHTML attribute values must be in quotation marks

Yes

Y/N: You can add new nodes anywhere in a linked list

runat="server"

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?

Queue

You are creating an application for a help desk center. Calls must be handled in the same order in which they were received. Which data structure should you use?

Stack

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?

Enter

You are creating an application that presents the user with a Windows Form. Which event is triggered each time the Windows Form receives focus?

Windows Forms

You are creating an application that presents users with a graphical interface in which they can enter data. The application must run on computers that do not have network connectivity. Which type of application should you choose?

A

You are migrating several HTML pages to your website. Many of these pages contain HTML <center> and <font> tags. Which XHTML document type declaration should you use?

Connection pooling

You have a server that limits the number of data connections. What should you use to optimize connectivity when the number of users exceeds the number of available connections?

3

You have a stack that contains integer values. The values are pushed onto the stack in the following order: 2,4,6,8. The following sequence of operations is executed: Pop Push 3 Pop Push 4 Push 6 Push 7 Pop Pop Pop What is the value of the top element after these operations are executed?

INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 0)

You have a table named ITEMS with the following fields: ✑ ID (integer, primary key, auto generated) ✑ Description (text) ✑ Completed (Boolean) You need to insert the following data in the table: "Cheese", False Which statement should you use?

in both the client-side code and the server-side code

You have a website that includes a form for username and password. You need to ensure that users enter their username and password. The validation must work in all browsers. Where should you put the validation control?

Provide a public function that assigns a value to the data member.

You need to allow a consumer of a class to modify a private data member. What should you do?

Get

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?

B

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?

Stack

You need to create an application that processes data on a last-in, first-out (LIFO) basis. Which data structure should you use?

Use the Attach to Process menu in Microsoft Visual Studio

You need to debug a Windows Service application by using breakpoints. What should you do?

Normalization

You need to ensure the data integrity of a database by resolving insertion, update, and deletion anomalies. Which term is used to describe this process in relational database design?

False

You need to evaluate the following expression: (A>B) AND (C<D) What is the value of this expression if A=3, B=4, C=4, and D=5?

Use a Cascading Style Sheet (CSS).

You need to group all the style settings into a separate file that can be applied to all the pages in a Web application.

A

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?

5

You open the Internet Information Services 7.5 Manager console as shown in the following exhibit: How many applications are configured on server W2008R2?

1

You open the Internet Information Services 7.5 Manager console as shown in the following exhibit: How many sites are configured on server W2008R2?

Console-based

You plan to create an application for your company. The application will run automated routines and write the results to a text-based log file. Little or no user interaction is required. Security requirements on the host computers prevent you from running applications on startup, and users must be able to see the status easily on the screen. The host computers also have limited memory and monitors that display only two colors. These computers will have no network connectivity. Which type of application should you use for this environment?

10

You run the following code: What is the value of result when the code has completed?

Establish a connection to the database by using the appropriate data provider.

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?

Call a stored procedure

Your database administrators will not allow you to write SQL code in your application. How should you retrieve data in your application?

String Array

Arguments are passed to console applications as a ______________________.

The line break tag is incorrectly formatted (the <br> tag must be properly closed, like this: <br />)

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

user acceptance

_______________ is the final set of tests that must be completed before a feature or product can be considered finished.

m1, m2, m3

Class C and Class D inherit from Class B. Class B inherits from Class A. The classes have the methods shown in the following table. All methods have a protected scope. Which methods does Class C have access to?

Console-based applications do not display a graphical interface

How does a console-based application differ from a Windows Forms application?

Add a reference to the Web service in the application.

How should you configure an application to consume a Web service?

Maintenance

In the application life cycle, the revision of an application after it has been deployed is referred to as:

Render (The SaveStateComplete event is raised after the view state and control state of the page and controls on the page are saved to the persistence medium. This is the last event raised before the page is rendered to the requesting browser.)

In the life cycle of an ASP. NET Web page, which phase follows the SaveStateComplete phase?

Requirements gathering, design, development, and testing

In which order do the typical phases of the Software Development Life Cycle occur?

Software Testing

Simulating the final design of an application in order to ensure that the development is progressing as expected is referred to as

multiple inheritance

The Dog class and the Cat class inherit from the Animal class. The Animal class includes a breathe() method and a speak() method. If the speak() method is called from an object of type Dog, the result is a bark. If the speak() method is called from an object of type Cat, the result is a meow. Which term is used to describe this object-oriented concept?

Route

The URL pattern is matched during the ___________ event.

Controller

The _________ event determines which action method is needed and then calls that method.

Server.Execute method

The ______________ is used to transfer processing of the current page to a new page, and then return processing back to the calling page once processing of the new page has completed.

bubble sort

The _______________ algorithm steps through the list to be sorted, comparing adjacent items and swapping them if they are in the wrong order

it succeeds or fails as a unit

The benefit of using a transaction when updating multiple tables is _________________

main

The default entry point for a console application is the ______________ method.

branching

The duplication of code so that modifications can happen in parallel is known as _________.

Using an integer index

The elements of an array must be accessed by:

swiping

The gesture shown in the graphic is ____________?

Unit testing

The primary goal of ______________ is to take the smallest piece of testable software in the application, isolate it from the rest of the code, and determine whether it behaves exactly as expected.

Serialization

The process of transforming compiled C# code into an XML string for a web service is known as ________________

Initialize an object of that class

The purpose of a constructor in a class is to:

Execute code only when an exception is thrown.

The purpose of the Catch section in an exception handler is to:

Polymorphism

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?

running, stopped, paused

What are the three basic states that a Windows service can be in?

prevents data inconsistencies, decreases space used on disk

What are two advantages of normalization in a database?

for, while

What are two methods that can be used to evaluate the condition of a loop at the start of each iteration?

web site, virtual directory

What are two possible options for representing a Web application within Internet Information Services (IIS)?

gets the standard error output stream

What does the Console.Error property do within a console-based application?

211

What does the console display after the following line? Printer(2);

a listing of methods that are available in the Web service

What is displayed when you attempt to access a Web service by using a Web browser?

can be overridden with its own implementation by a derived class

When a base class declares a method as virtual, the method ______________________

A WSDL File, A .DISCO File

When a web service is referenced from a client application in Microsoft Visual Studio, which two items are created?

protocol

When creating a site to utilize message queuing, the __________ must be configured to MSMQ.

on the computer that hosts the application

Where must Internet Information Services (IIS) be installed in order to run a deployed ASP. NET application?

communications protocol

Which function does Simple Object Access Protocol (SOAP) provide when using Web services?

JavaScript

Which language allows you to dynamically create content on the client side?

SQL

Which language uses Data Definition Language (DDL) and Data Manipulation Language (DML)?

SQL

Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?

JavaScript

Which programming language is characterized as client-side, dynamic and weakly typed?

Internet Information Services

Which service can host an ASP.NET application?

DateTimeOffset

You are building a web application that enables international exchange students to schedule phone calls with their prospective schools. The application allows students to indicate a preferred date and time for phone calls. Students may indicate no preferred time by leaving the date and time field empty. The application must support multiple time zones. Which data type should you use to record the student's preferred date and time?

Hosting

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?

SELECT firstName, lastName, telephoneNumber FROM Students

You are creating a database for a student directory. The Students table contains the following fields: Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?

Do-While

You are creating a routine that will perform calculations by using a repetition structure. You need to ensure that the entire loop executes at least once. Which looping structure should you use?

String

You are creating a variable for an application. You need to store data that has the following characteristics in this variable: ✑ Consists of numbers and characters ✑ Includes numbers that have decimal points Which data type should you use?

Windows Service Application

You are creating an application for computers that run Windows XP or later. This application must run after the computer starts. The user must not be aware that the application is running. The application performs tasks that require permissions that the logged-in user does not have. Which type of application allows this behavior

Web-based

You are creating an application that accepts input and displays a response to the user. You cannot create a graphical interface for this application. Which type of application should you create?

FormClosing

You are creating an application that presents the user with a Windows Form. You need to configure the application to display a message box to confirm that the user wants to close the form. Which event should you handle?

ASP.NET

You are creating an application that presents users with a graphical interface. Users will run this application from remote computers. Some of the remote computers do not have the . NET Framework installed. Users do not have permissions to install software. Which type of application should you choose?

double

You are creating the necessary variables for an application. The data you will store in these variables has the following characteristics: ✑ Consists of numbers ✑ Includes numbers that have decimal points ✑ Requires more than seven digits of precision You need to use a data type that will minimize the amount of memory that is used. Which data type should you use?

Share and data exchange

You are designing a Windows Store application. You need to design the application so that users can share content by connecting two or more devices by physically tapping the devices together. Which user experience (UX) guideline for Windows Store applications should you use?

Place the query into a stored procedure

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?

linear-gradientto bottom, green, black);

You are developing a web application. You need to create the following graphic by using Cascading Style Sheets (CSS): For the CSS Style background-image, you should use the value ________________

10px;

You are developing a web application. You need to create the following graphic by using Cascading Style Sheets (CSS): For the CSS Style border-radius, you should use the value ____________

4

You are developing a webpage that enables students to manage races. The webpage will display two lists: past races and upcoming races. The page also contains a sidebar with contact information and a panel with social media settings that can be edited. Race results can be shared on social media. How many components will be on the webpage?

current.Time current.Slower current.Faster current.Slower

You are developing an application that displays a list of race results. The race results are stored in the following class: You need to implement the Add Race method.

2

You are developing an application that tracks tennis matches. A match is represented by the following class: How many times is the Location property on the newly created Match class assigned?

Web application servers

You are reviewing the architecture for a system that allows race officials to enter the results of 5K race results. The results are then made available to students using a web application. The architecture is shown below. To increase the number of students that can access race results, what element should be added to the system?

Satellite link

You are reviewing the architecture for a system that allows race officials to enter the results of 5K race results. The results are then made available to students using a web application. The architecture is shown below. To minimize the time between when a race official records the results and when the results are available on the web, which part of the system is critical?

No

You are reviewing the following class that is used to manage the results of a 5K race: Can you change Key from "player" to "racer"?

Yes

You are reviewing the following class that is used to manage the results of a 5K race: Can you only set the player's ranking once?

Yes

You are reviewing the following class that is used to manage the results of a 5K race: If you call the MatchName method, will the code throw an exception?

No, no, yes

You are reviewing the following code that saves uploaded images. For each of the following statements, select Yes if the statement is true. Otherwise, select No.

server-side

You are writing a Web application that processes room reservation requests. You need to verify that the room that a guest has selected is not already reserved by another guest. Which type of programming should you use to determine whether the room is still available when the request is made?

Web Service Description Language (WSDL)

You create an application that uses Simple Object Access Protocol (SOAP). Which technology provides information about the application's functionality to other applications?

7

You create an object of type ANumber. The class is defined as follows. What is the value of _number after the code is executed?

50

You execute the following code. How many times will the word Hello be printed?

2

You execute the following code. What will the variable result be?

Application

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?

Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales

You have a SQL Server database named MyDB that uses SQL Server Authentication. Which connection string should you use to connect to MyDB?

LocalService

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?

No

You have a base class named Tree with a friend property named color and a protected property named NumberOfLeaves. In the same project, you also have a class named Person. Can methods in the Person class access the NumberOfLeaves property?

Yes

You have a base class named Tree with a friend property named color and a protected property named NumberOfLeaves. In the same project, you also have a class named Person. Can methods in the Person class access the color property?

No

You have a base class named Tree with a friend property named color and a protected property named NumberOfLeaves. In the same project, you also have a class named Person. Can methods in the Tree class access all private properties in Person?

Window.break();

You have a class named Glass that inherits from a base class named Window. The Window class includes a protected method named break(). How should you call the Glass class implementation of the break() method?

MyBase. brake();

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?

set

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?

public properties

must exist to inherit attributes from a particular class