Data Warehouse
Description: data warehouse | |
Number of Questions: 15 | |
Created by: | |
Tags: datawarehouse Database |
Which of the following data warehouse types are those in which components are distributed across a number of physical databases?
Which of the following characteristics of data warehouses puts data from disparate sources into a consistent format?
Which of the following components of data warehouse architecture has the major function to extract the data, transform the data, and then load the data into the data warehouse storage?
Which of the following servers in data warehouse supports multidimensional views of data through array-based multidimensional storage engines?
Which of the following schema in data warehousing is a method of normalising the dimension tables in a star schema and when it is completely normalised, the resultant structure resembles a schema with the fact table in the middle?
Which of the following objects in a data warehouse allows data to be modelled and viewed in multiple dimensions and is defined by dimensions and facts?
Which of the following methods in data warehousing is the process of examining the data available in an existing data source and collecting statistics and information about that data?
In which of the following levels of CMM data quality issues are acknowledged and major problems are handled, as and when they surface?
Which of the levesl in Capability Maturity Model (CMM) is the one in which a company understands how each IT process is related to overall business strategies and goals of the corporation?
Which of the following is the process of integrating data from multiple internal and external sources and making it readily available for use in business analysis?
Which of the following loads in data warehousing refers to completely erasing the contents of one or more tables and reloading with fresh data?
Which of the following functions in data warehouse has to deal with numerous data sources and employs appropriate technique for each data source?
Which of the following databases is designed for analysis of business measures by categories and attributes?
Which of the following components of a data warehouse is used to load the source data into the warehouse?
Which of the following data models in database describes the implementation of data in a physical database and is also called the blueprint for the database?