1. Analyze the purpose and benefits of high availability (‘HA’) and scalability.
a. Provide context of these in relation to data management.
b. Explain what terms are used to measure the effectiveness of each.
c. Explain why each is valuable and essential to database operations.
d. Explain how automatic failover is achieved and why it is beneficial to data management.
e. Provide an example of a database in an organization that are candidates for HA or
scalability.
f. What the impact of having HA and scalability solutions versus not?
2. Analyze the purpose and benefits of NoSQL systems
a. Provide context of NoSQL in relation to relational databases and data management.
b. Explain what the motivations are to develop NoSQL systems.
c. Explain why and how NoSQL is valuable and essential to data operations.
d. Provide an example of a business scenario that is a candidate for NoSQL solution
e. What the impact of having NoSQL solutions versus not?
3. Analyze the purpose and benefits of Data Warehouse systems/Business Intelligence
a. Provide context of Data Warehousing/BI in relation to relational databases, data
management and strategic decision-making.
b. Explain what the motivations were to develop data warehouse/BI systems.
c. Explain why and how Data Warehousing is valuable and essential to data operations.
d. Provide an example of a business scenario that best solved with a data warehouse
e. What the impact of having data warehousing solutions versus not?