Quiz 9 - Transformation

data splitting and aggregation

Data transformation involves duplication and load data splitting and aggregation format changes and load format changes and encryption

specified source database

Extract function in ETL reads data from specified source database unknown database data mart data warehouse

Competitions' data

In data extraction process for an ETL tool, which of the following is not an example of legit data source? Competitions' data Customers' social media data Point of Sales data Online Line Transaction data

Data Warehouse

In loading phase of an ETL tool, the transformed data gets loaded into an end target usually the _______. Data warehouse Original Database Master data management Online analytical processing

Load

One of the processes in ETL is Treatment Transition Extend Load

Load

The final stage of an ETL process is: Data Analysis Load Extract Transform

Teradata

Which of the following is an ETL vendor? Teradata JMP Tableau MySQL

data quality

Which of the following is not a requirement for an ETL architecture? data integration data compliance data quality data security

Data extraction from ERP

Which of the following is not a standard practice in "Data Transformation" process of an ETL tool? Splitting data fields Data extraction from ERP Data aggregation Change of data format

Encrypting

Which of the following is not one of the processes involved in data cleaning? Encrypting Consolidating Parsing Matching