MB2-421 Q & A / Study Guide

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

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

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

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

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

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

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