TE0-121 12 Teradata Basics Certification Practical Exam Set 3

What are two benefits of Single Table Join Indexes? (Choose two.)


Options are :

  • eliminate joins (Correct)
  • eliminate sorting
  • eliminate redistribution
  • eliminate base table access (Correct)

Answer : eliminate joins eliminate base table access

What is one advantage of relational databases?


Options are :

  • Predefined data access reduces indexing.
  • Rigid data structures provide faster access.
  • Changing data conditions are reduced. (Correct)
  • One copy of the data serves multiple purposes.

Answer : Changing data conditions are reduced.

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


Options are :

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

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

What is a characteristic of a dependent data mart?


Options are :

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

Answer : contains unique data

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


Options are :

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

Answer : inverted list

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


Options are :

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

Answer : Node AMP

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


Options are :

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

Answer : Exclusive and Read Read and Write

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


Options are :

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

Answer : Direct partitioning on a numeric column RANGE_N partitioning

Which two statements are true about a full-table scan (FTS)? (Choose two.)


Options are :

  • All AMPs scan their portion of the table in parallel.
  • Every data block of the table is read once. (Correct)
  • The data is redistributed across the AMPs. (Correct)
  • Performance is improved by subtable access.

Answer : Every data block of the table is read once. The data is redistributed across the AMPs.

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


Options are :

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

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

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

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


Options are :

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

Answer : 33%

What is a reason to use a USI over a NUSI when creating a table?


Options are :

  • They are needed for journaling. (Correct)
  • They are supported by the batch load utilities.
  • They ensure data uniqueness.
  • They are a one-AMP operation.

Answer : They are needed for journaling.

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


Options are :

  • row
  • set
  • page
  • block (Correct)

Answer : block

What is a key consideration in selecting a good primary index?


Options are :

  • enabling AMP-local joins to other tables
  • preventing duplicate rows from being inserted into a table
  • speeding up load utility processing (Correct)
  • ensuring even distribution of rows within join indexes built on a table

Answer : speeding up load utility processing

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

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


Options are :

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

Answer : data views

What tool is available for assigning resources to users?


Options are :

  • Teradata Workload Analyzer
  • Priority Scheduler
  • VprocManager (Correct)
  • ResUsage

Answer : VprocManager

Which statement is true for the Primary Key but not for the primary index?


Options are :

  • Once stored, its value should not be changed.
  • It may not contain duplicate values. (Correct)
  • It may be composed of one or more columns.
  • It may contain nulls.
  • It cannot be referenced in an SQL request.

Answer : It may not contain duplicate values.

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


Options are :

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

Answer : single view of all data in the database

Which functionality is available through the Teradata Parallel Data Pump (TPump)?


Options are :

  • end-to-end parallelism (Correct)
  • supports multiple scripting languages
  • near real-time updates
  • supports data exports

Answer : end-to-end parallelism

What differentiates a User from a Database?


Options are :

  • spool space
  • permanent space
  • tables (Correct)
  • password

Answer : tables

What is a reason to create a USI versus a NUSI?


Options are :

  • to ensure unique answer sets
  • to distribute the data for more efficient access (Correct)
  • to prevent duplicate rows
  • . to guarantee even data distribution

Answer : to distribute the data for more efficient access

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


Options are :

  • columns per table
  • BYNET bandwidth
  • nodes (Correct)
  • memory (Correct)

Answer : nodes memory

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 improve performance of queries using ranges (Correct)
  • to reduce the size of the query answer set
  • to improve performance of the duplicate row checking (Correct)

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

Which two reduce the likelihood of a Full Table Scan (FTS)? (Choose two.)


Options are :

  • The use of a WHERE clause in the query.
  • The primary index is fully qualified.
  • The primary index is defined as compressed. (Correct)
  • A surrogate key is defined on the index column. (Correct)

Answer : The primary index is defined as compressed. A surrogate key is defined on the index column.

Which three are characteristics of a Hot Standby Node? (Choose three.)


Options are :

  • is available to process data when system is too busy (Correct)
  • D. can be brought into a configuration when a node fails (Correct)
  • is a member of a clique
  • is turned off until needed (Correct)

Answer : is available to process data when system is too busy D. can be brought into a configuration when a node fails is turned off until needed

What is an Active Event?


Options are :

  • the capability to meet business objectives for system up-time in a mission critical environment
  • the activity or relevant transaction identified by the application of a business rule
  • the access of information quickly and consistently to support operational business processes (Correct)
  • the ability to dynamically manage a mixed workload environment

Answer : the access of information quickly and consistently to support operational business processes

Which single session processing type takes advantage of Teradata's parallel processing?


Options are :

  • row at a time (Correct)
  • set
  • group
  • singleton

Answer : row at a time

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


Options are :

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

Answer : single view of all data in the database

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions