TE0-01A Teradata Fundamentals Practice Test Set 4

What differentiates a User from a Database?


Options are :

  • permanent space
  • password
  • spool space
  • tables (Correct)

Answer : tables

What distinguishes set processing from row processing?


Options are :

  • Set processing normally applies to primary key operations. (Correct)
  • Set processing efficiently updates large amounts of data.
  • Set processing is unsupported by Teradata Utilities.
  • Set processing is seldom an all-AMP operation.

Answer : Set processing normally applies to primary key operations.

What are two reasons to consider using multi-level partitioning instead of single-level partitioning for a table? (Choose two.)


Options are :

  • Data will be more evenly distributed between the AMPs. (Correct)
  • . There is more flexibility when there are multiple choices for the partitioning expressions.
  • There is faster access of a single row via a primary index access. (Correct)
  • Query searches are efficient because of using partition elimination at various levels.

Answer : Data will be more evenly distributed between the AMPs. There is faster access of a single row via a primary index access.

Which component is part of Teradata's open architecture?


Options are :

  • PE
  • BYNET (Correct)
  • CPU
  • Node

Answer : BYNET

Why would a NUPI be a better primary index choice than a UPI?


Options are :

  • to increase efficiency because only one row qualifies
  • to guarantee even distribution of the table rows (Correct)
  • to allow access by a column with non-unique values
  • to reduce the size of the query answer set

Answer : to guarantee even distribution of the table rows

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


Options are :

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

Answer : AMP migration

Which type of database is built around both set processing and row-at-a-time processing?


Options are :

  • inverted list
  • hierarchical (Correct)
  • data mart
  • relational
  • network

Answer : hierarchical

Which is a characteristic unique to the Active Data Warehouse (ADW)?


Options are :

  • low cost of disk to data ratio (Correct)
  • linear scalability
  • automatic data distribution
  • event-based processing

Answer : low cost of disk to data ratio

When comparing a non-partitioned table to a partitioned table, what is the difference in how rows are logically stored for a partitioned table within an AMP?


Options are :

  • Rows are stored in rowid/partition order. (Correct)
  • Rows are stored in partition/rowid order.
  • Rows are stored in logical rowid order.
  • Rows are stored in partition/input order.

Answer : Rows are stored in rowid/partition order.

Which two components of a disk subsystem provide for data protection? (Choose two.)


Options are :

  • redundant controllers
  • redundant nodes (Correct)
  • redundant disk drives
  • redundant AMPs (Correct)

Answer : redundant nodes redundant AMPs

Which statement is true regarding continuous data loads?


Options are :

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

Answer : The table data is unavailable during data loads.

What is a benefit of automatic versus manually managed storage?


Options are :

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

Answer : It provides cost-savings as a result of reduced hardware needs.

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


Options are :

  • Statistics Wizard (Correct)
  • Visual Explain
  • Teradata Dynamic Workload Manager (Correct)
  • Teradata Administrator

Answer : Statistics Wizard Teradata Dynamic Workload Manager

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


Options are :

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

Answer : to allow the index to have duplicate values

Which two effects occur as a result of building separate data marts instead of building a centralized data warehouse? (Choose two.)


Options are :

  • Ad-hoc queries using multiple subject areas offer better performance.
  • Pre-planned queries for a limited number of users can offer better performance.
  • Database loading is easier to manage. (Correct)
  • Subject areas are repeated across the data marts. (Correct)

Answer : Database loading is easier to manage. Subject areas are repeated across the data marts.

What is a characteristic of relational databases?


Options are :

  • They reflect the way users think.
  • They are based on the referential model.
  • They are application-driven. (Correct)
  • They are founded in set theory.

Answer : They are application-driven.

What is the basic function of Archive and Restore utility (ARC)?


Options are :

  • restores the operating system
  • backs up and restores data
  • restores the Transient Journal
  • backs up and restores fault journals (Correct)

Answer : backs up and restores fault journals

What makes the rebuilding of indexes unnecessary with the Teradata database?


Options are :

  • Teradata AMPS (Correct)
  • Teradata BYNET
  • Teradata File System
  • Teradata Optimizer

Answer : Teradata AMPS

What is Active Workload Management?


Options are :

  • the active transactions identified by a business rule for a mixed workload
  • the capability to meet business objectives for system up-time in a mixed workload environment
  • the seamless integration of the mixed workload into existing business and technical architectures (Correct)
  • the ability to dynamically manage the mixed workload environment

Answer : the seamless integration of the mixed workload into existing business and technical architectures

Which statement is true regarding standard batch data loads?


Options are :

  • They process large amounts of data efficiently.
  • The data refresh rates are required to be near real-time.
  • The table lock level allows the data to be highly available. (Correct)
  • The data needs large numbers of transformations.

Answer : The table lock level allows the data to be highly available.

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


Options are :

  • An application data model integrates all aspects of the business whereas 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.
  • 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 whereas the enterprise model does not. (Correct)

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

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


Options are :

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

Answer : Teradata automatically speeds up data loading

What is the order of Data Warehouse evolution?


Options are :

  • Analyzing, Predicting, Operationalizing, Active Warehousing, Reporting
  • Active Warehousing, Reporting, Predicting, Analyzing, Operationalizing
  • Predicting, Operationalizing, Reporting, Active Warehousing, Analyzing (Correct)
  • Reporting, Analyzing, Predicting, Operationalizing, Active Warehousing
  • Operationalizing, Active Warehousing, Analyzing, Reporting, Predicting

Answer : Predicting, Operationalizing, Reporting, Active Warehousing, Analyzing

Which three are characteristics of a Hot Standby Node? (Choose three.)


Options are :

  • is a member of a clique (Correct)
  • is available to process data when system is too busy (Correct)
  • can be brought into a configuration when a node fails
  • is turned off until needed
  • eliminates the need for a restart to bring a failed node back into service (Correct)

Answer : is a member of a clique is available to process data when system is too busy eliminates the need for a restart to bring a failed node back into service

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions