WPC 300 Final| 136 Questions| With Complete Solutions
WPC 300 Final| 136 Questions| With Complete Solutions Extract, Transform, and Load (ETL) correct answer: Allows you to convert various data formats and types to adhere to one consistent system and migrate data into data warehouse a predefined process for accessing and manipulating the source data in loading it into a target database Requirements for an ETL architecture correct answer: specific business requirements data compliance data security data integration end user delivery interface data archiving alignment with overall enterprise architecture Extract correct answer: gathering and cleansing data gather data correct answer: raw data that is written directly into the disk primarily from legacy, operational systems data written to relational tables from structured source external data (mostly unstructured) often purchased from 3rd party cleansing data correct answer: eliminate duplicates or fragmented data
Written for
- Institution
-
Arizona State University
- Module
-
WPC 300
Document information
- Uploaded on
- June 6, 2023
- Number of pages
- 20
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- wpc 300 final
-
wpc 300 final| 136 questions| with complete soluti
Also available in package deal