OLAP is an acronym for On Line Analytical Processing. The OLAP Concepts assessment measures a candidate's understanding of the core ideas and key concepts of OLAP database design and management. This assessment is appropriate for entry-level OLAP users and those with one or two years of experience. Topics include Data Warehousing, Building Dimensions, Working with Cubes and Measures, Managing Storage and Optimization, Processing Dimensions and CubesManaging Partitions, Deploying an OLAP Solution, and Data Mining. Assessments for Data Modeling Concepts, Data Warehousing Concepts, and SPSS are also available. Total Questions 37 Question Types Multiple Choice Competencies Tested Processing Dimensions and CubesWorking with Cubes and MeasuresDeploying an OLAP SolutionData Warehousing and OLAPManaging Storage and OptimizationBuilding DimensionsData MiningManaging Partitions Tasks Tested Maintaining a DatabaseBasis of OLAP ProcessingRow RetrievalModels of Dimensional ArchitectureProcessing CubesUpdating a CubeDefining Cube PropertiesWorking with MeasuresSpecific Data Set or CategoryReserved Storage SpaceEnd User ReportingLarge Quantities of Data or UsersDeploying to ProductionBusiness RequirementsSmall Data WarehouseOLAP ModelsRotating a Two-Dimensional TableAdvanced Design TechniquesBasic Component of OLAPDatabase ManagementManaging Data StructuresManaging StorageOptimization TuningOptimizing and TuningDefining Tables within a SchemaWorking with Levels and HierarchiesAdjusting DimensionsWorking with Standard DimensionsTracking Non-Value EventsWorking with Dimension StructureSlowly Changing DimensionWorking with LevelsAccessing Large Quantities of DataBuilding a Data Mining ModelCreating Partitions
