Showing posts with label mcse. Show all posts
Showing posts with label mcse. Show all posts

Tuesday, March 10, 2015

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.


Wednesday, December 7, 2011

Microsoft 70-447 - Q & A / Study Guide

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at http://www.actualkey.com

QUESTION 1
You work as DBA at Certkingdom.com. You administer two Windows Server 2003
computers named Certkingdom A and Certkingdom B. You install SQL Server 2005 on both
Certkingdom A and Certkingdom B to host a new company database. Certkingdom A hosts a
read-write copy of the company database in which all changes are made. Certkingdom B
subscribes to a publication on Certkingdom A and is only used for reporting. A Windows
domain administrator provides you with a domain user account named SQLSRV to use as
the security context for the SQL Server services. A password policy of 42 days exists in
the Default Domain Group Policy object (GPO). You install the database on Certkingdom A
and Certkingdom B and configure replication. Everything works fine for six weeks, but then
all SQL Server services fail. You need to correct the problem. What should you do?

A. Ask the Windows domain administrator to grant the Log on as service right to the
SQLSRV domain user account.
B. Configure the SQLSRV domain user account with a new strong password. Configure
the new password in the properties of each SQL Server service that failed.
C. Create a local user account on Certkingdom A named Certkingdom A and a local user account
on Certkingdom B named Certkingdom B. Configure Certkingdom A and Certkingdom B to run under the
context of the appropriate local user account.
D. Ask the Windows domain administrator to grant the SQLSRV domain user account
membership in the Domain Admins group.

Answer: B

Explanation:
The Default Domain Group Policy object requires that passwords are
changed every 42 days. In order to correct this problem you have to change the
password in the Active Directory AND configure the new password on both you
SQL Servers to the newly changed password.


QUESTION 2
You are a database administrator of two SQL Server 2005 computers named Certkingdom A
and Certkingdom B. You have a Microsoft .NET application that has been modified so that it
now accesses a database on Certkingdom B in addition to Certkingdom A. You do not want the
user application to connect directly to Certkingdom B. You need to enable the data retrieval
from Certkingdom B while maintaining the ability to assign different permissions to different
users who use the .NET application. What should you do?

A. Change the .NET application to define a new server connection to Certkingdom B.
B. Configure a linked server on Certkingdom A to point to Certkingdom B.
C. Change the stored procedures called by the .NET application to include the
OPENXML command.
D. Configure a linked server on Certkingdom B to point to Certkingdom A.

Answer: B

Explanation:
SQL Server lets you access external data sources from your local
Transact-SQL code. You need to define a linked server for each external data
source you want to access and then configure the security context under which your
distributed queries will run. After you create a linked server, you can use the
Transact-SQL OPENQUERY function to execute your distributed queries.


QUESTION 3
You are a database administrator for Certkingdom.com. Your company uses a different
company's application that is based on SQL Server 2005 Standard Edition. The
application executes a query that uses an index query hint. The index query hint is not
suitable for your environment, but you cannot modify the query. You need to force the
application to use a different query execution plan. What should you do?

A. Create a plan guide for the query.
B. Clear the procedure cache.
C. Create a new covering index on the columns that the query uses.
D. Update the statistics for all of the indexes that the query uses.

Answer: A
Over the past few years, Microsoft SQL Server has increased its
presence in the industry and has reduced its TCO. This reduced TCO is a direct
result, primarily, of the numerous self-tuning mechanisms built into Microsoft(r)
SQL Server. These mechanisms automatically perform tasks that would otherwise
have to be performed by experienced database administrators. One such
mechanism is the cost-based optimizer (CBO) that is used to dynamically generate
query execution plans. The CBO probes several system-wide resource states and
employs many complex, heuristical algorithms to generate the best possible plan for
a given query and the underlying table and index structures. This mechanism works
well for the vast majority of user queries, but there are times when experienced
users need to force a particular query plan, based on some prior knowledge or
insights into future uses.


QUESTION 4
You are a database administrator for Certkingdom.com. Your SQL Server 2005 computer
contains one user database that holds sales transaction information. Users report that the
queries and stored procedures that they use every day are taking progressively longer to
execute. You also notice that the amount of free disk space on the SQL Server computer
is decreasing. You need to create a maintenance plan to correct the performance and
storage problems. What are two possible ways to achieve this goal? (Each correct answer
presents a complete solution. Choose two.)

A. In the SQL Server Maintenance Plan Wizard, use the Check Database Integrity option.
B. In the SQL Server Maintenance Plan Wizard, use the Reorganize Index option.
C. In the SQL Server Maintenance Plan Wizard, use the Shrink Database option.
D. In the SQL Server Maintenance Plan Wizard, use the Clean Up History option.
E. In the SQL Server Maintenance Plan Wizard, use the Execute SQL Server Agent Job
option.

Answer: B,C

Explanation:
When you indexes are not heavily fragmented you can reorganize
indexes, which uses few system resources and runs automatically online. In SQL
Server 2005, certain operations such as large delete operations or -one-time data
loads might leave database files larger than they need to be. SQL Server 2005
enables a DBA to shrink each file within a database to remove unused pages and
regain disk space.


QUESTION 5
You are a database administrator for Certkingdom.com. You are responsible for a SQL
Server 2005 database that has several indexes. You need to write a stored procedure that
checks the indexes for fragmentation. Which Transact-SQL statement should you use?

A. DBCC INDEXDEFRAG
B. SELECT * FROM sys.dm_db_index_physical_stats
C. SELECT * FROM sys.indexes
D. DBCC DBREINDEX

Answer: B

Explanation:
The index_physical_stats function takes five parameters: database_id,
object_id, index_id, partition_id, and mode. This function returns row size and
fragmentation information.


QUESTION 6
You work as DBA at Certkingdom.com. You administer two SQL Server 2005 computers
named Certkingdom A and Certkingdom B. Certkingdom A and Certkingdom B contain a copy of a
database named Sales. The database is replicated between Certkingdom A and Certkingdom B by
using transactional replication. A full backup of each database is performed every night.
Transaction log backups are performed every hour. Replication latency is typically less
than two minutes. One afternoon, the Sales database on Certkingdom A becomes corrupted.
You are unable to repair the database. The Sales database on Certkingdom B is unaffected.
You need to return the Sales database on Certkingdom A to normal operation as quickly as
possible. You must ensure a minimum loss of data and minimal impact to users of either
server. What should you do?

A. Perform a full database backup on Certkingdom B. Restore the backup to Certkingdom A.
B. Restore the most recent full database backup and all transaction logs made since the
full backup was made.
C. Restore only the most recent transaction log backup.
D. Detach the Sales database on Certkingdom B. Copy the database file to Certkingdom A, and
attach the database on both servers.

Answer: A

Explanation:
Detaching the database will not apply to the minimal impact on users
as it will be offline during copy. Restoring only the latest transaction log will not
give you a working database and restoring last full backup and all transaction logs
after that will not apply to the restore normal operations as quickly as possible part
of the requirements.


QUESTION 7
You are a database administrator for Certkingdom.com. The company runs a popular
database-driven Web site against a SQL Server 2005 computer named Certkingdom B. You
need to ensure a quick response time and appropriate audit trail in the event that
Certkingdom B experiences excessive traffic due to denial-of-service (DoS) attacks. Which
two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

A. Configure the new performance alert to start a SQL Server Profiler trace.
B. Create a new performance alert to monitor the Current Bandwidth counter.
C. Configure the new performance alert to start a Network Monitor capture.
D. Create a new performance alert to monitor the Bytes Total/sec counter.

Answer: C,D

Explanation:
Using alerts, System Monitor tracks specific events and notifies you of
these events as requested. An alert log can monitor the current performance of
selected counters and instances for objects in SQL Server. When a counter exceeds
a given value, the log records the date and time of the event. An event can also
generate a network alert. Characteristic for a typical DoS attack is a large number
of Bytes/sec. Characteristic for a DDoS attack is also a large number of Bytes/sec
but also a large number of connections made from a large number of hosts.


QUESTION 8
You are a database administrator for Certkingdom.com. One of the databases on a SQL
Server 2005 computer contains a stored procedure. Users run this stored procedure to
import data into a table. The stored procedure needs to use the TRUNCATE TABLE
command before importing new data into the table. However, the users who run the
stored procedure do not have permission to truncate the table. You need to provide a way
for the stored procedure to truncate the table before it imports new data. What should you
do?

A. Configure the stored procedure to use the EXECUTE AS command.
B. Configure the stored procedure to be owned by the same database user as the table.
C. Assign the users DELETE permission in the table.
D. Add the users to the db_datawriter fixed database role.

Answer: A

Explanation:
In SQL Server 2005 you can implicitly define the execution context of
the following user-defined modules: functions (except inline table-valued functions),
procedures, queues, and triggers. By specifying the context in which the module is
executed, you can control which user account the SQL Server 2005 Database Engine
uses to validate permissions on objects that are referenced by the module. This
provides additional flexibility and control in managing permissions across the object
chain that exists between user-defined modules and the objects referenced by those
modules. Permissions must be granted to users only on the module itself, without
having to grant them explicit permissions on the referenced objects. Only the user
that the module is running as must have permissions on the objects accessed by the
module.
Syntax:
Functions (except inline table-valued functions), Stored Procedures, and DML Triggers
{ EXEC | EXECUTE } AS { CALLER | SELF | OWNER | 'user_name' }


QUESTION 9
You are a database administrator for Certkingdom.com. You have separate SQL Server 2005
development and production environments. You use the Business Intelligence
Development Studio to create a SQL Server Integration Services (SSIS) package in your
development environment. Then, you use the SSIS package to import data into your
development environment from one of your company's trading partners. You need to
deploy the SSIS package to your production environment. Your production environment
uses different table names than your development environment. What should you do?

A. Save the SQL Server Integration Services (SSIS) package to a file. Copy the file to the
production server. Configure the SSIS package on the production server to use the new
file.
B. Back up the master database and restore it to the production server. Rename the
appropriate tables inside the master database.
C. Create a SQL Server Integration Services (SSIS) package configuration. Build a
deployment utility. Copy the deployment folder for your SSIS project to your production
server. Execute the manifest file.
D. Back up the msdb database and restore it to the production server. Rename the
appropriate tables inside the msdb database.

Answer: C

Explanation:
You have to use a SSIS package to accomplish this but you can not use
the package built for your development environment as the table names differ.


QUESTION 10
You are a database administrator for Certkingdom.com. You notice that one of the data files
on a SQL Server 2005 computer is corrupted. You need to restore the database from the
most recent set of backups. You want to perform this task as quickly as possible, with a
minimum loss of data. What should you do first?

A. Restore the most recent transaction log backup.
B. Restore the most recent full database backup.
C. Perform a full database backup.
D. Perform a transaction log backup.

Answer: D

Explanation:
In order to restore from the most recent set of backups, you have to
first ensure that you can restore all transactions that have occurred between the
time of the backup and the time when the database went corrupt. In order to
accomplish this you should backup the transaction log.

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at http://www.actualkey.com

Saturday, December 26, 2009

Cisco CCNA Career Training Choices Compared

Cisco CCNA Career Training Choices Compared

If Cisco training is your aspiration, and you haven't worked with routers or network switches, you should first attempt a CCNA training. This educates you in skills for setting up and maintaining routers. The internet is made up of hundreds of thousands of routers, and big organisations with several different sites also need routers to connect their computer networks.

Jobs that use this knowledge mean you'll be more likely to work for national or international companies that have various different locations but still need contact. The other possibility is being employed by an internet service provider. These jobs are well paid and in demand.

Getting your Cisco CCNA certification is perfectly sufficient to start with; don't be pushed into attempting your CCNP. After gaining experience in the working environment, you will have a feel for if it's relevant for you to have this next level up. If so, your experience will serve as the background you need to master your CCNP - which is quite a hard qualification to acquire - and mustn't be entered into casually.

Searching for your first position in IT can be a little easier if you're offered a Job Placement Assistance facility. With the massive demand for appropriately skilled people in this country at the moment, there's no need to get too caught up in this feature though. It isn't so complicated as you might think to land the right work once you're well trained and qualified.

One important thing though, don't procrastinate and wait until you have finished your training before updating your CV. As soon as your training commences, list what you're working on and get promoting! A good number of junior support jobs are offered to people who are still learning and have still to get qualified. This will at the very least get you on your way. If it's important to you to find work near your home, then you'll probably find that a local IT focused recruitment consultancy might serve you better than the trainer's recruitment division, for they're going to know the local job scene.

Various students, it would appear, put a great deal of effort into their studies (sometimes for years), only to do nothing special when trying to get the right position. Introduce yourself... Do everything you can to let employers know about you. Don't expect a job to just fall into your lap.

Most people don't even think to ask about something that can make a profound difference to their results - the way the company actually breaks down and delivers the courseware elements, and into how many bits. Training companies will normally offer a 2 or 3 year study programme, and send out each piece as you complete each section or exam. If you think this sound logical, then consider this: Students often discover that their training company's usual training route isn't ideal for them. They might find varying the order of study will be far more suitable. And what if you don't get to the end in the allotted time?

For maximum flexibility and safety, many trainees now want to have all their training materials (which they've now paid for) delivered immediately, and not in stages. You can then decide how fast or slow and in what order you want to go.

Many companies only look at the plaque to hang on your wall, and completely miss what it's all actually about - which will always be getting the job or career you want. Always start with the end goal - don't make the vehicle more important than the destination. It's a terrible situation, but thousands of new students commence training that sounds marvellous in the sales literature, but which provides the end-result of a job that doesn't satisfy. Just ask several university leavers to see what we mean.

Stay tuned-in to where you want to get to, and create a learning-plan from that - don't do it back-to-front. Keep your eyes on your goals and study for a career that will keep you happy for many years. Before you embark on a particular learning programme, it's good advice to chat over specific market requirements with an industry professional, to ensure the retraining programme covers all that is required.

Incorporating examination fees with the course fee then including an exam guarantee is a common method with a number of training colleges. However, let's consider what's really going on:

Patently it's not free - you're still footing the bill for it - it's just been included in your package price. It's everybody's ambition to qualify on the first attempt. Progressively working through your exams one at a time and funding them one at a time sees you much better placed to get through first time - you take it seriously and are aware of the costs involved.

Look for the very best offer you can at the appropriate time, and keep hold of your own money. You also get more choice of where you sit the exam - meaning you can choose a local testing centre. Huge profits are made by a significant number of organisations who get money for exam fees in advance. Many students don't take them for one reason or another but no refunds are given. Amazingly, there are companies around who actually bank on it - as that's how they make a lot of their profit. Remember, with most 'Exam Guarantees' - they control when and how often you are allowed to do a re-take. You will have to demonstrate an excellent pass-rate before they'll approve a re-take.

Exam fees averaged 112 pounds or thereabouts last year through VUE or Pro-metric centres in the UK. Therefore, why splash out often many hundreds of pounds extra for 'Exam Guarantees', when any student knows that the best guarantee is a commitment to studying and the use of authorised exam preparation tools. for more info login to http://www.certkingdom.com