Which workload management feature should the Administrator use?

An Administrator needs to enforce a security policy which prohibits the use of an application’s username from being used by certain query clients.

Which workload management feature should the Administrator use?
A . Flex Throttle
B . Utility Session
C . Exception
D . Filter

View Answer

Answer: D

Explanation:

Filters in Teradata workload management allow the Administrator to define rules that restrict or block certain types of queries or connections based on specific criteria, such as the username, query client, or other attributes. In this case, the Administrator can use a filter to prevent queries from specific clients using the application’s username, enforcing the security policy.

Option A (Flex Throttle) is used to manage query concurrency and system resources dynamically but is not designed to enforce security policies like user restrictions.

Option B (Utility Session) controls the number of utility sessions but does not help with filtering query clients based on usernames.

Option C (Exception) handles query workload exceptions based on certain thresholds or behaviors

but doesn’t directly enforce user or client restrictions.