TE0-121 12 Teradata Basics Certification Practical Exam Set 2

Which three mechanisms are used to authenticate access to the Teradata Database? (Choose three.)


Options are :

  • passwords (Correct)
  • Single Sign-On (Correct)
  • access rights
  • LDAP (Correct)
  • views

Answer : passwords Single Sign-On LDAP

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Why would a USI be chosen instead of a NUSI?


Options are :

  • It does not add overhead to the table.
  • It ensures that unique data is inserted into the table. (Correct)
  • It is a single AMP operation.
  • It accesses all AMPs but is more efficient than a Full Table Scan (FTS).

Answer : It ensures that unique data is inserted into the table.

What could improve response time but could also decrease throughput?


Options are :

  • decrease priority of the workgroup
  • decrease the number of concurrent users
  • increase spool space for concurrent users
  • increase the number of concurrent users (Correct)

Answer : increase the number of concurrent users

What makes the rebuilding of indexes unnecessary with the Teradata database?


Options are :

  • Teradata File System
  • Teradata AMPS (Correct)
  • Teradata BYNET
  • Teradata Optimizer

Answer : Teradata AMPS

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Which is a key capability provided by the Teradata Parallel Database Extensions (PDE)?


Options are :

  • It monitors system performance.
  • It returns answer sets to the client
  • It controls virtual processor resources. (Correct)
  • It performs disk space management.

Answer : It controls virtual processor resources.

USER1 has been created with NO PERM space allocation. Which object can USER1 create in the USER1 database?


Options are :

  • permanent table
  • stored procedure (Correct)
  • macro
  • join index

Answer : stored procedure

What are two reasons to create a PPI table? (Choose two.)


Options are :

  • A PPI provides more efficient access to the secondary index sub-tables.
  • A PPI requires less physical space than a traditional primary index. (Correct)
  • A PPI allows for faster primary index access. (Correct)
  • The table is accessed via a range constraint query.
  • The query can take advantage of partition elimination.

Answer : A PPI requires less physical space than a traditional primary index. A PPI allows for faster primary index access.

NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 4

Which three describe the benefit of Teradata's scalability? (Choose three.)


Options are :

  • It provides a fault tolerant processing platform. (Correct)
  • It has the ability to support multiple concurrent users.
  • Disk space can be added without having to manually offload/reload the data. (Correct)
  • Processing power can be added without needing to change the data model.
  • It provides a single view of the business.
  • It allows users to submit ad hoc queries. (Correct)

Answer : It provides a fault tolerant processing platform. Disk space can be added without having to manually offload/reload the data. It allows users to submit ad hoc queries.

Which component is part of Teradata's open architecture?


Options are :

  • AMP
  • Operating System
  • Node
  • BYNET (Correct)

Answer : BYNET

What is a Role?


Options are :

  • a collection of access rights
  • a set of common user parameters (Correct)
  • a set of common logon privileges
  • a collection of account defaults

Answer : a set of common user parameters

TE0-121 12 Teradata Basics Certification Practical Exam Set 2

What is an example of throughput and response time?


Options are :

  • number of concurrent users accessing Teradata and number of requests (Correct)
  • time taken for a database shutdown and time taken for a database restart
  • time taken by one query and quantity of data returned
  • number of queries executed in one hour and elapsed time per query

Answer : number of concurrent users accessing Teradata and number of requests

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which functionality is available through the SQL Assistant tool?


Options are :

  • SQL data encryption (Correct)
  • SQL front-end tool
  • SQL debugger
  • SQL code generator

Answer : SQL data encryption

Which two effects occur as a result of building separate data marts instead of building a centralized data warehouse? (Choose two.)


Options are :

  • Ad-hoc queries using multiple subject areas offer better performance.
  • Pre-planned queries for a limited number of users can offer better performance. (Correct)
  • Database loading is easier to manage. (Correct)
  • Subject areas are repeated across the data marts.

Answer : Pre-planned queries for a limited number of users can offer better performance. Database loading is easier to manage.

On which two table types can a multi-level partitioned primary index (MLPPI) be created? (Choose two.)


Options are :

  • Compressed join indexes
  • Global temporary tables
  • Volatile tables (Correct)
  • Derived tables (Correct)

Answer : Volatile tables Derived tables

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

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


Options are :

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

Answer : to reduce the I/O for range constrained queries to improve performance of full table scans

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


Options are :

  • It is a collection of related rows and columns.
  • It is a collection of logically related tables. (Correct)
  • It is a collection of physically related tables.
  • It is a DBMS that is based on the relational model. (Correct)
  • It is defined by Primary and Secondary Keys.

Answer : It is a collection of logically related tables. It is a DBMS that is based on the relational model.

What is expected for a table with two columns defined for its primary index and a query qualified on the first column?


Options are :

  • The partial index qualification gives the database a place to start qualifying rows thus avoiding a FTS. (Correct)
  • The qualified column is directly accessed avoiding a Full Table Scan (FTS).
  • The qualified column is hashed giving direct access to the rows performing a FTS.
  • The primary index is partially qualified therefore requiring a FTS.

Answer : The partial index qualification gives the database a place to start qualifying rows thus avoiding a FTS.

NR0-016 NCR Teradata Application Development V2R5 Exam Set 1

For what reason would a multi-level partitioned primary index (MLPPI) be defined as opposed to a single-level partitioned primary index (PPI)?


Options are :

  • to avoid the need to collect statistics on PARTITION
  • to provide multiple access paths to rows in the base table (Correct)
  • to eliminate the need for a USI
  • to improve data distribution across all partitions on all AMPs

Answer : to provide multiple access paths to rows in the base table

Which statement is true regarding mini-batch data loads?


Options are :

  • The Insert/Select loads the data into staging as a first step to loading.
  • The opportunity for row collisions is increased.
  • Transformations are not allowed when moving from the staging table to the target table
  • The FastLoad utility loads the data into staging as a first step to loading (Correct)

Answer : The FastLoad utility loads the data into staging as a first step to loading

Which is a characteristic of a Foreign Key?


Options are :

  • identify data outside the database
  • identify table relationships (Correct)
  • one instance of columns in a table
  • no duplicates are allowed

Answer : identify table relationships

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two situations might cause the Optimizer to choose a Full Table Scan (FTS) even though secondary indexes have been created on the table? (Choose two.)


Options are :

  • There is no index value specified in the WHERE clause.
  • The data distribution is skewed. (Correct)
  • Database hints force the Optimizer to choose a FTS instead of an index.
  • The secondary index is weakly selective. (Correct)

Answer : The data distribution is skewed. The secondary index is weakly selective.

What information is utilized by the Teradata Optimizer to create the lowest cost execution plan? (Choose two.)


Options are :

  • the volume of data stored on the system (Correct)
  • the number of users currently executing queries (Correct)
  • the number of AMPs on the system
  • the current data demographics for the tables in the query

Answer : the volume of data stored on the system the number of users currently executing queries

What differentiates between the construction and use of an application data model versus an enterprise data model?


Options are :

  • An application data model is focused on how the data flows through the organization whereas an enterprise data model is focused on how the data is processed. (Correct)
  • An application data model only looks at one aspect of the business whereas an enterprise logical data model integrates all aspects of the business.
  • The application data model requires additional semantic validation in the development phase than the enterprise model does.
  • Applying data governance rules is a complex issue when creating application data models whereas it requires nominal incremental effort for an enterprise data model.

Answer : An application data model is focused on how the data flows through the organization whereas an enterprise data model is focused on how the data is processed.

TE0-121 Teradata Basics Practice Test Set 2

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


Options are :

  • It is defined at the table level, the database level, and the system level.
  • It reduces the need for costly and time consuming full-table backups. (Correct)
  • It is maintained automatically (Correct)
  • 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 is maintained automatically

Which statement is true regarding mini-batch data loads?


Options are :

  • The opportunity for row collisions is increased
  • Transformations are not allowed when moving from the staging table to the target table (Correct)
  • The Insert/Select loads the data into staging as a first step to loading.
  • The FastLoad utility loads the data into staging as a first step to loading

Answer : Transformations are not allowed when moving from the staging table to the target table

Which two are characteristics of Fallback? (Choose two.)


Options are :

  • Fallback protects data from failure of two disks in the same rank. (Correct)
  • Tables with Fallback are fully available in the event of a down AMP
  • Fallback requires no additional space. (Correct)
  • Fallback protects data in the event of memory failure.

Answer : Fallback protects data from failure of two disks in the same rank. Fallback requires no additional space.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which is a characteristic of how active data warehousing has evolved?


Options are :

  • It produces pre-defined reports.
  • It uses ad-hoc analysis with data at the detail level.
  • It makes decisions with event-based triggers.
  • It discovers patterns in customer buying habits. (Correct)

Answer : It discovers patterns in customer buying habits.

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


Options are :

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

Answer : It updates rows in multiple tables. It exports tables to client files.

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


Options are :

  • Index
  • Row Hash (Correct)
  • Table (Correct)
  • User
  • Database (Correct)

Answer : Row Hash Table Database

TE0-141 14 Teradata Basics Certified Practice Test Set 4

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.
  • All Channel PEs will migrate to another node in the clique (Correct)
  • The PEs will continue processing the previous request.

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions