TE0-01A Teradata Fundamentals Practice Test Set 3

Which component is part of Teradata's open architecture?


Options are :

  • Disk
  • AMP
  • Node (Correct)
  • BYNET

Answer : Node

What is one advantage of relational databases?


Options are :

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

Answer : Predefined data access reduces indexing.

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


Options are :

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

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

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


Options are :

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

Answer : provides high volume data export is checkpoint restartable

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


Options are :

  • row at a time
  • singleton (Correct)
  • set
  • group

Answer : singleton

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


Options are :

  • TDWM (Correct)
  • BTEQ
  • TPump (Correct)
  • MultiLoad (Correct)
  • FastLoad

Answer : TDWM TPump MultiLoad

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


Options are :

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

Answer : to uniquely identify each row in the table

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


Options are :

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

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

What is Active Enterprise Intelligence?


Options are :

  • 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 ability to load data throughout the day as opposed to nightly batches
  • 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

Which functionality is available through the SQL Assistant tool?


Options are :

  • SQL debugger
  • SQL front-end tool
  • SQL code generator (Correct)
  • SQL data encryption

Answer : SQL code generator

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


Options are :

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

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

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


Options are :

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

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

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 (Correct)
  • single copy of each transaction
  • integrated logical data model (Correct)

Answer : single data store integrated logical data model

Which is the definition of a Primary Key?


Options are :

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

Answer : a relationship between tables

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


Options are :

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

Answer : It may contain nulls

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


Options are :

  • a profile
  • a userid
  • a role
  • a database (Correct)

Answer : a database

What is a function of the Teradata Workload Analyzer tool?


Options are :

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

Answer : recommends mapping to rule sets

Which statement is true about Teradata's linear scalability?


Options are :

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

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

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


Options are :

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

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

How is Spool space used?


Options are :

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

Answer : used to hold data for global temporary tables

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


Options are :

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

Answer : AS/400 Windows

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


Options are :

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

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

What is a benefit of automatic versus manually managed storage?


Options are :

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

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

Which is a characteristic of a Foreign Key?


Options are :

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

Answer : identify data outside the database

Which statement is true of FALLBACK?


Options are :

  • 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. (Correct)
  • The FALLBACK copy of a row is always located on the same AMP which holds the primary copy.
  • 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.

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


Options are :

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

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

Which is an advantage of relational databases?


Options are :

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

Answer : They are technology-driven and resource efficient.

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.
  • There are no limits to the number of columns that can be defined.
  • The value can be defined as unique or non-unique.
  • It is documented in the logical data model. (Correct)

Answer : It is documented in the logical data model.

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


Options are :

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

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

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


Options are :

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

Answer : It implies an access path to the data.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions