Tag Archives: mcitp certification

70-542 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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


QUESTION 1
There is a web site CertKingdomWS.
CertKingdomWS uses MS Office SharePoint Server 2007 Search Center.
CertKingdomWS runs a fixed keyword query.
If the result of this query is a fail to return any data.
How can this be achieved?

Answer:


QUESTION 2
There is a MS Office SharePoint Server 2007 application CertKingdomApp.
CertKingdomApp uses two tables Employees and EmployeesDetails.
They are related through a one-to many relation.
Two entities Employees and EmployeesDetails are defined in a BDC definition.
The metadata of this definition need to be defined.
Which code is appropriate?

Answer:


QUESTION 3
There is a MS Office SharePoint Server 2007 web site CertKingdomWS.
There is a MS Office SharePoint Server 2007 application CertKingdomApp.
There is a security group named DOMAIN\Employees.
In CertKingdomWS there is content that this group should have access to.
How can this be ensured? Select two.

A. Add a custom Web Part…
B. Add an audience…
C. Add a site group…
D. Use a filter…
E. ..based on the DOMAIN\Employees group.
F. ..that has the DOMAIN\Employees group as a member.
G. …that shows only the members of the DOMAIN\Employees group.

Answer: B,E

Explanation:


QUESTION 4
There is a MS Office SharePoint Server 2007 web site CertKingdomWS.
There is a MS Office SharePoint Server 2007 application CertKingdomApp.
There is a MS Excel 2007 workbook which contain employee data such as name, city, salary.
End users must be able to filter the workbook on city.
How can this be achieved through MS Office SharePoint Server 2007 Excel services? Select two.

A. Add an Excel VBA application…
B. Add an ActiveX control…
C. Use the Data-Filter option…
D. …in the workbook.
E. ..in CertKingdomApp.
F. ..in CertKingdomWS.

Answer: C,D

Explanation:


QUESTION 5
There is a MS SQL Server 2005 database CertKingdomDB.
There is a BDC definition which is used to search for employee data in CertKingdomDB.
Incremental crawls must be performed for indexing in CertKingdomDB.
How can this be ensured? Select two or three.

A. Add method
B. Add function..
C. Add stored procedure…
D. ..Finder
E. ..GenericInvoker
F. .. IDEnumerator
G. .. ViewAccessors
H. ..to have a return field representing the last update time of CertKingdomDB.
I. .. to return a different set of columns from the CertKingdomDB.

Answer: A,F,H

Explanation:


QUESTION 6
Exhibit:
public class CertKingdomClass
{
public double CertKingdom1 (double d)
{
return d * 9; }
public DateTime CertKingdom2 {
return ( DateTime.Today );
}
}
There are two UDFs CertKingdom1 and CertKingdom2.
These are defined as Excel Services in MS Office SharePoint Server 2007.
The code is displayed in the exhibit.
What action should you take?

Answer:


QUESTION 7
There is a ASP.NET web site CertKingdomWS.
There is a MS Office SharePoint Server 2007 application CertKingdomApp.
There is a Microsoft Office InfoPath form CertKingdomForm.
There is a custom control CertKingdomC that is derived from the XMLFormView class.
CertKingdomC will show CertKingdomForm inside an ASP.NET page on CertKingdomWS.
How can this be ensured?

Answer:


QUESTION 8
There is a web site CertKingdomWS.
There is a portal site template CertKingdomTempl.
CertKingdomTempl is used within CertKingdom Ltd. To recreate site hierarchies,
Extra sites must be added to the hierarchy.
What steps should be taken?
Your company uses a portal site template to recreate site hierarchies. You need to add additional
sites to the hierarchy that is defined in the portal site template. What should you do?

A. Modify file Webtemp*.xml…
B. Modify file webconfig…
C. Modify file global.aspx…
D. Modify the XML definition file..
E. Modify CertKingdomTempl…
F. Modify CertKingdomWS…
G. ..by adding a Template element that contains the site definitions for the new sites.
H. ..by adding extra Web elements to the XML definition file of the portal site template.
I. .. to include the new hierarchy and create a new site template on the Site Settings page.

Answer: D,H

Explanation:


 

MCTS Training, MCITP Trainnig

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

70-519 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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


QUESTION 1
There is ASP NET 3.5 Web application CertKingdomApp.
You are required to upgrade CertKingdomApp to ASP.NET 4.0.
You need to make sure that CertKingdomApp is optimized for search engines.
In particular this optimization must include HTML that is generated by CertKingdomApp and URLs
local within CertKingdomApp.
Within CertKingdomApp there is a Data List control CertKingdomC.
CertKingdomApp must be able to load data at runtime into CertKingdomC with the help of the current
URL.
What is appropriate in this scenario? Select four.

A. Use property Repeat Layout of..
B. Use property Data List Layout of..
C. Use property Render Outer table Layout of..
D. ..Web Forms routing and set the property to…
E. .. permanent redirect and set the property to..
F. .. temporary redirect and set the property to..
G. ..Null..
H. ..True..
I. ..False..
J. ..Table..
K. ..List..
L. .. on all list controls.
M. ..on all controls.
N. .. all Form View controls.

Answer: B,D,I,N

Explanation:


QUESTION 2
There a ASP.NET MVC 2 application CertKingdomApp.
Consider unhandled exceptions.
CertKingdomApp must manage and log these unhandled exceptions.
What would be best to achieve this if you want to put the logic into a single place?

A. Use a custom Handle Error attribute to…
B. Use the default Handle Error attribute to…
C. For every method..
D. For each controller..
E. .. override the Exception method.
F. .. override the OneException method.
G. .. and apply it to all controllers.
H. ..use try and catch.

Answer: A,G

Explanation:


QUESTION 3
There is an ASP.NET Web application CertKingdomApp.
CertKingdomApp has pages that are available for public users.
CertKingdomApp has pages that are available for only administrative purposes.
Consider error handling code for these pages.
The same code must be used for the public pages and the administrative pages.
Errors must be handled in one way for the public pages and in another way for the administrative
pages.
How can this be achieved? Select two.

A. Use file Global.asax.cs (or Global.asax.vb)
B. Use file code-behind.
C. Use the Page_Error method(s).
D. ..for every public page and for every administrative page.
E. ..of the subclasses of System.Web.UI.Page.
F. ..of the subclasses of System.Web.URL.Page.
G. ..use the Application_error method.
H. .. for each master page.

Answer: C,E

Explanation:


QUESTION 4
CertKingdom has multiple ASP.NET Web applications.
There is a class library CertKingdomLib that are used by all these application.
There is a variable CertKingdomVar in CertKingdomLib.
CertKingdomVar is within the helper class.
CertKingdomVar contains secret information.
CertKingdomVar must not be seen by developers debugging applications.
How can this be achieved?

Answer:


QUESTION 5
There is an ASP.NET Web application CertKingdomApp.
CertKingdomApp has a Menu Control CertKingdomMC.
For unauthorized users CertKingdomMC shows a menu of public pages.
For authorized users CertKingdomMC shows a menu of both public pages and some private pages.
For security you need to ensure that the private pages (both the menu options and the URLs) are
not shown to unauthorized user.
What is appropriate in this scenario? Select four.

A. The event handler..
B. The attribute..
C. The method..
D. The exception handler..
E. ..Page_Refresh should be used..
F. ..Page_Load should be used..
G. ..window.onload should be used..
H. ..window.update should be used..
I. ..window.onupdate should be used..
J. ..Page_Init should be used..
K. .. JavaScript document ready should be used..
L. ..VBS (or C# script) document ready should be used..
M. …to add pages to CertKingdomMC that are to be accessed by all users
N. ..to hide the private pages from the list of pages shown on CertKingdomMC.
O. ..to add pages to CertKingdomMC that are to be accessed by authorized users.
P. ..to add pages to CertKingdomMC that are to be accessed by unauthorized users.

Answer: C,F,O

Explanation:

MCTS Training, MCITP Trainnig

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

Bluetooth in Brief

Bluetooth is a radio or wireless technology designed for short range data communications in the Industrial, Scientific and Medical (ISM) band. The frequency range is from 2.402Ghz to 2.480Ghz, with the available frequency sprectrum being broken up into 79 x 1Mhz wide bands.

MCTS Certification, MCITP Certification

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

Bluetooth was designed by Ericsson as a short range wireless connectivity solution and is used to build Personal Area Networks, or PANs as they are known so that devices in close proximity can pass information. Typical examples being a mobile phone downloading data to a Personal Computer or a mobile phone earpiece communicating with the phone itself.
The technology behind Bluetooth is known as FHSS (Frequency Hopped Spread Spectrum), where the datastream is broken up into small pieces, each containing several binary bits of data which are transmitted in a pseudo random sequence over a series of up to 79 frequency bands. As Bluetooth has developed and matured, a number of data modulation schemes have been used to modulate the data onto the radio carriers including GFSK (Gaussian Frequency Shift Keying), DQPSK (Differential Quadrature Phase Shift Keying) and 8DPSK (8-ary Differential Phase Shift Keying). The development and use of the different modulation schemes were an attempt to increase the data rates of the system.
So how does Bluetooth operate?
Two or more Bluetooth devices that establish a connection (and share a channel) form a small wireless network known as a Piconet, with up to eight devices, forming the piconet . One device becomes the Master station, can join a Bluetooth piconet. Normally the device which initiates the connection will be the Master and other devices joining the PAN will be slaves. The master passes a Frequency Hopping Synchronisation (FHS) packet to any slaves containing its address and clock. The address of the Master Bluetooth device is used to determine the hop sequence and all slaves use the Master Clock to determine which frequency to transmit or receive on at any given time.
A group of piconets are referred to as a Scatternet, with each individual piconet having a unique hopping sequence, determined by it’s Master’s address. If a collision occurs where two devices transmit on the same frequency, a device will just retransmit the data on the next frequency hop. Although this can ultimately affect the performance and data rate of the transmission, it is the accepted method, just like collisions are a way of life in a shared Ethernet network when a hub is in use.
Devices can be a member of multiple piconets by using each Master address to determine the hopping sequence for each network, but can only be the Master for one piconet. The access method used by Bluetooth devices is known as TDD (Time-Division Duplex) where each device (Master and Slave) share the same frequency and are allocated a timeslot during which to transmit. A master will normally use even-numbered time slots and the slave will use odd numbered timeslots.
There are two types of transmission links normally supported by Bluetooth, known as SCO (Synchronous Connection-Orientated) and ACL (Asynchronous Connectionless Link). General Bluetooth operation uses ACL, where the packet and payload length will determine how many timeslots are required. Because ACL is Connection-Orientated, packets that are not acknowledged will be automatically retransmitted, abeit on a different timeslot or timeslots. Forward error correction can be employed as an option and although the data delivery may be more reliable, the data rate will reduce accordingly depending on how error prone the environment is at the time.
Voice over Bluetooth normally used an SCO link, where the voice data is sent over a number of reserved timeslots within an already established ACL link. Retransmissions do not occur on an SCO link as this could cause a number of problems, least of all latency and jitter. However, forward error correction can be used to provide a degree of reliability. There is an Enhanced version of SCO that can employ retransmission in some circumstances.
The latest version of Bluetooth, version 4 and all previous versions of Bluetooth have been designed to be backward compatible with previous versions, so no worry about using older devices with the newer Bluetooth devices.
The Bluetooth technologies have allowed us to provide fast data communications between devices that are in close proximity (within a few metres) without the need for a cable running RS-232 protocol for example and so have provided us with mobility free from the constraints imposed with the use of copper wiring.

Cloud platform supports product development activities

OneDesk collects feedback and ideas from internal sources and social media; a new API allows it to integrate with apps from NetSuite, Oracle, SAP and Salesforce.com.

MCTS Certification, MCITP Certification

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

When you talk about the sorts of internal collaboration activities that companies of any size need to support, those related to product development should be right up near the top of the list.

That’s why your organization might want to take a peek at a platform called OneDesk, a cloud-based application that is explicitly intended too coordinate product managers, engineers, marketing teams and even customer support professionals.

I spoke a few weeks back with Catherine Constantinides, one of the OneDesk team members, a few weeks back about how the platform might be used and the sorts of features that are included.

She describes it as a place for companies to declare and manage all the “needs requirements” associated with a given product or product development project.

Internally speaking, there are places to share ideas for the next releases, which can bubble up from anywhere. As some of these ideas are embraced for future features, the team can track the progress as well as any challenges or objections that might occurs along the way.

From an external perspective, OneDesk can be used to monitor and gather feedback about a product that is emerging in social media or social networks.

Ultimately, the main benefit is that all feedback — whether it is internal or external — can be gathered and searched from one location. “You can see all of the requirements, feedback and tasks associated with a particular product release,” Constantinides said. Then again, you can turn off any particular module that isn’t relevant to your organization.

There are two flavors of OneDesk, one that is free, which supports up to 30 people within a company (which is great if you are small small business) and that comes with up to 100 megabytes of data storage. OneDesk Pro will cost your organization $30 per user, per month. That essentially pays for the much larger storage capacity each users gets, up to 1 gigabyte per person.

For midsize businesses that need to worry about such things, OneDesk just released an application programming interface (API) that enables its application to be integrated with enterprise resource planning and CRM applications including Oracle, SAP, Salesforce.com and NetSuite (they aren’t the only applications supported, but are among the most relevant, of course).

RIM’s new CEO wants to focus more on consumers

RIM’s new CEO, Thorsten Heins, wants the company to improve its product development while also becoming better at marketing, he said during a conference call on Monday.

MCTS Certification, MCITP Certification

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

Heins is taking over from Mike Lazaridis and Jim Balsillie, who had co-CEO roles and will remain with the company.

“I pledge to do everything possible to exceed the expectations of all of the company’s shareholders,” said Heins.

RIM’s decision to pick its new CEO from within the company makes it clear that it won’t budge from current strategy, which is based on its acquisition of the QNX operating system, according to Geoff Blaber, analyst at CCS Insight. QNX is already used on its PlayBook tablet, and will also be used on its smartphones with the arrival of BlackBerry 10, Blaber said.

“Eighteen months ago Mike and Jim took a bold step when we had to make a major decision around our future platform, and they purchased QNX to shepherd the transformation of the BlackBerry platform for the next decade,” Heins said. “Right now, with PlayBook 2.0 coming out in February, we are more confidant than ever that this was the right path to go.”

At first, Heins will focus on improving the company’s marketing efforts, which include hiring a new chief marketing officer as soon as possible, and the way it develops products.

“We need to be more marketing driven, and we need to be more consumer-oriented because that is where a lot of our growth is coming from,” said Heins.

RIM will also change how it develops products. The company has been innovating while developing the products, and that needs to stop, Heins said.

Innovation will take place with much more emphasis on prototyping, and RIM has great teams that can try new ideas out, he said.

“But when we say a product is defined … execution has to be really, really precise, with no churn in existing development programs,” said Heins.

Heins didn’t address rumors about RIM being acquired, but emphasized that its current model is the way forward.

“I will not in any way split this up or separate it into different businesses,” said Heins, adding that while he will listen to anyone who wants to license BlackBerry 10, it is not his main focus.

Picking a new CEO from within was the right decision, according to analysts.

“Heins has been the COO for some time. He has been at RIM for over four years now, and he has been leading the current product transition,” said Blaber. “It will be about delivering on the strategy they have already embarked on.”

Pete Cunningham, analyst at market research company Canalys agreed: “RIM has been stagnating and needed an injection of fresh leadership.”

Bringing someone in from the outside would have been riskier, according to Cunningham.

The big challenge now is to get BlackBerry 10 smartphones to market as soon as possible. In December, RIM said it would not start selling phones with the software platform until the “later part” of 2012, because it wanted to wait for the arrival of more advanced chipsets.

“It is hard to see that a change of leadership at the company can accelerate that schedule terribly much,” said Cunningham.

Products based on the BlackBerry 10 platform were expected to arrive earlier, and the delay has hurt RIM, according to Blaber.

“The reality is that creating a new platform, albeit be it on a pre-existing operating system in QNX, was always going to take some time,” said Blaber, who thinks that the development of the PlayBook distracted RIM’s engineering department to the detriment of new smartphones.

Another of Heins’ main challenges will also be to help RIM regain some of former glory in the U.S. The company watched its market share drop from 24 percent in the third quarter of 2010 to just 9 percent in the same period last year, according to Canalys.

However, the picture for RIM in other parts of the world is more positive. The Middle East and Africa and Southeast Asia were particular bright spots during the third quarter, Canalys said.

“There are a number of markets where BlackBerries are still selling really well, but the problem RIM has that everyone is focused on the U.S. market, and that is where is has taken a real beating,” said Cunningham.

It is likely to get worse before its gets better for RIM. Just like vendors such as Sony Ericsson, Motorola Mobility and HTC RIM struggled during the fourth quarter.

RIM has its BlackBerry World conference coming up at the beginning of May. That will be one of the first opportunities for Heins to present his vision for the company, and bring back some excitement.

“But that will not be an easy job,” said Cunningham.

70-545 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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:

MCTS Training, MCITP Trainnig

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

Oracle calls school’s revised lawsuit over software project a ‘transparent ploy’

Oracle is asking a judge to throw out some of the claims made in a lawsuit filed against the vendor by Montclair State University over an allegedly failed ERP (enterprise-resource-planning) software project, according to a filing made this week in U.S. District Court for the District of New Jersey.

MCTS Certification, MCITP Certification

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

MSU sued Oracle in May 2011, blaming the vendor for a series of problems and delays on the PeopleSoft project, which was supposed to replace 25-year-old legacy applications. The parties had signed a US$15.75 million contract for software and implementation services in 2009.

The New Jersey school ended up firing Oracle and has said completing the project will cost up to $20 million more than the original budget. Oracle has countersued, seeking money it says MSU owes it and blaming school officials for the project’s woes.

In December, the school filed an amended complaint that added new allegations, including that Oracle had conducted a “rigged” demonstration of the software package at issue.

Oracle’s motion this week responds to that filing, asking that its allegations of fraudulent inducement, gross negligent misrepresentation, grossly negligent performance of contractual obligations and willful anticipatory repudiation of contract be dismissed.

The school’s initial complaint “was premised on the alleged breach of the Consulting Agreement between Oracle and MSU,” Oracle wrote in its filing this week. “Now, recognizing that there was no breach by Oracle and that the contract contains valid and enforceable limitations of liability, MSU has conjured up claims which completely contradict the allegations it filed initially.”

This amounts to a “transparent ploy” that “fails as a matter of law because, try as it may, MSU cannot avoid the fully integrated, extensively negotiated contract which covers the exact terms that form the basis of MSU’s new tort claims,” Oracle added.

MSU’s amended complaint includes claims of wrongdoing by Oracle that are “directly contradicted by a number of contractual provisions,” according to the filing.

For example, the school had alleged that Oracle said its base PeopleSoft system for higher education institutions would satisfy 95 percent of MSU’s more than 3,000 business requirements.

But “the Consulting Agreement makes clear, however, that 596 of the 3,071 requirements laid out in Attachment C-1 of the Fixed Price Exhibit were ‘Not in Scope,’ that 60 of the requirements were designated as ‘Undefined,’ and 52 of the requirements were to be met by customization of the base product,” Oracle said. “Thus, the Consulting Agreement provides that roughly 23% of MSU’s requirements were not to be met by the Oracle base product.”

Oracle’s motion also denies MSU’s allegation that the software vendor misrepresented how much MSU staff and resources would be required to finish the project on Oracle’s proposed schedule.

Once again, the parties’ consulting agreement contradicts the allegation since its wording “put the onus on MSU, not Oracle, to assure that MSU had the required personnel and resources,” the filing states.

If the school can provide documentation for all of its allegations in the 60-plus-page amended complaint, “they’re going to be in a real strong position,” but it’s not yet clear how the case will play out, said one IT consultant and expert witness who has testified in several cases involving Oracle software.

For example, the amended complaint included a long list of original project requirements. “Many of them are stated in general enough terms that it’s entirely possible there was a legitimate misunderstanding on the part of Oracle as to what those requirements involved,” said the consultant, who requested anonymity because of current involvement in another case regarding Oracle.

To that end, Oracle’s motion to dismiss cites an “assumption” in the consulting agreement regarding the project requirements.

If the base PeopleSoft product could do “what” a particular requirement called for, but not “how” MSU wanted it addressed, “it is MSU’s responsibility to change MSU’s business process to accommodate how the base product’s business process addresses the requirement,” the motion states.

“It’s entirely possible when you look at what was delivered it will be a judgment call, rather than a clear-cut determination, as to whether what Oracle delivered met those requirements or not,” the consultant said.

MSU plans to oppose Oracle’s motion, according to a spokeswoman, who declined further comment.

Overall, the case presents a cautionary tale for vendors and software customers.

“This is why both sides should document the process,” said analyst Ray Wang, CEO of Constellation Research. “When a project goes down, fingers point everywhere.”

70-451 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as a database developer at Certkingdom.com. You need to plan a SQL Server 2008 database
that will be accessed by mobile users.
The database must be able to profile data before importing it from heterogeneous data sources,
including Microsoft Office Excel, Microsoft SQL Server 2000, Microsoft SQL Server 2005, and
CSV files. In addition, Certkingdom.com’s mobile users must have collaboration and offline capabilities
and they must be able to use heterogeneous data stores.
How should you plan your database if you want your design to use the least amount of
administrative effort?

A. You should make use of the Analysis Services and the Notification Services.
B. You should make use of the SQL Server Agent.
C. You should make use of the Integration Services and the Microsoft Sync Framework.
D. You should make use of the Service Broker and SQL Mail.

Answer: C


QUESTION 2
Certkingdom.com has hired you to design a SQL Server 2008 database for its online retail application. The
database must be able to run both Transact-SQL statements as well as SQL Server Integration
Services (SSIS) packages. Certkingdom.com plans on running scheduled maintenance tasks on the
database and they want the database to send alerts and notifications to the network
administrators.
How should you design this database?

A. You should make use of the Analysis Services and the Notification Services.
B. You should make use of the Reporting Services.
C. You should make use of SQL Server Agent.
D. You should make use of the Service Broker and the Notification Services.

Answer: C


QUESTION 3
Certkingdom.com hires you as their database administrator of their SQL Server 2008 database
infrastructure. You need to optimize a very large database table for query execution against string
data. The database contains several million rows of data. You need to ensure that the queries are
performed in order of proximity and are completed in the least amount of time possible.
How should you configure the database?

A. You should create a partitioned view on the table.
B. You should create a nonclustered index on the table.
C. You should make use of the Analysis Services.
D. You should enable Full-Text-Search.

Answer: D


QUESTION 4
You work as a database developer at Certkingdom.com. You need to design a SQL Server 2008 database
named Sales. The Sales database will have tables named Customers with an identity column
named CustomerID, Products with and identity column named ProductID, SalesReps with an
identity column named RepID, Orders with an identity column named OrderID, and Invoices with
an identity column named InvoiceID.
Sales representatives are assigned to specific customers with each Sales Representative being
assigned to more than one customer.
You need to ensure that the database is normalized and that it represents the relationship
between the Sales Representatives and the customers.
How should you design your database?

A. You should create a foreign key constraint between the SalesReps and Customers tables.
B. You should make use of the hierarchyid data type on the SalesReps table.
C. You should add a SalesRep2Customer table with foreign key constraints to the SalesReps and
Customers tables.
D. You should make use of a table-valued function on the SalesReps table.
E. You should make use of a view based on the SalesReps and Customers tables.

Answer: C

Explanation:


QUESTION 5
Certkingdom.com has hired you as their database administrator of their SQL Server 2008 database
infrastructure. Certkingdom.com has a Sales database that contains tables named Orders, OrderDetails,
and Inventory. The OrderDetails table stores details for Orders table.
You need to ensure that when rows on the Orders table are moved to an archive and deleted from
the Orders table, the related detail in the OrdersDetails table is also deleted.
How would you accomplish this using the least lines of Transact-SQL code as possible?

A. You should create a filtered index on the OrderDetails table.
B. You should create a foreign key relationship between the Orders and OrderDetails tables.
C. You should create a stored procedure that deletes the related data on the OrderDetails table.
D. You should create a trigger on the Orders table that executes the stored procedure.
E. You should set Cascade Delete to False.
F. You should make use of the Service Broker.
G. You should set Cascade Delete to True.

Answer: B,G


MCTS Training, MCITP Trainnig

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

70-450 Q & A / Study Guide

 

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as a database administrator at Certkingdom.com. You are in the process of preparing the
deployment of a new database that will have 45 gigabytes storage space for the transaction log
file, and 280 gigabytes storage space for the database data file.
There are approximately six 120 GB disk drives available for the database in the storage array.
Certkingdom.com contains a RAID controller that supports RAID levels 0, 1, 5 and 10. The disks are on
the RAID controller. You have received an instruction from the CIO to make sure that the
transaction log’s write performance runs at optimum. The CIO has also instructed you to make
sure that in the event of a drive failure, the database and transaction log files are protected.
To achieve this goal, you decide to configure a storage solution.
Which of the following actions should you take?

A. You should consider using a RAID 1 volume as well as a RAID 5 volume in your storage configuration.
B. You should consider using a RAID 1 volume as well as a RAID 10 volume in your storage configuration.
C. You should consider using a RAID 3 volume as well as a RAID 5 volume in your storage configuration.
D. You should consider using a RAID 1 volume as well as a RAID 3 volume in your storage configuration.

Answer: A

Explanation:


QUESTION 2
You work as a database administrator at Certkingdom.com. Certkingdom.com has a database server named ABCDB04
with a SQL Server 2008 instance that includes an extensive mission-critical database that is
constantly being used ABC-DB04 has a quad-core motherboard with four CPUs.
When it is reported that ABC-DB04 often encounters CPU pressure, you receive an instruction
from management to make sure that the accessible CPU cycles are not exhausted by online index rebuilds.
Which of the following actions should you take?

A. You should make use of the affinity I/O mask option.
B. You should make use of the optimize for ad hoc workloads option.
C. You should make use of the affinity mask option.
D. You should make use of the max degree of parallelism option.

Answer: D

Explanation:


QUESTION 3
You work as a database administrator at Certkingdom.com. Certkingdom.com has a database server named ABCDB01
with a SQL Server 2008 instance.
During routine monitoring on ABC-DB01, you discover that the amount of CXPACKET waits
experienced by the instance is low, while the amount of lazy writer waits is abundant.
You have been instructed to enhance the operation of the instance to ensure productivity.
Which of the following actions should you take?

A. You should consider setting up the Windows System Monitoring tool to better the performance.
B. You should consider setting up the Asynchronous database mirroring to better the performance.
C. You should consider using the SQLAGENT.OUT log to better the performance.
D. You should consider setting up the software non-uniform memory access (soft-NUMA) to better the performance.

Answer: D

Explanation:


QUESTION 4
You work as a database administrator at Certkingdom.com. Certkingdom.com has a database server named ABCDB01.
ABC-DB01 is configured with 4 quad-core processors, 80 gigabytes of RAM, and multiple
independent raid volumes.
You are in the process of using a transactional database on the instance. It is anticipated that the
transactional database will have a significant amount of INSERT, UPDATE, and DELETE
activities, which incorporates the creation of new tables.
You receive an instruction from management to minimize the contention in the storage allocation
structures so that database performance is optimized, and the disk bandwidth maximized.
Which of the following actions should you take?

A. You should consider enabling Server Auditing.
B. You should consider using multiple data files for the database.
C. You should consider using row-level compression.
D. You should consider using the checksum page verify option.

Answer: B

Explanation:


QUESTION 5
You work as a database administrator at Certkingdom.com.
Certkingdom.com has informed you that a new database, named ABCData, has to be installed on a SQL
Server 2008 instance. ABCData is made up of several schemas, of which one will host a
significant amount of read-only reference information. Information is regularly inserted and
updated on ABCData.
You have received instructions from the management to configure a physical database structure
that enhances the backup operation.
Which of the following actions should you take?

A. This can be accomplished by using multiple filegroups and a single log file to set up the database.
B. This can be accomplished by using caching on the multiple data files.
C. This can be accomplished by using multiple downstream servers to create the database.
D. This can be accomplished by using the Database Engine Tuning Advisor tool to create the database.

Answer: A

Explanation:

MCTS Training, MCITP Trainnig

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

Lumia 900 release window confirmed

One of the hottest devices to be announced at CES 2012 was Nokia’s Lumia 900. Nokia and Microsoft already gave us the lowdown on the big brother of the Lumia 800, but one detail that they left out was a release date. All we had to go on was “the next few months.” Now it appears that we can narrow down that timeframe: the Lumia 900 will be launching on AT&T in March.

MCTS Certification, MCITP Certification

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

The info was spilled via the Nokia Developer portal. In an otherwise typical press release announcing the Lumia 900, it is revealed that the Lumia 900 “will become available exclusively through AT&T in March.”

The Lumia 900 is, by most people’s measures, a gorgeous phone. Its polycarbonate build is complemented by a 4.3-inch display that uses ClearBlack technology for darker darks. Its software is the real deal too, sporting the latest edition of Windows Phone, version 7.5 Mango. The Lumia 900 will run on AT&T’s burgeoning LTE network.

Microsoft and Nokia wanted to wait until after the 2011 holiday season to launch the first fruits of its collaboration. This was allegedly because it wanted to have its own moment in the spotlight. This may prove to be a smart strategy: apart from maybe Intel’s Medfield announcement, the Lumia 900′s unveiling may have been the biggest smartphone news to come out of CES 2012. March shouldn’t be a crowded field for big smartphone releases, though the expected release of the iPad 3 will surely dominate tech headlines in that month.

There still isn’t any pricing info for the Lumia 900, but it would be wise for Nokia and AT&T to keep it at $200. Verizon’s annoying habit of pricing its new LTE phones at $300 may work for the Android fans who always want the latest-and-greatest. But it wouldn’t be a wise pricing strategy for a platform that’s still unfamiliar to most Americans. $200 would match it up evenly with the iPhone, which is a comparison that Microsoft and Nokia will gladly accept.