TeraData TDVAN5 Actual Free Exam Questions & Community Discussion
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?
Which workload management feature should the Administrator use?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
An Administrator has been asked to improve the response time of the workloads in the tactical tier. Workloads are in all tiers of TASM. They are at CPU and I/O capacity, and they have AWT reserved for tactical. The Administrator begins by analyzing the data and the workload prioritization.
Which action should the Administrator take?
Which action should the Administrator take?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which workload management technique should the Administrator use to reject all QueryGrid queries during a pre-defined critical batch state?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
The Administrator has just created a new database object on a Vantage system.
Which privilege is NOT automatically granted to that database on itself?
Which privilege is NOT automatically granted to that database on itself?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
An Administrator has set up security constraints on columns holding sensitive data through the use of profiles. A user, with an appropriate profile, then issues a select against this sensitive data.
Which type of privilege is being used?
Which type of privilege is being used?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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?
Which DBQL option should be enabled?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A table that contains about two billion records is showing a bad response time for range-based queries on the order date column and frequently projects 10 out of 100 columns. The Administrator decides to convert the table to a column and row partitioned table.
Which resource is constrained?
Which resource is constrained?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A business' operating periods are event-driven, and the batch window begins and ends at various times of the evening. The Administrator needs to configure TASM to dynamically trigger the reporting planned environment using an API call issued when the batch window ends.
Which type of event can the Administrator use to meet this requirement?
Which type of event can the Administrator use to meet this requirement?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10