Question $2$: Metadata Management and Data Warehouse Infrastructure $(10$ Marks$)$

Scenario:

PQR Inc. has been facing challenges with managing their data warehouse due to inconsistent metadata and an aging infrastructure. This has led to difficulties in data retrieval, analysis, and overall system performance. They have decided to revamp their metadata management and upgrade their data warehouse infrastructure.

Questions:

$1.$ Improving Metadata Management:

a$)$ PQR Inc. plans to implement a centralized metadata repository. Describe how this repository could enhance data consistency and accessibility within the organization. $(3$ Marks$)$

b$)$ What types of metadata should PQR Inc. prioritize in their new system? Discuss two types and explain their significance in improving data warehouse operations. $(3$ Marks$)$

$2.$ Upgrading Data Warehouse Infrastructure:

a$)$ To modernize their infrastructure, PQR Inc. is considering using cloud services. Describe two benefits of integrating cloud services into their data warehouse infrastructure. $(2$ Marks$)$

b$)$ PQR Inc. is also concerned about ensuring the scalability of their new infrastructure. Propose a strategy that would allow them to scale their data warehouse as their data volumes increase. $(2$ Marks$)$