TE0-141 14 Teradata Basics Certified Practice Test Set 1

What are two benefits to defining a sparse join index? (Choose two.)


Options are :

  • Corresponds to a single row in its referenced base table
  • Take up less disk space
  • Store roll-up values for dimensions (Correct)
  • Faster to scan (Correct)

Answer : Store roll-up values for dimensions Faster to scan

One reason for creating a multilevel partitioned table would be:


Options are :

  • to create multiple access paths to the data
  • to add value-ordered secondary indexes
  • to increase table level locks
  • to improve primary index retrievals (Correct)

Answer : to improve primary index retrievals

Which two items describe a row in a relational table? (Choose two.)


Options are :

  • A single entity in a table (Correct)
  • An input from a single data source
  • One instance of all the columns in a table
  • A value for every column in the table (Correct)

Answer : A single entity in a table A value for every column in the table

Which two software component are necessary to access Teradata using a mainframeattached client? (Choose two.)


Options are :

  • CU
  • ODBC (Correct)
  • TDP
  • Gateway (Correct)

Answer : ODBC Gateway

What are two performance benefits of Teradata technology? (Choose two.)


Options are :

  • Automatic management of indexes
  • Ability to access a single AMP (Correct)
  • Ability to leverage load utilities from other database systems
  • Automatic management of user privileges and passwords (Correct)

Answer : Ability to access a single AMP Automatic management of user privileges and passwords

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


Options are :

  • Renaming views (Correct)
  • Examining system logs
  • Moving space from one database to another
  • Viewing and tracking system status on one or more databases (Correct)

Answer : Renaming views Viewing and tracking system status on one or more databases

What is an advantage of using row processing instead of set processing for a large table?


Options are :

  • Increased read-ahead capabilities
  • Decreased locking contention
  • Increased synchronized scanning
  • Decreased resources required when updating many rows (Correct)

Answer : Decreased resources required when updating many rows

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


Options are :

  • Virtual Machine Communications Interface (VMCI) (Correct)
  • OLEDB
  • Cellular Network Interface (CNI) (Correct)
  • .Net

Answer : Virtual Machine Communications Interface (VMCI) Cellular Network Interface (CNI)

What is the difference between throughput and response time?


Options are :

  • Throughput measures the volume of transactions received. Response time measures the queries processed per second.
  • Throughput measures the performance of the Parsing Engines (PE). Response time measures network delay.
  • Throughput measures the quantity of queries completed. Response time measures the average duration of the queries.
  • Throughput measures I/O performance. Response time measures CPU performance. (Correct)

Answer : Throughput measures I/O performance. Response time measures CPU performance.

Which three are terms that are associated with star schema but not with third normal form? (Choose three.)


Options are :

  • Primary index (Correct)
  • Normalize
  • Dimensions (Correct)
  • Cubes
  • Facts (Correct)
  • Snowflakes

Answer : Primary index Dimensions Facts

Which two will occur when a node fails? (Choose two.)


Options are :

  • Fallback tables assigned to that node are no longer available.
  • There is no impact and transactions continue uninterrupted. (Correct)
  • Are start occurs. (Correct)
  • The transient journal rolls back any transactions in process during the failure.

Answer : There is no impact and transactions continue uninterrupted. Are start occurs.

Which feature may be used to enable data encryption?


Options are :

  • column-level security (Correct)
  • Profiles
  • Roles
  • user defined functions (UDF)

Answer : column-level security

What are two advantages of using a NoPI table? (Choose two.)


Options are :

  • Data will not be redistributed when performing an INSERT SELECT. (Correct)
  • MultiLoad and TPump are supported. (Correct)
  • SELECT and DELETE will be faster than on a table with a primary index.
  • The sort phase is eliminated when using FastLoad.

Answer : Data will not be redistributed when performing an INSERT SELECT. MultiLoad and TPump are supported.

A table is defined with a multi-column primary index.When a query qualifying on the first column of the primary index is submitted against this table, what is expected to occur?


Options are :

  • Data is directly accessed using the primary index. (Correct)
  • Data is accessed by hashing the qualified column.
  • Data is accessed using a Full Table Scan (FTS).
  • Data is directly accessed through the qualified column

Answer : Data is directly accessed using the primary index.

What is a potential benefit of creating a single table join index?


Options are :

  • It can distribute a subset of a large base table on a column other than the primary index to facilitate joining with another table.
  • It eliminates the need to join a table to itself
  • It automatically adds primary index columns that point to the underlying base table rows. (Correct)
  • It permits definition of a persistent summary table without denormalizing the database.

Answer : It automatically adds primary index columns that point to the underlying base table rows.

USER1 has been created with SPOOL and TEMP space.Which objects can be created in the USER1 database?


Options are :

  • A temporal table
  • A user defined function (UDF) (Correct)
  • A macro
  • A queue table

Answer : A user defined function (UDF)

What are two differences between an application data model and an enterprise data model? (Choose two.)


Options are :

  • An application data model requires additional semantic validation in the development phase while an enterprise data model does not. (Correct)
  • An application data model is focused on how the data flows through the organization while an enterprise data model is focused on how the data is processed. (Correct)
  • An application data model is fixed while an enterprise data model is iterative.
  • An application data model reflects specific functions of the business while an enterprise data model integrates all aspects of the business.

Answer : An application data model requires additional semantic validation in the development phase while an enterprise data model does not. An application data model is focused on how the data flows through the organization while an enterprise data model is focused on how the data is processed.

What are three processes within Unity Director (formerly Teradata Unity)? (Choose three.)


Options are :

  • Endpoint (Correct)
  • Integrator (Correct)
  • Watchdog (Correct)
  • Replicator

Answer : Endpoint Integrator Watchdog

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


Options are :

  • The Parser evaluates the SQL statement for proper syntax. (Correct)
  • The AMP returns the result set to the Dispatcher. (Correct)
  • The BYNET retrieves the result set from the Dispatcher. (Correct)
  • The BYNET passes the dispatched steps to the AMPs.

Answer : The Parser evaluates the SQL statement for proper syntax. The AMP returns the result set to the Dispatcher. The BYNET retrieves the result set from the Dispatcher.

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


Options are :

  • Assign the CPUs to a workload (Correct)
  • Limit query concurrency
  • Pause queries during execution (Correct)
  • Restart paused queries

Answer : Assign the CPUs to a workload Pause queries during execution

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


Options are :

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

Answer : Join method

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 centralized database repository that reflects all of the entities in the business
  • 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

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 two components are necessary to access Teradata over the internet? (Choose two.)


Options are :

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

Answer : Parsing Engine (PE) TDP

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


Options are :

  • Performance is improved by subtable access.
  • The data is redistributed across the AMPS. (Correct)
  • The spool file created may be equal to the size of the base table.
  • 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 two utilities can monitor Unity Data Mover (formerly Teradata Data Mover) processes? (Choose two.)


Options are :

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

Answer : Teradata Viewpoint Unity Data Mover Agent

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


Options are :

  • Star schema uses third normal form physical base tables rather than a view layer.
  • 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 requires more entities than third normal form. (Correct)

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

Which statement is true about a Role?


Options are :

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

Answer : It contains spool allocations

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


Options are :

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

Answer : Fact Lookup

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


Options are :

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

Answer : Parsing Engine (PE) Node

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


Options are :

  • It is a member of a clique. (Correct)
  • It is a member of a cluster.
  • 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.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions