Mar 14
Question 1: Difference between MultiLoad and TPump? Answer: Tpump provides an alternative to MultiLoad for low volume batch maintenance of large databases under control of a Teradata system. Tpump updates information in real time, acquiring every bit of a data from the client system with low processor utilization. It does this through a continuous feed …
Mar 09
Question 1: What is the fallback or no fallback option while creating table DDL? Answer: FALLBACK requests that a second copy of the each rows inserted into the table has a duplicate copy in another AMP in the same cluster. This way we can make the copy of the data inserted into tables. While NO …
Mar 05
Teradata is designed in such a fashion, to reduce the DBA’s administrative functions when it comes to space management. Space is configured in the following ways in Teradata system – 1) PERMANENT SPACE 2) SPOOL SPACE 3) TEMPORARY SPACE 1) PERMANENT SPACE – Permanent space is where the objects (i.e. – databases, users, tables) are …
Mar 02
1. Which three aspects of the DSS environment have gained importance as technology has improved? (Choose three.) A. the ability to use detailed data B. the ability to do ad hoc queries C. the ability to do batch reporting D. requiring the data to be in a data mart E. the decreased need to use …
Mar 01
1. What three types of processing are needed in decision support data warehouse environments? (Choose three.) A. ad hoc queries B. pre-defined reports C. analytical modeling D. continuous update E. event-based triggering Answer: ABC 2. Which three stages in data warehouse usage evolution lead to Active Data Warehousing? (Choose three.) A. modifying B. analyzing C. …
Feb 28
1. Which three are characteristics of Active Data Warehousing? (Choose three.) A. allows for data redundancy B. provides scalability to support large amounts of detailed data C. allows users to directly update the operational data store (ODS) D. provides an integrated environment that supports strategic and tactical queries Answer: BCD 2. Why would you have …
Feb 26
For latest update about Teradata 14 certification, click below link – Teradata 14 Certification The Teradata Certified Professional Program is focused on advancing the growth of Teradata knowledge and skills to a worldwide professional IT community. After V2R5 the latest set of exams for Teradata is – TERADATA 12. There are total 7 exams for …
