TE0-121 12 Teradata Basics Certification Practical Exam Set 4

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 provide a constraint to ensure Referential Integrity
  • to support efficient data access
  • to enable compression on the data to improve query performance

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

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


Options are :

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

Answer : create userid owned views execute index compression

Which Teradata concept allows more than one model generation?


Options are :

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

Answer : Time sharing

TE0-141 14 Teradata Basics Certified Practice Test Set 2

What is a benefit of the Teradata Database?


Options are :

  • It supports multiple, mixed data stores.
  • It allows expansion without sacrificing performance.
  • It automatically detects and recovers from software failures.
  • It can be accessed by either channel-attached or wide-area-network-attached systems. (Correct)

Answer : It can be accessed by either channel-attached or wide-area-network-attached systems.

Which tool is available for reviewing historical workload?


Options are :

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

Answer : Teradata Query Scheduler

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


Options are :

  • a single entity in a table
  • one instance of all the columns in a table
  • a set of columns from one data source (Correct)
  • 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

TE0-141 14 Teradata Basics Certified Practice Test Set 2

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


Options are :

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

Answer : to support access using an arbitrary set of columns

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 generates query plans on test systems as though they were run on production. (Correct)
  • It recommends index improvements. (Correct)
  • It allows the user to capture system cost parameters.

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

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
  • reduces resources required when returning all the rows from a table
  • better able to take advantage of read-ahead capabilities (Correct)

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

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

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


Options are :

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

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

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


Options are :

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

Answer : LDAP Single Sign-On passwords

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


Options are :

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

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

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

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


Options are :

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

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

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)
  • Recursive data is easier to represent in star schema.
  • The same data modeling concepts exist in both modeling theories.
  • Star schema advocates a greater level of denormalization.

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

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


Options are :

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

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

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

Which statement is true of FALLBACK?


Options are :

  • Tables defined with FALLBACK create a Down AMP Recovery Journal in the event of an AMP failure.
  • FALLBACK is intended for non-critical data tables
  • 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 two can increase the efficiency of a Full Table Scan (FTS)? (Choose two.)


Options are :

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

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

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


Options are :

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

Answer : to avoid skewing of the data

TE0-141 14 Teradata Basics Certified Practice Test Set 2

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


Options are :

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

Answer : prioritize the workload assign users to a profile

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


Options are :

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

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

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


Options are :

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

Answer : WinDBC TDP

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

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


Options are :

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

Answer : AMP Node

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


Options are :

  • 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 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.
  • It keeps an after-image copy of changed rows on each AMP. Upon transaction failure, the changes are rolled back. (Correct)

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

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


Options are :

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

Answer : to uniquely identify each row in the table

TE0-121 12 Teradata Basics Certification Practical Exam Set 2

What is a function of the Teradata Workload Analyzer tool?


Options are :

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

Answer : recommends query optimization

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


Options are :

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

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

Which application interface is used by BTEQ?


Options are :

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

Answer : OLE DB

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

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


Options are :

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

Answer : E-R Model Application Neutral

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


Options are :

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

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

Which is the definition of a Primary Key?


Options are :

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

Answer : a set of columns that uniquely identify a row

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions