TE0-01A Teradata Fundamentals Practice Test Set 1

Which two reduce the likelihood of a Full Table Scan (FTS)? (Choose two.)


Options are :

  • A surrogate key is defined on the index column.
  • The primary index is fully qualified
  • The primary index is defined as compressed. (Correct)
  • The use of a WHERE clause in the query. (Correct)

Answer : The primary index is defined as compressed. The use of a WHERE clause in the query.

Which is a characteristic of how active data warehousing has evolved?


Options are :

  • . It uses ad-hoc analysis with data at the detail level.
  • It makes decisions with event-based triggers.
  • It discovers patterns in customer buying habits. (Correct)
  • It produces pre-defined reports.

Answer : It discovers patterns in customer buying habits.

What is a benefit of automatic versus manually managed storage?


Options are :

  • It allows data load preparation to be optimized. (Correct)
  • It enables capacity planning in tracking of the amount of allocated space
  • It eliminates the need to reorganize data or index space.
  • It allows the DBA to control where the data will be placed for optimal access.

Answer : It allows data load preparation to be optimized.

What are access rights?


Options are :

  • named collection of SQL statements
  • mechanisms for logging on to the database
  • privileges on database objects
  • common set of user parameters (Correct)

Answer : common set of user parameters

What is the purpose of accessing a row using the Primary Index?


Options are :

  • It may provide the answer without base table access.
  • It utilizes the power of the full-table scan (Correct)
  • It is only a two-AMP operation.
  • It improves query efficiency.

Answer : It utilizes the power of the full-table scan

Which two sets of functions does the Parsing Engine (PE) perform? (Select two.)


Options are :

  • SQL statement interpretation, syntax validation, and sematic evaluation
  • sorting, formatting, and aggregating of the final answer set
  • flow control of the data to and from the participating tables (Correct)
  • dispatching the step execution sequence to the AMP via the BYNET (Correct)

Answer : flow control of the data to and from the participating tables dispatching the step execution sequence to the AMP via the BYNET

Which are two ways the Transient Journal (TJ) ensures data integrity? (Choose two.)


Options are :

  • It provides full-table recovery to a specific point in time.
  • It provides transaction rollback when transactions fail. (Correct)
  • It provides full-database recovery to a specific point in time. (Correct)
  • It records changed rows automatically.

Answer : It provides transaction rollback when transactions fail. It provides full-database recovery to a specific point in time.

What is an example of throughput and response time?


Options are :

  • time taken for a database shutdown and time taken for a database restart (Correct)
  • . time taken by one query and quantity of data returned
  • number of queries executed in one hour and elapsed time per query
  • number of concurrent users accessing Teradata and number of requests

Answer : time taken for a database shutdown and time taken for a database restart

What is a Role?


Options are :

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

Answer : a set of common logon privileges

Which is a characteristic unique to the Active Data Warehouse (ADW)?


Options are :

  • automatic distribution of data (Correct)
  • concurrent access and load
  • single view of all data in the database
  • robust, parallel-aware Optimizer

Answer : automatic distribution of data

Which two are features of TPump? (Choose two.)


Options are :

  • It uses row-hash locks.
  • It exports tables to client files.
  • It loads data a block at a time. (Correct)
  • . It updates rows in multiple tables. (Correct)

Answer : It loads data a block at a time. . It updates rows in multiple tables.

Which functionality is available through the Teradata Visual Explain tool?


Options are :

  • It generates graphic EXPLAIN plans by role.
  • It uses Query Capture Access to create visual EXPLAIN plans. (Correct)
  • It interprets the EXPLAIN of a query plan automatically.
  • It allows the user to graphically interpret the results of an EXPLAIN

Answer : It uses Query Capture Access to create visual EXPLAIN plans.

Which two describe Perm space? (Choose two.)


Options are :

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

Answer : used to store index subtables used to hold data for global temporary tables

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


Options are :

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

Answer : Tables assigned to that node are no longer available.

Which two can be increased because of Teradata's linear scalability? (Choose two.)


Options are :

  • BYNET bandwidth
  • columns per table
  • memory (Correct)
  • nodes (Correct)

Answer : memory nodes

What are two reasons a customer would choose table partitioning? (Choose two.)


Options are :

  • for better distribution of data between the AMPs (Correct)
  • to improve performance of full table scans
  • to reduce the I/O for range constrained queries (Correct)
  • for the ability to archive specific partitions in a table

Answer : for better distribution of data between the AMPs to reduce the I/O for range constrained queries

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


Options are :

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

Answer : Hash buckets

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


Options are :

  • Gateway
  • BYNET
  • Nod (Correct)
  • AMP (Correct)

Answer : Nod AMP

What is an advantage of relational databases?


Options are :

  • They are designed to support application-driven processes. (Correct)
  • They are relationship independent.
  • They are solidly built on mathematical analysis.
  • They respond quickly to changing business conditions.

Answer : They are designed to support application-driven processes.

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


Options are :

  • Teradata System Emulation Tool
  • Priority Scheduler Administrator
  • Teradata Workload Analyzer (Correct)
  • Visual Explain (Correct)

Answer : Teradata Workload Analyzer Visual Explain

What differentiates between the construction and use of an application data model versus an enterprise data model?


Options are :

  • An application data model is focused on how the data flows through the organization whereas an enterprise data model is focused on how the data is processed.
  • Applying data governance rules is a complex issue when creating application data models whereas it requires nominal incremental effort for an enterprise data model. (Correct)
  • An application data model only looks at one aspect of the business whereas an enterprise logical data model integrates all aspects of the business.
  • The application data model requires additional semantic validation in the development phase whereas the enterprise model does not.

Answer : Applying data governance rules is a complex issue when creating application data models whereas it requires nominal incremental effort for an enterprise data model.

Which statement is true of FALLBACK?


Options are :

  • When one Teradata system goes down, FALLBACK rows in the cluster automatically migrate to the FALLBACK Teradata system.
  • A FALLBACK table eliminates a duplicate copy of an INDEX subtable. (Correct)
  • FALLBACK is intended for non-critical data tables
  • Tables defined with FALLBACK create a Down AMP Recovery Journal in the event of an AMP failure.

Answer : A FALLBACK table eliminates a duplicate copy of an INDEX subtable.

What tool is available for assigning resources to users?


Options are :

  • ResUsage
  • Priority Scheduler
  • VprocManager
  • Teradata Workload Analyzer (Correct)

Answer : Teradata Workload Analyzer

Which tool is available for reviewing historical workload?


Options are :

  • Teradata Administrator (Correct)
  • Teradata MDS
  • Teradata Manager
  • Teradata Query Scheduler

Answer : Teradata Administrator

Which ARC statement can be used to transfer a table from one Teradata system to another Teradata system?


Options are :

  • Restore
  • Checkpoint (Correct)
  • Archive
  • Copy

Answer : Checkpoint

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


Options are :

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

Answer : Read and Read Read and Share

Which three benefits are realized in an IT organization as a result of building a centralized data warehouse as opposed to a non-centralized data warehouse? (Choose three.)


Options are :

  • It uses less space for data storage.
  • Summary data is eliminated.
  • Less history needs to be maintained in the data warehouse. (Correct)
  • New requirements can be satisfied without reloading data. (Correct)
  • Data modeling is simpler. (Correct)

Answer : Less history needs to be maintained in the data warehouse. New requirements can be satisfied without reloading data. Data modeling is simpler.

Which two are advantages of a centralized data warehouse and are disadvantages of physically separate data marts? (Choose two.)


Options are :

  • It avoids row at a time processing.
  • It stores aggregate data instead of detailed data. (Correct)
  • It includes specific data models. (Correct)
  • It is less likely to repeat data.
  • It offers analytical users an historical view of multiple subject areas.

Answer : It stores aggregate data instead of detailed data. It includes specific data models.

What is a reason to choose a NUPI rather than a UPI when creating a new table?


Options are :

  • to allow the use of null (Correct)
  • to guarantee even row distribution
  • to avoid skewing of the data
  • to allow duplicate values

Answer : to allow the use of null

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


Options are :

  • Star schema advocates a greater level of denormalization
  • Recursive data is easier to represent in star schema. (Correct)
  • Both star schema and third normal form advocate repeating groups in a row.
  • The same data modeling concepts exist in both modeling theories

Answer : Recursive data is easier to represent in star schema.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions