Online MCITP Certification, mcitp training, mcitp exmas, mcitp certificaions

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

2012-01-29T22:44:00.000-08:00

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:

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

Microsoft MB2-422 CRM 3.0 Customization - Q & A / Study Guide

2012-01-27T23:31:00.000-08:00

Microsoft MB2-422
CRM 3.0 Customization

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

QUESTION 1:

You work as a CRM administrator at Certkingdom .com. Your assistant is named Clive
Wilson. You instruct Clive Wilson to define a second client in the case form that will
serve as the secondary owner. You also instruct Clive Wilson to ensure that the
contact data for the second client is readily accessible in Workflow without needing
custom development.
What should Clive Wilson do?

A. A relationship association between Case and User should be created in order to train
clients to create a Note on the Case document to backup the owner.
B. An organization-owned entity called 'Secondary Owner' should be created that keeps
data representing Microsoft CRM users which is assigned as Secondary Case owners.
Then you should create a relationship between Secondary Owner and Case to create a
lookup field on the Case form. Thereafter you are able to maintain information regarding
Secondary Owners separate from Users.
C. An nvarchar field should be created to permit the entry of the secondary client in the
case form.
D. The association between Case and Client should be created where the client is the
primary entity.

Answer: B

QUESTION 2:

You work as the CRM administrator at Certkingdom .com. Your assistant is named
Clive Wilson. The Certkingdom .com network consists of one Windows Small Business
Server 2003 Active Directory domain named Certkingdom .com.
You have received instruction from the CIO to implement Microsoft CRM 3.0.
Certkingdom .com wants to associate service cases with accounts. Management wants to
link the case with a particular person associated with the account
You instruct Clive Wilson to identify the best solution to create this association?
What should Clive Wilson do?

A. The existing Responsible Contact lookup field on the Case Form should be exposed.
B. He should create a new nvarchar text attribute called Responsible Contact.
C. He should insist that the clients create a new association with the Responsible Contact
entity.
D. He should train the users to type the existing Responsible Contact topic field at the
beginning of the lookup field and expose the lookup filed in the case.

Answer: A

QUESTION 3:

You work as the network technician at Certkingdom .com. You have received instruction
from the CIO to implement Microsoft CRM. Certkingdom .com intends to use an image
file as an icon for a custom entity.
What should you do?

A. You should make use of the Microsoft CRM Deployment manager to upload an icon
for the Web and Outlook Clients.
B. You should make use of the Microsoft CRM Deployment manager to locate the
default custom entity icon in \_img\ for the Web client.
C. You should make use of the Microsoft CRM Customization Area to upload an icon for
the Web and Outlook Clients.
D. You should make use of the Microsoft CRM Customization Area to upload an icon for
the Web client. The image file is copied to the Outlook client network installation
location.

Answer: C

QUESTION 4:

You work as the network administrator at Certkingdom .com. The Certkingdom .com
network consists of a single Active Directory domain named Certkingdom .com. You
implement Microsoft CRM 3.0 on the Certkingdom .com network.
You have received instruction from the CIO to integrate its financial system into
Microsoft CRM. You need to display four particular revenue fields on the Income
Form. You need to ensure that the information displayed is current.
What should you do?

A. The Income form should be modified. Post-callouts configured for specific events to
execute logic in custom assemblies to write data directly to the database of the financial
system should be used.
B. Use the Income form and create triggers on the Microsoft CRM database to write data
directly to the database of the financial system when records are created or updated
should be modified.
C. Use the Income form and client side code to write the data directly to the database of
the financial system should be modified.
D. Use the .aspx page that displays the Income form and write the data directly to the
database of the financial system should be modified.

Answer: A

QUESTION 5:

You work as the network administrator at Certkingdom .com. The Certkingdom .com
network consists of a single Active Directory domain named Certkingdom .com. Microsoft
CRM 3.0 is implemented on the Certkingdom .com network.
You have received instruction from the CIO to execute conditional validation of the
field values. A Certkingdom .com employee named Andy Reid works in the Research
and Development department. You delegate the task of identifying the best option to
execute the validation to Andy Reid. You inform Andy Reid that the correct value of
a text field depends on the values in numerous other fields.
What should he do? (Choose all that apply.)

A. He should use the client side code in the OnLoad event to set the default value when
the Create form is used.
B. In the OnChange event for the Est. Revenue field you should set the value in order to
check the value of the field.
C. He should use the form OnChange Event.
D. In the OnSave event form he should compare the 'value and 'returnValue' properties of
the Est. Revenue field to ensure that they are the same.
E. He should use the form OnSave Event.

Answer: E

QUESTION 6:

You work as the network administrator at Certkingdom .com. The Certkingdom .com
network consists of a single Active Directory domain named Certkingdom .com. You
implement Microsoft CRM 3.0 on the Certkingdom .com network.
You have received instruction from the CIO to create a custom entity called 'Event'.
'Event' will be used to keep data about certain events that are not part of the
normal services Certkingdom .com offers. A Certkingdom .com employee named Kara Lang
works in the Research and Development department.
You delegate the task of configuring three lookup fields on the event form. These
lookup fields are used to link Microsoft CRM clients who are responsible for the
areas of Entertainment, Catering, and Security. Kara Lang needs to identify the
possible solutions to address the need.
What should she do?

A. The Event entity should be created with a relationship to Activities than storing the
data in the Event form.
Task activities should then be created for the individual areas of responsibility.
B. Have a developer create A custom .aspx page needs to be created.
This will permit the clients to choose a CRM User and save the data with the Event
record.
No actual relationship is created in Microsoft CRM.
C. She should create three relationships between Event and User.
User will then be the primary entity.
The lookup fields are then displayed in the Event form.
D. A text field should be used to enter the names of the individuals without making use
of a lookup field.

Answer: A, B, D

QUESTION 7:

You work as the network administrator at Certkingdom .com. The Certkingdom .com
network consists of a single Active Directory domain named Certkingdom .com. All
servers on the Certkingdom .com network run Windows Server 2003 and all client
computers run Windows XP Professional. You have recently configured a custom
entity named AccPri which exists with a relationship where the Account is the
Primary entity.
You have recently received instruction from the network CIO to configure another
custom entity named EnAccPri with a relationship where AccPri is the Primary
entity. You are required to ensure that when only the customizations export only the
customizations for AccPri are exported and imported the customizations into a new
Microsoft CRM installation the AccPri should exist in the new installation. You are
required to select from the following what you can additionally expect to find.
What should you do?

A. The EnAccPri is what you would expect to find.
The relationship between EnAccPri and AccPri is what you would expect to find.
B. You would expect to find nothing else imported.
C. The EnAccPri is what you would expect to find.
The relationship between AccPri and Account is what you would expect to find.
The relationship between EnAccPri and AccPri is what you would expect to find.
D. The relationship between AccPri and Account is what you would expect to find.

Answer: D

QUESTION 8:

You work as a consultant at Certkingdom .com. The Certkingdom .com network consists of a
single Active Directory domain named Certkingdom .com. You implement Microsoft
Dynamics CRM 3.0 on the Certkingdom .com network.
The following customizations have already been implemented:-
* Form Customizations
* Client-side-code
* Custom mapping and
* Custom relationship behaviors.
You have received instruction from the CIO to add additional customizations on
Microsoft CRM. There is a development system with Microsoft CRM installed that
is available to develop customizations. You need to identify the best way to add the
additional customizations.
What should you do?

A. The customizations should be exported for the entities you plan to customize from the
production system.
The customizations should then be imported to the development system.
You then develop and test the customizations on the development system.
Then you export the customizations from the development system and import the
customizations to the production system.
Thereafter you can publish the entities you initially exported from the production system.
B. You should develop the customizations on the development system.
Then the customizations need to be tested on the development system.
You need to record all the customizations that were developed.
Thereafter the customizations can be manually applied on the production system.
C. You should develop the customizations on the development system.
Then the customizations need to be tested on the development system.
Thereafter the customizations can be imported to the production system.
D. You should export the current customizations from the production system.
The customizations should then be imported to the development system.
You then develop and test the customizations on the development system.
Thereafter you export the customizations from the development system and import the
customizations to the production system.

Answer: D

QUESTION 9:

You work as the network administrator at Certkingdom .com. The Certkingdom .com
network consists of a single Active Directory domain named Certkingdom .com.
You have received instruction from the CIO to add code on an event. You need to
add the code on the event that will only work if the user is online using the Outlook
client. A Certkingdom .com employee named Andy Reid works in the Research and
Development department. You delegate the task of checking the conditions prior to
the execution of the logic in your code.
What should he check the conditions? (Choose all that apply.)

A. He is able to determine whether the client is using the Outlook client by checking the
crmForm.IsForOutlookClient property.
B. He is able to determine whether the client is using the Outlook client by checking the
location property of the window. In the Outlook client the location property consist of a
reference field to port 5249.
C. You can send an HTTP request to an URL to find out if the client is online. As soon as
a request times out you can be sure that the client is not offline.
D. By checking the crmForm.IsOnline property you are able to determine whether the
client is online.

Answer: A, D

QUESTION 10:

You work as the system administrator at Certkingdom .com. The Certkingdom .com network
consists of a single Active Directory domain named Certkingdom .com. You have received
instruction to apply client-side code on-save event in the lead entity form.
You have received instruction from the CIO to publish customizations. A
Certkingdom .com employee named Mia Hamm works in the Sales department. One
morning Mia Hamm reports that an error occurred when she tried to save an
existing lead.
You are able to create new leads without an error. This error could have been
identified before the users.
What would have been the easiest method?

A. You should test the client side code making use of the Update Form menu option from
the Preview menu prior to publishing. The Preview menu is on the Form customization page.
B. You should test the code on another computer before applying it to the server and
preview the menu prior to publishing.
C. You should include conditional logic in the code to detect the user
D. You should check the code for syntax errors prior to applying the code to the form.

Answer: A

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

MB2-421 Q & A / Study Guide

2012-01-25T22:23:00.000-08:00

MB2-421 - CRM 3.0 Installation & Configuration

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

QUESTION 1
You work as a CRM consultant at Certkingdom .com. The Certkingdom .com network
consists of a single Active Directory domain named Certkingdom .com. Certkingdom .com has
its headquarters in Chicago and sales offices in Dallas and Miami. Every sales office
has a Microsoft CRM 3.0 Server and five laptops.
The Telesales campaigns are used by all sales offices. Every sales office makes use of
the mail merge functionality for direct mail order campaigns. Staff at every office
comprise of ten telesales operators that work in two shifts. The telesales operators in
the two shifts make use of the same client computer.
You need to plan the deployment of the most appropriate Microsoft CRM client for Certkingdom .com.
What should you do?

A. You should deploy the Microsoft CRM laptop client for Outlook on the laptop computers.
B. You should deploy the Microsoft CRM desktop client for Outlook on the laptop computers.
C. You should deploy the Microsoft CRM laptop client for Outlook on Microsoft CRM 3.0 server.
D. You should deploy the web browser client on the laptop computers.

Answer: B

QUESTION 2
You work as a CRM consultant at Certkingdom .com. Certkingdom .com consists of two
departments named Development and Customer Care. Certkingdom .com has its
headquarters in Chicago and a branch office in Dallas. The Customer Care
department resides in the headquarters and the Development department resides in
the branch office.
The technicians in the Development department have developed a schema and
formed customization for Certkingdom .com. This customization needs to be applied to
an existing Microsoft CRM implementation at the office of one of your customers.
The customer, Rory Allen, has live data in their Microsoft CRM database and
Metabase. You need to apply the developed schema and form customization to Rory
Allen's existing Microsoft CRM database. The existing live data in Rory Allen's
Microsoft CRM database must be retained.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)

A. Backup the Metabase database developed by the Development department to a file.
B. Export the schema and form customization developed by the Development department
to a file using the Microsoft CRM Redeployment tool.
C. Export the schema and form customization developed by the Development department
to a file using the Export Customization tool.
D. Restore the Metabase database developed by the Development department from
backup over Rory Allen's Metabase database.
E. Import the schema and form customization developed by the Development department
to Rory Allen's site using the Microsoft CRM Redeployment tool.
F. Import the schema and form customization developed by the Development department
to Rory Allen's site using the Import Customization tool.

Answer: C, F

QUESTION 3
You work as a CRM consultant at Certkingdom .com. The Certkingdom .com network
consists of a single Active Directory domain named Certkingdom .internal. Microsoft
CRM 3.0 Client for Outlook and Microsoft CRM 3.0 Exchange E-mail Router is
used in the current Certkingdom .com Microsoft CRM environment.
Certkingdom .com wants to restructure its Active Directory domain by creating a new
domain named Certkingdom .com. New user accounts must be created in the Certkingdom .com
domain and new mail boxes must be created for all Certkingdom .com users. The new
domain will also contain a server named Certkingdom -SR11. The Microsoft CRM
environment will be retained but the Microsoft CRM 3.0 installations must be
deployed on Certkingdom -SR11.
You want to use the Microsoft CRM 3.0 Redeployment Wizard to redeploy the
Microsoft CRM 3.0 installation on Certkingdom -SR11.
What should you do?

A. Before using the Microsoft CRM 3.0 Redeployment Wizard, you must assign a
Microsoft CRM security role to each user account.
B. Before using the Microsoft CRM 3.0 Redeployment Wizard, you must install the
Microsoft CRM 3.0 Exchange E-mail Router on Certkingdom -SR11.
C. Before using the Microsoft CRM 3.0 Redeployment Wizard, you must ensure that the
DNS Server is accessible.
D. Before using the Microsoft CRM 3.0 Redeployment Wizard, you must create the new
user accounts.

Answer: D

QUESTION 4
You work as a CRM consultant at Certkingdom .com. Certkingdom .com has four
departments named Sales, Marketing, Finance and Research. Certkingdom .com users
in the Marketing department use portable client computers when making
presentations to prospective customers. Microsoft Office XP is installed on the
portable computers. No service pack has been applied to Microsoft Office XP.
The CEO at Certkingdom .com wants to implement the Microsoft CRM laptop client for
Certkingdom .com users in the Marketing department. You need to ensure that the users
in the Marketing department can use the Microsoft CRM laptop client.
What should you do?

A. Install Service Pack 1 for Microsoft Office XP on the portable computers.
B. Install Service Pack 2 for Microsoft Office XP on the portable computers.
C. Install Service Pack 3 for Microsoft Office XP on the portable computers.
D. None of the above.

Answer: C

QUESTION 5
You work as a CRM consultant at Certkingdom .com. Certkingdom .com has its
headquarters in New York and sales offices in Paris and Berlin.
You need to use the Microsoft CRM 3.0 Redeployment Wizard to redeploy data
from one version of CRM 3.0 to another.
What should you do? To answer, complete the following phrase:
You can redeploy data from _____.

A. a French version of Microsoft CRM 3.0 to another French version of Microsoft CRM 3.0
B. a French version of Microsoft CRM 3.0 to an International English version of Microsoft CRM 3.0
C. a German version of Microsoft CRM 3.0 to a French version of Microsoft CRM 3.0
D. an International English version of Microsoft CRM 3.0 to a French version of Microsoft CRM 3.0
E. an International English version of Microsoft CRM 3.0 to a German version of Microsoft CRM 3.0

Answer: A

QUESTION 6
You work as a CRM consultant at Certkingdom .com. The Certkingdom .com network
contains a server named Certkingdom -SR13. Microsoft CRM 3.0 is installed on
Certkingdom -SR13. Microsoft CRM 3.0 on Certkingdom -SR13 is configured to use
port 5452. A Certkingdom .com user named Andy Reid regularly connects to the
Microsoft CRM 3.0 on Certkingdom -SR13.
Whenever Andy Reid connects to the Microsoft CRM 3.0 on Certkingdom -SR13, he
must enter the URL "http:// Certkingdom -SR13:5452". He only wants to type http://CRM.
What should you do? (Choose TWO.)

A. Create a host header in IIS Manager.
B. Uninstall Microsoft CRM and then reinstall it and define a new application pool for
the new Microsoft CRM site
C. Run the Microsoft CRM setup program using the command line and specifying the
new name for the Microsoft CRM site
D. Create a DNS CNAME record for the host header, which points to Certkingdom -SR13.
E. Uninstall Microsoft CRM and then reinstall it and create a host header in IIS Manager.

Answer: A, D

QUESTION 7
You work as a CRM consultant at Certkingdom .com. The Certkingdom .com network
consists of a single Active Directory domain named Certkingdom .com. Certkingdom .com
consists of a Development department.
Certkingdom .com contains a server named Certkingdom -SR44. A Certkingdom .com
technician has installed Microsoft CRM on Certkingdom -SR44. The users in the
development department connect to the Microsoft CRM on Certkingdom -SR44, by
making use of the URL http://crm.
A Certkingdom .com user named Andy Booth is a member of the Development
department. Andy Booth works on a client computer named Certkingdom -WS421.
Andy Booth complains that he cannot connect to the Microsoft CRM on
Certkingdom -SR44. Whenever he connects to the Internet Explorer starts and then
immediately closes. Andy Booth needs to connect to the Microsoft CRM on
Certkingdom -SR44.
What should you do?

A. Configure Certkingdom -WS421 so that Updates are downloaded and installed automatically.
B. Configure Certkingdom -WS421 so that http://crm is included in rusted sites in the Internet Options.
C. Configure Certkingdom -WS421 to disable popup blocking, or enter http://crm in the popup blocker's exceptions list.
D. Configure Certkingdom -WS421 so that a network drive is mapped to \\: Certkingdom -SR44\crm, and then restart Internet Explorer.

Answer: C

QUESTION 8
You work as a CRM consultant at Certkingdom .com. The Certkingdom .com network
consists of a single Active Directory domain named Certkingdom .com. Certkingdom .com
consists of a Sales department, which corresponds to the client via e-mail.
You have received instruction from the CIO to add a queue in to the Microsoft
CRM that will display e-mail received into a Support mailbox.
What should you do? (Each answer presents part of the solution. Choose TWO.)

A. Create a new User account in Active Directory.
B. Create a new MSMQ Queue Alias in Active Directory.
C. Disable the account in Active Directory.
D. Disable a new MSMQ Queue Alias in Active Directory.

Answer: A, C

QUESTION 9
You work as a Microsoft CRM 3.0 specialist at Certkingdom .com. Certkingdom .com has its
headquarters in Chicago and a branch office in Dallas. Headquarters has 15 users
while each branch office has ten. The two offices are connected by permanent T1 network connections.
You need to plan the Microsoft CRM 3.0 deployment for Certkingdom .com. You need
to implement the minimum number of servers of each type that will be required for this deployment.
What should you do?

A. Implement one Internet Information Server (IIS) server and one SQL database server.
B. Implement one Internet Information Server (IIS) server and two SQL database servers.
C. Implement two Internet Information Server (IIS) server and one SQL database server.
D. Implement two Internet Information Server (IIS) server and two SQL database
servers.

Answer: A

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

70-506 Q & A / Study Guide

2012-01-24T03:56:00.000-08:00

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:

B. You should consider making use of the segment below:

C. You should consider making use of the segment below:

D. You should consider making use of the segment below:

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:

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:

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:

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

70-545 Q & A / Study Guide

2012-01-22T01:06:00.000-08:00

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

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

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

Answer: B

Explanation:

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

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

Answer: A,D

Explanation:

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

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

Answer: B

Explanation:

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

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

Answer: A,C

Explanation:

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

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

Answer: A,C,E

Explanation:

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

70-451 Q & A / Study Guide

2012-01-19T06:46:00.000-08:00

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

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

70-450 Q & A / Study Guide

2012-01-17T01:26:00.000-08:00

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:

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

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

2012-01-15T08:46:00.000-08:00

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

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

70-448 Q & A / Study Guide

2012-01-13T10:26:00.000-08:00

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:

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

Microsoft MB2-185 Q & A / Study Guide

2012-01-10T01:42:00.000-08:00

Exam Name: Microsoft CRM Customization v1.2
Exam Type: Microsoft
Exam Code: MB2-185

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

QUESTION 1
The object model, query processor, and metadata framework are main components of which
layer of Microsoft CRM architecture?

A. Database
B. Platform
C. Presentation
D. Application

Answer: B

QUESTION 2
Which layer in the Microsoft CRM architecture includes the Browser Client and Sales for Outlook
Client components?

A. Platform
B. Application
C. Database
D. Presentation

Answer: D

QUESTION 3
Communication between the application layer and the platform layer is accomplished using which
technology?

A. Remote Procedure Calls
B. HTTP Post Method
C. SOAP
D. Stored Procedure Calls

Answer: C

QUESTION 4
Which technology does the Microsoft CRM browser client use to present the user interface to
Internet Explorer?

A. XML
B. Generated Platform API
C. ASP.NET
D. Fetch Builder

Answer: C

QUESTION 5
Which layer or Microsoft CRM performs all security checks independent of the caller?

A. Application
B. Platform
C. Database
D. Presentation

Answer: B

QUESTION 6
Once you have created a workflow rule, what must you do to it before you can test it in Microsoft
CRM?

A. Using Server Manager, run the server task titled "WF 100_Publish_Rule" in order to
instantiate the workflow rule you created
B. Activate the rule
C. Publish the rule
D. Assign the rule to a business unit

Answer: B

QUESTION 7
Your business is interested in using Microsoft CRM Workflow to automate its business processes
and policies. Which types of processes can a company automate with Microsoft CRM Workflow?

A. A process triggered by an event in an unlinked third-party application
B. A process that specifies the steps a sales rep should go through to close a sale
C. A process that schedules an activity for a non-Microsoft CRM user and places it on his
Outlook calendar
D. A process that assigns a sales rep to an account

Answer: B, D

QUESTION 8
Which of the following can instantiate a workflow rule against a particular record?

A. A unit
B. An event
C. A code change
D. A manual 'Apply Rule' action

Answer: B, D

QUESTION 9
The Microsoft CRM Professional Edition includes which of the following Workflow tools?

A. Workflow Manager
B. Workflow Process Mapper
C. Workflow Monitor
D. Workflow Event Scheduler

Answer: A, C

QUESTION 10
Workflow Rules can be created for which of the following objects?

A. Accounts
B. Activities
C. Case
D. Lead

Answer: A, C, D

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

Microsoft - MB2-184 - Q & A/ Study Guide

2012-01-09T23:42:00.000-08:00

Microsoft CRM Installation and Configuration V.1.2
Microsoft - MB2-184

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

QUESTION 1
What business framework was Microsoft CRM developed upon that allows it to be integrated with
virtually any system in the world?

A. Windows NT4.0
B. Microsoft NET
C. Web Net
D. SQL Server 2000

Answer: B

QUESTION 2
The integration between Microsoft CRM and Microsoft Outlook uses which technology that allows
users of the Sales for Outlook Client to see their contacts, leads, activities, opportunities, tasks,
appointments, and e-mail?

A. MDAC 2.7a
B. Microsoft Message Queuing
C. XML Web Services
D. UDDI

Answer: C

QUESTION 3
Microsoft CRM Version 1.2 can be installed in both Windows Server 2000 and Windows Server
2003 environments. In either of these environments, how many Primary Domain Controllers are
installed in a single domain?

A. One Primary Domain Controller is always required
B. At least one Primary Domain Controller and as many Backup Domain Controllers as needed
C. None. All Domain Controllers are considered peers in both Windows Server 2000 and
Windows Server 2003 environments
D. None. Domain Controllers are not required in a Windows Server 2000 or Windows Server
2003 environment running Microsoft CRM

Answer: C

QUESTION 4
Which advantage does the Active Directory domain architecture provide for companies that have
deployed Microsoft CRM Version 1 .2 in a Windows Server 2003 domain?

A. It provides a single point of management for user accounts, computers, and applications in
the Windows Server 2003 domain
B. It meets the messaging and collaboration needs of small organizations, large distributed
enterprises and everything in between.
C. It enables structured data exchange and data transport
D. It enables an unprecedented level of software integration through the use of XML Web
Services.

Answer: A

QUESTION 5
Which technology allows Microsoft CRM to share data and invoke capabilities from other
applications without regard to how those applications were built, what operating system or
platform they run on, and what devices are used to access them?

A. Application Programming Interfaces
B. XML Web Services
C. UDDI
D. Microsoft Exchange

Answer: B

QUESTION 6
XML Web Services are invoked over the Internet by means of industry-standard protocols
including which of the following?

A. SOAP
B. ASP.NET
C. Microsoft NET
D. UDDI

Answer: A

QUESTION 7
Microsoft CRM is tightly integrated with which of the following technologies for the purpose of
validating access level security upon each user request?

A. SQL Server 2000
B. Active Directory
C. Internet Information Server (lIS)
D. Exchange Server 2000

Answer: B

QUESTION 8
Which software component must be installed on the same machine as your Exchange 2000
server(s) in order to enable the e-mail functionality of Microsoft CRM?

A. E-Mail Router
B. Deployment Manager
C. Outlook Rich Client
D. Workflow Monitor

Answer: A

QUESTION 9
Which technology render the web pages used by Microsoft CRM and allows organizations to host
and manage web pages on the Internet or on their internal intranet?

A. DHTML
B. XML Web Services
C. UDDI
D. IIIS

Answer: D

QUESTION 10
Microsoft CRM uses which of the following technologies to display its web forms via the browser
application?

A. XML Web Services
B. SOAP
C. ASP.NET
D. Open Database Connectivity (ODBC)

Answer: C

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

70-433 Q & A / Study Guide

2012-01-08T13:17:00.000-08:00

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:

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

70-432 Q & A / Study Guide

2012-01-07T01:21:00.000-08:00

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.

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

70-431 Q & A / Study Guide

2012-01-05T10:25:00.000-08:00

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

QUESTION 1
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows 2000 Server. The CertKingdom.com network contains a SQL Server 2000 database
server named CERTKINGDOM-DB01 that runs on Windows 2000 Server. CERTKINGDOM-DB01
contains a database named CKD_Sales.
CertKingdom.com intends migrating CERTKINGDOM-DB01 to SQL Server 2005 in the near future. To
prepare for the migration, you decide to install SQL Server 2005 Express on a server named
CERTKINGDOM-SR31. You verify that CERTKINGDOM-SR31 exceeds the minimum recommended
hardware requirements for SQL Server 2005.
What should you do next?

A. Upgrade CERTKINGDOM-SR31 to Windows Sever 2003 and install Service Pack 1.
B. Install and run the SQL Server Upgrade Advisor on CERTKINGDOM-SR31.
C. Install SQL Server 2000 on CERTKINGDOM-SR31.
D. Download and install the .NET Framework 2.0.

Answer: D

Explanation:
SQL Server 2005 requires the.NET Framework 2.0. This is automatically installed when SQL
Server 2005 is installed but is not automatically installed when SQL Server 2005 Express is installed.

Incorrect Answers:
A: You do not need to upgrade CERTKINGDOM-SR31 to Windows Sever 2003 Service Pack 1 as
SQL Server 2005 Express can be installed on Windows 2000 Server. You will need to install
Service Pack 4 for Windows 2000 Server though.
B: You should run the SQL Server Upgrade Advisor when you want to upgrade an instance of a
SQL Server 2000 database to SQL Server 2005.
C: You do not need to install SQL Server 2000 before installing SQL Server 2005 Express.

Reference: Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server
Express, before installing

QUESTION 2
You work as a database administrator at CertKingdom.com. The CertKingdom.com network consists of a
single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows Server 2003 with the latest Service Packs and Hotfixes, while the client computers
run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5.
You install SQL Server 2005 on a member server named CERTKINGDOM-SR21. CERTKINGDOMSR21
will host a database named CKD_Sales. All CertKingdom.com users must be able to connect to
CERTKINGDOM-SR21 by computer name. A CertKingdom.com network administrator named Rory Allen
must ensure that the client computers will be able to connect to CERTKINGDOM-SR21.
Which protocols can CertKingdom.com users use to CERTKINGDOM-SR21?

A. TCP/IP and Named Pipes
B. TCP/IP and IPX/SPX
C. Virtual Interface Adapter (VIA)
D. Shared Memory

Answer: A

Explanation:
By default, clients have TCP and Named Pipes as available protocols. You can manipulate the
protocol ordering by using the SQL Server Client utility. The client application uses the protocols
in the order specified on the client computer. If you are using SQL Server 2005, the protocol order
is stored in the ProtocolOrder registry entry under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
Incorrect Answers:
B: SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as
NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
C: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.
D: Shared Memory can only be used on the local computer and cannot be used as a network protocol.

Reference:Microsoft SQL Server 2005 Books Online (2006), Index: client connections
[SQL Server], about client network connections, choosing a network protocol

QUESTION 3
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows 2000 Server. The CertKingdom.com network contains a SQL Server 2000 database
server named CERTKINGDOM-DB01 that runs on Windows 2000 Server. CERTKINGDOM-DB01
contains a database named CKD_Sales.
CertKingdom.com intends migrating CERTKINGDOM-DB01 to SQL Server 2005 in the near future. To
prepare for the migration, you decide to install SQL Server 2005 Express on a server named
CERTKINGDOM-SR23. CERTKINGDOM-SR31 was used for previously used by application developer
and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You
verify that CERTKINGDOM-SR23 exceeds the minimum recommended hardware requirements for
SQL Server 2005.
What should you do next? (Each correct answer provides part of the solution. Choose THREE.)

A. Upgrade CERTKINGDOM-SR23 to Windows Sever 2003 and install Service Pack 1 for Windows Sever 2003.
B. Install Service Pack 4 for Windows 2000 Sever on CERTKINGDOM-SR23.
C. Upgrade the .NET Framework 1.2 to .NET Framework 2.0 on CERTKINGDOM-SR23.
D. Uninstall the .NET Framework 1.2 and install the .NET Framework 2.0 on CERTKINGDOM-SR23.
E. Upgrade Internet Explorer 5.5 to Internet Explorer 6.0 and install Service Pack 1 for Internet
Explorer 6.0 on CERTKINGDOM-SR23.
F. Upgrade Microsoft Visual Studio 2003 to Microsoft Visual Studio 2005 and install Service Pack
1 for Microsoft Visual Studio 2005 on CERTKINGDOM-SR23.

Answer: B,D,E

Explanation:
SQL Server 2005 requires Service Pack 4 for Windows 2000 Sever, Internet Explorer 6.0 with
Service Pack 1 and the .NET Framework 2.0. The .NET Framework 2.0 is automatically installed
with other versions of SQL Server 2005 but is not automatically installed with SQL Server 2005
Express. You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET
Framework 2.0 but .NET Framework 1.2 must be uninstalled first.
Incorrect Answers:
A: You do not need to upgrade CERTKINGDOM-SR31 to Windows Sever 2003 Service Pack 1 as
SQL Server 2005 Express can be installed on a Windows 2000 Server once you install Service
Pack 4 for Windows 2000 Server.
C: You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework
2.0 but .NET Framework 1.2 must be uninstalled first.
F: SQL Server 2005 Express does not require any version of Microsoft Visual Studio.
Reference:Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server
Express, before installing

QUESTION 4
You work as a database administrator at CertKingdom.com. The CertKingdom.com network consists of a
single Active Directory domain named CertKingdom.com.
You have received instruction from the CIO to prepare a new installation of SQL Server 2005. The
new SQL Server 2005 database server is named CERTKINGDOM-DB01. A CertKingdom.com user
named Mia Hamm is a member of the Marketing department. You instruct her to identify the
protocols that the client computers might use to connect to the server. Mia Hamm needs to identify
the protocols that are needed to accomplish this goal.
What should she identify? (Choose all that apply)

A. She should use the Multiprotocol.
B. Mia Hamm should use the Named Pipes.
C. She should use the Shared Memory.
D. She should use the TCP/IP
E. Mia Hamm should use the Virtual Interface Adapter (VIA).

Answer: B,D

Explanation:
The clients have by default TCP and Named Pipes as available protocols. You can make use of
the SQL Server Client utility to manipulate the protocol ordering. The client application uses the
protocols in the order specified on the client computer. When you make use of the SQL Server
2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry
subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
Incorrect Answers:
C: Shared Memory can only be used on the local computer and cannot be used as a network
protocol.
E: The Virtual Interface Adapter (VIA) can be used only by VIA hardware.Reference:Microsoft SQL
Server 2005 Books Online (2006), Index: client connections [SQL Server], about client network
connections, choosing a network protocol

QUESTION 5
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows 2000 Server. The CertKingdom.com network contains a SQL Server 2000 database
server named CERTKINGDOM-DB01 that runs on Windows 2000 Server Service Pack 4.
CERTKINGDOM-DB01 contains a database named CKD_Trading.
CertKingdom.com wants to migrate CERTKINGDOM-DB01 to SQL Server 2005 but wants to retain the
CKD_Trading database with the same instance name. You decide to perform an in-place upgrade to
SQL Server 2005. You verify that CERTKINGDOM-DB01 exceeds the minimum recommended
hardware requirements for SQL Server 2005.
What should you do next?

A. Upgrade CERTKINGDOM-DB01 to Windows Sever 2003 Service Pack 1.
B. Run the SQL Server Upgrade Advisor on CERTKINGDOM-DB01.
C. Detach the CKD_Trading database on CERTKINGDOM-DB01.
D. Run the SQL Server 2005 Setup utility.

Answer: B

Explanation:
Before you perform an in-place upgrade of an existing database, you should run the SQL Server
Upgrade Advisor. The SQL Server Upgrade Advisor produces a list of items that must be
addressed before and after performing the upgrade. This list of items is specific to the existing
installation.
Incorrect Answers:
A: You do not need to upgrade CERTKINGDOM-DB01 to Windows Sever 2003 Service Pack 1 as
SQL Server 2005 can be installed on Windows 2000 Server with Service Pack 4.
C: You need to detach a database when you need to move the database to another database
instance or another database server. You do not need to detach the database before performing
an in-place upgrade.
D: You should run the SQL Server Upgrade Advisor before you run the SQL Server 2005 Setup
utility. The SQL Server Upgrade Advisor produces a list of items that must be addressed before
and after performing the upgrade. This list of items is specific to the existing
installation.Reference:Microsoft SQL Server 2005 Books Online (2006), Index: updating
databases, detaching and attaching databases

QUESTION 6
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows 2000 Server. The CertKingdom.com network contains a SQL Server 7.0 database server
named CERTKINGDOM-DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000
Server id installed on CERTKINGDOM-DB01.
CertKingdom.com wants to migrate CERTKINGDOM-DB01 to SQL Server 2005. You decide to perform
an in-place upgrade to SQL Server 2005. You verify that CERTKINGDOM-DB01 exceeds the
recommended hardware requirements for SQL Server 2005.
What should you do next?

A. Upgrade CERTKINGDOM-DB01 to Windows Sever 2003.
B. Install Service Pack 4 for SQL Server 7.0 on CERTKINGDOM-DB01.
C. Upgrade SQL Server 7.0 on CERTKINGDOM-DB01 to SQL Server 2000.
D. Run the SQL Server 2005 Setup utility on CERTKINGDOM-DB01 and upgrade directly to SQL
Server 2005.

Answer: B

Explanation:
You can upgrade from SQL Server 7.0 with Service Pack 4 directly to SQL Server 2005. Thus you
need only install Service Pack 4 for SQL Server 7.0.
Incorrect Answers:
A: You do not need to upgrade CERTKINGDOM-DB01 to Windows Sever 2003 as SQL Server 2005
can be installed on Windows 2000 Server with Service Pack 4.
C: You do not need to upgrade CERTKINGDOM-DB01 to SQL Server 200 as SQL Server 7.0 with
Service Pack 4 can be upgraded directly to SQL Server 2005. Besides, you will need to install
Service Pack 3 for SQL Server 2000 before you can upgrade it to SQL Server 2005.
D: You need to install Service Pack 4 for SQL Server 7.0 before you can upgrade it directly to SQL
Server 2005.Reference:Microsoft SQL Server 2005 Books Online (2006), Index: upgrading SQL
Server, upgrading to SQL Server 2005

QUESTION 7
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows Server 2003 and all client computers run Windows XP Professional. The
CertKingdom.com network contains two SQL Server 2000 database servers named CERTKINGDOMDB01
and CERTKINGDOM-DB02 that are configured for log shipping. CERTKINGDOM-DB01 is the
primary server and hosts a database named CKD_Trading. Both CERTKINGDOM-DB01 and
CERTKINGDOM-DB02 have Service Pack 3 for SQL Server 2000 installed.
CertKingdom.com wants to upgrade CERTKINGDOM-DB01 and CERTKINGDOM-DB02 to SQL Server
2005 Enterprise Edition but the CKD_Trading database must remain available during the upgrade
process. You verify that both CERTKINGDOM-DB01 and CERTKINGDOM-DB02 exceed the
recommended hardware requirements for SQL Server 2005 Enterprise Edition. You then install
Service Pack 1 for Windows Server 2003 on CERTKINGDOM-DB01 and CERTKINGDOM-DB02.
What should you do next?

A. Install Service Pack 4 for SQL Server 2000 on both database servers.
B. Enable failover in the SQL Server 2000 log shipping configuration and upgrade CERTKINGDOMDB02
to SQL Server 2005.
C. Run the Database Maintenance Plan Wizard on CERTKINGDOM-DB01 to upgrade it to SQL
Server 2005.
D. Upgrade CERTKINGDOM-DB02 to SQL Server 2005 and then upgrade CERTKINGDOM-DB01 to
SQL Server 2005.

Answer: B

Explanation:
SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral to
log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL
Server 2000 log shipping configuration directly to SQL Server 2005. To upgrade log shipping to
SQL Server 2005, you must migrate the database servers to SQL Server 2005. If you want the
database to remain available during the migration process, you must migrate with failover. To
migrate with failover you must enable failover and upgrade CERTKINGDOM-DB02. Then you need
to failover to CERTKINGDOM-DB02 and upgrade CERTKINGDOM-DB01. Then configure log shipping
with the CERTKINGDOM-DB02 becoming the primary server and CERTKINGDOM-DB01 becoming the
secondary server.
Incorrect Answers:
A: You do not need to install Service Pack 4 for SQL Server 2000 on the database servers as SQL
Server 2000 with Service Pack 3 can be upgraded to SQL Server 2005. However, SQL Server
2005 does not support the Database Maintenance Plan Wizard which was integral to log shipping
in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL Server 2000
log shipping configuration directly to SQL Server 2005.
C: SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral
to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a
SQL Server 2000 log shipping configuration directly to SQL Server 2005.
D: Removing log shipping from CERTKINGDOM-DB02 and upgrading CERTKINGDOM-DB01 to SQL
Server 2005 will not ensure that the CKD_Trading database remains available. Reference:Microsoft
SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], upgrading

QUESTION 8
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run Windows Server 2003. The CertKingdom.com network contains a Domain Controller named
CERTKINGDOM-DC01 and a member server named CERTKINGDOM-SR21.
CertKingdom.com wants to implement a SQL Server 2005 database that will store sales data. All
CertKingdom.com users will require access to the Sales_DB database. You have been instructed to
install SQL Server 2005 on CERTKINGDOM-SR21 and to create a database named Sales_DB. You
need to ensure that CertKingdom.com users and applications can connect to the database instance by
using only the computer name.
What should you do during the installation of SQL Server 2005 on CERTKINGDOM-SR21?

A. Select the Named Instance and use MSSQLSERVER as the instance name.
B. Select the Named Instance and use CERTKINGDOM-DC01 as the instance name.
C. Select the Default Instance and accept the default instance name.
D. Select the Named Instance and use CERTKINGDOM-SR21 as the instance name.

Answer: C

Explanation:
To ensure that users and applications can connect to the instance using the computer name, you
should select the Default Instance and accept the default instance name, MSSQLSERVER.
Incorrect Answers:
A: You cannot use a Named Instance as users and applications will need to specify the server
name and the instance name when connection to the database.
B: You cannot use a Named Instance as users and applications will need to specify the server
name and the instance name when connection to the database.
D: You cannot use a Named Instance as users and applications will need to specify the server
name and the instance name when connection to the database.

QUESTION 9
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run on Windows Server2003 while the client computers run Windows XP Professional, Windows
98 Second Edition, and Novell NetWare 6.5. All computers are members of the CertKingdom.com
Active Directory domain. The CertKingdom.com network contains a SQL Server 2005 database server
named CERTKINGDOM-DB01 that hosts a database instance named MSSQLSERVR.
CertKingdom.com wants to implement another SQL Server 2005 instance for a database named
Sales_DB. Sales_DB will store sales data for the company. All CertKingdom.com users will require
access to the Sales_DB database. You have been instructed to create the SQL Server 2005
instance for the Sales_DB database. You need to ensure that all users will be able to connect to
the Sales_DB database. You cannot make configuration changes to the client computers. Your
solution must optimize network traffic.
What should you do?

A. Install the instance as a Named Instance and configure it to support Mixed Mode
Authentication. The enable TCP/IP for the instance.
B. Install the instance as a Default Instance and configure it to support Windows Authentication.
The enable TCP/IP for the instance.
C. Install the instance as a Named Instance and configure it to support SQL Authentication. The
enable IPX/SPX for the instance.
D. Install the instance as a Default Instance and configure it to support Windows Authentication.
The enable IPX/SPX for the instance.

Answer: A

Explanation:
The default instance is named MSSQLSERVER. This instance name is already in use; therefore
you should use a Named Instance. You should use Mixed Mode Authentication to support
NetWare users.
Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is
already in use. Furthermore, you need to use Mixed Mode Authentication as Windows
Authentication does not support NetWare users.
C: You can use SQL Authentication, but this will require that you create SQL Logins for all users
and groups. It would be easier to use Windows Authentication for clients that user Windows XP
Professional and Windows 98 SE, and create SQL Logins for the NetWare 6.5 users. Also, SQL
Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as NetWare 6.5,
support TCP/IP which makes it the common protocol for all clients.
D: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is
already in use. Furthermore, you need to use Mixed Mode Authentication as Windows
Authentication does not support NetWare users. Also, SQL Server 2005 does not support
IPX/SPX. The newer versions of NetWare, such as NetWare 6.5, support TCP/IP which makes it
the common protocol for all clients.

QUESTION 10
You work as the database administrator at CertKingdom.com. The CertKingdom.com network consists of
a single Active Directory domain named CertKingdom.com. All servers on the CertKingdom.com network
run on Windows Server2003 and all client computers run Windows XP Professional. The
CertKingdom.com network contains two SQL Server 2005 database servers that are configured in a
cluster with two nodes named NodeA and NodeB. NodeA hosts a default database instance
named MSSQLSERVR.
CertKingdom.com wants to implement another SQL Server 2005 instance for a database named
Sales_DB. Sales_DB will store sales data for the company. All CertKingdom.com users will require
access to the Sales_DB database. You have been instructed to create the SQL Server 2005
instance for the Sales_DB database on Node
A. You need to ensure that all users will be able to
connect to the Sales_DB database.
What should you do?

A. Run the SQL Server 2005 Setup utility on NodeA and select a Named Instance for the
Sales_DB database.
B. Run the SQL Server 2005 Setup utility on NodeA and select the Default Instance for the
Sales_DB database.
C. Move the existing instance from NodeA to NodeB. Run the SQL Server 2005 Setup utility on
Node
A. Select the Default Instance and accept the default instance name
D. Run the SQL Server 2005 Setup utility on NodeB and select a Named Instance for the
Sales_DB database.

Answer: A

Explanation:
The default instance is named MSSQLSERVER. This instance name is already in use on NodeA;
therefore you should use a Named Instance.
Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is
already in use.
C: You do not need to move the existing instance as you can install up to 50 instances on a SQL
Server 2005 database server.
D: You need to install the instance on NodeA not NodeB. You can install a new instance on
NodeA if you use a Named Instance.

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

70-642 Study Guide

2012-01-03T04:33:00.000-08:00

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

Table of Contents

Table of Contents................................................................................................................ 1

Course Overview ................................................................................................................ 3

Section 0.1: Introduction..................................................................................................... 5

Section 0.2: Server Management ........................................................................................ 6

Section 0.3: Remote Management ...................................................................................... 7

Section 0.4: Mathematical Foundations.............................................................................. 8

Section 1.1: IPv4 Addressing.............................................................................................. 9

Section 1.2: IPv4 Subnetting............................................................................................. 10

Section 1.3: IPv4 Host Configuration............................................................................... 11

Section 2.1: IPv6............................................................................................................... 12

Section 2.2: IPv6 Addressing............................................................................................ 13

Section 2.3: IPv6 Configuration ....................................................................................... 14

Section 2.4: IPv6 Implementation..................................................................................... 15

Section 3.1: DHCP Configuration .................................................................................... 16

Section 3.2: DHCP Options .............................................................................................. 17

Section 3.3: Advanced DHCPv4 Settings......................................................................... 18

Section 3.4: Server Placement .......................................................................................... 19

Section 3.5: Superscopes and Split Scopes....................................................................... 20

Section 3.6: DHCPv6........................................................................................................ 21

Section 4.1: DNS Concepts............................................................................................... 22

Section 4.2: Name Resolution........................................................................................... 23

Section 4.3: Zone Configuration....................................................................................... 24

Section 4.4: Active Directory-integrated Zones ............................................................... 25

Section 4.5: Resource Records ......................................................................................... 26

Section 4.6: Client Configuration ..................................................................................... 27

Section 4.7: Dynamic DNS............................................................................................... 28

Section 4.8: Stub Zones and Forwarding.......................................................................... 29

Section 4.9: Root Hints and Root Zone ............................................................................ 30

Section 4.10: Zone Delegation.......................................................................................... 31

Section 4.11: WINS and GlobalNames ............................................................................ 32

Section 4.12: DNS Features.............................................................................................. 33

Section 4.13: DNS Design ................................................................................................ 34

Section 5.1: Routing.......................................................................................................... 35

Section 5.2: RIP ................................................................................................................ 36

Section 5.3: Demand-dial Routing.................................................................................... 37

Section 5.4: ICS and NAT ................................................................................................ 38

Section 6.1: Remote Access Concepts.............................................................................. 39

Section 6.2: Dial-up and VPN .......................................................................................... 40

Section 6.3: SSTP ............................................................................................................. 41

Section 6.4: CMAK .......................................................................................................... 42

Section 7.1: Network Location Profiles............................................................................ 43

Section 7.2: Wireless ........................................................................................................ 44

Section 7.3: RADIUS........................................................................................................ 45

Section 7.4: Network Access Protection (NAP) ............................................................... 46

Section 7.5: Network Authentication................................................................................ 47

Section 7.6: Firewall ......................................................................................................... 48

Section 7.7: IPsec.............................................................................................................. 49

Section 8.1: File Services.................................................................................................. 50

Section 8.2: File Shares..................................................................................................... 51

Section 8.3: Offline Files .................................................................................................. 52

Section 8.4: NTFS Permissions ........................................................................................ 53

Section 8.5: Share and NTFS Permissions ....................................................................... 54

Section 8.6: EFS................................................................................................................ 55

Section 8.7: Distributed File System (DFS) ..................................................................... 56

Section 8.8: Shadow Copy................................................................................................ 57

Section 8.9: Backup and Restore ...................................................................................... 58

Section 8.10: Disk Quotas................................................................................................. 59

Section 8.11: FSRM Features ........................................................................................... 60

Section 8.12: Print Services .............................................................................................. 61

Section 9.1: WSUS ........................................................................................................... 62

Section 9.2: Client Configuration ..................................................................................... 63

Section 9.3: MBSA ........................................................................................................... 64

Section 10.1: Reliability and Performance Monitor ......................................................... 65

Section 10.2: Event Viewer .............................................................................................. 66

Section 10.3: Network Monitor ........................................................................................ 67

Section 10.4: SNMP.......................................................................................................... 68

Practice Exams.................................................................................................................. 69

Course Overview

This course prepares students for the 70-642 Technology Specialist exam: Windows Server 2008 Network Infrastructure, Configuring. It focuses on the details of configuring the infrastructure of a network.

Module 0 – Introduction
This module introduces Microsoft’s recommendations of the technical experience a candidate should have before attempting the certification test. Students will become familiar with server and remote management tools. This module provides the mathematical calculations of how to convert numbers from binary to decimal and hexadecimal. This mathematical foundation is necessary for students to understand the IPv4 and IPv6 addresses they will be studying in the course.

Module 1 – IPv4
This module discusses the details of configuring IPv4 addressing and subnetting. This includes topics of converting IPv4 addresses from binary to decimal, converting subnet masks to slant notation, identifying Ipv4 classes and ranges of IP addresses, and determining local and non-local hosts. Students will learn how to customize the number of subnets and hosts allowed on each subnet.

Module 2 – IPv6
In this module students will learn why it will become necessary to migrate to IPv6. They will learn the basic format of IPv6 addresses, identifying IPv6 address types, and configuring IPv6 addresses using the GUI and command line. Interoperability strategies for implementing IPv4 and IPv6 are explored.

Module 3 – DHCP
This module covers DHCP configuration, customization options, and advanced settings. Students will learn proper server placement to assure client communication with the DHCP server, the rationale for creating superscopes and split scopes, and DHCPv6 options.

Module 4 – DNS
In Module 4 students will learn the details of how DNS translates host names to IP addresses and the process of DNS name resolution for both the client and server. Topics will also include; creating zone and zone transfers, creating or converting an Active Directory-integrated zone, creating and editing resource records, configuring client registration, automatically updating DNS using Dynamic DNS, resolving queries using stub zones and forwarding, using root hints and a root zone, managing zones through zone delegation, creating WINS-integrated zones and GlobalNames zones support, and implementing strategies and goals when designing a DNS solution.

Module 5 – Routing
Module 5 teaches the students the basics of routing and how to manage routing table entries. Students will become familiar with installing RRAS components, and configuring RIP, demand-dial routing, and NAT solutions.

Module 6 – Remote Access
Module 6 discusses the details of configuring remote access and network authentication. Topics include; configuring a Remote Access server to use Dial-up and VPN connections, configuring client connections, configuring a VPN using SSTP, and using CMAK to manage remote access.

Module 7 – Network Access and Security
In Module 7 students will learn several strategies for controlling network access and enhancing network security. These will include: controlling network location profiles, configuring wireless connection, configuring a RADIUS client, server and proxy, configuring a DHCP server as an enforcement point, enforcing network authentication using Kerberos and NTLM, configuring a firewall, and configuring IPsec to protect IP packets during transmission.

Module 8 – File and Print
This module discusses managing network files and printing. Topics include: managing network file sharing and shared folders, controlling access using NTFS and share permissions, encrypting files and folders, protecting integrity of data through shadow copy, and backup and restore, restricting disk space using disk quotas and FSRM, and managing print services.

Module 9 – WSUS
In this module students will learn how to configure a WSUS server and client to manage the updating of software. They will also learn how to use MBSA to scan for security compliance.

Module 10 – Performance and Reliability
This module covers tools that are used to collect and monitor network data for performance and reliability. The Reliability and Performance Monitor provides network performance statistics. Event Viewer is used to monitor event logs. Network Monitor is used to gather information about network traffic. SNMP is used to manage networkattached devices.

Practice Exams In Practice Exams students will have the opportunity to test themselves and verify that they understand the concepts and are ready to take the certification test.

Section 0.1: Introduction

Preparation
This course prepares students for the 70-642 Technology Specialist exam: Windows Server 2008 Network Infrastructure, Configuring. Microsoft recommends at least one year experience in the following underlying technologies:
• IP addressing and services
• Names resolution
• File and print services
• Network access and remote access
• Monitoring network services

This section introduces the instructor and the concepts that will be covered in this course.

Time

About 2 minutes

Section 0.2: Server Management

Preparation
This section discusses a new management console, Server Manager, used to install and manage server components. Server Manager uses the following elements:
• Role
• Role services
• Feature

Server Core, a scaled-down version of Server 2008, provides a reduced foot print, reduced maintenance, less crashes and downtimes, and uses less disk space. To provide these benefits a limited set of server roles are supported. Student will learn how to configure and manage a server using Server Manager. They will also learn how to install roles on a Server Core server.

Configuring Server 2008 Network Infrastructure Objectives
• 102. Configure Dynamic Host Configuration Protocol (DHCP)
• 201. Configure a Domain Name System (DNS) server.

Lecture Focus Questions:
• What are the differences among roles, role services, and features?
• How are dependencies handled during role installation?
• How does the server core installation differ from a standard server installation?
• What are the limitations of a server core installation? What are the advantages?

Time
About 20 minutes

Section 0.3: Remote Management

Preparation

This section examines remote management options. Students will learn how to enable Remote Desktop on a Server Core, enable remote management of the firewall, and open firewall ports to allow remote use of MMC snap-ins.

Lecture Focus Questions:
• How do firewall ports affect your ability to remotely manage a server?
• What firewall port must be opened for Remote Desktop connections?
• What advantage does using TS Gateway have over using Remote

Desktop?
• What is the effect of enabling the Remote Administration exception in the firewall?
• What are the operating system requirements for RSAT?
• Which remote administration tools could you use if the firewall had only ports 80 and 443 open?

Time
About 25 minutes

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

70-294 Q & A / Study Guide

2012-01-02T01:49:00.000-08:00

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

QUESTION 1
You work as the IT Admin at Certkingdom.com. The Certkingdom.com network has a forest that operates at the
forest functional level of Windows Server 2003. The forest has a root domain named Certkingdom.com,
and two child domains named north.Certkingdom.com and south.Certkingdom.com. Each domain has a security
group named Research which holds the user accounts for that domain.
Two domain controllers are situated in each of these domains. One domain controller in each
domain hosts a copy of the global catalog.
The global catalog server in the Certkingdom.com domain holds the domain naming and the schema
master roles. The global catalog server in north.Certkingdom.com and south.Certkingdom.com holds the relative
ID (RID), infrastructure, and PDC emulator master roles.
A Certkingdom.com user named Ally Wagner, in the south.Certkingdom.com domain, was recently married. When
Ally Wagner got back, she asked you to change her surname in her user account. After changing
Ally Wagner’s user account to Ally Hamm, you notice that her user account is still incorrectly
specified as Ally Wagner in the Research group.
Which of the following master roles should you move to the domain controller that does not have
the Global Catalog in each domain?

A. The domain naming master role.
B. The infrastructure master role.
C. The RID master role.
D. The schema master role.
E. The PDC emulator master role.

Answer: B

Explanation: Problems like this can occur when the Infrastructure master role is on the same
domain controller as the Global Catalog. The infrastructure master updates the group-to-user
reference whenever group memberships change and replicates these changes across the domain.
The infrastructure master compares its data with that of a global catalog. Global catalogs receive
regular updates for objects in all domains through replication, so the global catalog data will
always be up to date. If the infrastructure master finds that its data is out of date, it requests the
updated data from a global catalog. The infrastructure master then replicates that updated data to
the other domain controllers in the domain.
Unless there is only one domain controller in the domain, the infrastructure master role should not
be assigned to the domain controller that is hosting the global catalog. If the infrastructure master
and global catalog are on the same domain controller, the infrastructure master will not function.
The infrastructure master will never find data that is out of date, so it will never replicate any
changes to the other domain controllers in the domain. Transferring the Infrastructure master role
to a different computer would resolve this problem. There is no reason to transfer any other master
roles.
Reference:
Michael Cross, Jeffery
A. Martin, Todd
A. Walls, Martin Grasdal, Debra Littlejohn Shinder & Dr.
Thomas W. Shinder, MCSE: Exam 70-294: Planning, Implementing, and Maintaining a Windows
Server 2003 Active Directory Infrastructure Study Guide & DVD Training System, Syngress
Publishing, Rockland, MA, 2003, pp. 505-509.

QUESTION 2
You work as the IT Network Admin at Certkingdom.com. The Certkingdom.com network has a forest with two child
domains named us.Certkingdom.com and uk.Certkingdom.com. All servers and domain controllers on the
Certkingdom.com network have Windows 2000 Server installed.
You have been given the task to uABCrade the domain controllers in uk.Certkingdom.com to Windows
Server 2003. You therefore need to take the appropriate steps that are required to prepare the
forest for the impending deployment.
Which of the following actions should you take?
Answer by selecting the appropriate steps from the column on the left and place it in the correct
order in the column on the left.

Answer:

QUESTION 3
You work as the IT Admin at Certkingdom.com. The Certkingdom.com network has a domain named Certkingdom.com.
Certkingdom.com has offices in London and Berlin, which are configured as separate sites.
A Backup of Certkingdom.com’s Ntds.dit file is performed outside of business hours, seven days a week.
The domain has an OU named Research that currently holds no Active Directory objects. During
the course of the business day an administrator in Berlin removes the Research OU, while an
administrator in London simultaneously places existing Active Directory objects in it. The London
administrator is later informed of the removal, and now realizes that the objects that were placed
into the Research OU are missing.
The CIO has subsequently instructed you to make sure that a Research OU and the missing
Active Directory objects are available to the London administrator. The CIO also informs you that
your solution should have no impact on network connectivity and resources. You have already
created a new OU, and named it Research.
Which of the following actions should you take NEXT?

A. You should transfer the objects from the LostAndFound container to the new Research OU
B. You should recreate the objects and then place the replicas in a Domain Group Policy that
should be linked to all OUs.
C. You should restore the objects to the new Research OU nonauthoritatively.
D. You should restore the objects to the new Research OU authoritatively.

Answer: A

Explanation: You moved the objects to an OU that had just been deleted. When you move
objects to an object that is no longer there, the objects get moved to the LostAndFound container.
This means that we haven’t lost the objects, so we can just re-create the Research OU and move
the users from the LostAndFound container to the new OU.
Reference:
Michael Cross, Jeffery
A. Martin, Todd
A. Walls, Martin Grasdal, Debra Littlejohn Shinder & Dr.
Thomas W. Shinder, MCSE: Exam 70-294: Planning, Implementing, and Maintaining a Windows
Server 2003 Active Directory Infrastructure Study Guide & DVD Training System, Syngress
Publishing, Rockland, MA, 2003, pp. 38-39, 99-101

QUESTION 4
You work as a IT Admin at Certkingdom.com. Certkingdom.com has its headquarters located in Dallas and branch
division in Miami. The Dallas and Miami division represent separate sites. The Dallas and Miami
divisions are linked to each other via a WAN link.
You have added a domain controller named ABC-SR01 to the Miami division and configured it as
a global catalog server. You have just completed configuring the site link between the Dallas and
Miami divisions.
The CIO at Certkingdom.com has instructed you to make sure that Miami workstations authenticate to the
network via ABC-SR01. The CIO also informs you that the replication of domain changes has to
happen instantaneously.
Which of the following actions should you take?

A. You should reduce the site link interval.
B. You should reduce the site link cost.
C. You should combine the Dallas and Miami sites into a single site
D. You should increase the site link cost.

Answer: A

Explanation:

QUESTION 5
You work as the IT Admin at Certkingdom.com. The Certkingdom.com network has a domain named Certkingdom.com. All
servers on the Certkingdom.com network have Windows Server 2003 installed and all workstations have
Windows XP Professional installed.
Certkingdom.com is made up of four divisions named Sales, Marketing, Finance and Research. The
Certkingdom.com network has an organizational unit (OU) named after each division that holds the user
accounts of all employees working in that specific division.
You need to install a new application for all employees in the Marketing division. You start by
creating an installation package and a Group Policy object (GPO). You plan to make use of the
new GPO to deploy the package to the workstations in the Marketing division. You therefore
connect the GPO to the Marketing OU. However, the application does not install.
The CIO informs you that the application must be installed and that you should make sure that
marketing application is not installed on workstations in the other Certkingdom.com divisions.
How will you accomplish the task?

A. Advise the Marketing users to reboot their workstations.
B. Edit the GPO and assign the application to user accounts with Marketing OU membership.
C. Connect the GPO to the Certkingdom.com domain.
D. Connect the GPO to the OU that contains computer accounts and not the Marketing OU.

Answer: B

Explanation: It is likely that the application was assigned to the computer accounts, rather than
the user accounts.
Reference:
Jill Spealman, Kurt Hudson & Melissa Craft, MCSE Self-Paced Training Kit (Exam 70-294);
Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory
Infrastructure, Microsoft Press, Redmond, Washington, 2004, pp. 12-3 to 12-10, 12-13 to 12-28,
12-34 to 12-39

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

70-284 Q & A / Study Guide

2011-12-31T04:55:00.000-08:00

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

QUESTION 1
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Active
Directory domain named Certkingdom.com.
The Certkingdom.com Exchange organization contains two Exchange Server 2003 computers named
ABC-SR11 and ABC-SR12 respectively. ABC-SR11 is configured as the mailbox server and ABCSR12
is configured as the front-end server. ABC-SR12 has Microsoft Outlook Web Access over
SSL installed to allow Certkingdom.com employees to access their e-mail.
The Certkingdom.com intranet is connected to the Internet via a firewall. When several employees
complain that they are unable to access ABC-SR12, you investigate the issue and find that
employees are able to access Outlook Web Access using HTTP or HTTPS.
You have been instructed to make sure that the Certkingdom.com employees are only able to use HTTPS
to access Outlook Web Access.
Which of the following actions should you take?

A. You should reconfigure the firewall to allow Certkingdom.com employees to access port 443 on ABCSR12,
and then configure the default Web site on ABC-SR12 to require SSL connections.
B. You should reconfigure the firewall to allow Certkingdom.com employees to access port 80 on ABCSR12,
and then configure the default Web site on ABC-SR12 to use port 443 for SSL connections.
C. You should reconfigure the firewall to allow Certkingdom.com employees to access port 993 on ABCSR12,
and then configure the default Web site on ABC-SR12 to require SSL connections and 128-
bit encryption.
D. You should reconfigure the firewall to allow Certkingdom.com employees to access port 143 on ABCSR12,
and then configure the Exchange HTTP virtual server on ABC-SR12 to enable forms-based
authentication for Outlook Web Access.

Answer: A

Explanation: SSL utilizes port 443. The external firewall does not currently allow traffic on port
443 to pass. Opening up this port will take care of that issue. The default OWA site is currently not
correctly setup to use HTTPS. This is why internal clients can connect to OWA using HTTP.
Modifying the security on the OWA web site will solve this problem.
Reference:
MS white paper Exchange Server 2003 RPC over HTTP Deployment Scenarios
MS white paper Exchange Server 2003 Client Access Guide
MS white paper Exchange 2003 Front-End Back-End Topology

QUESTION 2
You work as the network Exchange administrator at Certkingdom.com, who has their headquarters located
in Miami. The Certkingdom.com network has an Active Directory domain named Certkingdom.com. All servers on
the Certkingdom.com network run Windows Server 2003 and all client computers run Windows XP
Professional.
The Certkingdom.com network includes a server named ABC-EX01, which runs Microsoft Exchange
Server 2003.
Certkingdom.com recently entered into partnership with Weyland Industries, who has their office located in
Toronto. Part of the network in the Toronto office is configured as an Active Directory site within
the Certkingdom.com domain. A server named ABC-EX02 is configured to run Microsoft Exchange Server
2003 and located in the Toronto office. The two Exchange servers are configured in separate
routing groups connected via a routing group connector. The Toronto and Miami offices are
connected to each other via a leased line connection.
You receive instruction from Certkingdom.com to configure an ISDN-dialup connection as a backup
connection in the event that the leased line connection becomes unavailable.
During the course of your maintenance you discover that the ISDN dial-up connection is not used
as a backup connection, but is used exclusively by the routing group connector.
Certkingdom.com wants you to make sure that the leased line connection is used as the primary
connection, and that the ISDN connection is used only if the leased line connection fails.
Which of the following actions should you take?

A. You should configure ABC-EX01 and ABC-EX02 to be in the same Active Directory site.
B. You should configure ABC-EX01 and ABC-EX02 to be in the same routing group.
C. You should have a lower IP route cost assigned to the ISDN link and a higher link cost to the
leased line link.
D. You should configure ABC-EX02 to use ABC-EX01 as a smart host.
E. You should have a lower IP route cost assigned to the leased line link and a higher link cost to
the ISDN link.

Answer: E

Explanation: It is possible that the administrator reversed the values of the cost on the
connections because IP route costs are used to set the preference levels between two routes to
the same destination.

QUESTION 3
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Active
Directory domain named Certkingdom.com. Certkingdom.com employs Exchange Server 2003 as its messaging
system. All servers on the Certkingdom.com network run Windows Sever 2003 and all Exchange servers
run Exchange Server 2003.
The Exchange organization contains an Exchange server named ABC-SR31, which is used to
pass SMTP e-mail messages between Certkingdom.com and the Internet and also stores the mailboxes of
all Certkingdom.com’s employees. The intranet is connected to the Internet via a firewall.
When several employees complain that they continuously receive numerous unwanted e-mail
messages, you investigate the issue and find that the unwanted e-mail messages received by
Certkingdom.com’s employees are the same. You also notice that the messages are being sent to a
universal distribution group in the Certkingdom.com domain.
You must configure the network so that distribution groups are prevented from sending e-mail
messages from the Internet to the Certkingdom.com users. Your solution must enable the Certkingdom.com users
to continue to send and receive legitimate e-mail messages.
Which of the following is the best solution?

A. You should consider having the universal distribution groups converted to Domain Local
Distribution groups.
B. You should consider having the Exchange Attributes removed from the universal distribution
groups.
C. You should consider having the distribution groups configured to only permit e-mail messages
from authenticated users.
D. You should consider having the membership of the universal distribution groups hidden.

Answer: C

Explanation: Your best option in this scenario would be to select Option C. The universal group is
used for mail distribution in your organization. You can configure the distribution group to accept
mail from authenticate users only to stop receiving spam.
Incorrect answers
A: Converting the universal groups to domain local security groups on its own will not protect you
against unsolicited mail. The security groups will still receive email
B: Removing the Exchange Attributes will remove the email address which would prevent
Certkingdom.com users from sending email to the groups.
D: Hiding the group membership will not protect you against unsolicited mail. The groups will still
receive email.
Reference:
MS white paper Exchange Server 2003 RPC over HTTP Deployment Scenarios
MS white paper Exchange Server 2003 Client Access Guide
MS white paper Exchange 2003 Front-End Back-End Topology
MS white paper Exchange Server 2003 Message Security Guide
MS white paper Microsoft Exchange Intelligent Message Filter Deployment Guide

QUESTION 4
You work as the network Exchange administrator at Certkingdom.com. The Certkingdom.com network has an
Active Directory domain named Certkingdom.com. All servers on the Certkingdom.com network have Windows
Server 2003 installed and all workstations have Windows XP Professional installed.
The Certkingdom.com network contains an Exchange 2003 server named ABC-EX01, which hosts
thousands of mailboxes in a single storage group. ABC-EX01 is equipped with a single RAID-5
device, which is configured as a single logical drive. ABC-EX01 is additionally equipped with a
high-end CPU and has a 2GB of RAM.
During the course of the day the Certkingdom.com network users with mailboxes hosted on ABC-EX01
complain that at times of peak usage their email-services become considerably slower and it takes
longer for messages to be sent and opened using Microsoft Outlook. You have recently received
instruction from the Certkingdom.com network CIO to monitor the performance and you receive the values
shown in the following exhibit:

You are required to improve the performance of e-mail for the network Exchange users on ABCEX01.
What should you do?

A. You should consider having a full-text index created on the mailbox store
B. You should consider having a new volume created on the existing RAID-5 device and move the
Exchange transaction logs to the new volume
C. You should consider having a new RAID device added and the Exchange transaction logs
moved to the new device
D. You should consider installing additional RAM
E. You should consider installing an additional processor

Answer: C

Explanation: The performance results indicate that the hard disk usage is very high and the other
counter values are within acceptable limits. All changes to the Exchange databases are recorded
first in the transaction logs.

QUESTION 5
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com Exchange organization has
includes a solitary server named ABC-EX01 that has Exchange Server 2003 installed. All
Certkingdom.com users make use of Microsoft Outlook to send and receive e-mail messages.
ABC-EX01 is equipped with dual CPUs and 2 GB Random Access Memory (RAM). ABC-EX01 is
configured to host a storage group that contains one mailbox store.
You receive reports that opening Outlook takes too long, and that every e-mail message being
sent or opened takes too long. You monitor the ABC-EX01 and find that the inadequate RAM
results in the primary bottleneck, which then results in sluggish performance. You, therefore,
increase ABC-EX01’s RAM to 4 GB RAM. However, the Certkingdom.com users continue to report
sluggish Outlook performance.
Which of the following actions should you take to improve ABC-EX01’s performance?

A. You should increase the size of the virtual memory to 6GB.
B. You should place an additional switch that increases user mode memory usage to the Boot.ini
file in the mailbox servers.
C. You should increase the priority of the store.exe process in Task Manager.
D. You should set up an additional mailbox store on the server. Then divide the existing mailboxes
between the old and the new mailbox store.

Answer: B

Explanation: If you have more than 1 GB of physical memory installed on a server that is running
Exchange Server 2003, you must make sure that Exchange Server 2003 can make efficient use of
that memory.
If you are running Exchange Server 2003 on a Windows Server 2003-based computer, and if the
/3GB switch is set, Microsoft recommends that you set the /USERVA=3030 parameter in the
Boot.ini file. This configuration option increases the virtual address space.

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

70-272 Q & A / Study Guide

2011-12-30T01:01:00.000-08:00

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

QUESTION 1
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Microsoft
Windows XP Professional SP2.
Certkingdom.com has a Marketing and Finance division which requires using Microsoft Office XP to
perform their daily duties.
How would you instruct the Marketing and Finance user’s to run the Microsoft Office XP setup if
the setup fails and rolls backup without changing the user’s currently assigned privileges?

A. By adding the Marketing and Finance division to the Network Configuration Operators group
and accessing Microsoft Office Product Updates to scan the computer for updates.
B. By adding the Marketing and Finance division to the Power Users group and using Add or
Remove Programs in Control Panel to remove Office and re-install Microsoft Office XP.
C. By creating a remote connection to the Marketing and Finance group client computers and reinstalling
Microsoft Office XP using a network-based installation point with the required .msi file.
D. By adding the Marketing and Finance division to the local Administrators group and restarting
the browser and Workstation services before re-installing Microsoft Office XP from the Windows
Installer command-line utility.

Answer: C

Explanation: To try to recreate the error you have to run the installation in the users’ privileges so
running the installation on your computer with your privileges will not help you to solve the problem
(answer B and D). Visiting the Microsoft Office Product Updates Web site will not help the user in
any way as long as he doesn’t have Microsoft Office installed on his computer.

QUESTION 2
You work as the desktop support technician at Certkingdom.com. Certkingdom.com has a domain named
Certkingdom.com. All servers on the Certkingdom.com network run Windows 2000 Server and all client computers
run Microsoft Windows XP Professional SP2.
Certkingdom.com has a Marketing division which uses Microsoft Office 2003 for their daily duties. During
the course of the day Marketing division users reported that certain files of theirs have been deleted.
How would you configure the Marketing division client computers to track any attempts by
malicious users to alter or delete files on their computers?

A. By running the secedit /analyze command on the client computers.
B. By running the secedit /configure command on the client computers.
C. By configuring security access control lists for their disk drives by auditing the Everyone group
on the client computers.
D. By running the secedit /validate command on the client computers.

Answer: C

Explanation: You must track unauthorized attempts to modify or delete the files so auditing the
Everyone group is the correct choice.

QUESTION 3
You work as a desktop adminsitrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers run Microsoft Windows 2000 server and the client computers run Microsoft Windows XP Professional.
Certkingdom.com has a Marketing division which makes online purchases during work hours.
How would you configure the network firewall to stop these activities whilst allowing the Marketing
division to access the Internet?

A. By having port 110 blocked on the firewall.
B. By having port 443 blocked on the firewall.
C. By having port 143 blocked on the firewall.
D. By having port 21 blocked on the firewall.

Answer: B

Explanation: Port 443 is used for Secure Sockets Layer connections to Secure HTTP Web sites.
This port should be blocked.

QUESTION 4
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Windows XP Professional.
Certkingdom.com has a Finance division which uses Microsoft Office XP to perform their daily tasks.
How would you configure Microsoft Office XP to ensure opened documents display’s a toolbar
containing the Balloons button?

A. By accessing the Help menu and selecting the Detect and Repair… option.
B. By right-clicking the toolbar and selecting the Reviewing toolbar from the context menu.
C. By re-installing Microsoft Office XP and copying a Normal.dot file from the administrator’s
computer to the My Documents folder.
D. By accessing the tools menu from another user’s document and accessing the Tools menu to
select Shared Workspace.

Answer: B

Explanation: The Balloons button appears on the Reviewing Toolbar. Simply enabling this toolbar
will show this button. To enable the toolbar, right click any open spot in the toolbar area. From the
dropdown list, click Reviewing.

QUESTION 5
You work as a network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows 2000 Server and all client computers run Windows
XP Professional SP2.
Certkingdom.com has a Finance division that has a client computer named ABC-WS272. The Finance
division requires the use of a printer. You attach a printer to ABC-WS272 and enable Print Shared.
You then print a test page. However, other users in the Finance division cannot find the printer on the network.
How would you configure ABC-WS272?

A. By using a Group Policy Object GPO which deploys the printer software to the Finance division.
B. By opening Windows Firewall and configuring ICMP options.
C. By enabling the File and Printer Sharing option on the Exception tab of the Windows Firewall.
D. By configuring Windows Firewall to have the Don’t allow exceptions option enabled.

Answer: C

Explanation: If the File and Printer Sharing is not enabled, the incoming request will be blocked
by the Windows Firewall.

QUESTION 6
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Windows
XP Professional SP2. Certkingdom.com has a client computer named ABC-WS272 configured with
Microsoft Outlook Express.
Certkingdom.com has a Marketing division which uses Microsoft Outlook Express to send e-mail.
How would you configure Microsoft Outlook Express to ensure the users are able to open saved email
messages when opening Microsoft Outlook Express?

A. By disabling AutoArchive.
B. By importing .zip files.
C. By importing .pst files.
D. By importing .bdx files.

Answer: D

Explanation: The probable cause for this problem is that the user is not loading his dbx files when
Outlook Express launches. This is usually due to the user moving the dbx files, and Outlook
Express can no longer find them.

QUESTION 7
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Windows
XP Professional. Certkingdom.com has a client computer named ABC-WS272 configured with Microsoft Internet Explorer.
Certkingdom.com has a Finance division with several employees who use ABC-WS272 to perform their daily tasks.
How would you configure ABC-WS272’s Internet Explorer to make sure that each user has their
own Favorites list?

A. By having a user profile created for each Finance division member using the computer.
B. By having a Microsoft Outlook Express identity created for Finance division members using the computer.
C. By having an Internet Explorer Address book identity created for Finance division members using the computer.
D. By having separate Favorites folder created under the My Documents folder for Finance division members using the computer.

Answer: A

Explanation: The user favorites list keeps changing. You must make sure for the user. Creating a
user profile for each family member will stop this change from happening.

QUESTION 8
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers run Windows Server 2003 and all client computers run Windows XP Professional.
Certkingdom.com has its headquarters in Chicago and a Marketing and Finance division in Boston. You
are in Chicago and use a client computer named ABC-WS272. The Marketing and Finance
division has a client computer named ABC-WS274. Both ABC-WS272 and ABC-WS274 utilizes
manual IP address configuration and ISDN lines to access the Internet.
How can you utilize ABC-WS272 to control ABC-WS274 using Remote Desktop without disrupting
Internet connectivity?

A. By having ABC-WS272 configured with an Internet Connection Sharing (ICS) enabled after
placing ABC-WS272’s domain user account to Remote Desktop Users group on ABC-WS274.
B. By having ABC-WS272 configured with an Internet Connection Firewall (ICF) enabled with
Remote Desktop option in the Internet Connection Firewall (ICF) services enabled on ABCWS274.
C. By having ABC-WS272 configured with an Internet Connection Sharing (ICS) enabled and
enabling Internet Connection Firewall (ICF) on ABC-WS274.
D. By having ABC-WS274 configured with an Internet Connection Sharing (ICS) enabled after
placing ABC-WS274’s domain user account to Remote Desktop Users group on ABC-WS272.

Answer: B

Explanation: To keep the home computer secure you should start by enabling the ICF. By default
if you're running Windows XP Service Pack 2 (SP2) and you enable Remote Desktop, Windows
Firewall will be automatically configured to allow Remote Desktop connections to your computer. If
you or someone else has removed the Remote Desktop exception then you’ll have to manually
add it by open the Security Center, click Windows Firewall and click the Exceptions tab, and select
Remote Desktop.

QUESTION 9
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Windows
XP Professional. Certkingdom.com has a client computer named ABC-WS272 configured with Microsoft
Outlook Express.
Certkingdom.com has a Marketing division which needs to sends e-mail to Arabic clients.
How would you configure ABC-WS272 to ensure the Marketing division members are able to
compose an e-mail message in the Arabic character set?

A. By downloading the foreign language version of Microsoft Outlook Express and install the software.
B. By having the Windows XP language pack for the foreign language required downloaded and installed.
C. By accessing Regional and Language option in Control Panel and select the foreign character set required.
D. By accessing the Microsoft Outlook Express View menu to select Auto Encoding.

Answer: B

Explanation: From Start menu, select Settings then Control Panel, Start Regional Options, Click
on Languages tab, In Supplemental language support box, check the checkboxes of desired
language collection(s) and click OK, Additional files will be copied to your machine. You may need
to provide the Windows XP CD or the network share name, After reboot, support for new
languages will become available.

QUESTION 10
You work as the network administrator at Certkingdom.com. Certkingdom.com has a domain named Certkingdom.com. All
servers on the Certkingdom.com network run Windows Server 2003 and all client computers run Windows
XP Professional. Certkingdom.com has a computer named ABC-SR01 configured as the VPN server using
IPSec connections.
Certkingdom.com has a Marketing division which uses ABC-SR01 using a L2TP connection. During the
course of the day the Marketing division state the L2TP connection has failed.
How would you configure the connection used to ensure that the Marketing division is able to
access ABC-SR01?

A. By configuring the connection type to PPTP VPN.
B. By configuring the connection to use the Public Key Infrastructure (PKI).
C. By configuring ABC-SR01 to use additional PPTP ports.
D. By configuring the connection type to SSTP VPN.

Answer: A

Explanation: IPSec is not used, so L2TP connections should not be used either. Instead
reconfigure to use PPTP VPN.

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

70-271 Exam Q & A / Study Guide

2011-12-28T00:57:00.000-08:00

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

QUESTION 1
You work as a technician at ABC.com. The ABC.com network only has workgroups. All client
computers are configured to run Windows XP Professional. All ABC.com employees have
administrative privileges on their own computer. ABC.com does not want file encryption to be
used.
You use a computer named ABC-WS25. You are promoted to a new position and have been
replaced by a new employee named Mia Hamm. You are worried that Mia Hamm will be able to
open your files.
How can you prevent Mia Hamm from opening your files and folders on ABC-WS25?

A. The data should be compressed in a folder.
B. The user should be removed from the ACL of the folder.
C. The operating system should be reinstalled with Windows XP Professional.
D. Your user account should be deleted from ABC-WS25.

Answer: D

Explanation: Your best option in this scenario would be to delete your user account from ABCWS25.

QUESTION 2
You are the newly appointed technician at ABC.com. The ABC.com network has a domain named
ABC.com. The client computers are configured to run Windows XP Professional.
Employees search the Web using Internet Explorer. To accomplish their tasks employees log onto
the ABC.com Web site. You implement a digital certificate to enhance the security of the ABC.com
Web site. The next day an employee of ABC.com, Ally Wagner, informs you that she is having
problems connecting to the Web site when she enters the URL for ABC.com in her browser.
Which action should you execute to resolve this problem?

A. Ally Wagner should add the www.ABC.com Web site to the approved Web sites in Content
Advisor.
B. Ally Wagner should access the Web site using the HTTPS for opening the URL..
C. Ally Wagner should set the Privacy setting to Medium in the Internet Option in the Control
Panel.
D. Ally Wagner should add the Web site URL to the trusted sites in the security zone.

Answer: B

Explanation: Your best option would be to select Option B. The scenario states that digital
certificates are used by ABC.com to secure the information on the website and in order to
establish a secure communication channel you have to use https instead of http. Https is http over
SSL.

QUESTION 3
You work as a graphics designer at ABC.com. The ABC.com network has a domain named
ABC.com. The client computers on the corporate network are configured to run Windows XP
Professional. You use a computer named ABC-WS271.
You want to increase the display size of your screen. However, you get an error message stating
that the Display menu on the control panel has been disabled.
How can you have the resolution of your screen increased?

A. You should set the hardware acceleration to full.
B. You should enable Advanced Configuration and Power Interface (ACPI) support in the system
BIOS on the computer.
C. You should configure the display settings to work in dual-monitor mode.
D. You should request that the Remove Display option in Control Panel be disabled.

Answer: D

Explanation: Your best option in this scenario would be to select Option D. The Deny Access to
the Display Settings option will disable the display settings control panel icon as well as stopping
users from accessing any display settings. This setting can be applied either by a GPO or by
modifying the registry.

QUESTION 4
You work as a technician at ABC.com. The ABC.com network has a domain named ABC.com. All
client computers on the network are configured to run Windows XP Professional.
You bring your personal laptop computer to work and attempts to logon to the domain from your
laptop. However, you are not able to log on. Your laptop computer is configured to run Windows
XP Home Edition.
How do you ensure access to the domain using your laptop? (Choose TWO. Each answer forms
part of the solution.)

A. By joining your laptop to the domain.
B. By installing Service Pack 3 on your laptop.
C. By logging on as a member of the Power Users group.
D. by changing the Custom settings in the Setup Wizard.
E. By uABCrading to Windows XP Professional.

Answer: A,E

Explanation: Your best option in this scenario would be to have ABC-WS25 uABCraded to
Windows XP Professional and join it to the domain. Microsoft has crippled the Home version of
Windows XP and made it impossible to join it to domains. It thus forced the majority of companies
to invest in the slightly more expensive Windows XP Pro.

QUESTION 5
You work as a help desk support technician at ABC.com. The ABC.com network consists of a
single Active Directory domain named ABC.com. The servers on the ABC.com network are
configured to run Windows Server 2003 and all client computers Windows XP Professional.
You have administrative privileges on a client computer named ABC-WS10. ABC-WS10 has a
hard disk that is formatted as a single partition. You realize the next day that you failed to backup
the Boot.ini file on ABC-WS10 and now get a message stating that the boot disk is unable to be
read and as a result Windows will not be started. You thus decide to run the Recovery Console
and reboot ABC-WS10.
You advise Rory Allen to reboot his computer with the Windows XP Professional CD-ROM and
make use of the Recovery Console.
Which of the following is the task that Rory Allen should complete next?

A. Rory Allen should reinstall Windows XP professional.
B. Rory Allen should execute a system restore on ABC-WS10.
C. Rory Allen should execute the bootcfg command with the /rebuild parameter.
D. Rory Allen should execute the diskpart command.

Answer: C

Explanation: Your best option in this scenario would be to select Option C. The bootcfg command
is a Microsoft Windows XP Recovery Console command that manipulates the Boot.ini file. This
command has a function that can scan your hard disks for Microsoft Windows NT 4.0, Microsoft
Windows 2000, and Windows XP installations, and then add them to an existing Boot.ini file. The
function can also rebuild a new Boot.ini file if one does not exist.

QUESTION 6
You work as a network administrator at ABC.com. The ABC.com network has a domain named
ABC.com. All servers on the ABC.com network run Windows Server 2003 and all client computers
run Windows XP Professional.
A ABC.com employee named Clive Wilson is a member of the Marketing department. Clive Wilson
is due to present a report to top management. The conference facility has a projector as well as a
laptop computer named ABC-WS25 that contains the latest graphics card. During the course of
the morning Clive Wilson informs you that he is having difficulty displaying complains that, during a
sales presentation to senior management he encountered a problem with ABC-WS25.
He informs you that the cables were connected properly and that ABC-WS25 was configured to
display to the projector. However, the message projected by the projector stated that it could not
project the image. You thus decide configure ABC-WS25 to show on the LCD but is unsuccessful
as you are presented with a ‘No signal’ message.
Which of the following actions should you take to rectify this problem?

A. The current video resolution on ABC-WS25 should be changed.
B. The projector should be checked to see whether it supports the IEEE 1394 standard.
C. The Video Graphics Array for ABC-WS25 should be listed in Device Manager.
D. The projector should be checked to see whether it supports the USB 2.0 standard.

Answer: A

Explanation: The error has occurred due to the fact that laptop computers often use a high
resolution while projectors have a much lower resolution. It is therefore needed that employees
assigned laptop computers make the necessary changed to the resolution settings prior to
connecting to the projector, unless the computer hardware takes care of this itself.

QUESTION 7
You work as a network administrator at ABC.com. The ABC.com network consists of a single
Active Directory domain named ABC.com. All servers on the ABC.com network run Windows
Server 2003 and all client computers run Windows XP Professional. The ABC.com network has a
file server named ABC-SR04 that is accessed by network users.
A ABC.com employee named Ally Wagner was assigned a computer named ABC-WS10. Ally
Wagner says that she cannot access ABC-SR04. No other employees are experiencing the same
problem. You confirm that the ABC-WS10 network cable connection is correct.
Which actions should you take to make sure that ABC-WS10 can make a connection to ABCSR04?

A. ABC-WS10 should be configured to make use of mnode for NetBIOS name resolution.
B. ABC-WS10 should be configured to automatically obtain an IP address.
C. ABC-WS10 should be configured with the correct DNS server IP address.
D. ABC-WS10 should be configured with the correct IP address of the default gateway.

Answer: C

Explanation: The scenario states that the cable is connected and other users are able to
communicate on the network. It is therefore not a physical network problem. It is likely to be a
configuration problem on ABC-WS10.

QUESTION 8
You work as a network administrator at ABC.com. The ABC.com network consists of a single
Active Directory domain named ABC.com. All servers on the ABC.com network run Windows
Server 2003 and all client computers run Windows 98.
ABC.com wants to uABCrade the client computers to Windows XP Professional. You are
concerned that performance might be slow after the uABCrade. You are particularly concerned
about response times when opening windows and menus.
Which of the following is a task that you would perform to address this issue?

A. Set the screen refresh rate to a lower value in Display settings.
B. Access the Performance Options dialog box and choose the Adjust for best performance
option.
C. Modify the Advanced Display settings to configure the display DPI setting to 120 dots per inch
in the Display Properties dialog box.
D. Access the Performance Options dialog box and modify the System applet.

Answer: B

Explanation: In this scenario you need to select the Adjust for best appearance option in the
Performance Option dialog box. The graphical nature of Windows XP Professional has progressed
as they are more extensive in their use of colors and shading, and they drain more system
resources. Trimming back the level of graphical representation in your Windows XP desktop can
save system resources and boost overall application and network performance.

QUESTION 9
You work as a network administrator at ABC.com. The ABC.com network has a workgroup named
ABC. All client computers either run Windows 2000 Professional or Windows XP Professional.
A ABC.com user named Kara Lang is assigned a new Windows XP Professional computer named
ABC-WS25. Kara Lang is assigned the permission to create a file for her department. The file will
be used by four other users. Each user is responsible for a specific task and permission has to be
assigned in accordance to the duties they will perform on the file.
Which of the following is an option that would enable Kara Lang to perform the functions
mentioned in the scenario?

A. On ABC-WS25 you need to have the option of simple file sharing deselected.
B. On ABC-WS25 the Full Control permission should be assigned to Kara Lang.
C. On ABC-WS25 the NTFS permissions was reset after the uABCrade.
D. On ABC-WS25 a link should be configured in My Computer to the shared folder.

Answer: A

Explanation: Your best option would be to have simple file sharing disabled as it is enabled on a
Microsoft Windows XP-based computer if the computer is not a member of a domain. Simple file
sharing allows you to share folders with everyone on your workgroup or network and make folders
in your user profile private. However, if simple file sharing is enabled, you cannot prevent specific
users and groups from accessing your shared folders. If you turn off simple file sharing, you can
permit specific users and groups to access a shared folder.

QUESTION 10
You are employed as an administrator at ABC.com. The client computers on the ABC.com
network are configured to run Windows XP Professional.
The ABC.com Sales department manager, Rory Allen is assigned a client computer named ABCWS25.
During the course of the day Rory Allen make use of the Windows XP Professional driver
to install a Canon MP250 color printer on ABC-WS25. The Canon MP250 color printer will be
shared with another manager in the department.
After the installation you receive complaints from the two managers informing that they are only
able to print monotone graphs. You receive an instruction from the CIO to ensure that they are
able print the graphs in color from the printer. You thus decide to install a printer driver on ABCWS25
from the CD-ROM provided by the manufacturing company but find that the problem
persists.
Which of the following should be your next option?

A. You should configure the appropriate printer option in the BIOS.
B. You should have a signed printer driver installed on ABC-WS25 that was obtained from the
company.
C. You should run use the Add Printer Wizard to connect to the printer.
D. You should reconfigure the properties of the print server in Printer and Faxes.

Answer: B

Explanation: You should install the correct printer driver on ABC-WS25. The computer of the
other manager will then receive the correct driver from ABC-WS25 when he attempts to print.

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

70-178 Q & A / Study Guide

2011-12-26T12:45:00.000-08:00

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

QUESTION 1
You work as a Project Manager at Certkingdom.com. You are using Microsoft Project Professional 2010 to
manage a project.
You notice that a section of the project is located in the wrong phase. The section includes a
summary task that contains eight subtasks and two milestones. You need to move the section
complete with the summary tasks and milestones to a different project phase. You want the Work
Breakdown Structure (WBS) numbering to be updated to match the destination phase.
Which of the following actions should you take?

A. You should select the summary task and select Change Working Time on the Project ribbon.
B. You should select the summary task and modify the start and finish dates.
C. You should open the properties of the summary task, select the Advanced tab and configure
the WBS code.
D. You should select the section including the summary task and milestones and click the Move
task option.
E. You should select the summary task and drag it to the correct phase.

Answer: B

Explanation:

QUESTION 2
Your work at Certkingdom.com includes management of projects using Microsoft Project Professional
2010.
You have several tasks in your project schedule. The tasks are a mix of active and inactive tasks
that are automatically or manually scheduled. Some tasks are summary tasks that include
subtasks. The tasks are listed using different text colors and fonts including bold, underline and
strikethrough fonts.
A new member of the project team uses Microsoft Office Project Professional 2007. He asks you
to save the project as a Project 2007 project until his version of Project is upgraded to 2010.
As a result of some features of the task list not being compatible with Project 2007, you would like
to complete the task without creating any new milestones.
Which of the following actions should you take?

A. You should alter all the tasks to be Manually Scheduled tasks.
B. You should alter all the tasks to be Auto Scheduled tasks.
C. You should alter the font of all tasks listed with a strikethrough font.
D. You should alter the font of all tasks listed with a bold font.

Answer: C

Explanation:

QUESTION 3
You work as a Project Manager at Certkingdom.com. You are using Microsoft Project Professional 2010 to
manage multiple projects.
Some resources are shared and work is distributed between the projects. You have received
instructions to modify the workload for some of the shared resources.
Which two of the following actions should you take? (Choose two.)

A. You should consider inserting the existing project schedules into a blank project as subprojects.
B. You should consider select the Links Between Projects option.
C. You should consider opening each existing project schedule and select the shared resource
pool.
D. You should consider enabling the Load Summary Resource Assignments option.
E. You should consider selecting the Level Resource function and select the required resources.
F. You should consider selecting the Level All function.

Answer: A,E

Explanation:

QUESTION 4
Your work at Certkingdom.com includes management of projects using Microsoft Project Professional
2010. You are working on a Software System Development project.
You have a task named Business Requirements Definition that is scheduled to be completed by
20th July.
The constraint type for all tasks listed in the project schedule is configured as “As Soon As
Possible”.
The project team members inform you that the Business Requirements Definition task will be
completed by 15th July. You want the default Gantt chart to show 20th July as the completion date
instead of 15th July.
Which of the following actions should you take?

A. Open the task information window and enter 20th July in the Constraint date field.
B. Open the task information window and enter 20th July in the Deadline date field.
C. Open the task information window and select the Fixed Units option in the Task Type field.
D. Open the task information window and enter 20th July in the Finish date field.

Answer: B

Explanation:

QUESTION 5
You work as a Project Manager at Certkingdom.com. You are using Microsoft Project Professional 2010 to
manage a new project.
The project will be divided into five major phases. The time that each phase will take is still being
calculated but the entire project needs to be completed within 6 months.
How should you configure the project to indicate that the entire duration will be 180 days?

A. You should configure five summary tasks each with a duration of 36 days.
B. You should set the Status Date to 180 days into the future.
C. You should enter the project timescale in the project calendar.
D. You should create a single summary task with the manually scheduled option.

Answer: C

Explanation:

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

Microsoft MB6-869 Q & A / Study Guide

2011-12-23T05:42:00.000-08:00

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

QUESTION 1
You are employed as a developer at ABC.com. ABC.com makes use of Microsoft Dynamics AX 2012.
You have received instructions to design business logic for ABC.com in Microsoft Dynamics AX 2012.
Which of the following actions should you take?

A. You should consider making use of either the IntelliMorph, or the MorphX IDE tools.
B. You should consider making use of either MorphX IDE, or Microsoft Visual Studio 2012 IDE.
C. You should consider making use of either Microsoft SQL Server, the MorphX IDE tools.
D. You should consider making use of either Microsoft Visual Studio 2012 IDE, or the IntelliMorph tool.
E. You should consider making use of either Microsoft Visual Studio 2012 IDE or Microsoft SQL Server.

Answer: B

QUESTION 2
You are employed as a developer at ABC.com. ABC.com makes use of Microsoft Dynamics AX 2012.
You are preparing to develop a form and a report for a Microsoft Dynamics AX 2012 feature. You
want the process to be handled automatically, with as little development input as possible.
Which of the following actions should you take?

A. You should consider making use of the IntelliMorph tool.
B. You should consider making use of the MorphX IDE tool.
C. You should consider making use of Microsoft SQL Server.
D. You should consider making use of Microsoft Visual Studio 2012.

Answer: A

QUESTION 3
You are employed as a developer at ABC.com. ABC.com makes use of Microsoft Dynamics AX 2012.
You have been assigned a trainee developer named Mia Hamm. You are in the process of
explaining models and the model store to Mia Hamm.
Which of the following is TRUE with regards to the model store? (Choose all that apply.)

A. The model store hosts application code only.
B. The model store replaces the Application Object Data (AOD) files that were used in previous
editions of Microsoft Dynamics AX.
C. Models n the model store cannot be exported to, or impoted from model files.
D. The model store hosts both metadata and application code.

Answer: B,D

Explanation:

QUESTION 4
You are employed as a developer at ABC.com. ABC.com makes use of Microsoft Dynamics AX 2012.
You have just completed creating a List page form. You want to make sure that data related to a
single record is displayed in the List page.
Which of the following actions should you take?

A. You should add a FactBox directly to the FactBox pane first.
B. You should define a FactBox part in the Parts node of the AOT first.
C. You should add a FactBox directly to the Preview pane.
D. You should add a FactBox button to the action pane.

Answer: B

Explanation:

QUESTION 5
You are employed as a developer at ABC.com. ABC.com makes use of Microsoft Dynamics AX 2012.
You have been assigned a trainee developer named Mia Hamm. You are in the process of
explaining models and the model store to Mia Hamm.
Which of the following is TRUE with regards to models? (Choose all that apply.)

A. Each element in a layer must belong to only one model.
B. Elements in a layer can belong to more than one model.
C. A model is a set of elements in a given layer.
D. Models can be exported to .aod files.

Answer: A,C

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

Microsoft 70-401 Q & A / Study Guide

2011-12-21T23:18:00.000-08:00

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

QUESTION 1
You work as an administrator at ABC.com. The ABC.com network consists of a single Active
Directory domain named ABC.com. ABC.com makes use of System Center Configuration
Manager 2007 on their network.
ABC.com has recently opened a new satellite office in Miami. You have been tasked with making
sure that users in the Miami office are able to install operating systems on their workstations using
boot images.
You decide to modify the settings of the site system in the Configuration Manager to answer
requests for boot images from workstations in the Miami office.
Which of the following actions should you take?

A. You should consider creating a new site system, and installing the PXE Boot Service on a
DHCP server in ABC.com’s environment.
B. You should consider creating a new site system, and granting it the Fallback status point role.
C. You should consider creating a new site system, and installing the State Migration Service on a
DHCP server in ABC.com’s environment.
D. You should consider creating a new site system, and granting it the PXE Service Point role.

Answer: D

Explanation:

QUESTION 2
You work as a Configuration Manager 2007 administrator at ABC.com. The ABC.com network
consists of a single Active Directory domain named ABC.com.
You have received instruction from the CIO to prepare for the deployment of new OS to all
workstations on the ABC.com network office.
You are then informed that for the boot images to perform adequately, it needs added network
drivers. You navigate to the properties of the boot image, and choose the Select a Driver option.
When you try to add the required drivers, you notice that there aren’t any drivers available.
Which two of the following actions should you take?

A. You should consider importing the relevant drivers into the Drivers node of the Configuration
Manager console.
B. You should consider importing the relevant drivers into the Driver Packages node of the
Configuration Manager console.
C. You should also consider choosing the relevant drivers and adding it in the boot image properties.
D. You should also consider choosing the relevant package and adding it in the boot image properties.

Answer: A,C

Explanation:

QUESTION 3
You work as a Configuration Manager 2007 administrator at ABC.com. The ABC.com network
consists of a single Active Directory domain named ABC.com.
After configuring Network Access Protection (NAP) on ABC.com’s network, you are instructed to
make sure that users on ABC.com’ network are able to access options for remediation in the event
of remediation failing. You create a Web site in the restricted network
Which of the following actions should you take?

A. You should consider having a Web site created in the restricted network.
B. You should consider having a Web site created in the public network.
C. You should consider having the Troubleshooting URL setting configured on the network policy
for computers that are not compliant.
D. You should consider having the Troubleshooting URL setting configured on the network policy
for computers that are unidentified.

Answer: A,C

Explanation:

QUESTION 4
You work as a Configuration Manager 2007 administrator at ABC.com. The ABC.com network
consists of a single Active Directory domain named ABC.com.
You have been tasked with making sure that all workstations on the ABC.com network can be
located by which office they reside in. To achieve this, you plan to insert a custom element in the
hardware inventory data.
Which of the following actions should you take?

A. You should insert a NOIDMIF file, which hosts the office location data, on each workstation.
You should then set up the Configuration Manager 2007 to gather NOIDMIF files from
workstations.
B. You should modify the Configuration.mof file. You should then insert a NOIDMIF file, which
hosts the office location data, on each workstation.
C. You should modify the Configuration.mof file. You should then set up the sms_def.mof file.
D. You should set up the sms_def.mof file. You should then set up the Configuration Manager
2007 to gather NOIDMIF files from workstations.

Answer: A

Explanation:

QUESTION 5
You work as an administrator at ABC.com. The ABC.com network consists of a single Active
Directory domain named ABC.com. ABC.com makes use of System Center Configuration
Manager 2007 on their network.
You have recently deployed a custom application to all workstations on the ABC.com network.
You are instructed to view the registry values for the new application for all ABC.com workstations.
To achieve this, you have to send a query to Configuration Manager 2007 for the relevant
information.
Which of the following actions should you take?

A. You should consider configuring hardware inventory, and setting the SMS_Def.MOF file on
every site to query for the registry values.
B. You should insert a NOIDMIF file on each workstation, and set up the Configuration Manager
2007 to gather NOIDMIF files from workstations.
C. You should consider amending the sitectrl.cto file at the primary site.
D. You should consider amending the sitectrl.cto file at the secondary site.

Answer: A

Explanation:

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

Microsoft 70-442 Q & A / Study Guide

2011-12-18T14:21:00.000-08:00

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

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

A. Make use of a DataSet object.

B. Make use of an XmlElement object.

C. Make use of an XmlDocument object.

D. Make use of an XmlDocumentFragment object.

Answer: D

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

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

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

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

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

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

Answer: D

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

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

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

B. Make use of the sp_xml_preparedocument stored procedure.

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

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

Answer: D

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

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

A. Create a server-side static cursor.

B. Create a server-side dynamic cursor.

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

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

Answer: D

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

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

A. Use a Transact-SQL stored procedure.

B. Use an extended stored procedure.

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

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

Answer: A

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

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

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

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

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

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

Answer: D

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

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

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

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

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

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

Answer: D

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

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

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

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

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

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

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

Answer: D

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

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

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

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

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

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

Answer: A

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

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

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

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

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

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

Answer: C

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

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

Microsoft 70-454 Q & A / Study Guide

2011-12-17T04:11:00.000-08:00

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

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:

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:

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:

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:

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

Answer: A,C,E

Explanation:

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

Microsoft MB6-285 Q & A / Study Guide

2011-12-12T04:01:00.000-08:00

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

QUESTION 1
How can you view total invoiced amount on a customer for a specific time interval?

A. Run the report CRM/Reports/Sales Management/Internal account statement
B. Select CRM, Inquiries, Statistics
C. On the Business relations form, click Update financial on the Financials tab, and view
the field Total invoiced
D. Open Management statistics, Business relation category, select the Specific Customer
radio button, and select the respective customer

Answer: D

QUESTION 2
Using the TAPI interface you receive a telephone call. How do you register this in the
CRM module?

A. I create a new record on the Phone calls tab in either the Contact person or Business relations form
B. I create a new note document called, for example, Incoming phone calls and register
the call by creating a note of this type in the Business relations form
C. I need to register the Business relation and/or contact person in order to have the
registered on my business relation
D. The phone call is registered automatically

Answer: D

QUESTION 3
You have received a text file containing a range of possible leads which you wish to
import into the Business relations form, it also contains several contact persons for each
lead:

A. You have to select which contact persons you need to import
B. You have to enter the contact persons through the MS Excel import wizard
C. You create a number of record groups and enter each contact person with a different
record group in the File format definition
D. You are limited to a maximum of three contact persons for each business relations

Answer: C

QUESTION 4
When a contact person leaves one of your customers:

A. Create a note in the memo field on the contact person
B. Replace the former contact person with the new contact person
C. Mark the contact person as inactive
D. Delete the contact person from the system

Answer: C

QUESTION 5
To view all quotations for a specific prospect, you:

A. Enter the Management statistics form, select category Business relation and view the quotation
B. Open the Quotations form, select a quotation for the prospect, and click the Business relations button
C. Open the Workbook tab Quotations and filter for the specific prospect
D. Open the Business relations form, select the prospect, and click the Quotations button

Answer: D

QUESTION 6
To send a document from Axapta’s document handling to an Axapta e-mail group you:

A. Drop the file into your e-mail program
B. Attach the document through the E-mail distribution form
C. Save the document separately and attach it manually to the e-mail
D. Click the E-mail group button in Axapta

Answer: D

QUESTION 7
Which of the following business relation types can be imported?

A. Competitors
B. Customers, vendors and prospects
C. Customers and vendors
D. Prospects

Answer: B

QUESTION 8
From where can you NOT see the Return of investment (ROI) for a given campaign?

A. In the Management statistics form
B. In the Business relations form
C. In the Campaign form
D. In the Projects form

Answer: B

QUESTION 9
How can you make sure that your employees in your call center follow a consistent questioning technique?

A. Create a Questionnaire and attach it to the call list
B. Add a detailed media description to the campaign
C. Detail the questioning technique in the Encyclopedia
D. Attach a Microsoft Word document to the call list with specific questions on it using Document Handling

Answer: A

QUESTION 10
How do you synchronize the contact persons from one business relation in Axapta to MS Outlook

A. You have to synchronize all the contacts
B. Open the menu item Periodic, MS Outlook synchronization, Synchronize contact
person to Outlook, and select Business relation contacts
C. Select the import field on the individual contact persons in the Contact persons form and select Synchronize
D. Select the business relation in the Business relation form and click the Synchronize button

Answer: B

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

Microsoft 70-236 Q & A / Study Guide

2011-12-11T10:58:00.000-08:00

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

QUESTION 1
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 infrastructure.
The network contains a mailbox named TestResources. At present all users are able to diarize
appointments for TestResources. A new company policy states that only Kara Lang and Mia
Hamm are permitted to diarize appointments for TestResources.
What actions must you take to comply with the Certkingdom.com policy?

A. You should run the following cmdlet:
Set- MailboxCalendarSettings - Identity"TestResources" - MonthCalendar calendar = new
MonthCalendar(); KaraLang , MiaHamm.
B. You should run the following cmdlet:
Set-MailboxCalendarSettings - Identity " TestResources" - BookInPolicy KaraLang , MiaHamm -
AllBookInPolicy $false cmdlet.
C. You should run the following cmdlet:
Set - MonthCalendar calendar = new MonthCalendar(); “host.KaraLang , MiaHamm = calendar "
this.Content = host;.
D. You should run the following cmdlet:
Set - MonthCalendar calendar = new MonthCalendar();
HwndSource source = HwndSource.FromHwnd(calendar.Handle);
this.Content = calendar;Delegates KaraLang , MiaHamm.

Answer: B

Explanation:

QUESTION 2
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. Certkingdom.com has headquarters in London and branch offices in Paris and
Berlin. The marketing department is located at the Paris office. The personnel in Paris connect to
the network through the Internet and use Outlook Anywhere on their laptops. To ensure
productivity management wants you to make sure that the marketing personnel have access to the
companies' mailboxes.
What actions must you take?

A. You should utilize the Test- MAPIConnectivity and the Test- WebServicesConnectivity cmdlet.
B. You should utilize Get- Recipient – Filter cmdlet.
C. You should utilize Show-MailboxStatistics cmdlet.
D. You should utilize List-Mailbox cmdlet.

Answer: A

Explanation:

QUESTION 3
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. The Certkingdom.com network has an Exchange Server 2007 environment.
The Edge Transport Server role is installed on a server named Certkingdom-EX01. Due to this server
failure, you have decided to install a new Microsoft Windows Server 2003 server named CertkingdomEX03
on the network with the reinstallation of the Edge Transport Server role. However, the
address rewrites that was functional on Certkingdom-EX01 did not in operation on Certkingdom-EX03. This
functionality is needed.
What actions must you take?

A. You should use the ImportEdgeConfig.ps1 on Certkingdom-EX03.
B. You should use the iiscnfg/enable: application name check version.
C. You should use the Transaction Logs for sp_configure configuration.
D. You should use create a new Send connector on Certkingdom-EX03.

Answer: A

Explanation:

QUESTION 4
You work as the Exchange administrator at Certkingdom.com. Certkingdom.com has headquarters in London and
a branch office in Paris. The Exchange Server 2007 server in the London office is named CertkingdomEX07
and the Exchange Server 2003 server in the London office is named Certkingdom-EX08. You need
to transfer the mailbox from Certkingdom-EX07 to Certkingdom-EX08.
What actions must you take?

A. You should include the IgnoreRuleLimitErrors parameter when using the Move-Mailbox cmdlet.
B. You should use the System configuration data collector.
C. You should create a mapping schema definition.
D. You should enable the Windows Remote Management (WinRM).

Answer: A

Explanation:

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

QUESTION 5
You work as the Exchange administrator at Certkingdom.com. Certkingdom.com has its headquarters in Chicago
and a branch office in Dallas. You are implementing a new Exchange Server 2007 Organization.
The Exchange Server 2007 environment of Certkingdom.com has the following server installed:
• An Edge Transport server named Certkingdom-EX01
• A Hub Transport server named Certkingdom-EX02.
During the course of the day you have received instruction from the CIO to have e-mail routing
configured on Certkingdom-EX01 and Certkingdom-EX02. In your solution you need to ensure that Certkingdom-EX01 is
able to transmit e-mail messages to and from the Internet. You should also ensure that Internet email
is sent to Certkingdom-EX01 via Certkingdom-EX02.
What actions must you take?

A. You should use the Microsoft System Center Configuration Manager (SCCM).
B. You should export a new Edge Subscription file to Certkingdom-EX01 and Import the Edge Subscription
file to Certkingdom-EX02.
C. You should use the Microsoft System Center Operations Manager (SCOM).
D. You should use the Microsoft Exchange Internet Message Access Protocol, Version 4 (IMAP4).

Answer: B

Explanation:

QUESTION 6
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
You were compelled to restore the directory objects and settings from a backup. However, after
the restoration a number of employees reported that they are unable to access their mailboxes
that were assigned to them before the backup was made. The employees need to access their
mailboxes.
What actions must you take?

A. You should use the Get-Mailbox cmdlet.
B. You should use the Get-MailboxInformation cmdlet.
C. You should use the Connect-Mailbox cmdlet.
D. You should use the Show-Information cmdlet.

Answer: C

Explanation:

QUESTION 7
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
During routine maintenance of the Exchange server you discover that the storage limits are all
different in the mailboxes.
What actions must you take to ensure that the storage limits to be the same?

A. You should use the Get-MailboxStatistics cmdlet and forward it to the Get-Mailbox cmdlet.
B. You should use the Show-MailboxStatistics cmdlet and forward it to the Select-Object cmdlet.
C. You should use the Get-MailboxInformation cmdlet and forward it to the Select-Object cmdlet.
D. You should create an Exchange Management Shell script and forward the Get-Mailbox
Database cmdlet output to the Set-Mailbox Database cmdlet.

Answer: D

Explanation:

QUESTION 8
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment. The Certkingdom.com network contains a stand-alone server named CertkingdomSR09.
Your boss, CertKingdom, wants to know which Exchange Server 2007 server role can Certkingdom-SR09
support.
What would you reply?

A. It can support the Terminal Service Session Broker (TS Session Broker) role.
B. It can support the Edge Transport server role.
C. It can support the PDC emulator role.
D. It can support the Exchange Recipient Administrators role.

Answer: B

Explanation:

QUESTION 9
You work as the Exchange Administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 infrastructure that has two Client Access Servers with load balancing.
The employees on the intranet has 24/7 access to data when utilizing Outlook Anywhere. During
the course of the day you have received instruction from the CIO to ensure that the employees
who connect to the Exchange infrastructure via the IUnernet also have access to data 24/7.
What actions must you take?

A. You should enable the Microsoft Exchange Information Store.
B. You should enable the Microsoft Exchange Search Service.
C. You should set the external URL on every Client Access Server.
D. You should enable the Microsoft Exchange File Distribution service.

Answer: C

Explanation:

QUESTION 10
You work as the Exchange administrator at Certkingdom.com. The Certkingdom.com network has an Exchange
Server 2007 environment.
You have received several complaints from employees in various departments stating that e-mail
messages are ending up in their Junk E-mail folder even though the sender’s e-mail address is on
their Safe Senders List. You need to ensure that the employees' Safe Senders Lists are used.
What actions must you take?

A. You should modify the SMTP Send connectors.
B. You should utilize the Get-Mailbox cmdlet.
C. You should utilize the Show-Information cmdlet.
D. You should utilize the Update-SafeList cmdlet on each mailbox.

Answer: D

Explanation:

Microsft 70-638 Q & A / Study Guide

2011-12-10T05:59:00.000-08:00

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

QUESTION 1
You work as a Network Administrator at Certkingdom.com. Your role includes the management of the
company’s communication system which comprises of servers running Microsoft Office
Communications Server 2007 Standard Edition.
A server named Certkingdom-WebConf1 is configured as a Web Conferencing Server. Certkingdom-WebConf1
runs Windows Server 2008 and is configured with a C: drive and a D: drive.
You create two shared folders on the D: drive of Certkingdom-WebConf1 named Meeting and Metadata.
You want to store meeting content in the \\Certkingdom-WebConf1\Meeting folder. You want to store the
Metadata in the \\Certkingdom-WebConf1\Metadata folder.
How should you configure the two shared folders?

A. You should modify the permissions on the two folders to grant the Read permission and the
Write permission to the RTC Component Local Group.
B. You should modify the permissions on the two folders to grant the Read permission to the RTC
Component Local Group
C. You should modify the permissions on the two folders to grant the Read permission and the
Write permission to the RTCComponentUniversalServices group.
D. You should modify the permissions on the two folders to grant the Read permission to the
RTCComponentUniversalServices group.

Answer: A

Explanation:

QUESTION 2
You work as a Network Administrator at Certkingdom.com. Your role includes the management of the
company’s unified communication infrastructure which includes multiple servers running Office
Communications Server 2007 Enterprise Edition. The company network consists of an internal
LAN and a perimeter network.
The perimeter network includes the following two Edge servers:
Certkingdom-Edge1 is configured as an A/V Edge server.
Certkingdom-Edge2 is configured as an Access and Web Conferencing Edge server.
The internal LAN includes the following OCS 2007 servers:
Certkingdom-Front1 is configured as a load balanced front end server.
Certkingdom-Front2 is configured as a load balanced front end server.
Certkingdom-SQL1 is configured as a clustered SQL Server.
Certkingdom-Dir1 is configured as a Director.
Certkingdom-Med1 is configured as a Mediation Server.
Remote users will use Microsoft Office Communicator Web Access 2007 for external access to
instant messaging and presence features.
You want to ensure that traffic from Communicator Web Access clients is encrypted using HTTPS.
Where should you install a Secure Sockets Layer (SSL) certificate to provide the HTTPS access?

A. You should install a Secure Sockets Layer (SSL) certificate on Certkingdom-Dir1.
B. You should install a Secure Sockets Layer (SSL) certificate on Certkingdom-Edge1.
C. You should install a Secure Sockets Layer (SSL) certificate on Certkingdom-Edge2.
D. You should install a Secure Sockets Layer (SSL) certificate on Certkingdom-Front1 and Certkingdom-Front2.
E. You should install a Secure Sockets Layer (SSL) certificate on Certkingdom-Med1.

Answer: C

Explanation:

QUESTION 3
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain. All servers run either Windows Server 2003 R2 or
Windows Server 2008. The client computers run either Windows XP Professional SP2 or
Windows 7 Professional. The office has a T1 data circuit and a T1 voice circuit.
You have been asked to deploy Office Communications Server 2007 as a unified communications
system for the company.
You install Office Communications Server 2007 Standard Edition on a server named Certkingdom-OCS1.
You then install Office Communicator 2007 on the client computers.
How can you enable all employees to call external phone numbers using Office Communicator
2007?

A. By uCertkingdomrading the Windows XP client computers to Service Pack 3 or later.
B. By uCertkingdomrading Certkingdom-OCS1 to Office Communications Server 2007 Enterprise Edition.
C. By installing a Mediation server.
D. By installing a Director server.
E. By installing an Access Edge server.

Answer: C

Explanation:

QUESTION 4
You work as a Network Administrator at Certkingdom.com. The company uses an Office Communications
Server (OCS) 2007 Enterprise infrastructure for it’s unified communications system.
All client computers run Microsoft Office Communicator 2007 and are enabled for Address Book
Lookup.
Several new employees have started work at Certkingdom.com. The new employees all have Active
Directory user accounts and are enabled for OCS.
You have updated the address book in Office Communications Server 2007 by running the
abserver- regenUR and abserver- syncnow utilities.
What else should you do to ensure that the Microsoft Office Communicator 2007 clients download
the latest address book?

A. You should rename the Galcontacts.xml file on each network computer.
B. You should delete the Galcontacts.db file on each client computer.
C. You should delete the Outlook.nk file on each client computer.
D. You should run abserver- syncnow on each client computer.

Answer: B

Explanation:

QUESTION 5
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain. All servers run either Windows Server 2003 R2 or
Windows Server 2008.
You are in the process of configuring a Microsoft Office Communications Server 2007 Enterprise
infrastructure to provide Enterprise Voice and Instant Messaging for the company.
You want to enable Public IM Connectivity (PIC) to enable employees to use Office Communicator
2007 initiate voice calls and IM conversations with users that run Windows Live Messenger.
Which of the following server roles are required to enable Public IM Connectivity (PIC)?

A. An Audio/Video Conferencing Edge Server.
B. A Web Conferencing Edge Server.
C. An Access Edge Server.
D. A Mediation Server.
E. A Reverse Proxy Server

Answer: C

Explanation:

QUESTION 6
You work as a Network Administrator at Certkingdom.com. You have been tasked with a project to design
a solution that provides Instant Messaging (IM) for the company.
The solution must enable external users or customers to initiate IM conversations with Certkingdom.com
employees working within the office LAN. IM sessions should be automatically reconnected if the
session is disconnected by an interruption in network connectivity.
You decide to implement Office Communications Server (OCS) 2007.
Which two of the following Office Communications Server (OCS) 2007 configurations would meet
the requirements and minimize costs? (Choose two).

A. OCS 2007 Standard Edition configured as a Front-End server.
B. OCS 2007 Enterprise Edition configured as a Front-End server.
C. OCS 2007 Standard Edition configured as a Mediation server.
D. OCS 2007 Enterprise Edition configured as a Mediation server.
E. OCS 2007 Standard Edition configured as an Access Edge server.
F. OCS 2007 Enterprise Edition configured as an Access Edge server.

Answer: A,E

Explanation:

QUESTION 7
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain. All servers run either Windows Server 2003 R2 or
Windows Server 2008. The company network consists of an internal LAN and a perimeter
network.
You are in the process of configuring a Microsoft Office Communications Server 2007 Enterprise
infrastructure to provide unified communications for the company.
Your deployment includes the following servers in the perimeter network.
Certkingdom-Edge1 is configured as an Access Edge server.
Certkingdom-Edge2 is configured as a Web Conferencing Edge server.
Certkingdom-RP1 is configured as a Reverse Proxy Server.
Your deployment also includes the following servers in the internal network.
Certkingdom-Front1 is configured as a load balanced front end server.
Certkingdom-Front2 is configured as a load balanced front end server.
Certkingdom-SQL1 is configured as a clustered SQL Server.
You need to provide external users with A/V conferencing and Web conferencing capability.
Which server role do you need to add to the infrastructure to provide the required capability?

A. A Director Server.
B. A Certificate Server.
C. An A/V Conferencing Edge Server.
D. A Mediation Server.
E. A Web Conferencing Edge Server.

Answer: C

Explanation:

QUESTION 8
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain. All servers run either Windows Server 2003 R2 or
Windows Server 2008.
The company has a Microsoft Office Live Communications Server 2005 SP1 Enterprise Edition
infrastructure. You are in the process of migrating to an Office Communications Server 2007
Enterprise Edition infrastructure.
The Marketing department has been migrated to Office Communications Server 2007. The Sales
department still use the Microsoft Office Live Communications Server 2005 SP1 system.
Twenty users are moving from the Marketing department to the Sales department. You need to
move the users from the Office Communications Server 2007 system to the Microsoft Office Live
Communications Server 2005 SP1 system.
You have enabled the users on the Live Communications Server 2005 SP1 system. You now
need to migrate the user data.
Which two of the following steps should you perform to migrate the user data from the from the
Office Communications Server 2007 system to the Microsoft Office Live Communications Server
2005 SP1 system? (Choose two).

A. You should export the user data from Office Communications Server 2007 using the Office
Communications Server 2007 administrative tools.
B. You should export the user data from Office Communications Server 2007 using Dbimpexp.exe.
C. You should import the user data into Live Communications Server 2003 SP1 using Live
Communications Server 2007 SP1 administrative tools.
D. You should import the user data into Live Communications Server 2005 SP1 using Dbimpexp.exe.

Answer: B,D

Explanation:

QUESTION 9
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain. All servers run either Windows Server 2003 R2 or
Windows Server 2008.
You are in the process of configuring an Office Communications Server 2007 Enterprise
infrastructure to provide unified communications for the company.
Your deployment includes the following servers.
Certkingdom-Edge1 is configured as an Access Edge and Web Conferencing Edge server.
Certkingdom-Front1 is configured as a front end server.
Certkingdom-SQL1 is configured as a SQL Server.
You need to configure the corporate firewall to provide external users with Web conferencing
capability.
How should you configure the firewall to provide the Web conferencing capability? (Choose two).

A. You should open TCP port 80 inbound to Certkingdom-Front1.
B. You should open TCP port 80 inbound to Certkingdom-Edge1.
C. You should open TCP port 443 inbound to Certkingdom-Front1.
D. You should open TCP port 443 inbound to Certkingdom-Edge1.
E. You should open TCP port 5061 inbound to Certkingdom-Front1.
F. You should open TCP port 5061 inbound to Certkingdom-Edge1.

Answer: D,F

Explanation:

QUESTION 10
You work as a Network Administrator at Certkingdom.com. The network consists of a single Active
Directory Domain Services (AD DS) domain.
The company uses an Office Communications Server 2007 Enterprise infrastructure that includes
the following servers.
Certkingdom-Front1 is configured as a front end server.
Certkingdom-SQL1 is configured as a SQL Server.
To increase capacity, you plan to expand the Office Communications Server 2007 infrastructure.
You will add another server running Office Communications Server 2007 Enterprise edition and
move from the current consolidated configuration to an expanded configuration.
Which server role do you need to add the current infrastructure to create an expanded
configuration?

A. You need to add a Director Server.
B. You need to add a Mediation Server.
C. You need to add an Access Edge Server.
D. You need to add a Front-End Server.
E. You need to add a Back-End Server.

Answer: D

Explanation:

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

Microsoft 70-630 Q & A / Study Guide

2011-12-09T12:37:00.000-08:00

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

QUESTION 1
You work as a SharePoint Server administrator at Certkingdom.com. You have just the completed the
insertion of new content in the root site. However, later that day the users complained that the new
content is not added in the search results when they run searches on the root site. You need to
make sure that the relevant content is included in query results.
What actions should you take to perform this task?

A. The best option is to set the Complete Through constraint.
B. The best option is to reset the crawled content and start a full crawl.
C. The best option is to set the Resource Center view.
D. The best option is to edit the CSS style sheet to include the new content.

Answer: B

Explanation:

QUESTION 2
You work as a SharePoint Server administrator at Certkingdom.com. One of Certkingdom.com branch offices
consists of a Windows Server 2003 Active Directory domain. You have received instructions from
the CIO to extend SharePoint user profiles to include the userID property from the users' domain accounts.
What actions should you take to perform this task?

A. The best option is to add a Microsoft Operations Manager (MOM) server.
B. The best option is to create a custom Microsoft Management Console that can access the branch office.
C. The best option is to create a new user profile property that is configured with import mapping.
D. The best option is to run the SharePoint Products and Technologies Configuration.

Answer: C

Explanation:

QUESTION 3
You work as a SharePoint Server administrator at Certkingdom.com. The Certkingdom.com network contains a
SharePoint Portal Server 2003 server named ABC-SR44. ABC-SR44 hosts a SharePoint portal
that is accessed through a hyperlink on the users' client computers.
The hyperlink points to http://www.Certkingdom.com/ms/certifications.
You want to migrate ABC-SR44 to Microsoft Office SharePoint Server (MOSS) 2007. You need to
ensure that the SharePoint portal will be accessible after the migration.
What actions should you take to perform this task?

A. By running the stsadm command with the osearch operator.
B. By editing the hyperlink so it will point to the new URL of the migrated content.
C. By running the stsadm command with the enumsites operator.
D. By enabling the Shared Services Provider Synchronizing job.

Answer: B

Explanation:

QUESTION 4
You work as a SharePoint Server administrator at Certkingdom.com. Certkingdom.com contains a Microsoft
Content Management Server 2002 computer named ABC-SR11. You have received instructions
from the CIO to uABCrade ABC-SR11 to Microsoft Office SharePoint Server (MOSS) 2007.
What actions should you take to perform this task?

A. The best option is to run the stsadm command with the addwppack operator.
B. The best option is to run the stsadm command with the installfeature operator.
C. The best option is to run the CMS Assessment utility on ABC-SR11.
D. The best option is to run the Optimize HTML command in SharePoint Designer.

Answer: C

Explanation:

QUESTION 5
You work as a SharePoint Server administrator at Certkingdom.com. Certkingdom.com has a Development
department with a database server named ABC-DB02. ABC-DB02 hosts a database named CkdProducts.
Certkingdom.com has implemented a Web application in the SharePoint site that must access data in CkdProducts.
What actions should you take?

A. The best option is to obtain and install an application definition file from the Development department.
B. The best option is to enable the Save for Sharing option, then save CkdProducts in the Development department.
C. The best option is to save CkdProducts as a Microsoft Excel 2007 worksheet.
D. The best option is to create a custom group in the Site Settings page to the trusted file locations list.

Answer: A

Explanation:

QUESTION 6
You work as a SharePoint Server administrator at Certkingdom.com. Certkingdom.com has a Web site named
testdocs that is hosted by an Internet service provider (ISP). Anonymous authentication is
configured on testdocs.
Certkingdom.com adds a Microsoft Excel 2007 spread sheet to testdocs. However, you have received
complaints from Certkingdom.com users that they get access denied errors when trying to use Excel
Services to access the spreadsheets.
What step should you perform to resolve this problem?

A. You should consider configuring a new Excel Services trusted file location.
B. You should consider selecting the Enable logging option.
C. You should consider configuring the Event Throttling feature.
D. You should consider editing the application.master file.

Answer: A

Explanation:

QUESTION 7
You work as a SharePoint Server administrator at Certkingdom.com. Certkingdom.com has a Sales department
that stores documents in a SharePoint site. The site has a list view Web part named
ABCCustomers that is populated with the names of customers.
You have received instructions from the CIO to add another Web part that will allow the Sales department
members to filter the names displayed on the ABCCustomers Web part.
How would you accomplish this?

A. By adding a Text Filter Web part.
B. By adding a DropDown List on the Web part.
C. By replacing the ABCCustomers Web part with a GridView.
D. By using the view in the team builder.

Answer: A

Explanation:

QUESTION 8
You work as a SharePoint Server administrator at Certkingdom.com. You have received instructions from
the CIO to create a new SharePoint site based on the Report Center template. The site must have
a new page with the Key Performance Indicator (KPI) and the Key Performance Indicator (KPI)
Details Access Web parts.
What actions should you take?

A. The best option is to add a new dashboard page.
B. The best option is to add a pivot table on the Article page layout.
C. The best option is to add a State field on the News Home page layout.
D. The best option is to edit the default.master file on the Document Center template.

Answer: A

Explanation:

QUESTION 9
You work as a SharePoint Server administrator at Certkingdom.com. The Certkingdom.com network has a
database server named ABC-DB30 that is running Microsoft SQL Server 2005. Certkingdom.com has
acquired a Marketing Data Catalog (MDC) application that will access a database hosted on ABCDB30.
To ensure productivity throughout the company you need to make sure that the information
exposed via the Marketing Data Catalog (MDC) application is available in the search results.
What actions should you take to perform this task?

A. By having the information displayed in the Resources Earned Value view.
B. By having Project selected from the View Type list in order to display the resource data.
C. By having the application.master file edited using an ASCII editor.
D. By having the default access account implemented for the Marketing Data Catalog (MDC)
application.

Answer: D

Explanation:

QUESTION 10
You work as a SharePoint Server administrator at Certkingdom.com. You have received instructions from
the CIO to implement a new SharePoint site. The CIO wants the site to have a key performance
indicator (KPI) list, a data connections library and a reference library.
How would you accomplish this?

A. The best option is to add a new pivot chart.
B. The best option is to add a new dashboard page.
C. The best option is to add a new State field.
D. The best option is to add a new Project Center page.

Answer: B

Explanation:

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

Microsoft 70-526 Q & A / Study Guide

2011-12-08T14:33:00.000-08:00

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

QUESTION 1
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS001 as developing collateral. You have
received instructions to make sure that the PictureBox control's properties cannot
be changed with a logo that you have added to the PictureBox in the designer of the
form base. Before the time you have added a form to the Microsoft Windows Forms
Control Library project and add a PictureBox control to the form. The form is
presenting Certkingdom.com's logo.
What action should you take?

A. You should set the Locked property to False.
B. You should set the Locked property to True.
C. You should set the Modifiers property to Private.
D. You should set the Modifiers property to Protected.

Answer: C

Explanation:
When you set the Modifiers property to Private, the value will show
that only the base form can modify the control.
Incorrect Answers:
A: You should not set it to False, because the control can be moved and resized.
B: If you set the property to True the control cannot be removed of resized. .
D: If you set the Modifiers property to Protected, the value will show that the base form
and any of the form yet to come can modify the control.

QUESTION 2
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS005 as developing collateral. You have just
included a DateTimePicker control to a form. You then set the format property to
Time. During the cause of the day, you check how the DateTimePicker control is
working, and learnt that it does not allow the Certkingdom.com users to change the
selected time.
What should you do to change the control so that it will allow the Certkingdom.com uses
to change the selected time?

A. You should set the ShowUpDown property to True.
B. You should set the ShowSelectBox property to True.
C. You should set the Visible property to False.
D. You should set the Checked property to False.

Answer: A

Explanation:
The ShowUpDown property is by default set on False. You should set
it on True. On False it will show the DateTimePicker must simulate a drop-down
control. This setting will allow the users to set the MonthCalender. If it is set to True
the users can select the time.
Incorrect Answers:
B: The ShowSelectBox will not resolve the problem. This will show if a CheckBox
should be displayed on the DateTimePicker.
C: If you set the Visible property to False, it will hide the DateTimePicker. .
D: You should not set the Checked property to False. If this is set on True, a CheckBox
control will be displayed on the DateTimePicker.

QUESTION 3
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS001 as developing collateral. The manager of
Certkingdom.com wants to have a borderless form with the background shown in the
exhibit.

When the form is view, the manager named Rory Allen does not want the maroon
area to be visible. He only wants the blue to be visible when the form is displayed.
Which of the following code segments should be used?

A. this.TransparencyKey = Color.Maroon;
B. this.BackColor = Color.Maroon;
C. this.TransparencyKey = Color.CornflowerBlue
D. this.BackColor = Color.Transparent;

Answer: A

Explanation:
The TransparencyKey = Color.Maroon specify the color that the
transparent represents the area on the form. With this setting the blue will respond
to the mouse.
Incorrect Answers:
B: You should not use the BackColor = Color.Maroon. This will determine the
background color of the form.
C: You should not use this code segment. The manager does not wan the blue area to be
transparent.
D: You should not use the BackColor = Color.Transparent. The manager does not want
the background to be transparent.

QUESTION 4
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS020 as developing collateral.
You have configured three columns to a form and add a TableLayoutPanel to the
form. You want the two side columns to have a fix width of 200 pixels each and
anchor the four edges of the form to the control. A Certkingdom.com manager wants
the center column to fill the remaining space, when ever the form is resized. You
need to change the ColumnStyle instance that represents the center column?
How should you set the ColumnStyle instance's Size Type property?

A. Set it to AutoSize and the Width property to 100F.
B. Set it to Absolute and the Width property to 100F.
C. Set it to Percent and the Width property to 100F.
D. Set it to AutoSize and the Width property to 0F.

Answer: C

Explanation:
This setting will show that the column should fill the remaining space.
Incorrect Answers:
A: This setting will allow the column to be sized enough so that not any of its child
controls are clipped. In this setting the middle will not occupy the remaining free space.
B: If you set it to Absolute, the value of the Width property will show the number of
pixels for the column.
D: You need to set the ColumnStyle instance's Size Type property to AutoSize and the
Width property to 100F.

QUESTION 5
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS020 as developing collateral. You have added
a SplitContainer control named CertkingdomSplitContainer to a form. You then left the
control to the default properties. To the right-most container of the SplitContainer
control, you need to add a PropertyGrid.
Which of the following code segments should you use?

A. PropertyGrid propertyGrid = new PropertyGrid[];
Panel rightPanel = [Panel] CertkingdomSplitContainer.GetContainerControl[];
rightPanel.ControlAdd[porpertyGrid];
B. PropertyGrid propertyGrid = new PropertyGrid[];
Panel rightPanel = [Panel] CertkingdomSplitContainer.GetNextControl[propertyGrid, true];
rightPanel.ControlAdd[porpertyGrid];
C. PropertyGrid propertyGrid = new PropertyGrid[];
CertkingdomSplitContainer.Container.Add[propertyGrid, "RightPanel"];
D. PropertyGrid propertyGrid = new PropertyGrid[];
CertkingdomSplitContainer.Panel2.Control.Add[propertyGrid];

Answer: D

Explanation:
An area can be divided into two containers, which is separated by a
movable bar, if you use the SplitContainer control. When the two Panels are
created, the left one is the Panel1 and the right is Panel2. You are adding a panel so
it will be on the right. You then need to specify Panel2.
Incorrect Answers:
A, B, C: You should not use the Add method of the SplitContainer.Container to add the
PropertyGrid. You also should not pass a PropertyGrid instance to the GetNextControl
method to return a Panel instance. This will actually retrieve the next tab-ordered control
given the current control. You also should not call the GetContainerControl method to
return a Panel instance. This will return the logical container of the SplitContainer
control.

QUESTION 6
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS020 as developing collateral. You are busy to
develop a Microsoft Windows Forms exam delivery application. This is going to be
used to access the content of the exam via the Internet. A WebBrowser named
testbrowser is added to the control to a form named CertkingdomForm, which is define
as follows:
[PermissionSet[SecurityAction.Demand, Name="FullTrust"]]
[System.Runtime.InteropServices.ComVisible[true]]
public CertkingdomForm : Form
{
public CertkingdomForm[]
{
InitializeComponent[];
}
public void Expire[]
{
}
}
The JavaScript-based timer that is used by the Web site for the exam has a function
to inform the exam delivery application when the time has expired for the exam,
which is the following:
window.external.Expire[];
What should you do to make sure that the Expire method of CertkingdomForm is called
when the JavaScrip function is carry out?

A. You should set the Document.DomDocument property of the browser instance to the
current instance of the CertkingdomForm class.
B. You should set the ObjectForScripting property of the browser instance to the current
instance of the CertkingdomForm class.
C. You should call the AttachEventHandler of the Document property of the browser
instance.
D. You should call the ExecCommand method of the Document property of the browser
instance.

Answer: B

Explanation:
You must set the ObjectForScripting for the browser instance to the
current instance of the CertkingdomForm class.
Incorrect Answers:
A: The property of the Document.DomDocument represents the true DOM object of an
HTML document.
C: The AttachEventHandler allows you to attach a HTML Document Object Model
event to an event handler.
D: The ExecCommand method allows you to execute commands against DOM
documents.

QUESTION 7
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS003 as developing collateral. You have
received instructions to make sure that the PictureBox will display dynamically
loaded images.
Which property will display a static image if any dynamic image fails to load?

A. BackgroundImage
B. Image
C. ErrorImage
D. InitailImage

Answer: C

Explanation:
The ErrorImage property specifies the image that should be
displayed. This will happened only if the image that you are trying to load
dynamically fails.
Incorrect Answers:
A: The BackgroundImage property specifies a background image which is used by the
control.
B: The Image property specifies the image you want the PictureBox control to display.
D: The InitailImage specifies the image you want the PictureBox control to display while
the other one is loading.

QUESTION 8
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS020 as developing collateral. You are
developing a Web service for new updates to query automatically, by use of a
Microsoft Windows Forms application. You then add a NotifyIcon component
named Certkingdomnotify to the application's main form. Whenever a new update is
available you want the following balloon tip to display as seen in the exhibit for 5
seconds.

Which segment should you use to write a code to download the updates if the users
click the balloon tip?

A. Certkingdomnotify.BallonTipClick +=delegate
{
// Download the updates
}
Certkingdomnotify.ShowBallonTip[5000, "New Update Available"; "Click here to download"
, ToolTipIcon.Info];
B. Certkingdomnotify.ShowBallonTip[5];
Certkingdomnotify.BalloonTipIcon = ToolTipIcon.Info;
Certkingdom.Balloon TipTitle = "New Update Available";
Certkingdom.BalloonTipText = "Click here to download";
Certkingdom.Click += delegate
{
// Download the updates
}
C. Certkingdomnotify.BalloonTipIcon = ToolTipIcon.Info;
Certkingdom.Balloon TipTitle = "New Update Available";
Certkingdom.BalloonTipText = "Click here to download";
Certkingdom.Click += delegate
{
// Download the updates
}
Certkingdomnotify.ShowBallonTip[5000];
D. Certkingdomnotify.ShowBallonTip[5, New Update Available", "Click here to download",
ToolTipIcon.Info];
Certkingdom.BalloonTipClick += delegate
{
// Download the updates
}

Answer: A

Explanation:
You should use an event handler, attach the BalloonTipClicked to the
event and call the ShowBalloon Tip method of the NotifyIcon class. When a user
clicks a balloon tip, a BalloonTipClicked event is raised.
Incorrect Answers:
B, C, D: You should not attach the BalloonTipClicked even to an event handler after you
have called the ShowBalloonTip method. Also note that the event is raised when the icon
is clicked and not the balloon tip.

QUESTION 9
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS020 as developing collateral. You are busy
adding a MenuStrip control, which has an instance of a ToolStripMenu item named
testjobItem, to a form in a Microsoft Windows Forms application. This item's
display text is Job. You have received instructions to add two menu items to the Job
menu item. The first item's display text should be Create New Job, and the second
one is Run Job.
Which code segment should you use to programmatically add the two menu items?

A. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New
Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
jobItem.Container.Add[createNewJobItem];
jobItem.Container.Add[runJobItem];
B. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New
Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
jobItem.Owner.Items.Add[createNewJobItem];
jobItem.Owner.Items.Add[runJobItem];
C. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New
Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
ToolStripMenuItem[] items = new ToolStripMenuItem[]{create NewJobItem,
runJobItem}
jobItem.DropDownItems.AddRange[items];
D. ToolStripMenuItem createNewJobItem = new ToolStripMenuItem["Create New
Job"];
ToolStripMenuItem runJobItem = new ToolStripMenuItem["Run Job"];
ToolStripMenuItem[] items = new ToolStripMenuItem[]{create NewJobItem,
runJobItem}
jobItem.Owner.Items.AddRange[items];

Answer: C

Explanation:
For the jobItem instance you should call the AddRange. The property
of the DropDownItems represents a collection of child items of the jobItem instance,
which allows you to add the two items to the job menu item.
Incorrect Answers:
A: This property returns an instance of IContainer, which represents a logical container
for other components.
B: The Owner property returns the Menu script instance that owns the
ToolStripMenuItem instance.
D: This action will add the two new menu at the same level as the Job menu item.

QUESTION 10
You are working as an application developer at Certkingdom.com. The Certkingdom.com
network consists of a single Active Directory domain named Certkingdom.com.
Certkingdom.com uses Visual Studio 2005 as an application platform. Certkingdom.com
consists of a Development department. You as the developer of Certkingdom.com use a
client computer named Certkingdom-WS050 as developing collateral. You were busy
with a task to add a ContextMenuStrip control to a form.
What should you do to display a custom control as a menu item of the
ContextMenuStrip control?

A. Add a ToolstripContainer control to the form and add the custom control to the
Controls collection residing on the toolStripContainer control. You should then add the
ContextMeniStrip control to the controls of the ToolStripContainer control.
B. Of ToolStripControlHost, create an instance and specify your custom control instance
as a parameter to the conductor. You should then the ToolStripControlHost instance to
the Items collection of the ContextMeniStrip control.
C. Add a ToolstripContainer control to the form and add the custom control to the
Controls collection residing on the toolStripContainer control. You should then add the
ToolstripContainer control to the controls of the ContextMeniStrip controls.
D. Of ToolStripControlHost, create an instance and specify your custom control instance
as a parameter to the conductor. You should then the ContextMeniStrip controls to the
collection of the ToolStripControlHost instance.

Answer: B

Explanation:
The ToolStripControlHost class to host a custom control as a menu
item in the ContextMeniStrip. You should also the custom control instance as the
parameter to the constructor.
Incorrect Answers:
A, B, C: The ToolstripContainer should not be used to reach your goal. Furthermore, you
cannot host a ToolstripContainer control as the menu item in a ContextMeniStrip controls.

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

Microsoft 70-447 - Q & A / Study Guide

2011-12-07T04:37:00.000-08:00

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

QUESTION 1
You work as DBA at Certkingdom.com. You administer two Windows Server 2003
computers named Certkingdom A and Certkingdom B. You install SQL Server 2005 on both
Certkingdom A and Certkingdom B to host a new company database. Certkingdom A hosts a
read-write copy of the company database in which all changes are made. Certkingdom B
subscribes to a publication on Certkingdom A and is only used for reporting. A Windows
domain administrator provides you with a domain user account named SQLSRV to use as
the security context for the SQL Server services. A password policy of 42 days exists in
the Default Domain Group Policy object (GPO). You install the database on Certkingdom A
and Certkingdom B and configure replication. Everything works fine for six weeks, but then
all SQL Server services fail. You need to correct the problem. What should you do?

A. Ask the Windows domain administrator to grant the Log on as service right to the
SQLSRV domain user account.
B. Configure the SQLSRV domain user account with a new strong password. Configure
the new password in the properties of each SQL Server service that failed.
C. Create a local user account on Certkingdom A named Certkingdom A and a local user account
on Certkingdom B named Certkingdom B. Configure Certkingdom A and Certkingdom B to run under the
context of the appropriate local user account.
D. Ask the Windows domain administrator to grant the SQLSRV domain user account
membership in the Domain Admins group.

Answer: B

Explanation:
The Default Domain Group Policy object requires that passwords are
changed every 42 days. In order to correct this problem you have to change the
password in the Active Directory AND configure the new password on both you
SQL Servers to the newly changed password.

QUESTION 2
You are a database administrator of two SQL Server 2005 computers named Certkingdom A
and Certkingdom B. You have a Microsoft .NET application that has been modified so that it
now accesses a database on Certkingdom B in addition to Certkingdom A. You do not want the
user application to connect directly to Certkingdom B. You need to enable the data retrieval
from Certkingdom B while maintaining the ability to assign different permissions to different
users who use the .NET application. What should you do?

A. Change the .NET application to define a new server connection to Certkingdom B.
B. Configure a linked server on Certkingdom A to point to Certkingdom B.
C. Change the stored procedures called by the .NET application to include the
OPENXML command.
D. Configure a linked server on Certkingdom B to point to Certkingdom A.

Answer: B

Explanation:
SQL Server lets you access external data sources from your local
Transact-SQL code. You need to define a linked server for each external data
source you want to access and then configure the security context under which your
distributed queries will run. After you create a linked server, you can use the
Transact-SQL OPENQUERY function to execute your distributed queries.

QUESTION 3
You are a database administrator for Certkingdom.com. Your company uses a different
company's application that is based on SQL Server 2005 Standard Edition. The
application executes a query that uses an index query hint. The index query hint is not
suitable for your environment, but you cannot modify the query. You need to force the
application to use a different query execution plan. What should you do?

A. Create a plan guide for the query.
B. Clear the procedure cache.
C. Create a new covering index on the columns that the query uses.
D. Update the statistics for all of the indexes that the query uses.

Answer: A
Over the past few years, Microsoft SQL Server has increased its
presence in the industry and has reduced its TCO. This reduced TCO is a direct
result, primarily, of the numerous self-tuning mechanisms built into Microsoft(r)
SQL Server. These mechanisms automatically perform tasks that would otherwise
have to be performed by experienced database administrators. One such
mechanism is the cost-based optimizer (CBO) that is used to dynamically generate
query execution plans. The CBO probes several system-wide resource states and
employs many complex, heuristical algorithms to generate the best possible plan for
a given query and the underlying table and index structures. This mechanism works
well for the vast majority of user queries, but there are times when experienced
users need to force a particular query plan, based on some prior knowledge or
insights into future uses.

QUESTION 4
You are a database administrator for Certkingdom.com. Your SQL Server 2005 computer
contains one user database that holds sales transaction information. Users report that the
queries and stored procedures that they use every day are taking progressively longer to
execute. You also notice that the amount of free disk space on the SQL Server computer
is decreasing. You need to create a maintenance plan to correct the performance and
storage problems. What are two possible ways to achieve this goal? (Each correct answer
presents a complete solution. Choose two.)

A. In the SQL Server Maintenance Plan Wizard, use the Check Database Integrity option.
B. In the SQL Server Maintenance Plan Wizard, use the Reorganize Index option.
C. In the SQL Server Maintenance Plan Wizard, use the Shrink Database option.
D. In the SQL Server Maintenance Plan Wizard, use the Clean Up History option.
E. In the SQL Server Maintenance Plan Wizard, use the Execute SQL Server Agent Job
option.

Answer: B,C

Explanation:
When you indexes are not heavily fragmented you can reorganize
indexes, which uses few system resources and runs automatically online. In SQL
Server 2005, certain operations such as large delete operations or -one-time data
loads might leave database files larger than they need to be. SQL Server 2005
enables a DBA to shrink each file within a database to remove unused pages and
regain disk space.

QUESTION 5
You are a database administrator for Certkingdom.com. You are responsible for a SQL
Server 2005 database that has several indexes. You need to write a stored procedure that
checks the indexes for fragmentation. Which Transact-SQL statement should you use?

A. DBCC INDEXDEFRAG
B. SELECT * FROM sys.dm_db_index_physical_stats
C. SELECT * FROM sys.indexes
D. DBCC DBREINDEX

Answer: B

Explanation:
The index_physical_stats function takes five parameters: database_id,
object_id, index_id, partition_id, and mode. This function returns row size and
fragmentation information.

QUESTION 6
You work as DBA at Certkingdom.com. You administer two SQL Server 2005 computers
named Certkingdom A and Certkingdom B. Certkingdom A and Certkingdom B contain a copy of a
database named Sales. The database is replicated between Certkingdom A and Certkingdom B by
using transactional replication. A full backup of each database is performed every night.
Transaction log backups are performed every hour. Replication latency is typically less
than two minutes. One afternoon, the Sales database on Certkingdom A becomes corrupted.
You are unable to repair the database. The Sales database on Certkingdom B is unaffected.
You need to return the Sales database on Certkingdom A to normal operation as quickly as
possible. You must ensure a minimum loss of data and minimal impact to users of either
server. What should you do?

A. Perform a full database backup on Certkingdom B. Restore the backup to Certkingdom A.
B. Restore the most recent full database backup and all transaction logs made since the
full backup was made.
C. Restore only the most recent transaction log backup.
D. Detach the Sales database on Certkingdom B. Copy the database file to Certkingdom A, and
attach the database on both servers.

Answer: A

Explanation:
Detaching the database will not apply to the minimal impact on users
as it will be offline during copy. Restoring only the latest transaction log will not
give you a working database and restoring last full backup and all transaction logs
after that will not apply to the restore normal operations as quickly as possible part
of the requirements.

QUESTION 7
You are a database administrator for Certkingdom.com. The company runs a popular
database-driven Web site against a SQL Server 2005 computer named Certkingdom B. You
need to ensure a quick response time and appropriate audit trail in the event that
Certkingdom B experiences excessive traffic due to denial-of-service (DoS) attacks. Which
two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

A. Configure the new performance alert to start a SQL Server Profiler trace.
B. Create a new performance alert to monitor the Current Bandwidth counter.
C. Configure the new performance alert to start a Network Monitor capture.
D. Create a new performance alert to monitor the Bytes Total/sec counter.

Answer: C,D

Explanation:
Using alerts, System Monitor tracks specific events and notifies you of
these events as requested. An alert log can monitor the current performance of
selected counters and instances for objects in SQL Server. When a counter exceeds
a given value, the log records the date and time of the event. An event can also
generate a network alert. Characteristic for a typical DoS attack is a large number
of Bytes/sec. Characteristic for a DDoS attack is also a large number of Bytes/sec
but also a large number of connections made from a large number of hosts.

QUESTION 8
You are a database administrator for Certkingdom.com. One of the databases on a SQL
Server 2005 computer contains a stored procedure. Users run this stored procedure to
import data into a table. The stored procedure needs to use the TRUNCATE TABLE
command before importing new data into the table. However, the users who run the
stored procedure do not have permission to truncate the table. You need to provide a way
for the stored procedure to truncate the table before it imports new data. What should you
do?

A. Configure the stored procedure to use the EXECUTE AS command.
B. Configure the stored procedure to be owned by the same database user as the table.
C. Assign the users DELETE permission in the table.
D. Add the users to the db_datawriter fixed database role.

Answer: A

Explanation:
In SQL Server 2005 you can implicitly define the execution context of
the following user-defined modules: functions (except inline table-valued functions),
procedures, queues, and triggers. By specifying the context in which the module is
executed, you can control which user account the SQL Server 2005 Database Engine
uses to validate permissions on objects that are referenced by the module. This
provides additional flexibility and control in managing permissions across the object
chain that exists between user-defined modules and the objects referenced by those
modules. Permissions must be granted to users only on the module itself, without
having to grant them explicit permissions on the referenced objects. Only the user
that the module is running as must have permissions on the objects accessed by the
module.
Syntax:
Functions (except inline table-valued functions), Stored Procedures, and DML Triggers
{ EXEC | EXECUTE } AS { CALLER | SELF | OWNER | 'user_name' }

QUESTION 9
You are a database administrator for Certkingdom.com. You have separate SQL Server 2005
development and production environments. You use the Business Intelligence
Development Studio to create a SQL Server Integration Services (SSIS) package in your
development environment. Then, you use the SSIS package to import data into your
development environment from one of your company's trading partners. You need to
deploy the SSIS package to your production environment. Your production environment
uses different table names than your development environment. What should you do?

A. Save the SQL Server Integration Services (SSIS) package to a file. Copy the file to the
production server. Configure the SSIS package on the production server to use the new
file.
B. Back up the master database and restore it to the production server. Rename the
appropriate tables inside the master database.
C. Create a SQL Server Integration Services (SSIS) package configuration. Build a
deployment utility. Copy the deployment folder for your SSIS project to your production
server. Execute the manifest file.
D. Back up the msdb database and restore it to the production server. Rename the
appropriate tables inside the msdb database.

Answer: C

Explanation:
You have to use a SSIS package to accomplish this but you can not use
the package built for your development environment as the table names differ.

QUESTION 10
You are a database administrator for Certkingdom.com. You notice that one of the data files
on a SQL Server 2005 computer is corrupted. You need to restore the database from the
most recent set of backups. You want to perform this task as quickly as possible, with a
minimum loss of data. What should you do first?

A. Restore the most recent transaction log backup.
B. Restore the most recent full database backup.
C. Perform a full database backup.
D. Perform a transaction log backup.

Answer: D

Explanation:
In order to restore from the most recent set of backups, you have to
first ensure that you can restore all transactions that have occurred between the
time of the backup and the time when the database went corrupt. In order to
accomplish this you should backup the transaction log.

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

Microsoft 70-445 Q & A / Study Tools

2011-12-06T12:46:00.000-08:00

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

QUESTION 1
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package has the following features:
Two Data Flow tasks and two Control Flow tasks
A success constraint between each Data Flow task and the subsequent Control Flow task
The package uses one transaction for all the tasks.
You need to configure the package so that the two Data Flow tasks use their own transactions.
You also need to ensure that each Control Flow task is enlisted in the same transaction as its
preceding Data Flow task.
Which three actions should you perform? (Each correct answer presents part of the solution.
Choose three.)

A. Change the TransactionOption property to Supported for the package.
B. Change the TransactionOption property to Required for the package.
C. Change the TransactionOption property to Supported for each Data Flow task.
D. Change the TransactionOption property to Required for each Data Flow task.
E. Change the TransactionOption property to Supported for each Control Flow task.
F. Change the TransactionOption property to Required for each Control Flow task.

Answer: A, D, E

QUESTION 2
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The
package contains 30 Data Flow tasks and 30 Control Flow tasks. The package runs slower than
expected. You need to capture the start time the finish time and the elapsed time for the
validation and execution of the package. What should you do?

A. Enable the OnProgress event handler and use the Control Flow tasks to write the information
to a log.
B. Monitor the Progress tab during the execution of the package, and then monitor the
Execution Results tab.
C. Use the Performance Monitor tool to capture the counters from the SQL Server SSIS Service
object. Analyze the output for the required information.
D. Use the Performance Monitor tool to capture the counters from the SQL Server: SSIS
Pipeline object. Analyze the output for the required information.

Answer: B

QUESTION 3
Microsoft SQL Server Management Studio (SSMS) is installed on your workstation. Microsoft
Business Intelligence Development Studio (BIDS) is not installed on your workstation.
You need to create a package that must meet the following requirements:
It must be transactional.
It must be optimized for 20 tables.
It must be stored securely in the msdb database of a remote server.
What should you do?

A. Create the package by using DTS Designer.
B. Create the package by using the Package Migration Wizard.
C. Create the package by using the Microsoft SQL Server Import and Export Wizard.
D. On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, click the Create
Package submenu.

Answer: C

QUESTION 4
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
While testing, a Transact-SQL user-defined function causes duplicate key values that stop the
transformation.
To permit the transformation to continue, the package must perform the following tasks:
1. Ascertain which rows are affected.
2. Insert the rows that fail into a table.
3. Continue with the process.
You need to change certain properties in the package to meet the requirements.
Which three tasks should you perform? (Each correct answer presents part of the solution.
Choose three.)

A. Choose the Redirect Row option for the Error property on the key column.
B. Choose the Ignore Failure option for the Error property on the key column.
C. Choose the Fail Component option for the Error property on the key column.
D. Add a DataReader source to use a new Data Flow destination when the Failure constraint is fired.
E. Add a DataReader source to use a new Data Flow destination when the Completion
constraint is fired.
F. Edit the Error Output properties for each DataReader source and configure each data source for error handling.

Answer: A, D, F

QUESTION 5
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The package uses at least one sequence container in one transaction. Each transaction controls
a Data Flow task and a Control Flow task. Each Data Flow task has a Success constraint.
The Control Flow task follows the Success constraint. The package must include the following
requirements:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must succeed or fail as an atomic unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an
atomic unit.
You need to make changes in the control flow designer to meet the outlined requirements.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

A. Add all the Data Flow tasks and the Control Flow tasks to one sequence container.
B. Add a sequence container for each Control Flow task and the Data Flow task that precedes it.
C. Change the FailPackageonFailure property to true for each new sequence container that is
added to the package.
D. Change the FailPackageonFailure property to false for each new sequence container that is
added to the package.

Answer: B, C

QUESTION 6
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. An
Analysis Services Processing task in the package requires data from a file. The file is exported to
a file share.
If the file is not available on the file share, the Analysis Services Processing task must import data
from a remote Microsoft SQL Server 2005.
You need to add steps to the package to import the data.
What should you do?

Answer:

QUESTION 7
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package.
The OLE DB data source for the package is a database that is updated frequently.
You need to create a package that accomplishes the following tasks:
Implement the IRowsetFastLoad interface.
Support various data flow destinations.
Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

A. Use an OLE DR data flow destination.
B. Use a Recordset data flow destination.
C. Use a DataReader data flow destination.
D. Create separate data flow destinations within the same Data Flow task.

Answer: A, D

QUESTION 8
Your company's business intelligence (BI) model uses Microsoft SQL Server 2005 Integration
Services (SSIS). There are 20 packages that use the same configuration. The package
configuration is stored in an XML file as a variable.
You need to track the changes that affect a package that uses one variable. You also need to
modify the package to provide automatic notification by e-mail whenever there are changes to the
variable.
What should you do?

Answer:

QUESTION 9
You are designing a Microsoft SQL Server Integration Services (SSIS) package.
The package contains a single OLE DB data source. The package must be deployed on 10
servers. The package uses the XML configuration file to connect to a pre-assigned server.
You need to ensure that the package uses the correct server at runtime
What should you do?

Answer:

QUESTION 10
You are designing a Microsoft SQL Server 2005 Integration Services (SSIS) package. The
package is named UpdateTable.dtsx and contains a variable named runlD. The package must
run by using the dtexec utility. The runlD variable must be set at runtime to a value of 5. You need
to meet the outlined requirements. What should you do?

A. Execute dtexec /F "c:\ssisPackages\UpdateTable.dtsx" /SET
\packages.variables[runlD].Value;5.
B. Execute dtexec /F "c:\ssisPackages\UpdateTable.dtsx" /SET \packages.variables.runlD=5.
C. Create a text file that specifies the variable name and value in the format
package.variables[runlD].Value = 5. Execute dtexec /F "c:\ssisPackages\UpdateTable.dtsx"
/COM where is the name of the file you just created.
D. Create a text file that specifies the variable name and value in the format runlD=5. Execute
dtexec /F "c:\ssisPackages\UpdateTable.dtsx" /COM where is the
name of the text file you just created.

Answer: A

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