TE0-121 Teradata Basics Practice Test Set 3

Which two statements are true for both single-level and multi-level partitioned tables? (Choose two.)


Options are :

  • They can be used with compressed join indexes. (Correct)
  • They offer dynamic partition elimination.
  • They can be used with non-unique and unique primary indexes. (Correct)
  • They support direct partitioning on a numeric column.

Answer : They can be used with compressed join indexes. They can be used with non-unique and unique primary indexes.

What is a benefit of automatic versus manually managed storage?


Options are :

  • It will automatically rebalance data across all containers, when containers are added (Correct)
  • It provides cost-savings as a result of reduced hardware needs.
  • It eliminates the need for data and index reorganizations.
  • . It initiates unloads/reloads based on triggers established for space usage.

Answer : It will automatically rebalance data across all containers, when containers are added

Which two management tools are considered part of the Teradata Analyst Pack? (Choose two.)


Options are :

  • SQL Assistant Query Builder (Correct)
  • Index Wizard
  • Performance Monitor (Correct)
  • Teradata Workload Analyzer

Answer : SQL Assistant Query Builder Performance Monitor

Which two describe Perm space? (Choose two.)


Options are :

  • used to hold work tables while a query is running (Correct)
  • used to hold data for global temporary tables (Correct)
  • used to store index subtables
  • used for Transaction rollback data
  • used to store data rows for tables

Answer : used to hold work tables while a query is running used to hold data for global temporary tables

Which two can be archived by the Teradata Archive and Restore utility (ARC)? (Choose two.)


Options are :

  • Index subtable
  • Partition
  • AMP (Correct)
  • Table (Correct)

Answer : AMP Table

Which component is part of Teradata's open architecture?


Options are :

  • Node (Correct)
  • Disk
  • BYNET
  • AMP

Answer : Node

Which two are the definition of a table? (Choose two.)


Options are :

  • a two-dimensional array of rows and columns (Correct)
  • a set of rows that relate to the Foreign Key
  • a relation
  • a set of columns that uniquely identify rows (Correct)

Answer : a two-dimensional array of rows and columns a set of columns that uniquely identify rows

What is the impact on a database when a node failure occurs?


Options are :

  • The database is restarted.
  • There is no impact and transactions continue uninterrupted.
  • The database has to be archived (Correct)
  • Tables assigned to that node are no longer available.

Answer : The database has to be archived

For what reason would a multi-level partitioned primary index (MLPPI) be defined as opposed to a single-level partitioned primary index (PPI)?


Options are :

  • to provide multiple access paths to rows in the base table (Correct)
  • to avoid the need to collect statistics on PARTITION
  • to improve data distribution across all partitions on all AMPs
  • to eliminate the need for a USI

Answer : to provide multiple access paths to rows in the base table

What does the hashing algorithm use to determine which AMP will receive the data?


Options are :

  • Primary Key
  • Primary Index
  • Primary Trigger (Correct)
  • Primary Pointer

Answer : Primary Trigger

Which component is part of Teradata's open architecture?


Options are :

  • PE
  • CPU
  • Node
  • BYNET (Correct)

Answer : BYNET

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


Options are :

  • It can be made up of a maximum of 64 columns.
  • It identifies relationships between views.
  • It implies an access path to the data.
  • It is a logical database representational concept. (Correct)

Answer : It is a logical database representational concept.

Which three benefits are realized in an IT organization as a result of building a centralized data warehouse as opposed to a non-centralized data warehouse? (Choose three.)


Options are :

  • Data is loaded once and used for multiple purposes. (Correct)
  • New requirements can be satisfied without reloading data.
  • Less history needs to be maintained in the data warehouse (Correct)
  • Data modeling is simpler.
  • It uses less space for data storage.
  • Summary data is eliminated. (Correct)

Answer : Data is loaded once and used for multiple purposes. Less history needs to be maintained in the data warehouse Summary data is eliminated.

For a table-level lock, which two lock type combinations are compatible? (Choose two.)


Options are :

  • Read and Share
  • Read and Write (Correct)
  • Access and Write
  • Read and Read (Correct)

Answer : Read and Write Read and Read

Which two are characteristics of a normalized model? (Choose two.)


Options are :

  • increases data complexity of the logical model (Correct)
  • eliminates redundant attributes, keys, and relationships from the model (Correct)
  • removes mathematical set theory from the table structure
  • reduces complex data structures into a simple and stable structure

Answer : increases data complexity of the logical model eliminates redundant attributes, keys, and relationships from the model

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


Options are :

  • to designate where the data is stored in the database
  • to limit the number of columns returned to the user in the query response (Correct)
  • to record which users access the data for future analysis and reporting
  • to limit the display of the data relevant to the user

Answer : to limit the number of columns returned to the user in the query response

Why would the Optimizer choose a Full Table Scan (FTS) rather than Index access?


Options are :

  • FTS is estimated to use fewer resources than the index.
  • FTS is estimated to redistribute more data across all AMPs than the index.
  • FTS is estimated to have less user input than the index.
  • FTS is estimated to spool more data than the index. (Correct)

Answer : FTS is estimated to spool more data than the index.

What can be increased to improve the operation of a Full Table Scan (FTS)?


Options are :

  • BYNETs
  • Data rows
  • Nodes
  • Hash buckets (Correct)

Answer : Hash buckets

Which hardware component protects data when a disk drive fails?


Options are :

  • the backup node
  • redundant disk drives (Correct)
  • redundant disk controllers
  • the fallback AMP

Answer : redundant disk drives

What are three potential disadvantages of partitioned tables over non-partitioned tables? (Choose three.)


Options are :

  • More AMPs are accessed in completing the query. (Correct)
  • Rows in a partitioned tables are 2 bytes longer.
  • Primary index access of a partitioned table may take longer
  • Full table joins to a non-partitioned table with the same primary index may take longer. (Correct)
  • Secondary indexes cannot be created on a partitioned table. (Correct)

Answer : More AMPs are accessed in completing the query. Full table joins to a non-partitioned table with the same primary index may take longer. Secondary indexes cannot be created on a partitioned table.

Which component in the Teradata architecture has the greatest influence over scalable parallelism?


Options are :

  • AMP migration (Correct)
  • Parsing Engine
  • BYNET
  • Teradata File System

Answer : AMP migration

What differentiates between the construction and use of an application data model versus an enterprise data model?


Options are :

  • The enterprise data model is intended to be more extensible than an application data model.
  • . The application data model requires additional semantic validation in the development phase than the enterprise model does. (Correct)
  • An application data model integrates all aspects of the business where an enterprise data model only looks at one aspect of the business.
  • The application data model is focused on how the data flows through the organization whereas the enterprise data model is focused on how the data is processed.

Answer : . The application data model requires additional semantic validation in the development phase than the enterprise model does.

Why would a USI be chosen instead of a NUSI?


Options are :

  • It does not add overhead to the table.
  • It accesses all AMPs but is more efficient than a Full Table Scan (FTS).
  • It ensures that unique data is inserted into the table. (Correct)
  • It is a single AMP operation.

Answer : It ensures that unique data is inserted into the table.

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


Options are :

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

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

Which two are benefits of having a Hot Standby Node configured on a system? (Choose two.)


Options are :

  • It prevents restarts when a node fails.
  • It avoids performance degradation when one node fails. (Correct)
  • It helps with planned outages.
  • . It makes the system faster when all nodes are working properly. (Correct)

Answer : It avoids performance degradation when one node fails. . It makes the system faster when all nodes are working properly.

USER1 has been created with NO PERM space allocation. Which object can USER1 create in the USER1 database?


Options are :

  • join index
  • stored procedure (Correct)
  • macro
  • permanent table

Answer : stored procedure

Which benefit is realized with automatic Teradata storage management versus the manual space management of other databases?


Options are :

  • Teradata enables total control over where the data physically resides.
  • Teradata automatically speeds up data loading.
  • Teradata automates the placement and maintenance of physical data location. (Correct)
  • Teradata automatically breaks the data into smaller data sets.

Answer : Teradata automates the placement and maintenance of physical data location.

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


Options are :

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

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

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

Which is a key capability provided by the Teradata Parallel Database Extensions (PDE)?


Options are :

  • It returns answer sets to the client
  • It performs disk space management.
  • It controls virtual processor resources. (Correct)
  • It monitors system performance.

Answer : It controls virtual processor resources.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions