Microsoft 98-361 Microsoft MTA Software Development Fundamentals Online Training
Microsoft 98-361 Online Training
The questions for 98-361 were last updated at Dec 20,2024.
- Exam Code: 98-361
- Exam Name: Microsoft MTA Software Development Fundamentals
- Certification Provider: Microsoft
- Latest update: Dec 20,2024
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?
- A . It reorders the records alphabetically.
- B . It speeds up query execution.
- C . It minimizes storage requirements.
- D . It reorders the records numerically.
Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?
- A . Java
- B . SQL
- C . C++
- D . Visual Basic
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?
- A . Isolation
- B . Normalization
- C . Integration
- D . Resolution
In your student directory database, the Students table contains the following fields:
firstName
lastName
emailAddress
telephoneNumtoer
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?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
A data warehouse database is designed to:
- A . Enable business decisions by collecting, consolidating, and organizing data.
- B . Support a large number of concurrent users.
- C . Support real-time business operations.
- D . Require validation of incoming data during real-time business transactions.
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?
- A . Deactivate
- B . Leave
- C . FormClosed
- D . FormClosing
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 . Windows Service
- B . Windows Forms
- C . Console-based
- D . Batch file
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
You need to create an application that processes data on a last-in, first-out (LIFO) basis.
Which data structure should you use?
- A . Queue
- B . Tree
- C . Stack
- D . Array
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?
- A . Binary tree
- B . Stack
- C . Hashtable
- D . Queue
Latest 98-361 Dumps Valid Version with 164 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
