Question: Identify the data warehouse architecture by matching the term with the definition. Group of answer choices ETL manager Mainframe, departmental data, private data, external data
Identify the data warehouse architecture by matching the term with the definition.
Group of answer choices
ETL manager
Mainframe, departmental data, private data, external data
Warehouse manager
A repository of current and integrated data used for analysis
Query manager
This data is not generally stored online, but is made available by aggregation
Metadata
Copies of the data kept for a retention period
Enduser access tools
Performs all the operations associated with the copying of data into the warehouse
Operational data
Tools used for reporting, querying, development, OLAP, and data mining
Operational data store
Performs all operations associated with user digital access requests for data
Detailed data
Predefined aggregations of data generated by the warehouse manager
Lightly and highly summrized data
Analysis, transformation, merging of data, creation of indexes, denormalizations, aggregations, backup, and archiving
ArchiveBackup data
Definitions of the data elements
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
