DATA WAREHOUSE ARCHITECTURES – 19%
Candidates should be able to identify the high-level concepts and major components of the data warehouse architectures, deployment options, implementation types, the data flow of data warehouses and the reasons for deploying a data warehouse architecture as well as the scalability options on Cloud and the integration options with Cloud service providers.
DATA DISTRIBUTION AND ACCESS – 12%
Candidates should be able to identify use cases of Primary, Secondary, and Join indexes, the impact the Primary Index has on data distribution, the differences between Primary Index and Primary Key, the types, levels and functionality of locking and the purpose and components of the access layer.
TERADATA TOOLS AND UTILITIES – 12%
Candidates must be able to identify the common data integration techniques and their uses, the features and functions of the administering and monitoring tools and the common access tools available within the Teradata client tools and their uses. This includes Teradata Studio Express and BTEQ.