- OLAP is an acronym for
- Online Analytical Processing
- Online Analysis Process
- Online Arithmetic Processing
- Object Linking and Processing
- What is a Data warehouse
- A database application that searches for hidden patterns in a database.
- A database designed to support decision making in organizations. It is batch updated and structured for rapid on-line queries and managerial summaries
- An interactive computer based system which helps decision makers utilize data and models to identify and solve problems and make decisions.
- The following is the characteristic(s) of data in a data warehouse
- Subject Oriented
- Non-Volatile
- Time-Variant
- Integrated
- All the above
- Which of the following is false
- Data Warehouse is designed for query and analysis
- Data Warehouse is designed for transaction processing
- Data Warehouse consolidates data from several sources
- Data Warehouse maintains the records of both historical and the current data
- The data in Data Warehouse is generally
- Clean Data
- Dirty Data
- Clean and Dirty Data
- None of above
- What is Metadata
- Metadata contains the relationship between Dimension and Fact Tables
- Metadata describes data and other structures, such as objects, business rules, and processes
- Metadata stores the aggregation information
- Metadata contains only business rules
- Multidimensional data can be queried and manipulated using
- T-SQL
- MDX
- MDAC
- OWC
- The following is not the characteristic of Dimension table
- Describes business entities
- Presents data organized into Hierarchies
- Describes data in the fact table
- Referential integrity need not be maintained between dimension tables and the fact table
- Different Storage Modes used for storage of cubes are
- MOLAP
- ROLAP
- HOLAP
- All the above
- Which of the following best describes the Fact table
- Contains only measures
- Contains only keys that join to Dimension Tables
- Contains measures and keys that join to Dimension tables
- None of the above
- Which of the following is false
- A private dimension is a dimension created for an individual cube
- A shared dimension is a dimension that can be used by multiple cubes
- A virtual dimension is a logical dimension based on the columns from a physical dimension
- The storage mode of a virtual dimension can be MOLAP, ROLAP or HOLAP
- Which of the following is TRUE for Cube Storage Mode
- MOLAP copies all of the data and all the aggregates to the analysis server in an optimized multidimensional format
- ROLAP leaves the original data in the relational tables and uses separate set of relational tables to store the aggregates
- In HOLAP, data remains in the relational tables, but aggregations are stored on the server in optimized multidimensional fomat
- All the above
- The following Storage Mode gives the best Query Performance
- MOLAP
- ROLAP
- HOLAP
- What is a Datamart
- It is a subset of data warehouse and it supports a particular region, business unit or business function
- It is a superset of data warehouse
- It is a copy of data warehouse
- None Of the above
- Which of the following is false
- In a star schema every dimension will have a primary key
- In a star schema, a dimension table will have one or more parent tables
- In a snow flake schema, dimension table will have one or more parent tables
- In a star schema, hierarchies for the dimensions are stored in the dimensional table itself
- In Snow Flake schema, hierarchies are broken into separate tables
- Snowflaking means
- Normalizing the data
- Denormalizing the data
- None of Above
- Which of the following is false for Cubes
- Cubes are multi-dimensional data representation
- Cubes replicate data in the dimension and fact tables
- Cubes do not require updating when the data warehouse data is updated
- Cubes provide an easy-to-use mechanism for querying data with quick and uniform response times
- The methods of processing the cubes
- Incremental Update
- Refresh Data
- Process (Rebuild) Data
- All the Above
- Which of the following is false
- Cube contains one or more Partitions
- Virtual Cubes retrieve information across multiple cubes
- Every Partition in a Cube should have the same storage mode
- All the above
- The Process by which data from transaction system or flat files is loaded in the datawarehouse schema is
- Extraction
- Transformation
- Loading
- All the above
- During ETL load we generally have
- Unsorted data for Aggregation
- Sorted data for Aggregation
- Does not matter if we use Sorted or Unsorted data for Aggregation
- Sequence of jobs to load data in to warehouse
- First load data into fact tables then dimension tables, then Aggregates if any
- First load data into dimension tables, then fact tables, then Aggregates if any
- First Aggregates then load data into dimension tables, then fact tables
- Does not matter if we load either of fact, dimensions, or aggregates
- Which of the following is false for Surrogate Keys
- These keys are maintained within the data warehouse
- These keys are taken from the source data
- This uniquely identifies each entity in the dimension table regardless of its source key
- All the above
- The following is the characteristic(s) of Aggregations
- Aggregations are precalculated summaries of data
- Aggregations are stored in the multidimensional structure in cells at coordinates specified by the dimensions
- Results in the fastest possible response time
- All the above
- The Data Analysis Tools that can be used to analyze data that is stored in data warehouse
- OLAP Manager
- Microsoft Excel 2000
- Microsoft English Query
- All the above
- Solution for managing Slowly Changing Dimension in which history of data is tracked accurately
- Type 1: Overwrite the dimension record
- Type 2: Write another dimension record
- Type 3: Updating the dimension record and moving old value to a separate attribute
- None of the above
- Which of the following method is used to view the data at different levels of granularity
- Drill Down
- Drill Up
- Drill Across
- Drill Through
- All the above
- Drill Across generally uses the following join to generate report
- Self Join
- Inner Join
- Outer Join
- What is Data Mining
- It is a process which removes the history data in the data warehouse
- It is a process which removes the current data in the data warehouse
- It is a process that looks at the data in the cube and searches for patterns
- None of the above
- In general data in Data Warehouse is
- Normalized
- Denormalized
- None of the Above
Nice compilation Pratap!!
ReplyDeleteWhere are the answers?
ReplyDelete