Data Architecture Assessment

  • $10.00

This Data Architecture assessment 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.

Number of questions 44
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Data Loading
Data Warehouse Architecture
Data Warehouse Roles
Dimensional Modeling
Performance Tuning
Tasks tested Accessing Customer Attributes
Audit Columns
Bus Architecture
Conformed Dimension
Data Extraction
Data Loading
Data Warehouse Architecture
Design Scope
Designing a Dependent Data Mart
Designing EDW
Determining CASE Tool
Determining Index Type
Dimensional Model
Dimensional Model First Defined
Entity Relationship Modeling
Execution Steps
Fact Attribute
Fact Table Types
Handling a Null Dimension Key
Handling Granularity
Handling Range
Junk Dimension
Levels of Granularity
Optimize Queries
Partition Data
Partition Indexes
Partitioning a Fact Table
Partitioning Scheme
Pre-requisite to the Dimensional Model
Process and Tools Used
Query Types Used with a Data Warehouse
Report Availability
Resolving Bank Design Requirements
SCD Type
Star Join Tuning
Surrogate vs. Primary Key
Usage of Aggregate
User Requirement Collection
Working with Large Dimension
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)