Data Architecture Assessment

$16.00

Data Architecture Assessment

$16.00
description

This Data Architecture test is designed to assess the knowledge of a data architect in the use and application of principles essential to Data Architecture. Topics covered include data warehouse architecture, modeling, and roles, as well as performance tuning, data loading, reporting, requirement collection, and dimensional modeling. A deep understanding of Data architecture concepts is needed for this assessment and as such this is appropriate for intermediate and advanced level data architects.

Assessments for Project Management for IT Professionals and Business Systems Analyst are also available.

 

Total Questions 44
Question Types Multiple Choice
Competencies Tested Dimensional Modeling
Data Warehouse Architecture
Data Loading
Reporting
Data Warehouse Roles
Performance Tuning
Tasks Tested Audit Columns
Dimensional Model
SCD Type
Junk Dimension
Handling a Null Dimension Key
Handling Range
Conformed Dimension
Dimensional Model First Defined
Surrogate vs. Primary Key
Fact Attribute
Accessing Customer Attributes
Data Warehouse Architecture
Pre-requisite to the Dimensional Model
Fact Table Types
Resolving Bank Design Requirements
Superset
Working with Large Dimension
Levels of Granularity
Handling Granularity
Designing EDW
Bus Architecture
Design Scope
Designing a Dependent Data Mart
Data Loading
Data Extraction
Query Types Used with a Data Warehouse
Report Availability
OLAP
User Requirement Collection
Roles
Process and Tools Used
Determining Index Type
Usage of Aggregate
Optimize Queries
Entity Relationship Modeling
Execution Steps
Partition Data
Star Join Tuning
Determining CASE Tool
Partition Indexes
Partitioning Scheme
Partitioning a Fact Table