Skip to main content

TE0-141 Online Exam

Teradata 14 Basics

126 questions available ยท Page 1 of 13

View study plans
Question 1 Drag & drop

DRAG DROP

For each characteristic on the left, identify the corresponding data protection feature from the right. Note that some features will be used more than once.

Question diagram
Show answer and explanation
Correct answer diagram
Question 2 Drag & drop

DRAG DROP

Match the warehouse architectural layer on the left with its purpose on the right.

Question diagram
Show answer and explanation
Correct answer diagram
Question 3 Drag & drop

DRAG DROP

Match the compression technique with the description.

Question diagram
Show answer and explanation
Correct answer diagram
Question 4 Drag & drop

DRAG DROP

For each measurement method on the left, identify the corresponding metric from the right. Note that some metrics will be used more than once.

Question diagram
Show answer and explanation
Correct answer diagram
Question 5 Multiple choice

What are two advantages of relational databases? (Choose two.)

  1. A

    Changing data conditions are reduced.

  2. B

    Rigid data structures provide faster access.

  3. C

    One copy of the data serves multiple purposes.

  4. D

    Flexibility of adding new business subject areas.

  5. E

    Specific data access paths for increased flexibility.

Show answer and explanation

Correct answers: D, E

Question 6 Single choice

Which Archive/Recovery Utility (ARC) statement would be used when transferring a table from one Teradata system to another?

  1. A

    Copy

  2. B

    Restore

  3. C

    Checkpoint

  4. D

    Rollforward

Show answer and explanation

Correct answer: B

Question 7 Multiple choice

What are two reasons a USI would be chosen instead of a NUSI? (Choose two.)

  1. A

    It minimizes the added overhead for the table.

  2. B

    It allows the TPump utility to be used with the table.

  3. C

    It is a two-AMP operation to access data when the USI is used.

  4. D

    It ensures that distinct data for the USI columns is inserted into the table.

Show answer and explanation

Correct answers: B, C

Question 8 Single choice

What is the maximum number of values per column that can be compressed using multi-value compression (MVC)?

  1. A

    126 plus nulls and zeroes

  2. B

    255

  3. C

    510 plus nulls and zeroes

  4. D

    1024

Show answer and explanation

Correct answer: A

Question 9 Multiple choice

What are two considerations when selecting a Primary Index? (Choose two.)

  1. A

    It should not be identical to the Primary Key.

  2. B

    It is the mechanism for assigning a row to an AMP.

  3. C

    It can be created or dropped at any time during the life of the table.

  4. D

    It should consist of a column or columns that are as unique as possible.

Show answer and explanation

Correct answers: C, D

Question 10 Multiple choice

Which three SQL coding constructs will result in a full table scan? (Choose three.)

  1. A

    accessing the table using any arbitrary set of columns

  2. B

    specifying a range of values for the primary index in the WHERE clause

  3. C

    using a non-equality clause when specifying a value for the primary index

  4. D

    referencing a value for each column of the primary index in the WHERE clause

Show answer and explanation

Correct answers: B, C, D