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 …
Feb 26
Question 1: Explain TPUMP (Teradata Parallel Data Pump) Utility in Teradata? Answer: TPUMP allows near real time updates from Transactional Systems into the Data Warehouse.It can perform Insert, Update and Delete operations or a combination from the same source. It can be used as an alternative to MLOAD for low volume batch maintenance of large …
Feb 26
The Teradata database was originally designed in 1976, by TERADATA Corp. Nearly 25 years later, Teradata is still considered ahead of its time. In 1976, IBM, mainframes dominated the computer business. However the original founders of TD noticed that it took about 4½ years for IBM to produce a new mainframe. At the same time, …
Feb 25
First of all what are Built-in functions? These are functions which do not need any sort of arguments but still returns information about the system; user, date, time, session etc. Built-in functions are sometimes referred to as special registers. Mostly used with the SELECT statement. SELECT <Built-In Function> • ACCOUNT: – If you are wondering …
