000-716 DB2 Data Warehouse Edition V9.1 Testking Exam

Demo Question 6.

A customer suspects that certain queries are not using their warehouse MQTs. They would like to manage long running queries for later inspection. They defined the long running queries as having an estimated cost above 100,000 timerons. How would they capture only the long running queries for analysis using Query Patroller Center to configure Query Patroller?

A. Configure a query class with a Min Cost equal to 100,000 and a Max Cost of 100,000,000,000. Use Historical Analysis to analyze the queries in the higher Query Class.
B. Configure the PUBLIC Submitters Class with a "Minimum cost to manage" above the threshold of queries to analyze. Use Monitoring -> Managed Queries to inspect the queries or input the queries to other DB2 tools.
C. Configure the Query Patroller System to intercept all applications and to save all intercepted queries. Use Historical Analysis to analyze the queries. Sort the results by "Elapsed Execution Time".
D. Configure 2 query classes; one with Max Cost equal to 100,000 and one with a Max Cost of 100,000,000,000. Configure only the higher Query Class to be managed. Use Historical Analysis to analyze the higher Query Class.


Display Answer

Answer: B

Explanation: