Data warehousing Data Mart

Data warehousing Data Mart

1) Which of the following steps is used to make data marting cost-effective?
A) Identify the Functional Splits
B) Identify User Access Tool Requirements
C) Identify Access Control Issues
D) All mentioned above
View Answer / Hide Answer


2) We need to determine the business benefits and technical feasibility using a data mart.
A) Yes
B) No
View Answer / Hide Answer


3) The cost measures for data marting are.
A) Hardware and Software Cost
B) Network Access
C) Time Window Constraints
D) All mentioned above
View Answer / Hide Answer


4) Data marting is more expensive than aggregations, therefore it should be used as an
A) Additional strategy
B) Alternative strategy
C) Both A & B
D) None of the above
View Answer / Hide Answer


5) Data mart is created to partition data in order to impose access control strategies.
A) True
B) False
View Answer / Hide Answer


6) Why do we need a data mart?
A) To speed up the queries by reducing the volume of data to be scanned.
B) To segment data into different hardware platforms.
C) To structure data in a form suitable for a user access tool.
D) All mentioned above
View Answer / Hide Answer


7) Data marting is more expensive than aggregations, therefore it should be used as an additional strategy and not as an alternative strategy.
A) True
B) False
View Answer / Hide Answer


8) The determination of how many data marts are possible depends on:
A) Network capacity
B) Time window available
C) Volume of data being transferred
D) All the mentioned above
View Answer / Hide Answer


9) Which are able to cross over from one subject data mart to another automatically?
A) Aggregate awareness
B) Crossing subject areas
C) Integration
D) Overcoming SQL limitations
View Answer / Hide Answer


10) Which are responsible for ensuring that all data within the data warehouse (various data marts) are fully synchronized?
A) Data Integrity Specialist.
B) Data Correction Authority.
C) Data Consistency Expert
D) None of the above
View Answer / Hide Answer


11) The data Web house necessitates a nicely distributed architecture comprising small-scale data marts.
A) Yes
B) No
View Answer / Hide Answer


12) The life cycle of data marts may be complex in the long run, if their planning and design are not organization-wide.
A) True
B) False
View Answer / Hide Answer


13) In identifying the functional splits the retail organization sales forecast on ______________
A) Daily basis
B) Weekly basis
C) Both A & B
D) None of the above
View Answer / Hide Answer


14) In identifying the functional splits the retail organization stock movements on ___________
A) Daily basis
B) Weekly basis
C) Both A & B
D) None of the above
View Answer / Hide Answer


15) Consider a retail organization, where each merchant is accountable for maximizing the sales of a group of products. For this, the following are the valuable information:
1) Sales transaction on a weekly basis
2) Sales forecast on a daily basis
3) Stock position on a weekly basis
4) Stock movements on a weekly basis

A) True
B) False
View Answer / Hide Answer


16) We need to determine the business benefits and technical feasibility of using a data mart.
A) Yes
B) No
View Answer / Hide Answer