TE0-121 12 Teradata Basics Certification Practical Exam Set 7

Which hardware component protects data when a disk drive fails?


Options are :

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

Answer : redundant disk drives

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


Options are :

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

Answer : facts attributes snowflakes

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

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


Options are :

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

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

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 few instances of the index values.
  • There are no STATISTICS collected on the index (Correct)
  • 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.

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 :

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

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

TE0-121 12 Teradata Basics Certification Practical Exam Set 4

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


Options are :

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

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

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.

Which statement is true regarding continuous data loads?


Options are :

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

Answer : They require a higher level locking schema.

TE0-141 14 Teradata Basics Certified Practice Test Set 1

What is a benefit of automatic versus manually managed storage?


Options are :

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

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

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


Options are :

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

Answer : archive to disk archive to tape RAID technology

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.
  • Performance is improved by subtable access.
  • 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.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which component is part of Teradata's open architecture?


Options are :

  • BYNET
  • Node (Correct)
  • AMP
  • Disk

Answer : Node

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 profiles to align users to specific database
  • using a user-defined function
  • using privacy-enabled data compression (Correct)
  • using encryption views

Answer : using privacy-enabled data compression

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


Options are :

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

Answer : It is a logical database representational concept.

TE0-121 12 Teradata Basics Certification Practical Exam Set 6

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


Options are :

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

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

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 eliminate the need for a USI
  • to avoid the need to collect statistics on PARTITION
  • to provide multiple access paths to rows in the base table (Correct)
  • to improve data distribution across all partitions on all AMPs

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

Which component is part of Teradata's open architecture?


Options are :

  • Node
  • BYNET (Correct)
  • CPU
  • PE

Answer : BYNET

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

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 record which users access the data for future analysis and reporting
  • to limit the number of columns returned to the user in the query response (Correct)
  • 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

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


Options are :

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

Answer : Windows Linux

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


Options are :

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

Answer : Compressed Join Indexes Global temporary Trace tables

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Which statement is true regarding continuous data loads?


Options are :

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

Answer : They require a higher level locking schema.

TE0-141 14 Teradata Basics Certified Practice Test Set 2

On which two table types can a multi-level partitioned primary index (MLPPI) be created? (Choose two.)


Options are :

  • . Derived tables (Correct)
  • Volatile tables (Correct)
  • Global temporary tables
  • Compressed join indexes

Answer : . Derived tables Volatile tables

Which two are advantages of a centralized data warehouse and are disadvantages of physically separate data marts? (Choose two.)


Options are :

  • It includes specific data models.
  • . It avoids row at a time processing (Correct)
  • It is less likely to repeat data.
  • It stores aggregate data instead of detailed data (Correct)

Answer : . It avoids row at a time processing It stores aggregate data instead of detailed data

Which interface provides platform-independent application access to a Teradata Database from various tools increasing data portability?


Options are :

  • JDBC
  • TS/API (Correct)
  • TDP
  • OLEDB

Answer : TS/API

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which two functionalities are available through the BTEQ tool? (Choose two.)


Options are :

  • is checkpoint restartable (Correct)
  • supports ad hoc queries (Correct)
  • runs scripted batch queries
  • provides high volume data export

Answer : is checkpoint restartable supports ad hoc queries

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


Options are :

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

Answer : Hash buckets

What is Active Enterprise Intelligence?


Options are :

  • 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
  • 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 (Correct)

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

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 3

Which modeling technique is supported by Teradata?


Options are :

  • star schema (Correct)
  • third normal form including Boyce-Codd normal form
  • snowflake schema
  • Teradata supports any data model that can be processed by SQL

Answer : star schema

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


Options are :

  • AS/400
  • TOS
  • Linux (Correct)
  • Windows (Correct)

Answer : Linux Windows

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


Options are :

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

Answer : pre-allocate table or index space reorganize data or index space format partitions or disk space

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions