TE0-01A 12 Teradata Fundamentals Certification Practice Exam Set 1

What can happen to PEs that are on a node which fails?


Options are :

  • All LAN PEs will migrate to another node in the clique
  • Recovery will occur for the PEs on the failing node.
  • The PEs will continue processing the previous request.
  • All Channel PEs will migrate to another node in the clique.

Answer : All Channel PEs will migrate to another node in the clique.

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

What are two ways to improve both response time and throughput? (Choose two.)


Options are :

  • by increasing the number of nodes
  • by implementing workload management
  • by increasing the number of sessions on the system
  • by increasing the number of parsing engines
  • by increasing the number of concurrent queries

Answer : by increasing the number of sessions on the system by increasing the number of concurrent queries

What is a characteristic of a dependent data mart?


Options are :

  • is the system of record
  • sourced from operational systems
  • contains unique data
  • subset of data often used by a department

Answer : sourced from operational systems

What describes the benefit of Teradata's scalability?


Options are :

  • It allows users to submit ad hoc queries.
  • It provides a single view of the business.
  • Processing power can be added, without needing to change the data model.
  • It provides a fault tolerant processing platform.

Answer : It provides a fault tolerant processing platform.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What is the difference between response time and throughput?


Options are :

  • Response time measures the queries processed per second and throughput measures the volume of transactions received.
  • Response time measures the performance of a CPU and throughput measures I/O performance.
  • Response time measures network delay and throughput measures the performance of the PEs.
  • Response time measures the average duration of the queries and throughput measures the quantity of queries completed during a time interval.

Answer : Response time measures the performance of a CPU and throughput measures I/O performance.

Which is a characteristic unique to an Active Data Warehouse (ADW)?


Options are :

  • single view of the business
  • data freshness
  • dimensional data
  • mature optimizer

Answer : dimensional data

Which two are reasons a UPI could be defined for the table instead of a NUPI? (Choose two)


Options are :

  • to guarantee even distribution of the table rows
  • to reduce the size of the query answer set
  • to improve performance of queries using ranges
  • to improve performance of the duplicate row checking

Answer : to improve performance of queries using ranges to improve performance of the duplicate row checking

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

When comparing a Primary Key and a Primary Index, which statement is true only for the Primary Index?


Options are :

  • It supports table access using alternate, less frequently used paths.
  • It uniquely identifies each row in the table.
  • It can improve join performance.
  • It ensures referential integrity of the data.

Answer : It ensures referential integrity of the data.

Which two refer to a row in a relational table? (Choose two.)


Options are :

  • a single entity in a table
  • a set of columns from one data source
  • a set of columns stored in an implied order
  • one instance of all the columns in a table

Answer : a single entity in a table a set of columns from one data source

At which three levels is locking supported on Teradata? (Choose three.)


Options are :

  • Index
  • Database
  • User
  • Row Hash
  • Table

Answer : Database User Table

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 2

Which three are terms that are associated with star schema and dimensional modeling? (Choose three.)


Options are :

  • attributes
  • snowflakes
  • facts
  • entities

Answer : attributes facts entities

Which two statements are true about a Relational Database? (Choose two.)


Options are :

  • It is defined by Primary and Secondary Keys.
  • It is a collection of related rows and columns.
  • It is a collection of logically related tables.
  • It is a collection of physically related tables.

Answer : It is defined by Primary and Secondary Keys. It is a collection of physically related tables.

What is one purpose of the Primary Index in the Teradata Database?


Options are :

  • to enable compression on the data to improve query performance
  • to ensure enough AMPs are involved to reduce query processing time
  • to provide a constraint to ensure Referential Integrity
  • to support efficient data access

Answer : to ensure enough AMPs are involved to reduce query processing time

NR0-016 NCR Teradata Application Development V2R5 Exam Set 3

How much space is used as overhead when using RAID-1?


Options are :

  • 50%
  • 33%
  • 20%
  • 25%

Answer : 33%

Which two can be increased because of Teradata's linear scalability? (Choose two.)


Options are :

  • BYNET bandwidth
  • columns per table
  • memory
  • nodes

Answer : memory nodes

NR0-016 NCR Teradata Application Development V2R5 Exam Set 2

Which two describe Perm space? (Choose two.)


Options are :

  • used to store index subtables
  • used to store data rows for tables
  • used to hold data for global temporary tables
  • used to hold work tables while a query is running
  • used for Transaction rollback data

Answer : used to store index subtables used to hold data for global temporary tables

Which two actions can a user with no PERM space allocation perform on the system? (Choose two.)


Options are :

  • execute queries
  • execute index compression
  • . create userid owned tables
  • create userid owned views

Answer : . create userid owned tables create userid owned views

What are access rights?


Options are :

  • mechanisms for logging on to the database
  • named collection of SQL statements
  • privileges on database objects
  • common set of user parameters

Answer : common set of user parameters

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which utility supports table loading, updating and streaming of updates?


Options are :

  • TPT
  • MultiTool
  • TSET
  • FastLoad

Answer : TSET

What are three varieties of data marts? (Choose three)


Options are :

  • OLAP
  • Independent
  • Logical
  • Dependent

Answer : OLAP Independent Dependent

What are two reasons a customer would choose table partitioning? (Choose two.)


Options are :

  • to improve performance of full table scans
  • for better distribution of data between the AMPs
  • for the ability to archive specific partitions in a table
  • to reduce the I/O for range constrained queries

Answer : for better distribution of data between the AMPs to reduce the I/O for range constrained queries

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which two are features of TPump? (Choose two.)


Options are :

  • It uses row-hash locks.
  • It exports tables to client files.
  • . It updates rows in multiple tables.
  • It loads data a block at a time.

Answer : . It updates rows in multiple tables. It loads data a block at a time.

Which two will cause the Optimizer to choose a Full Table Scan (FTS)? (Choose two.)


Options are :

  • The number of data blocks accessed is a small percentage of the table.
  • A value is not provided for the primary index.
  • There is no WHERE clause specified in the query.
  • There is a single row in the answer set.

Answer : The number of data blocks accessed is a small percentage of the table. A value is not provided for the primary index.

Which nodes receive migrating vprocs during node failure in a multi-node system with multiple cliques?


Options are :

  • Nodes in the same clique.
  • Non-TPA nodes on the system.
  • The least busy node on the system.
  • Vprocs will wait until the node is repaired.

Answer : Non-TPA nodes on the system.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which two are advantages of a centralized data warehouse and are disadvantages of physically separate data marts? (Choose two.)


Options are :

  • It stores aggregate data instead of detailed data.
  • It includes specific data models.
  • It avoids row at a time processing.
  • It is less likely to repeat data.
  • It offers analytical users an historical view of multiple subject areas.

Answer : It stores aggregate data instead of detailed data. It includes specific data models.

Which two lock levels are compatible with each other? (Choose two.)


Options are :

  • Write and Access
  • Read and Write
  • Read and Access
  • Exclusive and Read

Answer : Read and Write Exclusive and Read

Which are two ways the Transient Journal (TJ) ensures data integrity? (Choose two.)


Options are :

  • It provides full-table recovery to a specific point in time.
  • It provides full-database recovery to a specific point in time.
  • It records changed rows automatically.
  • It provides transaction rollback when transactions fail.

Answer : It provides full-database recovery to a specific point in time. It provides transaction rollback when transactions fail.

TE0-124 Teradata 12 Database Administration Practice Exam Set 1

Which tool is available for reviewing historical workload?


Options are :

  • Teradata Manager
  • Teradata Administrator
  • Teradata Query Scheduler
  • Teradata MDS

Answer : Teradata Administrator

Which two are characteristics of the Transient Journal (TJ)? (Choose two.)


Options are :

  • It is maintained automatically
  • It reduces the need for costly and time consuming full-table backups.
  • It is defined at the table level, the database level, and the system level.
  • It provides rollback of changed rows for transactions failing to complete.

Answer : It reduces the need for costly and time consuming full-table backups. It provides rollback of changed rows for transactions failing to complete.

What distinguishes throughput from response time?


Options are :

  • Throughput is a measurement of BYNET activity. Response time is a measurement of completed work.
  • Throughput is a measurement of node parallelism. Response time is a measurement of BYNET messaging.
  • Throughput is a measurement of how long it takes a query to complete. Response time is a measurement of node activity.
  • Throughput is a measurement of the amount of work that is processed. Response time is a measurement of process completion.

Answer : Throughput is a measurement of BYNET activity. Response time is a measurement of completed work.

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions