Exit demo TE0-141 Teradata 14 Basics PDF format · free preview

Teradata TE0-141 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/te0-141.html

Question 1
Single choice

What is a benefit of querying a table partitioned by column?

A.

Accesses a subset of the rows

B.

Eliminates unnecessary columns

C.

Improves access to all columns in a row

D.

Eliminates rows that do not need to be read

Question 2
Multiple choice

Which two statements are true for a centralized relational database? (Choose two.)

A.

Models businesses not processes.

B.

Presents a single copy of the data serving a single purpose.

C.

Allows businesses to quickly respond to changing conditions.

D.

Requires programs to be rewritten when a new field is added.

Question 3
Multiple choice

Which two statements apply more to tactical queries than to strategic queries? (Choose two.)

A.

They use minimal resources and run frequently.

B.

They have strict service level expectations defined.

C.

They are ad hoc in nature and submitted by end users.

D.

They are complex aggregations and joins are involved.

E.

They are used to determine business trends and patterns.

Question 4
Single choice

Which type of processing is associated with all-AMP operations?

A.

Set

B.

Row

C.

Page

D.

Block

Question 5
Single choice

If an INSERT...
SELECT is performed from a table with a UPI to a NoPI table, how will the data be organized?

A.

Rows will be redistributed to neutral AMPs.

B.

Rows will be stored on the same AMP where they currently reside.

C.

Rows will be sorted, then placed on the same AMP as the original table rows.

D.

ROWS will be redistributed to random AMPs based on the row hash of the original UPI.

Question 6
Single choice

What is a reason to use a USI versus a NUSI?

A.

To access data on a single AMP

B.

To provide single-row answer sets

C.

To prevent insertion of duplicate rows

D.

To evenly distribute the data across the AMPs

Question 7
Single choice

What is one benefit of a sparse join index?

A.

the elimination of the base table

B.

no additional maintenance needed

C.

the elimination of unnecessary rows

D.

the elimination of summary table maintenance

Question 8
Multiple choice

Which of the following are addressed in the semantic layer in the data warehouse? (Choose two.)

A.

It supports rapid experimentation and evaluation of data.

B.

It defines what a particular user community wants to see.

C.

It transforms abstracted data into a user-friendly structure.

D.

It provides the physical instantiation of the logical data model.

Question 9
Multiple choice

Which two statements are true about fallback? (Choose two.)

A.

AMPS will migrate to another node in the clique if a node fails.

B.

Data changed when an AMP is offline will be automatically restored.

C.

A copy of a primary row is stored on a different AMP in the same cluster.

D.

Fallback rows automatically migrate to the fallback system when the primary system goes down.

Question 10
Multiple choice

Which two items define a table? (Choose two.)

A.

A relation

B.

A set of columns that uniquely identify rows

C.

A two-dimensional array of rows and columns

D.

A set of columns that ensure referential integrity

Showing 10 of 126 questions · Unlock the full set