A web application executes millions of tactical queries on different tables of a large Vantage system, as shown below:
The most frequent query of the application is using the following SQL with this variable parameter:
The application owner requested to check for optimizations to improve the runtime of the query.
What should the Administrator suggest in this situation?
A sparse join index can be used to store a subset of rows from a table based on the condition of the most frequently queried parameter, in this case, CustomerNumber. By creating a sparse join index on the Receiptline table with CustomerNumber as an input parameter, the query can access a smaller subset of the data more efficiently, which can significantly improve performance, especially when millions of tactical queries are involved.
The other options are less optimal for this situation:
Create a NUSI on Receiptline: While NUSIs can improve query performance, creating NUSIs on multiple columns (e.g., ProductTypeId, OrderTypeId, VendorId) may not be as effective for improving this specific query focused on CustomerNumber.
ALTER tables ProductType and OrderType: Using a sparse map for these small tables (55 and 175 rows) wouldn't provide much benefit in terms of performance improvement, as the issue is not with these tables but with the larger Receiptline table.
Use a global temporary table: While prefiltering data in a temporary table could help in certain situations, this adds complexity and maintenance overhead. Additionally, it wouldn't necessarily offer a significant performance boost compared to a sparse join index.
Which statement accurately characterizes privileges?
When a privilege is granted at the database level, it applies to all objects within the database, and this is reflected in DBC.AccessRights, which tracks access rights for users and roles on specific objects.
An Administrator reports a power user running a query that is consuming significant CPU in a final step product join and impacting other users due to the high priority of the workload.
Upon contacting the user in the application team, they are advised that the query is a request from the CEO and needs to be completed. The team decides to remediate the situation by changing the workload to a lower priority.
Which Viewpoint portlet should be used to make this adjustment?
The Workload Designer portlet in Viewpoint is used to manage and adjust workloads, including setting priorities for different workloads. To address the situation where a high-priority query is consuming too many resources, the Workload Designer can be used to adjust the priority of the workload that the query belongs to, ensuring that the impact on other users is reduced while still allowing the query to complete.
The other options are less suited for adjusting workload priorities:
Application Queries is used to monitor and manage queries related to specific applications but does not provide direct options to change workload priorities.
Query Monitor allows the monitoring of active queries and possibly aborting problematic queries but does not handle workload priority changes.
Workload Health is used for monitoring the health and performance of workloads, but it is not the tool used to modify priorities.
A role, TestingSprint, was created and assigned to members of a testing unit. This role is temporary in nature and will be dropped after the sprint ends. The manager of the testing unit is also assigned to the role and wants to drop it once work is complete.
Which option can the Administrator use to fulfill this request?
Granting a role with the WITH ADMIN OPTION allows the recipient (in this case, the manager) to not only use the role but also manage it. This includes the ability to drop the role when it is no longer needed, as requested by the manager.
An Administrator received reports that a high priority business intelligence (BI) report is failing. This report is a large transaction comprised of multiple SQL statements. Analysis revealed that a TASM filter is rejecting one of the SQL statements in the transaction, and this is causing the entire report to fail.
Which workload management adjustment could the Administrator take to prevent this report from failing?
By adding the application ID for the high-priority report to the filter Bypass list, the TASM (Teradata Active System Management) filter will no longer reject any SQL statements from this specific report. This ensures that the entire report can execute successfully without one of its statements being blocked, thereby preventing the report from failing.
Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits
Get All 72 Questions & Answers