TE0-121 Teradata Basics Practice Test Set 1

Which benefit is realized with Teradata's automatic storage management over the manual space management of other databases?


Options are :

  • Teradata data rows can be moved or re-blocked without database administrator (DBA) intervention.
  • Teradata provides overflow pages to support table growth which are pre-allocated to improve database performance.
  • Teradata analyzes space for objects that may be candidates for shrinking to release space for other applications. (Correct)
  • Teradata utilizes fixed-size pages to store data rows which improves reorganization performance

Answer : Teradata analyzes space for objects that may be candidates for shrinking to release space for other applications.

What type of processing is occurring when updating a table where all AMPs are involved?


Options are :

  • row
  • block (Correct)
  • set
  • page

Answer : block

Which two partitioning expressions are available to both single-level and multi-level partitioned tables? (Choose two.)


Options are :

  • MODULO_N partitioning
  • Direct partitioning on a numeric column (Correct)
  • CASE_N partitioning
  • RANGE_N partitioning (Correct)

Answer : Direct partitioning on a numeric column RANGE_N partitioning

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


Options are :

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

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

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 eliminate the need for a USI
  • to avoid the need to collect statistics on PARTITION
  • to improve data distribution across all partitions on all AMPs
  • to provide multiple access paths to rows in the base table (Correct)

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

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 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 partial index qualification gives the database a place to start qualifying rows thus avoiding a FTS. (Correct)
  • 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.

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


Options are :

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

Answer : Volatile tables Derived tables

What is an example of throughput and response time?


Options are :

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

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

What is a use of the Primary Index in the Teradata Database?


Options are :

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

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

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 :

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

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

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


Options are :

  • An application data model only looks at one aspect of the business whereas an enterprise logical data model integrates all aspects of the business.
  • 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)
  • 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.

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


Options are :

  • Write and Access
  • Read and Access
  • Read and Write (Correct)
  • Exclusive and Read (Correct)

Answer : Read and Write Exclusive and Read

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


Options are :

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

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

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 is a characteristic of how active data warehousing has evolved?


Options are :

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

Answer : It discovers patterns in customer buying habits.

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.
  • 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)
  • The opportunity for row collisions is increased.

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

Teradata builds its products for implementing a centralized data warehouse to promote which two design goals? (Choose two.)


Options are :

  • single data store (Correct)
  • single version of the truth
  • integrated logical data model
  • single copy of each transaction (Correct)

Answer : single data store single copy of each transaction

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


Options are :

  • 20%
  • 33% (Correct)
  • 50%
  • 25%

Answer : 33%

Which functionality is available through the SQL Assistant tool?


Options are :

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

Answer : SQL data encryption

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


Options are :

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

Answer : It is maintained automatically It reduces the need for costly and time consuming full-table backups.

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


Options are :

  • Node (Correct)
  • BYNET
  • AMP (Correct)
  • Gateway

Answer : Node AMP

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


Options are :

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

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

What is a characteristic of a dependent data mart?


Options are :

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

Answer : contains unique data

Which is a characteristic of a Foreign Key?


Options are :

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

Answer : identify table relationships

What is the typical purpose of the Semantic layer in an Enterprise data warehouse architecture?


Options are :

  • data storage
  • data cleansing
  • data views (Correct)
  • data transformation

Answer : data views

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


Options are :

  • automatic distribution of data
  • concurrent access and load
  • robust, parallel-aware Optimizer
  • single view of all data in the database (Correct)

Answer : single view of all data in the database

Which type of database is built around both set processing and row-at-a-time processing?


Options are :

  • data mart
  • inverted list (Correct)
  • relational
  • hierarchical
  • network

Answer : inverted list

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


Options are :

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

Answer : Row Hash Table Database

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 FastLoad utility loads the data into staging as a first step to loading
  • Transformations are not allowed when moving from the staging table to the target table (Correct)
  • The opportunity for row collisions is increased

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)
  • Fallback requires no additional space. (Correct)
  • Fallback protects data in the event of memory failure.
  • Tables with Fallback are fully available in the event of a down AMP

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions