What should the Administrator use to assist this client?

A client has a healthy system but often sees delays in some queries because of workload concurrency limits. These limits have been carefully chosen, so the client needs a solution that will not modify them.

What should the Administrator use to assist this client?
A . Use a system throttle.
B . Use Query Group Viewpoint gortjet to change the throttle limit temporally.
C . Use Flex Throttle option.
Use Query Monitor Viewpoint portlet to change query workloads.

View Answer

Answer: C

Explanation:

The Flex Throttle option allows the system to temporarily adjust workload concurrency limits based on system conditions. This provides more flexibility when handling spikes in query concurrency, without permanently modifying the established workload limits. Flex Throttle is ideal for handling temporary peaks in activity, helping to smooth out delays while keeping the core concurrency limits intact.

Option A (Use a system throttle) would enforce strict concurrency limits but doesn’t provide the flexibility needed in this scenario, where the client is trying to avoid modifying existing limits. Option B (Use Query Group Viewpoint portlet to change the throttle limit temporarily) suggests manually adjusting the throttle limit, which is not desirable in this case as the limits have been carefully chosen.

Option D (Use Query Monitor Viewpoint portlet to change query workloads) would involve changing the way queries are handled or prioritized but does not address the need to keep concurrency limits unchanged while still dealing with temporary delays.

Thus, Flex Throttle (Option C) provides the best solution to assist the client without altering the concurrency limits permanently.