Vantage Certified Associate TDBL1-16.20 Book

Teradata Vantage Associate Exam Questions and Answers

Question 5

Which type of data mart is constructed from the actual data warehouse with the help of a semantic layer of SQL Views?

Logical

System

Independent

Extended

Question 6

What does Row-Level Security provide?

It allows for control of access to users by row number

It allows for a table creator to assign ownership of individual rows in a table to different users.

It allows for encryption of each row individually in a table by different user selectable algorithms.

It allows users to only see specific rows in a table.

Question 7

What does a dimension table represent?

Information that describes the attributes of a fact table

Information that describes the structure of the database

Information that describes the metadata of the database

Information that describes the location of data in the fact table

Question 8

What is an advantage of a Unique Primary Index (UPI)?

Provides uniform distribution

Avoids locks

Ensures referential integrity

Allows duplicate values