EMC Exam Questions

What is the EMC recommended method for an application developer to identify the DQL queries that may

During single-user testing, the task list of a TaskSpace application takes over 10 seconds to
render.
What is the EMC recommended method for an application developer to identify the DQL queries
that may be the cause of the problems?

A.
Turn on database level tracing and give the trace data to an experienced DBA.

B.
Enable DFC tracing on the TaskSpace application server and convert the trace file to an Excelfriendly format using traceD6.awk.

C.
Install a proxy on the client machine and monitor the traffic with the TaskSpace application
server when clicking on the task list.

D.
Set the last_sql_trace flag in the repository’s server.ini on the Content Server and obtain all the
queries from the server log file.