Data Warehousing Concepts Assessment

  • $10.00


The Data Warehousing Concepts assessment 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 assessment will specifically address those concepts that are unique to a Data Warehouse application. Consequently, the assessment 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.

Number of questions 39
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Business Intelligence
Database Administration
Design/ Operation /Management
Principles/Rules
Tasks tested Access Security
Attribute
Audit Function
Business Intelligence Tools
Dashboard
Data Cube
Data Mart Database Contents
Data Marts
Data Normalization
Data Warehouse Database Contents
Defining Terms
Derived Fact
Dimension
Dimension Tables
Encountering Errors
ETL Tool
InfoCube
Information Consumers Access
Initiating Delivery of Information
Logical Data Models
Logical Modeling
MDD Acronym
Metadata
OLAP Acronym
OLAP, MOLAP, ROLAP Tools
Operational Data Store
Optimized Databases
Responsibility for Database Optimization
Responsibility for Defining Criteria for Subscription Orders
Responsibility for Defining Data Integrity Criteria
Responsibility for Defining Frequency of Updates
Responsibility for Defining Schedule of Extractions
Responsibility for Defining Security
Responsibility for Definition of Data Elements
Responsibility for Definition of Data for Retrieval
Responsibility for ETL
Scheduling
Table/Schema Structures
Transactional Data Store
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)