teradata tdbl1-16-00 practice test

What is the primary value of the integration layer within the data warehouse architecture?

• A. Organize data based on specific business needs
• B. Provide shared views and services to help deliver data
• C. Promote reuse and cross-functional usage of data through common relationships
• D. Retain source data in original formats

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

• A. Logical
• B. System
• C. Independent
• D. Extended

Which authentication method may be used to validate a Teradata user?

• A. Automatic User Authentication
• B. Preferred User Authentication
• C. Permanent Database Authentication
• D. Teradata Database Authentication

Which table type contains a secondary copy of a table for redundancy?

• A. Global temporary table
• B. Secondary table
• C. Derived table
• D. Fallback table

Which Teradata UDA component deals with platform services such as On-Premises or Cloud
installations?

• A. Alation
• B. Teradata Everywhere
• C. Teradata Workload Management
• D. Teradata Aster

Which type of index can result in skewed table data?

• A. Primary Index
• B. Secondary Index
• C. Temporary Index
• D. Global Index

Which index would be likely to provide quick data access for two tables that are often queried
together on data for just the current year?

• A. A Multi-join Nonunique Secondary Index (NUSI)
• B. A Single Table Join Index
• C. A Sparse Join Index
• D. A Sparse Unique Primary Index (UPI)

When loading raw data, what is the initial point of entry into the data warehouse?

• A. Access layer
• B. Application layer
• C. Analytic layer
• D. Acquisition layer

What is a characteristic of a relational database?

• A. It provides unrestricted access to business data for all users.
• B. It provides a spontaneous approach to data management.
• C. It automatically relates tables throughout the database for shared usage.
• D. It promotes cross-functional usage of data through common relationships

Why would a Secondary Index be created?

• A. Redistribute the table data
• B. Allow additional columns
• C. Provide an alternate access path
• D. Reduce storage space