TE0-141 14 Teradata Basics Certified Practice Test Set 3

Which Archive/Recovery Utility (ARC) statement would be used when transferring a table from one Teradata system to another?


Options are :

  • Restore (Correct)
  • Rollforward
  • Checkpoint
  • Copy

Answer : Restore

Which statement is true during a mini-batch load process?


Options are :

  • The first step is to INSERT...SELECT data into staging
  • The FastLoad utility is used to load data into staging.
  • Data transformations are not allowed when moving from the staging table to the target table.
  • The row collision opportunities increase. (Correct)

Answer : The row collision opportunities increase.

What are two advantages of relational databases? (Choose two.)


Options are :

  • One copy of the data serves multiple purposes
  • Specific data access paths for increased flexibility. (Correct)
  • Rigid data structures provide faster access.
  • Changing data conditions are reduced.
  • Flexibility of adding new business subject areas. (Correct)

Answer : Specific data access paths for increased flexibility. Flexibility of adding new business subject areas.

What are three ways Teradata provides a low total cost of ownership? (Choose three.)


Options are :

  • Ease of setup and maintenance (Correct)
  • Automatic data distribution (Correct)
  • No reorganization of data needed
  • Use of off-the-shelf standard hardware (Correct)

Answer : Ease of setup and maintenance Automatic data distribution Use of off-the-shelf standard hardware

What is one reason a UPI would be defined for a table rather than a NUPI?


Options are :

  • To ensure the uniqueness of rows
  • To allow single-AMP access
  • To improve the performance of scalar queries (Correct)
  • To allow single I/O access

Answer : To improve the performance of scalar queries

Which statement is true about block level compression (BLC)?


Options are :

  • It can compress secondary indexes.
  • It is specified in the CREATE TABLE statement
  • It is set at the system level.
  • It can compress all structures within the database. (Correct)

Answer : It can compress all structures within the database.

What are two reasons a USI would be chosen instead of a NUSI? (Choose two.)


Options are :

  • It minimizes the added overhead for the table.
  • It is a two-AMP operation to access data when the USI is used. (Correct)
  • It ensures that distinct data for the USI columns is inserted into the table.
  • It allows the TPump utility to be used with the table. (Correct)

Answer : It is a two-AMP operation to access data when the USI is used. It allows the TPump utility to be used with the table.

Which two tools are included in the Teradata Analyst Pack? (Choose two.)


Options are :

  • Performance Monitor (PMON) (Correct)
  • Teradata System Emulation Tool (TSET)
  • Index Wizard (Correct)
  • Teradata Workload Analyzer (TWA)

Answer : Performance Monitor (PMON) Index Wizard

What are two common characteristics of row processing and set processing? (Choose two.)


Options are :

  • Both efficiently process large volumes of data. (Correct)
  • Both can apply to a single row.
  • Both use all-AMP operations. (Correct)
  • Both use serial processing.

Answer : Both efficiently process large volumes of data. Both use all-AMP operations.

Which statement is true about Teradata utilities?


Options are :

  • BTEQ allows import/export across all supported platforms.
  • BTEQ is limited to using one session
  • SQL Assistant supports report writing and formatting features (Correct)
  • FastLoad is used to load data to a populated table.

Answer : SQL Assistant supports report writing and formatting features

Which statement is true about third normal form but not about star schema?


Options are :

  • It is a virtual structure instead of a physical layer (Correct)
  • It has built-in temporal features.
  • It is designed for business rather than for specific applications.
  • It supports the B-tree data structure.

Answer : It is a virtual structure instead of a physical layer

Which two activities are supported by the Teradata Administrator tool? (Choose two.)


Options are :

  • database performance and utilization analysis
  • setting up rules for access logging (Correct)
  • dynamic monitoring of session information (Correct)
  • displaying information on databases or users

Answer : setting up rules for access logging dynamic monitoring of session information

What are three advantages of Teradata Virtual Storage (TVS) versus manually managed storage? (Choose three.)


Options are :

  • It allows sharing of storage devices among AMPS. (Correct)
  • It enables mixing drive sizes, speeds, and technologies (Correct)
  • It analyzes the data for compression opportunities based on the table size and frequency of access. (Correct)
  • It enables the automatic migration of data.

Answer : It allows sharing of storage devices among AMPS. It enables mixing drive sizes, speeds, and technologies It analyzes the data for compression opportunities based on the table size and frequency of access.

Which two statements describe the operation of a full table scan during a select process? (Choose two.)


Options are :

  • It is a group-AMP operation.
  • It uses block level locking. (Correct)
  • It requires a spool file. (Correct)
  • It accesses each data row only once.

Answer : It uses block level locking. It requires a spool file.

A customer needs to protect personally identifiable information from all users, including the DBAs who have full access to every table on the system.Which method and/or feature is available to enable this privacy protection?


Options are :

  • Using a user defined function (UDF)
  • Using views to conditionally encrypt the data (Correct)
  • Using profiles to align users to specific databases
  • Using privacy-enabled data compression

Answer : Using views to conditionally encrypt the data

What are two considerations when selecting a Primary Index? (Choose two.)


Options are :

  • It can be created or dropped at any time during the life of the table (Correct)
  • It should consist of a column or columns that are as unique as possible. (Correct)
  • It should not be identical to the Primary Key
  • It is the mechanism for assigning a row to an AMP.

Answer : It can be created or dropped at any time during the life of the table It should consist of a column or columns that are as unique as possible.

What is the maximum number of values per column that can be compressed using multivalue compression (MVC)?


Options are :

  • 510 plus nulls and zeroes
  • 255
  • 126 plus nulls and zeroes (Correct)
  • 1024

Answer : 126 plus nulls and zeroes

How do Teradata components function when a query is submitted? (Choose three.)


Options are :

  • The BYNET performs data conversion on the final answer set (Correct)
  • The BYNET merges the final answer set.
  • The Dispatcher passes the steps to the BYNET which passes them to the appropriate AMPS. (Correct)
  • The AMPS retrieve the data from the virtual disk. (Correct)

Answer : The BYNET performs data conversion on the final answer set The Dispatcher passes the steps to the BYNET which passes them to the appropriate AMPS. The AMPS retrieve the data from the virtual disk.

What are two benefits realized when a centralized data warehouse is built instead of multiple data marts? (Choose two.)


Options are :

  • Data is loaded once and used for multiple purposes.
  • Less history needs to be maintained in the data warehouse (Correct)
  • New business requirements can be satisfied without reloading data.
  • Summary data is eliminated. (Correct)

Answer : Less history needs to be maintained in the data warehouse Summary data is eliminated.

Which three of the lock type pairs requested through SQL statements will be granted immediately? (Choose three.)


Options are :

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

Answer : Access and Read Exclusive and Read Access and Write

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


Options are :

  • Rows in a partitioned tables require more space.
  • Joining multiple rows from a partitioned table to a non-partitioned table with the same primary index will take longer. (Correct)
  • More AMPs are accessed in completing the query. (Correct)
  • Primary index access of a partitioned table may take longer. (Correct)

Answer : Joining multiple rows from a partitioned table to a non-partitioned table with the same primary index will take longer. More AMPs are accessed in completing the query. Primary index access of a partitioned table may take longer.

Which three SQL coding constructs will result in a full table scan? (Choose three.)


Options are :

  • specifying a range of values for the primary index in the WHERE clause (Correct)
  • accessing the table using any arbitrary set of columns
  • referencing a value for each column of the primary index in the WHERE clause (Correct)
  • using a non-equality clause when specifying a value for the primary index (Correct)

Answer : specifying a range of values for the primary index in the WHERE clause referencing a value for each column of the primary index in the WHERE clause using a non-equality clause when specifying a value for the primary index

Which two will occur when a node fails in a system with a hot standby node? (Choose two.)


Options are :

  • Vproc migration occurs for AMPs on the failed node. (Correct)
  • PE Vdisks migrate for fiber attached connections.
  • A restart is required to bring the hot standby node into the configuration.
  • PE Vprocs migrate for channel attached connections (Correct)

Answer : Vproc migration occurs for AMPs on the failed node. PE Vprocs migrate for channel attached connections

What are two benefits of the Teradata database? (Choose two.)


Options are :

  • It provides centralized management and control regardless of system size.
  • It guarantees linear performance for cursor-based processing.
  • There are special versions tuned for the appliances. (Correct)
  • It automatically detects and recovers from software failures. (Correct)

Answer : There are special versions tuned for the appliances. It automatically detects and recovers from software failures.

Which two capabilities are provided by Unity Ecosystem Manager (formerly Teradata MultiSystem Manager) to assist controlling the data warehouse environment? (Choose two.)


Options are :

  • Summaries of account strings and utilities running in the environment
  • Auto notification of users regarding any environment problems (Correct)
  • End-to-end administration of the environment
  • Workload performance and system resource usage balance across the environment (Correct)

Answer : Auto notification of users regarding any environment problems Workload performance and system resource usage balance across the environment

Which three tasks do the AMPs perform? (Choose three.)


Options are :

  • Merging the sorted answer set
  • Row storage and retrieval from the vdisk (Correct)
  • Sending the answer set response back to the requesting client (Correct)
  • Creating the plan to return the response set
  • Disk space management and accounting
  • Output conversion (Correct)

Answer : Row storage and retrieval from the vdisk Sending the answer set response back to the requesting client Output conversion

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


Options are :

  • Is checkpoint restartable
  • Runs scripted batch queries (Correct)
  • Utilizes ODBC connectivity (Correct)
  • Supports ad hoc queries

Answer : Runs scripted batch queries Utilizes ODBC connectivity

Which three capabilities describe Teradata scalability? (Choose three.)


Options are :

  • Can scale to support more data and queries without performance degradation (Correct)
  • Can handle many concurrent users
  • Can add disk capacity or processing power with the offloading and reloading of data (Correct)
  • Can add nodes to increase processing power
  • Can join data from multiple Teradata systems in a single query (Correct)

Answer : Can scale to support more data and queries without performance degradation Can add disk capacity or processing power with the offloading and reloading of data Can join data from multiple Teradata systems in a single query

What are two benefits achieved with an Active Enterprise Data Warehouse? (Choose two.)


Options are :

  • Integrated view of the data (Correct)
  • Actively load large volumes of data during production hours (Correct)
  • Single copy of each transaction
  • Timely availability of data

Answer : Integrated view of the data Actively load large volumes of data during production hours

What are two reasons to define a UPI rather than a NUPI on a SET table? (Choose two.)


Options are :

  • To improve duplicate row checking performance (Correct)
  • To ensure even row distribution
  • To minimize query answer set size (Correct)
  • To improve performance of queries using ranges

Answer : To improve duplicate row checking performance To minimize query answer set size

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions