Week 3 Test. Please respond to the following questions: 1. Compare data integration and ETL. How are they related? 2. List the differences and/or similarities between the roles of a database...

REPORT
1. Compare data integration and ETL. How are they related?
The act of combining different types of data sources under a single query able schema is referred to as "data integration," and it is done with the goal of achieving a unified retrieval of the data.
ETL is an abbreviation that stands for "extract," "transform," and "load." These are three different database tasks, but they are combined into one tool known as ETL. The goal of this tool is to take data from one database and store it in another database.
Extract, transform, and load, or ETL for short, is a kind of data integration that involves first extracting, then transforming, and finally loading data into a destination database or file.
2. List the differences and/or similarities between the roles of a database administrator and a data warehouse administrator.
It is the responsibility of the database administrator to translate concepts into local designs, while the data warehouse administrator is accountable for transforming logical databases into physically implemented designs.
The day-to-day operations of the database are not the responsibility of the database administrator, rather the warehouse administrator is accountable for such operations.
The parallels are broken out below.
Both of the administrators are putting in effort to complete the design.
Both the administrator and the administrator's assistant are required to work diligently on the organization's data.
3. Discuss security concerns involved in building a data warehouse.
When constructing a data warehouse or enhancing the safety of an existing one, there really are numerous crucial aspects that must be taken into consideration, including the following:
Mapping existing data. One should be able to categorise the data that is stored in your warehouse, know where critical data is kept, and determine who has access to it. This safety measure is essential for a number of reasons, including the minimization of potential dangers and ensuring adherence to a variety of requirements. This procedure is made more difficult by the fact that data storage might be dynamic.
Putting in place safeguards for access. Start with the correct authentication, which often involves integration with the SSO management of your business and could need extra rules that are restricted .
Authorization in the correct form....