WorksheetsData Warehousing
Total questions: 17
Worksheet time: 9mins
Data Warehousing is the consolidation of data from multiple systems for the purpose of serving the business needs of an organization.
TRUE
FLASE
Which of the following is a business imperative for Data Warehousing?
Single view of customer data across merged data assets
Increase prevalence of hand coded resources
Save more money for the social clubs
Increase complexity
What type of customer represents the best opportunity for Informatica?
An all IBM Shop
An all SAP Shop
A heterogeneous environment
An all Microsoft shop
A requirement of a data warehouse is
High performance and scalability
Improved information quality to promote better decision making
Improved productivity
All of the above
Data warehousing helps clients to better manage their data lifecycle and meet regulatory compliance metrics.
TRUE
FALSE
Inability to access data is a common pain experienced by customers looking for a data warehouse solution.
TRUE
FALSE
A typical imperative of a data warehouse is to be able to access any type of data from anywhere (Mainframe, Core Business Application etc)
TRUE
FALSE
Discrete data is from qualities that can be
Measured
Counted
Both
Continuous data is from qualities that can be
Measured
Counted
Both
Which of these is NOT continuous data:
A person's height each year
The volume of water in a swimming pool each day
Cars finished in a factory each day
A person's weight on each birthday
Which of these is NOT discrete data:
Height of a sunflower as measured each day
How many students are absent from school each day
How many widgets a business sell each day
The number of people who drive through a red light each hour during rush hour
Daily rainfall is an example of what sort of data:
Discrete
Continuous
The distance that a cyclist rides each day is what sort of data:
Discrete
Continuous
The number of times that a cyclist rides over 45 km each day is what sort of data:
Discrete
Continuous
The number of avocadoes produced by my avocado tree each year is continuous data:
TRUE
FALSE
The average size of the avocado grown by my tree is continuous data:
TRUE
FALSE
The combined tonnage of mail passing each day through the local postal centre is discrete data:
TRUE
FALSE
