The Data Warehousing Concepts test focuses on Database Administration, Business Intelligence, Design/Operation/Management, and Principles/Rules specific to the area of Data Warehouse environments. The candidate should have functional knowledge in some area of Information Technology relevant to programming, design, or management of applications, but this test will specifically address those concepts that are unique to a Data Warehouse application. Consequently, the test does not examine the candidate's technical knowledge of general subjects or specific products. Assessments for Data Communications Concepts and Data Modeling Concepts are also available. Total Questions 39 Question Types Multiple Choice Competencies Tested Database AdministrationBusiness IntelligencePrinciples/RulesDesign/Operation/ManagementDesign/ Operation /Management Tasks Tested Derived FactAccess SecurityLogical Data ModelsData Mart Database ContentsTable/Schema StructuresOptimized DatabasesData NormalizationData Warehouse Database ContentsBusiness Intelligence ToolsInitiating Delivery of InformationDimensionInformation Consumers AccessOLAP, MOLAP, ROLAP ToolsData CubeDefining TermsOLAP AcronymMDD AcronymDashboardResponsibility for Defining Data Integrity CriteriaResponsibility for Definition of Data for RetrievalEncountering ErrorsAudit FunctionResponsibility for Database OptimizationOperational Data StoreResponsibility for Defining Schedule of ExtractionsResponsibility for Defining Frequency of UpdatesResponsibility for Defining Criteria for Subscription OrdersSchedulingResponsibility for Defining SecurityTransactional Data StoreResponsibility for Definition of Data ElementsResponsibility for ETLData MartsETL ToolMetadataAttributeInfoCubeDimension TablesLogical Modeling
