Data Architecture Assessment


Data Architecture Assessment

Skills Assessment

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.


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 44
Question Types Multiple Choice
Competencies Tested Dimensional Modeling
Data Warehouse Architecture
Data Loading
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
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
User Requirement Collection
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