EMC Exam Questions

What is the right approach of DQL query tuning when a user complains about performance problems?

What is the right approach of DQL query tuning when a user complains about performance
problems?

A.
1. trace operation with the Content Server installation owner account
2. locate SQL statement in session logfile
3. get the query plan for this SQL statement using database tools
4. tune the query and re-test the operation

B.
1. trace operation with the user or a user equivalent account
2. locate SQL statement in session logfile
3. get the query plan for this SQL statement using database tools
4. tune the query and re-test the operation

C.
1. trace operation with the user account
2. locate SQL statement in agentexec logfile
3. get the query plan for this SQL statement using database tools
4. tune the query and re test the operation

D.
1. trace operation with the repository owner account
2. locate SQL statement in agentexec logfile
3. get the query plan for this SQL statement using database tools
4. tune the query and re-test the operation