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