TE0-121 Teradata Basics Practice Test Set 6

What differentiates a User from a Database?


Options are :

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

Answer : tables

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


Options are :

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

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

What are three reasons to use views? (Choose three.)


Options are :

  • Views return a single row at a time with each invocation.
  • Views provide a materialized answer set. (Correct)
  • Views provide security for restricting table access and updates. (Correct)
  • Views provide a mechanism to include a locking modifier (Correct)

Answer : Views provide a materialized answer set. Views provide security for restricting table access and updates. Views provide a mechanism to include a locking modifier

Which two functions are available through the Teradata System Emulation Tool? (Choose two.)


Options are :

  • It works closely with the Optimizer to evaluate load utility responsiveness
  • It allows the user to capture system cost parameters.
  • It generates query plans on test systems as though they were run on production. (Correct)
  • It recommends index improvements. (Correct)

Answer : It generates query plans on test systems as though they were run on production. It recommends index improvements.

Which two application interfaces are used by Windows applications? (Choose two.)


Options are :

  • WinDBC (Correct)
  • TS/API
  • TDP (Correct)
  • ODBC

Answer : WinDBC TDP

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


Options are :

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

Answer : single view of all data in the database

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


Options are :

  • to improve performance of the duplicate row checking (Correct)
  • 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

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

How does the Transient Journal (TJ) ensure data integrity?


Options are :

  • It keeps an after-image copy of changed rows on each AMP. Upon transaction failure, the changes are rolled back. (Correct)
  • It keeps a before-image copy of changed rows in memory. Upon transaction failure, the changes are rolled back.
  • It keeps an after-image copy of changed rows in memory. Upon transaction failure, the changes are rolled back.
  • It keeps a before-image copy of changed rows on each AMP. Upon transaction failure, the changes are rolled back.

Answer : It keeps an after-image copy of changed rows on each AMP. Upon transaction failure, the changes are rolled back.

Which three functions are performed by Teradata when a user submits a query? (Choose three.)


Options are :

  • The Optimizer evaluates the SQL statement for proper syntax (Correct)
  • The AMPs retrieve the data from their vdisk.
  • The Dispatcher passes steps to the BYNET.
  • The BYNET performs any output data conversion on the answer set. (Correct)
  • The BYNET merges the answer set. (Correct)

Answer : The Optimizer evaluates the SQL statement for proper syntax The BYNET performs any output data conversion on the answer set. The BYNET merges the answer set.

Which is the definition of a Primary Key?


Options are :

  • a set of logically related columns
  • a set of rows that uniquely identify data
  • a set of columns that uniquely identify a row (Correct)
  • a relationship between tables

Answer : a set of columns that uniquely identify a row

Which application interface is used by BTEQ?


Options are :

  • OLE DB (Correct)
  • ODBC
  • JDBC
  • CLIv2

Answer : OLE DB

Which Teradata concept allows more than one model generation?


Options are :

  • Coexistence
  • Virtual Reconfiguration
  • Time sharing (Correct)
  • Node sharing
  • Cohabitation

Answer : Time sharing

What is a function of the Teradata Workload Analyzer tool?


Options are :

  • recommends appropriate workload goals
  • maintains mapping to rule sets
  • recommends query optimization (Correct)
  • maintains workload definitions

Answer : recommends query optimization

What are two reasons an access lock is used? (Choose two.)


Options are :

  • to perform a dirty read (Correct)
  • to increase the priority of the query running (Correct)
  • to be able to gain access to a table before rights are given
  • to be able to read data that is currently being written by another process

Answer : to perform a dirty read to increase the priority of the query running

What is a reason to choose a NUPI rather than a UPI when creating a new table?


Options are :

  • to allow the use of null
  • to guarantee even row distribution
  • to avoid skewing of the data (Correct)
  • to allow duplicate values

Answer : to avoid skewing of the data

Which two can increase the efficiency of a Full Table Scan (FTS)? (Choose two.)


Options are :

  • a UPI on the table
  • the number of physical reads exceeds the number of data blocks (Correct)
  • multiple secondary indexes on the table (Correct)
  • even data distribution

Answer : the number of physical reads exceeds the number of data blocks multiple secondary indexes on the table

Which two statements apply more to tactical queries than to strategic queries? (Choose two.)


Options are :

  • They are associated with clearly-defined service level expectations. (Correct)
  • They are often used to identify business trends and patterns.
  • They often involve complex joins and aggregations. (Correct)
  • They are usually ad hoc queries submitted by end users.
  • They are short, highly-tuned, and repetitively executed.

Answer : They are associated with clearly-defined service level expectations. They often involve complex joins and aggregations.

What is one use of the primary index in the Teradata Database?


Options are :

  • to determine the partitioning sequence for a table
  • to support value-ordered access in the database
  • to determine data distribution across the AMPs
  • to uniquely identify each row in the table (Correct)

Answer : to uniquely identify each row in the table

What are two features of MultiLoad? (Choose two.)


Options are :

  • merge data from two tables into one table (Correct)
  • upsert data to multiple tables (Correct)
  • insert data into empty tables
  • split data from one table into two tables

Answer : merge data from two tables into one table upsert data to multiple tables

What is an Active Event?


Options are :

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

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

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


Options are :

  • prioritize the workload (Correct)
  • assign users to a profile (Correct)
  • provide more consistent response times
  • maintain database space

Answer : prioritize the workload assign users to a profile

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


Options are :

  • execute index compression (Correct)
  • create userid owned tables
  • create userid owned views (Correct)
  • execute queries

Answer : execute index compression create userid owned views

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


Options are :

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

Answer : AMP Node

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


Options are :

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

Answer : Single Sign-On passwords LDAP

Which two statements are true about data integration utilities? (Choose two.)


Options are :

  • BTEQ allows import/export across all supported platforms.
  • SQL Assistant supports report writing and formatting features. (Correct)
  • BTEQ is limited to using one session.
  • FastExport is used to export large amounts of data (Correct)

Answer : SQL Assistant supports report writing and formatting features. FastExport is used to export large amounts of data

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


Options are :

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

Answer : row at a time

The AMP controls its portion of the Teradata Database, performing the physical database work, including which two tasks? (Select two.)


Options are :

  • merge the sorted answer set
  • row storage and retrieval from the VDISK (Correct)
  • creation of the plan to return the response set (Correct)
  • output conversion and formatting

Answer : row storage and retrieval from the VDISK creation of the plan to return the response set

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


Options are :

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

Answer : memory nodes

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


Options are :

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

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

Which statement is true of FALLBACK?


Options are :

  • FALLBACK is intended for non-critical data tables
  • Tables defined with FALLBACK create a Down AMP Recovery Journal in the event of an AMP failure.
  • A FALLBACK table eliminates a duplicate copy of an INDEX subtable.
  • When one Teradata system goes down, FALLBACK rows in the cluster automatically migrate to the FALLBACK Teradata system. (Correct)

Answer : When one Teradata system goes down, FALLBACK rows in the cluster automatically migrate to the FALLBACK Teradata system.

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


Options are :

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

Answer : end-to-end parallelism

Which statement is true when comparing star schema data models to third normal form data models?


Options are :

  • Both star schema and third normal form advocate repeating groups in a row. (Correct)
  • Star schema advocates a greater level of denormalization.
  • Recursive data is easier to represent in star schema.
  • The same data modeling concepts exist in both modeling theories.

Answer : Both star schema and third normal form advocate repeating groups in a row.

What is a characteristic of using row versus set processing for a large table?


Options are :

  • response times will tend to go down as the number of nodes increases
  • less locking contention
  • better able to take advantage of read-ahead capabilities (Correct)
  • reduces resources required when returning all the rows from a table

Answer : better able to take advantage of read-ahead capabilities

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


Options are :

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

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

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


Options are :

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

Answer : a set of columns from one data source a set of columns stored in an implied order

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


Options are :

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

Answer : to distribute the data for more efficient access

Which tool is available for reviewing historical workload?


Options are :

  • Teradata Administrator
  • Teradata Query Scheduler (Correct)
  • Teradata Manager
  • Teradata MDS

Answer : Teradata Query Scheduler

Why should a UPI be defined for a table instead of a NUPI?


Options are :

  • to avoid duplicate row checks during data loads
  • to improve performance of queries using ranges
  • to reduce the size of the query answer set
  • to support access using an arbitrary set of columns (Correct)

Answer : to support access using an arbitrary set of columns

Which two terms are associated with dimensional modeling and NOT associated with third normal form? (Choose two.)


Options are :

  • Star and Snowflake schema
  • Application Specific
  • Application Neutral (Correct)
  • E-R Model (Correct)

Answer : Application Neutral E-R Model

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions