TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which two functions will the Teradata System Emulation Tool TSET) perform? (Choose two.)


Options are :

  • Capture system cost parameters
  • Works with the Optimizer to evaluate and provide load utility statistics (Correct)
  • Generates query plans on test systems as though they were run on production (Correct)
  • Recommends columns to collect statistics on

Answer : Works with the Optimizer to evaluate and provide load utility statistics Generates query plans on test systems as though they were run on production

Which lock type and level would be needed to change the block size on a table?


Options are :

  • Write lock at the table level
  • Exclusive lock at the database level
  • Exclusive lock at the table level
  • Write lock at the database level (Correct)

Answer : Write lock at the database level

What three functions does Teradata handle automatically? (Choose three.)


Options are :

  • Allocate space for data or indexes (Correct)
  • Execute queries in parallel
  • Create users (Correct)
  • Collect statistics (Correct)

Answer : Allocate space for data or indexes Create users Collect statistics

Which two interfaces enable access to Teradata from a network-attached client? (Choose two.)


Options are :

  • Java Database Connectivity (JDBC)
  • Call Level Interface (CLI) (Correct)
  • Microsoft Database Connectivity (MDBC) (Correct)
  • Unix Database Connectivity (UDBC)

Answer : Call Level Interface (CLI) Microsoft Database Connectivity (MDBC)

Which two statements are true about fallback? (Choose two.)


Options are :

  • A copy of a primary row is stored on a different AMP in the same cluster
  • AMPs will migrate to another node in the cluster if a node fails.
  • Rollback of changed rows is provided in the event of AMP failure. (Correct)
  • Data is protected from the loss of two drives in a rank. (Correct)

Answer : Rollback of changed rows is provided in the event of AMP failure. Data is protected from the loss of two drives in a rank.

What are two capabilities of MultiLoad? (Choose two.)


Options are :

  • It enables loading of up to five tables simultaneously.
  • It can load data that has been preprocessed by an input module (Correct)
  • It can load NoPI tables.
  • It maintains data in base tables with join indexes. (Correct)

Answer : It can load data that has been preprocessed by an input module It maintains data in base tables with join indexes.

Which two statements are true for a NoPI table? (Choose two.)


Options are :

  • It will be rehashed, redistributed, and sorted to improve join access
  • It reduces skew in intermediate ETL tables which have no natural primary index. (Correct)
  • It allows loading duplicate rows using FastLoad
  • It allows single-AMP access. (Correct)

Answer : It reduces skew in intermediate ETL tables which have no natural primary index. It allows single-AMP access.

Which two support multilevel partitioned primary indexes? (Choose two.)


Options are :

  • column-partitioned tables (Correct)
  • permanent tables
  • NoPltables
  • non-compressed join indexes (Correct)

Answer : column-partitioned tables non-compressed join indexes

Which two communication interfaces can FastLoad use? (Choose two.)


Options are :

  • OLEDB (Correct)
  • ODBC
  • JDBC (Correct)
  • CLIv2

Answer : OLEDB JDBC

What is Teradata Director Program (TDP)?


Options are :

  • A high-performance interface for messages sent between the mainframe client and Teradata
  • An Information Management System (IMS) interface to Teradata
  • A gateway service allowing products that access DB2 to access data stored on Teradata
  • A Teradata proprietary API and library used by applications to communicate with Teradata (Correct)

Answer : A Teradata proprietary API and library used by applications to communicate with Teradata

When using a mainframe-aftached computer, which software component serves as the interface between the Teradata Database and CLIv2?


Options are :

  • MOSI (Correct)
  • TDP
  • BYNET
  • MTDP

Answer : MOSI

Which three abilities are available with automated workload management? (Choose three.)


Options are :

  • Filter poorly formulated queries (Correct)
  • Adjust CPU resource distribution dynamically
  • Interrupt and delay queries exceeding resource consumption levels (Correct)
  • Rewrite poorly formulated queries dynamically (Correct)
  • Abort queries exceeding exception thresholds dynamically

Answer : Filter poorly formulated queries Interrupt and delay queries exceeding resource consumption levels Rewrite poorly formulated queries dynamically

Which two components or features in the Teradata architecture influence scalable parallelism? (Choose two.)


Options are :

  • Parsing Engine (PE)
  • data distribution
  • AMP migration (Correct)
  • BYNET (Correct)

Answer : AMP migration BYNET

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


Options are :

  • Restrict access via database profiles (Correct)
  • Set a user’s TEMP space to zero (Correct)
  • Set a user’s PERM space to zero
  • Require users to access data via macros

Answer : Restrict access via database profiles Set a user’s TEMP space to zero

Which two mechanisms are used for identity validation to the Teradata Database? (Choose two.)


Options are :

  • External stored procedures (Correct)
  • Passwords
  • Access rights
  • Logon statement (Correct)

Answer : External stored procedures Logon statement

What is true about Online Analytical Processing (OLAP)?


Options are :

  • It is used when the access method is through the primary index.
  • It is similar to tactical queries with known, predictable response times. (Correct)
  • It is used when analysis occurs across multiple dimensions such as time, product, and location.
  • It is used when near real-time data freshness is required.

Answer : It is similar to tactical queries with known, predictable response times.

Which two architectures are built from an enterprise data model? (Choose two.)


Options are :

  • An independent data mart built for a specific purpose and fed from various operational systems (Correct)
  • A central repository and appliances in the environment for special purpose processing of portions of the enterprise data (Correct)
  • A centralized data mart feeding individual department data marts
  • A centralized database repository that reflects all of the entities in the business

Answer : An independent data mart built for a specific purpose and fed from various operational systems A central repository and appliances in the environment for special purpose processing of portions of the enterprise data

Which single session processing type benefits from Teradata’s parallel processing?


Options are :

  • Row at a time
  • Set
  • Group AMP (Correct)
  • Group

Answer : Group AMP

Which two components are necessary to access Teradata over the internet? (Choose two.)


Options are :

  • TDP (Correct)
  • Parsing Engine (PE) (Correct)
  • Token Manager
  • Gateway

Answer : TDP Parsing Engine (PE)

Which two statements are true about a full table scan during select processing? (Choose two.)


Options are :

  • The spool file created may be equal to the size of the base table.
  • Performance is improved by subtable access.
  • The data is redistributed across the AMPS. (Correct)
  • Every row of the table is read once. (Correct)

Answer : The data is redistributed across the AMPS. Every row of the table is read once.

Which statement is true about a Role?


Options are :

  • It contains access rights
  • It provides a way to set password parameters
  • It contains spool allocations (Correct)
  • It is used to authenticate the user to the database.

Answer : It contains spool allocations

Which three statements describe a hot standby node? (Choose three.)


Options are :

  • It is a member of a cluster.
  • It is a member of a clique. (Correct)
  • It can be brought into a configuration when a node fails. (Correct)
  • It is powered off until needed. (Correct)

Answer : It is a member of a clique. It can be brought into a configuration when a node fails. It is powered off until needed.

What is the purpose of the X views in the Data Dictionary?


Options are :

  • to limit the display of the data relevant to the user
  • to show the database profiles available within the database
  • to record which users access the data for future analysis and reporting
  • to show the database objects for which the user may wish to request access (Correct)

Answer : to show the database objects for which the user may wish to request access

What is a major difference between a table partitioned by column versus a table partitioned by row?


Options are :

  • A table partitioned by row may have a partition added to it while a table partitioned by column requires rebuilding of the table. (Correct)
  • The primary index of a table partitioned by column has a higher frequency of use in join processing.
  • When individual rows are deleted from a table partitioned by column they are only marked as deleted.
  • A table partitioned by row may be compressed while a table partitioned by column may not.

Answer : A table partitioned by row may have a partition added to it while a table partitioned by column requires rebuilding of the table.

What is one in put the Optimizer uses to determine whether to choose a full table scan or an index access?


Options are :

  • Join method (Correct)
  • Statistics
  • Data temperature
  • Data freshness

Answer : Join method

Which two types of tables are associated with star schema but not with third normal form?


Options are :

  • Source
  • Lookup (Correct)
  • Fact (Correct)
  • Stage

Answer : Lookup Fact

How does the Transient Journal (TJ) ensure the successful rollback of failed transactions?


Options are :

  • It maintains a before and after image of rows affected by transactions on each AMP. (Correct)
  • It maintains a before and after image of rows affected by transactions in memory
  • It maintains a before image of rows affected by transactions in memory.
  • It maintains a before image of rows affected by transactions on each AMP

Answer : It maintains a before and after image of rows affected by transactions on each AMP.

What are three data protection techniques used by Teradata? (Choose three.)


Options are :

  • Vproc migration (Correct)
  • Transient journal (Correct)
  • archive to disk (Correct)
  • RAID technology

Answer : Vproc migration Transient journal archive to disk

Which two utilities can monitor Unity Data Mover (formerly Teradata Data Mover) processes? (Choose two.)


Options are :

  • Unity Data Mover Agent (Correct)
  • Unity Ecosystem Manager (formerly Teradata Multi-System Manager)
  • Unity Data Mover Monitor
  • Teradata Viewpoint (Correct)

Answer : Unity Data Mover Agent Teradata Viewpoint

Which two hardware components provide redundancy in a Teradata MPP system? (Choose two.)


Options are :

  • BYNET
  • AMP
  • Parsing Engine (PE) (Correct)
  • Node (Correct)

Answer : Parsing Engine (PE) Node

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


Options are :

  • Star schema fact tables are similar to third normal form lookup tables.
  • Star schema is designed for specific applications while third normal form models the business.
  • Star schema uses third normal form physical base tables rather than a view layer.
  • Star schema requires more entities than third normal form. (Correct)

Answer : Star schema requires more entities than third normal form.

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


Options are :

  • Provide more consistent response times and throughputs (Correct)
  • Assign users to a profile
  • Adjust the priority of workloads
  • Monitor database space utilization (Correct)

Answer : Provide more consistent response times and throughputs Monitor database space utilization

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions