WorksheetsDWDM-2
Total questions: 20
Worksheet time: 10mins
A data warehouse is which of the following?
Can be updated by end users.
Contains numerous naming conventions and formats.
Organized around important subject areas.
Contains only current data.
________ is a collection of data marts representing historical data from different operations in the company.
data warehouse
data mining
OLAP
None of these
Data can be updated in _____environment.
data mart
data mining
operational
informational
______________ is data about data.
Metadata
Microdata
Minidata
Multidata
The star schema is composed of __________ fact table.
1
2
3
Many
___________ is a good alternative to the star schema.
Star schema.
Snowflake schema.
Fact constellation.
Star-snowflake schema.
Fact tables are ___________.
completely demoralized
partially demoralized.
completely normalized.
partially normalized.
Which of the following is not true for data warehouse?
Data warehouse contains subject oriented data
Data warehouse contains only short duration recent data.
Data warehouse provides analytical information for decision making process.
Data warehouse is different from traditional database systems.
Data warehousing and on-line analytical processing (OLAP) are _______ elements of decision support system.
Unusual
Essential
Optional
None of the these
ROLAP refers to ............OLAP.
Roll
Rapid
Running
Relational
The OLAP operations are___
Roll up
Roll down
Slice and Dice
All of these
Which of the following is the numeric measurements or values that represents a specific business aspects or activity:
dimensions
schemas
facts
tables
Getting data from multiple, heterogeneous, and external sources is known as ____
Data mining
Data transformation
Data extraction
Load
In which of the following, a fact table in the centre is directly linked with dimension table?
star schema
snowflake schema
fact constellation schema
relational schema
Three Categories of Data Cube Measures are_____
Distributive
Algebraic
Holistic
All the above
Which operation allows an analyst to rotate the cube in space to see its various faces?
Pivot
Dice
Roll-up
Slice
Three Data Warehouse Models are ___ ,___ ,___
Operational Data,
Informational data , Metadata
Enterprise warehouse,
Informational data , Metadata
Enterprise warehouse,
Data Mart,
Virtual warehouse
None of these
Data Cube consists of
Dimensional data
Multidimensional Data
No Dimensional Data
Procedural Data
OLTP stands for
Online Time processing
Online Analytical Processing
Online Transfer Processing
None of these
______ cubes are ideal for slicing and dicing data and can perform complex calculations.
ROLAP
MOLAP
HOLAP
WOLAP
