- All Exams Instant Download
Which workload management feature should the Administrator use?
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?A . Flex ThrottleB . Utility SessionC . ExceptionD . FilterView AnswerAnswer: D Explanation: Filters in Teradata workload management allow...
How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?
How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?A . By accessing the Completed Queries portlet and selecting the Data Mover jobB . By using the Data Mover portlet accessing the log tabC . By viewing the job statistics tab of...
Which type of privilege is being used?
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?A . InheritedB . OwnershipC . AutomaticD . AssignedView AnswerAnswer: A Explanation: Inherited...
How does the SKEW factor affect the user's Perm space, assuming the total space consumed is under the specified perm space limit?
Given a user creation request on a 10-AMP system: CREATE USER hr_user AS PERM = 100e9 SKEW = 10 PERCENT, SPOOL = 100e9 SKEW = 20 PERCENT; How does the SKEW factor affect the user's Perm space, assuming the total space consumed is under the specified perm space limit?A ....
What is the best way to control access to each group's sensitive data?
A middle-tier application server logs on to the database as TrustedUser and submits requests on behalf of application end users. The server is shared by Finance and Human Resources groups and uses ProxyUser query band to identify end users to the database. Each group needs access to its own sensitive...
What is a use case for Data Mover?
What is a use case for Data Mover?A . Archiving data to a Hadoop systemB . Copying data between Vantage systems for active-active replicationC . Replicating data to a disaster recovery systemD . Copying data between Hadoop systemsView AnswerAnswer: C Explanation: Teradata Data Mover is primarily designed to copy and...
queries during a pre-defined critical batch state?
Which workload management technique should the Administrator use to reject all QueryGrid queries during a pre-defined critical batch state?A . An exception that includes the following Foreign Servers: TD_SYSFNLIB.QGInitiatorExport TD_SYSFNLIB.QGInitiatorlmport TD_SYSFNLIB.QGRemoteExport TD_SYSFNLIB.QGRemotelmportB . A filter that includes the following functions: TD_SYSFNLIB.QGInitiatorExport TD_SYSFNLIB.QGInitiatorlmport TD_SYSFNLIB.QGRemoteExport TD_SYSFNLIB.QGRemotelmportC . An exception that excludes the...
