TE0-01A 12 Teradata Fundamentals Certification Practice Exam Set 3

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


Options are :

  • Windows
  • Linux
  • AS/400
  • TOS

Answer : Windows AS/400

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


Options are :

  • More AMPs are accessed in completing the query.
  • Rows in a partitioned tables are 2 bytes longer.
  • Primary index access of a partitioned table may take longer.
  • Secondary indexes cannot be created on a partitioned table.

Answer : More AMPs are accessed in completing the query. Primary index access of a partitioned table may take longer.

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


Options are :

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

Answer : low cost of disk to data ratio

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 1

Which statement is true regarding continuous data loads?


Options are :

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

Answer : The table data is unavailable during data loads.

What is an example of throughput and response time?


Options are :

  • . time taken by one query and quantity of data returned
  • time taken for a database shutdown and time taken for a database restart
  • number of concurrent users accessing Teradata and number of requests
  • number of queries executed in one hour and elapsed time per query

Answer : time taken for a database shutdown and time taken for a database restart

TE0-122 12 Teradata SQL Certification Practice Exam Set 4

What is a reason to choose a NUPI rather than a UPI when creating a new table?


Options are :

  • to allow duplicate values
  • to avoid skewing of the data
  • to allow the use of null
  • to guarantee even row distribution

Answer : to allow the use of null

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 :

  • Summary data is eliminated.
  • Less history needs to be maintained in the data warehouse.
  • Data modeling is simpler.
  • New requirements can be satisfied without reloading data.
  • It uses less space for data storage.

Answer : Less history needs to be maintained in the data warehouse. Data modeling is simpler. New requirements can be satisfied without reloading data.

Which ARC statement can be used to transfer a table from one Teradata system to another Teradata system?


Options are :

  • Restore
  • Copy
  • Checkpoint
  • Archive

Answer : Checkpoint

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

What is an advantage of relational databases?


Options are :

  • They are relationship independent.
  • They are designed to support application-driven processes.
  • They are solidly built on mathematical analysis.
  • They respond quickly to changing business conditions.

Answer : They are designed to support application-driven processes.

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


Options are :

  • Visual Explain
  • Priority Scheduler Administrator
  • Teradata Workload Analyzer
  • Teradata System Emulation Tool

Answer : Visual Explain Teradata Workload Analyzer

What is a Role?


Options are :

  • a set of common logon privileges
  • a collection of account defaults
  • a collection of access rights
  • a set of common user parameters

Answer : a set of common logon privileges

TE0-121 Teradata Basics Practice Test Set 4

Which two sets of functions does the Parsing Engine (PE) perform? (Select two.)


Options are :

  • SQL statement interpretation, syntax validation, and sematic evaluation
  • sorting, formatting, and aggregating of the final answer set
  • flow control of the data to and from the participating tables
  • dispatching the step execution sequence to the AMP via the BYNET

Answer : flow control of the data to and from the participating tables dispatching the step execution sequence to the AMP via the BYNET

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


Options are :

  • single view of all data in the database
  • robust, parallel-aware Optimizer
  • automatic distribution of data
  • concurrent access and load

Answer : automatic distribution of data

Which statement is true when comparing star schema data models to third normal form data models?


Options are :

  • Recursive data is easier to represent in star schema.
  • Both star schema and third normal form advocate repeating groups in a row.
  • Star schema advocates a greater level of denormalization
  • The same data modeling concepts exist in both modeling theories

Answer : Recursive data is easier to represent in star schema.

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

What tool is available for assigning resources to users?


Options are :

  • VprocManager
  • Teradata Workload Analyzer
  • ResUsage
  • Priority Scheduler

Answer : Teradata Workload Analyzer

What is the purpose of accessing a row using the Primary Index?


Options are :

  • It may provide the answer without base table access.
  • It is only a two-AMP operation.
  • It improves query efficiency.
  • It utilizes the power of the full-table scan

Answer : It utilizes the power of the full-table scan

Which two components in a Teradata MPP system have hardware redundancy? (Choose two.)


Options are :

  • AMP
  • Gateway
  • Nod
  • BYNET

Answer : AMP Nod

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

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


Options are :

  • BYNETs
  • Data rows
  • Nodes
  • Hash buckets

Answer : Hash buckets

What is a benefit of automatic versus manually managed storage?


Options are :

  • It enables capacity planning in tracking of the amount of allocated space
  • It allows data load preparation to be optimized.
  • It allows the DBA to control where the data will be placed for optimal access.
  • It eliminates the need to reorganize data or index space.

Answer : It allows data load preparation to be optimized.

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


Options are :

  • Read and Read
  • Read and Share
  • Access and Write
  • Read and Write

Answer : Read and Read Read and Share

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two reduce the likelihood of a Full Table Scan (FTS)? (Choose two.)


Options are :

  • The use of a WHERE clause in the query.
  • A surrogate key is defined on the index column.
  • The primary index is fully qualified
  • The primary index is defined as compressed.

Answer : The use of a WHERE clause in the query. The primary index is defined as compressed.

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


Options are :

  • Applying data governance rules is a complex issue when creating application data models whereas it requires nominal incremental effort for an enterprise data model.
  • An application data model only looks at one aspect of the business whereas an enterprise logical data model integrates all aspects of the business.
  • The application data model requires additional semantic validation in the development phase whereas the enterprise model does not.
  • An application data model is focused on how the data flows through the organization whereas an enterprise data model is focused on how the data is processed.

Answer : Applying data governance rules is a complex issue when creating application data models whereas it requires nominal incremental effort for an enterprise data model.

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


Options are :

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

Answer : Tables assigned to that node are no longer available.

TE0-121 12 Teradata Basics Certification Practical Exam Set 2

Which is a characteristic of how active data warehousing has evolved?


Options are :

  • It produces pre-defined reports.
  • . It uses ad-hoc analysis with data at the detail level.
  • It makes decisions with event-based triggers.
  • It discovers patterns in customer buying habits.

Answer : It discovers patterns in customer buying habits.

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


Options are :

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

Answer : Teradata automatically speeds up data loading

TE0-121 12 Teradata Basics Certification Practical Exam Set 2

What is the order of Data Warehouse evolution?


Options are :

  • Active Warehousing, Reporting, Predicting, Analyzing, Operationalizing
  • Reporting, Analyzing, Predicting, Operationalizing, Active Warehousing
  • Operationalizing, Active Warehousing, Analyzing, Reporting, Predicting
  • Analyzing, Predicting, Operationalizing, Active Warehousing, Reporting
  • Predicting, Operationalizing, Reporting, Active Warehousing, Analyzing

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

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


Options are :

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

Answer : to guarantee even distribution of the table rows

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


Options are :

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

Answer : backs up and restores fault journals

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What distinguishes set processing from row processing?


Options are :

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

Answer : Set processing normally applies to primary key operations.

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


Options are :

  • Teradata AMPS
  • Teradata File System
  • Teradata BYNET
  • Teradata Optimizer

Answer : Teradata AMPS

What is a benefit of automatic versus manually managed storage?


Options are :

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

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

NR0-013 Teradata SQL v2r5 Certification Practice Exam Set 2

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


Options are :

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

Answer : to allow the index to have duplicate values

Which is an advantage of relational databases?


Options are :

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

Answer : They are technology-driven and resource efficient.

What is Active Workload Management?


Options are :

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

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

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

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


Options are :

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

Answer : It implies an access path to the data.

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 requires additional semantic validation in the development phase whereas the enterprise model does not.
  • The enterprise data model is intended to be more extensible than an application data model.
  • 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 whereas the enterprise model does not.

Which component is part of Teradata's open architecture?


Options are :

  • BYNET
  • PE
  • CPU
  • Node

Answer : BYNET

TE0-121 Teradata Basics Practice Test Set 4

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


Options are :

  • Teradata Administrator
  • Visual Explain
  • Teradata Dynamic Workload Manager
  • Statistics Wizard

Answer : Teradata Dynamic Workload Manager Statistics Wizard

With Teradata, which three DBA functions are unnecessary, thereby contributing to the ease of management? (Choose three.)


Options are :

  • reorganize data or index space
  • checking database space available
  • format partitions or disk space
  • pre-allocate table or index space
  • create users

Answer : reorganize data or index space checking database space available pre-allocate table or index space

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What is Active Enterprise Intelligence?


Options are :

  • the ability to load data throughout the day as opposed to nightly batches
  • the capability to meet business objectives for system up-time in a mission critical environment
  • the activity or relevant transaction identified by the application of a business rule
  • the seamless integration of the ADW into existing business and technical architectures

Answer : the capability to meet business objectives for system up-time in a mission critical environment

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


Options are :

  • The Parser evaluates the SQL statement for proper syntax.
  • The Optimizer develops the least expensive plan for executing the query.
  • The BYNET retrieves the rows from the disks.
  • The BYNET passes the step to the AMPs.
  • The AMP dispatches the plan steps to the BYNET.

Answer : The Parser evaluates the SQL statement for proper syntax. The BYNET passes the step to the AMPs. The AMP dispatches the plan steps to the BYNET.

Which statement is true of FALLBACK?


Options are :

  • The FALLBACK copy of a row is always located on the same AMP which holds the primary copy.
  • The FALLBACK copy of a row is located on an AMP different from the AMP which holds the primary copy.
  • The FALLBACK rows automatically migrate to a different clique when one AMP goes down.
  • The FALLBACK data is recorded twice, once in the primary Teradata system and once in the FALLBACK Teradata system.

Answer : The FALLBACK rows automatically migrate to a different clique when one AMP goes down.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

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


Options are :

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

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

Which two statements apply more to tactical queries than to strategic queries? (Choose two.)


Options are :

  • They are short, highly-tuned, and repetitively executed.
  • They are often used to identify business trends and patterns.
  • They often involve complex joins and aggregations.
  • They are usually ad hoc queries submitted by end users.

Answer : They often involve complex joins and aggregations. They are usually ad hoc queries submitted by end users.

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


Options are :

  • BYNET
  • AMP migration
  • Parsing Engine
  • Teradata File System

Answer : AMP migration

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

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


Options are :

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

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

Which component is part of Teradata's open architecture?


Options are :

  • Node
  • Disk
  • BYNET
  • AMP

Answer : Node

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


Options are :

  • redundant AMPs
  • redundant disk drives
  • redundant nodes
  • redundant controllers

Answer : redundant AMPs redundant nodes

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 3

Teradata builds its products for implementing a centralized data warehouse to promote which two design goals? (Choose two.)


Options are :

  • single version of the truth
  • single data store
  • integrated logical data model
  • single copy of each transaction

Answer : single data store integrated logical data model

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


Options are :

  • The value can be defined as unique or non-unique.
  • It ensures referential integrity of the data.
  • It is documented in the logical data model.
  • There are no limits to the number of columns that can be defined.

Answer : It is documented in the logical data model.

Which two functions are available through the Teradata System Emulation Tool? (Choose two.)


Options are :

  • It allows the user to capture system cost parameters.
  • It works closely with the Optimizer to evaluate load utility responsiveness.
  • It recommends index improvements
  • It generates query plans on test systems as though they were run on production.

Answer : It allows the user to capture system cost parameters. It works closely with the Optimizer to evaluate load utility responsiveness.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which statement is true for the Primary Key but not for the Primary Index?


Options are :

  • It may not contain duplicate values.
  • It may contain nulls
  • It may be composed of one or more columns.
  • It cannot be referenced in an SQL request.

Answer : It may contain nulls

Which functionality is available through the SQL Assistant tool?


Options are :

  • SQL front-end tool
  • SQL data encryption
  • SQL debugger
  • SQL code generator

Answer : SQL code generator

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


Options are :

  • . 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.
  • Data will be more evenly distributed between the AMPs.
  • Query searches are efficient because of using partition elimination at various levels.

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

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions