Question 1.
Which two attributes are copied for a CREATE TABLE from a subquery to the table being created? (Choose two.)

A. data types
B. FALLBACK option
C. column-level attributes
D. primary index
E. CHECK constraints

Answer: A, C

Question 2.
Which three features are associated with join indexes? (Choose three.)

A. a pre-aggregation of a single base table
B. the pre-join of multiple tables using INNER JOIN
C. the pre-join of multiple tables using FULL OUTER JOIN
D. a replicated subset of a single base table

Answer: A, B, D

Question 3.
You want to generate three mutually exclusive sample sets from a customer table.
SELECT customer_id, age, income, SAMPLEID
FROM customer_table

Which clause needs to be added to complete the task?

A. SAMPLE .6, .25, .10, .05 ;
B. SAMPLE .6, .25, .10, .05 WITH REPLACEMENT ;
C. SAMPLE .6, .25, .10 ;
D. SAMPLE .6, .25, .10 WITH REPLACEMENT ;

Answer: C

Question 4.
Consider the table t1 created as follows:
CREATE TABLE t1 (
a integer,
d date,
v varchar(100))
PRIMARY INDEX (a)
PARTITION BY RANGE_N(d BETWEEN
DATE '2001-01-01' AND DATE '2005-12-31'
EACH INTERVAL '7' DAY); and the query:
SELECT v FROM t1 WHERE d = DATE '2004-03-16';

Which plan does the Optimizer use to find qualifying rows?

A. full table scan on a single AMP
B. single partition scan on every AMP
C. value lookup on every AMP
D. hash lookup on each AMP
E. single partition scan on a single AMP

Answer: B

Question 5.
If neither RANGE_N nor CASE_N are used to define the number of partitions, how many partitions will the Optimizer assume?

A. 255
B. 0
C. 32767
D. 1
E. 65535

Answer: E

Question 6.
Which two statements are true concerning parameters within a stored procedure? (Choose two.)

A. Parameters and their attributes are always stored in the Data Dictionary.
B. Parameters can be used to build a dynamic SQL statement.
C. Parameters can be altered using the FORMAT clause.
D. Parameters can include status variables such as ACTIVITY_COUNT.

Answer: A, B

Question 7.
Which two tools can be used to alter database objects to improve workload performance? (Choose two.)

A. Teradata System Emulation Tool (TSET)
B. Teradata Visual Explain
C. Teradata Statistics Wizard
D. Teradata Index Wizard

Answer: C, D

Question 8.
Which three are attributes of an Active Data Warehouse? (Choose three.)

A. high availability
B. tactical queries
C. complex queries
D. expanding batch windows

Answer: A, B, C

Question 9.
Which join plan makes use of a primary index on each of two tables with matching partitioned primary indexes (PPIs)?

A. rowkey-based merge
B. nested
C. exclusion merge
D. rowhash merge

Answer: A

Question 10.
You are evaluating the possible use of a hash index on a multi-terabyte table. 

Which two factors complicate the implementation of a hash index on such a table? (Choose two.)

A. A partitioned primary index (PPI) is defined on the table.
B. A large number of users access the table.
C. Triggers are defined on the table.
D. The maintenance job for the table is MultiLoad.

Answer: C, D

Question 11.
What are two characteristics of the COMPRESS clause? (Choose two.)

A. It can be defined so a specific value is not stored in each row.
B. It compresses repeating 1s and 0s.
C. It can be used on character data types only.
D. It supports multiple values per column.

Answer: A, D

	Web www.certsbraindumps.com