Tricky Questions

Database
Enthusiast

Tricky Questions

 Hi Gurus,

I came across thorugh a set of tricky questions while preparing for the cert. Request the experts to please help me out with the answers.

1)Which two statements describe the operation of a full table scan during a select process? (Choose Two).

     A) It requires a spool file.

     B) It uses block level locking.

     C) It is a group AMP operation.

     D) It accesses each data row only once.

2)Which two communication interfaces can fast load use? (Choose two)

     A) CLIv2.

     B) JDBC.

     C) ODBC.

     D) OLEDB.

3)  Match the warehouse architectural layer on the left with its purpose on the right.

     A) Staging layer          1) Gather data from multiple source systems.

     B) Physical layer.         2) Transform normalized data into user friendly structures

     C) Access layer.          3) Enables prototyping by business users with minimal controls

     D) Data Lab.             4) Provides data repository used to support cross functional,

                            Enterprise initiatives.

4)

 What are two benefits of the Teradata database?(Choose two.)

     A) There are special versions tuned for the appliances.

     B) It automatically detects and recovers from software failures.

     C) It guarantees linear performance for cursor based processing.

     D) It provides centralized management and control regardless of system size.

     E) It can be accessed by either channel attached or network attached systems.

5)

What is a benefit of a single table join index?

     A) Table joins are eliminated.

     B) Summary tables are eliminated.

     C) Secondary indexes are eliminated.

     D) Redistribution for some queries is eliminated

Thanks,

Amit

5 REPLIES
Enthusiast

Re: Tricky Questions

1) 

C) It is a group AMP operation.

D) It accesses each data row only once.

 

2)

 B) JDBC.

 D) OLEDB.

 

3) @dnoeth ... Can you share your insight on this question here. Thanks in advance

 

4)

A) There are special versions tuned for the appliances.

B) It automatically detects and recovers from software failures.

 

5)  A) Table joins are eliminated.

 

 

 

 

Enthusiast

Re: Tricky Questions

Also please share your answer for the below question @dnoeth

Match the options to questions 

1. requires twice the disk space  

2. protects data in case of Amp failure

3. protect data incase of node failure

4. provides rollback after transaction failure

5. is critical for high availability applications

6. starts up when an AMP fails

 

Options:

A. Clique

B. Fallback

C.Transient Journal

D. Down Amp Recovery Journal

Enthusiast

Re: Tricky Questions

Hi, I think below is the correct match: 3. A 6. D 4. C 2. B 1. B 5. A
Enthusiast

Re: Tricky Questions

The correct answer is:

 

1. B

2. B

3. A

4. C

5. B

6. D

 

For reference: http://www.xmind.net/m/Bh7X

Highlighted
Enthusiast

Re: Tricky Questions

For 5th question, I think answer is D) Redistribution for some queries is eliminated.

How can it eliminate join? Where join is needed it has to happen. But if the rows to be joined are on same AMP, redistribution will not be required( this happens when we join tables on PI columns). The reditribution can be avoided even if column is not the  PI in main table if we create Hash Index or Join index with join column as PI index.