CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. TDVAN5

Free TDVAN5 Exam Braindumps (page: 7)

Page 6 of 19
PDF with 72 Questions

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?

  1. Inherited
  2. Ownership
  3. Automatic
  4. Assigned

Answer(s): A

Explanation:

Inherited privileges are those that a user acquires based on their membership in a profile or role. In this case, the user has been assigned a profile that grants access to sensitive data, meaning the privilege to access that data is inherited through the profile. Option B (Ownership) refers to the privileges that the creator (owner) of a database object has over that object, but in this case, the user is accessing data through a profile, not ownership. Option C (Automatic) would suggest that the privilege is granted automatically without the need for an explicit assignment or inheritance, which doesn't apply here because the privileges are coming from a profile.
Option D (Assigned) refers to direct privileges granted to a user individually, but in this scenario, the user is accessing data through a profile, which means the privileges are inherited rather than directly assigned.



How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?

  1. By accessing the Completed Queries portlet and selecting the Data Mover job
  2. By using the Data Mover portlet accessing the log tab
  3. By viewing the job statistics tab of the Performance Data Collection portlet
  4. By submitting the datamove status -job_name command in the remote console

Answer(s): B

Explanation:

The Data Mover portlet in Viewpoint provides specific functionality for managing and monitoring Data Mover jobs. By accessing the log tab within the Data Mover portlet, the Administrator can review detailed logs, including the data volume that was transferred during the job execution. Option A (Completed Queries portlet) focuses on monitoring and analyzing completed queries but does not provide detailed insights into Data Mover jobs. Option C (Performance Data Collection portlet) is used for monitoring system performance but is not directly related to Data Mover job details or data transfer volumes. Option D (datamove status command) is a CLI (Command-Line Interface) method to check job status, but it is not related to monitoring the data volume within the Viewpoint environment.



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?

  1. Flex Throttle
  2. Utility Session
  3. Exception
  4. Filter

Answer(s): D

Explanation:

Filters in Teradata workload management allow the Administrator to define rules that restrict or block certain types of queries or connections based on specific criteria, such as the username, query client, or other attributes. In this case, the Administrator can use a filter to prevent queries from specific clients using the application's username, enforcing the security policy. Option A (Flex Throttle) is used to manage query concurrency and system resources dynamically but is not designed to enforce security policies like user restrictions. Option B (Utility Session) controls the number of utility sessions but does not help with filtering query clients based on usernames.
Option C (Exception) handles query workload exceptions based on certain thresholds or behaviors but doesn't directly enforce user or client restrictions.



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?

  1. 16 MB
  2. 32 MB
  3. 2 GB
  4. 8 GB

Answer(s): B

Explanation:

When using the NOS_READ function in Teradata to read data in CSV and JSON formats based on the LATIN character set, the maximum payload size that can be read is 32 MB. This limit ensures efficient processing and handling of large datasets, while also maintaining performance.






Post your Comments and Discuss TeraData TDVAN5 exam with other Community members:

TDVAN5 Discussions & Posts