TE0-141 questions and answers

Question 1

Multiple choice

Which three statements describe a hot standby node? (Choose three.)

1. A

   It is a member of a clique.

2. B

   It is a member of a cluster.

3. C

   It is powered off until needed.

4. D

   It can be brought into a configuration when a node fails.

5. E

   It can eliminate flow control by having standby AMPs available.

6. F

   It can eliminate an additional restart to bring a failed node back into service.

Reveal answer details Close answer details

Correct answersA, C, D

Question 2

Multiple choice

What are three data protection techniques used by Teradata? (Choose three.)

1. A

   archive to disk

2. B

   Vproc migration

3. C

   Transient journal

4. D

   RAID technology

5. E

   archive to alternate clique

Reveal answer details Close answer details

Correct answersA, B, C

Question 3

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

Reveal answer details Close answer details

Correct answerB

Question 4

Multiple choice

What are two components of an enterprise wide data warehouse architecture? (Choose two.)

1. A

   A virtual data warehouse with access directly against the operational data.

2. B

   Independent data marts that support various functions within the enterprise.

3. C

   A central repository built upon an integrated model that minimizes data movement.

4. D

   Dependent data marts built on appliances that support applications and are fed from the data warehouse.

Reveal answer details Close answer details

Correct answersB, C

Question 5

Multiple choice

Which two items describe a row in a relational table? (Choose two.)

1. A

   A single entity in a table

2. B

   An input from a single data source

3. C

   A value for every column in the table

4. D

   One instance of all the columns in a table

Reveal answer details Close answer details

Correct answersA, C

Question 6

Multiple choice

Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.)

1. A

   Restart paused queries

2. B

   Limit query concurrency

3. C

   Assign the CPUs to a workload

4. D

   Pause queries during execution

5. E

   Monitor Service Level Goals (SLGs)

Reveal answer details Close answer details

Correct answersC, D

Question 7

Multiple choice

What three functions does Teradata handle automatically? (Choose three.)

1. A

   Create users

2. B

   Collect statistics

3. C

   Execute queries in parallel

4. D

   Allocate space for data or indexes

5. E

   Redistribute data during an expansion

6. F

   utilize application-based workload management

Reveal answer details Close answer details

Correct answersA, B, D

Question 8

Multiple choice

What are three ways Teradata provides a low total cost of ownership? (Choose three.)

1. A

   Automatic data distribution

2. B

   Ease of setup and maintenance

3. C

   No reorganization of data needed

4. D

   Use of off-the-shelf standard hardware

Reveal answer details Close answer details

Correct answersA, B, D

Question 9

Single choice

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

1. A

   Accesses a subset of the rows

2. B

   Eliminates unnecessary columns

3. C

   Improves access to all columns in a row

4. D

   Eliminates rows that do not need to be read

Reveal answer details Close answer details

Correct answerA

Question 10

Multiple choice

Which two capabilities are provided by Unity Ecosystem Manager (formerly Teradata Multi-System Manager) to assist controlling the data warehouse environment? (Choose two.)

1. A

   End-to-end administration of the environment

2. B

   Auto notification of users regarding any environment problems

3. C

   Summaries of account strings and utilities running in the environment

4. D

   Workload performance and system resource usage balance across the environment

Reveal answer details Close answer details

Correct answersB, D

Question 11

Single choice

What is one reason a UPI would be defined for a table rather than a NUPI?

1. A

   To allow single I/O access

2. B

   To allow single-AMP access

3. C

   To ensure the uniqueness of rows

4. D

   To improve the performance of scalar queries

Reveal answer details Close answer details

Correct answerD

Question 12

Multiple choice

Which two hardware components provide redundancy in a Teradata MPP system? (Choose two.)

1. A

   AMP

2. B

   Node

3. C

   BYNET

4. D

   Parsing Engine (PE)

Reveal answer details Close answer details

Correct answersB, D

Question 13

Multiple choice

Which two mechanisms are used for identity validation to the Teradata Database? (Choose two.)

1. A

   Passwords

2. B

   Access rights

3. C

   Logon statement

4. D

   External stored procedures

Reveal answer details Close answer details

Correct answersC, D

Question 14

Multiple choice

Which two statements are true about a full table scan during select processing? (Choose two.)

1. A

   Every row of the table is read once.

2. B

   The data is redistributed across the AMPS.

3. C

   Performance is improved by subtable access.

4. D

   The spool file created may be equal to the size of the base table.

Reveal answer details Close answer details

Correct answersA, B

Question 15

Multiple choice

Which two statements are true for a NoPI table? (Choose two.)

1. A

   It allows single-AMP access.

2. B

   It allows loading duplicate rows using FastLoad.

3. C

   It will be rehashed, redistributed, and sorted to improve join access.

4. D

   It reduces skew in intermediate ETL tables which have no natural primary index.

Reveal answer details Close answer details

Correct answersA, D

Question 16

Multiple choice

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

1. A

   A relation

2. B

   A set of columns that uniquely identify rows

3. C

   A two-dimensional array of rows and columns

4. D

   A set of columns that ensure referential integrity

Reveal answer details Close answer details

Correct answersC, D

Question 17

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

Reveal answer details Close answer details

Correct answerA

Question 18

Single choice

Which statement is true about a relational database?

1. A

   It is a collection of attributes.

2. B

   It is a collection of logically related tables.

3. C

   It is a collection of physically linked tables.

4. D

   It is a collection of related files and attributes.

Reveal answer details Close answer details

Correct answerD

Question 19

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

Reveal answer details Close answer details

Correct answersB, C, D