Microsoft 70-454 Q & A / Study Guide

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

---

QUESTION 1
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to develop database strategies.
You are in the process of developing a strategy that has three tables named Certkingdom1, Certkingdom2, and
Certkingdom3. The Certkingdom1 and Certkingdom2 have the integer and varchar data type column types configured
respectively. Certkingdom3 has both the integer and varchar data types configured as column types.
You have configured rowlevel compression on Certkingdom1, and page-level compression on Certkingdom2 and Certkingdom3.
Which of the following describes the reason for this configuration?

A. It allows for the reduction of disk space usage, while modifying the data types in the tables of the database
B. It allows for the reduction of disk space usage without modifying the data types in the tables of the database
C. It allows for the increase of disk space usage, while modifying the data types in the tables of the database
D. It allows for the increase of disk space usage, while modifying the data types in the tables of the database

Answer: B

Explanation:

---

QUESTION 2
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a database strategy that includes a table which hosts
data imported from an outside source. This data includes a field named TransactionTime that
should be configured to make use of hh:mm:ss[.n] format.
You have been informed that the data type selected for the TransactionTime field must allow for
storage to be kept to a minimum.
You, therefore, make use of the time(1) data type.
Which of the following is TRUE with regards to the time data type?

A. The default fractional precision is 7 (100ns).
B. The default fractional precision is 3 (100ns).
C. The time produced by the time data type is not time zone aware and is based on a 24-hour clock.
D. The time produced by the time data type is time zone aware and is based on a 12-hour clock.

Answer: A,D

Explanation:

---

QUESTION 3
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that has two tables named CertkingdomVendor and
CertkingdomItem. You have configured a foreign key constraint between the CertkingdomVendor and CertkingdomItem
tables on the CertkingdomVendorID column.
You have configured the CertkingdomVendor table to display a 0 value for the CertkingdomVendorID when a
vendor is removed. You also want make sure that the CertkingdomVendorID value in the CertkingdomItem table is
set to 0 when a vendor is removed.
You then create a default constraint on the CertkingdomVendorID column in the CertkingdomItem table, which is
used to set the value to 0.
Which of the following actions should you take NEXT?

A. You should consider setting the ON DELETE property of the foreign key constraint to Null.
B. You should consider setting the ON DELETE property of the foreign key constraint to Default.
C. You should consider setting the ON DELETE property of the foreign key constraint to Cascade.
D. You should consider setting the ON DELETE property of the foreign key constraint to No Action.

Answer: B

Explanation:

---

QUESTION 4
You are employed as a database developer at Certkingdom.com. You make use of a SQL Server 2008
instance to develop database strategies.
You are in the process of designing a database strategy that makes use of the Integration
Services and Microsoft Sync Framework SQL Server components.
Which of the following is TRUE with regards to the use of these components?

A. Microsoft Sync Framework allows for collaboration and offline access for applications, services, and devices.
B. Microsoft Sync Framework prevents collaboration and offline access for applications, services, and devices.
C. Integration Services allows for the merging of data from Heterogeneous Data Stores.
D. Integration Services prevents the merging of data from Heterogeneous Data Stores.

Answer: A,C

Explanation:

---

QUESTION 5
You are employed as a database developer at Certkingdom.com. You make use of SQL Server 2008 to
develop database strategies.
You have received instructions to design a strategy that helps Certkingdom.com’s administration manager.
You have created three entities named User, UserTask, and UserAssignment. You have
configured the User entity to make use of the UserID attribute, the UserTask entity to make use of
the UserTaskID attribute, and the UserAssignment entity to make use of the UserAssignmentID attribute.
You have been informed that the strategy must allow for users to be assigned multiple tasks. You
also need to ensure that a task is deleted when it has been completed, and that the assignment
linked to that task is also deleted. Furthermore, a NULL value has to replace the user reference to
the user assignment as soon as a user becomes unavailable to finish a task.
Which combination of the following actions should you take? (Choose all that apply.)

A. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserAssignment entity.
B. You should consider configuring Foreign Key constraints on the UserTaskID and UserID
attributes in the UserTask and User entities respectively.
C. You should consider referencing the UserTask and User entities respectively.
D. You should consider referencing the UserAssignment and User entities respectively.
E. You should consider specifying the On Delete property as NULL.
F. You should consider specifying the On Delete property as Default.

Answer: A,C,E

Explanation:

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

So Cometh Windows 8!

With the unveiling of Windows 8 Transitional Computing Inc. finds itself reminiscing about Microsoft's previous OS releases and musing about how this next release will affect IT professionals and the businesses we support.

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

Microsoft began its journey into market dominance of the PC world in 1985 with its release of Windows 1.0; an interface management system that would eventually be followed by several iterations of the OS and become an integral part of how we do business today. Though Microsoft is clearly a market leader for its operating systems support of business applications, they have on occasion released operating systems that have been a source of frustration for IT professionals and the businesses we support.

This is no more prevalent than in Microsoft's release of Windows Vista. Though the OS was touted to have many improvements over its predecessor Windows XP (mostly in the arena of security features) it was plagued with performance issues. Benchmarks tests showed that Vista executed applications more slowly than Windows XP with the same hardware configuration. Further issues such as software bloat, software compatibility, poor power management on laptops, and the price to upgrade from XP to Vista all combined to make Vista an impractical solution for business owners and IT professionals alike. This had the unfortunate result of leaving business owners two generations of OS behind.


When Microsoft released Windows 7 in July of 2009 nearly 3 years after the release of Vista most business owners still found themselves running on an XP platform. Windows 7 was met with mostly positive acclaim. It easily out performed its predecessor Vista in the areas of usability and functionality with most reviewers saying Windows 7 is what Vista should have been.

In the eyes of IT professionals and business owners upgrading to Windows 7 however still had its drawbacks. With the general impression consumers and corporations had that Windows Vista was a stumble along the OS road, most consumers were reluctant to upgrade to what some considered a dressed up Vista. Upgrade fees were rather steep even for users upgrading from Vista to 7. Upgrades were available for users still running on an XP platform but only in the form of license upgrades.

What did this all mean for business owners?

Well, the small percentage running Vista could install Windows 7 over top their existing OS with no need to back up their applications and data or fear that their Vista applications would not be compatible with Windows 7. On the other foot XP users found that they had to perform "clean installs" and actually do all of the above listed things Vista users were not required to. From the perspective of Business owners this made the prospect of upgrading from XP to Windows 7 a daunting task. Even with the positive acclaim Windows 7 had received most did not see any meaningful advantage to upgrading.


As of April 2011, nearly 2 years after its release, Windows 7 has finally overtaken XP in the US market share. The "what" and the "why" of how Windows 7 finally replaced it's twice removed predecessor can be attributed to several factors. One notable reason was Microsoft's release of XP Mode for Windows 7 Professional and Ultimate. Initially available in Oct. 2009 as an application that launched a virtual XP environment, XP Mode allowed users to run legacy software that did not run natively inside Windows 7. This first iteration of XP Mode required microprocessors with hardware support for virtualization. Ironically the target audience that Microsoft was trying to reach with XP Mode, namely small to mid-sized businesses, now found themselves required to update their hardware in order to upgrade to Windows 7 making the cost prohibitive. Microsoft has since released an update that removes the hardware requirement for XP mode making it available to a wider range of users.

So where we are we at now with Windows 7?

Stable efficient OS - Check
Legacy software support - Check
A market share larger than XP - Check
Compatible with a larger array of hardware specifications - Check

Just when we feeling we are in good a place with Windows 7. So Cometh Windows 8! Well technically that's not true. At recent press conference when Microsoft gave us all our first look at the upcoming Windows OS they did announce that Windows 8 was not projected to be released until late 2012.

As IT professionals however it is our responsibility to keep abreast of these developments and try to predict what impact this will have on our clients.

At first glance Windows 8 looks to be Microsoft's big bid to enter the "post PC era". If you're not familiar with the term "post PC era" well its actual definitions seems to be a subject for open debate, but in reference to Windows 8 "post PC era" seems to refer to the switch over from desktop and laptop computers to the wider use of mobile devices such as tablet computers and smartphones.

The interface for Windows 8 is in fact based in part on the current Windows 7 phone interface. If you've never seen it before don't feel bad. The Windows 7 phone was poorly marketed and made barely a squeak on a mobile device stage that has been recently dominated by Apple and Android based smart phones and tablets.

As one would expect since the new OS is based on Smartphone technology it leans heavily towards touch screen based interactivity. Most of the demos Microsoft has put forth thus far tend to focus on the touch screen features. This is not to say Windows 8 is going to leave mouse and keyboard users out the cold. Though it is designed for the "post-PC era", Windows 8 looks more to us as though it is a bridge between device and dedicated PC users.

With such a drastic shift of focus some of you may be wondering how much consideration Microsoft put into compatibility. Microsoft has assured consumers that Windows 8 is not abandoning the Windows 7 usability model, it is expanding on it. Windows 8 will be able to run current Windows 7 applications on a comfortably familiar Windows Desktop. The Windows 8 Desktop will have expanded control for multi monitor displays allowing deeper customization of the view controls for each screen. What could throw some desktop users for a loop is the Windows 8 start menu, primarily because it is no longer a menu. Windows 8 will feature a customizable "Start Screen", a full screen tiled display that allows you to group apps together and swipe through several tiled groups. While this may be familiar enough for Windows 7 users to get the hang of, those migrating from XP might have a slightly steeper learning curve with this feature.

Can your hardware handle it?

For those who have updated their hardware within the past year the answer is a happy yes. If you are currently running Windows 7 without performance issues Microsoft touts that Windows 8 will run just as well if not better on the same hardware.

What's our verdict?

What we've seen so far leads us to believe Windows 8 is an upgrade that takes into account many of the headaches previous upgrades did not handle as successfully. Microsoft seems to have put the user experience under a microscope while developing their latest OS considering ease of transition and feature improvement. Whether the new features and cost of upgrading will prove to be a practical solution for IT pros and business owners still remains to be seen. We'll be keeping our eye on this product as it approaches its ultimate release, that's for sure.

Home Education within the UK - A Helpful Guide For Other Countries

Education is not thought-about a privilege. In most jurisdictions, 'education' is taken into account as an essential half of a kid's rights.

Best CCIE Training and CCIE Exams and more Cisco exams log in to examkingdom.com

Within the UK, education has always commanded a high priority in the society. The govt., in turn, has continuously adopted a liberal education policy, as highlighted from the laws of the land. That's why the concept of Home Education (HE) has invariably been an integral part of society in the UK.

Why Home Education?

Because of a multicultural and plural society as prevalent within the UK, the reasons for folks to opt for Home Education may vary. A number of the common factors influencing parents' decisions regarding the tutorial desires of their kids include:

- Non secular, philosophical, or religious compulsions

- Unsatisfactory school system

- Lack of suitable schools in the locality

- To meet the precise and/or special desires of some youngsters, like those littered with diseases such as Cerebral Palsy, autism etc.

- Failure of kid and college management to effectively tackle bound conditions in college, like bullying, corporal punishment etc.


- Financial reasons etc.

Recently, the Parental Responsibility has emerged collectively of the major reasons for Home-Educating youngsters in the UK. Additional and additional oldsters are trying to learn the art of true parenthood and are relishing the extra responsibility of being (really) responsible for the growth of the thought method within the child.

Whatever might be the compelling circumstances, Home Education is here to stay, and is being increasingly most well-liked in the UK. An estimated 100,000 kids between the ages of five and 16 are being given Home Education by their folks in the United Kingdom, and the figure is possible to extend in the coming years.

Benefits of Home Education

Home Education (tutorial-based teaching) has several benefits over classroom education (instructions-primarily based teaching). Some of these embody:

1. The child tends to receive individualistic and so much more attention at home than at school.

2. Comfy home environment in the corporate of parents offers the child an ideal environment to learn.


3. The absence of awe-inspiring lecturers suggests that fast feedback from the child to assess his/her learning capabilities.

4. The Kid can learn at their own pace, and follow their own curriculum and interests.

5. Enhanced self-motivation and self-discipline within the child.

6. Instilment of parental values instead of peer values in the child.

7. Cultivation of courage to arrive at freelance decisions.

8. Avoid damaging competition in search of higher grades from the peers and fellow students.

9. Special youngsters need special attention that can only be provided underneath home conditions.

10. Above all, as a parental responsibility of teaching your child, nothing is a lot of beneficial and satisfactory than to take complete responsibility of your kid's education.

Shortcomings of Home Education

One should conjointly consider some disadvantages of Home Education before deciding the academic way forward for the child. Some of these embody:

1. Non-development of social skills thanks to the absence of interaction with peers and teachers.

2. Special experience and skills needed to show may be lacking within the parents. Moreover, they could not be abreast of the most recent technologies and teaching aids that may facilitate the child learn better.

3. Even each the parents combined could not know all the themes needed for the right education of the child.

4. Oldsters might ultimately pay a substantial quantity of time equipping themselves with the abilities to show their kid; thus, losing out on the chance to supplement the family income.

5. Laboratories, gyms, and different facilities provided by school authorities could not be accessible from home.

6. A child's progress will not be adequately monitored, especially as they are doing not must follow the National Curriculum or take SATs.

Home Education in UK - Legal Side

The UK is divided into totally different legal jurisdictions. As an example, there are totally different sets of laws applicable in England and Wales, Scotland, and Northern Ireland. However, substantially, of these jurisdictions follow similar legal principles and postulates, with minor variations.

Home Education has legal sanction in all 3 regions within the UK. Section 7 of the Education Act 1996 (England and Wales), Sections thirty of Education (Scotland) Act 1980, and Article forty five of Education and Libraries (Northern Ireland) Order 1986, are the relevant legal provisions that provide the requisite teeth to the concept of Home Education in the UK.

Here is that the outline of these legalities as applicable within the UK:

Solely 'education' is compulsory under UK laws and not 'schooling.'

No qualification is prescribed for the fogeys desirous of giving Home Education to their child.

Parents are at absolute liberty to determine how they need their kid to be educated at home.

No compulsion of following the National Curriculum or observing faculty hours.

Folks should ensure that their kid receives an efficient full time education, suitable to his/her age, ability and aptitude, and to any special instructional needs the child might have.

Oldsters are not legally obligated to tell the Local Education Authority (LEA) after they decide to educate their youngsters at home. If the kid has never been registered at a State faculty, or if you progress to an area served by another LEA, you're not obliged to notify the LEA, though you'll do so if you wish. If you're taking your kid out of a state college in England or Wales, the head teacher should remove the kid's name from the register and inform the LEA. If your kid has special desires and attends a special school, you need permission to deregister.

However, if you are withdrawing your child from a State school in Scotland, the LEA should be informed.

No special Government grants are available for Home Education in UK.

No formal tests are required to pass by the child. However, the LEA might ask for data informally at intervals to observe your child's progress.

There is no prohibition on the Home Education of a statemented kid provided he/she is not attending a special school, in that case you need the consent of the LEA.

Home-Educated kids will take GCSEs as non-public candidates or as students of correspondence courses. But, it's not compulsory to require GCSEs.

To handle the concern for social deprivation of Home-Educated youngsters, in many areas, home educators meet frequently for social, educational, and alternative activities. Kids conjointly attend clubs, classes, sporting and leisure activities in the community. Youngsters get to interact with people of all ages as well as their peers.

Jillian Cook has been writing articles online for nearly 2 years now. Not only does this author specialize in Special Education, you can also check out his latest website about:
Polaroid Camera Film Which reviews and lists the best
Polaroid 500 Film