Which action should be taken by the Administrator to assist this client?

A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries.

Which action should be taken by the Administrator to assist this client?
A . Use the Query Spotlight Viewpoint portlet to deprioritize the queries.
B . Use the Flex Throttle option.
C . Use a TASM system filter.
D . Use the Query Log Viewpoint portlet to identity and abort the harmful queries.

View Answer

Answer: C

Explanation:

Teradata Active System Management (TASM) allows the system administrator to control and manage query workload in real-time. A TASM system filter can be used to prevent or deprioritize certain types of queries, such as product joins or poorly written queries, that are consuming excessive resources. This approach ensures that problematic queries do not harm the overall system performance.

Query Spotlight Viewpoint portlet focuses on identifying and managing individual queries but does not provide the same level of proactive filtering and control as TASM system filters.

Flex Throttle is useful for controlling the concurrency of queries, but it doesn’t specifically address preventing or managing product joins in a way that would directly resolve the issue with poorly written SQL.

Query Log Viewpoint portlet would help in identifying and aborting harmful queries, but it’s a reactive approach rather than a proactive solution like using TASM system filters.