Data Warehousing Concepts Assessment


Data Warehousing Concepts Assessment

Skills Assessment

The Data Warehousing Concepts test focuses on Database Administration, Business Intelligence, Design/Operation/Management, and Principles/Rules specific to the area of Data Warehouse environments. The candidate should have functional knowledge in some area of Information Technology relevant to programming, design, or management of applications, but this test will specifically address those concepts that are unique to a Data Warehouse application. Consequently, the test does not examine the candidate's technical knowledge of general subjects or specific products.

Assessments for Data Communications Concepts and Data Modeling Concepts are also available.


What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.

How does it work?
Total Questions 39
Question Types Multiple Choice
Competencies Tested Database Administration
Business Intelligence
Design/ Operation /Management
Tasks Tested Derived Fact
Access Security
Logical Data Models
Data Mart Database Contents
Table/Schema Structures
Optimized Databases
Data Normalization
Data Warehouse Database Contents
Business Intelligence Tools
Initiating Delivery of Information
Information Consumers Access
Data Cube
Defining Terms
OLAP Acronym
MDD Acronym
Responsibility for Defining Data Integrity Criteria
Responsibility for Definition of Data for Retrieval
Encountering Errors
Audit Function
Responsibility for Database Optimization
Operational Data Store
Responsibility for Defining Schedule of Extractions
Responsibility for Defining Frequency of Updates
Responsibility for Defining Criteria for Subscription Orders
Responsibility for Defining Security
Transactional Data Store
Responsibility for Definition of Data Elements
Responsibility for ETL
Data Marts
ETL Tool
Dimension Tables
Logical Modeling