Posts Tagged ‘MCSA’


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

by admin ·

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 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 Releases Small Business Server 2012 Training

by admin ·

Certkingdom, Inc the global leader in professional computer training, announced the release of its new Small Business Server 2012 Training.

Just because a business is small, doesn’t mean it can get by without a business server. Microsoft’s Small Business Server 2012 offers small to medium size businesses an updated suite of powerful server software including Windows Server 2008 R2, Microsoft Exchange 2010 and SharePoint Foundation 2010, all in a single package. Businesses that need a robust database server can add the Small Business Server 2012 Premium Add-On, which provides a SQL Server 2008 R2 for Small Business server license as well.

Microsoft’s SBS 2012 is a full-featured server environment for small businesses. SBS 2012 offers a lower cost server solution without the additional overhead and complexity of the company’s flagship Windows Server product.

Certkingdom’s SBS 2012 Training instructor Ed Liberman said, “SBS 2012 is a cost effective way to get a lot of services on a single server. It’s a great tool for making small businesses more efficient, as one administrator can handle all of the server tasks, whether it’s managing the network, Exchange or SharePoint.”

While Microsoft has done an admirable job of simplifying the installation and management of SBS 2012, software this powerful requires some technical knowledge to maximize its potential for small businesses. That is why Certkingdom’s first to market SBS 2012 training is so valuable.

Certkingdom’s Small Business Server 2012 Training course teaches network administrators and small business owners how to install, configure, manage and optimize an SBS 2012 environment. The SBS 2012 course also covers how to migrate from Small Business Server 2003 or Small Business Server 2008. Students looking to prove their SBS 2012 competency will be glad to know that Certkingdom’s SBS 2012 training offers full coverage of Microsoft certification exam 70-169: Windows Small Business Server 2012 Standard, Configuring.

This Small Business Server training will help get a small business up and running with ease. The full level of coverage means that students can take advantage of the enormous potential provided by all of SBS’s eight Microsoft products in one package, including Windows Server 2008 R2, Exchange Server 2010 Standard SP1, SharePoint Foundation 2010, SQL Server 2008 R2 Express, WSUS 3.0 SP2, Integrated Migration Prep Tool and Remote Web Access.

Matt Elias, Certkingdom’s Product Team Manager, said, “SBS 2012 is a collaboration of different Microsoft products that are designed to work together seamlessly. The product has really come a long way in the last decade and in our SBS 2012 training we show users how to take advantage of the complete SBS Package.”

The instructors for this course are networking and Windows Server expert Ed Liberman and SharePoint and Exchange expert J. Peter Bruzzese.

Ed Liberman has 18 years of experience and numerous industry certifications including MCSA, MCSE, MCT, MCTS, MCITP, CWNA, CWTS, CWNT. He has been a certified instructor since 1998 and has helped thousands of people advance their IT careers. While Liberman ensures students have the knowledge to pass a certification exam, his real focus is on helping students develop the skills needed to succeed in the real world.

J. Peter Bruzzese, who covers the SharePoint and Exchange topics in the SBS 2012 course, also has multiple certifications including a Triple-MCSE, MCT, MCSA, MCITP: Messaging and is a Microsoft MVP for Exchange. He has published numerous books including Exchange 2007 SP1 How-To, Server 2008 How-To and Windows 7 Unveiled, all from publisher Que. Bruzzese is also a regular contributor to Redmond Magazine, Windows IT Pro, Realtime and TechTarget, as well as being a regular speaker at Microsoft TechEd Conferences and IT 360 Tech Conferences in Canada.

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at

Gosia Niklinski, Certkingdom’s Product Development Specialist, said, “Our SBS 2012 training is perfect for beginners. Ed and Peter not only show you how to do everything, they explain in detail why you’re doing it. But the course is also great for those moving from previous versions of SBS as the migration steps from 2003 and 2008 are covered in detail.”

Certkingdom’s Small Business Server 2012 Training provides almost 16 hours of training broken down into 25 lessons. Students receive three DVDs in the mail, including two DVDs of video lessons and an additional content DVD. However, students don’t have to wait for their disks to arrive to get started. Certkingdom offers instant online access to all course materials, content and notes almost immediately after signing up.

Like all Certkingdom courses, all lessons come in multiple audio and video formats ensuring that students can access the training on virtually any device. In addition, all instructor notes are included in PDF format for reading on the go, or following along with the training videos.

Certkingdom’s Small Business Server 2012 Training is offered at just $397 and comes backed by a 90 Day Total Experience Guarantee.

About Certkingdom: Founded in 2002, Certkingdom provides computer-based “Total Experience” training that gives individuals the tools and confidence to tackle real-world challenges, pass their certification exam and succeed in today’s competitive global IT market.

Certkingdom offers a wide range of computer training packages covering Microsoft, Cisco, CompTIA, VMware, and Microsoft Office. In addition to its Windows Server 2008, Exchange Server 2010, and SQL Server 2008 courses, Certkingdom offers training for over fifty different training courses including: VMware vSphere training, Cisco CCNA training, Windows 7 training, and more.

A privately-held company, Certkingdom is based in Schaumburg, IL. For more information about Certkingdom, please visit

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at


4 Varying Kinds Of Mobile Computer Gadgets

by IT Trainer ·

Varying types of portable computer gadgets include the following: smartphones, laptop computers, netbook computers, and tablet PCs.

Technology has provided us with an array of choices in mobile computer gadgets. These devices may have computer operations that are similar to each other, but they also have numerous other aspects that make each one unique. If you are planning to get yourself one of these gadgets, read this article to find out more about each kind so that you can figure out which is perfect for you.

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at


A smartphone is a combination of a personal organizer and a cellular phone. It is a small device that looks a lot more like a PDA than an ordinary cellular phone, but it has a complex systems program to enable its “smart” functions. Moreover, it also provides simplicity of use to its owners. The user interface of smartphones is also better than regular cellular phones, with larger screens and QWERTY keyboards. There are also many programs and work productivity applications that can be used on these devices, such as mailers, organizers, spreadsheets, text editors, and web browsers, among many others. Additionally, these gadgets boast 1 or 2 cameras and allow users take and view photos or videos in several file formats. In contrast to ordinary cellphones, smartphones can be connected in numerous ways, like through Wi-Fi, 3G, and also WiMax. Even a LAN network is easily done with these devices. If you have to send files from or to your smartphone, you can either do it through USB cables or its Bluetooth feature.

Laptop computers

Also known to manufacturers as notebook computers, a laptop is a pc that can be brought around to such places as libraries, airplanes, meetings and temporary offices. This is because, as opposed to desktop computers, laptops are normally smaller than a briefcase and can be powered both by battery or AC. They also generally weigh less than 5 pounds and have a thickness of three inches or less. This device, though, is more costly than a desktop computer with the same features because of the complexity involved in trying to fit all the same properties into a much more compact device. But what also make them more useful desktop computers is that they can be utilized either as a laptop or desktop computer.

Netbook computers

Netbook computers are new versions of laptop computers that are defined by their size, price and a couple of other properties. These new computers are small, inexpensive, with low horsepower, and run on an operating system that is either old or unfamiliar. The dimension of the monitors range from 9-10 inches, and they have a keyboard that is somewhat similar to that of laptops. They also weigh only about 2 to 3 pounds. This kind of computer is very handy, indeed. Yet, one certain attribute that this gadget doesn’t have is the optical drive of laptop computers. CD and DVD drives have been taken out from this types of device to allow for its small size and weight.

Tablet PC

A tablet PC is yet another type of computer that you can bring anywhere with you. With its wireless network card, you can conveniently connect to the Internet to check your email, chat with friends, update your social network status, or look for ipad support. What makes this device unique, though, is that it doesn’t fold or have a keyboard like that of a laptop. This device is just a single tablet that you work either by making use of a stylus or the tips of your fingers.

Because these gadgets are available in various prices and with different features, it is essential that you ascertain your needs first and then find the device that is closest to the price you can afford, as well as offers the most valuable functions for you. Be well informed before making a decision


Intel ponders solar-powered CPU tech in graphics, memory

by IT Trainer ·

Intel’s experimental solar-powered processor may have started off as a fun project, but the chip maker is now looking to extend the technology to hardware such as graphics processors, memory and floating point units.

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at

Intel last year showed the low-power processor — charged only by the light from a reading lamp — running Windows and Linux PCs. Intel is expected to share further details about the processor, which is code-named Claremont, at the International Solid-State Circuits Conference in San Francisco next week.

The CPU, which is the size of a postage stamp, is also known as the near-threshold voltage (NTV) CPU for its ability to keep operating at extremely low voltage levels. The CPU’s power consumption could go down to as little as 280 millivolts when running at 3MHz, and up to 1.2 volts when running at around 1Ghz when more performance is needed.

The NTV CPU is designed to bring extreme energy efficiency to computing devices, said Justin Rattner, Intel’s chief technology officer, in a briefing ahead of the show.

“It’s allowing us to make Intel’s product more [power efficient] across the compute continuum” while reaching appropriate performance levels, Rattner said.

The CPU can remain at near-threshold voltage levels when not operational, which could keep laptops operational without killing battery life. That is much better than putting a PC into sleep or hibernation mode to save battery.

In an on-stage demonstration at last year’s Intel Developer Forum, an engineer demonstrated a PC running a small animation when powered by the CPU. After the light source was blocked from the chip, the computer froze. The CPU worked with concept DDR3 memory developed by Micron called Hybrid Memory Cube, which is seven times more power-efficient than current DDR3 memory.

“It was not our intention to build a solar-powered microprocessor,” Rattner joked, reminiscing about the experiment.

But the demonstration was an interesting way to show what the company was trying to achieve with NTV technology. The energy gains are about five to 10 times with NTV, Rattner said.

“The design has generated an extraordinary amount of interest,” Rattner said.

The next goal is to extend the technology to other key components inside a computer.

“We are continuing to expand the use of these low-voltage techniques … to graphics and memory,” Rattner said. The technology can also be deeply embedded inside circuitry to bring more power efficiency to supercomputing.

The solar-powered CPU is based on a Pentium chip design, and the researchers converted the logic circuit to operate at near-threshold voltage. The CPU was made using the 32-nanometer processor, which is the same used to make Intel’s latest smartphone chip code-named Medfield. That chip will be appear in smartphones and tablets later this year.

Intel is sharing details about the chip layout and design methodology at ISSCC, which is being held from Feb. 19 to Feb. 23. The chip maker is also presenting separate papers that cover memory, graphics processors and floating-point units based on near-threshold voltage technology.

The research around the solar-powered CPU is being carried out in Intel’s research labs. The chip maker has said it does not expect the solar-powered CPU to go commercial, but that elements from the research would be implemented in future Intel products.


Microsoft’s Windows Azure Active Directory plans takes shape

by IT Trainer ·

This year should be a big one for Microsoft’s Windows Azure Active Directory cloud service, yet another piece of its hybrid public/private cloud puzzle.


MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at

In the coming months, Windows users and partners are going to be hearing a lot more about Windows Azure Active Directory, the “conceptual equivalent” of Microsoft’s Active Directory directory service in Windows Server.

I only recently learned about the Windows Azure Active Directory — or WAAD (ugh!) — name via a December post I found on Dominik’s Cloud Security Blog). But the Softies have been dropping hints about plans to step up rights and management policies using Active Directory on the cloud side of the house, too, since last November.

Sessions about WAAD are on the docket for Microsoft’s upcoming TechEd conferences in June. Before that, Microsoft is planning to make some WAAD-related capabilities available to its Windows Azure cloud customers, according to a Microsoft cloud roadmap I saw earlier this year.

Microsoft is expected to tout the synergies of on-premises Active Directory and WAAD across several fronts, according to that roadmap document. Users will be able to maintain secure access to their apps in the cloud using their existing Active Directory set-ups. They’ll be able to migrate apps that depend on Active Directory to the Azure cloud “without making any changes.”

Office 365 enterprise users already can use their on-premises Active Directory to implement single sign-on. As it currently stands, “the administrator, and your users will need to maintain separate user names and passwords for your online and on-premises accounts,” and requires both Active Directory Federation Services (ADFS) 2.0 and the Active Directory sync service. Based on the aforementioned cloud roadmap, it sounds like Microsoft may be adding more Active Directory single sign-on capabilities and features to Office 365 some time this spring.

A Microsoft Web page on WAAD calls WAAD a multi-tenant cloud service. From that page:

“Windows Azure Active Directory is a cloud service that provides identity and access capabilities for applications on Windows Azure and Microsoft Office 365. Windows Azure Active Directory is the multi-tenant cloud service on which Microsoft Office 365 relies on for its identity infrastructure.

“Windows Azure Active Directory utilizes the enterprise-grade quality and proven capabilities of Active Directory, so you can bring your applications to the cloud easily. You can enable single sign-on, security enhanced applications, and simple interoperability with existing Active Directory deployments using Access Control Service (ACS), a feature of Windows Azure Active Directory.”

Microsoft announced last year the availability of ACS 2.0, which added new federation capabilities for Web sites and services. The latest update to the Azure Service Bus includes built-in support for ACS 2.0.

Update: I’m not entirely sure if WAAD is just a new name/new positioning for ACS or if it actually is something more. I’ll try asking Microsoft to see if I can get clarity. If so, I’ll update this post.

In other Microsoft cloud news, Microsoft announced plans to drop SQL Azure pricing (again) this week, effective immediately. The reduced pricing is aimed at customers with databases bigger than 1 GB in size who need to scale. Microsoft also added a new 100 MB database plan to its SQL Azure line-up this week.


Oracle buying Taleo for $1.9B in direct hit at SAP

by IT Trainer ·

Oracle is buying cloud-based talent management and employee recruitment software vendor Taleo for roughly $1.9 billion, the company announced Thursday. The move comes shortly after SAP’s move to acquire SuccessFactors, a close competitor of Taleo, for $3.4 billion in a deal that has yet to close.

MCTS Certification, MCITP Certification

Microsoft Oracle Exam Training , Oracle Certification and over 2000+
Exams with Life Time Access Membership at

“Human capital management has become a strategic initiative for organizations,” said Thomas Kurian , executive vice president, Oracle Development, in a statement. “Taleo’s industry leading talent management cloud is an important addition to the Oracle Public Cloud.”

The Taleo deal is expected to close in the middle of this year and is subject to shareholder approval, Oracle said. Taleo’s board has unanimously approved the sale.

Taleo’s applications focus on talent management, which includes areas such as recruitment, learning and development, and compensation and succession planning.

It remains to be seen exactly how Taleo’s product portfolio will be aligned with Oracle’s Fusion HCM (human capital management) software, which is also available as a cloud offering, and has some overlapping functionality.

Together, the companies “expect to create a comprehensive cloud offering for organizations to manage their Human Resource operations and employee careers,” Kurian said in a letter to customers. The resulting products will “empower employees and managers to effectively manage careers throughout their entire employment, enable organizations to retain talent and optimize costs, and improve the employee experience through faster on boarding and better collaboration with team members via social media,” he added.

Some 5,000 enterprises use Taleo’s software, which also handles 15 percent of employee hires in the U.S., according to an Oracle document. About half of the world’s top career websites run Taleo as well, Oracle said.

SAP has characterized the pending SuccessFactors purchase as something that will give the company needed “cloud DNA” and expertise in that market.

Oracle’s announcement of the Taleo deal included no similar sentiments, but Taleo is its second major acquisition, along with customer-service vendor RightNow, of a cloud application vendor in the past six months.

Since SAP announced the SuccessFactors deal, speculation had run rampant that Oracle would make a move in response, with Taleo bandied about as a possible acquisition target. has also begun a push into human-resources software with its recent acquisition of Rypple, which focuses on employee performance management.

Unlike other software categories, the types of products sold by SuccessFactors, Taleo and Rypple have relevance to every employee in a company, allowing for more profitable large-scale SaaS (software as a service) deals.

There will likely be additional acquisitions in the HCM arena soon, said HR software analyst Naomi Bloom, managing partner of the consulting firm Bloom & Wallace. “I think we can expect that the boards of Cornerstone, of Ultimate Software, they are undoubtedly having conversations at least among themselves if not potential acquirers.”

Oracle’s move doesn’t have “much to do with a technology buy,” Bloom added. Instead, as with the acquisition of ERP (enterprise resource planning) vendor PeopleSoft, Oracle is looking to take out a competitor and gain a revenue stream, she said.

Taleo also has been running a SaaS business and has a lot of knowledge that will be beneficial to Oracle, Bloom said. While Oracle has long sold an on-demand CRM (customer relationship management) application, that experience isn’t as relevant since unlike human resources, CRM isn’t subject to government regulations and it impacts far fewer employees in an organization, she said.

Meanwhile, “if you are a Taleo customer, or God forbid are in the process [of becoming one], this should put ice water in your veins,” Bloom said. “I have great regard for Oracle, they are an amazing financial machine. But if I’m a customer, I might look at it differently.”

Oracle’s announcement stated that it is currently reviewing Taleo’s product road map, and that “any resulting features and timing of release of such features” are at Oracle’s “sole discretion.”

But Oracle has invested heavily in its Fusion Middleware and Fusion Applications as a next-generation software platform. Therefore, Taleo customers could expect some incremental improvements in the software over time, Bloom said. However, “if I entered into business with Taleo because I felt they were going to be a continuous innovation machine, that’s not going to happen,” she added.

The SuccessFactors and Taleo deals also could reflect growing concern on the part of both SAP and Oracle over the rise of Workday, which has landed large deals for its own cloud-based HCM software, Bloom said.

“I think Oracle was drawn in to having to do this deal,” said Forrester Research analyst Paul Hamerman.

“I don’t know why they didn’t make this deal five years ago,” he added. Oracle would have paid much less and would have primarily gained recruitment software, Hamerman said. But today, Taleo has built out the “four pillars” of talent management, namely recruitment, employee job performance, compensation and learning, he said.

While Oracle has had great success selling core HR applications for payroll, benefits and other areas, it hasn’t had much luck with talent management, Hamerman said.

The overlap with Fusion HCM is not that significant, since it currently lacks recruitment, learning and succession planning capabilities, all areas where Taleo is strong, according to Hamerman. “It’s actually a pretty complementary fit.”


Microsoft 70-447 – Q & A / Study Guide

by admin ·

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at



You work as DBA at 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

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.

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

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.

You are a database administrator for 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.

You are a database administrator for 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

Answer: B,C

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.

You are a database administrator for 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?

B. SELECT * FROM sys.dm_db_index_physical_stats
C. SELECT * FROM sys.indexes

Answer: B

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.

You work as DBA at 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

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.

You are a database administrator for 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

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.

You are a database administrator for 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

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

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
Functions (except inline table-valued functions), Stored Procedures, and DML Triggers
{ EXEC | EXECUTE } AS { CALLER | SELF | OWNER | ‘user_name’ }

You are a database administrator for 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
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

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.

You are a database administrator for 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

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


Adobe’s potential enterprise worries trump Flash concerns

by IT Trainer ·

Adobe’s Flash sucked up all the headlines this week, but concerns about enterprise sales may be more troubling for the company.

For Adobe it’s open season on Flash again as this week Microsoft said that its Metro browser will be plug-in free, but concerns about enterprise demand may be far more troublesome for the company’s financial picture.

MCTS Certification, MCITP Certification

Microsoft MCTS Certification, MCITP Certification and over 2000+
Exams with Life Time Access Membership at

The fact that Adobe’s Flash is under fire isn’t exactly news given Apple ditched Adobe’s Web software years ago. Fortunately for Adobe, Flash has no impact on its profit picture. Adobe sells developer tools and back-end software not Flash specifically. Adobe’s Flash week went like this:

CNET: Microsoft joins anti-Flash crowd with IE10
CNET: Adobe: Flash will flourish despite Windows 8
Microsoft: Metro style browsing and plug-in free HTML
Calm down, Windows 8 DOES support Flash

The anti-Flash talk garners the headlines, but is irrelevant to Adobe on the financial front. That’s why a downgrade from JMP Securities analyst Patrick Walravens is notable.

Walravens summed up the situation in a research note:

While we believe there are some key things that could go right for the company over the next 2-3 years, near term we have grown incrementally concerned about the success of the company’s enterprise business and about their ability to retain key management and sales personnel. We also believe the lack of economic growth in the U.S. and other countries may have caused certain customers to delay their technology purchases from Adobe in F3Q, particularly in certain verticals.

Specifically, Walravens said that adoption of Adobe’s customer experience management (CEM) software is becoming an issue. CEM is one of Adobe’s growth pillars. The problem: Enterprise customers don’t understand Adobe’s CEM software.

Meanwhile, Adobe is likely to take a hit from slowing enterprise demand overall, said Walravens. Toss in Drupal, an open source content management system, and there are long-term concerns about Adobe.

Walravens is also worried about turnover in Adobe’s executive suite. Rob Tarkoff, head of Adobe’s digital enterprise solutions unit, recently left to be CEO of Lithium Technologies.

Amid all the hubbub over Adobe’s Flash this week, Walravens’ concern about enterprise sales—if they pan out—are far more material than what Microsoft ultimately thinks of Flash.