1. Home
  2. Teradata
  3. Vantage Certified Associate
  4. TDBL1-16.20
  5. Teradata Vantage Associate Exam Questions and Answers

Pass the Teradata Vantage Certified Associate TDBL1-16.20 Questions and answers with CertsForce

 Teradata Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Options:
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

Questions # 2:

Which concept does a dimensional model implement to improve performance?

Options:
A.

Denormalization

B.

Row sizing

C.

Global access

D.

Parallelization

Questions # 3:

What makes Teradata faster than other database systems?

Options:
A.

Fault tolerance

B.

Parallel processing

C.

Scalability

D.

Single data store

Questions # 4:

What is a dimensional view?

Options:
A.

A fallback schema view that is layered over detail data of a fallback table and is used to compare fallback data to the detail data of the associated base table

B.

A view that is layered over a dimension table and provides statistics on the data in the table

C.

A virtual star or snowflake schema layered over detail data maintained in fully-normalized base tables

D.

A virtual view that is layered over a metadata table and presents a view of a single attribute of the data

Questions # 5:

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

Options:
A.

Alation

B.

Teradata Everywhere

C.

Teradata Workload Management

D.

Teradata Aster

Questions # 6:

What is the purpose of a role?

Options:
A.

To define privileges on objects for groups of users

B.

To define parameters such as spool space limit

C.

To define password parameters

D.

To identify trusted users

Questions # 7:

What is a use case for a Join Index?

Options:
A.

A one-time merge on a single table A table

B.

with multiple UDFs

C.

A frequent query with the same two tables

D.

A query that uses the Primary Index

Questions # 8:

What does a Primary Key uniquely identify in the table?

Options:
A.

A row

B.

An attribute

C.

A column

D.

A constraint

Questions # 9:

How is data made available for business users?

Options:
A.

Business users access data that is acquired, integrated, and made available via the access layer.

B.

Business users are given access to private sandboxes with no access to any data warehouse data.

C.

Business users are limited to interrogating data in the integration layer.

D.

Business users access canned reports run against the acquisition layer

Questions # 10:

What does a dimension table describe?

Options:
A.

The attributes of a fact table

B.

The detail table for each dimension

C.

The number of rows in a detail table

D.

The data types of a fact table

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions