PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

what is the minimum number of spindles required to satisfy the performance needs of the database?

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 required to satisfy the
performance needs of the database?

What action should be taken to improve Site-A performance?

Refer to the exhibit.

A customer has a three-site configuration, where Site-A is running critical production applications,
Site-B receives data from Site-A in SRDF/S mode and is used exclusively for disaster recovery.
Site-C is a new location designed to receive data from Site-B using Cascaded SRDF. During the
initial establish of data between Site-B and Site-C, significant performance issues were
encountered at Site-A. What action should be taken to improve Site-A 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 “M:\”.
You have decided on RAID-1 protected 15,000 RPM drives for the new SQL environment.
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 43 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 cost effective solution should be suggested?

Refer to the exhibit.

A customer has a Symmetrix VMAX storage array which had a capacity add completed after one
year of service. Performance for a specific host application with large block I/O has not achieved
expected levels of performance. The customer requests a performance review and determination
of the problem.
You determine that FA processors are running 52% busy, FA ports have an average of 30 MB/s
and disks in the thin storage pool are 28% utilized. Which cost effective solution should be
suggested?

what is the minimum number of spindles required to satisfy the performance needs of the database?

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 “M:\”.
You have decided on RAID-1 protected 15,000 RPM drives for the new SQL environment.
Last week, you configured Perfmon to record the current IOPS load.
Following EMC best practices, what is the minimum number of spindles required to satisfy the
performance needs of the database?

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 “M:\”.
You have decided on RAID-1 protected 15,000 RPM drives for the new SQL environment.
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 43 GB worth of data.
Following EMC best practices, what is the minimum number of spindles that must be allocated for
optimal transaction log performance?