TE0-121 12 Teradata Basics Certification Practical Exam Set 6

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


Options are :

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

Answer : passwords Single Sign-On LDAP

Why would a USI be chosen instead of a NUSI?


Options are :

  • It does not add overhead to the table.
  • It ensures that unique data is inserted into the table. (Correct)
  • It is a single AMP operation.
  • It accesses all AMPs but is more efficient than a Full Table Scan (FTS).

Answer : It ensures that unique data is inserted into the table.

What could improve response time but could also decrease throughput?


Options are :

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

Answer : increase the number of concurrent users

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


Options are :

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

Answer : Teradata AMPS

Which is a key capability provided by the Teradata Parallel Database Extensions (PDE)?


Options are :

  • It monitors system performance.
  • It returns answer sets to the client
  • It controls virtual processor resources. (Correct)
  • It performs disk space management.

Answer : It controls virtual processor resources.

USER1 has been created with NO PERM space allocation. Which object can USER1 create in the USER1 database?


Options are :

  • permanent table
  • stored procedure (Correct)
  • macro
  • join index

Answer : stored procedure

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.
  • A PPI requires less physical space than a traditional primary index. (Correct)
  • A PPI allows for faster primary index access. (Correct)
  • The table is accessed via a range constraint query.
  • The query can take advantage of partition elimination.

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

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


Options are :

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

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

Which component is part of Teradata's open architecture?


Options are :

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

Answer : BYNET

What is a Role?


Options are :

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

Answer : a set of common user parameters

Which two statements are true for both single-level and multi-level partitioned tables? (Choose two.)


Options are :

  • They offer dynamic partition elimination.
  • They can be used with compressed join indexes. (Correct)
  • They can be used with non-unique and unique primary indexes. (Correct)
  • They support direct partitioning on a numeric column.

Answer : They can be used with compressed join indexes. They can be used with non-unique and unique primary indexes.

Which is an advantage of relational databases?


Options are :

  • They are business-driven and reflect the way the business works
  • They are enterprise-driven and reflect departmental priorities.
  • They are technology-driven and resource efficient. (Correct)
  • They are system-driven and represent user access.

Answer : They are technology-driven and resource efficient.

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

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

Why would the Optimizer choose a Full Table Scan (FTS) rather than Index access?


Options are :

  • FTS is estimated to redistribute more data across all AMPs than the index.
  • FTS is estimated to have less user input than the index.
  • FTS is estimated to spool more data than the index. (Correct)
  • FTS is estimated to use fewer resources than the index.

Answer : FTS is estimated to spool more data than the index.

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


Options are :

  • Java Database Connectivity (JDBC) (Correct)
  • Open Database Connectivity (ODBC)
  • Unix Database Connectivity (UDBC)
  • Datagram Congestion Control Protocol (DCCP) (Correct)
  • Call-level Interface V2 (CLIv2) (Correct)

Answer : Java Database Connectivity (JDBC) Datagram Congestion Control Protocol (DCCP) Call-level Interface V2 (CLIv2)

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


Options are :

  • assign the CPUs to a workload (Correct)
  • monitor Service Level Goals (SLGs)
  • limit concurrency
  • pause queries during execution (Correct)

Answer : assign the CPUs to a workload pause queries during execution

For a table-level lock, which two lock type combinations are compatible? (Choose two.)


Options are :

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

Answer : Read and Read Read and Write

Which two can be archived by the Teradata Archive and Restore utility (ARC)? (Choose two.)


Options are :

  • Table (Correct)
  • AMP (Correct)
  • Partition
  • Index subtable

Answer : Table AMP

What can be increased to improve the operation of a Full Table Scan (FTS)?


Options are :

  • BYNETs
  • Hash buckets (Correct)
  • Data rows
  • Nodes

Answer : Hash buckets

At which three levels is locking supported on Teradata? (Choose three.)


Options are :

  • Table
  • Row Hash
  • Index (Correct)
  • Database (Correct)
  • User (Correct)

Answer : Index Database User

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

Answer : It ensures referential integrity of the data.

How much space is used as overhead when using RAID-1?


Options are :

  • 33% (Correct)
  • 50%
  • 25%
  • 20%

Answer : 33%

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


Options are :

  • SQL Assistant Query Builder (Correct)
  • Index Wizard
  • Teradata Workload Analyzer
  • Performance Monitor (Correct)

Answer : SQL Assistant Query Builder Performance Monitor

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


Options are :

  • to improve the performance of scalar queries
  • to allow null values to be used (Correct)
  • to allow the index to have duplicate values
  • to ensure uniqueness of rows

Answer : to allow null values to be used

What distinguishes throughput from response time?


Options are :

  • Response time measures how many queries are processed. Throughput is how long the processing takes.
  • Throughput measures how many rows are processed. Response time measures how long a process takes.
  • Response time is how long the processing takes. Throughput measures how long the rows are processed. (Correct)
  • Throughput measures how many queries are processed. Response time is how long the processing takes.

Answer : Response time is how long the processing takes. Throughput measures how long the rows are processed.

Which two describe Perm space? (Choose two.)


Options are :

  • used to hold work tables while a query is running (Correct)
  • used for Transaction rollback data
  • used to hold data for global temporary tables (Correct)
  • used to store data rows for tables
  • used to store index subtables

Answer : used to hold work tables while a query is running used to hold data for global temporary tables

When accessing the Teradata Database from a network-attached client, which two software components are used for communications? (Choose two.)


Options are :

  • Micro Teradata Director Program (MTDP) (Correct)
  • Micro Teradata System Manager (MTSM) (Correct)
  • Micro Cursor Service (MCS)
  • Micro Call Level Interface (MCLI)

Answer : Micro Teradata Director Program (MTDP) Micro Teradata System Manager (MTSM)

What is the impact on a database when a node failure occurs?


Options are :

  • The database has to be archived (Correct)
  • There is no impact and transactions continue uninterrupted.
  • Tables assigned to that node are no longer available.
  • The database is restarted.

Answer : The database has to be archived

What does the hashing algorithm use to determine which AMP will receive the data?


Options are :

  • Primary Pointer
  • Primary Index
  • Primary Trigger (Correct)
  • Primary Key

Answer : Primary Trigger

Which statement is true regarding strategic queries?


Options are :

  • They normally require row hash locks.
  • They are expected to complete in real-time.
  • They usually avoid all-AMP plans. (Correct)
  • They typically rely heavily on detail data.

Answer : They usually avoid all-AMP plans.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions