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 ModelingData Warehouse ArchitectureData LoadingReportingData Warehouse RolesPerformance Tuning Tasks Tested Audit ColumnsDimensional ModelSCD TypeJunk DimensionHandling a Null Dimension KeyHandling RangeConformed DimensionDimensional Model First DefinedSurrogate vs. Primary KeyFact AttributeAccessing Customer AttributesData Warehouse ArchitecturePre-requisite to the Dimensional ModelFact Table TypesResolving Bank Design RequirementsSupersetWorking with Large DimensionLevels of GranularityHandling GranularityDesigning EDWBus ArchitectureDesign ScopeDesigning a Dependent Data MartData LoadingData ExtractionQuery Types Used with a Data WarehouseReport AvailabilityOLAPUser Requirement CollectionRolesProcess and Tools UsedDetermining Index TypeUsage of AggregateOptimize QueriesEntity Relationship ModelingExecution StepsPartition DataStar Join TuningDetermining CASE ToolPartition IndexesPartitioning SchemePartitioning a Fact Table
