Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

What is the name of a single instance of all the attributes in a relation?

A.

Column

B.

Degree

C.

Row

D.

Table

Which Teradata utility can be used to load data from a flat file to a populated table with transaction data?

A.

TPTLoad

B.

TPT Update

C.

TPT Operator

D.

FastLoad

The Teradata Database Data Dictionary is kept in which user?

A.

DBC

B.

SYSTEMFE

C.

TDWM

D.

SYSLIB

Which property allows a table to enforce proper values in each column/

A.

Data statistics

B.

Data parameters

C.

Data types

D.

Data phases

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

A.

Machine logs

B.

Data engines

C.

Business Intelligence tools

D.

Compute clusters

Which concept does a dimensional model implement to improve performance?

A.

Denormalization

B.

Row sizing

C.

Global access

D.

Parallelization

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?

A.

Authenticity verification

B.

Referential integrity

C.

Cross domain validation

D.

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

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

Which cloud environment includes dedicated infrastructure for Teradata Database?

A.

Google Cloud

B.

IntelliCloud

C.

Amazon Web Services

D.

Azure

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

A.

Provides uniform distribution

B.

Avoids locks

C.

Ensures referential integrity

D.

Allows duplicate values