TE0-121 Teradata Basics Practice Test Set 5

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


Options are :

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

Answer : Hash buckets

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which two are common between row processing and set processing? (Choose two.)


Options are :

  • Both use serial processing.
  • Both process with one command
  • Both use all-AMP operations.
  • Both can consist of one row (Correct)
  • Both efficiently process large volumes of data. (Correct)

Answer : Both can consist of one row Both efficiently process large volumes of data.

In which two ways is TEMP space used? (Choose two.)


Options are :

  • available to the user until their session is terminated
  • used to store index data (Correct)
  • used to store data for global temporary tables
  • used to hold work tables while a query is running (Correct)

Answer : used to store index data used to hold work tables while a query is running

What is the order of Data Warehouse evolution?


Options are :

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

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

TE0-141 14 Teradata Basics Certified Practice Test Set 3

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


Options are :

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

Answer : Volatile tables . Derived tables

What are two possible benefits of Aggregate Join Indexes? (Choose two.)


Options are :

  • improve join performance (Correct)
  • eliminate aggregate processing (Correct)
  • reduce sorting requirements
  • eliminate base table access

Answer : improve join performance eliminate aggregate processing

What is a reason to create a NUSI instead of a USI on a table?


Options are :

  • It is only a two-AMP operation for row retrieval.
  • It is the preferable secondary index for access using a single value. (Correct)
  • It has lower space needs for index storage.
  • It is particularly useful for range access equality conditions

Answer : It is the preferable secondary index for access using a single value.

TE0-141 14 Teradata Basics Certified Practice Test Set 3

For a network-attached user, connection to the Teradata Database is made over the LAN using which two components? (Choose two.)


Options are :

  • PE (Correct)
  • TDP (Correct)
  • Gateway
  • AMP

Answer : PE TDP

Which two describe the operation of a Full Table Scan (FTS)? (Choose two.)


Options are :

  • It accesses each data row only once.
  • It is a group-AMP operation.
  • It accesses each data block only once. (Correct)
  • It uses block level locking. (Correct)

Answer : It accesses each data block only once. It uses block level locking.

What is the difference between response time and throughput?


Options are :

  • Response time measures network delay, and throughput measures the performance of the PE's
  • Response time measures the performance of a CPU and throughput measures I/O performance.
  • Response time measures the average duration of the queries and throughput measures the quantity of queries completed during a time interval.
  • Response time measures the queries processed per second and throughput measures the volume of transactions received. (Correct)

Answer : Response time measures the queries processed per second and throughput measures the volume of transactions received.

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which two methods are available with Teradata to limit data access? (Choose two.)


Options are :

  • set a user's PERM space to zero (Correct)
  • require users to access data via stored procedures (Correct)
  • restrict access via database profiles
  • require users to access data via macros

Answer : set a user's PERM space to zero require users to access data via stored procedures

Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.)


Options are :

  • reject query based on table access
  • optimize mixed workloads (Correct)
  • monitor table locks
  • pause queries (Correct)

Answer : optimize mixed workloads pause queries

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


Options are :

  • to allow access by a column with non-unique values
  • to allow the index to have distinct values
  • to avoid skewing of the data (Correct)
  • to guarantee even distribution of the table rows

Answer : to avoid skewing of the data

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

What is the typical purpose of the Semantic layer in an Enterprise data warehouse architecture?


Options are :

  • data cleansing
  • data transformation
  • data storage
  • data views (Correct)

Answer : data views

What is the purpose of a lock?


Options are :

  • It enables one or more databases to update data in a synchronized manner.
  • It protects data during a database restart by ensuring only recovery journals can update the tables.
  • It ensures data in the database is only updated by applications with the appropriate rights. (Correct)
  • It serializes access in situations where concurrent access would compromise data consistency.

Answer : It ensures data in the database is only updated by applications with the appropriate rights.

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


Options are :

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

Answer : TS/API

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

Which statement is true regarding continuous data loads?


Options are :

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

Answer : They require a higher level locking schema.

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


Options are :

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

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

What is an advantage of a third normal form data model over a star schema data model?


Options are :

  • It is easy to use. (Correct)
  • It provides a single version of the truth.
  • It has the ability to support previously undefined questions.
  • Implementation is fast.

Answer : It is easy to use.

TE0-124 Teradata 12 Database Administration Practice Exam 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 (Correct)
  • the seamless integration of the ADW into existing business and technical architectures
  • the activity or relevant transaction identified by the application of a business rule

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

What can happen to an AMP during a node failure on a multi-node system?


Options are :

  • It rebuilds itself using the Recovery Journal for all tables.
  • It will continue processing the previous request without interruption.
  • Its data will not be available until the node recovers. (Correct)
  • It will migrate to another node in the same clique.

Answer : Its data will not be available until the node recovers.

What is the primary purpose of the staging layer in an Enterprise data warehouse architecture?


Options are :

  • add application specific structures (Correct)
  • provide end user data views
  • define data transformation
  • assess index choices

Answer : add application specific structures

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

Which application interface is used by BTEQ?


Options are :

  • OLE DB (Correct)
  • CLIv2
  • JDBC
  • ODBC

Answer : OLE DB

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 is a logical database representational concept. (Correct)
  • It can be made up of a maximum of 64 columns.

Answer : It is a logical database representational concept.

The AMP controls its portion of the Teradata Database, performing the physical database work, including which two tasks? (Select two.)


Options are :

  • row storage and retrieval from the VDISK (Correct)
  • output conversion and formatting
  • creation of the plan to return the response set (Correct)
  • merge the sorted answer set

Answer : row storage and retrieval from the VDISK creation of the plan to return the response set

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

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


Options are :

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

Answer : supports ad hoc queries is checkpoint restartable

Which modeling technique is supported by Teradata?


Options are :

  • third normal form including Boyce-Codd normal form
  • star schema (Correct)
  • 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

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

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


Options are :

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

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

What is a benefit of the Teradata Database?


Options are :

  • It automatically detects and recovers from software failures.
  • It allows expansion without sacrificing performance.
  • It supports multiple, mixed data stores.
  • It can be accessed by either channel-attached or wide-area-network-attached systems. (Correct)

Answer : It can be accessed by either channel-attached or wide-area-network-attached systems.

TE0-121 Teradata Basics Practice Test Set 5

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions