A performance analyst notices that several tactical queries are experiencing high and variable response times. Using the `ResUsage` tables, the analyst wants to determine if the issue is caused by AMP-level CPU contention rather than I/O waits or delays. Which combination of `ResUsage` metrics provides the most direct evidence of CPU queuing at the AMP level?
An administrator needs to prevent large product join queries from executing during a critical reporting window (5 PM - 7 PM). The goal is to reject only those specific queries without impacting other user activities. Which Teradata Active System Management (TASM) feature is the most precise and effective tool for this requirement?
A data lake team wants to use Teradata Vantage to query large volumes of Parquet and CSV files stored in an Amazon S3 bucket without performing a full ETL process. They plan to use Native Object Store (NOS) for this purpose. Which of the following statements are key benefits of using NOS for this scenario? (Select TWO)
A large retail corporation uses a Teradata Vantage system for its primary sales data warehouse. The `SALES_TRANSACTIONS` database is over 50 TB and grows by approximately 200 GB daily. The business has a strict Recovery Point Objective (RPO) of 1 hour and a Recovery Time Objective (RTO) of 4 hours for this database. The database must remain online and available for queries during backup operations. The DBA team is tasked with designing a new backup strategy. They have access to a high-speed network and a dedicated backup server with ample storage. They are using the Teradata Data Stream Architecture (DSA). The strategy must minimize the backup window, meet the RPO/RTO, and allow for point-in-time recovery. They must also consider the performance impact on the production system during the backup process. Given the requirements, which backup strategy should the DBA team implement for the `SALES_TRANSACTIONS` database?
A security auditor needs to generate a report of all failed logon attempts and any granted privilege modifications that occurred over the last quarter. The auditor needs to query the system tables directly to get this information. Which two tables in the `DBC` database are essential for this task?
True or False: A user profile in Teradata Vantage can be used to enforce password complexity rules, but it cannot be used to set a default database for a user.
A critical query is performing poorly because the optimizer is generating a bad plan based on inaccurate row count estimates for a highly skewed join column. Recalculating full statistics is too resource-intensive to be done frequently. What is the most effective and least disruptive method to provide the optimizer with more accurate information about this skewed column?
An administrator receives an alert that the Teradata system is running low on available spool space. The administrator needs to quickly identify which specific user sessions and queries are currently consuming the most spool space to take corrective action. Which Teradata Viewpoint portlet is the best tool for this immediate investigation?
An administrator needs to implement a dynamic workload management strategy that changes workload priorities based on the time of day and day of the week (e.g., Business Hours, Batch Window, Weekend). Which TASM components should be configured to achieve this?
A database is consistently running out of temporary space during the execution of complex analytical queries that use volatile tables. The administrator has already increased the `TEMP` space allocation for the user profile. What is the next logical step to diagnose the root cause of the excessive temporary space usage?