TE0-121 12 Teradata Basics Certification Practical Exam Set 8

What is the primary purpose of the staging layer in an Enterprise data warehouse architecture?


Options are :

  • define data transformation
  • add application specific structures (Correct)
  • assess index choices
  • provide end user data views

Answer : add application specific structures

Which two describe the operation of a Full Table Scan (FTS)? (Choose two.)


Options are :

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

Answer : It uses block level locking. It accesses each data block only once.

Why would a NUPI be a better primary index choice than a UPI?


Options are :

  • to avoid skewing of the data (Correct)
  • to allow access by a column with non-unique values
  • to allow the index to have distinct values
  • to guarantee even distribution of the table rows

Answer : to avoid skewing of the data

What is the difference between response time and throughput?


Options are :

  • Response time measures the performance of a CPU and throughput measures I/O performance.
  • Response time measures the average duration of the queries and throughput measures the quantity of queries completed during a time interval.
  • Response time measures the queries processed per second and throughput measures the volume of transactions received. (Correct)
  • Response time measures network delay, and throughput measures the performance of the PE's

Answer : Response time measures the queries processed per second and throughput measures the volume of transactions received.

The AMP controls its portion of the Teradata Database, performing the physical database work, including which two tasks? (Select two.)


Options are :

  • creation of the plan to return the response set (Correct)
  • row storage and retrieval from the VDISK (Correct)
  • output conversion and formatting
  • merge the sorted answer set

Answer : creation of the plan to return the response set row storage and retrieval from the VDISK

What can happen to an AMP during a node failure on a multi-node system?


Options are :

  • Its data will not be available until the node recovers. (Correct)
  • It will migrate to another node in the same clique.
  • It rebuilds itself using the Recovery Journal for all tables.
  • It will continue processing the previous request without interruption.

Answer : Its data will not be available until the node recovers.

What is the order of Data Warehouse evolution?


Options are :

  • Active Warehousing, Reporting, Predicting, Analyzing, Operationalizing (Correct)
  • Analyzing, Predicting, Operationalizing, Active Warehousing, Reporting
  • Predicting, Operationalizing, Reporting, Active Warehousing, Analyzing
  • Operationalizing, Active Warehousing, Analyzing, Reporting, Predicting

Answer : Active Warehousing, Reporting, Predicting, Analyzing, Operationalizing

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


Options are :

  • It can be made up of a maximum of 64 columns.
  • It is a logical database representational concept. (Correct)
  • It implies an access path to the data.
  • It identifies relationships between views.

Answer : It is a logical database representational concept.

Which application interface is used by BTEQ?


Options are :

  • OLE DB (Correct)
  • ODBC
  • CLIv2
  • JDBC

Answer : OLE DB

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


Options are :

  • pause queries (Correct)
  • monitor table locks
  • optimize mixed workloads (Correct)
  • reject query based on table access

Answer : pause queries optimize mixed workloads

What is an advantage of a third normal form data model over a star schema data model?


Options are :

  • It has the ability to support previously undefined questions.
  • It provides a single version of the truth.
  • It is easy to use. (Correct)
  • Implementation is fast.

Answer : It is easy to use.

For a network-attached user, connection to the Teradata Database is made over the LAN using which two components? (Choose two.)


Options are :

  • TDP (Correct)
  • PE (Correct)
  • AMP
  • Gateway

Answer : TDP PE

What are two possible benefits of Aggregate Join Indexes? (Choose two.)


Options are :

  • reduce sorting requirements
  • eliminate aggregate processing (Correct)
  • eliminate base table access
  • improve join performance (Correct)

Answer : eliminate aggregate processing improve join performance

What is a reason to create a NUSI instead of a USI on a table?


Options are :

  • It is the preferable secondary index for access using a single value. (Correct)
  • It is particularly useful for range access equality conditions
  • It is only a two-AMP operation for row retrieval.
  • It has lower space needs for index storage.

Answer : It is the preferable secondary index for access using a single value.

What is the typical purpose of the Semantic layer in an Enterprise data warehouse architecture?


Options are :

  • data transformation
  • data storage
  • data cleansing
  • data views (Correct)

Answer : data views

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


Options are :

  • set a user's PERM space to zero (Correct)
  • require users to access data via stored procedures (Correct)
  • require users to access data via macros
  • restrict access via database profiles

Answer : set a user's PERM space to zero require users to access data via stored procedures

Which two are common between row processing and set processing? (Choose two.)


Options are :

  • Both use serial processing.
  • Both efficiently process large volumes of data. (Correct)
  • Both process with one command
  • Both use all-AMP operations.
  • Both can consist of one row (Correct)

Answer : Both efficiently process large volumes of data. Both can consist of one row

In which two ways is TEMP space used? (Choose two.)


Options are :

  • used to store data for global temporary tables
  • available to the user until their session is terminated
  • used to hold work tables while a query is running (Correct)
  • used to store index data (Correct)

Answer : used to hold work tables while a query is running used to store index data

What is the purpose of a lock?


Options are :

  • It enables one or more databases to update data in a synchronized manner.
  • It serializes access in situations where concurrent access would compromise data consistency.
  • It protects data during a database restart by ensuring only recovery journals can update the tables.
  • It ensures data in the database is only updated by applications with the appropriate rights. (Correct)

Answer : It ensures data in the database is only updated by applications with the appropriate rights.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions