- All Exams Instant Download
What is the maximum payload size for CSV and JSON data formats that the NOS_READ function can read, when it is based on the LATIN character set?
What is the maximum payload size for CSV and JSON data formats that the NOS_READ function can read, when it is based on the LATIN character set?A . 16 MBB . 32 MBC . 2GBD . 8GBView AnswerAnswer: B Explanation: When using the NOS_READ function in Teradata to read data...
An Administrator is configuring an alert service on a Vantage system and must define threshold levels and triggers for the alerts
DRAG DROP An Administrator is configuring an alert service on a Vantage system and must define threshold levels and triggers for the alerts. Match the Administrator's portlet to the correct use definition. (Each answer is used once.) View AnswerAnswer:
Which action should be taken by the Administrator to assist this client?
A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries. Which action should...
Which recommendation will help the merge step?
A customer is complaining that the creation of a large table in the lab environment is getting stuck in the merge step. The customer is using the following command to create the table: CREATE TABLE ... AS (SELECT * ...) WITH DATA Which recommendation will help the merge step?A ....
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...
