DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Store data
|
|
|
Analyse Data
|
|
|
Clean Data
|
|
|
Retrieve Data
|
Detailed explanation-1: -A data access layer (DAL) in computer software is a layer of a computer program which provides simplified access to data stored in persistent storage of some kind, such as an entity-relational database. This acronym is prevalently used in Microsoft environments.
Detailed explanation-2: -The access layer, which is the lowest level of the Cisco three tier network model, ensures that packets are delivered to end user devices. This layer is sometimes referred to as the desktop layer, because it focuses on connecting client nodes to the network.
Detailed explanation-3: -Extract: The first stage in the ETL process is to extract data from various sources such as transactional systems, spreadsheets, and flat files.
Detailed explanation-4: -Answer-D) The data is stored, retrieved, and updated in OLTP.
Detailed explanation-5: -The typical extract, transform, load (ETL)-based data warehouse uses staging, data integration, and access layers to house its key functions. The staging layer or staging database stores raw data extracted from each of the disparate source data systems.