Posts Tagged ‘MCSE’


70-696 Administering System Center Configuration Manager and Intune

by admin ·

70-696 Administering System Center Configuration Manager and Intune

Published: January 23, 2015
Languages: English
Audiences: IT professionals
Technology Windows 8.1, Windows Server 2012 R2, Microsoft Intune
Credit toward certification: MCP, MCSE

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft
Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

Deploy and manage virtual applications (14%)
Prepare virtual applications
Sequence applications, install and configure the sequencer environment, prepare applications for deployment in different environments, configure virtual application interaction and sharing
Manage application virtualization environments
Configure App-V, manage application cache, configure System Tray/SFTTray.exe switches, configure application extensions with virtualized applications, configure application settings using group policies
Deploy and manage RemoteApp
Configure RemoteApp and Desktop Connections settings, configure Group Policy Objects (GPOs) for signed packages, subscribe to the RemoteApp and Desktop Connections feeds, export and import RemoteApp configurations, support iOS and Android, configure Remote Desktop web access for RemoteApp distribution

Deploy and manage desktop and mobile applications (15%)
Plan an application distribution strategy
Considerations, including impact on clients due to offline access, deployment infrastructure, and remote locations; choose the appropriate application distribution method; plan to distribute applications to mobile devices, including Windows Phone, Windows RT, iOS, and Android, by using Microsoft Intune; plan to distribute applications to desktops
Deploy applications using Microsoft System Center 2012 Configuration Manager
Choose and configure deployment types, configure user device affinity, configure requirements, manage the software library and application catalog
Deploy applications using Microsoft Intune
Choose between automatic and manual deployment, configure application deployment policies, add software packages, configure the company portal
Plan for application upgrades
Considerations, including application version co-existence, compatibility issues, and migrating application settings and configurations; re-sequence/redeploy applications
Monitor applications
Monitor offline application usage; monitor real-time sessions; monitor application licensing usage; configure Asset Intelligence in Configuration Manager; monitor applications, using Software Center
Manage content distribution
Manage distribution points, distribution point groups, and Content Library; monitor log files

Plan and implement software updates (16%)
Plan and deploy third-party updates
Plan for third-party support, integrate System Center Updates Publisher with Configuration Manager
Deploy software updates by using Configuration Manager and Windows Server Update Services (WSUS)
Configure software update point synchronization to Windows Update, use reports and In Console Monitoring to identify required updates, create update groups, create and monitor deployments, analyze log files, configure Automatic Deployment Rules (ADR), provide secondary access to Windows Update, configure GPO settings
Deploy software updates by using Microsoft Intune
Use reports and In Console Monitoring to identify required updates, approve or decline updates, configure automatic approval settings, configure deadlines for update installations, deploy third-party updates

Manage compliance and Endpoint Protection settings (15%)
Build a Configuration Item (CI)
Create a CI, import a CI, set CI versioning, remediate rules
Create and monitor a baseline
Deploy a baseline, import a configuration pack, build a custom baseline
Configure Endpoint Protection
Create and manage the Endpoint Protection policy; configure definitions within the client policy; export policies; choose which template to use; select exclusions; configure Endpoint Protection, using Microsoft Intune; use In Console Monitoring to monitor client compliance

Manage Configuration Manager clients (15%)
Deploy and manage the client agent
Identify deployment methods, manage client agent settings
Manage collections
Plan the collection structure; define rules for collections; customize collection-specific settings, including maintenance windows and power management
Configure and monitor client status
Configure client status settings, use In Console Monitoring to determine client health, configure alert thresholds, configure client health auto-remediation

Manage inventory using Configuration Manager (12%)

Manage hardware and software inventory
Extend hardware inventory WMI classes, export and import WMI class settings, configure standardized vendor names, analyze the identified inventory and generate reports
Manage software metering
Create software metering rules, enable or disable auto-generated rules, report software metering results
Create reports
Clone and modify reports, create custom reports, import and export reports, manage asset intelligence, install the asset intelligence sync point, enable the WMI classes, modify categories and labels, analyze reports

Provision and manage mobile devices (12%)
Integrate Configuration Manager with the Exchange ActiveSync Connector
Configure and apply ActiveSync policies, view inventory on mobile devices, configure connection to an on-premises or Hosted Exchange server environment, monitor the Exchange connector log file
Manage devices with Microsoft Intune
Provision user accounts, enroll devices, integrate Microsoft Intune with Configuration Manager, view and manage all managed devices, configure the Microsoft Intune subscriptions, configure the Microsoft Intune connector site system role
Manage connection profiles, by using Configuration Manager
Configure Remote Desktop profiles, certificate profiles, email profiles, and Wi-Fi profiles

Click here to view complete Q&A of 70-696 exam

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft 70-696 Training at



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


Cloud Specific IT Certifications 2013

by admin ·

Few areas within the IT industry have seen the kind of growth that cloud computing has. As a result, many IT professionals are now seeking cloud specific certifications. Here is an overview of what is currently available to help you figure out which certification may be best for you.

2013 is here and as we look back at 2012, few areas within the IT industry have seen the kind of growth that cloud computing has experienced.

If your company is locked into a specific cloud service vendor then choosing which IT certification to get may be simple. However, because cloud computing comes in many flavors and is still in its infancy, deciding which cloud certification to get is difficult for many IT professionals.

To help you figure out what vendor offerings are out there and where to begin, has put together a list of currently available cloud certifications. This list isn’t all-inclusive, simply because the cloud computing market is in a state of transformation. Please add any certification we may have missed to the comments section.

CompTIA Cloud Essentials
The CompTIA Cloud Essentials specialty certification demonstrates that an individual knows what cloud computing means from a business and technical perspective, as well as what is involved in moving to and governing the cloud.

The CompTIA Cloud Essentials exam covers:
Characteristics of cloud services from a business perspective
Business value of cloud computing
Technical perspective/cloud types
Steps to successful adoption
Impact and changes on IT service management
Risks and consequences

The Cloud Essentials exam objectives were originally developed by ITpreneurs in cooperation with the Cloud Credential Council, a membership body dedicated to vendor-neutral training in cloud computing and comprised of companies including IBM, Cisco, EMC, HP and ING.

While it is not required, CompTIA recommends that a candidate have at least six months working in an environment that markets or relies on IT-related services

Get Certified with The #1 Certification Program in the information storage and management industry.

EMC Proven Professional Certification »

Invest in Yourself – Our program offers a
role-based series of courses and exams that
cover the full range of EMC’s hardware,
software, and solutions.

Information Storage and Management v2 – Not sure where to start? Our Industry leading ‘open’ information storage course that covers all segments of technologies from network storage to data security and virtualization. Associate Level (E10-001)

EXIN Cloud Computing Foundation
The exam focuses to a limited extent upon Cloud technology. The main focus of the programme is the procurement, implementation and management of Cloud Computing, hence the slogan ‘Get into the Cloud – and stay in control’.

EXIN Cloud Computing Foundation is part of the Certified Integrator program and is one of the prerequisites to attain the title:

EXIN Certified Integrator Secure Cloud Services.

Target group
The exam is suitable for IT managers, business managers, IT professionals and procurement specialists, who want to qualify for a role within the rapidly growing field of Cloud Computing. For organizations and trainers, EXIN Cloud Computing serves as independent certification of their own course or training.

Cloud Computing ties in well with other EXIN examination programmes, such as IT Service Management and Information Security.
EXIN Cloud Computing Foundation was created in close collaboration with industry and trade organizations.

HP ExpertOne
HP ATA – Cloud V1
Click to Chat With an Online Representative
For students pursuing HP ATA certification

This certification training provides you with the skills and knowledge to understand a customer’s business objectives and support end-to-end IT solution design and deployment, including on premises, hosted, and cloud solutions for small- to medium-size businesses.

To prepare for this certification, you will learn industry-standard cloud and virtualization technologies. You will also learn how to support disaster recovery plans, install, configure, and upgrade servers, storage, data, networks, clients, applications, and users in new and existing environments. Achieving this certification validates your ability to optimize, troubleshoot, and administer cloud solutions.
Why earn this certification?

As a student you have access to HP training developed in an academic format. You will gain higher job and earning potential through an industry-recognized certification and a high-quality education that provides practical experience with HP and industry-standard technologies.

The HP Accredited Technical Associate (ATA) certification is for individuals interested in pursuing careers in technology and lays the foundation for success.

HP ASE – Cloud Architect v1
Click to Chat With an Online Representative

This certification verifies that you have the ability to specify and architect a spectrum of cloud services based on a converged infrastructure. These include private, public and hybrid cloud environments, and IaaS, PaaS and SaaS platforms. The Cloud Architect training provides you with the ability to navigate through the HP CloudSystem solution offerings and identify, describe, position and specify the right solution based on identified needs. The training also provides an understanding at the level of purpose, function, positioning, and capabilities of HP CloudSystem offerings. The available training will also help you learn the technical consulting skills needed for planning and designing complete cloud solutions.
Why earn this certification?

Businesses are moving rapidly to take advantage of the cloud to speed innovation, accelerate business processes, and reduce time-to-revenue. However, enterprises and service providers seeking to build cloud environments are confronted with fragmented solutions, leading to complexity, security issues, and management costs that organizations are trying to avoid. You can increase your business and professional value by validating your unique breadth of knowledge to plan and design a complete, integrated and open solution based on HP CloudSystem built on a converged infrastructure. You validate The Cloud Architect V1 training and certification provides the skills needed to effectively plan and design the right cloud solutions based for both business and IT needs.

IBM Certified Solution Advisor – Cloud Computing Architecture V2
An IBM Certified Solution Advisor – Cloud Computing Architecture V2 is a person who can clearly explain the benefits and underlying concepts of cloud computing. They can also demonstrate how the IBM Cloud Computing offering helps customers realize these benefits.

Key areas of competency include:
Explain the cloud computing concepts.
Describe how the customer can realize the benefits of cloud computing within their environment.
Identify cloud computing architecture and design principles.
Map customer-s requirements to the IBM Cloud Computing offerings.

Required Prerequisite Skills:
The following qualifications are requirements for success:

Working knowledge of Cloud Computing principles
Working knowledge of implementation of Cloud Computing concepts
Working knowledge of the various types of clouds
Working knowledge of the various types of -as a service- offerings
Working knowledge of various Cloud Computing business models
Working knowledge of key concerns and how they are addressed in Cloud Computing such as security,

Microsoft MCSE – Private Cloud certification

Private Cloud certification
Solutions Expert The globally recognized standard for IT professionals

Prove your expertise in managing and implementing Microsoft private cloud computing technologies. With Windows Server and System Center, you will build your Microsoft private cloud solution to optimize IT service delivery and gain the automation and flexibility you need for your IT infrastructure, now and in the future.
Installing and Configuring Windows Server 2012
Administering Windows Server 2012
Configuring Advanced Windows Server 2012 Services
Monitoring and Operating a Private Cloud with System Center 2012
Configuring and Deploying a Private Cloud with System Center 2012
If you’re already certified as a Microsoft Certified IT Professional (MCITP): Enterprise Administrator or MCITP: Server Administrator, you only need to complete steps 4 and 5 above to earn your Private Cloud certification.
This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.


Oracle Exalogic Elastic Cloud X2-2 Certified Implementation Specialist certification

Exalogic Elastic Cloud X2-2 Essentials

New! Register for OPN Exchange and take this exam for FREE at Oracle OpenWorld 2012.

The Exalogic Elastic Cloud X2-2 Essentials exam is intended for system administrators who have implemented and are managing an Exalogic Elastic Cloud environment in a data center. The exam targets a broad range of topics from fundamentals and initial machine setup to storage and network configuration. In addition to on-the-job training, preparation can include attending Oracle University’s Oracle Exalogic Elastic Cloud Administration course.

The Oracle Exalogic Elastic Cloud Implementation Specialist certification recognizes OPN members as OPN Certified Specialists. This certification differentiates OPN members in the marketplace by providing a competitive edge through proven expertise.




MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP 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


What to expect at TechEd North America 2012

by admin ·

As anyone who’s been to TechEd will attest, the event is not a sprint; it’s a marathon. With hundreds of technical sessions, workshops, labs and vendors, the annual Microsoft event doesn’t lack quantity. But what’s actually worth paying attention to?

Thanks to the timing of the event, the published agenda and the tarot cards found lying around the TechTarget office, we have a few informed guesses regarding what attendees can expect to hear a lot about, and where Microsoft wants the industry conversation to go. Here are the top topics we’ll be watching:

Windows Server 2012
With the recent name change from Windows Server 8, there’s a renewed anticipation for Microsoft’s upcoming server OS – and heightened expectations for all the things the company claims it can do. Server and Tools Business president Satya Nadella will be one of the featured keynote speakers at the show, and he’ll likely hammer on all of the many documented improvements within Server 2012, from enhancements to Hyper-V and PowerShell to the new Resilient File System. There are also 72 technical sessions in the Windows Server track, which should sate folks eager to play with the Release Candidate, available now.
MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at
Windows 8
It’s no secret that Microsoft is betting big on Windows 8, its “reimagined,” “fast and fluid” new client operating system. With the next iteration – dubbed the Release Preview – now available, you can bet it’ll be a major point of emphasis for many speakers, if not for the IT pros who remain skeptical of how the touch-centric interface will translate to the enterprise. The agenda includes technical sessions on Windows 8 deployment, Metro-style app delivery, Windows To Go and more. Developers will have plenty to chew on as well: Visual Studio corporate vice president Jason Zander will be speaking during Monday’s keynote session, and Antoine LeBlond, corporate vice president for Windows Web Services (with a focus on the Windows Store) takes the stage on Tuesday.

Sure, IT pros have been able to take certification exams at TechEd every year. But this year adds some intrigue, given the recent changes to Microsoft’s program, including the return of the MCSE and a focus on the cloud. Many are wondering what the changes mean for them, whether they should get recertified and what the value of these things are, anyway. If there is any place to get answers, it’s here.

Device (or user) management
It’s pretty difficult to avoid the topic of consumerization and BYOD programs at any conference these days, and for good reason: Any organization that isn’t dealing with it now will soon need to or risk being beaten over the head by iPad-wielding employees. One of the main ways that Microsoft is addressing the new reality is through improved device management. The revamped Windows Intune, which will purportedly give IT the ability to manage and deliver applications to iOS and Android devices in addition to Windows devices, will be featured in demos and discussions throughout the week (as will System Center Configuration Manager 2012). Expect to hear about Microsoft’s “user-centric” management model a lot, and get explanations as to why Windows RT tablets don’t need to join Active Directory domains.

The word “cloud” at a Microsoft conference usually means Azure. The public cloud platform will definitely be a major coverage area at TechEd, given both the timing – there was a recent branding brouhaha, and the company is scheduled to make a significant Azure announcement on June 7 – and the speaker slate (which includes sessions from Azure executives Scott Guthrie and Mark Russinovich, and purportedly something on the new Windows Azure Active Directory). But don’t discount Microsoft’s private cloud push, which includes System Center 2012 and Hyper-V.

System Center 2012
Though Microsoft’s updated systems management suite got plenty of time in the spotlight during the Management Summit in April, IT pros are looking to learn more about how to better monitor and respond to increasingly complex environments. Many of the suite’s most significant products, including Virtual Machine Manager, Operations Manager and Orchestrator, will get dedicated technical sessions, and should be touted as ways to tie together many of the topics mentioned above.

We’ve heard very little about how things are going with Office 365, Microsoft’s answer to Google Apps, and maybe that’s for a reason. But the roadmap should become a little clearer during TechEd, as there are several sessions scheduled that cover the cloud-based productivity suite in depth, including its tie-ins to the Sharepoint collaboration platform (and we may get more details on the new government-specific version). Though there’s nothing listed, we might also hear something about Office 15, which will reportedly be delivered to Windows devices before anything else.

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-442 Q & A / Study Guide

by admin ·

MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at

You work as a contract developer for National Retailers. You are currently working
on the online order application the National Retailers database developer has
informed you that the product parts and components will be stored in a xml data
type column. National Retailers employees are allowed to request product
information regarding a doll or action figure line by clicking a button on the Web
form. The data will only be retrieved if the employee requests details.
You need to design the appropriate data access technologies and must thus choose
the object that you need to use to store the query results for product parts and
component information.
What should you do?

A. Make use of a DataSet object.

B. Make use of an XmlElement object.

C. Make use of an XmlDocument object.

D. Make use of an XmlDocumentFragment object.

Answer: D

Explanation: An XmlDocumentFragment object can store either a well-formed
XML document or a fragment of a document. This would be consistent with the xml
data type which has the ability to store well-formed documents as well as fragments.
1. The National Retailers management wants to expand business by selling their
exclusive doll line on the company Web site
Incorrect Answers:
A: A DataSet object is used when the method returned a relational data set, akin to the
method that is generated from a SELECT statement.
B: An XmlElement object is used to store the results of a SELECT … FOR XML query,
not the contents of a single value.
C: An XmlDocument object must store well-formed XML Documents. It is thus not
compatible with the xml data type.

You work as the database developer for National Retailers. You need to optimize
the indexing strategies and are thus designing the indexes for the Sales.Orders table.
The query in the following exhibit is frequently executed, though it is not the most
commonly executed query.
SELECT Salesrepresentative, SUM(Commission)
FROM Sales.Orders
WHERE Date BETWEEN @ startDate AND @ endDate
GROUP BY Salesrepresentative
ORDER BY Salesrepresentative
You need to use the appropriate statement to create the best index to accommodate
this query.
What should you do?

A. Use the following statement:
CREATE INDEX ix_Commission
ON Sales.Orders(Salesrepresentative, Date, Commission)

B. Use the following statement:
ON Sales.Orders(Salesrepresentative, Date)

C. Use the following statement:
CREATE INDEX ix_Commission
ON Sales.Orders(Date)
INCLUDE (Salesrepresentative);

D. Use the following statement:
CREATE INDEX ix_Commission
ON Sales.Orders(Date, Salesrepresentative)
INCLUDE (Commission);

Answer: D

Explanation: The Date column is used to select the records and the
Salesrepresentative column is used to group and order the records. This means that
both these columns have to be key columns. The Date column is used in a
BETWEEN comparison, thus it should also be the first in the query. Furthermore,
it has higher selectivity than the Salesrepresentative column.
1. Sales Representatives should also be allowed to check the current commissions due to them.
Incorrect Answers:
A: The column used for equality or BETWEEN comparisons should be listed first. This
must then be followed by the most selective column, then the rest of the predicate
columns in order of decreasing selectivity. And, although it is possible that you can
create an index by using a computed column as the key column, it is recommended that
key columns be kept as narrow as possible. This means that making use of an included
column for Commission is a better option.
B: A Clustered index should have high selectivity. The Salesrepresentative column does
not have high selectivity. This means that this clustered index will not be appropriate for
any other queries done against the table like retrieving order information for instance. A
table can only have one unique index.
C: The Salesrepresentative column is used in the GROUP BY clause. Thus it would be
better suited as the key column rather than an included column. Furthermore, this is not a
covering index as it does not include Commission as an included column.

You work as the database developer for National Retailers. While busy designing
queries for the retrieval of data from XML sources, you are writing a script that
will generate an XML file to be imported into the collections application. This
application assumed XML data includes both elements and attributes.
You need to make a choice of the most appropriate type of Transact-SQL statement
to use to retrieve the data from the database.
What should you do?

A. Make use of the OPENXML Transact-SQL statement.

B. Make use of the sp_xml_preparedocument stored procedure.

C. Make use of the SELECT … FOR XML AUTO Transact-SQL statement.

D. Make use of the SELECT … FOR XML PATH Transact-SQL statement.

Answer: D

Explanation: The FOR XML PATH clause of the SELECT
statement will allow you to use XPath to define the structure for the XML data that
is returned. This structure can include both elements and attributes.
1. The Chicago office handles debt collection. All customers with an outstanding balance
over 60 days are also sent to the Chicago office. The accounting department makes use of
a collections application that imports XML data.
Incorrect Answers:
A: The OPENXML statement is used to insert XML data into relational tables. Not to
retrieve a resultant set formatted as XML from relational tables.
B: The sp_xml_preparedocument system stored procedure is used prior to calling OPENXML.
C: The FOR XML AUTO clause of the SELECT statement will generate a result set of
nested elements and as such do not make allowance for a mix of elements and attributes.

You are busy designing the database query strategy for National Retailers that will
retrieve the result set used to report on monthly sales trends. To this end you are
designing the stored procedure. This stored procedure will be used by an
application that makes use of Microsoft Visual C# .NET.
Of the requirements that you need to keep in mind is that the analysts need the
ability to retrieve a result set with approximately 100 records and scroll through
them to gather information. These analysts will need the ability to locate records
based on either factory or product I
D. They do NOT update any data. You thus
need to design the most appropriate cursor strategy for National Retailers.
What should you do?

A. Create a server-side static cursor.

B. Create a server-side dynamic cursor.

C. Create a client-side forward-only cursor.

D. Use a default result set and do not create a cursor.

Answer: D

Explanation: The Default Result Set caches all records in the result set to the client.
This will thus reduce round trips across the network to one and prevent data from
being stored in the tempdb.
1. Regularly at the end of each month, reports are generated manually and e-mailed to the
Chicago office. Monthly sales and invoice aging information is included in these reports.
Incorrect Answers:
A: If you create a Server-side static cursor it will consume server resources and require a
round-trip across the network each time the client fetches data. Furthermore the cursor
will then be stored in tempdb.
B: A Server-side dynamic cursor does require a round-trip across the network every time
a client fetches data.
C: Creating a Client-side forward-only cursor will not allow analysts to scroll through
the data the way that they require to. These cursors only support the ability to fetch the
next record and not to move to a specific record.

You work as the database developer for National Retailers. You are currently
designing the code that will retrieve the product information for the online order
application. To this end you need to determine the appropriate type of object that
you should create to return to the Web application. The Web application will
require that information such as product name, product description, and product
price information be returned in response to a search request.
What should you do?

A. Use a Transact-SQL stored procedure.

B. Use an extended stored procedure.

C. Use a table-valued user-defined function.

D. Use a Common Language Runtime (CLR) user-defined function.

Answer: A

Explanation: The online application accesses data via a Native XML Web service.
This means that you are limited to using an object that can be exposed as a Web
method. A Transact-SQL stored procedure can return the required information and
can be exposed as a Web method.
1. The National Retailers management wants to expand business by selling their
exclusive doll line on the company Web site.
2. The future online Sales application will be outsourced. NRCH-DB02 will host a
database to support the e-commerce application. The e-commerce application will make
use of Simple Object Access Protocol (SOAP) to retrieve product information and submit
Incorrect Answers:
B: An Extended stored procedure cannot be exposed as a Web method.
C: A Table-valued user-defined function cannot be exposed as a Web method.
D: A CLR user-defined function is not required because the data can be retrieved using

You are designing the error-handling routines for National Retailers. You are
creating a function that will be used to check the audit trail for the products. This
function must raise a custom error in the event of the audit trail not being
verifiable. Do bear in mind that the code to check the audit trail requires a query
and a cursor.
What should you do?

A. Use the following error-handing method:
— Perform query and open the cursor
— Run code that iterates through the cursor and checks the audit trail

B. Use the following error-handing method:
— Perform query and open the cursor
— Run code that iterates through the cursor and checks the audit trail
RAISERROR (@myCustomError, 15)

C. Use the following error-handing method:
–Perform query and open the cursor
–Fetch the first row
WHILE /*not the last row*/
IF /*Code that checks the audit trail*/
–Fetch the next row
SET @@ERROR = @myCustomError

D. Use the following error-handing method:
–Perform query and open the cursor
–Fetch the first row
WHILE /*not the last row*/
IF /*Code that checks the audit trail*/
— Fetch the next row
RAISERROR (@myCustomError, 15)

Answer: D

Explanation: You need to pass the error message back to the application via an IF
ELSE statement to check the values in a row, then calling RAISERROR in the event
of the values being invalid. The RAISERROR function will allow you to send an
error message up the calling chain.
1. Industry regulations require an audit trail for all components and parts that go into a
doll or action figure. The audit trail must be able to use the UPC number on the package
to trace all the components and parts, who supplied the components and parts, and what
date the components and parts were shipped. Components and parts information must be
entered at the time the product line is created and cannot be altered after the quality
inspection. Attempts to modify components and parts information after the inspection
time must be logged.
2. Only product lines with an intact audit trail can be shipped. If an audit trail is not
available, the product line must be destroyed. The product line application includes a
verification routine that checks a specific product line’s audit trail. The application makes
use of structured error handling to react to a product line that must be destroyed.
Incorrect Answers:
A: The requirements will not be met if you use @@ERROR after iterating through the
cursor. The @@ERROR global variable contains the error number generated by the last
statement. Thus if will only include an error number if the last statement to process the
cursor is responsible for the error.
B: Using a TRY … CATCH block within a function is not possible.
C: @@ERROR is a global variable that is automatically set by SQL Server every time a
statement executes. Thus you cannot set @@ERROR.

You are designing the error-handling routines for the National Retailers Web
application. In the event of a customer failing to enter valid payment information,
you need to send a custom error to the calling application. Furthermore, this error
message has to be localized to the user’s language. The Web application will pass the
language when it opens a connection to the database server. You thus need to decide
which would be the most appropriate way to support error messages in multiple
What should you do?

A. A CASE statement should be added to the CATCH block.
Then call RAISERROR with a different error message for each language.

B. A different error number should be used for each language version.
Then a CASE statement should be added to the trigger and call RAISERROR with
the language-specific error.

C. Add a message for each language using sp_addmessage.
A different error number should be used for each language version.
Raise the error in the @@ERROR global variable.

D. Add a message for each language using sp_addmessage.
The same error number should be used for each language version.
Call RAISERROR from the trigger.

Answer: D

Explanation: The same error numbers should be used when adding an error
message for each language. This will allow SQL Server to match the session
language to the error message language when you call RAISERROR. The
sp_addmessage stored procedure is used to add an error message.
1. The National Retailers management wants to expand business by selling their
exclusive doll line on the company Web site.
2. The future online Sales application will be outsourced. NRCH-DB02 will host a
database to support the e-commerce application. The e-commerce application will make
use of Simple Object Access Protocol (SOAP) to retrieve product information and submit
Incorrect Answers:
A: A CASE statement should not be added to the CATCH block and then call
RAISERROR with a different error message for each language. This will make
maintenance quite difficult since you will then be required to modify the code that calls
RAISERROR if a message changes or you need to add a language.
B: There is no need to use a different error number for each different language version
and then add a CASE statement to the trigger. This option will work, though it will be
difficult to maintain since the trigger will then have to be modified each time a language
is added. It will also require more programming effort instead of allowing SQL Server to
choose the right language for the error message.
C: If you raise the error in @@ERROR, then the error associated with the last statement
will be raised and not the custom error message. Also, there is no need to define a
different error number for each language version.

You are designing the error-handling routines for National Retailers. You thus need
to design the code that will validate the audit trail for a product batch.
Users that do not enjoy membership of the sysadmin role will run the
fn_ValidateBatch function. You need to use the appropriate statements to ensure
that in the event of an invalid audit trail, an error is raised to the calling application
and an event is written to the application log.
What should you do?

A. Use the following statements:
sp_addmessage (@msgnum=50888, @severity=15, @msgtext=”Batch” + @b “cannot be
RAISERROR(50888, @batchnum, WITH LOG)

B. Use the following statements:
sp_addmessage (@msgnum=50888, @severity=16, @msgtext=”Batch %b cannot be
RAISERROR (50888, WITH SETERR, @batchnum)

C. Use the following statements:
sp_addmessage (@msgnum=50888, @severity=16, @msgtext=”Batch %b cannot be
RAISERROR (50888, %batchnum)

D. Use the following statements:
sp_addmessage (@msgnum=50888, @severity=16, @msgtext=”Batch %b cannot be
RAISERROR(50888, @batchnum, WITH LOG)

E. Use the following statements:
sp_addmessage (@msgnum=50888, @severity=21, @msgtext=”Batch %b cannot be
RAISERROR(50888, @batchnum, WITH LOG)

Answer: D

Explanation: By specifying the 16 severity level, you ensure that the users who do
not belong to the sysadmin role have the ability to raise the error. Also this option
displays the correct syntax for using arguments in a message text string. By default,
only messages with a severity level of over 19 are logged to the application log. This
can be overridden by specifying WITH LOG when calling RAISERROR.
1. Industry regulations require an audit trail for all components and parts that go into a
doll or action figure. The audit trail must be able to use the UPC number on the package
to trace all the components and parts, who supplied the components and parts, and what
date the components and parts were shipped. Components and parts information must be
entered at the time the product line is created and cannot be altered after the quality
inspection. Attempts to modify components and parts information after the inspection
time must be logged.
Incorrect Answers:
A: This option would be correct except for the severity level of 15. By default, only
messages with a severity level of over 19 are logged to the application log. This option
does not offer any overriding probabilities to have the error logged to the application log.
B: This option is only partly correct. But you should not raise the error by specifying
SETERR. This will result in @ERROR and ERROR_NUMBER to be set to 50000. You
do not make use of a concatenated string to use an argument in the message text.
C: The RAISERROR (50888, $batchnum) is the incorrect syntax. A local variable starts
with an @ and not a %. Also this option will not cause the application to be logged to the
application log.
E: You should not specify a severity of 21. Messages with this severity level can only be
raised by members of the sysadminrole.

You work as the database developer for National Retailers. You are currently
designing the indexes that will be used for the OnlineSales.Customers table. The
following exhibit illustrates the most common query that will be used.
SELECT FirstName, LastName, Address, City, State, Zip
FROM OnlineSales.Customers
WHERE CustomerID = @emailAddress
You thus need to select the best statement that should be used to create this index
that will accommodate this query.
What should you do?

A. Use the following statement:
CREATE INDEX ix_custInfo
ON OnlineSales.Customer(CustomerID)
INCLUDE (FirstName, LastName, Address, City, State, Zip);

B. Use the following statement:
CREATE INDEX ix_custInfo
ON OnlineSales.Customer(LastName, FirstName)
INCLUDE Address, City, State, Zip;

C. Use the following statement:
ON OnlineSales.Customer(CustomerID, FirstName, LastName, Address, City, State,

D. Use the following statement:
ON OnlineSales.Customer(CustomerID)
INCLUDE (LastName, Address, FirstName, City, Zip, State);

Answer: A

Explanation: Making use of this statement will create an index with a small unique
key that covers the entire query. For optimal performance a small key size that
includes the columns used in the
WHERE clause and other predicates or in joins are recommended. In this scenario
the only required key column would be the CustomerID column. Then you can
include the rest of the columns as non-key columns. This means that you need to
create the index as a non-clustered index because non-key included columns are not
supported for clustered indexes.
1. The National Retailers management wants to expand business by selling their
exclusive doll line on the company Web site.
Incorrect Answers:
B: This index would not be used for the query because the CustomerID column is not
listed as a key column.
C: This statement, if created will result in an index with 344 bytes in the key column.
Though it is possible, it is not optimal since it is better to create an index with a smaller
key column and included columns.
D: This is incorrect because you cannot make use of included columns in a clustered

National Retailers require a database that will support the e-commerce application.
You need to find a way to provide the e-commerce application with information
about the existing inventory. The database must determine the nearest factory that
has the product ordered in stock and send the order to that specific factory to have
it fulfilled.
You thus need to determine how the inventory information should be made
available to the e-commerce application while providing the best possible
performance when placing the order.
What should you do?

A. Query the database server at each factory using OPENROWSET from a stored
procedure run on NRCH-DB02.

B. At each factory implement an HTTP endpoint on the database server and expose a
Web method that checks inventory.

C. Replicate the data from the database servers at the different factories to the
NRCH-DB02 server using merge replication.

D. Use a linked server for the database server at each factory at NRCH-DB02.

Answer: C

Explanation: Using merge replication to replicate all data from the factories to
NRCH-DB02 will make the data available locally and improve query performance when
an order is placed. This is the best type of replication to use in this case because there
could be conflicts by orders placed over the Web and order places by the Sales
representatives at each factory. Also in a case where the different sites/factories are not
well-connected making use of merge replication makes sense. And in this case the
factories are connected to the Chicago office by demand-dial links.
1. The National Retailers management wants to expand business by selling their
exclusive doll line on the company Web site.
2. The future online Sales application will be outsourced. NRCH-DB02 will host a
database to support the e-commerce application. The e-commerce application will make
use of Simple Object Access Protocol (SOAP) to retrieve product information and submit
Incorrect Answers:
A: Making use of OPENROWSET to query each database server at each factory from a
stored procedure on NRCH-DB02 will result in one or more remote queries to be sent
across the network for each product ordered.
B: Making use of an HTTP endpoint will result in more overhead than is required. There
is already a demand-dial connection between the Chicago office and the different
factories. Thus there is no firewall that restricts incoming protocol to only HTTP. Making
use of a SOAP request will result in even more overhead than a remote query.
D: Making use of a linked server for the database server at each factory and performing a
remote query is not the best solution because each product that is ordered will cause at
least one, and possible more, remote queries to be sent across the network.


MCTS Training, MCITP Trainnig

Best Microsoft MCTS Certification, Microsoft MCITP Training at