MCTS Online Training

15 Top Paying Certifications for 2013
Randy Muller, Global Knowledge Instructor, MCT, MCSE, MCSA, MCDST

Having earned an IT certification, many individuals think they are automatically entitled to a huge raise. The truth is that several factors, including geography, industry, experience, and yes, certifications, combine to play a major role in determining an individual’s salary. However, certain certifications do have greater impact on the earning potential of an individual. Here, we take a look at the 15 certifications with the highest earning potential for 2013.

Note: The rankings below are derived from certifications that received the minimum number of responses to be statistically relevant in the Global Knowledge annual salary survey completed in October 2012. Certain certifications pay more, but are not represented due to their exclusive nature. These include CCIE: Cisco Certified Internetworking Expert and VCDX: VMware Certified Design Expert, for example.

1. PMP: Project Management Professional – $105,750
The Project Management Institute’s (PMI) Project Management Professional (PMP) credential is recognized as the most important certification for project managers. It is globally acknowledged, in heavy demand, and highly sought after by corporations and individuals alike. A Project Management Professional designation demonstrates that you have not only the experience but also the education to successfully lead and direct projects. The PMP credential is for experienced project management professionals, as the qualifications and testing for this certification are rigorous, as are the required continuing education requirements. All of these factors ensure that the PMP credential is widely respected. The PMP experience and exam requirements focus on five process groups: Initiating, Planning, Executing, Controlling, and Closing.

2. CISSP: Certified Information Systems Security Professional – $103,299
The Certified Information Systems Security Professional (CISSP) credential is primarily intended for security managers and profes¬sionals who develop policies and procedures in information security. The CISSP certification has become the gold standard in information security certifications and education. Earning and maintaining a CISSP certification is required for many government, military, and civilian security positions. The CISSP was the first credential in the field of information security, accredited by the ANSI (American National Standards Institute) to ISO (International Organization for Standardization) Standard 17024:2003.

3. MCSD: Microsoft Certified Solutions Developer – $97,849
The Microsoft Certified Solutions Developer is the new Microsoft developer certification that replaces the old Microsoft Certified Solutions Developer certification. The new certification validates a candidate’s ability to design and build application solutions. These solutions may span multiple versions of a single technology or integrate multiple technologies. Developers are expected to analyze and design enterprise solutions using different Microsoft languages and development tools.

Currently, there are three separate certification tracks for those seeking to earn this certification: MCSD: Windows Store Apps, MCSD: Web Applications, and MCSD: Application Lifecycle Management. Each MCSD track requires anywhere from three to six separate exams. Microsoft has introduced a recertification requirement for the new MCSD. Current certification holders will have to recertify every two years, ensuring that they remain current on the base technology that will have changed due to service packs, revisions, and new product releases. (Those holding MCSE certifications will have to recertify every three years).

4. MCDBA: Microsoft Certified Database Administrator – $95,950
Access to information is critical in today’s fast-paced, global environment. Corporations are even more dependent on quick and reliable systems to process and retrieve information. This means they must operate their own database servers and business intelligence software to access this information in order to grow and become more successful, and Microsoft Certified Database Administrators (MCDBA) are the ones who provide this expertise. An MCDBA-certified individual has proven his or her ability to design, implement, and manage SQL Server 2000 databases. This certification was retired on September 30, 2012, though if you achieved it before that date it will still appear on your transcript as a legacy certification. There are two new MCSE certifications for SQL 2012: Microsoft Certified Solutions Expert (MCSE): Data Platform and Microsoft Certified Solutions Expert (MCSE): Business Intelligence.

5. CCDA®: Cisco Certified Design Associate – $94,799
The Cisco Certified Design Associate (CCDA) indicates that the certified individual has a strong foundation and apprentice knowledge of network design for Cisco converged networks. A CCDA certification is for network design engineers, technicians, and support engineers, who enable efficient network environments. The CCDA-certified individual has the skills to design a routed and switched network infrastructure and services involv¬ing LAN, WAN, and broadband access for businesses and organizations.

6. MCAD: Microsoft Certified Application Developer – $93,349
The Microsoft Certified Application Developer (MCAD) credential provides industry recognition for professional developers who build powerful applications using Microsoft Visual Studio .NET and Web services. Responsibilities include implementing requirements, developing, testing, deploying, and maintaining department-level applications components, Web or desktop clients, or back-end data services by using Microsoft tools and technologies. The MCAD certification is appropriate for Programmers, Analysts, Software Engineers, Software Application Specialists and Application/Software Developers.

7. VCP-DV: VMware Certified Professional Datacenter Virtualization – $92,400
Virtualization, and those who are knowledgeable on virtualization products, are in heavy demand, especially those professionals with datacenter virtualization skills. In the highly competitive virtualization market it is essential to distinguish yourself with a certification that validates your technical capabilities. VMware is one of the leading vendors of virtualization products and earning a VMware certification is the first step toward gaining industry-recognized expertise in virtual infrastructure. Earning the VCP-DV certification demonstrates that you have not only completed a VMWare-authorized training course but also have the necessary experience and training to successfully install, deploy, scale, and manage VMware vSphere environments.

8. CNE: Certified Novell Engineer – $91,350
The Certified Novell Engineer (CNE) shows that those certified individuals have the expertise and knowledge to solve advanced company-wide support problems and high-level network problems. They perform planning, installation, configuration, troubleshooting, and upgrade services for networks. The Certified Novell Engineer (CNE) has been recognized as one of the IT industry’s leading certifications for advanced networking and troubleshooting professionals.

9. ITIL v3 Foundation – $90,900
The Information Technology Infrastructure Library (ITILv3) is a foundational process that provides for quality IT Service Management. The success of ITIL is through the use of documented and proven processes that cover the entire Service Lifecycle. The ITIL Expert level is the third of four levels. The ITIL Expert level certification is aimed at those individuals who are interested in demonstrating a superior level of knowledge of ITIL Version 3 (v3) in its entirety. Once you have achieved ITIL Expert level you will also satisfy the pre-requisite entry criteria for the ITIL Master Level; the highest level of certification within the ITIL v3 scheme, though the Master level is still under development.

10. CCA: Citrix Certified Administrator – Citrix XenServer 6 – $90,850
The Citrix CCA is an entry-level certification. Earning this certification validates the candidate’s skills with one of 11 specific Citrix products, the most popular being XenApp, XenDesktop, and XenServer. The Citrix Certified Administrator (CCA) for Citrix XenServer 6 certification validates the certified individual’s ability to effectively install, configure, administer, troubleshoot, and maintain XenServer 6.0 Enterprise edition and Provisioning Services 6.0 in an enterprise environment.

11. MCITP: Database Administrator – $90,200
The MCITP certification validates that the IT professional is capable of deploying, building, designing, optimizing, and operating technologies for a particular job role. MCITP certifications builds on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. In order to earn the MCITP: Database Administrator you must first pass the Microsoft Certified Technical Specialist certification in SQL Server 2008 (by passing the 70-432 exam) and then pass the 70-450 exam. The MCITP Database Administrator demonstrates knowledge of SQL Server instances and database solutions, database server security solutions, high availability databases, backup and recovery solutions, monitoring strategies, database management and maintenance strategies, and data distribution strategies.

12. MCTS: SQL Server 2005 – $90,100
Those who have earned the MCTS: SQL Server 2005 certification are IT professionals who may pursue careers as database administrators, database developers, or business intelligence developers. They may also be people who do not work with Microsoft SQL Server as a part of their primary job functions but who want to show their breadth of technology experience, such as developers, systems administrators, and others. This certification validates that the IT professional can implement and maintain databases by using specific instructions and specifications.

13. MCT: Microsoft Certified Trainer – $89,949
Those holding the Microsoft Certified Trainer (MCTs) certification are the premier technical and instructional experts on Microsoft technologies. An MCT has earned at least one premier certification on a Microsoft product and maintains that certification. Some of the benefits of earning and maintaining an MCT include access to the complete library of Official Microsoft Learning Products; substantial discounts on exams, books, and Microsoft products; members-only newsgroups and online community resources; and invitations to exclusive events and programs. MCT’s must renew each year by completing an online application, pay an annual fee, and meet a number of program requirements to renew your certification for the coming year.

14. CCNP®: Cisco Certified Network Professional – $89,749
There are two tracks available at the Associate and Professional levels – Designing and Networking. The Cisco Certified Network Professional (CCNP) demonstrates that you have the ability to plan, implement, verify, and troubleshoot local and wide-area enterprise networks. A CCNP-certified individual is expected to work collaboratively with other Cisco specialists on advanced products such as security, voice, wireless, and video solutions.

15. CCA: Citrix Certified Administrator – Citrix XenDesktop 5 – $89,499
The Citrix CCA is an entry-level certification. Earning this certification validates the candidate’s skills with one of 11 specific Citrix products, the most popular being XenApp, XenDesktop, and XenServer. The CCA for Citrix XenDesktop 5 certifies the expertise required to install, administer, and troubleshoot an enterprise environment containing a XenDesktop implementation, including Provisioning Services, XenServer, XenApp and the Desktop Delivery Controller
Summary

Earning a certification does not guarantee that you will walk into a higher paying job. Certification counts, but employers look at several factors, including experience. There was a time when certification holders were reasonably assured of landing a job. Today it is more of a qualifier – not having a certification means you may not even get an interview.
About the Author

Randy Muller (MCT, MCTS, MCSE, CEH) is an instructor with Global Knowledge, specializing in teaching Microsoft Office 365, Exchange, Lync Server as well as Windows Server 2008.

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

facebook   twitter   digg   tumblr   stumbleupon   linkedin   delicious    

The Rewards of Microsoft Certification

Microsoft certification is a vast combination of rich and varied spectrum of job and responsibilities. To successfully perform the critical IT function we should earn a specific credential providing objective validity of the ability. One of the most effective ways to reach a long-term career goal, which is even embraced by industry professionals worldwide, is Microsoft certification.

What are the benefits of achieving a Microsoft Certification?

Microsoft Certification enables you to keep your skills relevant, applicable, and competitive. In addition, Microsoft Certification is an industry standard that is recognized worldwide—which helps open doors to potential job opportunities. After you earn your Microsoft Certification, you have access to a multitude of benefits, which can be found on the MCP, MCT, or MOS member site.

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

===============================================================================================

Advancing with long-term career goals Microsoft certification has helped countless IT professionals work more effectively. Individuals have started quoting their valuable experiences during the Microsoft certification course on the websites available. The professionals of Microsoft certification course are very different from the IT counterparts. They not only keep on fighting the challenges of IT field but also have keep themselves a step ahead from them by developing and improving their skills. These certification processes gives one a kind of knowledge to know how to get recognized in any field.

The professionals of Microsoft certification are called at the Microsoft certified professionals or MCP. For the this Microsoft certification they have to pass current Microsoft certification exam which will proved a reliable and valid measure of professional and technical expertise. The validity of a current exam is only considered and not which is retired. Microsoft certification exams reflect how Microsoft products are used in the organization.

Microsoft certification exams are developed from the inputs received from the IT industry professionals. The independent testing organizations administer these exams. There is one very big reason why IT professionals and developers become Microsoft certified professionals is that they all know that their clients, peers, employees and the IT industry shall acknowledge their expertise in working with the Microsoft products and technologies.

There are various steps towards obtaining Microsoft certification. Firstly, one should decide which Microsoft certification is correct for the person. As Microsoft offers a vast variety of professions within the IT industry one should understand which course would be the best for him. One should also get handy with the Microsoft products, which can be done only after working in the IT industry. Experience should be expanded with training by taking advantage of the training resources.

For obtaining Microsoft certification, it is also better to know what to expect in the exam. Previous question papers or taking consultation from those who have appeared or cleared the test is always a good choice. Taking helps from the help guides for Microsoft certification exams is also an added advantage. These help provide guidelines and suggestions to the person appearing for the exam. It is also suggested to take trial tests before appearing for the final exam. The test center should be selected from the worldwide locations. Also certain details like area of study, testing program and region etc should be mentioned.

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.

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

===============================================================================================
About The Author

Hi I educated in the U.K. with working experienced for 5 years in multinational companies, As an IT Manager and IT Instructor, I am attached with certkingdom.com here they provide IT exams study material, the study materials included exams Q&A with Explanation, Testing Engine, Study Guides, Training Labs, Exams Simulations, Training Videos, Audio Exams Training, etc. for certification like MCTS Training, MCITP MCTS, MCSD, MCSA, MCSE  Training, CCNA exams preparation, CompTIA A+ Training, and more Certkingdom.com provide you the best training 100% guarantee. “Best Material Great Results”
My Specialties

I’ve worked with a lot of technologies, but these are where my focus has been in recent years:

* Microsoft SQL Server (particularly high availability and disaster recovery)

* VMWare Virtualization

* Oracle (yes, Oracle, I’ve worked on 7-11)

* Microsoft Clustering

* Red Hat Linux (I can still write shell scripts)

facebook   twitter   digg   tumblr   stumbleupon   linkedin   delicious    

Oracle and SAP may be back in court on June 18 to begin a retrial of Oracle’s corporate theft lawsuit involving SAP’s former TomorrowNow subsidiary, according to a judge’s order Thursday.

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

Oracle was awarded US$1.3 billion in damages from SAP last November as compensation for TomorrowNow’s theft of software and support materials from an Oracle website.

SAP argued the sum was unfairly high, and the court agreed, overturning the jury’s award. Oracle was given a choice of accepting a lower damages amount of $272 million or going into a new trial, and earlier this month it picked the new trial.

The two weeks starting June 18 are the only two weeks free on the judge’s calendar this year, Judge Phyllis Hamilton of the Northern District Court of California said in her scheduling order Thursday. If Oracle and SAP reject that date, they can choose Aug. 13, 2013, or else hope an opening comes up before then.

It will be a busy year for Oracle in the courts. The company is fighting two other big cases that are due to go to trial this year. One was brought by Hewlett-Packard, over Oracle’s decision to drop support for Itanium. The other is Oracle’s suit against Google for alleged patent and copyright violations in Android.

facebook   twitter   digg   tumblr   stumbleupon   linkedin   delicious    

Microsoft is replacing its Office Academic SKU with a new Office University one that it hopes will help curtail fraudulent use.

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

Whenever folks complain about how expensive Microsoft’s Office suite is, someone inevitably points out that the academic version is only about under $100 (usually around $80). And if you’re not a student… no worries. You can use someone else’s ID to buy it.

Microsoft officials know this, too. To help thwart non-students from getting an undeserved  deal on the Academic SKU — which includes Word 2010, Excel 2010, PowerPoint 2010, OneNote 2010, Outlook 2010, Publisher 2010, Access 2010, and Office Web Apps (the free, consumer-focused version of Microsoft’s Webified version of four of its Office apps) — Microsoft is tightening the verification requirements.

On February 1, Microsoft quietly replaced the Office Professional Academic 2010 SKU with a new one called “Microsoft Office University 2010.” The new SKU is for “higher-education” students and faculty only. “Microsoft Office Home and Student 2010 is the recommended product for parents and families with K-12 students,” according to a Microsoft frequently asked questions (FAQ) document. (There’s a new comparable Office for Mac 2011 University SKU, too.)

C-FAX 1070 radio “Tech Talk” host Alan Perry is the one who alerted me to the new SKU, which Microsoft confirmed.

Office University 2010 includes the same point products as the former Academic Professional SKU. It costs $99 and can be installed on two PCs. But it has a new verification process, which works as follows, according to the FAQ:

Office University 2010 does not come with a product key. Your eligibility will be verified online before completing purchase. This product will not work without successful verification as you will not have a product key.

You will be required to verify your eligibility online to use this software.
1.Go to www.office.com/verify.
2.Sign in with your Windows Live ID or create one using any email address.
3.Provide your school email address, sign-in ID, or international student identity card (ISIC).

Once you pass verification, the online site displays the product key.

“The big change is the validation process, as you’ll see on the big warning stickers on the packaging,” said Perry. “Up to now, if you could persuade someone to sell you a copy, (even if you weren’t a student or faculty) it was yours to use. The change appears to be an effort to curtail the large number of ineligible people buying the Academic versions.”

Microsoft plans to offer a similar Office University SKU as part of its next versions of Office for Windows and Mac, Perry said the Softies told him.

facebook   twitter   digg   tumblr   stumbleupon   linkedin   delicious    

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.

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

facebook   twitter   digg   tumblr   stumbleupon   linkedin   delicious