Tag Archives: Microsoft Technology Associate (MTA)

98-364 Database Administration Fundamentals


QUESTION 1
The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?

A. View
B. Function
C. Index
D. Stored procedure
E. Trigger

Answer: C


QUESTION 2
One reason to add an index is to:

A. Decrease storage space.
B. Increase database security.
C. Improve performance of select statements.
D. Improve performance of insert statements.

Answer: C


QUESTION 3
You have a table that contains the following data.


You break the table into the following two tables.

This process is referred to as:

A. defragmentation
B. normalization
C. fragmentation
D. denormalization

Answer: B


QUESTION 4
You have a table that contains the following data.

Which database term is used to describe the relationship between ProductID and ProductCategory?

A. Cohort
B. Relationally dependent
C. Deterministic
D. Functionally dependent
E. Compositional

Answer: D


QUESTION 5
Which key uniquely identifies a row in a table?

A. foreiqn
B. primary
C. local
D. superkey

Answer: B

 

Click here to view complete Q&A of 98-364 exam

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 98-364 Training at certkingdom.com

98-361 Software Development Fundamentals


QUESTION 1
You are employed as a developer at ABC.com. You make use of C# and ASP.NET for
development purposes.
You have been asked to create a new program for ABC.com. Prior to creating the new program,
you plan to create an algorithm to fully comprehend how the processes of the program must run.
The algorithm will list the required actions for completing a process in the appropriate sequence.
You are informed that your method for creating the algorithm should be as simple, and clear as
possible.
What option should you use?

A. You should consider making use of the flowchart method.
B. You should consider making use of the pivotchart method.
C. You should consider making use of the data table method.
D. You should consider making use of the XML method.

Answer: A

Explanation:


QUESTION 2
You are employed as a developer at ABC.com. You are creating a .NET Framework application.
You have been instructed to make sure that you make use of Common Intermediate Language
(CLI) for programming the application.
What options are TRUE with regards to CLI? (Choose all that apply.)

A. CIL is the highest-level human-readable programming language defined by the Common
Language Infrastructure specification.
B. CIL is the highest-level human-readable programming language defined by the Common
Language Infrastructure specification.
C. CIL is an object-oriented assembly language, and is entirely stack-based.
D. CIL is an object-oriented assembly language, but is not stack-based.

Answer: A,C

Explanation:


QUESTION 3
You are employed as a developer at ABC.com. You make use of Visual Basic .Net for
development purposes.
You have written the code shown below for declaring an array of a new application:
Dim myArray as String = { apples, pears, plums, grapes, oranges, bananas}
You want to return the third item in your array.
What code would you employ?

A. myArray[1]
B. myArray[2]
C. myArray[3]
D. myArray[4]
E. myArray[5]
F. myArray[6]

Answer: B

Explanation:


QUESTION 4
You are employed as a developer at ABC.com. You are in the process of creating code for a
method that does not retrieve a value for the calling code.
You want to make sure that this is reflected when declaring the method.
What option should you use?

A. You should consider making use of the void keyword in the method declaration.
B. You should consider making use of the sealed C# statement in the method declaration.
C. You should consider making use of the internal C# statement in the method declaration.
D. You should consider making use of the public C# statement in the method declaration.
E. You should consider making use of the protected C# statement in the method declaration.

Answer: A

Explanation:


QUESTION 5
You are employed as a developer at ABC.com. You make use of C# and ASP.NET for
development purposes.
You have received instructions to create a new program for ABC.com using C#. You are informed
that the new program should allow for intricate multi-way branching. Furthermore, the code used
must not be difficult to make sense of.
What is the option you should use?

A. You should consider making use of the foreach C# statement.
B. You should consider making use of the while C# statement.
C. You should consider making use of the protected C# statement.
D. You should consider making use of the switch C# statement.

Answer: D

Explanation:


 

 

Click here to view complete Q&A of 98-361 exam

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 98-361 Training at certkingdom.com

The Big Question Rises How To Become Microsoft, Cisco, ComTIA Certified

The big question rises how to become the Microsoft certified , All Microsoft certifications are acquired by simply taking a series of exams. If you can self-study for said exams, and then pass them, then you can acquire the certification for the mere cost of the exam (and maybe whatever self-study materials you purchase).

You’ll also need, at minimum (in addition to the MCTS), the CompTIA A+, Network+ and Security+ certs; as well as the Cisco CCNA cert.

Microsoft Certified Technology Specialist (MCTS) – This is the basic entry point of Microsoft Certifications. You only need to pass a single certification test to be considered an MCTS and there are numerous different courses and certifications that would grant you this after passing one. If you are shooting for some of the higher certifications that will be discussed below, then you’ll get this on your way there.

Microsoft Certified Professional Developer (MCPD) – This certification was Microsoft’s previous “Developer Certification” meaning that this was the highest certification that was offered that consisted strictly of development-related material. Receiving it involved passing four exams within specific areas (based on the focus of your certification). You can find the complete list of courses and paths required for the MCPD here.

Microsoft Certified Solutions Developer (MCSD) – This is Microsoft’s most recent “Developer Certification” which will replace the MCPD Certification (which is being deprecated / retired in July of 2013). The MCSD focuses within three major areas of very recent Microsoft development technologies and would likely be the best to persue if you wanted to focus on current and emerging skills that will be relevant in the coming years. You can find the complete list of courses and paths required for the MCSD here.

The Microsoft Certifications that you listed are basically all of the major ones within the realm of development. I’ll cover each of the major ones and what they are :

Most people, however, take some kind of course. Some colleges — especially career and some community colleges — offer such courses (though usually they’re non-credit). Other providers of such courses are private… some of them Microsoft Certified vendors of one type or another, who offer the courses in such settings as sitting around a conference table in their offices. Still others specialize in Microsoft certification training, and so have nice classrooms set up in their offices.

There are also some online (and other forms of distance learning) courses to help prepare for the exams.

The cost of taking classes to prepare can vary wildly. Some are actually free (or very nearly so), while others can cost hundreds of dollars. It all just depends on the provider.

And here’s a Google search of MCTS training resources (which can be mind-numbing in their sheer numbers and types, so be careful what you choose):

There are some pretty good, yet relatively inexpensive, ways to get vendor certificate training. Be careful not to sign-up for something expensive and involved when something cheaper — like subscribing to an “all the certificates you care to study for one flat rate” web site — would, in addition to purchasing a study guide or two at a bookstore, likely be better.

If you want a career in IT, then you need to have both an accredited degree in same (preferably a bachelors over an associates), and also a variety of IT certifications. The MCTS is but one that you will need.

You should probably also get the Microsoft MCSE and/or MCSA. The ICS CISSP. And the ITIL.

There are others, but if you have those, you’ll be evidencing a broad range of IT expertise that will be useful, generally. Then, in addition, if the particular IT job in which you end-up requires additional specialist certification, then you can get that, too (hopefully at the expense of your employer who requires it of you).

Then, whenever (if ever) you’re interested in a masters in IT, here’s something really cool of which you should be aware…

There’s a big (and fully-accredited, fully-legitimate) university in Australia which has partnered with Microsoft and several other vendors to structure distance learning degrees which include various certifications; and in which degrees, considerable amounts of credit may be earned simply by acquiring said certifications. It’s WAY cool.

One can, for example, get up to half of the credit toward a Masters degree in information technology by simply getting an MCSE (though the exams which make it up must be certain ones which correspond with the university’s courses). I’ve always said that if one were going to get an MCSE, first consult the web site of this university and make sure that one takes the specific MCSE exams that this school requires so that if ever one later decided to enter said school’s masters program, one will have already earned up to half its degree’s credits by simply having the MCSE under his/her belt. Is that cool, or what?

I wouldn’t rely on them over experience (which is far and away the most valuable asset out there) but they are worth pursuing especially if you don’t feel like you have enough experience and need to demonstrate that you have the necessary skills to land a position as a developer.

If you are going to pursue a certification, I would recommend going after the MCSD (Web Applications Track) as it is a very recent certification that focuses on several emerging technologies that will still be very relevant (if not more-so) in the coming years. You’ll pick up the MCTS along the way and then you’ll have both of those under your belt. MCPD would be very difficult to achieve based on the short time constraints (passing four quite difficult tests within just a few months is feasible, but I don’t believe that it is worth it since it will be “retired” soon after).

No job experience at all is necessary for any of the Microsoft Certifications, you can take them at any time as long as you feel confident enough with the materials of the specific exam you should be fine. The tests are quite difficult by most standards and typically cover large amounts of material, but with what it sounds like a good bit of time to study and prepare you should be fine.

Certifications, in addition to degrees, are so important in the IT field, now, that one may almost no longer get a job in that field without both. The certifications, though, are so important that one who has a little IT experience can get a pretty good job even without a degree as long as he has all the right certs. But don’t do that. Definitely get the degree… and not merely an associates. Get the bachelors in IT; and make sure it’s from a “regionally” accredited school.

Then get the certs I mentioned (being mindful, if you think you’ll ever get an IT masters, to take the specific exams that that Strut masters program requires so that you’ll have already earned up to half the credit just from the certs).

If you already have two years of experience in working in the .NET environment, a certification isn’t going to guarantee that you will get employed, a salary increase or any other bonuses for achieving the honor. However, it can help supplement your resume by indicating that you are familiar with specific technologies enough to apply them in real-world applications to solve problems.

If your ready for career change and looking for Microsoft MCTS Training, Microsoft MCITP Training or any other Microsoft Certification preparation get the best online training from Certkingdom.com they offer all Microsoft, Cisco, Comptia certification exams training in just one Unlimited Life Time Access Pack, included self study training kits including, Q&A, Study Guides, Testing Engines, Videos, Audio, Preparation Labs for over 2000+ exams, save your money on boot camps, training institutes, It’s also save your traveling and time. All training materials are “Guaranteed” to pass your exams and get you certified on the fist attempt, due to best training they become no1 site 2012.

MCTS Training, MCITP Trainnig

Best Microsoft MTA Certification, Microsoft MCTS Training at certkingdom.com