PrepAway - Latest Free Exam Questions & Answers

Category: E20-880 (v.1)

Exam E20-880: EMC VNX Solutions Expert Exam for Technology Architects (update January 25th, 2015)

What is the minimum number of disk spindles required to service the random I/O requests during usage of the SQ

A customer is in the design phase of their SQL server implementation. They request your
guidance concerning the number of disk drives needed to properly configure the database
for performance. The current utilization of the database is shown below:
S 85% reads and 15% writes
10K SAS disks
RAID 1/0
1150 IOPS
What is the minimum number of disk spindles required to service the random I/O requests
during usage of the SQL Server database?

which configuration best assigns the workloads?

Your customer has a new VNX solution configured with Flash, SAS, and NL-SAS drives.
The customer requires their OLTP, VDI, Software Development, and Regulatory Compliance
workloads to be distributed between the different drive types. Due to limited drive quantities
only one workload type can be configured using Flash drives.
According to best practices which configuration best assigns the workloads?

What is the minimum number of disk spindles required to service the random I/O requests during usage of the SQ

A customer is in the design phase of their SQL server implementation. They request your
guidance concerning the number of disk drives needed to properly configure the database
for performance. The current utilization of the database is shown below:
80% reads and 20% writes
10K SAS disks
RAID 5
1150 IOPS
What is the minimum number of disk spindles required to service the random I/O requests
during usage of the SQL Server database?

what state(s) of the database would the replication occur?

As a result of suffering a catastrophic failure, your customer has requested a DR solution.
The solution must introduce a higher level of availability for their Exchange 2010 system.
You have recommended a strategy that involves Replication Manager with native DAG.
In what state(s) of the database would the replication occur?

How can the customer increase available capacity to the archive server?

A customer has designed an environment using block based LUNs presented to individual
hosts. They have configured a pool to start using both thick and thin LUNs. One of the
standalone servers is an archive server running on Windows. They want to maximize
capacity on the standalone server since the data is no longer accessed. They have no more
drives to increase LUN capacity.
How can the customer increase available capacity to the archive server?

What should be done to improve performance during replication without affecting recovery data granularity?

A SQL Data Warehouse database is replicating between two VNX storage systems with
Incremental San Copy. The production database is on 15, 15k rpm SAS drives and the
Reserved LUN Pool uses five NL-SAS drives. The database is continuously updated locally
and replicated once a day to maximize the benefits of write folding. Replication takes place
from 6 PM until 10 PM. At 6 PM the storage administrator notices an increase in response
time of the application, which steadily improves until 10 PM. What should be done to
improve performance during replication without affecting recovery data granularity?

Why is the SQL application seeing increased disk response times from the local array?

A pair of VNX storage arrays is replicating between two data centers over an iSCSI
connection. The SQL Admin has noticed that a small OLTP database with a write size of 4k
periodically experiences increased disk response times. The Storage Admin reports that
during the same period, replication sessions are taking longer to complete. The Network
Admin reports degraded performance between the sites during the same period. Why is the
SQL application seeing increased disk response times from the local array?


Page 1 of 2412345...1020...Last »