MTA 98-361
How many parameters can a default constructor have?
0
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?
4
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?
6
What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (Each correct answer presents a complete solution. Choose two. ) A. For B. Do. . . While C. If D. While
A. For D. While
What are two possible options for representing a Web application within Internet Information Services (IIS)? (Each correct answer presents a complete solution. Choose two. ) A. Web site B. Web directory C. Virtual directory D. Application server E. Application directory
A. Web site C. Virtual directory
Which three items are benefits of encapsulation? (Choose three.) A. maintainability B. flexibility C. restricted access D. inheritance E. performance
A. maintainability B. flexibility C. restricted access
What are two advantages of normalization in a database? (Choose two) A. prevents data inconsistencies B. reduces schema limitations C. minimizes impact of data corruption D. decreases space used on disk
A. prevents data inconsistencies D. decreases space used on disk
Which three phrases are advantages of connection pooling? (Choose three.) A. reduces time to create a connection B. requires no configuration C. reduces load on the server D. improved scalability E. improved performance
A. reduces time to create a connection D. improved scalability E. improved performance
Which three items are benefits of encapsulation? A. restricted access B. flexibility C. maintainability D. performance E. inheritance
A. restricted access B. flexibility C. maintainability
Which two types of information should you include in an effective test case? A. on the computer that you plan to deploy from B. on the computer that hosts the application C. on the Application Layer Gateway Service D. on the client computers
A. the expected result from testing the case B. multiple actions combined as a single step to test the case
What are two possible options for representing a Web application within Internet Information Services (IIS)? (Each correct answer presents a complete solution. Choose two. ) A. web site B. virtual directory C. application directory D. application server E. Web directory
A. web site B. virtual directory
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?
ASP. NET
How should you configure an application to consume a Web service?
Add a reference to the Web service in the 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?
Application
Which three are valid SQL keywords? (Choose three.) A. GET B. FROM C. SELECT D. WHAT E. WHERE
B. FROM C. SELECT D. WHAT
You are creating a database for a student directory. The Students table contains the following fields: first name lastname emailaddress telephonenumber Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory? A. WHERE Students SELECT * B. SELECT firstName, lastName, telephoneNumber FROM Students C. SELECT firstName, lastName, telephoneNumber IN Students D. SELECT * FROM Students E. WHERE Students SELECT firstName, lastName, telephoneNumber
B. SELECT firstName, lastName, telephoneNumber FROM Students
When a web service is referenced from a client application in Microsoft Visual Studio, which two items are created? (Choose two.) A. a stub B. a.wsdl file C. a proxy D. a .disco file
B. a.wsdl file D. a .disco file
Which three phrases are advantages of connection pooling? (Choose three.) A. reduces load on the server B. improved performance C. reduces time to create a connection D. requires no configuration E. improved scalability
B. improved performance C. reduces time to create a connection E. improved scalability
What are the three basic states that a Windows service can be in? A. halted B. running C. stopped D. paused E. starting
B. running C. stopped D. paused
What are the three basic states that a Windows service can be in? (Choose three.) A. running B. starting C. halted D. stopped E. paused
B. starting D. stopped E. paused
Which three are valid SQL keywords?
C. FROM D. SELECT E. WHERE
What are two methods that can be used to evaluate the condition of a loop at the start of each iteration? (Each correct answer presents a complete solution. Choose two. ) A. If B. Do. . . While C. For D. While
C. For D. While
What are two advantages of normalization in a database? (Choose two.) A. reduces schema limitations B. minimizes impact of data corruption C. decreases space used on disk D. prevents data inconsistencies
C. decreases space used on disk D. prevents data inconsistencies
The throw keyword is used to perform which two actions? A. stop processing of the code B. move error handling to a separate thread C. raise exceptions D. re-throw exceptions as a different type
C. raise exceptions D. re-throw exceptions as a different type
The throw keyword is used to perform which two actions? (Choose two.) A. stop processing of the code B. move error handling to a separate thread C. raise exceptions D. re-throw exceptions as a different type
C. raise exceptions D. re-throw exceptions as a different type
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?
CREATE PROCEDURE store data @username navarchar (255)
Your database administrators will not allow you to write SQL code in your application. How should you retrieve data in your application? A. Script a SELECT statement to a file. B. Query a database view. C. Call a stored procedure. D. Reference an index in the database.
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?
Call a stored procedure.Call a stored procedure.
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?
Connection pooling
How does a console-based application differ from a Windows Forms application?
Console-based applications do not display a graphical interface.
How does a console-based application differ from a Windows Store app?
Console-based applications do not display a graphical interface.
You have a SQL Server database named MyDB that uses SQL Server Authentication. Which connection string should you use to connect to MyDB? A. Data Source=MyDB; Integrated Security=SSPf; Initial Catalog=Sales B. Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales C. Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales D. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales 0
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? A. Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales B. Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales C. Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales D. Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales
Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
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?
DateTimeOffset?
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?
Do„While
A data warehouse database is designed to:
Enable business decisions by collecting, consolidating, and organizing data.
You are creating an application that presents the user with a Windows Form. Which event is triggered each time the Windows Form receives focus?
Enter
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?
Establish a connection to the database by using the appropriate data provider.
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?
Event driven
The purpose of the Catch section in an exception handler is to:
Execute code only when an exception is thrown.
The purpose of the Finally section in an exception handler is to:
Execute code regardless of whether an exception is thrown.
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?
Form Closing
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?
Get
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?
Hosting
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? A. INSERT INTO ITEMS (ID, Description, Completed) VALUES (1, 'Cheese', 0) B. INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 1) C. INSERT INTO ITEMS (10, Description, Completed) VALUES (NEWID(), 'Cheese', 6) D. INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 0)
INSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 0)
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?
Inheritance
The purpose of a constructor in a class is to
Initialize an object of that class.
Which service can host an ASP.NET application?
Internet Information Services
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?
It speeds up query execution.
Which programming language is characterized as client-side, dynamic and weakly typed?
JavaScript
Which language allows you to dynamically create content on the client side?
JavaScript (JS)
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?
LocalService
Which type of Windows application presents a parent window that contains child windows?
Multiple-document interface (MDI)
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?
MyBase. brake();
bytes question
N,N,Y
Entity question
N,Y,Y,
(Y/N) XHTML attributes must be in uppercase
No
(Y/N) the "has a" relationship between classes refers to inheritence
No
(Y/N) the "is a" relationship between classes refers to composition
No
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?
Normalization
You need to allow a consumer of a class to modify a private data member. What should you do?
Provide a public function that assigns a value to the data member.
Which of the following must exist to inherit attributes from a particular class?
Public properties
Which of the following must exist to inherit attributes from a particular class? A. Public properties B. A has-a relationship C. An is-a relationship D. Static members
Public properties
In the life cycle of an ASP. NET Web page, which phase follows the SaveStateComplete phase?
Render
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?
SQL
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?
Share and data exchange
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?
String
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?
Use a Cascading Style Sheet (CSS)
You need to debug a Windows Service application by using breakpoints. What should you do?
Use the Attach to Process menu in Microsoft Visual Studio.
You create an application that uses Simple Object Access Protocol (SOAP). Which technology provides information about the application's functionality to other applications?
Web Service Description Language (WSDL)
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?
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? A. Windows Forms B. Windows Service C. Web-based D. Console-based
Web-based
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?
Window.break();
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?
Windows Forms
You are creating an application that presents users with a graphical interface in which they computers that do not have network connectivity. Which type of application should you choose?
Windows Forms
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
Windows Service
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?
Windows Service application
Tree question
Y,N,N,
(Y/N) XHTML attribute minimization is forbidden
Yes
(Y/N) XHTML attributes must be in quotation maks
Yes
What is displayed when you attempt to access a Web service by using a Web browser?
a listing of methods that are available in the Web service
Which type of function can a derived class override?
a protected virtual member function
Which function does Simple Object Access Protocol (SOAP) provide when using Web services?
communications protocol
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?
console-based
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?
double
What does the Console.Error property do within a console-based application?
gets the standard error output stream
What does the Console.Error property do within a console-based application? A. sets the standard error input stream B. gets the standard error output stream C. gets the standard error input stream D. sets the standard error output stream
gets the standard error output stream
You have a website that includes a form for usemame 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?
in both the client-side code and the server-side code
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?
it speeds up query execution.
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?
lace the query into a stored procedure.
The class 3 and the class 4 are derived from class 2 and the class 2 is derived from class 1 Which methods can the class 3 access ?
m1, m2, m3
Where must Internet Information Services (IIS) be installed in order to run a deployed ASP. NET application?
on the computer that hosts the application
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?
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?
polymorphism
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?
runat="server"
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?
server-side
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?
set
All objects in .NET inherit from which item?
the System.Object class
(Y/N) both composition and inheritance allow you to create sub objects
yes