Showing posts with label mcitp training. Show all posts
Showing posts with label mcitp training. Show all posts

Thursday, June 14, 2012

70-664 Q&A / Study Guide / Testing Engine / Videos

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as a Network Administrator at Certkingdom.com. You have been asked to deploy Lync Server
2010 as a VOIP telephony and video conferencing solution for the company.
Company management is concerned about the possible network load imposed by the VoIP and
video conferencing features of Lync Server 2010.
To manage the network bandwidth used by the system, you configure Call Admission Control.
How can you enable the Call Admission Control feature?

A. By running the Set-CsNetworkInterSitePolicy cmdlet.
B. By running the Set-CsNetworkConfiguration cmdlet.
C. By running the Set-CsCpsConfiguration cmdlet.
D. By running the Set-CsVoiceConfiguration cmdlet.

Answer: B

Explanation:


QUESTION 2
You work as a Network Administrator at Certkingdom.com. The company’s communication system is
provided by a Lync Server 2010 infrastructure.
You have configured a bandwidth policy to limit the network bandwidth used by real-time audio
and video sessions.
You want to override the policy for the Managing Director of the company.
What type of policy should you create first to enable you to override the bandwidth policy for the
Managing Director?

A. You should first create a Conferencing Policy.
B. You should first create a Client Version Policy.
C. You should first create a Voice Policy.
D. You should first create an External Access Policy.

Answer: C

Explanation:


QUESTION 3
You work as a Network Administrator at Certkingdom.com. You are configuring a new Lync Server 2010 infrastructure.
You want the company phone number to be displayed in the format +11112222333 when users on
the Public Switched Telephone Network (PSTN) receive calls from users using the Lync Server
system.
Which cmdlet should you run?

A. You should run the Set-CsVoiceConfiguration cmdlet.
B. You should run the Set-CsNetworkInterSitePolicy cmdlet.
C. You should run the Set-CsVoicePolicy cmdlet.
D. You should run the Set-CsLocationPolicy cmdlet.

Answer: C

Explanation:


QUESTION 4
Your work as a Network Administrator at Certkingdom.com includes the management of the Lync Server
2010 infrastructure.
The Lync Server 2010 infrastructure includes a Mediation Server pool that includes three servers
named Certkingdom-Med1, Certkingdom-Med2 and Certkingdom-Med3.
You need to take Certkingdom-Med3 offline for maintenance.
Which two of the following steps should you perform to allow you to take Certkingdom-Med3 offline without
disconnecting any current calls in progress?

A. Navigate to the Lync Server 2010 Topology Builder.
B. Navigate to the Lync Server 2010 Control Panel.
C. Modify the properties of the Mediation Pool.
D. Modify the properties of Certkingdom-Med3.
E. Create a new Mediation Pool.

Answer: B,D

Explanation:


QUESTION 5
You work as a Network Administrator at Certkingdom.com. You are in the process of deploying a Lync
Server 2010 infrastructure for the company.
You have configured dial-in conferencing and verified that it is functioning properly.
You now want to notify users about the availability of the feature. The notification should include
introductory instructions such as the initial PIN and the link to the Dial-in Conferencing Settings
webpage.
What is the easiest way to send the notification with the required information to the users?

A. Open the Lync Management Shell and run the New-CsAnnouncement cmdlet.
B. Open the Lync Management Shell and run the Set-CsPinSendCAWelcomeMail cmdlet.
C. Open the Lync Management Shell and run the New-CsConferenceDirectory cmdlet.
D. Open the Lync Management Shell and run the New-CsConferencingConfiguration cmdlet.

Answer: B

Explanation:


MCTS Training, MCITP Trainnig

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

Saturday, April 7, 2012

70-620 Q&A / Study Guide / Testing Engine

MCTS Training, MCITP Trainnig

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

QUESTION 1
You are employed as a Desktop Technician at Certkingdom.com. The Certkingdom.com network consists of a
single Active Directory domain named Certkingdom.com.
Certkingdom.com has acquired a computer named Certkingdom-WS624. The operating system on the computer is
Microsoft Windows XP Professional and its specifications are:
• 1 GB of RAM
• 2GHz processor
• 64-MB video adapter
• 60-GB hard disk with 15 GB of free space
You received instructions for installation of Microsoft Windows Vista on Certkingdom-WS624.
After performing fresh installation you need to identify the which of uCertkingdomrade is needed for
supporting Microsoft Windows Aero Experience?

A. You need to uCertkingdomrade the hard disk to 100 GB.
B. You need to clear 40 GB of free space on the hard disk.
C. You need to uCertkingdomrade the memory to 2 GB of RAM.
D. You need to install a 128 MB of RAM video adapter supporting Microsoft DirectX 9, and
Microsoft Pixel Shader 2.0.
E. You need to uCertkingdomrade the processor to a dual-core processor.

Answer: D

Explanation: To support the Microsoft Windows Aero Experience, you need a video adapter that
has at least 128 MB of RAM, support for Microsoft DirectX 9, and Microsoft Pixel Shader 2.0.


QUESTION 2
You are employed as a network administrator at Certkingdom.com. The Certkingdom.com network consists of a
single Active Directory domain named Certkingdom.com.
A client computer named Certkingdom-WS620 is running Microsoft Windows 2000 with Service Pack 3.
Certkingdom-WS620 also runs some legacy applications. The Certkingdom.com management wants all computers
to be running Microsoft Windows Vista. To this end you have received instructions from the CIO to
uCertkingdomrade Certkingdom-WS620 to Microsoft Windows Vista.
Which two steps should you take to uCertkingdomrade Certkingdom-WS620 and keeping the current applications
intact and not requiring reinstallation?

A. By Installing Windows Vista into a separate partition.
B. By using the Windows Easy Transfer wizard.
C. By uCertkingdomrading to Microsoft Windows XP Professional.
D. By uCertkingdomrading to Windows Vista.
E. By installing the latest version of the Service Pack.
F. By copying your user profile to a removable media.
G. By Performing a clean installation of Windows Vista.
H. By Copying the user profile to the C:\Windows\Users directory.

Answer: C,D

Explanation: To move to Windows Vista without having to reinstall your applications, you need to
do an ‘in-place’ uCertkingdomrade. However, you cannot uCertkingdomrade directly to Windows Vista from
Windows 2000 Professional (you would need a clean install which would delete your applications).
Therefore, you need to uCertkingdomrade to Windows XP Professional first. Then you can uCertkingdomrade to
Windows Vista and keep the applications.


QUESTION 3
You are employed as a network administrator at Certkingdom.com. The Certkingdom.com network consists of a
single Active Directory domain named Certkingdom.com. All client computers on the Certkingdom.com network run
Microsoft Windows Vista.
Certkingdom.com contains a client computer named Certkingdom-WS621. Certkingdom-WS621 has been assigned to a
Certkingdom.com user named Andy Booth. You received a report from Andy Booth complaining that CertkingdomWS621
is performing slower than it should. You have a suspicion that it could be malware that is
causing the problem.
How can you find out what is causing the problems?

A. You need to run a Windows Defender scan.
B. You need to view the processes list in Task manager.
C. You need to view the startup items in the System Configuration utility.
D. You need to run Disk Defragmenter.

Answer: A

Explanation: Windows Defender is an application that can scan for malware or other potentially
harmful files. You can initiate a Windows Defender scan to scan all the files on your system for
malware or other potentially harmful files.


QUESTION 4
You are employed as a network technician at Certkingdom.com. The Certkingdom.com network consists of a
single Active Directory domain named Certkingdom.com. All client computers on the Certkingdom.com network run
Microsoft Windows Vista.
A Certkingdom.com user named Andy Booth has been assigned a client computer named Certkingdom-WS629.
One morning Andy Booth complains that Certkingdom-WS629 does not produce any sound when he
views a video file clip. You open the Device Manager as shown below.



What configuration change should you make to Certkingdom-WS629?

A. You need to update the driver for the audio device.
B. You need to uninstall the device then run a hardware scan.
C. You need to enable the audio device in Device Manager.
D. You need to change the IRQ for the device.
E. You need to run Microsoft Windows Update and install the latest updates for Certkingdom-WS629.
F. You need to replace the audio device with one that is compatible with Windows Vista.

Answer: C

Explanation: The icon by the sound device (the Creative SB Live! Series device) shows that the
device is disabled. Therefore, to receive audio output from Certkingdom-WS629, you simply need to
enable the device. You can do this by right-clicking on the device and selecting Enable.


QUESTION 5
You are employed as a help desk technician at Certkingdom.com. The Certkingdom.com network consists of a
Workgroup named Certkingdom. The client computers on the Certkingdom.com network run a mix of Windows XP
Professional and Windows Vista. You
The Certkingdom.com management wants to conduct a meeting with all their users. You need to facilitate
this meeting. However, invitation to the Certkingdom.com users are not getting sent as they do not appear
in the Invite people list of the Microsoft Windows Meeting Space meeting.
What should you do to be able to invite all Certkingdom.com users to the Windows Meeting Space
meetings? (Each correct answer presents part of the solution. Choose TWO.)

A. You need to instruct the Certkingdom.com users with Windows XP Professional computers to create an
exception for invitations from Windows Meeting Space in the Microsoft Windows Firewall.
B. You need to uCertkingdomrade the Windows XP Professional computers to Windows Vista.
C. You need to configure the Windows XP Professional computers to use Microsoft NetMeeting to
connect to the meeting.
D. You need to instruct all members of the Certkingdom workgroup to sign in to the People Near Me feature.
E. You need to install Service Pack 3 on the Windows XP Professional computers.

Answer: B,D

Explanation:


MCTS Training, MCITP Trainnig

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

Sunday, March 11, 2012

70-573 Q & A / Study Guide / Testing Engine

MCTS Training, MCITP Trainnig

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


QUESTION 1
A site definition has been purchased from another company. It is used to created SharePoint sites.
Now there is a request to modify the home page for the site definition by adding a Web Part.
What actions need to be taken? Select two.

A. Add..
B. Uninstall..
C. Remove…
D. Modify..
E. Install…
F. ..the file CSTemplate.xsd
G. ..the file Onet.xml
H. ..a Feature receiver
I. ..a Feature dependcy
J. ..the file config.web
K. ..the file web.config

Answer: D,G

Explanation:


QUESTION 2
A customized Site Featured need to be made. There is customized site definition.
The Feature of this site definition must be activated for all additional sites which are created using
it.
What actions need to be taken? Select two.

A. Add..
B. Uninstall..
C. Remove…
D. Modify..
E. Install…
F. ..the file CSTemplate.xsd
G. ..the file Onet.xml
H. ..a Feature receiver
I. ..a Feature dependcy
J. ..the file config.web
K. ..the file web.config

Answer: D,G

Explanation:


QUESTION 3
There is third party site definition named CertKingdom.
A file named TemplateCertKingdom.xsd is included in CertKingdom.
TemplateCertKingdom.xsd contains configuration date.
There is a provision handler for CertKingdom.
The information in TemplateCertKingdom.xsd must be read.
The following property should be used.



Answer:




QUESTION 4
There is a specialized program to import data into SharePoint sites.
There is a specialized site definition named CertKingdom created by MS Visual Studio 2010.
The specialized program code must be run whenever a new site is created by using CertKingdom.
What should be done to ensure this? Select three.

A. Modify..
B. Add…
C. Delete…
D. ..file..
E. ..class..
F. ..feature..
G. .. CSTemplate.xsd
H. ..SPItemEventReceiver
I. .. Onet.xml
J. .. receiver
K. .. SPChangeFile
L. .. SPWebEventReceiver
M. .. dependcy
N. .. SPWebProvisioningProvider
O. ..config.web
P. .. web.config

Answer: B,E,N

Explanation:


QUESTION 5
There is a specialized Web Part named CertKingdomWebpart.
There must be a test to check if CertKingdomWebpart generates leaks in the RAM.
What should be done to ensure this? Select two.

A. Modify..
B. Add…
C. Run..
D. Delete…
E. .. WinDbg.exe
F. .. CSTemplate.xsd
G. ..SPItemEventReceiver
H. .. Onet.xml
I. .. SPDisposeCheck.exe
J. .. SPChangeFile
K. .. SPWebEventReceiver
L. .. SPMetal.exe
M. .. SPWebProvisioningProvider
N. ..config.web
O. .. web.config

Answer: C,I

Explanation:


MCTS Training, MCITP Trainnig

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

Tuesday, February 28, 2012

83-640 Q & A / Study Guide / Testing Engine

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as the network administrator at CERTKINGDOM.com. The CERTKINGDOM.com network has a
domain named CERTKINGDOM.com. All servers on the CERTKINGDOM.com network run Windows Server 2008.
Only one Active-Directory integrated zone has been configured in the CERTKINGDOM.com domain.
CERTKINGDOM.com has requested that you configure DNS zone to automatically remove DNS records
that are outdated.
What action should you consider?

A. You should consider running the netsh /Reset DNS command from the Command prompt.
B. You should consider enabling Scavenging in the DNS zone properties page.
C. You should consider reducing the TTL of the SOA record in the DNS zone properties page.
D. You should consider disabling updates in the DNS zone properties page.

Answer: B

Explanation: In the scenario you should enable scavenging through the zone properties because
scavenging removes the outdated DNS records from the DNS zone automatically. You should
additionally note that patience would be required when enabling scavenging as there are some
safety valves built into scavenging which takes long to pop.
Reference: http://www.gilham.org/Blog/Lists/Posts/Post.aspx?List=aab85845-88d2-4091-8088-
a6bbce0a4304&ID=211


QUESTION 2
You work as the network administrator at CERTKINGDOM.com. The CERTKINGDOM.com network has a
domain named CERTKINGDOM.com. All servers on the CERTKINGDOM.com network run Windows Server
2008.
The CERTKINGDOM.com network has a server named CERTKINGDOM-SR15. You install the Active
Directory Lightweight Directory Services (AD LDS) on CERTKINGDOM-SR15.
Which of the following options can be used for the creation of new Organizational Units (OU’s) in
the application directory partition of the AD LDS?

A. You should run the net start command on CERTKINGDOM-SR15.
B. You should open the ADSI Edit Microsoft Management Console on CERTKINGDOM-SR15.
C. You should run the repadmin /dsaguid command on CERTKINGDOM-SR15.
D. You should open the Active Directory Users and Computers Console on CERTKINGDOM-SR15.

Answer: B

Explanation: You need to use the ADSI Edit snap-in to create new OUs in the AD LDS
application directory partition. You also need to add the snap-in in the Microsoft Management
Console (MMC).


QUESTION 3
You work as the network administrator at CERTKINGDOM.com. The CERTKINGDOM.com network has a
domain named CERTKINGDOM.com. All servers on the CERTKINGDOM.com network run Windows Server
2008.
The CERTKINGDOM.com network has two domain controllers CERTKINGDOM-DC01 and CERTKINGDOMDC02.
CERTKINGDOM-DC01 suffers a catastrophic failure but it is causing problems because it was
configured to have Schema Master Operations role. You log on to the CERTKINGDOM.com domain as
a domain administrator but your attempts to transfer the Schema Master Operations role to
CERTKINGDOM-DC02 are unsuccessful.
What action should you take to transfer the Schema Master Operations role to CERTKINGDOMDC02?

A. Your best option would be to have the dcpromo /adv command executed on CERTKINGDOMDC02.
B. Your best option would be to have the Schema Master role seized to CERTKINGDOM-DC02.
C. Your best option would be to have Schmmgmt.dll registered on CERTKINGDOM-DC02.
D. Your best option would be to add your user account to the Schema Administrators group.

Answer: B

Explanation: To ensure that CERTKINGDOM-DC02 holds the Schema Master role you need to seize
the Schema Master role on CERTKINGDOM-DC02. Seizing the schema master role is a drastic step
that should be considered only if the current operations master will never be available again. So to
transfer the schema master operations role, you have to seize it on CERTKINGDOM-DC02.
Reference: http://technet2.microsoft.com/windowsserver/en/library/d4301a14-dd18-4b3c-a3ccec9a773f7ffb1033.
mspx?mfr=true


QUESTION 4
You work as the network administrator at CERTKINGDOM.com. The CERTKINGDOM.com network has a
single forest. The forest functional level is set at Windows Server 2008.
The CERTKINGDOM.com network has a Microsoft SQL Server 2005 database server named
CERTKINGDOM-DB04 that hosts the Active Directory Rights Management Service (AD RMS).
You try to access the Active Directory Rights Management Services administration website but
received an error message stating:
"SQL Server does not exist or access is denied."
How can you access the AD RMS administration website?

A. You need to restart the Internet Information Server (IIS) service and the MSSQLSVC service on
CERTKINGDOM-DB04.
B. You need to install the Active Directory Lightweight Directory Services (AD LDS) on
CERTKINGDOM-DB04.
C. You need to reinstall the AD RMS instance on CERTKINGDOM-DB04.
D. You need to reinstall the SQL Server 2005 instance on CERTKINGDOM-DB04.
E. You need to run the DCPRO command on CERTKINGDOM-SR04

Answer: A

Explanation: You need to restart the internet information server (IIS) to correct the problem. The
starting of the MSSQULSVC service will allow you to access the database from AD RMS
administration website.


QUESTION 5
You work as an enterprise administrator at CERTKINGDOM.com. The CERTKINGDOM.com network has a
domain named CERTKINGDOM.com. The CERTKINGDOM.com network has a Windows Server 2008
computer named CERTKINGDOM-SR03 that functions as an Enterprise Root certificate authority (CA).
A new CERTKINGDOM.com security policy requires that revoked certificate information should be
available for examination at all times.
What action should you take adhere to the new policy?

A. This can be accomplished by having a list of trusted certificate authorities published to the
CERTKINGDOM.com domain.
B. This can be accomplished by having the Online Certificate Status Protocol (OCSP) responder implemented.
C. This can be accomplished by having the OCSP Response Signing certificate imported.
D. This can be accomplished by having the Startup Type of the Certificate Propagation service set to Automatic.
E. This can be accomplished by having the computer account of CERTKINGDOM-SR03 added to the
PGCertificates group.

Answer: B

Explanation: You should use the network load balancing and publish an OCSP responder. This
will ensure that the revoked certificate information will be available at all times. You do not need to
download the entire CRL to check for revocation of a certificate; the OCSP is an online responder
that can receive a request to check for revocation of a certificate. This will also speed up certificate
revocation checking as well as reducing network bandwidth tremendously.


MCTS Training, MCITP Trainnig

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

Monday, February 27, 2012

70-562 Q & A / Study Guide / Testing Engine

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as a Web Developer at CERTKINGDOM.com. You make use of Microsoft .NET Framework 3.5 to
develop ASP.NET Web applications.
CERTKINGDOM.com has a server, named CERTKINGDOM-SR13, which runs an instance of Microsoft SQL Server 2005
locally and is configured to make use of Windows Authentication. You have developed a Web
application named CERTKINGDOMApp1 that will be hosted on CERTKINGDOM-SR13.
You are preparing to configure the role management and membership providers on CERTKINGDOM-SR13.
Which of the following actions should you take?

A. You should consider making use of the Aspnet_compiler.exe command.
B. You should consider making use of the aspnet_regiis.exe command.
C. You should consider making use of the Aspnet_merge.exe command
D. You should consider making use of the ASP.NET SQL Server registration tool.

Answer: A,B

Explanation:


QUESTION 2
You work as a Web Developer at CERTKINGDOM.com. You make use of Microsoft .NET Framework 3.5 to
develop ASP.NET Web applications.
You have recently developed a Web application named CERTKINGDOMWebApp1, and configured it to make
use of Windows Authentication. After specific group is granted NTFS permissions to access a
specific file named CERTKINGDOM.doc, you are informed that you have to make sure that users not
belonging to the group are prevented from accessing the file.
Which of the following actions should you take?

A. You should configure the machine.config file to include the element.
B. You should configure the machine.config file to include the element.
C. You should configure the app.config file to include the element.
D. You should configure the Web.config file to include the element.
E. You should configure the Web.config file to include the element.
F. You should configure the app.config file to include the element.

Answer: D

Explanation:


QUESTION 3
You work as a Web Developer at CERTKINGDOM.com. You make use of Microsoft .NET Framework 3.5 to
develop ASP.NET Web applications.
You have developed a web application named CERTKINGDOMWebApp. You are now preparing to configure
authentication for CERTKINGDOMWebApp so that clients are not allowed to access it anonymously. You also
need to make sure that access for users from untrusted domains are allowed.
You have written the code segment shown below:








Which of the following actions should you take NEXT?

A. You should consider adding the code segment to the web.config file.
B. You should consider adding the code segment to the project’s property pages.
C. You should consider adding the code segment to the app.config file.
D. You should consider adding the code segment to the workstation’s machine.config file.

Answer: A


QUESTION 4
You work as a Web Developer at CERTKINGDOM.com. An MS ASP.NET Web application, named CERTKINGDOMApp1,
has been developed using the 3.5 version of MS Net Framework.
Subsequent to retrieving the most recent project version from the source control repository, you try
to compile it on your workstation and find that the reference to the assembly is absent.
You want to add a reference path that connects to the absent assembly.
Which of the following options should you access to achieve this?

A. The project’s property pages.
B. CERTKINGDOMApp1’s web.config file.
C. CERTKINGDOMApp1’s app.config file.
D. Your workstation’s machine.config file.

Answer: A

Explanation:


QUESTION 5
You work as a Web Developer at CERTKINGDOM.com. You make use of Microsoft .NET Framework 3.5 to
develop Microsoft ASP.NET Web applications.
An existing Web application was developed using Microsoft .NET Framework 1.0. the Web
application makes use of Microsoft Internet Information Services (IIS) 6.0, but does not make use
of any features of Microsoft .NET Framework 3.5.
You want to configure the Web application for .NET Framework 3.5 with as little administrative
effort as possible.
Which of the following actions should you take?

A. You should consider accessing Microsoft Internet Information Services (IIS) 6.0 to modify the
handler runtime version.
B. You should consider accessing the machine.config file to modify the handler runtime version.
C. You should consider accessing the app.config file to modify the handler runtime version.
D. You should consider accessing the web.config file to modify the handler runtime version.

Answer: A

Explanation:


MCTS Training, MCITP Trainnig

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

Monday, February 20, 2012

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

Sunday, February 19, 2012

70-536 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as the application developer at CertKingdom.com. CertKingdom.com uses Visual Studio.NET
2005 as its application development platform.
You are in the process of storing numerical values up to 2,100,000,000 into a variable and may
require storing negative values using a .NET Framework 2.0 application. You are required to
optimize memory usage
What should you do?

A. Int32
B. UInt16
C. UInt32
D. Int16

Answer: A

Explanation:
The Int32 type should be used in the scenario as it can be used to store positive and negative
numerical values from -2,147,483,648 to +2,147,483,647.
Incorrect Answers:
B: The UINT32 and UInt16 type should not be used in the scenario because they are used to store
only unsigned positive numbers.
Reference types
C: The UINT32 and UInt16 type should not be used in the scenario because they are used to store
only unsigned positive numbers.
Attributes
D: The Int16 type should not be used as you will only be allowed to store values from -32768 to
+32768.


QUESTION 2
You work as an application developer at CertKingdom.com. You are currently in the process of
creating a class that stores data about CertKingdom.com’s customers.
CertKingdom.com customers are assigned unique identifiers and various characteristics that may
include aliases, shipping instructions, and sales comments. These characteristics can change in
both size and data type.
You start by defining the Customer class as shown below:
public class Customer
{
private int custID;
private ArrayList attributes;
public int CustomerID
{
get {return custID;}
}
public Customer (int CustomerID)
{
this.custID = CustomerID;
this.attributes = new ArrayList ();
}
public void AddAttribute (object att)
{
attributes.Add (att);
}
}
You have to create the FindAttribute method for locating attributes in Customer objects no matter
what the data type is.
You need to ensure that the FindAttribute method returns the attribute if found, and you also need
to ensure type-safety when returning the attribute.
What should you do?

A. Use the following code to declare the FindAttribute method:
public T FindAttribute (T att)
{
//Find attribute and return the value
}
B. Use the following code to declare the FindAttribute method:
public object FindAttribute (object att)
{
//Find attribute and return the value
}
C. Use the following code to declare the FindAttribute method:
public T FindAttribute (T att)
{
//Find attribute and return the value
}
D. Use the following code to declare the FindAttribute method:
public string FindAttribute (string att)
{
//Find attribute and return the value
}

Answer: C

Explanation:
This code declares the method FindAttribute and specifies an argument named att using the T
placeholder as the argument and return data type. To ensure the FindAttribute method accepts
arguments of different types, you should specify an argument using a generic placeholder. The
argument att in this generic method will accept any valid data type and ensures type-safety by
returning that same data type.
Incorrect Answers:
A: You should not use this code because it does not declare the placeholder T. when declaring a
generic method, you have to use the < > bracketsto declare the place holder before using it.
B: You should not use this code because it does not guarantee type-safery.
D: You should not use this code because it will only accept a string argument and return a string
argument.
Generic types


QUESTION 3
You work as an application developer at CertKingdom.com. You are creating a custom exception
class named ProductDoesNotExistException so that custom exception messages are displayed in
a new application when the product specified by users is unavailable.
This custom exception class will take the ProductID as an argument to its constructor and expose
this value through the ProductID. You are now in the process of creating a method named
UpdateProduct. This method will be used to generate and manage the
ProductDoesNotExistException exception if the ProductID variable contains the value 0.
You need to ensure that use the appropriate code for the UpdateProduct method.
What should you do?

A. Make use of the following code:
public void UpdateProduct ()
{
try
{
if (ProductID == 0)
throw new ProductDoesNotExistException (ProductID);
}
catch (ProductDoesNotExistException ex)
{
MessageBox.Show (“There is no Product” + ex. ProductID);
}
}
B. Make use of the following code:
public void UpdateProduct ()
{
try
{
if (ProductID = = 0)
throw new Exception (“Invalid ProductID”);
}
catch (ProductDoesNotExistException ex)
{
MessageBox.Show (ex.Message);
}
}
C. Make use of the following code:
public void UpdateProduct ()
{
if (ProductID = = 0)
throw new ProductDoesNotExistException (ProductID);
}
D. Make use of the following code:
public void UpdateProduct ()
{
if (ProductID = = 0)
throw new Exception (“Invalid ProductID”);
}

Answer: A

Explanation:
This code verifies the value of the ProductID variable by using the if statement. If the ProductID
variable contains a value of 0, this code generates an exception of type
ProductDoesNotExistException . To explicitly generate an exception, you are required to use the
throw statement. The exception generated by using the throw statement can be handled by the
try…catch block. This code generates the custom exception by calling the constructor of the
custom exception class named ProductDoesNotExistException . The constructor argument is the
ProductID attached to the ProductDoesNotExistException object. This code then handles the
custom exception named ProductDoesNotExistException by using a catch block, which handles
exceptions by using a variable named ex of the type ProductDoesNotExistException . This code
displays the ” There is no Product ” error message by using the MessageBox.Show method and
concatenating the ex. ProductID to it.
Incorrect Answers:
B: You should not use the code that generates an exception of the type Exception and handles the
exception of the type ProductDoesNotExistException in the catch block. This code is incorrect
because you are required to generate a custom exception named ProductDoesNotExistException.
C: You should not use the codes that do not use a try…catch block because the application an
unhandled exception.
D: You should not use the codes that do not use a try…catch block because the application an
unhandled exception.


QUESTION 4
You work as the application developer at CertKingdom.com. CertKingdom.com uses Visual Studio.NET
2005 as its application development platform.
You have recently finished development of a class named TestReward and package the class in a
.NET 2.0 assembly named TestObj.dll. After you ship the assembly and it is used by client
applications, you decide to move the TestReward class from TestObj.dll assembly to the
TestRewardObj.dll Assembly. You are to ensure when you ship the updated TestObj.dll and
TestRewardObj.dll assemblies that the client applications continue to work and do not require
recompiling.
What should you do?

A. The TypeForwardedTo attribute should be used
B. The TypeConvertor.ConvertTo method should be used
C. The InternalsVisibleTo attribute should be used
D. The Type Convertor.ConvertFrom method should be used

Answer: A

Explanation:
The statement used for you to add a type from one assembly into another assembly is the
TypeForwardTo attribute which enables you not to have the application recompiled.
Incorrect Answers:
B: The TypeConverter class provides a unified way of converting different types of values to other
types and can not be used to move a type.
C: The method in question here specifies all nonpublic types in an assembly are visible to other
assemblies but can not be used to move types.Part 2: Manage a group of associated data in a
.NET Framework application by using collections. (Refer System.Collections namespace)
D: The TypeConverter class provides a unified way of converting different types of values to other
types and can not be used to move a type.


QUESTION 5
You work as an application developer at CertKingdom.com. You have recently created a custom
collection class named ShoppingList for a local supermarket. This custom class will include
ShoppinItem objects that have the public properties listed below.
* Name
* AisleNumber
* OnDiscount
You are required to enable users of your class to iterate through the ShoppingList collection, and
to list each product name and aisle number using the foreach statement.
You need to achieve this by declaring the appropriate code.
What code should you use?

A. public class ShoppingList : ICollection
{
// Class implementation
}
B. public class ShoppingList : IEnumerator, IEnumerable
{
// Class implementation
}
C. public class ShoppingList : Ilist
{
// Class implementation
}
D. public class ShoppingList : Enum
{
// Class implementation
}

Answer: B

Explanation:
You should implement the IEnumerable and IEnumerator interfaces of the System.Collections
namespace to ensure that your collection class supports foreach iteration. The IEnumerable
interface defines only one method named GetEnumerator that returns an object of type
IEnumerator of the System.Collections namespace and is used to support iteration over a
collection. The IEnumerator interface supports methods, such as Current , MoveNext , and Reset
to iterate through a collection. The Current method returns the current element of the collection.
The Move method positions the enumerator to the next available element of the collection. The
Reset method positions the enumerator before the first element of the collection.
Incorrect Answers:
A: You should not use the code that implements the ICollection interface because this interface is
used to define properties in a collection. Implementing this interface will not ensure that your
collection class supports foreach iteration because it does not inherit the IEnumerator interface.
C: You should not use the code that implements the Ilist interface because this interface is used to
define properties of a non-generic list of items accessed by index. Implementing this interface will
not ensure that your collection class supports foreach iteration because it does not inherit the
IEnumerator interface.
D: You should not use the code that inherits the Enum because this structure is used as a base
class for those classes that provide enumeration values. Inheriting the Enum structure will not
ensure that your collection class supports foreach iteration.


QUESTION 6
You work as the application developer at CertKingdom.com. CertKingdom.com uses Visual Studio.NET
2005 as its application development platform.
You are developing a .NET Framework 2.0 application used to store a type-safe list of names and
e-mail addresses. The list will be populated all at ones from the sorted data which means you well
not always need to perform insertion or deletion operations on the data. You are required to
choose a data structure that optimizes memory use and has good performance.
What should you do?

A. The System.Collections.Generic.SortedList class should be used
B. The System.Collections.HashTable class should be used
C. The System.Collections.Generic.SortedDictionary class should be used
D. The System.Collections.SortedList class should be used

Answer: A

Explanation:
The SortedList generic class should be used in the scenario class as it provides type safety
compared against the System.Collections.SortedList class.
Incorrect Answers:
B: The System.Collections.HashTable class should not be used as this class provides no type
safety.
Collection interfaces
C: Although this is very similar to the SortedList class the SortedList class should be used instead
in the scenario.
Iterators
D: Although this is very similar to the SortedList class the SortedList class should be used instead
in the scenario.


QUESTION 7
You work as an application developer at CertKingdom.com. You are currently in the process of
reviewing an application that was created by a fellow developer.
The application that you are reviewing includes a declaration for a collection named EmployeeList,
which stores Employee objects. The declaration is shown below:
public class EmployeeList : Enumerator, IEnumerable
{
// Class implementation
}
You require the ability to iterate through the EmployeeList with minimum development effort.
What should you do?

A. Utilize the switch statement
B. Utilize the dowhile statement
C. Utilize the foreach statement
D. Utilize the if statement

Answer: C

Explanation:
the IEnumerable and IEnumerator interfaces of the System.Collections namespace are used to
ensure that your collection class supports foreach iteration. The IEnumerable interface defines
only one method named GetEnumerator that returns an object of type IEnumerator of the
System.Collections namespace and is used to support iteration over a collection. The
IEnumerator interface supports methods, such as Current , MoveNext , and Reset to iterate
through a collection. The Current method returns the current element of the collection. The Move
method positions the enumerator to the next available element of the collection. The Reset
method positions the enumerator before the first element of the collection.
Incorrect Answers:
A: These statements will not allow you to iterate through the EmployeeList collection.
B: You should not use this statement because it will require manually calling the MoveNext and
Current methods. The scenario states that you need to “…iterate through the EmployeeList with
minimum development effort.”
D: These statements will not allow you to iterate through the EmployeeList collection.
Hashtable class


QUESTION 8
You work as an application developer at CertKingdom.com. CertKingdom.com has been contracted to
develop an application for the local bank.
You have been given the responsibility of creating this application and need to store each
transaction record, which is identified using a complex transaction identifier, in memory. The bank
informs you that the total amount of transaction records could reach 200 per day.
To achieve this, you decide to utilize one of the existing collection classes in the .NET 2.0 class
library.
You need to ensure that you the collection class you select is the most efficient one for storing
transaction records.
What should you do?

A. Select the ListDictionary collection class.
B. Select the HashTable collection class.
C. Select the Queue collection class.
D. Select the StringCollection collection class.

Answer: B

Explanation:
You should select the HashTable class to store transaction records because each element is
identified using a unique identifier and the size of the collection is large. Elements in the
HashTable collection are stored with a key/value pair where each key is created using a hash
code. The default capacity of a HashTable class is zero, and you can use the Add method to add
a new element to the collection. The Count property provides the total number of elements in the
HashTable collection. An element of the HashTable class can be accessed using the
DictionaryEntry class. You can use the Key and Value properties of the DictionaryEntry class to
access the key associated with the element and the value of the element, respectively.
Incorrect Answers:
A: You should not select this collection class because this class is used if the total number of
elements to be stored in a collection is less than 10 elements in length.
C: You should not select this collection class because you need to access transaction records
using a transaction identifier, not in sequential order.
D: You should not select this collection class because this class is used to manage a collection of
string values.


QUESTION 9
You work as an application developer at CertKingdom.com. CertKingdom.com has been hired by a small
local private school to develop a class library that will be used in an application named
ManageAttendance for the purpose of managing student records.
You are responsible for developing this class library. CertKingdom.com has instructed you to create a
collection in the application to store learners’ results.
The school has informed you that they currently only have seven learners, but that this value will
triple in the following year. Due to the limited resources, you need to ensure that the collection you
create consumes a minimum amount of resources.
What should you use to create the collection?

A. The HybridDictionary collection class.
B. The HashTable collection class.
C. The ListDictionary collection class.
D. The StringCollection collection class.

Answer: A

Explanation:
You should use the HybridDictionary class to create the collection because this class is useful in
scenarios where the number of elements is unknown or could grow in size. A collection of the
HybridDictionary type manages the collection depending on the number of elements. The
HybridDictionary type collection uses the ListDictionary class to manage the collection when there
are only a few elements. When the number of elements exceeds ten, the HybridDictionary type
collection automatically converts the elements into HashTable management.
Incorrect Answers:
B: You should not use this collection class because this class is used if the total number of
elements to be stored in a collection is known and is greater than ten elements in length.
C: You should not use this collection class because this class is used if the total number of
elements to be stored in a collection is known and is less than ten elements in length.
D: You should not use this collection class because this class is used to manage a collection of
string values.


QUESTION 10
You work as an application developer at CertKingdom.com. CertKingdom.com wants you to develop an
application that stores and retrieves client information by means of a unique account number.
You create a custom collection class, which implements the IDictionary interface, named
ClientDictionary. The following code have been included into the new application.
//Create Client objects
Client c1 = new Client (“AReid”, “Andy Reid”, Status.Current);
Client c2 = new Client (“DAustin”, “Dean Austin”, Status.New);
//Create ClientDictionary object
IDictionary cData = new ClientDictionary ();
cData.Add (“10001″, c1);
cData.Add (“10002″, c2);
You use the same method to add other Client objects to the collection. You need to ensure that
you are able to retrieve client information associated with the account number 10111.
What should you do?

A. Use the following code:
Client foundClient;
foundClient = (Client) cData.Find (“10111″);
B. Use the following code:
Client foundClient;
if (cData.Contains (“10111″))
foundClient = cData ["10111"];
C. Use the following code:
Client foundClient;
if (cData.Contains (“10111″))
foundClient = (Client) cData ["10111"];
D. Use the following code:
Client foundClient;
foreach (string key in cData.Keys
{
if (key == “10111″)
foundClient = (Client) cData.Values ["10111"];
}

Answer: C

Explanation:
This code invokes the Contains method of the IDictionary interface to determine whether a value is
associated with the key 10111. If a value exists for that key, then the clientData ["10111"]
statement retrieves the client data as a generic object. The code casts the generic object into a
Client object, and it is stored in the foundClient variable
Incorrect Answers:
A: You should not use the code that uses the Find method because no such method exists in the
IDictionary interface.
B: You should not use the code that assigns the foundClient variable to a generic object because
the foundClient variable is declared as a Client type.
D: You should not use the code that iterates through the Keys collection because it is unnecessary
and process-intensive.

MCTS Training, MCITP Trainnig

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

Thursday, February 16, 2012

70-523 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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

QUESTION 3
There is a service WCF (Windows Communication Foundation) Data Services CertKingdomService.
CertKingdomService has been developed with MS .NET Framework 4 and MS Visual Studio 2010.
An application CertKingdomApp uses CertKingdomService.
There is a problem. Whenever CertKingdomApp sends DELETE and PUT requests to
CertKingdomService there is an error.
What should be done in this scenario? Select three.

A. When accessing CertKingdomService CertKingdomApp should use header..
B. When accessing CertKingdomService CertKingdomApp should use footer..
C. ..HTTP-Method..
D. .. X-HTTP-Method..
E. .. HTTP ContentType..
F. .. XML ContentType..
G. .. XLS-Method..
H. ..as part of a DELETE request.
I. ..as part of a GET request.
J. ..as part of a POST request.
K. ..as part of a PUT request.

Answer: A,D,J

Explanation:


QUESTION 4
There is an application CertKingdomApp.
CertKingdomApp has been developed with MS .NET Framework 4 and MS Visual Studio 2010.
There is a server CertKingdomSrv.
There is a Microsoft SQL Server 2008 database CertKingdomDb on CertKingdomSrv.
CertKingdomApp connects to CertKingdomDb.
CertKingdomDb includes a table CertKingdomProducts.
CertKingdomProducts includes product information.
CertKingdomProducts has a column ProductType.
ProductType is used to identify if the product is digital or physical.
There is Product entity base type.
There is an Association entity Digital inheriting from the Product entity base type.
All digital products must be bound to Digital class.
What should be done? Select three.

A. The Entity Data Model Designer should be used to..
B. Change the file..
C. ..code-behind to include..
D. ..global.aspx to include..
E. .. .edmx file to include..
F. ..to set up a referential constraint..
G. .. to set up an association between..
H. .. the primary key of the Digital class and ProductType.
I. .. between the Digital class and ProductType.
J.
K.

Answer: B,E,J

Explanation:


QUESTION 5
There is an application CertKingdomApp.
CertKingdomApp has been developed with MS .NET Framework 4 and MS Visual Studio 2010.
To model entities CertKingdomApp ADO.NET Entity Framework is used.
CertKingdomApp make sure that users can update entities even if they are not connected to the
central store. In such a case, when the user reconnects: changes the local data must be persisted,
latest updates from the central data store are loaded to the local store (when no local changes
have been made).
What should be done in this scenario? Select three.

A. Use method…
B. Use library..
C. Use attribute..
D. ..Execute..
E. ..Refresh of ObjectContext class..
F. ..Refresh of ViewContext class..
G. ..through usage of MergeOptions.OverwriteChanges
H. ..through usage of RefreshMode.StoreWins.AppendOnly
I. ..through usage of RefreshMode.ClientWins
J. ..through usage of MergeOptions.AppendOnly

Answer: A,E,I

Explanation:


QUESTION 6
There is an application CertKingdomApp.
CertKingdomApp has been developed with MS .NET Framework 4 and MS Visual Studio 2010.
You are implementing the CertKingdomApp data layer.
In particular when the GetDataReader method returns a SqlDataReader, the SqlDataReader can
retrieve rows from the database.
Also when the SqlDataReader is closed the active SQL connections, opened with the
GetDataReader method, must be closed.
What code should be used in this scenario?



Answer:



QUESTION 7
Sales Exhibit:
Sales Properties:
SalesID
CustomerID
OrderDate
ShipAddress
Sales_details Exhibit:
Properties:
SalesID
ProductID
UnitPrice
Quantity
There is an application CertKingdomApp.
CertKingdomApp has been developed with MS .NET Framework 4 and MS Visual Studio 2010.
There is a server CertKingdomSrv.
There is a Microsoft SQL Server 2008 database CertKingdomDb on CertKingdomSrv.
CertKingdomApp connects to CertKingdomDb.
LINQ is used to created the Sales and Sales_details in the exhibit.
There is a one- to-many relation from the SalesID of Sales to the SalesID of Sales_details.
The primary key of Sales is SalesID column.
The primary key of Sales_details is the SalesID and ProductID columns.
You are required to provide SQL code that produces the sum of the price of each Sales record.
Which code should be used?



Answer:


MCTS Training, MCITP Trainnig

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

Sunday, January 22, 2012

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

Thursday, January 19, 2012

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

Sunday, January 15, 2012

MB2-186 - Microsoft CRM Applications Professional v.1.1 - Q&A / Study Guide

MCTS Training, MCITP Trainnig

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


Exam Name: Microsoft CRM Applications Professional v.1.1
Exam Type: Microsoft
Exam Code: MB2-186


QUESTION 1
Which of the following statements regarding Account record relationships is correct?

A. Contacts can only have one parent Account
B. Accounts can parent many other Accounts
C. Accounts can have many parent Accounts
D. Accounts can parent many Contacts

Answer: A, B, D


QUESTION 2
When does an Activity change ownership in the Microsoft CRM application?

A. When it is modified by another user
B. When it is assigned to another user
C. When it is shared with another user
D. When it is viewed by another user

Answer: B


QUESTION 3
What is the significance of blue field labels found in Microsoft CRM records?

A. A blue field label indicates a business required field value
B. A blue field label indicates a business recommended field value
C. A blue field label indicates a system generated field value
D. A blue field label indicates a field value that may be updated only by a system administrator

Answer: B


QUESTION 4
Which of the following statements about Notes and Attachments is correct?

A. Notes may be shared with other application users.
B. Notes are always parented by another record.
C. Sales Professional is required to use Notes and Attachments.
D. Notes and attachments can only be added to Accounts, Contacts and Opportunities.

Answer: B


QUESTION 5
Which of the following are functions in Microsoft CRM for finding data?

A. CRM Index Alphabet Bar
B. Options menu
C. Quick Create
D. View menu

Answer: A, D


QUESTION 6
What action in the Account and Contact record is permanent and cannot be reversed?

A. Assigning
B. Deactivating
C. Deleting
D. Sharing

Answer: C


QUESTION 7
What types of records may be assigned to a Queue in the Workplace?

A. Accounts
B. Activities
C. Cases
D. Opportunities

Answer: B, C


QUESTION 8
A Subject record has how many parent relationships?

A. 1
B. 3
C. 5
D. Unlimited

Answer: A


QUESTION 9
If a Microsoft CRM user accepts an Activity or Case, where will it be placed in the application?

A. Assigned queue
B. Draft queue
C. In Progress queue
D. Public queue

Answer: C


QUESTION 10
What are the personal options for converting incoming E-mail to Microsoft CRM Activity records?

A. All Incoming e-mail
B. Only inbound e-mail
C. Only e-mail about a new CRM record
D. Only e-mail about an existing CRM record

Answer: A, D


MCTS Training, MCITP Trainnig

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

Friday, January 13, 2012

70-448 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. The Certkingdom.com network contains a SQL Server
2008 database server named ABC-DB01, which hosts the SQL Server 2008 Reporting Services
(SSRS) instance.
During routine monitoring, you discover that this instance does not render any extensions for
Microsoft Office Word.
How would you modify the instance to render these extensions?

A. The Report Server database should be modified on ABC-DB01.
B. The RSReportServer.config file should be modified on ABC-DB01.
C. The XML configuration file should be modified onABC-DB01.
D. The Web.config file should be modified on ABC-DB01.

Answer: B

Explanation:


QUESTION 2
You work as a database administrator for Certkingdom.com. The Certkingdom.com network contains a SQL
Server 2008 database server named ABC-DB03.
You are in the process of designing a SQL Server 2008 Integration Services (SSIS) package for
the Certkingdom.com network. Certkingdom.com has informed you that ABC-DB03 will be hosting the package.
You receive an instruction from the CIO to devise a plan of action in the event that ABC-DB03
becomes inactive.
How can this be achieved?

A. The master database should be backed up.
B. You should back up ABC-DB03.
C. You should execute an incremental backup on a weekly basis.
D. The SSIS package should be backed up.

Answer: A

Explanation:


QUESTION 3
You work as a database administrator at Certkingdom.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01.
You receive instruction that the SQL Server 2008 Reporting Services model needs to be deployed
on ABC-DB01 to support a data source that contains 800 tables for the Marketing division. You
have been tasked with developing a report model.
Which of the following options will make sure that the Marketing division is only able to access 10
tables? (Choose two)

A. A data source view should be developed.
B. The marketing division should be denied access to the other tables.
C. The tables and views the marketing division will not be using should be highlighted.
D. The tables and views the marketing division will use should be indicated.
E. The Dynamic Management View should be properly modified.

Answer: A,D

Explanation:


QUESTION 4
You work as a database administrator at Certkingdom.com. The Certkingdom.com network contains a SQL Server
2008 database server named ABC-DB01. ABC-DB01 is configured to host the SQL Server
Analysis Services (SSAS) role.
There is a dimension named Housing in ABC-DB01 that contains three properties named Slabs,
Cement and Bricks. The relationship between the properties is nonflexible. Currently a data source
is used that indicates the changes between the affiliations of the properties. You receive an
instruction from the CIO to ensure that any modifications will be reflected.
Identify the command that will help you to accomplish your task?

A. The ProcessDefault command
B. The ProcessAdd command.
C. The ProcessFull command.
D. The ProcessClear command.
E. The ProcessNone command.

Answer: A,D

Explanation:


QUESTION 5
You work as a database administrator at Certkingdom.com. Your duties include administering a SQL
Server 2008 Analysis Services (SSAS) sample named ABC-DB01.
You receive an instruction from the CIO to log all queries. You then decide to make the necessary
changes to the QueryLogconnection String feature.
What should your next step be?

A. You should modify the connection string to the default value.
B. A valid connection string should be set on ABC-DB01.
C. The source attribute should be set to 20.
D. You should set the default value using Discover_Query.

Answer: B

Explanation:


MCTS Training, MCITP Trainnig

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

Sunday, January 8, 2012

70-433 Q & A / Study Guide

MCTS Training, MCITP Trainnig

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


QUESTION 1
You work as a network database administrator at Certkingdom.com. Certkingdom.com has a database server
named ABC-DB01 that hosts the Inventory database.
Certkingdom.com has a user named Rory Allen has the SQL login rallen. Rory Allen was granted the
DELETE permissions to Stock table in the Inventory database.
How would you configure ABC-DB01 to revoke Rory Allen’s SELECT permissions to the Stock
table without disrupting other permissions he has to the Inventory database?

A. By running the ADD USER rallen Transact-SQL statement.
B. By running the TRUNCATE Inventory.Stock FROM rallen Transact-SQL statement.
C. By running the DENY DELETE ON Inventory.Stock TO rallen Transact-SQL statement.
D. By running DELETE SELECT ON Inventory.Stock TO rallen Transact-SQL statement.

Answer: C

Explanation:


QUESTION 2
You work as a network database administrator at Certkingdom.com. Your boss, CertKingdom wants to know
on which columns unique constraints can be created.
What must you tell your boss?

A. On nvarchar(50) NULL or nvarchar(50) NOT NULL columns.
B. On nvarchar(50) SPARSE NULL and nchar(max) SPARSE NULL columns.
C. On nvarchar(max) NOT NULL and nvarchar(max) NULL columns.
D. On all of the above.

Answer: A

Explanation:


QUESTION 3
You work as a network database administrator at Certkingdom.com. Certkingdom.com has a database server
named ABC-DB01 which hosts the Inventory database.
Certkingdom.com recently created a table named ItemsSold which lists the customers with their discount ratings.
How can you configure ABC-DB01 to have customers who have made purchases before granted 15% discount?

A. By using the WITH CHECK (Purchases = 0 AND Discount = 0.15) constraint.
B. By using the WITH CHECK (Purchases > 0 AND Discount 0.15) constraint.
C. By using the WITH CHECK ((Purchases = 0 AND Discount = 0) AND (Purchase < 0 AND Discount = 0.15)) constraint.
D. By using the WITH CHECK ((Purchases = 0 AND Discount = 0) OR (Purchase > 0 AND Discount = 0.15)) constraint.

Answer: D

Explanation:


QUESTION 4
You work as a network database administrator at Certkingdom.com. Certkingdom.com has a database server
named ABC-DB01 that hosts the Inventory database.
Certkingdom.com has a Sales division which makes changes to the ItemSold and Stock tables of the Inventory database.
How can the Inventory database be configured ensuring changes listed in the ItemSold table
corresponds to records in the Stock table?

A. By making use of the MERGE statement.
B. By making use of CLR triggers.
C. By making use of a Clustered Index and INNER JOIN constraints.
D. By making use of a Foreign key constraint.
E. By making use of a Unique constraint.

Answer: D

Explanation:


QUESTION 5
You work as a network database administrator at Certkingdom.com. Certkingdom.com has a database server
named ABC-DB01 that hosts the Retail database.
The Retail database has a table named Customers that has a column named Address. You need
to alter the Address column to enable users to query the column based on geographic location.
How would you alter the column?

A. By specifying the datetimeoffset data type.
B. By specifying the text data type.
C. By specifying the geography data type.
D. By specifying the user-defined type data type.

Answer: C

Explanation:


MCTS Training, MCITP Trainnig

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