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

Role Of Short Online Quizzes In Exam Preparation

We’ve heard a lot about the conventional methods - classroom learning, practice exams, simulation-based testing - that have been employed to assist students in preparing for these key exams. Long tests and practice exams are often appropriate preparation methods however sometimes they may be too broad-based or inflexible to fit a student’s need to work on specific weak areas. Short, material-targeted practice quizzes have proven to be effective in helping students strengthen specific weak areas. Students who have used short quizzes in conjunction with traditional, practice exam preparation methods have reported strikingly positive results.

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

What makes short quizzes so effective in preparing for exams? A major factor is the ability of a short quiz to test a specific area of knowledge rather than all of the required material. For example, the SAT Critical Reading test contains two major sections of questions "reading comprehension" and "vocabulary in context" and even within these questions, different types appear. For example, a student may be very bad at summarizing a passage’s main focus, which in turn results in him getting a lower score every time on a major practice test. With shorter quizzes on only the main focus questions, the student will be able to quickly see how much room he has for improvement.

Pinpointing weaknesses, however, is only one part of the equation. With shorter quizzes, students can also receive customized feedback. Online practice quizzes in particular offer students the chance to receive instant feedback, which can be very helpful if a student is trying to "cram" for a big exam. Most students who take online practice quizzes agree that instant feedback is a major reason why they take the quizzes instead of simply reading preparation material or “cram sheets.” Candidates for IT certification, for example, will often need to read explanations for the answers to questions as many of the questions will test each candidate’s ability to analyze rather than to simply recall knowledge.

Online quizzes also offer the ability to include special media in questions that may appear on actual exams. For example, GED exams sometimes feature specialized images or pictures in order to assist the test-taker on a particular problem. Some IT or professional certification exams may even require a video demonstration of a particular problem to troubleshoot. All of this media and more can be included on an online practice quiz, which can significantly improve the testing experience and offer a great deal of realism to the test-taker.

The shorter length of the online quizzes combined with the customized feedback makes for an incredibly personalized and flexible exam preparation experience. Students note that while these large exams are useful to take as gauges or diagnostics, short quizzes are useful to improve on a specific weakness. In response, these same students have turned to a preparation regimen that includes both full-length exams and frequent quizzing.

It’s not by chance that so many students are using short, targeted online quizzes to quickly enhance their exam scores. The flexibility of these quizzes, coupled with their customizable feedback, offers to the test-taker the chance to improve on the areas that they need the most help with. In conjunction with classroom learning, everyday studying, and practice examinations, short quizzes can offer students the ability to significantly improve their performance on even the toughest exams.