TE0-01A Teradata Fundamentals Practice Test Set 2

What describes the benefit of Teradata's scalability?


Options are :

  • Processing power can be added, without needing to change the data model.
  • It allows users to submit ad hoc queries.
  • It provides a fault tolerant processing platform. (Correct)
  • It provides a single view of the business.

Answer : It provides a fault tolerant processing platform.

Which two are characteristics of the Transient Journal (TJ)? (Choose two.)


Options are :

  • It is maintained automatically
  • It is defined at the table level, the database level, and the system level.
  • It reduces the need for costly and time consuming full-table backups. (Correct)
  • It provides rollback of changed rows for transactions failing to complete. (Correct)

Answer : It reduces the need for costly and time consuming full-table backups. It provides rollback of changed rows for transactions failing to complete.

At which three levels is locking supported on Teradata? (Choose three.)


Options are :

  • User (Correct)
  • Row Hash
  • Table (Correct)
  • Index
  • Database (Correct)

Answer : User Table Database

What are two ways to improve both response time and throughput? (Choose two.)


Options are :

  • by increasing the number of sessions on the system (Correct)
  • by increasing the number of parsing engines
  • by implementing workload management
  • by increasing the number of concurrent queries (Correct)
  • by increasing the number of nodes

Answer : by increasing the number of sessions on the system by increasing the number of concurrent queries

What can happen to PEs that are on a node which fails?


Options are :

  • All LAN PEs will migrate to another node in the clique
  • All Channel PEs will migrate to another node in the clique. (Correct)
  • The PEs will continue processing the previous request.
  • Recovery will occur for the PEs on the failing node.

Answer : All Channel PEs will migrate to another node in the clique.

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


Options are :

  • It ensures referential integrity of the data. (Correct)
  • It uniquely identifies each row in the table.
  • It supports table access using alternate, less frequently used paths.
  • It can improve join performance.

Answer : It ensures referential integrity of the data.

Which two actions can a user with no PERM space allocation perform on the system? (Choose two.)


Options are :

  • create userid owned views (Correct)
  • . create userid owned tables (Correct)
  • execute index compression
  • execute queries

Answer : create userid owned views . create userid owned tables

Which two will cause the Optimizer to choose a Full Table Scan (FTS)? (Choose two.)


Options are :

  • There is no WHERE clause specified in the query.
  • The number of data blocks accessed is a small percentage of the table. (Correct)
  • There is a single row in the answer set.
  • A value is not provided for the primary index. (Correct)

Answer : The number of data blocks accessed is a small percentage of the table. A value is not provided for the primary index.

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


Options are :

  • data freshness
  • single view of the business
  • dimensional data (Correct)
  • mature optimizer

Answer : dimensional data

What is the difference between response time and throughput?


Options are :

  • Response time measures the queries processed per second and throughput measures the volume of transactions received.
  • 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 performance of a CPU and throughput measures I/O performance. (Correct)
  • Response time measures network delay and throughput measures the performance of the PEs.

Answer : Response time measures the performance of a CPU and throughput measures I/O performance.

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


Options are :

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

Answer : relationships entities snowflakes

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


Options are :

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

Answer : entities facts attributes

Which two lock levels are compatible with each other? (Choose two.)


Options are :

  • Read and Access
  • Write and Access
  • Exclusive and Read (Correct)
  • Read and Write (Correct)

Answer : Exclusive and Read Read and Write

Which two refer to a row in a relational table? (Choose two.)


Options are :

  • a single entity in a table (Correct)
  • a set of columns from one data source (Correct)
  • a set of columns stored in an implied order
  • one instance of all the columns in a table

Answer : a single entity in a table a set of columns from one data source

What are three varieties of data marts? (Choose three)


Options are :

  • Logical
  • Dependent (Correct)
  • Independent (Correct)
  • OLAP (Correct)

Answer : Dependent Independent OLAP

Which two are reasons a UPI could be defined for the table instead of a NUPI? (Choose two)


Options are :

  • to improve performance of queries using ranges (Correct)
  • to guarantee even distribution of the table rows
  • to reduce the size of the query answer set
  • to improve performance of the duplicate row checking (Correct)

Answer : to improve performance of queries using ranges to improve performance of the duplicate row checking

What distinguishes throughput from response time?


Options are :

  • Throughput is a measurement of how long it takes a query to complete. Response time is a measurement of node activity.
  • Throughput is a measurement of node parallelism. Response time is a measurement of BYNET messaging.
  • Throughput is a measurement of BYNET activity. Response time is a measurement of completed work. (Correct)
  • Throughput is a measurement of the amount of work that is processed. Response time is a measurement of process completion.

Answer : Throughput is a measurement of BYNET activity. Response time is a measurement of completed work.

How much space is used as overhead when using RAID-1?


Options are :

  • 33% (Correct)
  • 50%
  • 20%
  • 25%

Answer : 33%

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


Options are :

  • It provides a fault tolerant processing platform (Correct)
  • Disk space can be added without having to manually offload/reload the data (Correct)
  • It provides a single view of the business.
  • 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 two statements are true about a Relational Database? (Choose two.)


Options are :

  • It is a collection of physically related tables. (Correct)
  • It is a collection of related rows and columns.
  • It is a collection of logically related tables.
  • It is defined by Primary and Secondary Keys. (Correct)

Answer : It is a collection of physically related tables. It is defined by Primary and Secondary Keys.

What is a characteristic of a dependent data mart?


Options are :

  • subset of data often used by a department
  • is the system of record
  • contains unique data
  • sourced from operational systems (Correct)

Answer : sourced from operational systems

Which nodes receive migrating vprocs during node failure in a multi-node system with multiple cliques?


Options are :

  • Non-TPA nodes on the system. (Correct)
  • The least busy node on the system.
  • Nodes in the same clique.
  • Vprocs will wait until the node is repaired.

Answer : Non-TPA nodes on the system.

Which utility supports table loading, updating and streaming of updates?


Options are :

  • TSET (Correct)
  • TPT
  • FastLoad
  • MultiTool

Answer : TSET

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


Options are :

  • to support efficient data access
  • to ensure enough AMPs are involved to reduce query processing time (Correct)
  • to enable compression on the data to improve query performance
  • to provide a constraint to ensure Referential Integrity

Answer : to ensure enough AMPs are involved to reduce query processing time

Which tool is available to change workload settings?


Options are :

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

Answer : Teradata Workload Analyzer (TWA)

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


Options are :

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

Answer : checking access rights query parsing

Which functionality is available through the FastLoad Utility?


Options are :

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

Answer : It quickly performs batch updates of large tables.

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


Options are :

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

Answer : Third normal form requires additional data storage

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


Options are :

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

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

What is the definition of a clique?


Options are :

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

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions