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

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

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

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.

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.

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

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)

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.

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

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

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.

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