Get prepared for the Certifications with the Teradata Quiz

Welcome to the Teradata Quiz.

Each time you take the quiz, a different set of questions will be asked. We are adding new questions on a regular base. At the end of the quiz, we will show you the correct answers, your score and the average score of all people.

Enter your name and press "NEXT" to start the quiz

Name Email

1. Would you consider to use block level compression (BLC) in order to reduce CPU usage?

Yes

No

2. Given the following query (all used objects exist): SELECT Table1.COL1 FROM DATABASENAME.Table2; Will the query work?

Yes

No

3. Which of these technical join types are available on Teradata?

Hash Join

Merge Join

Sliding Window Merge Join

Product Join

Left Outer Join

4. The column DelayTime in the DBC.DBQLOGTBL shows what?

The total number of seconds the request was delayed

The number of seconds a request was delay in a workload queue

The sum of workload delays and system delays

5. Where are random AMP samples stored?

DBC.StatisticsV

Table Header in FSG cache

Parsing Engine

6. Why would you use a Unique Primary Index (UPI)?

A UPI guarantees even data distribution

A UPI is the Primary Key of the table

A UPI access is a one AMP operation

A UPI requires no duplicate row checking during loads

7. Can you use relative weights in the timeshare tier?

Yes

No

8. Can a NUSI be used in a join step?

Yes

No

9. How would you collect statistics on a very small table?

Dynamic AMP sampling

Fully collected statistics

Both are reliable methods for small tables

10. Which of the following are tasks carried out by FastExport?

It exports data from multiple tables

It writes data to Teradata tables

It writes data to a host file

It uses a single session

Get prepared for the Certifications with the Teradata Quiz

Welcome to the Teradata Quiz.

Enter your name and press "NEXT" to start the quiz

Be sure to click "Submit Quiz" to see your results (click only once, the rating process may need a couple of seconds)!

Be sure to click "Submit Quiz" to see your results
(click only once, the rating process may need a couple of seconds)!