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

Exact2Pass Menu

Login / Register

Question # 4

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

A.

Column

B.

Degree

C.

Row

D.

Table

Full Access
Question # 5

Which object enables business users to efficiently access and easily understand data?

A.

Primary Key

B.

Primary Index

C.

View

D.

Trigger

Full Access
Question # 6

Which tool provides SQL Query Builder which gives the user a list of valid SQL statements?

A.

Data Stream Architecture (DSA)

B.

Teradata Viewpoint

C.

Teradata Index Wizard

D.

Teradata Studio

Full Access
Question # 7

What is the role of the Primary Key?

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

Full Access
Question # 8

Which attribute has to be defined at table creation?

A.

Secondary Index

B.

Block Size

C.

Column Data Type

D.

Fallback

Full Access
Question # 9

Which Teradata component provides bi-directional communication between virtual processors (vprocs)?

A.

Node

B.

Dispatcher

C.

BYNET

D.

Gateway (GTW)

Full Access
Question # 10

Which statement is true about explicitly granted privileges?

A.

Once granted, they can only be removed by dropping the user or database.

B.

Once granted, they cannot be removed.

C.

They can be granted directly to a user or a database.

D.

They can be granted only to permanent database users.

Full Access
Question # 11

Which data structure layer is primarily utilized by users of data marts?

A.

Shared Services

B.

Standardization

C.

Integration

D.

Access

Full Access
Question # 12

What is the flow of data in a data warehouse?

A.

Acquisition layer, integration layer, access

B.

layer Access layer, acquisition layer, integration layer

C.

Integration layer, access layer, acquisition layer

D.

Access layer, integration layer, acquisition layer

Full Access
Question # 13

What does the staging layer accomplish?

A.

It contains data that has been transformed.

B.

It provides user or application-specific data structures.

C.

It simplifies strategic data distribution.

D.

It maintains data in its raw and unprocessed format.

Full Access
Question # 14

What is the purpose of a role?

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

Full Access
Question # 15

Which Teradata component is responsible for managing the individual disk space?

A.

AMP

B.

Gateway (GTW)

C.

BYNET

D.

Parsing Engine (PE)

Full Access