TE0-121 12 Teradata Basics Certification Practical Exam Set 1

Which ARC statement can be used to transfer a table from one Teradata system to another Teradata system?


Options are :

  • Copy
  • Checkpoint
  • Restore (Correct)
  • Archive

Answer : Restore

Which two components of a disk subsystem provide for data protection? (Choose two.)


Options are :

  • redundant disk drives (Correct)
  • redundant controllers
  • redundant AMPs
  • redundant nodes (Correct)

Answer : redundant disk drives redundant nodes

What differentiates a User from a Database?


Options are :

  • permanent space
  • password
  • tables (Correct)
  • spool space

Answer : tables

What are two reasons a customer would create a MLPPI table? (Choose two.)


Options are :

  • to reduce the I/O required for range constrained queries
  • to increase the opportunity for partition elimination at additional levels
  • because a PPI is not available for this table
  • to improve performance for all joins on a table (Correct)
  • to improve primary index access against the table (Correct)

Answer : to improve performance for all joins on a table to improve primary index access against the table

Which statement describes On-line Analytical Processing (OLAP) queries?


Options are :

  • Primary index retrieval is the access method most commonly used.
  • Response times are known, predictable, and close to tactical. (Correct)
  • The analysis involves current day data requiring near real-time access
  • They allow analysis on multiple dimensions such as time, product, and location.

Answer : Response times are known, predictable, and close to tactical.

Which two management tools are considered part of the Teradata Analyst Pack? (Choose two.)


Options are :

  • Statistics Wizard
  • Visual Explain
  • Error Log Analyzer (Correct)
  • Teradata Dynamic Workload Manager
  • Teradata Administrator Query Builder (Correct)

Answer : Error Log Analyzer Teradata Administrator Query Builder

What differentiates between the construction and use of an application data model versus an enterprise data model?


Options are :

  • . The application data model requires additional semantic validation in the development phase than the enterprise model does. (Correct)
  • An application data model integrates all aspects of the business where an enterprise data model only looks at one aspect of the business.
  • The application data model is focused on how the data flows through the organization whereas the enterprise data model is focused on how the data is processed.
  • The enterprise data model is intended to be more extensible than an application data model.

Answer : . The application data model requires additional semantic validation in the development phase than the enterprise model does.

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 Parser evaluates the SQL statement for proper syntax.
  • The BYNET retrieves the rows from the disks. (Correct)
  • The AMP dispatches the plan steps to the BYNET. (Correct)

Answer : The BYNET passes the step to the AMPs. The BYNET retrieves the rows from the disks. The AMP dispatches the plan steps to the BYNET.

Which two effects occur as a result of building separate data marts instead of building a centralized data warehouse? (Choose two.)


Options are :

  • Ad-hoc queries using multiple subject areas offer better performance.
  • Pre-planned queries for a limited number of users can offer better performance. (Correct)
  • Database loading is easier to manage. (Correct)
  • Subject areas are repeated across the data marts.

Answer : Pre-planned queries for a limited number of users can offer better performance. Database loading is easier to manage.

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


Options are :

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

Answer : a set of columns stored in an implied ord a set of columns from one data source

Which software component serves as the interface between the Teradata Database and CLIv2 for a mainframe client?


Options are :

  • Teradata Database Connector (TDC)
  • Teradata Warehouse Manager (TWM) (Correct)
  • Teradata System Manager (TSM)
  • Teradata Director Program (TDP)

Answer : Teradata Warehouse Manager (TWM)

What is an advantage of relational databases?


Options are :

  • They are designed to support application-driven processes.
  • They are solidly built on mathematical analysis.
  • They respond quickly to changing business conditions.
  • They are relationship independent. (Correct)

Answer : They are relationship independent.

Why should a UPI be defined for a table instead of a NUPI?


Options are :

  • to improve performance of queries using ranges
  • to support access using an arbitrary set of columns (Correct)
  • to avoid duplicate row checks during data loads
  • to reduce the size of the query answer set

Answer : to support access using an arbitrary set of columns

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
  • It uniquely identifies each row in the table.
  • It supports table access using alternate, less frequently used paths.
  • It can improve join performance. (Correct)

Answer : It can improve join performance.

What is a characteristic of relational databases?


Options are :

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

Answer : They are based on the referential model.

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


Options are :

  • 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
  • to ensure only two AMPs are necessary to respond to the query

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

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.
  • Data availability is increased for more users. (Correct)
  • Cross-functional queries are simplified. (Correct)
  • A department insists on owning their own database.
  • Application ROI justifies a low cost appliance implementation.

Answer : Data availability is increased for more users. Cross-functional queries are simplified.

What differentiates between the construction and use of an application data model versus an enterprise data model?


Options are :

  • The application data model is focused on how the data flows through the organization whereas the enterprise data model is focused on how the data is processed.
  • The enterprise data model is the shared model that is designed to favor the most critical applications, while an application model builds on that shared model for each specific business area. (Correct)
  • An enterprise data model serves as a neutral data model that is normalized to address all business areas and not specific to any function or group whereas an application model is built for a specific business area.
  • An application model includes denormalizations that combine the various needs of all business areas, while an enterprise data model is normalized and is not specific to any function or group.

Answer : The enterprise data model is the shared model that is designed to favor the most critical applications, while an application model builds on that shared model for each specific business area.

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


Options are :

  • determine workload on a system
  • block access on a table to a user (Correct)
  • reserve database space
  • add users (Correct)

Answer : block access on a table to a user add users

Which component in the Teradata architecture has the greatest influence over scalable parallelism?


Options are :

  • AMP migration (Correct)
  • BYNET
  • Parsing Engine
  • Teradata File System

Answer : AMP migration

What are two reasons to consider using multi-level partitioning instead of single-level partitioning for a table? (Choose two.)


Options are :

  • There is more flexibility when there are multiple choices for the partitioning expressions. (Correct)
  • The query searches will be efficient by using partition elimination at various levels.
  • Data will be more evenly distributed between the AMPs.
  • Combined statistics can be captured on multiple partitions for better query performance. (Correct)

Answer : There is more flexibility when there are multiple choices for the partitioning expressions. Combined statistics can be captured on multiple partitions for better query performance.

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


Options are :

  • TPT
  • MultiTool (Correct)
  • FastLoad
  • TSET

Answer : MultiTool

What is used by PEs and AMPs for internal communications?


Options are :

  • the BYNET (Correct)
  • a proprietary LAN
  • an inter-node WAN
  • the YNET

Answer : the BYNET

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


Options are :

  • to improve performance of the duplicate row checking (Correct)
  • 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

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

Which tool is available to the Database Administrator (DBA) to examine the active workload?


Options are :

  • Teradata Performance Monitor
  • Teradata Statistics Wizard
  • Teradata Dynamic Workload Manager (Correct)
  • Resource Usage Monitor

Answer : Teradata Dynamic Workload Manager

Which feature may be used to enable data encryption?


Options are :

  • multi-value data compression
  • X views in the Data Dictionary
  • database roles (Correct)
  • user-defined functions

Answer : database roles

Which benefit is realized with automatic Teradata storage management versus the manual space management of other databases?


Options are :

  • Teradata enables total control over where the data physically resides.
  • Teradata automates the placement and maintenance of physical data location. (Correct)
  • Teradata automatically breaks the data into smaller data sets.
  • Teradata automatically speeds up data loading.

Answer : Teradata automates the placement and maintenance of physical data location.

What is a benefit of automatic versus manually managed storage?


Options are :

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

Answer : It increases the efficiency of the data and index reorganizations.

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


Options are :

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

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

Which two are benefits of having a Hot Standby Node configured on a system? (Choose two.)


Options are :

  • It avoids performance degradation when one node fails. (Correct)
  • It prevents restarts when a node fails.
  • . It makes the system faster when all nodes are working properly. (Correct)
  • It helps with planned outages.

Answer : It avoids performance degradation when one node fails. . It makes the system faster when all nodes are working properly.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions