PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

what is the minimum number of spindles that must be allocated for optimal transaction log performance?

Click on the calculator icon in the upper left corner. Refer to the exhibit.

You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server migration.
Currently all user databases reside on a single locally attached disk enclosure, mounted to “N:\”.
You have decided on RAID-5 protected 15,000 RPM drives for the new SQL database and RAID-1
for the transaction log.
Last week, you configured Perfmon to record the current IOPS load of the databases during the 8-hour business day, Monday thru Friday as shown in the exhibit. During an average business day,
the transaction log processes 87 GB worth of data.
Following EMC best practices, what is the minimum number of spindles that must be allocated for
optimal transaction log performance?

which discount can be taken from the overall write IOPS, when calculating for the database writes?

Click on the calculator icon in the upper left corner. Refer to the exhibit.

You are designing the Symmetrix VMAX architecture for a DAS-to-SAN SQL Server migration.
Currently all user databases reside on a single locally attached disk enclosure, mounted to “N:\”.
You have decided on RAID-5 protected 15,000 RPM drives for the new SQL database and RAID-1
for the transaction log.
Last week, you configured Perfmon to record the current IOPS load of the databases during the 8-hour business day, Monday thru Friday as shown in the exhibit. During an average business day,
the transaction log processes 87 GB worth of data.
Following EMC best practices, which discount can be taken from the overall write IOPS, when
calculating for the database writes?

which configuration should be recommended?

Refer to the exhibit.

A customer is planning to replace an end-of-lease DMX-2500 with a new two engine VMAX.
Because the customer has reported some performance issues with the DMX, you have been
asked to analyze the DMX and recommend the VMAX configuration. This customer’s plan is for
10% growth over the next 24 months. The DMX has 256GB cache and 380 x 300GB-10K FC
drives. To avoid past performance issues but keep the cost low, which configuration should be
recommended?