A system in Viewpoint is regularly reported as being in a critical state due to a lack of available AWT. No flow control is observed on the system. The Administrator identified that this is due to a recently completed cloud migration for the system that increased the number of available AWT from 80 to 120.Which process task is required to set up the system in Viewpoint to address this problem?
A capacity planner wants to keep a record of the number of rows that are added and deleted from certain tables over time and would like to obtain this information without having to change the application itself.Which DBQL option should be enabled?
The Administrator has received a request to add SELECT rights on the BusinessViews database to end users, developers, and batch accounts in the accounting unit. The following roles are set up for each group:The Administrator created the AcctShared role and will use it in a role nesting strategy to provide the required access.Which actions can the Administrator take to fulfill this request?
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?
Which statement accurately characterizes privileges?
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?
