Tag Archives: MCTS Training

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

MCTS Training, MCITP Trainnig

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

 


QUESTION 1
Exhibit:
<endpoint address =” https:://www.CertKingdom.com/CertKingdomService”
Binding=”netTc pBinding”
bindingConfiguraton-NetTcpBinding_CertKingdomService
contract=”ServiceReference 1. ICertKingdomService’
name=’NetTcpBinding_CertKingdomService”/>
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService use address tcp:www.CertKingdom.com/CertKingdomService to listens for
messages.
The logical address is www.CertKingdom.com/CertKingdomService
The WCF client is configured as in the exhibit.
However, the client is unable to communicate with the server.
In what way must the configuration be adjusted?

Answer:


QUESTION 2
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService has a callback contract.
There is a client application CertKingdomClient.
CertKingdomClient calls CertKingdomService.
How can you ensure that CertKingdomClient and CertKingdomService can communicate? Select two.

A. Use the OperationContractAttribute..
B. On CertKingdomService..
C. On CertKingdomClient..
D. ..set set the Async Pattern property value to false
E. ..set set the Async Pattern property value to true
F. ..use GetCallbackChannel <T>
G. ..add a proxy derived from DuplexClientBase <TChannel>

Answer: C,G

Explanation:


QUESTION 3
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService has a callback contract.
There is a client application CertKingdomClient.
CertKingdomClient calls CertKingdomService.
How can you ensure that CertKingdomClient and CertKingdomService can communicate? Select two.

A. Use the OperationContractAttribute..
B. On CertKingdomService..
C. On CertKingdomClient..
D. ..set set the Async Pattern property value to false
E. ..set set the Async Pattern property value to normal
F. ..use GetCallbackChannel (Of T)
G. ..add a proxy derived from DuplexClientBase (Of TChannel)

Answer: C,G

Explanation:


QUESTION 4
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService supports transactions. Messages handled by CertKingdomService must be
encoded using a binary encoding, must be secured using Windows stream-based security, and
must be sent over TCR.
CertKingdomService must implement a custom binding for the service.
How should the stacking order be defined?

Answer:


QUESTION 5
There is a WCF (Windows Communication Foundation) application CertKingdomApp.
CertKingdomApp exposes a service as and end point (SOAP) for consumption by cross-platforms
clients.
You want to log messages that the service receives from the client.
What action should you take?

Answer:


QUESTION 6
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService communicates with a database CertKingdomDB.
CertKingdomDB uses a workflow engine.
CertKingdomDB handles data access authorization. A security exception is raised an unauthorized
user tries to access CertKingdomDB.
This exception must be transmitted the client that is calling CertKingdomService.
How can this be achieved? Select two.

A. Use CertKingdomDB..
B. Use CertKingdomService..
C. ..and configure service Debug.
D. ..and configure router.
E. ..and configure router Security Audit.
F. ..and configure Unhandled Exception

Answer: B,C

Explanation:


QUESTION 7
There is a WCF (Windows Communication Foundation) service CertKingdomService.
There are out of-process process resources that CertKingdomService must access on behalf of an
originating caller. What should you do?

A. Use the service contract PrincipalPermissionAttribute..
B. Use ServiceSecurityContext.CurrentWindowsidentity.ImpersonationLevel..
C. ..and set the value to…
D. ..and change the value of bindingConfiguration attribute in the endpoint element of the
configuration file to..
E. .. TokenImpersonationLevelDelegation
F. .. wsHttpBinding
G. .. ssHttpBinding
H. .. Impersonation

Answer: B,C,E

Explanation:


QUESTION 8
There is WCF (Windows Communication Foundation) application CertKingdomApp.
There is a data contract CertKingdomData, with several data members, that is used by
CertKingdomApp.
Consider a serialized instance of CertKingdomData which is deserialized. If any of data members
are not available CertKingdomApp must throw a Serialization Exception.
What action should you take? Select three.

A. For each data member…
B. Use CertKingdomData and..
C. Set a default value in each of the data member declarations.
D. .. Set the IsRequired property..
E. .. Emit Default Value proper..
F. .. Order property..
G. ..add the Unknown Type attribute.
H. ..add the Known Type attribute.
I. ..to false.
J. ..to true.
K. .. to a unique integer value.
L. .. to a unique string value.

Answer: A,D,J

Explanation:


QUESTION 9
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService exposes the operations CertKingdom1 and CertKingdom2.
CertKingdom1 should run with the identity of the client.
CertKingdom2 should run with the identity of the CertKingdomService.
How can this be achieved?

Answer:


QUESTION 10
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService handles accounting related processes.
You must ensure that CertKingdomService runs with the identity of the application that is calling
CertKingdomService.
How can this be ensured?

Answer:


QUESTION 11
There is a WCF (Windows Communication Foundation) service CertKingdomService.
CertKingdomService is secured.
How can you track attempts to access CertKingdomService that are unsuccessful? Select all that
apply.

A. Use the serviceAuthorization behavior..
B. Use the serviceDebugger behavior..
C. Use the serviceSecurityAudit behavior..
D. Use the security configuration element..
E. ..and use attribute..
F. ..and use method..
G. Mode
H. messageAuthenticationAuditLevel
I. includeExceptionDetailsInFaults
J. authorizationManagerType
K. ..and set it to..
L. True
M. False
N. Success
O. Failure
P. Service
Q. Message

Answer: C,E,H,K,O

Explanation:

MCTS Training, MCITP Trainnig

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

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified Technology Specialist (MCTS)
Demonstrate your specialized technical expertise with a Microsoft Certified Technology Specialist (MCTS) certification. By earning this certification, you can prove your ability to successfully implement, build on, troubleshoot, and debug a particular Microsoft technology, such as a Windows operating system, Microsoft Exchange Server, Microsoft SQL Server, and Microsoft Visual Studio.

Level: One or more years of experience implementing, troubleshooting, and debugging a specific technology
Audience: IT professional or developer
Type: Microsoft Certification

MCTS Training, MCITP Trainnig

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

MCTS Overview
The Microsoft Certified Technology Specialist (MCTS) certifications are designed to help validate your skills on the features and functionality of Microsoft technologies. You can show your depth of knowledge in one specific technology, earn multiple MCTS certifications to show breadth across different products, or build on the MCTS to earn a Microsoft Certified IT Professional (MCITP) certification.

MCTS candidate profile

MCTS candidates are capable of implementing, building, troubleshooting, and debugging a particular Microsoft technology.

Why get certified?
Earning a Microsoft Certification validates your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today’s rapidly changing IT marketplace, Microsoft Certifications help you utilize evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

Whether you are new to technology, changing jobs, or a seasoned professional, becoming certified demonstrates to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

MCTS Certifications
To earn each MCTS certification, you must pass the corresponding exam(s).

Exchange Server
MCTS: Microsoft Exchange Server 2007, Configuration Exam 70-2361
MCTS: Microsoft Exchange Server 2010, Configuration Exam 70-662

Lync Server and Office Communications Server
MCTS: Microsoft Lync Server 2010, Configuration Exam 70-664
MCTS: Microsoft Office Communications Server 2007, Configuration Exam 70-6381

Project and Project Server
MCTS: Microsoft Project Server 2010, Configuration Exam 70-177
MCTS: Microsoft Project 2010, Managing Projects Exam 70-178
MCTS: Microsoft Office Project 2007, Managing Projects Exam 70-632
MCTS: Enterprise Project Management with Microsoft Office Project Server 2007 Exam 70-633
MCTS: Microsoft Office Project Server 2007, Configuration Exam 70-639

SharePoint and SharePoint Server
MCTS: Microsoft SharePoint 2010, Configuration Exam 70-667
MCTS: Microsoft SharePoint 2010, Application Development Exam 70-573
MCTS: Microsoft Office SharePoint Server 2007, Configuration Exam 70-6301
MCTS: Microsoft Office SharePoint Server 2007, Application Development Exam 70-542

SQL Server
MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance Exam 70-448
MCTS: Microsoft SQL Server 2008, Database Development Exam 70-433
MCTS: Microsoft SQL Server 2008, Implementation and Maintenance Exam 70-432

Virtualization
MCTS: Windows Server 2008 R2, Server Virtualization Exam 70-659
MCTS: Windows Server 2008 R2, Desktop Virtualization Exam 70-669
MCTS: Windows Server Virtualization, Configuration Exam 70-6521

Visual Studio
MCTS: Microsoft .NET Framework 4, Windows Applications Exam 70-511
MCTS: Microsoft .NET Framework 4, Web Applications Exam 70-515
MCTS: Microsoft .NET Framework 4, Service Communication Applications Exam 70-513
MCTS: Microsoft .NET Framework 4, Data Access Exam 70-516
MCTS: Microsoft Silverlight 4, Development Exam 70-506
MCTS: Microsoft Visual Studio Team Foundation Server 2010, Administration Exam 70-512
MCTS: Microsoft .NET Framework 3.5 ADO.NET Applications Exam 70-536 and Exam 70-561
MCTS: Microsoft .NET Framework 3.5 ASP.NET, Applications Exam 70-536 and Exam 70-562
MCTS: Microsoft .NET Framework 3.5, Windows Communication Foundation Applications Exam 70-536 and Exam 70-503
MCTS: Microsoft .NET Framework 3.5 Windows Forms Applications Exam 70-536 and Exam 70-505
MCTS: Microsoft .NET Framework 3.5, Windows Presentation Foundation Applications Exam 70-536 and Exam 70-502
MCTS: Microsoft .NET Framework 3.5, Windows Workflow Foundation Applications Exam 70-536 and Exam 70-504
Note If multiple exams are required, you can take them in any order.

Windows Client
MCTS: Windows 7, Configuration Exam 70-680
MCTS: Windows 7 and Microsoft Office 2010, Deployment Exam 70-681
MCTS: Windows Vista, Configuration Exam 70-620

Windows Embedded
MCTS: Microsoft Windows Embedded CE 6.0, Development Exam 70-571
MCTS: Microsoft Windows Embedded Standard 2009, Development Exam 70-577
MCTS: Microsoft Windows Embedded Standard 7, Development Exam 70-582
MCTS: Windows Embedded Compact 7 Exam 70-181

Windows Mobile
MCTS: Windows Mobile 6.5, Application Development Exam 70-5801
MCTS: Windows Mobile 6.5, Configuration Exam 70-5791

Windows Server
MCTS: Windows Server 2008 Active Directory, Configuration Exam 70-640
MCTS: Windows Server 2008 Network Infrastructure, Configuration Exam 70-642
MCTS: Windows Server 2008 Applications Infrastructure, Configuration Exam 70-643
MCTS: Windows Small Business Server 2011 Standard, Configuration Exam 70-169
MCTS: Windows Small Business Server 2008, Configuration Exam 70-653
MCTS: Windows Essential Business Server 2008, Configuration Exam 70-654
MCTS: Windows Internals Exam 70-660
MCTS: Windows HPC Server 2008, Development Exam 70-691

Other technologies
MCTS on Microsoft Dynamics

MCTS: Microsoft BizTalk Server 2010 Exam 70-595
MCTS: Volume Licensing Specialist, Large Organizations Exam 70-672
MCTS: Volume Licensing Specialist, Small and Medium Organizations Exam 70-671
MCTS: Microsoft Desktop Optimization Pack, Configuration Exam 70-656
MCTS: Microsoft Forefront Endpoint and Application Protection, Configuration Exam 70-162
MCTS: Microsoft Bing Maps Platform, Application Development Exam 70-5441
MCTS: Microsoft Office Visio 2007, Application Development Exam 70-545

Frequently Asked Questions

View all answers

Q. How many exams must I typically take to obtain an MCTS certification?

A. Typically, you must take one to three exams that focus on a key Microsoft product or technology.

Q. Will additional MCTS certifications be offered?

A. Yes, as new technologies are released, MCTS certifications will be added.

Q. Am I a Microsoft Certified Professional (MCP) if I earn a Microsoft Certified Technology Specialist (MCTS) certification?

A. The term MCP is used both as a general term for all Microsoft Certified Professionals and as the name of a credential. As an MCTS, you become part of the Microsoft Certified Professional community, with access to all related benefits, information, and activities. You do not earn a credential titled “MCP.” You should use the MCTS certification on your resume and in business collateral, thereby indicating your specialty and that you are a member of the MCP community at large.

Q. How long will my certification be valid?

A. Today, most of our Microsoft Certified Technology Specialist (MCTS), Microsoft Certified IT Professional (MCITP), and Microsoft Certified Professional Developer (MCPD) exams retire when Microsoft discontinues mainstream support for the related technology. The certification will still appear on your transcript but will be listed in an inactive section with an expiration date. In most cases, an upgrade path, which allows candidates to earn the certification with fewer exams (usually one), will be available for individuals who hold the certification on the previous version of the technology.

The legacy Microsoft certifications, such as Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA), currently do not expire, but some may no longer be awarded because all exams are retired or because Microsoft has ended extended support for the technology. In most cases, individuals who hold the certification on the previous version of the technology can earn the certification on the next version of the technology with one upgrade exam.

To maintain the relevance and value of our certifications and ensure that candidates possess up-to-date skills on technologies that are constantly changing, recertification may be necessary for some certifications. In these cases, the certification will remain valid as long as the candidate continues to recertify at appropriate intervals.

Note that Microsoft reserves the right to retire exams and certifications as well as change our recertification policy at any time.

Still have questions? Try one of the following frequently asked questions (FAQ) pages.

MCTS Training, MCITP Trainnig

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

70-511 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 an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You have recenty created an application, and cofigured it to have a composite user control. You
also configured the user control to have a TextBox control, named txtEntry. You then configure the
user control to be stored in a window, and include the following code in the constructor of the user control:
AddHandler(TextBox.TextChangedEvent, new RoutedEventHandler(Audit_TextChanged), true);
Which of the following statements are TRUE? (Choose all that apply.)

A. A text-changed event handler, named Audit_TextChanged, was created for the txtEntry control.
B. Audit_TextChanged will stop running because the event is marked as handled by certain event handlers
C. Even though the event is marked as handled by certain event handlers, Audit_TextChanged will still run.
D. Audit_TextChanged will continue to run until the event is marked as handled.

Answer: A,C

Explanation:


QUESTION 2
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
After developing an application, named CertkingdomApp22, you configure a Button control and a
MenuItem control that will be hosted by a window. The Button control and the MenuItem control
have both been named Add.
You have configured the exact same RoutedCommand, named AddCommand, as the Command
properties of these two controls. You then write the code shown below:
Private void CanAdd (object sender, CanExecuteRoutedEventArgs e) { … }
You are then informed that the two controls should be disabled when the CanExecute property is
set to to false.
Which combination of the following actions should you take? (Choose all that apply.)

A. You should consider having an event handler configured for the CanExecuteChanged event of
the AddCommand command.
B. You should consider having a CommandBinding object added to the CommandBindings
property of the window.
C. You should consider having a CommandBinding object added to the CommandBinding section
of the MenuItem control.
D. You should consider having the CanAdd method called from within the event handler.
E. You should consider having the AddCommand inherited from the RoutedUICommand class.
F. You should consider having the Command property of CommandBinding set to the AddCommand command.
G. You should consider having the CanAdd method called from within the constructor of the AddCommand command.
H. You should consider having the CanExecute property of the CommandBinding object set to the CanAdd method.

Answer: B,F,H

Explanation:


QUESTION 3
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You have created a new application, and written the code shown below:
MediaPlayer player = new MediaPlayer();
player.Open(new URI(AudioFilePath), UriKind.Relative)); player.play();
You then inserted this code into the button onclick event.
Which of the following statements are TRUE with regards to the configuration?

A. The media player will open as soon as a user clicks the button, but no file will be played.
B. The file that is stored in the AudioFilePath variable will be played as soon as the button is clicked by the user.
C. All files stored in the media player will be played in sequence.
D. All files stored in the media player will be played randomly.

Explanation:


QUESTION 4
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Forms applications. After developing a new application, named
CertkingdomApp13, you include a custom class named CertkingdomClient.
You have configured a new object data source, and also added a BindingSource component
named CertkingdomclientBindingSource to a Windows Form. The CertkingdomclientBindingSource component is
configured to be data-bound to the CertkingdomClient data source.
You then configure the Windows form to have two TextBox controls for presenting and modifying
CertkingdomClient. You have bound the data of these controls to its own CertkingdomclientBindingSource
property. The Windows form is also configured to contain an ErrorProvider component, named
errorProvider. The data entries for the TextBox controls will be validated by the ErrorProvider
component.
You want to configure the validation process to occur automatically.
Which of the following actions should you take?

A. You should consider throwing an exception when the value is invalid to apply the validation
rules inside the TextChanged event handler of each TextBox control by throwing an exception
when the value is invalid. You should also consider inserting the code shown below in the
InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.CertkingdomclientBindingSource;
B. You should consider throwing an exception when the value is invalid to apply the validation
rules inside the TextChanged event handler of each TextBox control by throwing an exception
when the value is invalid. You should also consider inserting the code shown below in the
InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.CertkingdomclientBindingSource.DataSource;
this.errorProvider.DataMember = this.CertkingdomclientBindingSource.DataMember;
C. You should consider throwing an exception when the value is invalid to apply the validation
rules inside the setter of each property of the CertkingdomClient class. You should also consider inserting
the code shown below in the InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.CertkingdomclientBindingSource.DataSource;
this.errorProvider.DataMember = this.CertkingdomclientBindingSource.DataMember;
D. You should consider throwing an exception when the value is invalid to apply the validation
rules inside the setter of each property of the CertkingdomClient class. You should also consider inserting
the code shown below in the InitializeComponent method of the Windows Form.
this.errorProvider.DataSource = this.CertkingdomclientBindingSource;

Answer: D

Explanation:


QUESTION 5
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Forms applications.
You have recently created a new application. You then wrote the code shown below:
Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture;
Which of the following options are TRUE with regards to the code?

A. The user interface will make use of the culture settings that are configured in the Control Panel at present.
B. The user interface will make use of new culture settings.
C. The user interface will have no culture settings.
D. The user interface will make use of the culture settings that were installed with the operating
system.

Answer: A

Explanation:


QUESTION 6
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You are in the process of developing a new application, named CertkingdomApp35, which has a server
assembly, as well as a partially trusted client assembly configured. After configuring customized
sandboxed application domain, you are required to make sure that you are able to run CertkingdomApp35
in a partial-trust setting.
Which of the following actions should you take?

A. You should consider configuring the PartialTrustVisibilityLevel setting for the
AllowPartiallyTrustedCallers attribute of the server assembly to be VisibleByVefault.
B. You should consider configuring the PartialTrustVisibilityLevel setting for the
AllowPartiallyTrustedCallers attribute of the server assembly to be NotVisibleByDefault.
C. You should consider configuring the PartialTrustVisibilityLevel setting for the
AllowPartiallyTrustedCallers attribute of the client assembly to be VisibleByDefault.
D. You should consider configuring the PartialTrustVisibilityLevel setting for the
AllowPartiallyTrustedCallers attribute of the client assembly to be NotVisibleByDefault.

Answer: B

Explanation:


QUESTION 7
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Forms applications.
After creating a new client application, you configure a default form size in the UserScopedSetting
of the the ApplicationSettingsBase class.
Then application makes use of the Form1 type form, which includes a FormSettings object named
frmSettings1.
You have been instructed to write code that allows for the user’s preferred form size to be used
whenever the user opens the application.
Which of the following options should you write?

A. public void Form2_Load(object sender, EventArgs e) { frmSettings2.start();
} public void Form2_FormClosing(object sender, FormClosingEventArgs e) {
frmSettings2.FormSize = this.Size;
frmSettings2.Save(); }
B. private void Form1_Load(object sender, EventArgs e) { frmSettings1.UCertkingdomrade();
} private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{ Form1.FormSize = this.Size;
Form1.Delete(); }
C. private normal Form1_Load(object sender, EventArgs e) { this.Size = frmSettings2.FormSize;
} public void Form2_FormClosing(object sender, FormClosingEventArgs e)
{ Form2.FormSize = this.Size;
Form2.UCertkingdomrade(); }
D. private void Form1_Load(object sender, EventArgs e) { this.Size = frmSettings1.FormSize;
} private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{ frmSettings1.FormSize = this.Size;
frmSettings1.Save(); }

Answer: D

Explanation:


QUESTION 8
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Forms applications.
You have been instructed to create a new application. The application must present a text
message requesting users to update their settings. This should occur whenever a user starts the
application.
Which of the following options suitably represents the required code?

A. sealed class FormSettings : ApplicationSettingsBase
{
[UserScopedSetting()] [DefaultSettingValue(“Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}
B. sealed class FormSettings : ApplicationSettingsBase
{
ApplicationScopedSetting()] [DefaultSettingValue(“Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}
C. sealed class FormSettings : ApplicationSettingsBase
{
[MachineSetting()] [SettingsDescription(“Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}
D. sealed class FormSettings : ApplicationSettingsBase
{
[UserScopedSetting()] [SettingsDescription(“Description: Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}
E. sealed class FormSettings : ApplicationSettingsBase
{
[ApplicationScopedSetting()] [SettingsDescription(“Description: Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}
F. sealed class FormSettings : ApplicationSettingsBase
{
[MachineSetting()] [SettingsDescription(“Description: Please update your settings.”)]
public String Description
{
get { return (String)this[“Description”]; }
set { this[“Description”] = value;}
}
}

Answer: A

Explanation:


QUESTION 9
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You are in the process of developing a new application named CertkingdomApp13. CertkingdomApp13 must be
able to present data to application users two consecutive pages at one time.
Which of the following actions should you take?

A. You should consider having an XMLDocumentReader control configured.
B. You should consider having a FlowDocumentReader control configured.
C. You should consider making use of the Microsoft Word Viewer.
D. You should consider making use of the XPS Reader.

Answer: B

Explanation:


QUESTION 10
You are employed as an application developer at Certkingdom.com. You make use of Microsoft .NET
Framework 4 to develop Windows Presentation Foundation (WPF) applications.
You are in the process of developing a new application named CertkingdomApp35. You have been
informed that CertkingdomApp35 should have a layout panel configured. The layout panel used should
allow for child objects to be organized and displayed vertically.
The layout panel should not, however, require the child objects to be resized.
Which of the following actions should you take?

A. You should consider making use of the Grid panel layout.
B. You should consider making use of the Canvas panel layout.
C. You should consider making use of the Lock layout.
D. You should consider making use of a Stack panel layout.

Answer: D

Explanation:


MCTS Training, MCITP Trainnig

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

70-506 Q & A / Study Guide

 

MCTS Training, MCITP Trainnig

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

 


QUESTION 1
You work as a Silverlight 4.0 developer for Certkingdom.com.
You have recently developed a Silverlight application named CertkingdomApp. While testing CertkingdomApp, you
do a right-click within CertkingdomApp that result in the Silverlight standard panel being displayed when
the mouse button is released. You do not want this information to be displayed.
You notice that the layout root element of CertkingdomApp is set up to manage the
RightMouseButtonDown in the right way.
What should be done in this scenario?

A. You should consider making use of the MouseButtonEventArgs.Handled property, and setting it
to FALSE.
B. You should consider making use of the MouseButtonEventArgs.Handled property, and setting it
to TRUE.
C. You should consider making use of the MouseButtonEventArgs.OriginalSource property, and
setting it to TRUE.
D. You should consider making use of the MouseButtonEventArgs.OriginalSource property, and
setting it to FALSE.

Answer: B

Explanation:


QUESTION 2
You work as a Silverlight 4.0 developer for Certkingdom.com.
Certkingdom.com has a file server named Certkingdom-SR13. You have developed a Silverlight application named
CertkingdomApp that sends files to Certkingdom-SR13. You have configured CertkingdomApp as a trusted application.
You are required the make sure that a user is able to select a file.
Which of the following actions should you take?

A. You should consider making use of the OpenFileDialog class to achieve your goal.
B. You should consider making use of the SaveFileDialog class to achieve your goal.
C. You should consider making use of the CopyFileDialog class to achieve your goal.
D. You should consider making use of the CloseFileDialog class to achieve your goal.

Answer: A

Explanation:


QUESTION 3
You work as a Silverlight 4.0 developer for Certkingdom.com.
Certkingdom.com has a file server named Certkingdom-SR13. You have developed a Silverlight application named
CertkingdomApp that sends files to Certkingdom-SR13. You have configured CertkingdomApp as a trusted application.
You are required the make sure that a user is able to select a file.
What should be done in this scenario? Select two or three.

A. You should make use of the File.SpecialFolder method.
B. You should make use of the Environment.SpecialFolder method.
C. You should make use of the File.GetFolderPath method.
D. You should make use of the Environment.GetFolderPath method.

Answer: B,D

Explanation:


QUESTION 4
You work as a Silverlight 4.0 developer for Certkingdom.com.
You have developed a Silverlight application, named CertkingdomApp13. You have configured a control
within CertkingdomApp13 to show a picture. You notice that the picture is being presented upside down.
You decide to make use of XAML code to configure the application to correct the presentation of the picture.
Which of the following is TRUE with regards to the required code? (Choose all that apply.)

A. Your code should include the CompositeTransform class combined with the Dispatcher property.
B. Your code should include the CompositeTransform class combined with the SkewY property.
C. Your code should include the CompositeTransform class combined with the Rotation property.
D. Your code should include the CompositeTransform class combined with the SkewX property.

Answer: C

Explanation:


QUESTION 5
You work as a Silverlight 4.0 developer for Certkingdom.com.
There is a Silverlight application named CertkingdomApp7.
CertkingdomApp has three VisualStates OK, HalfOK, and NotOK.
You want to make sure that the NotOK VisualState changes to the OK VisualState in 7 seconds exactly.
Which of the following actions should you take?

A. You should create an XAML code segment that makes use of the VisualTransition class, and
includes the GeneratedDuration Property.
B. You should create an XAML code segment that makes use of the VisualState Class class, and
includes the GeneratedDuration Property.
C. You should create an XAML code segment that makes use of the VisualStateGroup Class
class, and includes the GeneratedDuration Property.
D. You should create an XAML code segment that makes use of the
VisualStateChangedEventArgs Class class, and includes the GeneratedDuration Property.

Answer: A

Explanation:


QUESTION 6
You work as a Silverlight 4.0 developer for Certkingdom.com. You are currently creating a Silverlight
application named CertkingdomApp7.
CertkingdomApp7 has a page, named CertkingdomPage, which includes a text box control named CertkingdomTB.
CertkingdomApp7 also includes a ControlTemplate, which has been set up as a Resource.
You want to make sure that CertkingdomTB makes use of this resource via XAML code.
Which of the following actions should you take?

A. You should consider making use of the segment below:
<TextBox Template=”{StaticResource TextBoxTemplate}” />
B. You should consider making use of the segment below:
<TextBox Template=”{StaticResource CertkingdomTB}” />
C. You should consider making use of the segment below:
<TextBox Template=”{CertkingdomTB}” />
D. You should consider making use of the segment below:
<TextBox Template=”{CertkingdomApp7}” />

Answer: A

Explanation:


QUESTION 7
You work as a Silverlight 4.0 developer for Certkingdom.com. You have created a Silverlight application
named CertkingdomApp13.
CertkingdomApp13 has a page, named CertkingdomPage, which includes a text box named CertkingdomTB.
You have written the segment shown below:
<Style
TargetType=”TextBox”>
<Setter Property=”FontFamily” Value=”Arial” />
<Setter Property=”Foreground” Value=”Red” />
</Style>
Which of the following options are TRUE with regards to using this segment?

A. It defines an explicit style for CertkingdomTB.
B. It defines an implicit style for CertkingdomTB.
C. It defines an explicit style for CertkingdomPage.
D. It defines an implicit style for CertkingdomPage.

Answer: B

Explanation:


QUESTION 8
XAML exhibit:
<TextBox Style=”{StaticResource TextBoxTemplate}” />
You work as a Silverlight 4.0 developer for Certkingdom.com.
There is a Silverlight application named CertkingdomApp.
CertkingdomApp includes the code being displayed in the exhibit.
You are now required to add a customer control in relation to the definition in the exhibit.
Which of the following actions should you take?

A. You should consider writing code that makes use of the BaseOn property.
B. You should consider writing code that makes use of the TargetType property.
C. You should consider writing code that makes use of the IsSealed property.
D. You should consider writing code that makes use of the Setter property.

Answer: D

Explanation:


QUESTION 9
You work as a Silverlight 4.0 developer for Certkingdom.com.
There is an MS Visual Studio 2010/Silverlight 4.0 application named CertkingdomApp21 that should be
configured to support three languages. There should be only three resource files, one for each
language. CertkingdomApp should choose the proper language with no additional code.
Which of the following file extensions should form part of the resource naming solution?

A. .res
B. .resx
C. .xml
D. .xaml

Answer: B

Explanation:


QUESTION 10
You work as a Silverlight 4.0 developer for Certkingdom.com.
There is a Silverlight/MS Visual Studio 2010 web site named CertkingdomSite.
English, German, Spanish, Arabic, Swahili and French are used within CertkingdomSite.
CertkingdomSite stack panel control for the user controls must be set up to be able show languages that are bidirectional.
What should be done in this scenario?

A. You should consider setting the HorizontalAlignment property of the stack panel control.
B. You should consider setting the VerticalAlignmentproperty of the stack panel control.
C. You should consider setting the FlowDirection property of the stack panel control.
D. You should consider setting the Orientation property of the stack panel control.

Answer: A

Explanation:

 

MCTS Training, MCITP Trainnig

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

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

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

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

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

 

70-432 Q & A / Study Guide

 

MCTS Training, MCITP Trainnig

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

 

QUESTION 4
You work as a database administrator at Certkingdom.com. Certkingdom.com is using a SQL Server 2008
instance. The SQL Server 2008 instance hosts quite a few applications. ABC also has a server
named ABC-SR43 that is used to store log files.
You have to set up a new job that stores log files on ABC-SR43. You create a new account
ABC\Log_Account. You set it up to be run by the SQL Server Agent Services.
However, your job fails to store any log files on ABC-SR43. After some investigation you notice
that the job does not have permissions to store files on ABC-SR43.
How should you remedy the situation? Select the best option.

A. You should set up ABC\Log_Accoun as a Remote Service account.
B. You should set up ABC\Log_Accoun as a Domain service account.
C. You should set up ABC\Log_Accoun as a Local Service account.
D. You should set up ABC\Log_Accoun as a Local System account.
E. You should set up ABC\Log_Accoun as a Network Service account.
F. You should set up ABC\Log_Account as a Domain account.

Answer: F

Explanation:
The service startup account defines the Microsoft Windows account in which SQL Server Agent
runs and its network permissions. SQL Server Agent runs as a specified user account. For
compatibility with earlier versions of SQL Server, SQL Server Agent can also run as the Local
System account.
In this scenario you should select a Domain account, which allows sufficient permissions and
improved security.


QUESTION 5
You work as a database administrator at Certkingdom.com. Certkingdom.com is using a SQL Server 2008
instance that has a table named ABC_Training. ABC_ Training contains a column named
ABC_Distance. A new Certkingdom.com training policy states that the training (ie. The ABC_Distance
column in the ABC_Training table) cannot be increased or decreased by more than 3%.
How should you implement the ABC Training Policy?

A. You should consider developing a view which rolls back non-compliant Certkingdom.com policy
changes to ABC_Distance.
B. You should consider developing a stored procedure which rolls back non-compliant Certkingdom.com
policy compliant changes to the ABC_Distance column.
C. You should consider developing a primary key constraint to the ABC_training table which only
contains valid values on ABC_Distance.
D. You should consider developing a create trigger which rolls back non-compliant Certkingdom.com
policy changes to the ABC_Distance column.
E. You should consider developing an update trigger which rolls back non-compliant Certkingdom.com
policy changes to the ABC_Distance column.
F. You should consider developing a delete trigger which rolls back non-compliant Certkingdom.com policy
changes to the ABC_Distance column.

Answer: E

Explanation:


QUESTION 6
You work as a database administrator at Certkingdom.com. Certkingdom.com is using a SQL Server 2008
instance that contains a database named ABC_DB. Certkingdom.com contains a lot of customer data
which is processed by the Web application. You need to keep the customer information safe since
it is confidential. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application?
Select one or two.

A. You should consider adding a transaction Log on ABC_DB, and set the information to be
encrypted for a fixed time.
B. Use BitLocker Drive Encryption on the hard drives on the SQL Server.
C. Use EFS (Encrypting File System) on the hard drives on the SQL Server.
D. You should consider enabling the Transparent Database Encryption on ABC_DB and back up
the transaction log.
E. You should consider enabling the Transparent Database Encryption on ABC_DB and enabling
the Transparent Database Encryption on master database.
F. Use cell-level encryption for the specific data that needs to be kept safe.

Answer: D

Explanation:
With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have
the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by
using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for
bulk encryption to meet regulatory compliance or corporate data security standards. TDE works at
the file level, which is similar to two Windows® features: the Encrypting File System (EFS) and
BitLocker™ Drive Encryption, the new volume-level encryption introduced in Windows Vista®,
both of which also encrypt data on the hard drive. TDE does not replace cell-level encryption,
EFS, or BitLocker.


QUESTION 7
You work as a database administrator at Certkingdom.com. Certkingdom.com is using two SQL Server 2008
sample named ABCSmp1 and ABCSmp2. Furthermore, ABCSmp1 contains a database named
ABC_DB. A Certkingdom.com user named Mia Hamm uses her logon MiaHamm to log on to the database
on ABCSmp1. During the week you have transferred ABC_DB to ABCSmp2. You manually
recreate the Mia Hamm login on ABCSmp2. However, when she tries to login on ABC_DB at
ABCSmp2, she received an error message stating that she is not allowed access. Mia Hamm
needs to access ABC_DB and you need to make it happen.
What T-SQL code should you use? (Each correct option is part of the answer. Choose TWO)

A. Use Certkingdom.com;
B. Use ABC_DB; *
C. Use ABCSmp1;
D. Use ABCSmp2;
E. ALTER LOGIN MiaHamm WITH DEFAULT_DATABASE = ABC_DB;
F. CHANGE LOGIN MiaHamm WITH DEFAULT_DATABASE = ABC_DB;
G. ALTER LOGIN MiaHamm WITH PASSWORD = ‘pwd1234’ UNLOCK;
H. CHANGE LOGIN MiaHamm WITH PASSWORD = ‘pwd1234’ UNLOCK;
I. CHANGE USER MiaHamm WITH LOGIN = MiaHamm;
J. ALTER USER MiaHamm WITH LOGIN = MiaHamm; *
K. ALTER LOGIN MiaHamm ENABLE;
L. CHANGE LOGIN MiaHamm ENABLE;

Answer: B,J

Explanation:


QUESTION 8
You work as a database administrator at Certkingdom.com. Certkingdom.com is using a SQL Server 2008 instance.
Your junior assistant is curious about on how to move a table, such as ABC_table, from its current
scheme (scheme1) to another scheme (scheme2)
How can you accomplish this in T-SQL?

A. You should consider using the following:
ALTER TABLE Schema1.ABC_Table SWITCH TO Schema2.ABC_table;

B. You should consider using the following:
ALTER AUTHORIZATION ON Schema1.ABC_Table TO Schema2;

C. You should consider using the following:
ALTER SCHEMA schema2 TRANSFER schema1.ABC_table;

D. You should consider using the following:
ALTER SCHEMA schema1 TRANSFER schema2.ABC_table;

E. You should consider using the following:
ALTER USER Schema1 WITH DEFAULT_SCHEMA = Schema2;

F. You should consider using the following:
MOVE ABC_Table FROM SCHEMA schema1 TO schema2

G. You should consider using the following:
MOVE ABC_Table FROM schema1 TO schema2

Answer: C

Explanation:
ALTER SCHEMA can only be used to move securables between schemas in the same database.
To change or drop a securable within a schema, use the ALTER or DROP statement specific to
that securable.


QUESTION 9
You work as a database administrator at Certkingdom.com. Certkingdom.com is using a SQL Server 2008
instance. You have received instructions from management to allow the users at Certkingdom.com on the
SQL Server sample to use the OPENROWSET() function to search remote information sources.
You study incomplete code in the exhibit carefully. (Line numbers are used for reference purposes only)
Exhibit:
01. sp_configure ‘show advanced options’, 1
02. RECONFIGURE
03.
04. RECONFIGURE
05. GO
06.
07. SELECT a.*
08. FROM OPENROWSET(‘SQLNCLI’, ‘Server=Madrid;Trusted_Connection=yes;’,
09. ‘SELECT GroupName, Name, DepartmentID
10. FROM AdventureWorks.HumanResources.Department
11. ORDER BY GroupName, Name’) AS a;
12. GO
Which T-SQL statement should you insert at line 03 to make the batch meet the requirement in
this scenario?

A. sp_configure ‘Router control’, 1
B. sp_configure ‘Router control’, 0
C. sp_configure ‘Transaction Logs’, 1
D. sp_configure ‘Transaction Logs’, 0
E. sp_configure ‘Ad Lib Distributed Queries ‘, 1
F. sp_configure ‘Ad Lib Distributed Queries ‘, 0
G. sp_configure ‘Ad Hoc Distributed Queries’, 1
H. sp_configure ‘Ad Hoc Distributed Queries’, 0

Answer: G

Explanation:
By default, SQL Server does not allow ad hoc distributed queries using OPENROWSET and
OPENDATASOURCE. When this option is set to 1, SQL Server allows ad hoc access. When this
option is not set or is set to 0, SQL Server does not allow ad hoc access.
Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to
connect to remote data sources that use OLE DB. OPENROWSET and OPENDATASOURCE
should be used only to reference OLE DB data sources that are accessed infrequently. For any
data sources that will be accessed more than several times, define a linked server.

 

MCTS Training, MCITP Trainnig

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