TE0-121 Teradata Basics Practice Test Set 2

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


Options are :

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

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

TE0-141 14 Teradata Basics Certified Practice Test Set 3

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


Options are :

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

Answer : speeding up load utility processing

What can happen to PEs that are on a node which fails?


Options are :

  • The PEs will continue processing the previous request.
  • All Channel PEs will migrate to another node in the clique (Correct)
  • Recovery will occur for the PEs on the failing node.
  • All LAN PEs will migrate to another node in the clique.

Answer : All Channel PEs will migrate to another node in the clique

What tool is available for assigning resources to users?


Options are :

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

Answer : VprocManager

TE0-124 Teradata 12 Database Administration Practice Exam Set 3

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


Options are :

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

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

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


Options are :

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

Answer : They are needed for journaling.

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


Options are :

  • . the number of users currently executing queries (Correct)
  • 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

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

TE0-141 14 Teradata Basics Certified Practice Test Set 3

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


Options are :

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

Answer : eliminate joins eliminate base table access

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


Options are :

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

Answer : It may not contain duplicate values.

What is one advantage of relational databases?


Options are :

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

Answer : Changing data conditions are reduced.

TE0-124 Teradata 12 Database Administration Practice Exam Set 1

Which three functions are performed on the database when a user submits a query to Teradata? (Choose three.)


Options are :

  • The AMP dispatches the plan steps to the BYNET. (Correct)
  • The BYNET passes the step to the AMPs. (Correct)
  • The Parser evaluates the SQL statement for proper syntax.
  • The BYNET retrieves the rows from the disks. (Correct)

Answer : The AMP dispatches the plan steps to the BYNET. The BYNET passes the step to the AMPs. The BYNET retrieves the rows from the disks.

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which two are advantages to using a partitioned table as compared to a non-partitioned table? (Choose two.)


Options are :

  • There are fast deletes of all the rows in a partition.
  • There is faster access of a single row via a primary index access. (Correct)
  • Range queries can be executed without a secondary index.
  • Fewer AMPs are involved when accessing data. (Correct)

Answer : There is faster access of a single row via a primary index access. Fewer AMPs are involved when accessing data.

When comparing a Primary Key and a Primary Index, which statement is true only for the Primary Index?


Options are :

  • It supports table access using alternate, less frequently used paths.
  • It ensures referential integrity of the data. (Correct)
  • It uniquely identifies each row in the table.
  • It can improve join performance.

Answer : It ensures referential integrity of the data.

Which two table types support multi-level partitioned primary indexes (MLPPI)? (Choose two.)


Options are :

  • Base tables
  • Compressed Join Indexes (Correct)
  • Non-compressed join indexes
  • Global temporary Trace tables (Correct)

Answer : Compressed Join Indexes Global temporary Trace tables

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which statement is true regarding strategic queries?


Options are :

  • They normally require row hash locks.
  • They typically rely heavily on detail data.
  • They usually avoid all-AMP plans. (Correct)
  • They are expected to complete in real-time.

Answer : They usually avoid all-AMP plans.

What are three ways Teradata protects data? (Choose three.)


Options are :

  • archive to alternate clique
  • RAID technology (Correct)
  • archive to disk (Correct)
  • archive to tape (Correct)

Answer : RAID technology archive to disk archive to tape

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


Options are :

  • Datagram Congestion Control Protocol (DCCP) (Correct)
  • Unix Database Connectivity (UDBC)
  • Java Database Connectivity (JDBC) (Correct)
  • Open Database Connectivity (ODBC)
  • Call-level Interface V2 (CLIv2) (Correct)

Answer : Datagram Congestion Control Protocol (DCCP) Java Database Connectivity (JDBC) Call-level Interface V2 (CLIv2)

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

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


Options are :

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

Answer : Database User Index

When accessing the Teradata Database from a network-attached client, which two software components are used for communications? (Choose two.)


Options are :

  • Micro Teradata System Manager (MTSM) (Correct)
  • Micro Cursor Service (MCS)
  • Micro Teradata Director Program (MTDP) (Correct)
  • Micro Call Level Interface (MCLI)

Answer : Micro Teradata System Manager (MTSM) Micro Teradata Director Program (MTDP)

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


Options are :

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

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

NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 1

Which statement is true regarding continuous data loads?


Options are :

  • The table data is unavailable during data loads.
  • They require a higher level locking schema. (Correct)
  • They work most effectively with large volumes of data.
  • The TPump utility is used to read from queues or flat files.

Answer : They require a higher level locking schema.

Which three are terms that are associated with star schema and dimensional modeling? (Choose three.)


Options are :

  • dimensions
  • snowflakes (Correct)
  • facts (Correct)
  • entities
  • attributes (Correct)

Answer : snowflakes facts attributes

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


Options are :

  • limit concurrency
  • monitor Service Level Goals (SLGs)
  • assign the CPUs to a workload (Correct)
  • pause queries during execution (Correct)

Answer : assign the CPUs to a workload pause queries during execution

TE0-141 14 Teradata Basics Certified Practice Test Set 3

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


Options are :

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

Answer : 33%

A customer needs to protect personally identifiable information from all users, including the Database Administrators who have full access to every table on the system. Which methods and/or features are available to enable this privacy protection?


Options are :

  • using privacy-enabled data compression (Correct)
  • using profiles to align users to specific database
  • using encryption views
  • using a user-defined function

Answer : using privacy-enabled data compression

Which two operating systems will run the Teradata database? (Choose two.)


Options are :

  • Z/OS
  • AIX
  • Linux (Correct)
  • Windows (Correct)

Answer : Linux Windows

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

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


Options are :

  • to ensure uniqueness of rows
  • to allow the index to have duplicate values
  • to improve the performance of scalar queries
  • to allow null values to be used (Correct)

Answer : to allow null values to be used

What distinguishes throughput from response time?


Options are :

  • Throughput measures how many rows are processed. Response time measures how long a process takes.
  • Response time measures how many queries are processed. Throughput is how long the processing takes.
  • Response time is how long the processing takes. Throughput measures how long the rows are processed. (Correct)
  • Throughput measures how many queries are processed. Response time is how long the processing takes.

Answer : Response time is how long the processing takes. Throughput measures how long the rows are processed.

Which is an advantage of relational databases?


Options are :

  • They are business-driven and reflect the way the business works
  • They are system-driven and represent user access.
  • They are technology-driven and resource efficient. (Correct)
  • They are enterprise-driven and reflect departmental priorities.

Answer : They are technology-driven and resource efficient.

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

Which two situations will influence the Optimizer to choose a Full Table Scan (FTS) although the query specifies multiple secondary index values in the WHERE clause of the query? (Choose two.)


Options are :

  • Most of the rows qualify for the answer set
  • There are no STATISTICS collected on the index (Correct)
  • There are few instances of the index values.
  • Index values are distributed unevenly across the AMPs. (Correct)

Answer : There are no STATISTICS collected on the index Index values are distributed unevenly across the AMPs.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions