Teradata Basics Questions2

Of the following, which are two Referential Integrity options accessible in the ALTER TABLE command? (Choose two) A. WITH CHECK option B. ON COMMIT DELET ROWS C. DUAL BEFORE JOURNAL D. MODIFY PRIMARY INDEX E. DROP INCONSISTENT REFERENCE

A,E

To determine space requirements for NUSIs, what are three factors that is utilized? (Choose three) A. Fallback B. Number of NULL values C. Number of nodes in the system D. Cardinality E. Index value size

A,D,E

Which three menu options are accessible when you use Visual EXPLAIN? (Choose three) A. Replace Execution Plans B. Show Connectors C. Explain Textual Difference D. Open Plan from Database

B,C,D

The Index Wizard performs which three of the following functions? (Choose three) A. recommends Partitioned Primary Indexes based on specified workloads. B. recommends adding indexes based on specified workloads C. recommends dropping the indexes that may not be necessary D. automatically drops existing indexes based on the workload E. automatically creates DDL statements for recommended indexes

B,C,E

Which of the following are three characteristics of the functions of the PE? (Choose three) A. It determines which AMP should receive a message B. It breaks down SQL requests into steps. C. It can manage up to 120 individual sessions D. It handles output conversion and formatting E. It verifies SQL requests for proper syntax

B,C,E

Match each normal form name to its appropriate description. 1) Attributes must describe the entire primarykey, not just a portion 2) Attributes must describe only the primary key and not each other 3) Attributes must not repeat within a table 4) Attributes of a multi-valued dependency are functionally dependent on each other A) 1NF B) 2NF C) 3NF D) 4NF

...

As part of a training exercise at Certkiller .com,you are asked to arrange the steps that demonstrate how outer joins are logically performed into the correct sequence. Inner table column values for unmatched outer rows are extended with nulls All inner join conditions are performed WHERE conditions are applied

1) All inner join conditions are performed 2) Inner table column values for unmatched outer rows are extended with nulls 3) WHERE conditions are applied

You are an administrator at Certkiller .com.As part of an exercise, Certkiller .comasks you to arrange the tasks performed when using the Teradata Index Wizard into the correct sequence. Indexes are recommended Workload is analyzed Workload is defined

1) Workload is defined 2) Workload is analyzed 3) Indexes are recommended

A lock is held on a resource and a transaction arrives with a LOCKING ROW NOWAIT option. What is the meaning of NOWAIT in this instance? A. NOWAIT means the transaction will not wait in a queue and is aborted immediately. B. NOWAIT means the transaction gets put at the head of the queue for its performance group. C. NOWAIT means the transaction cannot wait and the current lock holder temporarily gives up the lock so the transaction can quickly finish and return the lock. D. NOWAIT puts the transaction at the head of the queue to get the resource as soon as it becomes available.

A

A parameterized macro named ABC is executed by which statement? A. EXEC abc (10, 'ABC'); B. EXEC abc (:10, :'ABC'); C. EXEC abc VALUES(10, 'ABC'); D. EXEC MACRO abc (10, 'ABC');

A

An input data type of timestamp without conversion can be handled by_________ . A. Insert/Select B. FastLoad C. MultiLoad D. Teradata Warehouse Builder

A

HUT locks can be displayed using which utility? A. showlocks B. Locking Logger C. Performance Monitor D. lokdisp E. RCVManager

A

How is a submitted query affected when a deadlock occurs? A. Youngest query is aborted. B. Dispatcher identifies which query to hold and waits for completion of deadlocking query. C. Oldest query is aborted. D. Query waits for deadlock to resolve.

A

How is system availability guaranteed, if a node fails in a MPP environment with multi-node cliques? A. The AMPs on the failed node migrate to the other nodes in the clique. B. The remaining nodes migrate to an alternate clique. C. The RAID groups owned by the AMPs on the failing nodes are shut down. D. The RAID groups owned by the AMPs on the failing nodes migrate to AMPs already running on the remaining nodes in the clique.

A

If column enum is a primary index for both the employee and employee_phone table, which join plan would be seen in the EXPLAN output for the following query? SELECT * FROM employee,employee_phone WHER employee.enum = employee_phone.enum; A. Merge Join B. Row Hash Join C. Product Join D. Nested Join

A

If you are a Certkiller .com database administrator, how would you apply inherited Privileges? A. by granting privileges with the ALL option to a user B. by automatically applying inherited privileges C. by using GIVE to change user hierarchy D. by granting inherited privileges directly to the user

A

In addition to a compiler for a high-level language, which application development API also needs a pre-processor? A. Embedded SQL B. ECLI C. ODBC D. CLI

A

In the table definition, what does the use of the free space parameter allow you to reserve. A. space within a cylinder during loading B. cylinder for further expansion of tables C. space within block during loading D. cylinders for spool to be used by the users

A

In what situation is Fallback data not available? A. when there are two AMPs down in cluster three B. when there are two AMPs down in clique two C. when there is a drive down in AMP one and a drive down in AMP two D. when there is an AMP down in clique one and an AMP down in clique two E. when there is an AMP down in cluster one and an AMP down in cluster two

A

Information on node utilization is provided by which ResUsage table? A. ResUsageSpma B. ResUsageSctl C. ResUsageSvpr D. ResUsageScpu

A

Maximum control over Teradata connectivity is provided by which application development API? A. CLI B. ODBC C. Embedded SQL D. ECLI

A

Of the following, what is the maximum level of data protection? A. RAID 1 and Fallback B. RAID 5 and Fallback C. RAID 5 and No Fallback D. RAID 1 and No Fallback

A

Of the following, which is the type of join that locates a single row using a unique value, then uses the join condition value from the acquired row to access another table using an index? A. Nested Join B. Hash Join C. Product Join D. Merge Join E. Indexed Join

A

Taking the following SQL statement into consideration, how many distinct SAMPLEID values are created if there are 10 rows from every state in the stores table? SELECT city, state, SAMPLEID FROM stores SAMPLE WITH REPLACEMENT WHEN state = 'WI' THEN 4 ELSE 3 END ORDER BY 3 A. 2 B. 3 C. 4 D. 7

A

The GIVE statement has an effect on which of the following? A. owned databases and space B. passwords and explicit access rights C. space and explicit access rights D. owned databases and passwords E. owned databases and explicit access rights

A

The Teradata Warehouse Builder ODBC operator executes which task? A. reads data from an ODBC provider B. transforms data from an ODBC provider C. preprocesses data from an ODBC provider D. writes data to an ODBC provider

A

Two thousand users have recently been added to Certkiller .com's Teradata database and are experiencing connection problems. What might be added to solve this problem? A. PEs B. AMPs C. I/O service processors D. vdisks

A

What benefit does a covered query have? A. All columns required by the query are available via a join index B. All columns required by the query have appropriate access rights for this user. C. All columns required by the query exist in the specified tables. D. All columns required by the query are contained in a single table

A

What best describes primary index access in a table with a Partitioned Primary Index? A. The primary index column values are hashed and each partition which hasn't been eliminated in the predicate is scanned for the rowid. B. The partition value is hashed and each partition which hasn't been eliminated in the predicate is scanned for the rowid. C. The partition value is hashed and the data row is retrieved directly. D. The primary index column values are hashed and the data row is retrieved directly

A

What condition allows you to restore database DBC to a Teradata system? A. following a system initialization B. following the creation of new database objects C. following a standard data table archive D. following a system reconfiguration

A

What is a condition under which a user can access a table through the primary index while it is being loaded with the TPump utility? A. when the user issues a LOCKING FOR ACCESS B. when the user is DBC C. when the user is the owner of the table D. only after the data has been loaded

A

What is a feature of a row, according to relational concepts? A. A row is one instance of all columns B. Row sequence is specified C. Duplicate rows are allowed in a table D. Rows can have different formats

A

What is caused as a result of demoralization on application coding? A. It generally makes new applications more difficult to implement. B. It generally reduces the potential for data problems. C. It increases the cost of data retrieval. D. It usually increases data flexibility.

A

What occurs in the event of a database containing a Permanent Journal running out of space? A. All table updates that write to that Permanent Journal abort. B. The DBS restarts. C. All table updates that write to that Permanent Journal are written to the Fallback Permanent Journal. D. All non-used Permanent Journals in that database are dropped.

A

What occurs in the event of a user that belongs to an allocation group with an IMD policy and a weight of 40%, logs onto an idle system? A. The user's session will have access to all available system resources. B. The user's session will have access to its owner's partition weight %. C. The user's session will have access to 40% of all system resources. D. The user's session will have access to 60% of available system resources. E. The user's session will have access to 40% of available system resources.

A

What shows that a query contains a join or a subquery in an EXPLAIN output? A. the type of join step that is identified B. the number of parallel steps that are generated C. the number of retrieve steps that are generated D. the subquery step that is identified

A

What would best describe user's MAXSPOOL? A. a value used to limit the number of bytes the system will allocate to create spool files for a user B. the number of bytes in use for resolving queries C. the maximum number of bytes created in a spool reserve database to ensure all queries have enough spool space to run efficiently D. the maximum number of bytes used by a transaction for a user since the value was last reset by the ClearPeakDisk macro

A

When electing to demoralize a table, what should you take into consideration? A. volatility B. number of users C. connectivity D. cardinality

A

When the join calls for a Merge Join of two tables with the same primary index, which is the distribution strategy that is preferred by the Optimizer? A. join by accessing the table rows without redistribution B. redistribute one or both tables by the column that is the join constraint C. send all rows of the smaller table to a single AMP for processing and locally copy the larger table into a spool file on each AMP D. choose the smaller spool file and duplicate it on all AMPs, leaving the other table in place E. choose the smaller spool file, duplicate it on all AMPs, and locally copy the other table into a spool file to be prepared for the join

A

When you compress multiple values for a column, where is it stored? A. in the table header B. in the row header C. in the presence bytes D. in the column header

A

When you run a query against a table without Fallback if an AMP is down, how will it be affected? A. The query will execute only if it does not require data from the down AMP. B. The query will always execute and return data from only the AMPs that are available. C. The query will not execute under these conditions. D. The query will execute and return data from all AMPs.

A

Which conditions does the following term refer to in the join step of an EXPLAIN? "residual condition" A. conditions that must be applied after one or more JOIN conditions have been applied. B. Conditions that are applied according to the WHER conditions of UNIONed Select statements C. conditions that do not need to be applied to joined rows D. conditions that reside in cache

A

Which is a denormalization technique that you can apply to a table to help optimize query access when there are many rows that are seldom used? A. horizontal partitioning B. derived data C. vertical partitioning D. repeating groups E. pre-joined tables

A

Which is a true statement regarding join indexes? A. They can be assigned a different primary index from the base table B. They can be used on a table with triggers and Referential integrity constraint C. They can be used to define Full Outer Joins D. They can be processed using Multiload

A

Which is an accurate statement for a partial covering join index? A. The partial covering index includes all columns of the unique index of a table containing non-covered columns. B. The partial covering index is used if most of the columns selected are in the index. C. The partial covering index is used if the join index is an aggregate. D. The partial covering index is used if the primary index of one table is in the covering index

A

Which is the join plan that can utilize a primary index on each of two tables with matching Partitioned Primary Indexes? A. Merge B. Bitmap C. Exclusion Merge D. Product

A

Which of the following is the maximum number of nested levels for a role? A. one B. The limit is determined by the default system setting. C. There is no limit on the number of nested levels. D. two

A

Which statement concerning a Merge Join is true? A. It retrieves rows from two tables and then puts them onto a common AMP, based on the row hash of the columns involved in the join. B. It is a join for which the WHERE conditions specify a constant value for a unique index in one table and those conditions also match some column of that single row to the primary or secondary index of the second table. C. It is a join where only the rows that do not satisfy any condition specified in the request are joined. D. It compares every qualifying row from one table to every qualifying row from the other table.

A

You are adeveloper at Certkiller .com. You have written several SQL statements which generate the same report format for different departments and are run at different times. How could you simplify this process, while retaining the efficiency of the SQL, as well as keeping the source secure? A. create a parameterized macro B. create a global temporary table to hold the result C. create a PP2 program using COBOL D. create a parameterized stored procedure

A

You are an administrator at Certkiller .com. Certkiller .comhas a 4-node Teradata system, with 40 AMPs and 6 PEs. What is the default maximum number of sessions that can be connected simultaneously? A. 720 B. 960 C. 2400 D. 240 E. 400

A

You are an administrator at Certkiller .com.You define Referential Integrity (RI) on a table WITH CHECK option. An implicit transaction with multiple inserts is submitted against the table. What will happen when the RI is violated by one insert? A. All the rows inserted are rolled back and an abort message is issued. B. All rows except the one violator are inserted. An error message informs the user which row did not get inserted. C. An error table is created with a copy of offending column(s) that violated RI. D. All rows are inserted. An error message informs the user of which row is the problem row that needs to be fixed.

A

Which two of the following statements are accurate regarding a column, according to relational concepts? (Choose two.) A. Column position is arbitrary. B. Columns always contain like data. C. Columns cannot contain NULL data. D. Columns require range constraints.

A, B

Which three statements pertaining to join plans are true? (Choose three) A. A Nested join is only used when the user specifies a constant value in a WHERE clause B. A Merge join requires that the data from the tables be sorted before performing the join operation C. A Hash join requires that the data from both tables be sorted before performing the join operation D. A Merge join retrieve rows from tables and requires them to be on the same AMP based on the row hash of the columns involved in the join.

A, B, D

Which three are possible join types if you see the following phrase in the EXPLAIN of a join process? (Choose three) "spool... which is duplicated on all AMPs." A. Product Join B. Predicate Join C. Hash Join D. Nested Join E. Merge Join

A, C, E

A user's access to database objects is restricted by which two of the following? (Choose two.) A. roles of user B. access rights C. profile of user D. creator of user E. access logs

A,B

Every time you have stand-alone derived data, you have to decide to either calculate it, or store it. Which two demographics should be the basis of your decision? (Choose two) A. column data value volatility B. access frequency C. access column D. number of sources involved

A,B

For which two reasons would you choose a NUPI? (Choose two.) A. It allows clustering of data rows. B. It facilitates AMP-local joins of matching sets. C. It is a closer match for the primary key. D. It allows the user to generate a much larger table. E. It allows duplicate rows in a set table.

A,B

For which two types of tables are Partitioned Primary Indexes best suited? (Choose two) A. large tables that are maintained by deleting and adding ranges of rows B. large, tables that are frequently accessed using restrictive conditions C. large tables that are frequently accessed for Referential Integrity checks D. large, tables that are not referenced using range constraints

A,B

Good OLTP performance is provided by which two access types? (Choose two.) A. nested joins B. unique secondary index C. full cylinder read D. non-unique secondary index

A,B

In Usage Demographics of a column, which are two factors that are considered? (Choose two.) A. frequency of join access in SQL queries B. frequency of value access in SQL queries C. frequency of change D. frequency of loading data

A,B

In which two of the following situations is it necessary to collect multi-column statistics? (Choose two.) A. if a secondary index was defined to allow statistics collection in the past B. when the columns frequently appear together in join conditions C. if the combination of columns will be using multi-value compression D. when the columns frequently appear together in a GROUP BY clause of an hourly report

A,B

Of the following statements, which two pertaining to ownership privileges are correct? (Choose two.) A. They cannot be explicitly revoked. B. They cannot be taken away unless ownership is transferred. C. They can be explicitly revoked by the Database Administrator. D. They must be explicitly granted.

A,B

The Optimizer can often perform which two of the following as a Hash Join? (Choose two.) A. Inner Join B. Self Join C. Nested Join D. Cross Join

A,B

The Teradata Statistics Wizard is able to execute which two tasks? (Choose two.) A. execute statistics collection recommendations B. recommend recollection of statistics based on table skew C. reproduce Optimizer related issues in a test environment D. display current versus captured statistics information E. recommend secondary indexes

A,B

The elapsed time of a particular query can shorten by performing which of the following tasks? (Choose two.) A. modify the weight assigned to the Allocation Group of the session used to run the query B. raise the priority of either the query or of the session in which it is running C. change the Priority Scheduler settings to give a higher priority to all long-running (CPU intensive) queries D. delete all Performance Groups that are not being used

A,B

The primary index columns will differ from the primary key columns for what two reasons? (Choose two.) A. known access paths B. join performance C. to increase volatility D. to enforce uniqueness

A,B

To verify data integrity, you should run which two utilities? (Choose two.) A. Scandisk B. Checktable C. DBSControl D. Packdisk E. Defrag

A,B

What are two accessible table types when users want to generate a small temporary table and have only spool space assigned to them? (Choose two.) A. Volatile B. Derived C. Permanent D. Global Temporary

A,B

When you attempt to evade Data Dictionary access and transaction locks, which are two table types you should consider? (Choose two.) A. Volatile B. Derived C. Permanent D. Global Temporary

A,B

Which are two pieces of information from DBQL that may be used to define a workload policy for TDQM? (Choose two.) A. the typical processing time for queries during the defined time B. the occurrence of full table scans during the specified time C. the size of the tables involved in queries during the defined time D. the number of AMPs running at 100% CPU during the specified time

A,B

Which are two ways of implementing transaction integrity on a single platform in Teradata mode? (Choose two.) A. Encapsulate statements between the Begin Transaction (BT) and End Transaction (ET) statement pair. B. Create an implicit transaction using a multi-statement request. C. Issue a COMMIT WORK statement after the last statement in the transaction. D. Create a reference constraint to enforce the integrity.

A,B

Which of the following are two appropriate methods of employing table aliasing to avoid Cartesian product joins? (Choose two.) A. SEL * FROM table_a A1, table_a WHERE A1.acct1 = table_a.acct2 B. SEL * FROM table_a A1, table_a A2 WHERE A1.acct1 = A2.acct2 C. SEL * FROM table_a A1, table_a A2 WHERE A1.acct1 = table_a.acct2 D. SEL A1.c1, table_a.c2 FROM table_a A1, table_a A2 WHERE A1.acct1 = A2.acct2

A,B

Which two can be determined with AMPUsage data? (Choose two.) A. session priority B. user activity C. user privileges D. database owners

A,B

Which two of the following are planning considerations when you want to set up Roles in Teradata? (Choose two.) A. Will the users need to create permanent tables? B. Will the users need permissions to access specific tables? C. Will the users be assigned to the same profile? D. Will the users need to create volatile tables?

A,B

Which two of the following options should you take into account when calculating the size requirements for global temporary tables? (Choose two.) A. the number of concurrent materializations per user B. the size and number of rows per use C. the spool requirements for the user D. the archive policy for the system

A,B

Which two of the following statements are accurate with regards to data distribution? (Choose two) A. In a partitioned table the partition identifier is part of the row identifier B. Rows from a partitioned table are stored in partitions on each AMP and ordered by hash. C. Secondary indexes affect the distribution of rows across AMPs. D. Both primary and secondary indexes may be created and dropped dynamically E. Both primary and secondary indexes use subtables for access to data rows.

A,B

With reference to identity columns, which of the following are two accurate statements? (Choose two) A. Only one can be specified per table. B. They need not be a primary index column. C. They can be primary index of a table with atomic upsert operations D. They can be part a composite primary index.

A,B

n which two kinds of application implementation are updatable cursors allowed? (Choose two.) A. applications that use a Teradata pre-processor B. stored procedures C. macros D. triggers

A,B

A USI has which three advantages? (Choose three) A. duplicate row checking is not necessary B. cannot insert rows with duplicate USI values C. can eliminate a full table scan D. saves disk space E. is used to cover queries

A,B,C

All AMPs are required by which three of the following join methods? (Choose three) A. Merge Joins B. Product Joins C. Hash Joins D. Nested Joins

A,B,C

FastExport is best described by which three of the following? (Choose three.) A. exports from multiple tables B. uses Support Environment C. uses multiple sessions D. exports data to multiple files without use of OUTMOD

A,B,C

For what three reasons would you make use of identity columns? (Choose three.) A. to reduce the need to generate keys outside of Teradata B. when more even data distribution is needed C. to facilitate moving applications from other systems to Teradata D. when users need key values with hidden significance or intelligence

A,B,C

In which three of the following instances can an identity column be useful in a table definition? (Choose three.) A. when a unique secondary index is desired for the table B. when a primary key is desired for the table C. when a primary index is desired for the table D. when a Partitioned Primary Index (PPI) is desired for the table E. when a foreign key is desired for the table

A,B,C

Of the following options,which three are considered when you select a column as a primary index? (Choose three.) A. frequency of change B. maximum rows per value C. distinct values D. minimum rows per value E. sample data

A,B,C

Of the following, which are three data demographic elements? (Choose three) A. number of nulls B. number of rows per value C. number of distinct values D. number of constraints

A,B,C

On which three of the following can Logging be invoked if you are using Database Query Log (DBQL)? (Choose three) A. all users B. a list of users C. a list of account strings D. a list of database objects

A,B,C

Sufficient data protection can be provided by a backup of your entire database using the ARC utility, in which three of the followingcircumstances? (Choose three.) A. when there are accidentally dropped tables, views, or macros B. when there is a loss of the data on multiple AMPs within the same cluster C. when there is a loss of data on an AMP for non-Fallback tables D. when global temporary tables are in use at the time of the archive operation

A,B,C

The Teradata Administrator tool can be used to perform which three tasks? (Choose three.) A. grant MONITOR privileges to a user B. clone users C. copy DDL from one system to another D. copy table data from one system to another E. abort a user session

A,B,C

What are three accurate statements pertaining to Global and Volatile Temporary tables? (Choose three.) A. Global Temporary table definitions are maintained in the Data Dictionary. B. Volatile Temporary tables must be created before they can be materialized. C. Volatile Temporary tables are materialized in spool space and their definition is maintained in cache. D. Volatile Temporary table space requirements are charged against the user's allocation of temporary space.

A,B,C

What are three functions of the Statistics Wizard? (Choose three.) A. allows importing of workload from other Teradata utilities B. allows you to schedule statistics collection C. makes recommendations based on table demographics D. allows for "what-if" analysis

A,B,C

When determining a workload definition for TDQM, which of the followingare three useful methods? (Choose three.) A. DBQL analysis of join types for the schedule period B. DBQL analysis of full table scans requested during the period C. Priority Scheduler output containing queue length and wait times D. the Statistics Wizard analysis of needed statistics for this workload E. the number of Resource Partitions defined in Priority Scheduler

A,B,C

When using a Left Outer Join, which three of the following options describe the rows returned from the left and right table? (Choose three.) A. unmatched rows from the left table B. matched rows from the right table C. matched rows from the left table D. unmatched rows from the right table

A,B,C

When you create a primary index, which three of the following options should be taken into consideration? (Choose three) A. Primary index values should not be subject to change B. Very non-unique values can cause premature "database full" conditions. C. Columns frequently used for row selection are good candidates D. If third normal form you must use a primary key E. Duplicate values are not stored in the same block

A,B,C

Which three of the following are attributes of derived tables? (Choose three.) A. There is no Data Dictionary involvement. B. Spool rows are discarded when the query finishes. C. They are local to the query. D. They are materialized in temporary space. E. They may be defined with DDL.

A,B,C

Which three of the following considerations are valid for optimal system performance? (Choose three.) A. Primary indexes are chosen based on access, uniqueness, and stable data values. B. The performance benefit of a secondary index for OLTP applications outweighs the performance cost for batch maintenance. C. Statistics are collected on all indexes. D. The disk space consumed by a secondary index negatively impacts OLTP applications.

A,B,C

Which three of the following statements would be valid constructs within the following partially defined stored procedure? (Choose three.) CREATE PROCEDURE test_set (IN a INT, INOUT b INT, OUT c INT) A. SET b = b + 1 B. SET c = b + 1 C. SET c = b + a D. SET b = c + 1

A,B,C

Which three of the followingare essential Teradata RDBMS facilities for hardware fault tolerance? (Choose three.) A. cliques B. RAID disk units C. redundant power supplies D. AWS

A,B,C

Which three of the followingstatements pertaining to data compression are true? (Choose three.) A. CPU path length associated with the I/Os saved is substantial. B. It can achieve substantial reduction of space for both numeric and character data. C. The actual uncompressed values are stored in the table header. D. It reduces the overhead for storing variable character data.

A,B,C

Which three of the options can you use to enhance the overall performance of the system? (Choose three.) A. multi-value compression B. Partitioned Primary Index (PPI) C. multi-statement requests D. PMON E. triggers F. establish profiles

A,B,C

When deciding between calculating summary results on demand and creating a summary table, you should consider which four important factors? (Choose four.) A. frequency of summary request B. response time requirements C. complexity of the calculations D. concurrency of users E. volatility of the column to summarize F. typical rows per value

A,B,C,E

Which four of the following options conclude whether a column or index must have statistics collected? (Choose four.) A. non-indexed column used for set selection B. non-unique indexes C. non-indexed column used for join constraints D. columns in the SELECT list E. columns in the GROUP BY clause F. the UPI of small tables with no other statistics

A,B,C,F

Capacity planning is assisted by which three periodic summaries? (Choose three.) A. user logons and logoffs B. spool usage C. number of materialized tables D. table growth

A,B,D

Of the following, which three statements pertaining to COLLECT STATISTICS are true? (Choose three) A. Multi-column collection can be done at the column level without creating an index. B. Statistics can be collected on a maximum of 512 columns und indexes per table. C. Statistics can be collected on a maximum of 40 columns and indexes per table. D. Statistics can be calculated using a sample of the table data. E. Statistics can be useful in determining which AMPs will be accessed for query processing.

A,B,D

Spool files are required for which three join methods? (Choose three) A. Product Join B. Merge Join C. Nested Join D. Exclusion Merge Join

A,B,D

Teradata System Emulation Tool uses which three sets of information to model production system processes on a test system? (Choose three.) A. hardware characteristics B. table and column statistics C. samples of table data D. object definitions

A,B,D

The amount of raw data generated by a single INSERT EXPLAIN in the Query Capture Database is affected by whichthree elements? (Choose three.) A. size of the SQL statement B. number of tables and views in the query C. average size of the tables in the query D. size of the EXPLAIN statement output

A,B,D

What are three purposes of Teradata STATISTICS (Choose three) A. enables the Optimizer to evaluate NUSI bit mapping B. Helps the Optimizer determine optimal join types and sequences C. Helps the Optimizer determine how well the data is distributed across the AMPs. D. used to estimate the cardinalities of intermediate spool files.

A,B,D

Which are three factual statements concerning the creation and use of indexes? (Choose three.) A. All secondary, hash, and join indexes are stored in subtables, so they require additional storage space. B. Index subtables are updated each time an indexed column value in the base table is updated or deleted. C. Hash indexes are created in order to allow the Optimizer to choose hash joins. D. A Unique Secondary Index entry might not reside on the same AMP as the base table row.

A,B,D

Which of the following are three accurate statements on the subject of roles? (Choose three.) A. Roles help reduce the number of rows in the DBC.AccessRights table. B. Changes are effective immediately. C. They are a set of common user parameters applied to a group of users. D. They are viewed as a pseudo-user with privileges on objects. E. Changes are not effective until the next logon.

A,B,D

Which of the following three statements is accurate concerning a Partitioned Primary Index (PPI)? (Choose three.) A. A PPI can slow joins if there are many partitions. B. A PPI can speed up row deletion. C. A PPI table can be altered to change the range of an existing partition. D. A PPI can substitute for a secondary index.

A,B,D

Which three actions are allowed by Data Control Language (DCL) statements? (Choose three.) A. restricting access to database objects B. holding membership in a role C. logging on to the client D. logging on to Teradata

A,B,D

Which three are techniques for reducing the number of rows that are inserted into the DBC.AccessRights table? (Choose three.) A. assign users to a role B. grant privileges at the database level C. assign users to a profile D. grant privileges at the user level

A,B,D

Which three of the following are features of third normal form? (Choose three.) A. Attributes must relate to the entire primary key. B. Attributes must relate to the primary key and not to each other. C. Attributes must relate to the entire foreign key. D. There are no repeating groups. E. Indexes are defined on the attributes.

A,B,D

Which three of the following are recovered from an AMPs virtual disk (vdisk)? (Choose three) A. index subtables B. tables C. master index D. spool E. free cylinder list F. hash maps

A,B,D

Which three of the following describe similarities between Volatile tables and Derived tables? (Choose three.) A. have no Data Dictionary access or transaction locks B. are designed for optimal performance C. are local to the query D. table definition kept in memory

A,B,D

Which three of the following should be included in an analysis that defines TDQM restrictions? (Choose three.) A. a list of users whose access must be above restriction B. a listing of the requirements for critical applications and the times of day that are most critical C. the client resources available during the peak periods D. an understanding of the timing requirements for maintenance of specific tables or databases E. a projection of the growth pattern for major tables in the database

A,B,D

Which three of the followingaspects should be taken into consideration when a column is chosen as a primary index? (Choose three.) A. frequency of access B. distribution across the AMPs C. data type D. stability of the data values

A,B,D

Which three security reasons justify the use of a macro? (Choose three.) A. It limits the need to grant privileges on tables and views used in the macro. B. The privilege to create the macro can be restricted to specified developers. C. A parameterized macro can be designed to use the parameter to control the table or view to access in the macro. D. A parameterized macro can be designed to use the parameter to restrict access to a subset of the data for a given table or view used in the macro.

A,B,D

Which three tasks does the Profile subsystem in Teradata Manager allows you to execute? (Choose three.) A. establish a connection to a Teradata Database B. program automatic application starts C. identify users with similar characteristics D. tailor the Teradata Manager drop-down menus E. store information about registered users

A,B,D

With reference to single-column NUSIs, which three statements are true? (Choose three.) A. Their statistics are stored in DBC.TVFields. B. They can be created on an existing value-ordered NUSI column. C. Their access involves row-hash level locking. D. They may be used for access if statistics do not exist on them. E. They must be dropped prior to running MultiLoad.

A,B,D

In the CREATETABLE statement, what are three applicable DATABLOCKSIZE options? (Choose three) A. DATABLOCKSIZE = 32 KILOBYTES B. MINIMUM DATABLOCKSIZE C. DATABLOCKSIZE = MAXIMUM D. OWNERS DATABLOCKSIZE E. MAXIMUM DATABLOCKSIZE

A,B,E

Which three types of parallelism is demonstrated in the following request, where "col" is the UPI of table T1? (Choose three.) SELECT * FROM T1 WHERE col = 1 ;SELECT * FROM T1 WHERE col = 2; A. multi-AMP B. multi-step C. multi-request D. multi-session E. multi-statement

A,B,E

A sparse index can best be described by which two options? (Choose two.) A. is a type of join index B. references values that are rarely used in queries C. reduces the storage requirements for an index D. is especially useful for joining to tables that have few rows

A,C

For what two reasons are allowing columns to follow consistent data types administered at the domain level important? (Choose two.) A. reduces data redistribution B. reduces data storage requirements C. avoids data conversions D. eliminates data compression E. eliminates need for constraints

A,C

For which two reasons would Partitioned Primary Index (PPI) be considered on a table? (Choose two.) A. to eliminate ranges of data values from a query and thereby reduce scan time B. to reduce response time by placing all data in the same partition on the same AMP C. to reduce the amount of I/O needed to process queries D. to reduce the number of columns in a table to those needed by most queries

A,C

Of the following statements, which two are accurate regarding Permanent Journals? (Choose two.) A. Multiple data tables can share one Permanent Journal. B. Permanent Journals replace Fallback protection. C. Data tables in one database can use Permanent Journals in other databases. D. Permanent Journals must be Fallback. E. Multiple Permanent Journals can be used by one data table.

A,C

On the subject of FastLoad, which two statements are correct? (Choose two.) A. no journaling B. can maintain NUSIs but not USIs C. no secondary indexes on the target table D. loads duplicate rows into a multiset table

A,C

Permanent Journaling allows continuous operation In which two of the followingways? (Choose two) A. All archive related activities on a Permanent Journal take significantly less time than an archive of the referenced table. B. An archive of a Permanent Journal subtable places locks on the underlying table(s). C. If the Permanent Journal includes After Images, the table can be archived without impeding concurrent update activity in progress. D. It is not necessary to checkpoint a Permanent Journal when using a Group Read Lock.

A,C

The growth of the AccessRights table can effectively be limited by which two of the Following methods? (Choose two.) A. grant all privileges at the database level B. ensure that all users belong to a profile and inherit the profile's access rights C. assign users to one or more roles D. grant all necessary privileges to each user on individual database objects

A,C

The import of workloads from other Teradata tools is facilitated by which two tools? (Choose two.) A. Index Wizard B. TSET C. Statistics Wizard D. Visual Explain

A,C

To export data for a report utilizing RECORD mode from the Teradata database, which are two utilities that you can use? (Choose two.) A. BTEQ B. Teradata SQL Assistant C. FastExport D. TPump

A,C

What are two characteristics of derived tables? (Choose two) A. Spool space is used to materialize table B. Temporary space is used to materialize table C. Rows are deleted when the query ends. D. Definitions are stored in the data dictionary E. Rows are maintained following a system restart

A,C

What are two effects of statistics collection that can be displayed through EXPLAIN output? (Choose two.) A. if a new index will be used B. the CPU and I/O usage of each step C. the estimated spool row count of a step D. the data skew of large tables E. the selectivity of various indexes

A,C

When grouping the Teradata users under profiles, which of the followingare two options that are available? (Choose two.) A. management of the Priority Scheduler Performance Groups B. control over the object creation access rights C. control of the AMP Usage Logging and Account String Expansion D. management over the external connections available to users

A,C

Which are two correct statements on the subject of USI maintenance? (Choose two.) A. Updating the USI value of the base row requires relocating the corresponding USI row. B. Updating the UPI value of the base row requires relocating the corresponding USI row. C. A separate Transient Journal entry is required for a changed USI row. D. Updating the PI of a base row requires relocating the corresponding USI row.

A,C

Which of the following are two accurate statements regarding MultiLoad? (Choose two.) A. It is limited by the MaxLoadTasks parameter of DBSControl. B. It requires empty tables. C. It is checkpoint restartable. D. It allows multiple concurrent loads to the same table.

A,C

Which two are accurate statements regarding COLLECT STATISTICS? (Choose two.) A. Statistics allow the Optimizer to choose NUSI bit mapping. B. Statistics are automatically updated by the system. C. The Optimizer is more conservative when statistics are missing. D. Statistics must be refreshed after a reconfiguration of the system.

A,C

Which two of the following utilizations must be examined first when you troubleshoot bottlenecks? (Choose two.) A. CPU utilization B. BYNET utilization C. disk utilization D. channel utilization E. memory utilization

A,C

Which two of the followingstatements are true with regard to lock levels? (Choose two.) A. A read lock ensures that no modification of that resource is permitted while a SELECT operation is in progress. B. A write lock ensures that the requester has exclusive rights to the locked resource so that no other process can read from, write to, or access the locked resource in any way. C. A write lock ensures that the requester has exclusive rights to the locked resource except for readers not concerned with data consistency. D. A read lock permits modifications on the underlying data while a SELECT operation is in progress.

A,C

Which two statements are true about Col1 if you take the following identity column definition into consideration? (Choose two.) Col1 INTEGER GENERATED ALWAYS AS IDENTITY (MAXVALUE 100) A. The first inserted row will have a value of 1. B. By explicitly specifying values in the insert, it is possible to skip numbers in the sequence. C. The table cannot have more than 100 rows. D. Deleted rows may be replaced in the sequence

A,C

Which two statements pertaining to join indexes are correct? (Choose two) A. Join indexes are automatically updated when underlying data rows change. B. A query must reference the join indexes to activate it. C. Join indexes may have repeating values. D. The Archive utility will restore join indexes. E. Join indexes are normally used when tables are weakly selective.

A,C

You are an administrator at Certkiller .com. There is join between a Non-Partitioned Primary index (NPPI) table and a Partitioned Primary index (PPI) table with a huge number of surviving partitions after applying constraints. Which two of the following statements of the above NPPI to PPI join are accurate if you compare it to an NPPI to NPPI join? (Choose two) A. CPU utilization is higher. B. CPU utilization is the same. C. Disk I/Os are higher D. Disk I/O are less. E. Memory requirements are the same.

A,C

"soft" Referential integrity has been defined on two tables joined in a view. When you are selecting columns using this view, which three of the following statements are true? (Choose three) A. If data is requested from both tables, Teradata will do the expected join. B. If data is requested from the referenced table, Teradata will lock and return data directly from the referenced table without joining to the referencing table. C. If data is requested from the referencing table, Teradata will lock and return data directly from the referencing table without joining to the referenced table. D. If data is requested from the referenced table, Teradata will do the expected join.

A,C,D

Of the following, which are three features of a global temporary table? (Choose three) A. Definitions are stored in the data directory B. Rows are lost following a system restart. C. Temporary space is used to materialize the table. D. Rows are deleted at session end. E. Spool space is used to materialize the table

A,C,D

Permanent Journals offers which three types of protection? (Choose three.) A. protection against the loss of changes made after a data table is archived B. Fallback protection for journaled non-Fallback tables C. protection against incorrect operation of a batch process D. protection from loss of data caused by failure of a secondary storage device

A,C,D

Visual EXPLAIN is best described by which three of the following statements? (Choose three) A. It identifies what the Optimizer chooses not why B. It may be used on any SQL statement, including EXPLAIN C. It may be used on any SQL statement, except EXPLAIN D. It translates Optimizer output (the parse tree) into icons. E. It identifies what the Optimizer chooses and why

A,C,D

What does the Optimizer estimate when you want to equi-join a Partitioned Primary Index (PPI) table to a Non-Partitioned Primary Index (NPPI) table, or to another PPI table defined with a different partitioning expression? (Choose three) A. Spooling one or both PPIs into a NPPI spool and joining these using a conventional merge join. B. Re-partitioning and redistributing both tables to have matching partition definition in preparation for a rowkey-based Merge Join. C. using a "sliding window" join of the two tables without re-partitioning either table. D. Re-partitioning, if possible, one of the two tables into a PPI spool with the same partitioning as the PPI table in preparation for a rowkey-based.

A,C,D

What three parameters you can set in TPump? (Choose three.) A. SERIALIZE B. REPEAT C. PACK D. ROBUST

A,C,D

When a column defined as a foreign key in the referencing table is compared to the primary key in the referenced table, which three rules will apply? (Choose three.) A. The data type must be the same. B. The compression values must be the same. C. No column in the foreign key (referencing) can be an identity column. D. The case sensitivity must be the same.

A,C,D

When you are comparing MultiLoad and TPump, which are three statements that you find to be true? (Choose three.) A. MultiLoad uses table locks; TPump uses row hash locks. B. MultiLoad uses multiple statement requests to improve performance; TPump uses multiple sessions to improve performance. C. MultiLoad updates tables from a work table; TPump updates tables from CLI parcels directly. D. MultiLoad performs better as volume of changes increases; TPump performs better on low volume of changes.

A,C,D

Which of the following are three potential drawbacks of a Partitioned Primary Index (PPI)? (Choose three.) A. The table might need to be re-created if the partitioning granularity changes. B. It can cause more AMPs to be involved in accessing data. C. A large number of partitions could cause slow joins. D. The partitioning column might not be part of the primary index.

A,C,D

Which of the followingare three consequences of the EMPLOYEE ALL clause in the Archive utility being used? (Choose three.) A. All tables in database EMPLOYEE are archived. B. Only database EMPLOYEE and its immediate descendants are archived. C. All tables, views, and macros in database EMPLOYEE are archived. D. Database EMPLOYEE and all its descendants are archived. E. All databases with the root name EMPLOYEE are archived.

A,C,D

Which three items are affected if you choose ANSI instead of Teradata mode? (Choose three.) A. data conversions B. rounding behavior C. case sensitivity defaults D. transaction protocol behavior

A,C,D

Which three methods can be made use of to design the query for a report of day-of-week (i.e., Saturday sales, Sunday sales, etc.) sales totals? (Choose three.) A. Use the CASE statement. B. Use the SET SESSION DATEFORM statement. C. Use the system calendar. D. Use a minor entity table.

A,C,D

Which three of the following statements regarding identity columns are true? (Choose three) A. They are supported by Tpump B. They guarantee sequential numbering of inserted rows. C. They simplify the initial port from other database that use generated keys. D. They provide even row distribution when used as a primary index

A,C,D

Which three of the followingTeradata utilities are also CLI applications? (Choose three.) A. PM/API B. SQL Assistant C. C Preprocessor2 D. BTEQWin

A,C,D

With regard to join plans, which of the following are three accurate statements? (Choose three) A. A Merge Join requires that the data from the tables be sorted before performing the join operation. B. A Hash join requires that the data from both tables be stored before performing the join operation C. A Merge join retrieves rows from two tables and requires them to be on the same AMP based on the row hash of the columns involved in the join. D. A Nested join Is only used when the user specifies a constant value in a WHERE clause.

A,C,D

MERGE INTO department USING VALUES (105, 'Sales Dept', 770000, 1018) AS Dept (deptnum, deptname, budget, manager) ON Dept.deptnum = department.department_number WHEN MATCHED THEN UPDATE SET budget_amount = Dept.budget WHEN NOT MATCHED THEN INSERT VALUES (Dept.deptnum, Dept.deptname, Dept.budget, Dept.manager); Which of the following are four true statements in relation to the following MERGE INTO statement? (Choose four.) A. The USING clause defines the source table row. B. The primary index of the target table must be unique. C. The AS clause specifies the name of the source table. D. The operation performed is an Upsert on the department table. E. The ON clause must contain the primary index of the target table.

A,C,D,E

In which three ways do Materialized global temporary tables differ from permanent tables? (Choose three) A. They are always empty when first materialized B. Contents can be shared by other sessions C. They are automatically dropped at the end of each session D. Rows are maintained after a system restart E. Contents can optionally be at the end of each transaction

A,C,E

Running Visual Explain on queries during application development is necessary for whichthree reasons? (Choose three.) A. to determine access paths B. to calculate necessary spool space requirements C. to validate the usage of indexes D. to establish run times E. to determine locking profiles

A,C,E

The MaxLoadTasks parameter limits which three of the following utilities in the DBSControl utility? (Choose three.) A. FastExport B. BTEQ C. MultiLoad D. TPump E. FastLoad

A,C,E

To use all the functions of the Performance Monitor, you need possess which three user privileges? (Choose three.) A. monsession B. selsession C. setresrate D. insertsesrate E. abortsession

A,C,E

If you are defining Roles in Teradata, what are two questions that you should ask yourself? (Choose two.) A. Will this user need more than just SELECT access to the data? B. From which network path will this user access Teradata? C. What characteristics are important for this user's password controls? D. Will this user be assigned to perform more than one job function?

A,D

In query analysis, what information is provided by the EXPLAIN output to assist the user? (Choose two.) A. which steps may be processed in parallel B. what statistics should be collected on a column C. accurate time measurements for query processing D. details of which indexes, if any, will be used to process the query E. recommendations to improve the query based on timing and sizing

A,D

Of the following software components,which two runs on a Teradata channel-attached client? (Choose two.) A. TDP B. PE C. TPA D. CLI E. TGTW

A,D

Of the following statements,which two concerning Fallback protected tables are correct? (Choose two.) A. If the primary AMP fails, the system can still access data on the fallback AMP. B. Fallback protection is accomplished by grouping AMPs into cliques and distributing every row to a different AMP from the one containing the primary row. C. In limited cases, the Fallback copy of a row can reside on the same AMP as the primary copy. D. Fallback protected tables take up twice the space on your system as non-Fallback protected tables.

A,D

The impact of TPump on the system can be decreased in which two ways? (Choose two.) A. reduce the RATE parameter in the TPump job B. add a TENACITY parameter to the TPump job C. add a SLEEP parameter to the TPump job D. modify the Priority Scheduler Facility (PSF) settings E. apply options in the Ferret utility

A,D

The use of global temporary tables has what two performance advantages? (Choose two.) A. There are no locks placed on any objects when they are materialized or dropped. B. They share data between user sessions. C. Referential Integrity rules can be enforced. D. They allow reuse of intermediate results.

A,D

UPDATE has which are two features? (Choose two .) A. It can include a self join. B. It cannot include a subquery. C. It must include a WHERE clause. D. It can be performed on a single table view.

A,D

What are two strategies that can be employed to increase parallelism when someone submits a high volume of all-AMP requests? (Choose two.) A. use more sessions B. use multi-request transactions C. use NUSIs on the tables D. use multi-statement requests

A,D

When 'we lock databasename.tablename for access' is shown by the EXPLAIN output, which two statements are true? (Choose two.) A. The query has a table level access lock on the object. B. The query has a rowhash level access lock on the object. C. The user can read the object even when it is already or concurrently locked for exclusive access. D. The user can read the object even when it is already or concurrently locked for read or write.

A,D

Which are two available options when tuning for tactical queries in Priority Scheduler? (Choose two.) A. place the users submitting tactical queries in Allocation Groups with the highest weight B. place the users submitting tactical queries in Resource Partition 0 C. place the users submitting tactical queries in Allocation Group 0 D. reserve AMP Worker Tasks for tactical queries

A,D

Which of the following is provided by the EXPLAIN output for user assistance in query analysis? (Choose two.) A. which steps may be processed in parallel B. what statistics should be collected on a column C. accurate time measurements for query processing D. details of which indexes, if any, will be used to process the query E. recommendations to improve the query based on timing and sizing

A,D

Which of the followingare two true statements regarding "soft" Referential Integrity (RI)? (Choose two.) A. The RI is presumed to be enforced outside of the database. B. The RI is enforced by the database. C. The PK columns can appear anywhere in the WHERE clause. D. Redundant joins between soft RI defined tables are eliminated.

A,D

Which two of the following are advantages of session pools? (Choose two.) A. Logon times are typically 2-3 seconds faster. B. If all sessions are active, the next pool is used regardless of the logon string. C. They allow better tracking of when applications log on and log off. D. The number of sessions a user can log on is controlled.

A,D

Which two of the following statements concerning dynamic AMP Sampling are accurate? (Choose two) A. A random data block from a random cylinder is selected and the number of rows it contains are counted. B. The potential for error introduced from a large table is much higher than the estimates gained by the full-table statistics gathered using the Optimizer from of COLLECT STATISTICS. C. The Optimizer understands the reliability of the information it collects using a random AMP and it can be more aggressive in its pursuit of optimal access and join strategies. D. An AMP is selected to represent an estimation of population demographics.

A,D

Which two statements are true of a join back with a join index? (Choose two.) A. The join back to the base table does not count against the join maximum if a partial covering is in effect. B. The join index is joined to another join index before joining back to the base table. C. The join back to the base table happens only if the index is fully covered. D. The join index is joined back to the base table.

A,D

With reference to changing the default lock assignments using the locking modifier, which two statements are true? (Choose two) A. Any lock may be upgraded. B. A WRITE lock may be downgraded to a READ lock. C. Any lock may be downgraded D. A READ lock may be downgraded to an ACCESS lock.

A,D

You are a database administrator at Certkiller .comwho is using the Statistics Wizard. From which two of the following can you define a workload? (Choose two.) A. DBQL statements B. workload monitor C. TDQM statements D. statement text

A,D

Certkiller .com has a referential integrity constraint that exists between two tables. Because the referenced value is not in the parent table, the attempt to insert a row in the child table is unsuccessful. Which of the following are three corrective actions that you can take before you insert the row into the child table? (Choose three.) A. insert a row with the referenced value into the parent table B. alter the parent table to drop inconsistent references C. delete the referencing value D. change the referencing value to a value in the parent table E. change the referencing value to null

A,D,E

During application testing, which is useful information when determining resource impacts? (Choose three.) A. parallel efficiency at different time intervals B. user growth predictions C. errors occurring during data loading D. spool space peaks E. AMP utilization

A,D,E

Of the following options, which are the three that you would use to modify collection and logging rates for ResUsage in Teradata? (Choose three.) A. xctl B. ferret C. gdb D. Teradata Manager E. xdbw

A,D,E

The allocation of system CPU resources in a mixed workload environment can be improved by executing which three of the followingtasks? (Choose three.) A. use the MODIFY USER statement to change the ACCOUNT for a user B. modify the Default Resource Partition to a lower weight than other Resource Partitions C. use the MODIFY USER statement to give a user more spool space D. maintain development and test users in separate Allocation Groups E. define Allocation Groups for different times of the day

A,D,E

Views have which three of the following attributes? (Choose three.) A. Views can contain a WHERE clause. B. Views cannot be used to UPDATE a table. C. Views must change if columns are added to a table. D. Views are not affected if columns are added to a table. E. Views provide an additional level of security or authorization.

A,D,E

When you choose a primary index, what are three requirements that must be met? (Choose three.) A. volatility of data values B. must be primary key C. must ensure row uniqueness D. most frequently accessed column(s) E. reasonable distribution

A,D,E

Which are three accurate statements concerning aggregations in views? (Choose three) A. They simplify the maintenance of complicated calculations B. Alias names are not required in views with aggregates. C. They are affected if new columns are added to underlying tables. D. They are unaffected if new columns are added to underlying tables. E. They simplify end-user coding requirements

A,D,E

Which are three true statements regarding the implementation of the following macro? (Choose three.) USING (x INTEGER, y INTEGER, z INTEGER) EXEC Macro1(:x, :y, :z); A. No values are present for the Optimizer. B. It contains multiple statements. C. It should be demographically dependent. D. It will be cached immediately. E. It should be demographically independent.

A,D,E

Which three Teradata tools use the Query Capture Database (QCD)? (Choose three.) A. Teradata Statistics Wizard B. DBQL C. Teradata DQM D. Teradata Index Wizard E. Visual EXPLAIN

A,D,E

Decomposable data may be indicated by which two operators? (Choose two) A. LIKE B. EQUALS C. IN D. BETWEEN E. SUBSTRING

A,E

Of the following, which are two features that the Teradata Warehouse Builder Load Operator supports? (Choose two.) A. checkpoint restartable B. secondary index on target table C. referential integrity D. create table E. error limits

A,E

The same hash result is generated by which data types? (Choose two) A. INTEGER and DATE B. DATE and CHAR C. BYTE and NUMERIC D. CHAR and VARBYTE E. CHAR and VARCHAR

A,E

Which of the following are two types of journals that can be defined for a table? (Choose two.) A. Permanent LOCAL AFTER JOURNAL B. Permanent UPDATE ONLY JOURNAL C. Transient UPDATE ONLY JOURNAL D. Transient LOCAL AFTER JOURNAL E. Permanent DUAL BEFORE JOURNAL

A,E

Which two components do the rowid consist of? (Choose two) A. uniqueness value B. AMP number identification C. table number D. row number E. row hash

A,E

Which two statements referring to a dimensional data model are correct? (Choose two.) A. It often implements fewer tables. B. It is extremely flexible. C. It requires significantly less ETL activity. D. It reduces the need for summary tables. E. It can be adapted to optimize performance.

A,E

Of the following options,which three are initiated in the ELDM? (Choose three.) A. value access frequency B. column nullability C. foreign keys D. index selection E. maximum rows null F. join access rows

A,E,F

A RAID configuration for system availability has what advantage? A. If a node fails, the AMPs running on that node migrate to the other nodes in a different clique. B. If a single drive fails, work can proceed because the disk controller can reconstruct the data. C. If multiple drives fail in the same drive group, work can proceed using the redundant copies. D. A disk array cabinet failure does not interrupt operation since RAID forces redundancy across RAID cabinets.

B

All possible cylinders on the system can be retrieved using which operation? A. CYLPACK B. PACKDISK C. SHOWSPACE D. DEFRAG E. QRYCINFIG

B

An Exclusion Join is a result of which operation? A. NOT EXISTS B. NOT IN C. NOT EQUAL D. NOT BETWEEN

B

An allocation group has a scheduling policy of ABS and a group weight of 40%. What will happen if a user that belongs to this group, logs onto an idle system? A. The user's session will have access to more than 40% of the system if resources are available. B. The user's session will have access to no more than 40% of the system. C. The user's session will have access to no more than 60% of the system. D. The user's session will have access to its owner's partition weight %. E. The user's session will have access to more than 60% of the system if resources are available.

B

As part of an assignment for Certkiller .com, you run a query against a three year history table. SELECT * FROM Orders WHERE 0_orderdat BETWEEN ?003-07-01[] AND ?003-07-07? Which three statements regarding a NUSI on 0_orderdate are FALSE? A. Since a full table scan is required anyway, a NUSI will not improve performance B. A value-ordered NUSI should perform better than a hash-ordered NUSI. C. A hash-ordered NUSI should perform better than a value-ordered NUSI D. The value-ordered NUSI rows are stored in row hash order.

B

Before selecting the Primary Index, what do you need to know so that even distribution is ensured? A. number of rows in the table B. columns that define uniqueness C. data demographics of new data from load processes D. other tables that will be involved in a join

B

Certkiller .com's employee table contains only empno and name columns. Certkiller .com's department table contains only deptno and mgrno columns. Which query is responsible for producing the names of all employees who are department managers? A. SELECT name FROM employee WHERE mgrno IN (SELECT mgrno FROM department); B. SELECT name FROM employee WHERE empno IN (SELECT mgrno FROM department); C. SELECT name FROM employee WHERE name IN (SELECT mgrno FROM department); D. SELECT name FROM employee WHERE empno NOT IN (SELECT mgrno FROM department);

B

Certkiller .com'sdata warehouse environment has critical data that needs to be available 24 hours a day, 7 days a week. How can continual availability be ensured? A. archive data and keep a copy of the archived data offsite B. develop and implement a strategy for simultaneously or near simultaneous loading of critical data to an offsite dual system C. send archived data to the offsite system to be loaded on a regular basis D. keep a dual system offsite and restore the data as needed

B

Multiple sources of data arriving from multiple platforms concurrently, is supported by which utility? A. FastLoad B. Teradata Warehouse Builder C. BTEQ D. MultiLoad

B

Of the following features, which one allows multiple users to share the blocks that are read from a table? A. Redistribution Buffering B. SyncScan C. PreReads D. Access Locking

B

Of the following properties, which is a feature of a NUSI? A. physical grouping of related dat B. index row and table row on same AMP C. two-AMP operation D. two tables with the same index

B

Sessions are acquired in which MultiLoad stage? A. logon B. preliminary C. acquisition D. application

B

The best Teradata performance is provided by which configuration of disk arrays? A. RAID S B. RAID 1 C. RAID 5 D. RAID 0

B

What are you calculating when you analyze volatility as a factor for selecting indexes? A. how unique the column values are B. how frequently the column value changes C. the difference between the maximum and minimum values D. how frequently the column is used for access

B

What benefit does assigning account strings at the profile level have? A. enables you to grant privileges to a group of users based on their account string B. enables you to change all or part of the designation just once for many users C. enables you to save space by reducing the number of rows inserted into DBC.AccessRights D. enables you to save space by reducing the number of rows inserted into DBC.AMPUsage

B

What does the following phrase specify in the ARCHIVE and RESTORE commands? EXCLUDE <dbname1> TO <dbname2> A. a sequential group of database IDs B. a range of alphabetically sorted databases C. database descendants through ownership D. location of databases/users within the hierarchy

B

What is guaranteed by using pseudo table locks? A. Two users will not need to share virtual tables. B. Two users will not deadlock on a table level lock request. C. Two users will be able to have simultaneous and conflicting locks on a table. D. One user will be able to have locks on two tables simultaneously. E. Two users ill not get conflicting row locks on a table.

B

What is the correct formula for the number of bytes used by a table with Fallback, if you are given the b = block size c = table row count n = number of AMPs r = rows per block h = table header size A. 2*(r/c)*b + n*h B. 2*(c/r)*b + n*h C. (c/r)*b + n*h D. (r/c)*b + n*h

B

What type of query population is helped by a sparse index? A. queries that often redistribute a large table B. queries that repeatedly use the same subset of the table C. queries that often return a large percent of the rows of a large table based on the primary key D. queries that often eliminate a large percent of the rows of a large table using a superset of the table E. queries that rarely redistribute a large table in complex join processing

B

When can two or more SQL statements share spool files? A. when statements are within a stored procedure B. when statements are from the same request parcel. C. when spool is on the same node D. When statements are executed during the same session.

B

When migrating a Non-Partitioned Primary index table (NPPI) to a Partitioned Primary Index table (PPI), what added space per row is required? A. four bytes B. two bytes C. three bytes D. one byte

B

When the join condition is an inequality, which join type would you use? A. Nested Join B. Product Join C. Merge Join D. Hash Join

B

When you change password features such as expiration, reuse, minimum, and maximum length, what is updated? A. DBC.Users B. DBC.SysSecDefaults C. DBC.LogOnOff D. DBC.LogonRules

B

Which LOCKING modifier should you employ to avoid waiting on conflicting locks? A. UNLOCK ROW B. LOCKING ROW NOWAIT C. OVERRIDE CURRENT LOCK D. LOCKING ROW FOR EXCLUSIVE

B

Which is a facility that automatically manages system workflow by blocking queries that defy predefined rules from entering the system? A. ResUsage B. TDQM C. DBSControl D. Priority Scheduler

B

Which is an accurate statement with regard to two queries in deadlock for the same tables? A. A 'hung transaction' detection mechanism detects and aborts hung transactions. B. A detection mechanism will abort the youngest transaction. C. A transaction time-out mechanism aborts and restarts a transaction without notifying the user. D. A detection mechanism will abort the transaction that has completed the least work.

B

Which is the query tool that lets you access not only Teradata, but other databases as well? A. BTEQ B. Teradata SQL Assistant C. Teradata Manager D. TDQM

B

Which lock request is being executed in the following statement? LOCKING prod.table_a FOR WRITE SELECT * FROM prod.table_a WHERE UPIcolumn = 1; A. We lock prod.table_a for write on a Row-hash. B. We lock prod.table_a for write. C. We lock prod.table_a for read on a Row-hash. D. We lock prod.table_a for read.

B

Which of the followingis a characteristic of Permanent Journals? A. Permanent Journals allow you to create and store comments using the COMMENT ON statement. B. Permanent Journals (AFTER images) allow the user to recover changes lost when tables are restored. C. Permanent Journals may be used to roll back or roll forward changes after an ALTER TABLE operation. D. Permanent Journals (BEFORE and AFTER images) may be used to roll back or roll forward changes after a RENAME TABLE operation.

B

Which of the followingis a true statement on the subject of archiving tables with join indexes? A. The Teradata ARC utility is sufficient if the join indexes are archived at least on a weekly basis. B. Since the Teradata ARC utility cannot be used on a join index, you must archive the underlying tables and manually rebuild all the join indexes when you need to restore. C. The Teradata ARC utility is sufficient if the join indexes are archived as frequently as the data is changed. D. The Teradata ARC utility cannot be used on a join index itself but it automatically recreates and repopulates all the join indexes as long as you have saved the join index definitions within a Data Dictionary archive.

B

Which of the followingis an accurate statement when creating an identity column as GENERATED ALWAYS? A. The column may be updated by an SQL statement. B. The column may be used to define the primary index. C. The column is used to facilitate copying data from one table into another. D. The column may be used in a join index.

B

Which three statements are FALSE regarding USIs? A. They are always preferable to NUSIs. B. At worst case they result in a two-AMP operation At worst case they result in a two-AMP operation C. They cannot be created dynamically D. They allow a duplicate row to occur

B

Whichof the following may justify the use of the Fast Export and FastLoad utilities as a backup/recovery approach? A. 300 large volatile tables B. 20 small static tables C. 300 large static tables D. 20 small volatile tables

B

You are a database administrator at Certkiller .com. Certkiller .comhas an eight node Teradata system with DBC.CRASHDUMPS defined as FALLBACK. Assume that a 200 MB/node is required for one PDE dump. Youwant the CRASHDUMPS allocation, which is currently 1600 MB, to hold the recommended three PDE dumps. What must the total space allocation be for CRASHDUMPS, and what database does it come from? A. 600 MB from database DBC B. 4800 MB from database DBC C. 4800 MB from database ALL D. 600 MB from database ALL

B

Which is an accessible option with Global Temporary tables? A. Identity Column B. Collect Statistics C. Permanent Journaling D. Referential Constraints

B*

Of the following, which are three true statements regarding Teradata Statistic? (Choose three) A. Table statistics are refreshed automatically by Teradata B. Table statistics can be viewed using the STATS module of Teradata Manager C. User must have at least one appropriate privilege on the object to COLLECT STATISTICS D. Statistics can be collected on a global temporary table E. Statistics are eliminated when all rows from the table are deleted.

B, C, D

Which three of the following statements pertaining to multi-value compression are correct? (Choose three) A. NULLs must be the first value in a multivalue list. B. Values can appear in any order. C. NULL cannot appear in the list if the column is declared NOT NULL D. Maximum number of distinct constant values in the list is 255 plus nulls. E. A value list may contain duplicates

B, C, D

When you implement Referential Integrity, which two definitions are required on the referenced columns? (Choose two) A. Indexed B. Unique C. Nullable D. Not Null

B, D

Which of the following are two factual statements regarding parallel steps? (Choose two) A. They are seen in the creation of a spool file, which is subsequently used in more than one processing steps. B. They are steps whose output may be used in a later statement. C. They represent combined identical steps for two more SQL statements within the request parcel. D. They are sequentially numbered steps that may execute simultaneously.

B, D

Which of the following are two reasons why you would apply Referential integrity constraints? (Choose two) A. allows referencing values to exist without a corresponding referenced value B. ensures data integrity and consistency between Primary and Foreign key columns C. requires more application programming to enforce constraints D. provides the Optimizer with a mean for devising better query plans

B, D

A Partitioned Primary Index (PPI), NUSIs, and a USI is defined on Table X. which two of the followingcan you employ for daily maintenance? (Choose two.) A. MultiLoad B. TPump C. FastLoad into an empty Table Y, then INSERT/SELECT into Table X D. Teradata Warehouse Builder Load Operator

B,C

A table that has a join index can be updated using which two methods? (Choose two.) A. MultiLoad B. TPump C. FastLoad into an empty table and INSERT/SELECT into the target table D. Teradata Warehouse Builder Apply Operator

B,C

Column level security can be provided used which two? (Choose two.) A. sparse index B. view or macro C. access rights D. roles and profiles

B,C

In a CREATE TABLE statement, which are two options that overrides system level specifications for that tables? (Choose two) A. MAXCOLUMNS B. DATABLOCKSIZE C. FREESPACE D. COMPRESS E. ON COMMIT DELETE ROWS

B,C

The TSET utility serves which two purposes? (Choose two.) A. allows you to schedule statistics collection B. allows you to import data demographics from one system to another C. allows you to import system characteristics from one system to another D. allows for the importing of workloads from other Teradata utilities E. creates a view of your data demographics

B,C

What are two accurate statements concerning multiple value-list compression (VLC)? (Choose two) A. VLC reduces the table header size B. VLC improves response time for table scans. C. VLC reduce disk I/O time D. VLC decreases storage capacity

B,C

What are two cases in which an application can read a primary index value from a table that is being populated with an INSERT/SELECT? (Choose two.) A. anytime during the INSERT/SELECT B. after the INSERT/SELECT has finished loading all the data C. when the application can issue a LOCKING FOR ACCESS D. after the row-hash lock has been released

B,C

What are two purposes creating a view with aggregation? (Choose two.) A. to improve query performance B. to reduce query complexity C. to minimize summary table maintenance D. to minimize macro executions

B,C

When you plan the allocation of system resources in Priority Scheduler, which are two vital tasks? (Choose two.) A. calculating how many CPU cycles are available B. recognizing the goal of using Priority Scheduler C. gaining an understanding of the current workload D. defining at least four Resource Partitions for workload balance

B,C

Which are two accurate statements pertaining to rows per NUPI value? (Choose two.) A. All rows with the same NUPI value always end up in the same datablock. B. Adding a second column to the NUPI generally reduces the number of rows per primary index value. C. A SET table with many rows for each NUPI value has much worse insert performance than a MULTISET table with many rows for each NUPI value. D. A large table with fewer unique NUPI values than there are AMPs in the system can still have an even distribution.

B,C

Which are two features of the MultiLoad utility? (Choose two.) A. Up to ten tables can be specified in a single execution. B. The upsert function is supported. C. Insert, update, and delete are all supported. D. It uses macros to improve performance. E. The processing rate can be controlled.

B,C

Which are two tasks that you should execute prior to a Reconfig? (Choose two.) A. drop secondary indexes B. verify data integrity C. delete unneeded data D. reassign spool to Reconfig

B,C

Which of the following applies to Non-Partitioned Primary Index (NPPI) tables when determining the size of a row in Teradata? (Choose two.) A. two bytes for variable length accommodation B. eight bytes per row for the rowid C. two bytes per row for row length D. one byte per column for compression E. four bytes for the primary index

B,C

Which two are inaccurate statements about Permanent Journals? (Choose two.) A. They can store both before and after images (copies) of rows changed in one or more tables. B. They store an image of each table that has been altered using any DML statement. C. They store images (copies) of each table both before and, optionally, after they have been updated. D. They store images (copies) of each data row that has been changed with an insert, update or delete statement.

B,C

Which two of the following are advantages of Teradata Manager? (Choose two.) A. It accumulates large amounts of data over a long period. B. It provides session-level resource usage data. C. It acquires data in near real-time with less overhead. D. It provides data as detailed as ResUsage data.

B,C

Which two of the following are scheduling policies found in Priority Scheduler? (Choose two.) A. low B. absolute C. relative D. rush

B,C

Which two of the following statements are FALSE? (Choose two) A. New columns with multi-value compression can be added to a table. B. Primary index columns can be compressed C. ALTER TABLE supports compression on existing columns D. Only fixed width columns can be compressed.

B,C

Which two of the followingare activities that should be carried out subsequent to a Reconfig? (Choose two) A. reload data B. verify data integrity C. test existing applications D. initialize tables

B,C

Which two of the followingstatements are correct in relation to data marts? (Choose two.) A. Dependent data marts are isolated entities entirely separate from the enterprise data warehouse. B. A data mart is generally a relatively small application-specific subset of the data warehouse. C. A logical data mart is a form of dependent data mart that is constructed virtually from the physical data warehouse. D. Independent data marts are derived from the enterprise data warehouse.

B,C

Which two of the followingutilities can you used to update a table that has Referential Integrity, as well as enabled triggers? (Choose two.) A. FastLoad B. BTEQ C. TPump D. MultiLoad

B,C

You are a Teradata administrator at Certkiller .com.What are two questions you must consider when organizing the system into databases? (Choose two.) A. How frequently are the archives of the tables needed? B. Which views are needed to have extended privileges such as update and delete? C. Which views are needed to be used by the same users? D. Which users will be doing the FastLoads of multiple tables?

B,C

You are a database administrator at Certkiller .com, and have an active session with a query in progress with data already cached. When you disable logging to the Database Query Log (DBQL), what will happen? (Choose two.) A. Collected rows are deleted from disk. B. Subsequent queries during that session are not logged. C. Collected rows are committed immediately. D. Cache is not immediately flushed.

B,C

You are a database administrator at Certkiller .com.You are currently analyzing application performance using the Access Log. Of the followingoptions, which are two that you can capture? (Choose two.) A. embedded views B. start time C. SQL function D. CPU time E. disk I/O

B,C

A USI subtable row includes which three elements? (Choose three) A. subtable-id B. USI column value(s) C. Secondary index rowed D. Rowid of the base row E. UPI column value (S)

B,C,D

PP2 has whichthree of the following characteristics? (Choose three.) A. supports COBOL, PL/I, C, and Pascal B. uses indicator variables for NULL handling C. supports macros D. supports multiple sessions

B,C,D

Tactical queries have which three characteristics? (Choose three.) A. multiple tables scanned B. use direct access path C. highly tuned D. defined response time requirements

B,C,D

The Teradata Warehouse Builder DataConnector operator supports which three of the following functions? (Choose three.) A. preprocessing input data files B. writing data to external data files C. reading unspecified number of data files D. reading external data files

B,C,D

Volatile tables have whichthree features? (Choose three.) A. They are restricted to a single query statement. B. They require no Data Dictionary access or transaction locks. C. They are materialized in spool space. D. Their table definitions are kept in cache. E. They do not have to be explicitly created in the current session with DDL.

B,C,D

When defining an instance of Referential integrity on a Teradata table, which three of the following rules are relevant? (Choose three) A. The same column may appear more than once in the foreign key B. If no columns are specified for the referenced table then that table must have a single column primary key or a single column specified with the unique constraint. C. There is a limit of 16 columns in a single foreign key. D. References may be specified with a NO CHECK option E. The foreign key may reference columns in a global temporary table.

B,C,D

Which are three accurate statements regarding global temporary tables? (Choose three.) A. Global temporary tables require the user to have the necessary permanent space to store data when the table is materialized. B. Global temporary tables provide the user with a place to store interim results. C. Global temporary tables can reduce the number of times the user needs to create and drop tables. D. Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions

B,C,D

Which three factors are considered by the Optimizer to decide the least costly access method and join path? (Choose three.) A. Priority Scheduler settings B. index choices C. the column and index demographics D. row selection criteria E. the workload of the system

B,C,D

Which three of the following options will enhance overall job mix and throughput? (Choose three.) A. using the Priority Scheduler Administrator to set slow AMPs to a higher priority B. using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU C. maintaining development and testing users in a separate Allocation Group D. defining Allocation Groups for different times of the day E. changing the poorly performing queries to $R status

B,C,D

Which three statements are true if an EXPLAIN output contains one of the following phrases? (Choose three) "a single partition of" or "#partitions of" A. Indicates that the table is being accessed using a sparse index B. The query has a range constraint on the partitioning columns. C. Indicates AMPs will only access a single partition or #partitions of a table. D. The query has an equality constraint on the partitioning column.

B,C,D

Which three statements regarding the Extended Logical Data Model (ELDM) are correct? (Choose three.) A. It contains the business rules of the organization. B. It is the main source of information for creating the PDM. C. It maps applications and transactions to the related objects. D. It provides demographics of data distribution, sizing, and access.

B,C,D

Which three statements with reference to MultiLoad are true? (Choose three.) A. It maintains all secondary indexes. B. A maximum of five tables can be loaded at a time. C. Each import task can do multiple insert, update, and delete functions. D. It can load data using a view.

B,C,D

Whichof the following describes three Global Temporary table characteristics? (Choose three.) A. They can utilize permanent journaling. B. They are materialized in the login user's temporary space. C. They can be referenced from a macro. D. Their table definitions are stored in the Data Dictionary. E. They can be created using the WITH DATA option.

B,C,D

You are a database administrator at Certkiller .com, and have defined a user with no permanent space. Which are three objects that can be found in this user? (Choose three) A. tables B. triggers C. macros D. views

B,C,D

Teradata Dynamic Query Manager (TDQM) supports which three of the following activities? (Choose three.) A. limiting the number of reserved AMP Worker Tasks B. delaying query processing C. controlling access to database objects D. controlling access to host groups E. limiting types of joins

B,C,E

The Teradata Warehouse Builder has which three attributes? (Choose three.) A. Transient Journal compliant B. end to end parallelism C. scalable D. runs in interactive mode E. single scripting language

B,C,E

What is the purpose of a Bit Map Set Manipulation Step (BMSMS)? A. relocating data in preparation for an upcoming join step B. taking a single row of a table and using a secondary index value that hashes to the AMP on which the table row is stored C. handling weakly selective secondary indexes that have been ANDed D. combining rows under control of aUNION, EXCEPT, MINUS, or INTERSECT operator

B,C,E

Which of the following are three features of Volatile table? (Choose three) A. Definitions are stored in the data dictionary B. Rows are deleted at session end. C. Rows are lost following a system restart D. Temporary space is used to materialize the table. E. Spool space is used to materialize the table.

B,C,E

Which of the following are three useful demographics for index selection? (Choose three.) A. number of concurrent users B. join access frequency C. distinct values D. number of columns in a composite index E. value access frequency

B,C,E

Which three conditions have to exist so that an ORDER clause can ensure the appropriate sequencing of the triggered actions, when creating multiple triggers on the same table? (Choose three.) A. They must share the same trigger WHEN condition. B. They must have the same trigger action time. C. They must have the same trigger type. D. They must affect the same triggered columns. E. They must share the same trigger event.

B,C,E

Which three of the following privileges are automatically granted to User B on User B, after User A creates User B? (Choose three.) A. CREATE DATABASE B. RESTORE C. CREATE TABLE D. WITH GRANT OPTION E. DUMP

B,C,E

Which three statements with reference to the MultiLoad utility are true? (Choose three.) A. The Transient Journal is used to allow roll back. B. Multiple tables may be loaded in the same job. C. Target tables may have secondary indexes and referential integrity. D. Near real-time updates may be achieved. E. Duplicate rows are allowed

B,C,E

Within queries, which are three available join types? (Choose three.) A. Product B. Cross C. Self D. RowID E. Outer F. Hash G. Merge

B,C,E

You are a database administrator at Certkiller .com. You add a foreign key constraint to a column of a table. However, there are foreign key values in the child table that reference values not found in the parent table. What are three potential procedures for correcting each row in the error table? (Choose three.) A. add a row with the referenced value to the child table B. add a row with the referenced value to the parent table C. delete the row from the child table D. add a row with a null value to the parent table E. change the referencing value in the child table to null

B,C,E

A macro can be used to load data in which two of the following ways? (Choose two.) A. MultiLoad B. INSERT/SELECT C. FastLoad D. TPump

B,D

An empty target table is required by which two utilities when loading data? (Choose two.) A. FastExport B. FastLoad C. MultiLoad D. Teradata Warehouse Builder Load operator

B,D

Assume that table Big_T is a very large table, with hash distributed rows that are based on 16 unique values. Applications using Big_T operates well with high parallelism on a system with 1 or 2 nodes and 8 to 16 AMPs. Which two statements are true if the system is expanded to 8 nodes and 128 AMPs? (Choose two.) A. The rows of Big_T will be distributed across the AMPs equally and the application will perform much better. B. Applications accessing Big_T could perform much worse than before the system was upgraded. C. Applications accessing Big_T could be rewritten to utilize the new system configuration more efficiently. D. The rows of Big_T will still be distributed across 16 AMPs and applications will not perform any better.

B,D

Both FastLoad and the Teradata Warehouse Builder Load Operator support which two of the following Teradata features? (Choose two.) A. referential integrity B. partitioned primary indexes C. secondary indexes D. multi-value compression

B,D

For columns with which two characteristics should you consider the compression allowed in Teradata, when designing tables? (Choose two.) A. numeric columns with a large number of leading zeros B. columns with a large number of null occurrences C. variable length character columns with nulls D. columns with a large number of default occurrences

B,D

Of the following statements, which two are accurate for primary keys as compared to primary indexes? (Choose two.) A. The data values may change over time. B. They are logical constructs which ensure uniqueness. C. The first objective is to control row distribution. D. The data values may not be null.

B,D

What are the only two circumstances in which the Optimizer can select a Nested Join? (Choose two.) A. If there is an equality condition on a non-unique index of one table. B. If there is an equality condition on a unique index of one table. C. If there is a join on a column of the row specified by the first table to any column of the second table. D. If there is a join on a column of the row specified by the first table to any primary or secondary index of the second table.

B,D

Which are two accurate statements about TPump? (Choose two.) A. The larger the batch is, the faster the throughput is. B. It uses time-based checkpoints, rather than count-based. C. TPump cannot operate on tables with Referential Integrity specified. D. The processing rate can be modified.

B,D

Which two of the following are features of multi-statement requests? (Choose two.) A. can have multiple USING row descriptors per request B. are atomic C. can include a DDL statement D. improve system performance by reducing processing overhead

B,D

Which two of the following statements are true with reference to Teradata derived tables? (Choose two.) A. If users can create a derived table, they can also share it with other users. B. More than one derived table can be referenced in the same SQL statement. C. Derived tables can be referenced by multiple SQL statements in a multi-statement request. D. Derived tables can be used to compare an aggregated value from a table to the individual values from the rows of that table.

B,D

Which two of the following statements regarding nested views are true at query execution time? (Choose two) A. Nested views are not updatable B. Teradata validates nested view privileges of the executing user at execution time. C. If the view contains WITH CHECK OPTION, the WHERE clause used in defining the view is ignored. D. Maximum size of the fully expanded text is 2 MB

B,D

With regard to vproc migration during a node failure, which two statements are true? (Choose two) A. System performance remains constant B. Access to all data is maintained C. Access to some data is maintained D. System performance degradation is proportional to lique size

B,D

Consider the following: UPDATE employee SET salary_amount = salary_amount * 1.1 WHERE department_number = 403; Which three statements are true if the department_number column is not an index? (Choose three.) A. Write locks are applied on all updated rows. B. A pseudo lock is applied. C. Read locks are applied. D. Write locks will queue behind existing read locks. E. Write locks are applied at the table level.

B,D,E

When the ALL option is specified in the ARC utility, whichthree is archived? (Choose three.) A. all tables, views, macros, and stored procedures in the specified database's parent B. all column and index information in the specified database and its descendants C. all column and index information in the specified database and its parent D. all tables, views, macros, and stored procedures in the specified database'sdescendants E. all tables, view, macros, and stored procedures in the specified database

B,D,E

When writing update applications, which are three areas that should be taken into consideration? (Choose three.) A. number of mini-cylpacks performed B. processing window D. when users are accessing the data E. data timeliness requirements

B,D,E

Which of the following are three FastExport requirements? (Choose three.) A. OUTMOD B. END EXPORT C. NOTIFY D. SELECT E. LOGTABLE

B,D,E

Which of the following are three permitted SQL statements in a triggered statement? (Choose three.) A. COMMIT B. EXEC C. CREATE D. INSERT SELECT E. DELETE

B,D,E

Which of the following are three practical reasons for using a USI? (Choose three) A. to provide good distribution of base rows B. to provide an alternate path to the data C. to provide an additional Optimizer option for Merge Join planning D. to provide a option for avoiding full table scans E. to provide a uniqueness constraint to a column

B,D,E

Which three of the following are applicable for the ALTER TABLE command? (Choose three) A. ADD compression to an existing column B. MODIFY CONSTRAINT for a named CHECK constraint C. ADD a compressible value to a column with multi-value compression D. ADD a new column with multi-value compression E. ADD columns up to 2048 columns

B,D,E

Which three of the following statements are FALSE? (Choose three.) A. An outer join requires an ON clause. B. A cross join requires a WHERE clause. C. An ON clause cannot be specified for a cross join. D. A WHERE clause cannot be specified with a cross join. E. An implicit join is a sequence of table references enclosed in parentheses. F. For an implicit join, the join condition, if any, is specified in the WHERE clause.

B,D,E

Which three of the following statements are true in relation to view definitions? (Choose three.) A. You can create an index on a view. B. You can use derived tables within a view. C. You can use an ORDER BY within a view. D. You can perform aggregations within a view. E. You can assign new column names within a view.

B,D,E

Which three of the followingare software components that run on a Teradata network-attached client? (Choose three.) A. BYNET B. MOSI C. TDP D. MTDP E. CLI

B,D,E

Which four of the following would justify the use of a macro? (Choose four.) A. to pass a table name dynamically as a parameter B. to enforce locking choices C. to create several secondary indexes on a table D. to ensure consistency of SQL code E. to reduce parsing overhead F. to limit access to data

B,D,E,F

What are two data demographics that should be considered in the design of a Teradata table? (Choose two.) A. nulls per row B. nulls per column C. numeric columns per row D. number of character columns per row E. rows per value in a column

B,E

Which of the following two options will allow the user to avoid waiting for a write lock currently on a table? (Choose two) A. LOCKING table 1 FOR SHARE B. LOCKING ROW FOR ACCESS C. LOCKING table 1 FOR READ D. LOCKING ROW FOR WRITE E. LOCKING table 1 FOR ACCESS

B,E

Which two of the following are features of an aggregate join index? (Choose two.) A. can be created using a Global Temporary table B. automatically reflects changes in the underlying detail data C. must contain more than one table reference D. can be directly referenced by a query E. COUNT is automatically present if SUM is used

B,E

Which two of the followingare features of the SyncScan operation in Teradata? (Choose two.) A. allows users to control which AMPs are to be processed first during a retrieval operation B. is enabled by the memory allocation specified in the DBSControl utility C. allows the system to reduce the processing speed of inserts into tables D. is especially powerful for transaction processing applications E. allows more than one user to share read buffers for a table

B,E

You are a database administrator at Certkiller .com. Certkiller .com has User A running a complex join with $L priority in the DEFAULT partition. You use Teradata Manager to alter the priority of the user's query to $R. this change has which two effects on the jobs currently running on a busy system? (Choose two). A. The other users' jobs are not affected. B. The other users' jobs experience performance degradation. C. The other users' jobs experience a performance improvement. D. User A's job will experience performance degradation. E. User A's job will experience a performance improvement.

B,E

"Only 12 sessions can be logged on for a userid" is what kind of Teradata Dynamic Query Manager (TDQM) rule? A. query resource B. query access C. workload D. object access

C

Consider the following SQL statement: SELECT cust_name, cust_addr, SAMPLEID FROM customer_table SAMPLE WHEN state = 'CA' THEN .25, .20 ELSE .25, .35 Assuming that there are 10 rows from every state in customertable, how many distinct SAMPLEID values would you find in the answer set? A. 1 B. 2 C. 4 D. None are found. The query results in an error because the sample percentages add to greater than 1.

C

DISTINCT applies to which column(s) in the following query? SELECT DISTINCT dept_num, job_code FROM employee A. job_code B. dept_num C. dept_num and job_code D. It does not apply to either column as the query needs parentheses.

C

How would you define a transaction? A. a logon, submittal of work, and logoff B. a single SQL statement C. a logical unit or work D. a single SQL, statement and the unit of recovery

C

I/O and CPU usage at the user level can be determined using which view? A. ResCPUUsageByAMPView B. ResIOView C. AMPUsage D. ResNode

C

If a NUPI is included in a Partitioned Primary Index (PPI) table, how can you determine the number of hash collisions? A. with the SQL HASHCOL function B. with the SQL HASHBUCKET function C. with the SQL HASHROW function D. with the SQL HASHAMP function

C

If no value is specified in the user's profile parameter or the CREATE USER statement, what default value is assigned as the user's default database? A. a NULL value B. the default database of the user's parent C. the user's username D. database DBC

C

If you assume that the required information has been collected, when is NUSI bit mapping utilized? A. when the query ANDs two more indexes with the bit mapping option B. when at least one of the NUSI is null C. when two or more weakly selective indexed conditions are ANDed and the combination is strongly selective D. when two or more weakly selective indexed conditions are Ored and the combination is strongly selective

C

In which circumstance will the Reconfiguration utility abort? A. when the database restarts B. when the Database Window shuts down C. when the system does not have sufficient storage capacity D. when the hash maps are incorrectly calculated

C

In which stage of modeling is denormalization done? A. dimensional B. logical C. physical D. extended logical

C

Information on the amount of permanent disk space currently in use at the table level is provided by which system view? A. DBC.SysInfo B. DBC.Tables C. DBC.TableSize D. DBC.DiskSpace

C

Logons to the RDBMS via the gateway is enabled by which of the following? A. RUN GTW B. START SESSIONS C. ENABLE LOGONS D. ENABLE GTW

C

Of the following, which join strategy is considered a special type of Nested Join? A. Correlated Join B. Hash Join C. RowID Join D. Inclusion Join

C

On which type of table may compression be specified for the columns? A. global temporary B. derived C. multiset D. volatile

C

The Recovery Manager utility has the ability to display which locking information? A. HUT locks B. tables locked by in-flight transactions C. locks currently held by online transaction recovery D. locks blocking other sessions

C

The cost of upgrading a system is least likely to be substantiated by which kind of processing workload? A. executive report B. daily sales report C. quarter end report D. nightly batch process

C

The following represents a query you are running against a three year history table: SELECT *from orders WHERE o_orderdate BETWEEN ?003-07-01- AND ?003-07-07? Which statement regarding a NUSI on o_orderdate is true? A. The value-ordered NUSI rows are stored in row hash order. B. A hash-ordered NUSI should perform better than a value -ordered NUSI C. A value- ordered NUSI should perform better than a hash-ordered NUSI. D. Since a full table scan is required anyway a NUSI will not improve performance

C

The sharing of data across user sessions is allows by what kind of table? A. global temporary B. volatile C. permanent D. derived

C

To avoid data conversion, what should you do? A. Use secondary indexes to provide another path to the data type B. Use character data types as often as possible to allow for ease of conversion when necessary C. Administer data type assignments at the domain level D. Use byte data types whenever possible

C

To upgrade a table read lock to an exclusive lock, which privilege is needed? A. RESTORE table B. CREATE table C. DROP table D. UPDATE table

C

What can a referencing column not reference? A. Column defined with the unique and not null constraints B. Unique secondary index defined with not null C. NUPI defined with not null D. primary key

C

What curtails row redistributions when a table has a multi-column (composite) primary key? A. Using an identify column to ensure that the rows are evenly distributed B. Avoiding creating secondary indexes on any column other than the columns included in the primary key. C. defining a NUPI over the columns most frequently joined. D. Defining a UPI over the primary key columns to get better row distribution

C

What is the result of another user trying to log on when a host group has exceeded its session limit? A. The user's connection is refused and the user does not receive an error message. B. The user receives an error message and is logged on to the next host group. C. The user's connection is refused and the user receives an error message. D. The user does not receive an error message and is logged on to the next hostgroup.

C

What is verified by the system when a row is inserted into a referencing table and foreign key columns are defined to be NOT NULL? A. It verifies if a row exists in the referenced table with the same values as those in the primary key of the referencing table. B. It verifies if a row exists in the referenced table that is NOT NULL. C. It verifies if a row exists in the referenced table with the same value(s) as that in the foreign key column(s). D. It verifies if a row exists in the reference index subtable with a zero count.

C

What reason describes why Hash joins generally operate better than Merge Joins? A. because the small table is always cached B. because the large table may be cached C. because the large table does not need to be sorted D. because neither table needs to be sorted

C

What redistribution action is necessary to prepare for a Merge or Exclusion Merge Join, when both join columns is not a primary index, and the join condition operator is either equal ( = ) or not equal ( < >)? A. All rows from both tables must be re-hashed, redistributed/duplicated, and sorted B. All rows from both tables must be stored and joined locally C. Qualified rows from both tables must be re-hashed, redistributed/duplicated, and sorted D. Qualified rows from one table must be re-hashed redistributed/duplicated and sorted

C

What would be an alternative archive method for a table that takes too long to execute a full archive? A. BTEQ Export B. use FastExport to unload the data and FastLoad to reload the data C. cluster data table archive with a full archive of the Data Dictionary D. cluster data table archive

C

When is a fully covering join index advantageous to a query? A. when the base table is small enough to fit in cache B. when there is an unpredictable selection of columns from the base table C. when relatively few columns are in the result and join or selection criteria includes values other than the base tables' primary index(es) D. when the result set is produced through either join or selection criteria on the base tables' primary index(es)

C

Which compression method does Teradata use? A. Cylinder level B. Block level C. Field level D. Row level

C

Which is an accurate statement pertaining to Performance Periods in Priority Scheduler? A. There are five types of Performance Periods allowed: Time, Session, Period, Query, and Cycle. B. A Performance Period is assigned to only one Performance Group. C. Performance Periods allow for users assigned to one performance group to be automatically shifted into a different Allocation Group. D. Performance Periods allow for a DBA to be notified that a user is using more system resources than planned.

C

Which statement is true if the following phrase is included in an EXPLAIN output? "Aggregate Intermediate Results are computed globally" A. Aggregation results are placed in a global temporary table B. Aggregation requires no redistribution phase. C. Both local and global aggregation phases are required. D. Aggregation requires a global spool file.

C

Which the system view you would use to monitor failed logon attempts? A. DBC.LogOnInfo B. DBC.SessionInfo C. DBC.LogOnOff D. DBC.AccLog

C

Which two of the followingare features of highly non-unique primary index values? (Choose two.) A. maximize parallel processing B. cause multiple data blocks to be used and incur multiple I/Os C. cause efficient distribution among AMPs D. cause database full condition on AMPs where excessive number of rows are stored

C

While a user holds a READ lock on a Table, a second user requires a WRITE lock on the same table and is waiting for the first user to finish. What will happen if a third user requests an ACCESS lock on the same table? A. A SHARE lock is granted and the request proceeds. B. A READ lock is granted and the request proceeds. C. An ACCESS lock is granted and the request proceeds. D. The third user's request is queued behind the WRITE lock request.

C

With which DDL clause is soft referential integrity defined? A. REFERENCES WITHOUT CHECK OPTION B. REFERENCES WITH CHECK OPTION C. REFERENCES WITH NO CHECK OPTION D. REFERENCES WITH SOFT CHECK OPTION

C

You are a Certkiller .com administrator in a multi-user environment with update activity. Which lock would you recommend for SELECT queries to make sure that you are working with current, consistent data? A. write B. access C. read D. exclusive

C

You are a database administrator at Certkiller .com. Certkiller .com'sPermanent space on a Teradata machine is being used up rapidly. You want to make sure that there will be enough spool space in the system to satisfy all queries. What should you do to meet these requirements? A. give each user a spool size equal to the sum of the sizes of the tables that the user can access, the system managing the rest B. take all available space and divide by the number of users in the system and give this amount to each user as spool space C. create a database equal to at least twenty percent of the total user space to reserve for spool usage D. create a database called Spool_Space with all currently available space assigned to it

C

You are allows to archive secondary indexes with which type of archive? A. single-AMP archive B. index archive C. all-AMP archive D. single cluster archive

C

You are creating an application to export some date values, and want to override the current default date form of INTEGERDATE with the following statement: SET SESSION DATEFORM=ANSIDATE; Which of the following is a true statement? A. Date values will continue to be returned in INTEGER form. B. Date values will be returned in CHAR(8) form. C. Date values will be returned in CHAR(10) form. D. The statement is syntactically incorrect as written.

C

Which of the following are two goals of the hashing algorithm? (Choose two) A. to produce a unique rowed B. to compute a variable row hash depending on the input column value. C. to produce random and consistent row hash values D. to compute a 32 bit row hash E. to produce random and unique row hash values

C, D

Adding columns to an index has which two effects? (Choose two.) A. The index selectivity does not change. B. Usually there will be more base table rows per index entry. C. Usually there will be fewer base table rows per index entry. D. SQL not referencing the added columns will not use the index.

C,D

For software fault tolerance, which are two vital Teradata RDBMS facilities? (Choose two.) A. Checktable Utility B. dual buffering C. vproc migration D. Fallback tables

C,D

Give two reasons for selecting different columns, which are defined for the Primary Key, for the Primary Index? (Choose two) A. even data distribution B. to enforce uniqueness C. known access paths D. join performance

C,D

Join steps can potentially be eliminated by which two features? (Choose two) A. single table join index B. matching primary index columns on the join conditions C. multi-table join index D. "soft" Referential integrity (RI) constraints

C,D

Merge Joins are best described by which two requirements? (Choose two) A. Join condition values are not required to eliminate hash collisions B. A complete copy of the smaller table must be duplicated on every AMP. C. There is a join constraint of either EQUAL (=) or NOT EQUAL ( < > ) D. Both tables are sorted by row hash or by rowkey

C,D

Permanent space limits can be assigned at which two of the followinglevels? (Choose two.) A. system B. table C. user D. database

C,D

The allocation of which two resources is controlled by weights and scheduling policies within Priority Scheduler? (Choose two.) A. perm space B. sessions C. I/O D. CPU E. spool space

C,D

The difference between the COPY and RESTORE operations of the ARC utility is best described by which two of the followingstatements? (Choose two.) A. A RESTORE operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database. B. A COPY operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored. C. A COPY operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database. D. A RESTORE operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored.

C,D

The implementation of Referential Integrity constraints can be justified by which two reasons? (Choose two) A. requires more application programming to enforce constraints B. allows referencing values to exist without a corresponding referenced value. C. Ensure data integrity and consistency between Primary and Foreign key columns D. provides the Optimizer with a means for devising better query plans

C,D

What are two ways of adding new rows to an existing table that has a Referential Integrity constraint? (Choose two.) A. use MultiLoad if the table contains the primary key not the foreign key B. insert the new rows with FastLoad C. use TPump to insert the new rows D. drop the Referential Integrity constraint and MultiLoad the new rows

C,D

When creating profiles on the Teradata Database, whichof the followingare two concerns? (Choose two.) A. Which users will need to create tables and which will not? B. Which databases are to be accessed at the same time? C. Which users will need the same priorities? D. Which users will need approximately the same amount of spool?

C,D

Which are two accessible logging options for database query logging in DBQL? (Choose two.) A. Performance logging B. Exception logging C. Threshold logging D. Summary logging

C,D

Which are two true statements with reference to FastLoad? (Choose two.) A. When an error occurs, locks are dropped with no ill effect. B. It can load up to five empty tables. C. Number of sessions are defaulted to one session per AMP. D. It can load data from tape files on a channel-attached client system.

C,D

Which of the followingare compatible types of Teradata locks? (Choose two.) A. a write lock and a write lock B. a read lock and a read lock C. a read lock and a write lock D. a write lock and an access lock

C,D

Which two expressions may be used to define Partitions in the CREATE TABLE statement? (Choose two) A. CAS and RANGE expressions B. ALWAYS and AS DEFAULT expression C. CASE_N and RANGE_N expressions D. PARTITION BY expressions

C,D

Which two factors is the Optimizer allowed to predict because of collected statistics on a Teradata table? (Choose two) A. the AMP to send data to B. the PE that will be assigned to the process C. the number of occurrences of a value D. the size of spool files

C,D

Which two of the followingstatements concerning Disaster Recovery (DR) plans are true? (Choose two.) A. Data recovery plans may be built without linking data objects to business processes and priorities. B. Standardized DR plans can be used to cover most business situations. C. A DR plan should be tested regularly. D. A well defined DR plan develops and documents details unique to your business needs and recovery strategy.

C,D

Which two statements regarding Permanent Journals are true? (Choose two.) A. The space used by the Permanent Journal is limited by the spool space limit of the Database or User where they are defined. B. They provide an alternative for Fallback and RAID without using as much real disk space. C. Permanent Journal images are placed on the Primary AMP, a Backup AMP, and/or a Fallback AMP depending on the type of journal specified and on the protection type of the journaled table. D. If a Permanent journal is defined on a Fallback table, the journal rows will be Fallback protected.

C,D

You are a database administrator at Certkiller .com. Certkiller .com Users are complaining about poor system response time. You discover a query that is consuming a large amount of CPU, and subsequently run an EXPLAIN on it. Which of the following are two steps in the EXPLAIN that could detect the root of this problem? (Choose two), A. duplication of a small table across all AMPs B. a Merge Join of two large tables C. a (1=1) product join of two large tables D. redistribution of a large table across all AMPs E. a Merge Join of a small table to a large table

C,D

You are a database administrator at Certkiller .com.When determining the workload rules for TDQM, which of the followingare two sets of information provided by Teradata tools that you could use? (Choose two.) A. the RDBMS Setup report from Teradata Manager B. the DBSControl Utility - Performance Settings C. objects accessed by users in DBQL reports D. Logon / Off usage reports from Teradata Manager

C,D

You must decide whether to calculate or store stand-alone derived data, whenever you have it. Which of the following are two demographics you should base your decision on? (Choose two) A. number of sources involved B. access column C. column data value volatility D. access frequency

C,D

An authorized user is allowed to do whichof the followingby the Performance Monitor? (Choose three.) A. purge ResUsage tables B. reset peak utilization values C. identify a blocked user D. set ResUsage rates E. abort user sessions

C,D,E

How can improve a query's performance without restarting Teradata? (Choose three.) A. By modifying the user's account to increase the spool space of the user B. By increasing the number of cylinder slots in FSG Cache C. By modifying the weights assigned to the user's Resource Partition D. By modifying the weights assigned to the user's Allocation Group E. By changing the priority of the user's session which is running slow

C,D,E

In decision support data warehouse environments, what are three necessary types of processing? (Choose three) A. continuous update B. event-based triggering C. analytical modeling D. pre-defined reports E. ad hoc queries

C,D,E

The Optimizer would choose a Product Join in which three circumstances? (Choose three.) A. when the workload of the system is skewed B. when there are no statistics available to quantify the demographics of a column or index C. when the join conditions are ORed D. when it is less costly than other join forms E. when the join condition is not based on equality

C,D,E

Which are three accurate statements about the TPump utility? (Choose three.) A. It provides an alternative to MultiLoad for the high volume batch maintenance of large databases. B. Data is loaded using stored procedures. C. Target tables may have secondary indexes and referential integrity constraints. D. SQL operations may be performed on multiple tables simultaneously. E. Near real-time updates may be achieved.

C,D,E

Which of the following are three tools and utilities that is part of the Teradata Analyst suite? (Choose three) A. Priority Scheduler Facility B. Teradata Dynamic Query Manager C. Teradata index Wizard D. Query Capture Database E. Teradata System Emulation Tool

C,D,E

Which three extremely effective join plans is the Optimizer allowed to choose as a result of joining tables on their primary index? (Choose three.) A. Product Join B. Cross Join C. Merge Join D. Hash Join E. Nested Join

C,D,E

You can control which three of the followingactivities using Teradata Manager profiles? (Choose three.) A. the number of concurrent users B. the Data Dictionary tables available to the user C. the ability to change a profile D. the functions available through drop-down menus E. the start time for auto-start applications

C,D,E

An inappropriate job mix can be identified with the use of which two tools? (Choose two.) A. ferret B. filer C. Locking Logger D. DBSControl E. Performance Monitor

C,E

Overall system performance can be improved by employing which three characteristics? (Choose three.) A. Permanent Journals B. Transient Journals C. Priority Scheduler D. triggers E. macros F. NUSI

C,E,F

Which three of the following should you when predicting space growth for a particular database? (Choose three.) A. expansion of hardware for the system B. number of new users to be added C. new tables added for new applications D. spool space required for new applications E. rows deleted from the existing tables F. incorporating multi-value compression on existing tables

C,E,F

A join index has been created to optimize access to frequently used tables. For daily updates on these tables, MultiLoad is employed. What group of tasks can you execute to update these tables now? A. modify the MultiLoad script to include the join index B. use the Teradata Warehouse Builder Apply Operator instead of MultiLoad C. run the MultiLoad script unchanged (The join index will automatically be updated.) D. drop the join index; run the MultiLoad script; recreate the join index

D

A join index would be added to a set of tables for what reason? A. to enforce Referential Integrity across tables B. to ensure same distribution of both tables C. to enforce data uniqueness D. to decrease response time on well known queries

D

After considering the following set of SQL statements, which statement would you judge to be true? CREATE SET TABLE t1 (a INTEGER, b INTEGER) PRIMARY INDEX (a) INSERT INTO t1 VALUES (1,1) INSERT INTO t1 VALUES (1,2) UPDATE t1 SET b = b + 1 WHERE b = 1 A. The INSERTs and the UPDATE succeed. B. The second INSERT fails because it would create a duplicate primary index value. C. The INSERTs succeeds but the UPDATE fails because the syntax is incorrect. D. The INSERTs succeeds but the UPDATE fails because it would create a duplicate row.

D

An example of what kind of parallelism is it when you prepare two tables for a join simultaneously? A. multi-session B. multi-AMP C. multi-statement D. multi-step E. multi-threading

D

Certkiller .com's employee table contains emp_no, emp_name, and dept_no. Certkiller .com's department table contains dept_no and dept_name . Which query is responsible for returning the employees who work in the Finance Department? A. SELECT emp_name FROM employee WHERE dept_name LIKE '%Finance%'; B. SELECT emp_name FROM employee WHERE dep_tno IN (SELECT e.dep_tno FROM employee e WHERE dept_name LIKE '%Finance%'); C. SELECT emp_name FROM department WHERE dept_name LIKE '%Finance%' and dept_no IN (SELECT e.deptno FROM employee e); D. SELECT emp_name FROM employee WHERE dep_tno IN (SELECT d.dept_no FROM department d WHERE dept_name LIKE '%Finance%');

D

For what reason would two physical LAN connections per node be connected to Certkiller .com's network? A. so two session connections can be made concurrently B. so one can accept requests and the other can return responses C. to double the request speed D. for redundancy

D

In which kind of join strategy is AMP memory required to hold the small table? A. Merge Join B. Product Join C. Exclusion Join D. Row-hash Join

D

In which of the following situations should you consider using value-ordered NUSIs? A. when you have a high number of concurrent queries B. when you have a high number of updated rows C. when you have a high number of joins in queries D. when you have a high number of range constraint queries

D

In which way is data distributed with a Partitioned Primary Index A. It is based on the Secondary Index B. It is based on the Primary key of the table C. It is on the partitioning column. D. It is based on the Primary Index of the table

D

In which way is data protected by RAID 1? A. It uses parity to reconstruct the data on a failed AMP. B. It uses parity to reconstruct the data on a failed drive. C. with pairs of AMPs containing mirrored data D. with pairs of drives containing mirrored data

D

Of the following, which is a business example that is considered OLTP? A. Determining the interest rate for a loan, based on credit rating and current assets B. Query of retailer database to determine monthly sales of shoes C. capacity planning for the RDBMS D. ATM money withdrawal from a bank.

D

Pseudo table lock is designed to enable_________ . A. locking of the virtual tables accessed by the user B. locking of the global temporary tables C. reserving of a volatile temporary table D. sequenced locking of a resource

D

Setting the FreeSpacePercent parameter of the DBSControl utility to 15% has what effect? A. Table blocks are written with 15% of the space left in the block for more rows to be inserted. B. Each user is limited to 15% of memory for their active work space. C. Spool files are not created when there is less than 15% free space on an AMP. D. Cylinders are loaded to 85% of their capacity during load operations.

D

The Fallback rows for AMP 0 are stored in which location? A. on PEs in the same clique as AMP 0 B. on other AMPs in the same clique as AMP 0 C. on PEs in the same cluster as AMP 0 D. on other AMPs in the same cluster as AMP 0 E. on all other AMPs in the system

D

The maximum size of a datablock in a table is controls by which DBSControl parameter? A. PermDBAllocUnit B. DBSize C. MaxDBSize D. PermDBSize

D

To determine the optimal set of secondary indexes on a given workload, a "what-if" analysis is performed using which Teradata Analyst tool? A. Teradata Statistics Wizard B. Teradata Visual Explain C. Teradata System Emulation Tool D. Teradata Index Wizard

D

What advantage does using the WITH NO CHECK OPTION instead of the WITH CHECK OPTION have? A. No unique index is required on the referenced column list. B. Join elimination is possible. C. There is no extra cost for deleting rows from the referenced table. D. There is no extra cost for inserting rows into the referencing table.

D

What can a logical data mart be defined as? A. a physical part of the operational data stores B. a separate structure of the data warehouse C. a data load from a data warehouse D. an existing part of the data warehouse

D

What can you obtain as a result of the following SQL statement? SELECT employee_number, department_number, salary_amount FROM personnel WITH SUM(salary_amount) ORDER BY department_number; A. total salaries for each department B. no details, just a total of all salaries C. a list of employee salaries with totals by department D. a list of employee salaries with a grand total of all salaries

D

What is indicated by BMSMS (Bit Map Set Manipulation Step) in the EXPLAIN output? A. Rows are selected based on manipulating the unique secondary index bit map. B. The rows in the spool file are manipulated by hash code using a uniqueness sort to eliminate duplicate rows. C. The data row associated with the rowed is accessed only if the associated bit is turned on in the static bit map. D. Two or more NUSIs are intersected by ANDing them to form one large bit map.

D

What will happen when a foreign key constraint is created on a populated table? A. Any foreign key violations are deleted from the table. B. Existing rows are not checked for violations. C. An error is returned when creating a foreign key constraint on a populated table. D. Any foreign key violations are copied to an error table.

D

When is NUSI bit mapping used, if you assume that the necessary statistics have been collected? A. when at least one of the NUSI is NULL B. when the query ANDs two more indexes with the bit mapping option C. when two or more weakly selective indexed conditions are ORed and the combination is strongly selective D. when two or more weakly selective indexed conditions are ANDed and the combination is strongly selective

D

When the join constraints are ORed, which join method will probably be used? A. Exclusion Merge Join B. Inclusion Merge Join C. Inclusion Hash Join D. Product Join

D

When utilizing a Unique Secondary index, how many AMP (s) are usually accessed? A. all-AMP B. one-AMP C. multi-AMP D. two-AMP

D

Whether parallel steps have been generated in an EXPLAIN output is defines by which of the following? A. the phrase "we execute parallel steps on each AMP" B. the phrase "we execute the following steps as an all-AMPs RETRIEVE" C. the phrase "we execute the following steps in unison" D. the phrase "we execute the following steps in parallel"

D

Which formula is appropriate for calculating the base table size with Fallback? A. (Number of blocks*Typical block size) - (Number of header bytes*2) B. (Number of blocks*Typical block size) + (Number of header bytes*2) C. 2(Number of blocks*Typical block size) - Number of header bytes D. 2(Number of blocks*Typical block size) + Number of header bytes

D

Which index type is a Partitioned Primary Index a substitute for? A. MULTI-TABLE JOIN INDEX B. UNIQU PRIMARY INDEX C. NON-UNIQUE PRIMARY INDEX D. VALUE-ORDERED SECONDARY INDEX

D

Which is a statement that is true with regards to the TDP command SET MAXSESS? A. It changes the maximum number of sessions supported by the Teradata server. B. A change to MAXSESS only takes effect at TDP startup. C. The allowable values must equal a multiple of the PE session limit. D. The number of sessions is constrained for the TDP.

D

Which is an applicable statement regarding applications written for Teradata? A. The applications should use the Optimizer to resolve rules-based calculations. B. The applications should minimize the use of extensions to ANSI SQL. C. The applications should be written to use multiple instances of the program running in parallel. D. The applications should use set manipulation to leverage parallelism.

D

Which is the Teradata Warehouse Builder consumer operator that employs multiple sessions to execute DML transactions against Teradata tables in near real-time mode? A. DataConnector B. Update C. Load D. Stream

D

Which join method DOES NOT require all AMPs? A. Hash Joins B. Product Joins C. Merge Joins D. Nested Joins

D

Which of the following is a feature of a cylinder split? A. The data blocks in a cylinder are split to defragment the space. B. Data blocks are moved from a full cylinder to an empty cylinder on a different AMP. C. A new cylinder is divided into two and one half is put in overflow D. Data blocks are moved from a full cylinder to an empty cylinder on the same AMP.

D

Which of the followingis a true statement regarding row inserts into a table with an identity column? A. Generated numbers reflect row insertion sequence. B. Values will be unique if the GENERATED BY DEFAULT option is used. C. Serialization is guaranteed. D. Numbering gaps can occur.

D

Which table type would recommended for users who need to share a table definition, but not the data? A. Volatile B. Derived C. Permanent D. Global Temporary

D

Which type of database object is affects affected by the DBSControl parameter PPICacheThrP? A. global temporary tables B. temporary tables C. partitioned databases D. partitioned tables E. cached tables

D

Whichof the following describes the Teradata Visual Explain utility input? A. Query Capture Table (QCT) B. Visual Explain Database (VED) C. Visual Explain Table (VET) D. Query Capture Database (QCD)

D

With which kind of archived table are the ROLLBACK and ROLLFORWARD statements used? A. index subtables B. Transient Journal tables C. dictionary tables D. Permanent Journal tables

D

You are an administrator at Certkiller .com. Certkiller .com'sapplication finds the Partitioned Primary Index to be valuable for avoiding scans on large tables, and it has also established that primary index access (without specifying the partition key) takes significantly longer. Which of the followingis an option that will improve this? A. COLLECT STATISTICS on the partitioning column B. create a non-unique secondary index on the partitioning key C. COLLECT STATISTICS on the primary index columns individually D. create a unique secondary index on the columns of the primary index

D

Which two of the following statements concerning correlated subqueries are accurate? (Choose two.) A. They require temporary table space. B. They require special access rights to create. C. They always join a table to a subset of the same table. D. They allow the user to process data from the same table twice within the query. E. They are one method for locating a maximum or minimum occurrence within groups.

D, E

When the join calls for a Merge Join by matching two non-indexed columns from two tables, which are the two distribution strategies that the Optimizer might possibly chose? (Choose two.) A. choose the smaller spool file and duplicate it on all AMPs, leaving the other table in place B. join by accessing the table rows without redistribution C. send all rows of the smaller table to a single AMP for processing and locally copy the larger table into a spool file on each AMP D. choose the smaller spool file, duplicate it on all AMPs, and locally copy the other table into a spool file to be prepared for the join E. redistribute one or both tables by the column that is the join constraint

D,E

At which stage would you first decide to take full advantage of Teradata parallelism? A. design of the LDM B. design of the application code C. design of the ELDM D. design of the OLAP E. design of the PDM

E

If "by way of a Row-hash match scan" is stated in the EXPLAIN text, which kind of join will Teradata perform? A. rowID B. inner C. outer D. hash E. merge

E

If you consider the following table definition and query, which type of data comparison and index use occurs? CREATE TABLE TCPP.test ( C1 char( 10 ) ) UNIQUE PRIMARY INDEX (c1); SELECT *FROM TCPPtest WHERE c1 =3; A. C1 is converted to a numeric value and compared to the numeric value using the UPI B. C1 is compared to the character literal using the UPI. C. c1 is compared to a numeric value using the UPI. D. Numeric value is converted to character and compared to c1 using the UPI. E. C1 is converted to a numeric value and compared to the numeric value using full table scan.

E

Real-time data requirements are supported secondary indexes in which way? A. completely eliminate full table scans B. require less row header space C. are given priority in the Optimizer queue D. require no extra disk access E. are maintained with the base table

E

Which of the following best describes the lifespan of a transaction lock? A. based on time out setting B. four minutes after the lock is initiated C. four hours after the lock is installed D. two minutes after another user requests the resource E. until the user release the lock

E

You can reclaim all possible cylinders on the system with which operation? A. DEFRAG B. SHOWSPAC C. QRYCONFIG D. CYLPACK E. PACKKDISK

E

Match the utility to the task most suitable to it. Load 10M rows to an empty table Update 100K rows Extract 100 rows for a report Continuous load with changing load rate BTEQ TPump FastLoad MultiLoad

TPump = Load 10M rows to an empty table MultiLoad = Update 100K rows BTEQ = Extract 100 rows for a report FastLoad = Continuous load with changing load rate

Match the Teradata Utility with the Teradata Warehouse Builder operator that has the same function, by placing it in the appropriate position. load update stream export TPump FastLoad MultiLoad FastExport

TPump load MultiLoad update FastLoad stream FastExport export

Which join method is the Optimizer employing when it elects to cache one table and join it by hash to an unsorted spool? A. Hash Join B. Nested Join C. Merge Join D. Product Join

A

Which statement is true if the following phrase is included in an EXPLAIN output? "by way of a traversal of index #n extracting row ids only" A. A spool file is built from rowed values found in a secondary index (Index#n). B. A spool file is built from the rowhash found in the cylinder index. C. Rowid values are accessed in memory without the need for a spool file. D. A temporary file is accessed with rowed values found in a secondary Index (index #n).

A

You are a designer at Certkiller .com. You are designing a data warehouse which Certkiller .com's customers will utilize for long range strategic planning and to answer "what if" type questions. What kind of system has to be designed? A. DSS B. ODS C. OLDP D. RDBD

A

You are an administrator at Certkiller .com. Certkiller .com has a Teradata system with 100 GB of permanent space, of which 50 GB is reserved for spool space. The system currently has 30 GB of user data. What is the total available spool space for user queries? A. 70 GB B. 50 GB C. 30 GB D. 80 GB

A

A business model has what two advantages? (Choose two.) A. Data is organized according to what it represents. B. There is a unique data model for each department. C. The data model is the same regardless of data volume. D. Data is organized according to how it is accessed.

A, C

Which of the following are two factual statements regarding the use of Non-Unique Primary Indexes (NUPIs)? (Choose two.) A. There can be more than one row with the same Primary Index value(s). B. NUPIs distribute rows evenly and keep all the AMPs utilized equally. C. They require a Unique Secondary Index (USI) for duplicate row checking. D. They can cause skewed data.

A, D

A Unique Secondary Index has what two benefits? (Choose two.) A. It improves data retrieval speed and efficiency in a query. B. It enforces uniqueness on a Primary Key. C. It forces the Optimizer to select a full table scan. D. Row access is always a one AMP operation.

A,B

The method of creating rows, columns, and tables is governed by which two relational database concepts? (Choose two) A. The order of rows in a table is arbitrary B. A table can contain only one row formats. C. The order of rows in a table is keyed to the Primary Index. D. A table can contain multiple row formats.

A,B

Which of the following are two advantages of not requiring rows to be stored in order in a table? (Choose two) A. Unordered data is independent of any query being submitted. B. Unordered data does not need maintenance to preserve order C. Unordered data requires the use of all AMPs thereby increasing the parallelism of the total system D. Unordered data allows for more rows in a data block

A,B

Which of the following are two benefits of a Teradata relational database? (Choose two) A. It is designed to represent a business and its practices B. It allows maximum flexibility in selecting and using data C. It requires users to know the access path of the data D. It contains logically related data for a specific purpose

A,B

Which two of the following statements regarding a Primary Index are accurate? (Choose two.) A. A Primary Index is a physical mechanism. B. There is a limit to the number of columns in a Primary Index. C. A Primary Index requires uniqueness. D. A Primary Index value can not be null.

A,B

Considering the nested view situation where ViewY references TableA, which three privileges are required? (Choose three) User1 accesses ViewY User2 owns ViewY Database VMDB owns ViewX Database DBX owns TableA A. User2 has privileges on ViewX WITH GRANT option. B. Database VMDB has privileges on TableA WITH GRANT option. C. User1 has privileges on a ViewY D. User1 has privileges on TableA.

A,B,C

In the TERADATA RDBMS, what are three accessible types of indexes? (Choose three) A. join index B. Hash index C. Value Ordered index D. Primary key index

A,B,C

Which of the following three statements are accurate concerning Partitioned Primary indexes (PPI)? (Choose three) A. To store rows using PPI you specify partitioning in the CREATE TABL statement B. They reduce the number of rows processed by using partition elimination C. PPI is beneficial in queries specifying range constraints. D. PPI is used to enhance performance against small tables

A,B,C

Active Data Warehousing has which three of the following characteristics? (Choose three) A. provides an integrated environment that supports strategic and tactical queries B. provides scalability to support large amounts of detailed data C. allows for data redundancy D. allows users to directly update the operational data store (ODS)

A,B,D

Of the following, which are three factual statements regarding Visual EXPLAIN? (Choose three) A. may be used on any SQL statement, except EXPLAIN B. identifies what the Optimizer chooses not why C. identifies what the Optimizer chooses and why D. translates Optimizer output (the parse tree) into icons E. may be used on any SQL statement, including EXPLAIN.

A,B,D

Which three of the following are features of a Teradata RDBMS? (Choose three) A. Is founded on mathematical Set Theory B. Models the business C. Models the process D. Is easy to understand E. Is application driven

A,B,D

Which three of the following are features of an Active Data Warehouse environment? (Choose three.) A. support of tactical queries B. 24x7 availability and reliability C. allows for data redundancy D. mission critical applications

A,B,D

Two advantages of Fallback are_________ and_________ . (Choose two.) A. It permits automatic restoration of data changed during the AMP offline period. B. It permits access to the down AMP's vdisk by another AMP in the cluster. C. You have access to data while an AMP is offline. D. AMPs migrate in the event of a node failure

A,C

Which of the following are two tasks carried out by FastExport? (Choose two.) A. It exports data from multiple tables. B. It writes data to Teradata tables. C. It writes data to a host file. D. It uses a single session.

A,C

Which of the following are two types of columns that is supported with compression? (Choose two) A. integer B. identity C. date D. primary index E. variable length

A,C

Which two of the following are conditions for changing Partition definitions using an ALTER TABLE statement? (Choose two) A. Is populated and the ALTER TABLE statements are adding partitions to either the beginning or the end of the table B. Is defined with a NUPI C. Is empty and not in use D. Is populated, but no updates are running

A,C

Which two of the following can Teradata provide because of linear scalability? (Choose two) A. increased workload without decreased throughput B. redundant data storage for fault tolerance C. investment protection for application development D. ability to accommodate 32 CPUs on a node

A,C

A Unique Primary Index (UPI) is chosen for which three reasons? (Choose three) A. A UPI guarantees even data distribution B. A UPI is the Primary Key of the table C. A UPI access is a one AMP operation D. A UPI requires no duplicate row checking during loads

A,C,D

A connection between Teradata and a mainframe host can involve which three components? (Choose three) A. PE B. BYNET C. Host Channel Adapter D. ESCON cables E. AMP

A,C,D

In a Teradata environment, which three DBA tasks are unnecessary? (Choose three.) A. pre-allocation of table space B. index selection C. pre-prepare data for loading D. database reorganizations E. data modeling

A,C,D

Locks can be placed at which three levels? (Choose three.) A. table B. system C. database D. row hash E. block

A,C,D

Of the following, what are three major attributes of the Teradata database? (Choose three) A. parallel aware optimizer B. portable to any platform C. unconditional parallelism D. automatic data distribution

A,C,D

Which of the following are three purposes that AMP serves? (Choose three) A. It does the physical work associated with generating an answer set B. It develops the least expensive plan to return the requested response set C. It does output conversion and formatting D. It has access to a single vdisk

A,C,D

Which three of the following statements concerning PEs are accurate? (Choose three.) A. The Dispatcher receives steps from the Parser and transmits them to the AMPs. B. Session Control is responsible for load balancing across the BYNET. C. The Optimizer develops the least expensive plan to return the response set. D. The Parser checks statements for proper syntax and evaluates them semantically.

A,C,D

As technology has improved, which three aspects of the DSS environment have gained importance? (Choose three.) A. the ability to use detailed data B. requiring the data to be in a data mart C. the decreased need to use summary data D. the ability to do batch reporting E. the ability to do ad hoc queries

A,C,E

When dynamic AMP Sampling is used, which three of the following are utilized to work out the number of rows in a table? (Choose three) A. number of AMPs in the configuration B. number of disk arrays in the configuration C. average number of rows per block in the sampled cylinder D. number of nodes in the configuration E. number of data blocks in the sampled cylinder

A,C,E

You can find which three software components on a Teradata node? (Choose three.) A. PDE B. TDP C. AMP D. MOSI E. PE

A,C,E

Which are two accurate statements pertaining to job responsibilities of the Teradata DBA? (Choose two) A. Physical partitioning of disk space is not required. B. Range distribution must be used to analyze data distribution C. All related data can be placed in a single physical partition D. reorganizations are not required

A,D

Which are two exclusive features of Teradata? (Choose two) A. mature Optimizer B. Industry standard access language (SQL) C. Concurrent users D. Parallel architecture

A,D

Which of the following are two advantages of a centrally located logical architecture? (Choose two) A. provides a single view of the business B. provides departmental data control C. reduces departmental politics D. minimizes synchronization

A,D

Which of the following are two features of transient journaling that guarantees data integrity? (Choose two) A. It is automatic B. After images of changed rows are captured C. Transient Journal rows are deleted by a restart D. Data is returned to its original state after transaction failure

A,D

Which two characteristics offers continued access to data when a node fails? (Choose two). A. Disk managed by AMPs remains available within the clique. B. All paths to the data are maintained. C. All PEs migrate from the failing node to another node in the same clique. D. All AMPs migrate from the failing node to another node in the same clique.

A,D

Which two of the following are characteristics of a full table scan? (Choose two.) A. It is a way to access the data without using an index. B. It accesses all AMPs sequentially. C. It requires a read lock to operate. D. It accesses each data row only once.

A,D

Which two of the following would make the joining of a Partitioned Primary Index (PPI) table to a Non-Partitioned Primary Index (NPPI) table more efficient? (Choose two) A. choosing primary index columns that minimize row redistributions B. designing PPI tables to have fewer rather than more rows per partition C. designing the partitions so that each partition has the same number of rows D. designing the partitions so that the most common WHERE conditions eliminate the most partitions.

A,D

Which two statements aptly describes how data distribution is handled by Teradata? (Choose two.) A. Hash values are calculated using the hashing algorithm. B. The hash value for each row is calculated using the Primary Key. C. Hash values are assigned to each node. D. Hash maps will change if you add AMPs to the system.

A,D

In Teradata, what are three kinds of locks? (Choose three) A. access B. inclusive C. system D. exclusive E. read

A,D,E

Of the following, which is a true statement with regard to a Primary index operation? A. When choosing a Primary index you should pick a column with a severely limited value set. B. If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized. C. Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata D. The degree of uniqueness is not critical to efficiency

B

Which action by the system is enabled by the use of the following SQL option? Locking row no wait A. immediate access to the row B. abort requesting task on a wait C. down grade to an access lock D. abort holding lock on a wait

B

Which of the following is a statement that is true regarding temporary space? A. Temporary space is spool space currently not used. B. Temporary space is permanent space currently not used. C. Temporary space is subtracted from SysAdmin. D. Temporary space is assigned at the table level.

B

Why is it advantageous for a query to access a view that performs aggregation, instead of accessing a table that stores the aggregations? A. The aggregation may be used by other queries B. The aggregation is always current with the data in the database C. The aggregation is independent of the underlying tables D. The aggregation is calculated only once and stored in a derived table.

B

Why is the Product Joins chosen by Optimizer for all Join conditions except equality? A. They are more efficient B. Hash values cannot be used in a greater than (>) or less than (<) compare. C. Duplicating a small table is usually more efficient than hashing, redistributing, and sorting tables on the hash of the join condition D. They require less setup (redistribution and sorts)

B

Why would you choose a Non-Unique Primary Index (NUPI) instead of a Unique Primary Index (UPI)? A. A NUPI requires less disk space to store the data row. B. A NUPI may be more effective for query access and joins. C. A NUPI query simplifies the optimization process in the PE. D. A NUPI provides better data distribution.

B

You are allowed to copy a table and restore it to another Teradata database via which utility? A. Table Rebuild B. Archive Recovery C. FastExport D. Teradata Copy Tool

B

A Partitioned Primary Index should be used for what two reasons? (Choose two.) A. It is the Primary Key of the table, which guarantees uniqueness. B. It allows instantaneous dropping of old data and rapid addition of new data. C. It avoids full table scans without the overhead of a Secondary Index. D. It places all data in a specific range on the same AMP.

B,C

Of the following, which two are attributes of a Teradata warehouse? (Choose two.) A. Customer applications drive the processes. B. Relational databases are more flexible than other types. C. Businesses are able to quickly respond to changing conditions. D. It is built to reflect business application models.

B,C

Two examples of tactical queries are_________ and__________ . (Choose two.) A. modeling customer demographics B. determining the best offer for a specific customer C. altering a campaign based on current results D. deriving patterns in customer buying habits

B,C

What are two main characteristics that must be taken into consideration for an OLTP application? (Choose two.) A. Many tables must be accessed to retrieve data. B. Very little I/O processing is required to complete a transaction. C. Only a few of many possible tables are accessed. D. Data retrieved may need further processing using aggregations, joins, or sorts.

B,C

What is the result of a full table scan occurring on Teradata? (Choose two) A. All data rows are copied into temporary space B. Each data block for a table is read C. Each data row is accessed only one D. A random set of data blocks for a table is read.

B,C

Which two of the following statements are NOT true regarding RAID 5 protection? (Choose two) A. Missing blocks of data can be reconstructed B. A disk failure does not affect performance C. RAID 5 has a higher space penalty than RAID 1. D. Data and parity are striped across an rnk of disks.

B,C

Which two statements concerning Failback are true? (Choose two) A. Failback does not require additional disk space B. Failback can be specified at the table level C. Failback is associated with AMP cluster D. Failback is a data protection scheme that uses cliques

B,C

You will locate which two types of data in data mart? (Choose two) A. summarized subset of detailed data for general use B. summary data for a particular use C. detailed data for a particular use D. all detailed data for general use

B,C

In which three ways is data access handled by Teradata? (Choose three) A. The AMPs convert the SQL into steps that are sent out by the Dispatcher B. The BYNET sends a communication between the nodes C. The PEs handle Session Control functions D. The AMPs retrieve and perform database functions on the requested rows. E. The BYNET sends the answer set back to the application

B,C,D

Which three are the phases in the data warehouse usage evolution that leads to Active Data Warehousing? (Choose three) A. data access B. event-based triggering C. analytical modeling D. program modification E. continuous update

B,C,E

When electing to denormalize a table, which are two factors you should think about? (Choose two) A. cardinality B. volatility C. connectivity D. performance

B,D

When you compare Primary Keys, Primary Indexes, and Partitioned Primary Indexes (PPI), which two statements do find to be true? (Choose two.) A. Data distribution with PPI is based on the partitioned column(s). B. Primary Keys are not changed. C. A Primary Index is a relational modeling convention. D. Data distribution with PPI is based on the Primary Index.

B,D

Which of the following are two statements regarding Fallback that is correct? (Choose two.) A. Fallback does not require additional disk space. B. Fallback is associated with AMP clusters. C. Fallback is a data protection scheme that uses cliques. D. Fallback can be specified at the table level.

B,D

What option can best describe Teradata's architecture? A. shared everything B. shared memory C. shared nothing D. shared data

C

When collected statistics are available the Optimizer can estimate costs more accurately, and build more aggressive join plans. What expression would suggest that statistics are absent in an EXPLAIN? A. High confidence... B. A table is duplicated on all AMPS... C. No confidence.... D. Statistics are needed...

C

Which task is performed by the Teradata Index Wizard? A. emulate a workload on a test system B. recommend Primary Indexes for a table C. recommend Secondary Indexes for a table D. compare performance of multiple workloads

C

You are an administrator at Certkiller .com. Certkiller .com has a Teradata system with 100 GB of permanent space and you create User A with 30 GB permanent space. How much space will User A have, if User A creates User B with 20 GB permanent space? A. 70 GB B. 80 GB C. 10 GB D. 30 GB

C

Of the following, which are two true statements about permanent space? (Choose two.) A. Macros require permanent space. B. Tables and views are defined in permanent space. C. All databases have a defined upper limit of permanent space. D. Permanent space is not physically allocated at object definition time.

C,D

Which of the following are two architectural attributes of a Teradata system? (Choose two.) A. Disk space associated with an AMP is divided into three areas: system, permanent, and spool. B. Parallelism is achieved through operating system time slicing. C. The AMPs access data from their associated vdisks as required. D. The PEs communicate with the AMPs across the BYNET.

C,D

Which of the following are two factual statements regarding an OLTP environment? (Choose two) A. Transactions are write intensive B. The number of rows per transaction is large. C. Transactions typically occur within seconds, not minutes D. The number of rows per transaction is small

C,D

Which two of the following are system events that take place as part of transient journaling to guarantee data integrity? (Choose two.) A. automatic rollforward of After Images B. control records for drops and creates are maintained C. automatic rollback of changed rows in the event of a transaction failure D. Before Images are retained on each AMP as changes occur

C,D

Which two of the following statements are true if an EXPLAIN output contains the following phrase? (Choose two) "with high confidence" A. One input relation has high confidence and the other has low confidence B. Restricting conditions exist on an index that has collected statistics but is ORed with another column having collected statistics. C. One input relation has high confidence and the other has high or index join confidence D. Restricting conditions exist on an index or column that has collected statistics.

C,D

Block level operations are performed against populated tables by which utility? A. Tpump B. BulKLoad C. FastLoad D. MultiLoad

D

Queries based on set threshold are restricted by which tool? A. Teradata Manager B. BTEQ C. Teradata SQL Assistant D. TDQM

D

Which is the component that limits queries based on set thresholds? A. Teradata SQL Assistant B. BTEQ C. Teradata Manager D. TDQM

D

A Partitioned Primary Index would be defined during which stage of modeling design? A. Logical Data Modeling B. Entity-Relationship Modeling C. Business information Modeling D. Physical Data Modeling

D

An example of an OLTP environment is____________ . A. creating a report to show a comparison of sales from this week to last week B. creating a report to show how much credit can be extended to a customer C. creating a report that shows the top ten selling items across all stores for one year D. updating a checking account to reflect a deposit

D