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
