Which tool provides recommendations on how query processing performance can be improved by
modifying physical design structures such as indexes, indexed views, and partitioning?

Exchange 2010 is being virtualized on a VNX storage array in a VMware environment. Arraybased replicas will be used to provide data protection.
Which best practice should be followed to increase performance and reduce the meta data activity
on the VMFS volume?

You are in a design session with a customer of an ESXi 5.0 cluster. One of the stakeholders
inquires about vNUMA.

By default, what is the minimum number of CPUs in a vNUMA enabled environment?

A VNX for File administrator using SnapSure has created a recurring monthly cycle of
Checkpoints. The administrator has been tasked with changing this to a weekly cycle by deleting a
number of checkpoints.
What would you recommend to minimize performance impact?

Your customer has a VNX array with FAST Cache licensed with a single storage pool created.
They currently use the Storage Pool for their general production environment, but would like you to
design an environment that will support their Exchange 2010 deployment. There is sufficient free
space in the Storage Pool to accommodate their Exchange storage requirements.
Based on EMC best practice guidelines, which design would you recommend?

Your customer has a VNX array with FAST Cache licensed and two storage pools created. Only
Storage Pool A has FAST Cache enabled.
They currently use both Storage Pools for their general production environment, but would like you
to design an environment that will support their Exchange 2010 deployment. There is sufficient
free space in both Storage Pools to accommodate their Exchange storage requirements.
Based on EMC best practice guidelines, which design would you recommend?

Analyzer indicates that a LUN has a Queue Length of 2.3 and an Average Busy Queue Length of
5.1, and that Average Seek Distance is 25 GiB for the 300 GB disks used in the RAID Group.
Based only on these findings, which statement is true?

Replication Manager (RM) is being used to create replicas for a SQL server installed on VMFS
residing on an ESX server. The operations are sent from a separate virtual RM proxy host.
However, the RM is not able to successfully create copies.
What is the most likely cause of the failure?

Your customer would like to replicate their Oracle database between their two data centers. The
data centers are located approximately 1500 km apart.
Which array-based solution is best suited to replicate their database?

You have designed a VNX for File implementation for a customer data environment that involves a

high level of data duplication. The customer is concerned with disk efficiency, and you have
designed the system with the minimum number of disks necessary to meet expected storage
needs after deduplication.
The customer is initially pleased with the implementation. The decision is made to add a cycle of
SnapSure Checkpoints for backup and recovery purposes. Within weeks, deduplication
automatically aborts.
What would you recommend to get deduplication working again?