Symmetrix Solutions Expert Exam for Implementation Engineers v6.0

You are having a discussion with a customer regarding Microsoft SQL Server 2005 database layout and the topic of separating the data and log files arises. They want to know that in addition to performance, if there is another reason for selecting separate volumes for their data and log files.
How would you respond to the customer's inquiry?

A customer has a mission-critical Microsoft SQL Server environment on a Symmetrix V-
Max storage array. They have implemented the TimeFinder/SQL Integration Module
(TF/SIM) for remote backups.
What are prerequisites for executing a remote backup using tsimsnap?

You have been asked to configure a Cascaded SRDF solution at a customer site. The production site will be at Site A, the synchronous target will be at Site B, and the asynchronous target at Site C.
Which kind of RDF devices will be needed at each site?

A customer needs to move a large amount of data from a standard device on a Symmetrix
DMX to a new Symmetrix V-Max with SRDF Adaptive Copy Disk. On the current source
DMX, cache and disk directors have 70% utilization. You have determined that the SRDF will need to be delayed by 125 milliseconds.
Which value does the Quality of Service need to be set to in EMC Ionix ControlCenter?

A customer has purchased Enterprise Flash Drives (EFD) for their Symmetrix V-Max array.
The customer is considering how to use these drives effectively.
Which application workloads are good candidates to migrate to the Enterprise Flash
Drives?

You are analyzing a performance problem using the total host queue and the I/O transmission times. Which measure can be derived from these two metrics?

A customer has migrated a Microsoft Exchange 2007 server with several very active mailbox databases to their Symmetrix V-Max. In addition, they have decided to integrate host-based fault tolerance by utilizing Microsofts native continuous replication technology.
Which database feature, provided by Exchange to reduce the chance of data loss, will also increase disk capacity requirements on this busy mailbox server?

Which change in a Symmetrix array's workload will typically result in an increase in the read hit rate?

Which SRDF/CE component is responsible for performing SRDF operations such as failover, failback, and group creation?

A Symmetrix V-Max array is configured with RAID 1 and RAID 6 (14+2) devices. In order to implement Symmetrix Optimizer, which types of devices need to be configured?

Which type of read workload produces the worst Symmetrix cache performance?

A Symmetrix V-Max is shared between a customer's sales and engineering departments.
The customer has the following requirements:
1. A specific user from the sales department should be allowed to execute TimeFinder commands on the devices set aside for sales using a Solaris host.
2. The same user should not be allowed control over devices belonging to engineering.
3. No other user with an account on the Solaris host should be able to exercise the same controls specified in the first two requirements.
Which combination of access control permission and user-based authorization role will fulfill this requirement?

A customer is using Oracle 11g with flashback functionality enabled with a retention period of 24 hours. A TimeFinder/BCV copy of the database is taken every evening at midnight.
The customer becomes aware of a transactional corruption in the database at 3:00 P.M.
A plan to fix the database needs to be presented for approval. The plan must specify which changes need to occur with the database to recover as much of the data as possible. How can the customer identify the exact point of corruption?

TimeFinder/SQL Integration Module (TF/SIM) was configured for a customer several months ago. Recently, the customer experienced a corruption to one of their production databases named "Custinfo". While attempting to recover the database, the customer located the path to the required metadata file. However, they are unsure which file is needed for replay of their transaction log backups.
Which filename should the customer be directed to in order to recover the VDI metadata file?