Free TDVCL2 Teradata Updates

Associate VantageCloud Lake 2.0 Exam Questions and Answers

Question 5

Which statement is true for tables stored in Object File System?

The tables should each have a Primary Index (PI) defined

Space used will be taken from the user's permanent allocation

Data is owned and managed outside the database

Some indexing or partitioning is done automatically

Question 6

How would data supplied via cloud object storage be processed?

Primary Compute nodes copy the data to Native Disk Store.

Compute Workers or Compute Clusters access the data directly.

Teradata Parallel Transporter is used to load the data to Object File System.

Session Manager places the data in spool.

Question 7

Which Vantage object contains one or more SQL statements, always executed as a single request?

Stored procedure

Fallback

Function

Macro

Question 8

What does an external directory server do in relation to External Roles?

Assigns system attributes

Maps to Internal Roles

Assigns database privileges

Maps to users