TE0-121 Teradata Basics Practice Test Set 4

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


Options are :

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

Answer : to support access using an arbitrary set of columns

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.
  • Database loading is easier to manage. (Correct)
  • Pre-planned queries for a limited number of users can offer better performance. (Correct)
  • Subject areas are repeated across the data marts.

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

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 set of columns that uniquely identify rows (Correct)
  • a relation

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

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


Options are :

  • It can improve join performance. (Correct)
  • 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.

Answer : It can improve join performance.

What is a benefit of automatic versus manually managed storage?


Options are :

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

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

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


Options are :

  • Combined statistics can be captured on multiple partitions for better query performance. (Correct)
  • 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.

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

Which feature may be used to enable data encryption?


Options are :

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

Answer : database roles

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


Options are :

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

Answer : redundant nodes redundant disk drives

What are two reasons to create a PPI table? (Choose two.)


Options are :

  • A PPI provides more efficient access to the secondary index sub-tables.
  • The query can take advantage of partition elimination.
  • A PPI requires less physical space than a traditional primary index. (Correct)
  • The table is accessed via a range constraint query.
  • A PPI allows for faster primary index access. (Correct)

Answer : A PPI requires less physical space than a traditional primary index. A PPI allows for faster primary index access.

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


Options are :

  • 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.
  • 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)
  • 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.
  • 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.

What is used by PEs and AMPs for internal communications?


Options are :

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

Answer : the BYNET

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


Options are :

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

Answer : Teradata Dynamic Workload Manager

What makes the rebuilding of indexes unnecessary with the Teradata database?


Options are :

  • Teradata BYNET
  • Teradata File System
  • Teradata Optimizer
  • Teradata AMPS (Correct)

Answer : Teradata AMPS

What is an advantage of relational databases?


Options are :

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

Answer : They are relationship independent.

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


Options are :

  • Restore (Correct)
  • Checkpoint
  • Archive
  • Copy

Answer : Restore

Which component is part of Teradata's open architecture?


Options are :

  • BYNET (Correct)
  • Operating System
  • AMP
  • Node

Answer : BYNET

What could improve response time but could also decrease throughput?


Options are :

  • decrease priority of the workgroup
  • increase spool space for concurrent users
  • decrease the number of concurrent users
  • increase the number of concurrent users (Correct)

Answer : increase the number of concurrent users

What is a characteristic of relational databases?


Options are :

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

Answer : They are based on the referential model.

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 (Correct)
  • 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 provide a physical mechanism for assigning a data row to an AMP

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

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


Options are :

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

Answer : Teradata Administrator Query Builder Error Log Analyzer

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


Options are :

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

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

What is a Role?


Options are :

  • a collection of account defaults
  • a set of common user parameters (Correct)
  • a collection of access rights
  • a set of common logon privileges

Answer : a set of common user parameters

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


Options are :

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

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

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


Options are :

  • TSET
  • MultiTool (Correct)
  • FastLoad
  • TPT

Answer : MultiTool

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


Options are :

  • Processing power can be added without needing to change the data model.
  • It allows users to submit ad hoc queries. (Correct)
  • Disk space can be added without having to manually offload/reload the data. (Correct)
  • It has the ability to support multiple concurrent users.
  • It provides a fault tolerant processing platform. (Correct)
  • It provides a single view of the business.

Answer : It allows users to submit ad hoc queries. Disk space can be added without having to manually offload/reload the data. It provides a fault tolerant processing platform.

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


Options are :

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

Answer : Teradata Warehouse Manager (TWM)

What differentiates a User from a Database?


Options are :

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

Answer : tables

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


Options are :

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

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

Which three mechanisms are used to authenticate access to the Teradata Database? (Choose three.)


Options are :

  • LDAP (Correct)
  • passwords (Correct)
  • access rights
  • views
  • Single Sign-On (Correct)

Answer : LDAP passwords Single Sign-On

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


Options are :

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

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

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions