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

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

What is the role of the Primary Key?

Options:

A.

Provides alternate access path


B.

Uniquely identifies every row on the table


C.

Most direct access path


D.

Evenly distributes rows in the table


Expert Solution
Questions # 12:

A transaction table tracks customer account activity. An administrator wants to ensure that every customer account number in the transaction table has a matching entry in the customer table.

Which capability makes this an appropriate use case for a relational model?

Options:

A.

Authenticity verification


B.

Referential integrity


C.

Cross domain validation


D.

This is not an appropriate use case for a relational model.


Expert Solution
Questions # 13:

In the ecosystem architecture, end users will interact with which component?

Options:

A.

Machine logs


B.

Data engines


C.

Business Intelligence tools


D.

Compute clusters


Expert Solution
Questions # 14:

Which component is involved at the point of entry of data into a data warehouse?

Options:

A.

Query log


B.

Load utilities


C.

Data profiling


D.

System monitoring


Expert Solution
Questions # 15:

Which type of index can result in skewed table data?

Options:

A.

Primary Index


B.

Secondary Index


C.

Temporary Index


D.

Global Index


Expert Solution
Questions # 16:

The Teradata Database Data Dictionary is kept in which user?

Options:

A.

DBC


B.

SYSTEMFE


C.

TDWM


D.

SYSLIB


Expert Solution
Questions # 17:

What is a method to gain Teradata system access?

Options:

A.

Encryption services


B.

Profile Query Bands


C.

External authentication


D.

Final-tier application


Expert Solution
Questions # 18:

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?

Options:

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)


Expert Solution
Questions # 19:

Which table type should be defined to ensure that a table's utilized space will be automatically released at the end of a session?

Options:

A.

Spool


B.

Variable


C.

Temporary


D.

Interim


Expert Solution
Questions # 20:

Which locks are placed by the Archive/Recovery utility?

Options:

A.

Row Hash locks


B.

HUT locks


C.

READ locks


D.

Two-Phase locks


Expert Solution
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions