70-431 Microsoft SQL Server 2005 - Implementation and Maintenance
Note 2: 70-431 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 8.
You work as a database administrator at EliteCertify.com. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. Your duties at EliteCertify.com include administrating a SQL Server 2005 database named EliteCertify -DB09. EliteCertify -DB09 consists of a table that has 300 million rows of information. In this table some information is historical and some is current. You instruct him to partition the information on a single server in order to increase performance and optimize maintenance. What should you do?
A. You should implement vertical partitioning in order to increase the performance and optimize maintenance.
B. You should implement horizontal partitioning in order to increase the performance and optimize maintenance.
C. You should implement Distributed partitioning should be implemented by Rory Allen in order to accomplish this.
D. You should implement a raw partition.
Display Answer
Purchase Full Version:
70-431 Printable PDF Prep Guide $49.95 BUY NOW!
70-431 Test Simulation Engine $69.95 BUY NOW!
70-431 PDF & Test Simulation Engine $99.95 BUY NOW!
Answer: B
Explanation: Table and index partitioning - intended to improve performance of
operations performed on large tables. The basic concept is straightforward and
involves splitting a table into several units (called partitions), which can be accessed
independently of each other, limiting impact of I/O intensive activities performed on
the table's data (queries, data loads, backups and restores, maintenance tasks - such
as index rebuilds and defragmentations, as well as operations that would result in
lock escalation to the table level). The most common method of splitting data is
horizontal partitioning, in which rows of a table matching mutually exclusive
criteria (such as, range of dates or letters in alphabet, for datetime and character
data, respectively) are placed in designated partitions.
- Based on the latest 70-431 exam objectives!
- Designed like actual 70-431 exam questions!
- 100% Verified Realistic 70-431 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 70-431 Questions Included!
- Constantly Updated Guide to Reflect the Current 70-431 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
Demark
England
NY, USA
Keyword
