TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which single session processing type benefits from Teradataís parallel processing?


Options are :

  • Group AMP (Correct)
  • Group
  • Row at a time
  • Set

Answer : Group AMP

What is a major difference between a table partitioned by column versus a table partitioned by row?


Options are :

  • A table partitioned by row may have a partition added to it while a table partitioned by column requires rebuilding of the table. (Correct)
  • When individual rows are deleted from a table partitioned by column they are only marked as deleted.
  • A table partitioned by row may be compressed while a table partitioned by column may not.
  • The primary index of a table partitioned by column has a higher frequency of use in join processing.

Answer : A table partitioned by row may have a partition added to it while a table partitioned by column requires rebuilding of the table.

Which lock type and level would be needed to change the block size on a table?


Options are :

  • Exclusive lock at the table level
  • Write lock at the database level (Correct)
  • Write lock at the table level
  • Exclusive lock at the database level

Answer : Write lock at the database level

TE0-141 14 Teradata Basics Certified Practice Test Set 2

What is the purpose of the X views in the Data Dictionary?


Options are :

  • to show the database profiles available within the database
  • to record which users access the data for future analysis and reporting
  • to show the database objects for which the user may wish to request access (Correct)
  • to limit the display of the data relevant to the user

Answer : to show the database objects for which the user may wish to request access

What are three data protection techniques used by Teradata? (Choose three.)


Options are :

  • RAID technology
  • Transient journal (Correct)
  • Vproc migration (Correct)
  • archive to disk (Correct)

Answer : Transient journal Vproc migration archive to disk

What is true about Online Analytical Processing (OLAP)?


Options are :

  • It is used when analysis occurs across multiple dimensions such as time, product, and location.
  • It is similar to tactical queries with known, predictable response times. (Correct)
  • It is used when the access method is through the primary index.
  • It is used when near real-time data freshness is required.

Answer : It is similar to tactical queries with known, predictable response times.

TE0-141 14 Teradata Basics Certified Practice Test Set 2

How does the Transient Journal (TJ) ensure the successful rollback of failed transactions?


Options are :

  • It maintains a before image of rows affected by transactions in memory.
  • It maintains a before and after image of rows affected by transactions on each AMP. (Correct)
  • It maintains a before and after image of rows affected by transactions in memory
  • It maintains a before image of rows affected by transactions on each AMP

Answer : It maintains a before and after image of rows affected by transactions on each AMP.

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


Options are :

  • Monitor database space utilization (Correct)
  • Assign users to a profile
  • Provide more consistent response times and throughputs (Correct)
  • Adjust the priority of workloads

Answer : Monitor database space utilization Provide more consistent response times and throughputs

Which two mechanisms are used for identity validation to the Teradata Database? (Choose two.)


Options are :

  • Passwords
  • Access rights
  • Logon statement (Correct)
  • External stored procedures (Correct)

Answer : Logon statement External stored procedures

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

Which two functions will the Teradata System Emulation Tool TSET) perform? (Choose two.)


Options are :

  • Works with the Optimizer to evaluate and provide load utility statistics (Correct)
  • Recommends columns to collect statistics on
  • Capture system cost parameters
  • Generates query plans on test systems as though they were run on production (Correct)

Answer : Works with the Optimizer to evaluate and provide load utility statistics Generates query plans on test systems as though they were run on production

What are two reasons to define a UPI rather than a NUPI on a SET table? (Choose two.)


Options are :

  • To ensure even row distribution
  • To improve duplicate row checking performance (Correct)
  • To minimize query answer set size (Correct)
  • To improve performance of queries using ranges

Answer : To improve duplicate row checking performance To minimize query answer set size

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

What is Teradata Director Program (TDP)?


Options are :

  • A gateway service allowing products that access DB2 to access data stored on Teradata
  • A Teradata proprietary API and library used by applications to communicate with Teradata (Correct)
  • A high-performance interface for messages sent between the mainframe client and Teradata
  • An Information Management System (IMS) interface to Teradata

Answer : A Teradata proprietary API and library used by applications to communicate with Teradata

Which two statements are true about fallback? (Choose two.)


Options are :

  • A copy of a primary row is stored on a different AMP in the same cluster
  • AMPs will migrate to another node in the cluster if a node fails.
  • Rollback of changed rows is provided in the event of AMP failure. (Correct)
  • Data is protected from the loss of two drives in a rank. (Correct)

Answer : Rollback of changed rows is provided in the event of AMP failure. Data is protected from the loss of two drives in a rank.

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


Options are :

  • It enables loading of up to five tables simultaneously.
  • It can load data that has been preprocessed by an input module (Correct)
  • It can load NoPI tables.
  • It maintains data in base tables with join indexes. (Correct)

Answer : It can load data that has been preprocessed by an input module It maintains data in base tables with join indexes.

TE0-121 Teradata Basics Practice Test Set 6

Which three capabilities describe Teradata scalability? (Choose three.)


Options are :

  • Can add nodes to increase processing power
  • Can join data from multiple Teradata systems in a single query (Correct)
  • Can handle many concurrent users
  • Can add disk capacity or processing power with the offloading and reloading of data (Correct)
  • Can scale to support more data and queries without performance degradation (Correct)

Answer : Can join data from multiple Teradata systems in a single query Can add disk capacity or processing power with the offloading and reloading of data Can scale to support more data and queries without performance degradation

What three functions does Teradata handle automatically? (Choose three.)


Options are :

  • Execute queries in parallel
  • Allocate space for data or indexes (Correct)
  • Create users (Correct)
  • Collect statistics (Correct)

Answer : Allocate space for data or indexes Create users Collect statistics

Which two capabilities are provided by Unity Ecosystem Manager (formerly Teradata MultiSystem Manager) to assist controlling the data warehouse environment? (Choose two.)


Options are :

  • Summaries of account strings and utilities running in the environment
  • Auto notification of users regarding any environment problems (Correct)
  • Workload performance and system resource usage balance across the environment (Correct)
  • End-to-end administration of the environment

Answer : Auto notification of users regarding any environment problems Workload performance and system resource usage balance across the environment

TE0-141 14 Teradata Basics Certified Practice Test Set 3

Which three abilities are available with automated workload management? (Choose three.)


Options are :

  • Abort queries exceeding exception thresholds dynamically
  • Rewrite poorly formulated queries dynamically (Correct)
  • Filter poorly formulated queries (Correct)
  • Interrupt and delay queries exceeding resource consumption levels (Correct)
  • Adjust CPU resource distribution dynamically

Answer : Rewrite poorly formulated queries dynamically Filter poorly formulated queries Interrupt and delay queries exceeding resource consumption levels

Which two statements are true for a NoPI table? (Choose two.)


Options are :

  • It reduces skew in intermediate ETL tables which have no natural primary index. (Correct)
  • It will be rehashed, redistributed, and sorted to improve join access
  • It allows loading duplicate rows using FastLoad
  • It allows single-AMP access. (Correct)

Answer : It reduces skew in intermediate ETL tables which have no natural primary index. It allows single-AMP access.

Which two components or features in the Teradata architecture influence scalable parallelism? (Choose two.)


Options are :

  • Parsing Engine (PE)
  • BYNET (Correct)
  • data distribution
  • AMP migration (Correct)

Answer : BYNET AMP migration

TE0-121 Teradata Basics Practice Test Set 1

When using a mainframe-aftached computer, which software component serves as the interface between the Teradata Database and CLIv2?


Options are :

  • MOSI (Correct)
  • TDP
  • MTDP
  • BYNET

Answer : MOSI

What are two benefits of the Teradata database? (Choose two.)


Options are :

  • There are special versions tuned for the appliances. (Correct)
  • It guarantees linear performance for cursor-based processing.
  • It automatically detects and recovers from software failures. (Correct)
  • It provides centralized management and control regardless of system size.

Answer : There are special versions tuned for the appliances. It automatically detects and recovers from software failures.

Which three tasks do the AMPs perform? (Choose three.)


Options are :

  • Disk space management and accounting
  • Row storage and retrieval from the vdisk (Correct)
  • Merging the sorted answer set
  • Sending the answer set response back to the requesting client (Correct)
  • Output conversion (Correct)
  • Creating the plan to return the response set

Answer : Row storage and retrieval from the vdisk Sending the answer set response back to the requesting client Output conversion

TE0-121 Teradata Basics Practice Test Set 1

Which two interfaces enable access to Teradata from a network-attached client? (Choose two.)


Options are :

  • Unix Database Connectivity (UDBC)
  • Microsoft Database Connectivity (MDBC) (Correct)
  • Call Level Interface (CLI) (Correct)
  • Java Database Connectivity (JDBC)

Answer : Microsoft Database Connectivity (MDBC) Call Level Interface (CLI)

Which two functionalities are available through the BTEQ tool? (Choose two.)


Options are :

  • Supports ad hoc queries
  • Is checkpoint restartable
  • Runs scripted batch queries (Correct)
  • Utilizes ODBC connectivity (Correct)

Answer : Runs scripted batch queries Utilizes ODBC connectivity

Which two will occur when a node fails in a system with a hot standby node? (Choose two.)


Options are :

  • A restart is required to bring the hot standby node into the configuration.
  • Vproc migration occurs for AMPs on the failed node. (Correct)
  • PE Vdisks migrate for fiber attached connections.
  • PE Vprocs migrate for channel attached connections (Correct)

Answer : Vproc migration occurs for AMPs on the failed node. PE Vprocs migrate for channel attached connections

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two support multilevel partitioned primary indexes? (Choose two.)


Options are :

  • NoPltables
  • column-partitioned tables (Correct)
  • permanent tables
  • non-compressed join indexes (Correct)

Answer : column-partitioned tables non-compressed join indexes

What are two benefits achieved with an Active Enterprise Data Warehouse? (Choose two.)


Options are :

  • Integrated view of the data (Correct)
  • Timely availability of data
  • Actively load large volumes of data during production hours (Correct)
  • Single copy of each transaction

Answer : Integrated view of the data Actively load large volumes of data during production hours

Which two communication interfaces can FastLoad use? (Choose two.)


Options are :

  • OLEDB (Correct)
  • ODBC
  • JDBC (Correct)
  • CLIv2

Answer : OLEDB JDBC

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which two methods are available with Teradata to limit data access? (Choose two.)


Options are :

  • Set a userís TEMP space to zero (Correct)
  • Set a userís PERM space to zero
  • Require users to access data via macros
  • Restrict access via database profiles (Correct)

Answer : Set a userís TEMP space to zero Restrict access via database profiles

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions