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

Which two describe the benefit of Teradata's scalability? (Choose two.)


Options are :

  • It provides a single view of the business.
  • It provides a fault tolerant processing platform
  • Disk space can be added without having to manually offload/reload the data
  • It has the ability to support multiple concurrent users.

Answer : It provides a fault tolerant processing platform Disk space can be added without having to manually offload/reload the data

Which three terms are associated with third normal form data models? (Choose three.)


Options are :

  • attributes
  • dimensions
  • relationships
  • entities
  • facts
  • snowflakes

Answer : relationships entities snowflakes

Which statement is true of FALLBACK?


Options are :

  • When one Teradata system goes down, FALLBACK rows in the cluster automatically migrate to the FALLBACK Teradata system.
  • A FALLBACK table eliminates a duplicate copy of an INDEX subtable.
  • Tables defined with FALLBACK create a Down AMP Recovery Journal in the event of an AMP failure.
  • FALLBACK is intended for non-critical data tables

Answer : A FALLBACK table eliminates a duplicate copy of an INDEX subtable.

TE0-121 Teradata Basics Practice Test Set 6

Which functionality is available through the Teradata Visual Explain tool?


Options are :

  • It allows the user to graphically interpret the results of an EXPLAIN
  • It interprets the EXPLAIN of a query plan automatically.
  • It generates graphic EXPLAIN plans by role.
  • It uses Query Capture Access to create visual EXPLAIN plans.

Answer : It uses Query Capture Access to create visual EXPLAIN plans.

What are two reasons an access lock is used? (Choose two.)


Options are :

  • to be able to gain access to a table before rights are given
  • to perform a dirty read
  • to be able to read data that is currently being written by another process
  • to increase the priority of the query running

Answer : to be able to read data that is currently being written by another process to increase the priority of the query running

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

What is a purpose of the Primary Index in the Teradata Database?


Options are :

  • to enable reduction in the space necessary to store the row
  • to provide a physical mechanism for assigning a data row to an AMP
  • to ensure that each row is only accessed once when generating the query response
  • to ensure only two AMPs are necessary to respond to the query

Answer : to enable reduction in the space necessary to store the row

Which statement is true about Teradata's linear scalability?


Options are :

  • It is able to process query steps in parallel.
  • It is able to grow the system without moving data around.
  • It is able to grow the system without performance degradation.
  • It is able to process query steps in parallel.

Answer : It is able to process query steps in parallel.

How is Spool space used?


Options are :

  • used for transaction rollback area
  • used to store data rows for tables
  • used to hold intermediate query results
  • used to hold data for global temporary tables

Answer : used to hold data for global temporary tables

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

Which single session processing type takes advantage of Teradata's parallel processing?


Options are :

  • singleton
  • set
  • row at a time
  • group

Answer : singleton

What is needed to log on to the Teradata Database in addition to a password?


Options are :

  • a userid
  • a database
  • a role
  • a profile

Answer : a database

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


Options are :

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

Answer : provides high volume data export is checkpoint restartable

TE0-121 Teradata Basics Practice Test Set 3

What is a benefit of automatic versus manually managed storage?


Options are :

  • It initiates unload/reloads based on triggers established for space usage
  • It increases the efficiency of the data and index reorganizations.
  • It makes the database easier to manage and maintain.
  • It optimizes the data for loading based on the database size.

Answer : It optimizes the data for loading based on the database size.

What is a function of the Teradata Workload Analyzer tool?


Options are :

  • maintains database alerts
  • recommends mapping to rule sets
  • maintains workload definitions
  • recommends candidate workloads

Answer : recommends mapping to rule sets

Which functionality is available through the FastLoad Utility?


Options are :

  • It quickly performs batch updates of large tables.
  • It quickly builds secondary indexes on empty tables.
  • It quickly loads large amounts of data into an empty table.
  • It quickly loads large amounts of data into a partially empty table.

Answer : It quickly performs batch updates of large tables.

TE0-121 Teradata Basics Practice Test Set 6

What is one purpose of the primary index in the Teradata Database?


Options are :

  • to determine data distribution across the AMPs
  • to uniquely identify each row in the table
  • to determine the partitioning sequence for a table
  • to support value-ordered access in the database

Answer : to uniquely identify each row in the table

Which three utilities will support a table update? (Choose three.)


Options are :

  • FastLoad
  • TDWM
  • TPump
  • MultiLoad
  • BTEQ

Answer : TDWM TPump MultiLoad

Which two tasks does the AMP perform? (Choose two.)


Options are :

  • disk space management
  • checking access rights
  • joining data rows
  • query parsing

Answer : checking access rights query parsing

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

What is one advantage of relational databases?


Options are :

  • Rigid data structures provide faster access.
  • Changing data conditions are reduced.
  • Predefined data access reduces indexing.
  • One copy of the data serves multiple purposes.

Answer : Predefined data access reduces indexing.

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


Options are :

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

Answer : a set of columns that uniquely identify rows a set of rows that relate to the Foreign Key

Which is a characteristic of a Foreign Key?


Options are :

  • no duplicates are allowed
  • identify data outside the database
  • identify table relationships
  • one instance of columns in a table

Answer : identify data outside the database

TE0-121 12 Teradata Basics Certification Practical Exam Set 2

Which is the definition of a Primary Key?


Options are :

  • a set of columns that uniquely identify a row
  • a set of logically related columns
  • a relationship between tables
  • a set of rows that uniquely identify data

Answer : a relationship between tables

What is the definition of a clique?


Options are :

  • a set of AMPs that access the same disk arrays
  • a group of AMPs that act as a single fallback unit
  • a set of drives that use a disk-mirroring protection
  • a set of nodes cabled to a set of disk arrays

Answer : a set of AMPs that access the same disk arrays

Which statement is true when comparing the advantages of third normal form to star schema?


Options are :

  • Star schema requires additional data storage.
  • Third normal form tends to have fewer entities.
  • Third normal form requires additional data storage
  • Star schema tends to have fewer entities.

Answer : Third normal form requires additional data storage

TE0-121 Teradata Basics Practice Test Set 6

Which tool is available to change workload settings?


Options are :

  • Teradata Dynamic Workload Manager (TDWM
  • Teradata Administrator
  • Teradata Parallel Data Pump (TPUMP)
  • Teradata Workload Analyzer (TWA)

Answer : Teradata Workload Analyzer (TWA)

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.
  • Rows are stored in logical rowid order.
  • Rows are stored in partition/rowid order.
  • Rows are stored in partition/input order.

Answer : Rows are stored in rowid/partition order.

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

Which statement is true regarding standard batch data loads?


Options are :

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

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

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


Options are :

  • hierarchical
  • data mart
  • network
  • inverted list
  • relational

Answer : hierarchical

What is a characteristic of relational databases?


Options are :

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

Answer : They are application-driven.

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

What differentiates a User from a Database?


Options are :

  • password
  • permanent space
  • tables
  • spool space

Answer : tables

What are two reasons data mart implementations may be preferred over centralized data warehouse architectures? (Choose two.)


Options are :

  • A department insists on owning their own database.
  • Application ROI justifies a low cost appliance implementation.
  • Data availability is increased for more users.
  • Cross-functional queries are simplified.
  • Data content among data marts is easier to synchronize

Answer : Application ROI justifies a low cost appliance implementation. Cross-functional queries are simplified.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions