WPC 300 Final (all accurately answered)

Extract, Transform, and Load (ETL) correct asnwers 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 asnwers specific business requirements data compliance data security data integration end user delivery interface data archiving alignment with overall enterprise architecture Extract correct asnwers gathering and cleansing data gather data correct asnwers 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 asnwers eliminate duplicates or fragmented data exclude unwanted information data cleansing reasons correct asnwers dummy variables missing data or absence of data multipurpose fields cryptic data personally identifiable info of customers dirty data due to entry error steps in data cleansing correct asnwers 1) parsing 2) correcting 3) standardizing 4)matching 5) consolidating transform (data transformation) correct asnwers format changes, deduplication, splitting up fields, replacement of codes, derived values, and aggregates aggregates correct asnwers often pre-calculated and stored in the warehouse to speed queries that require summary totals sample ETL tools correct asnwers teradata