Data Warehousing Concepts Assessment

$16.00

Data Warehousing Concepts Assessment

$16.00
description

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.

 

Number of questions 39
Competencies tested Database Administration
Business Intelligence
Principles/Rules
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
Dimension
Information Consumers Access
OLAP, MOLAP, ROLAP Tools
Data Cube
Defining Terms
OLAP Acronym
MDD Acronym
Dashboard
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
Scheduling
Responsibility for Defining Security
Transactional Data Store
Responsibility for Definition of Data Elements
Responsibility for ETL
Data Marts
ETL Tool
Metadata
Attribute
InfoCube
Dimension Tables
Logical Modeling