Data Transformation(ETL, ELT and ECL) — Learn free

Self-check

Questions 1–10 of 10

1. What does ECL stand for in data transformation?
Question 1A. Extract, Clean and LoadB. Extract, Compress and LoadC. Extract, Convert and LoadD. Encode, Convert and LinkE. Extract, Catalogue and Link
2. In ETL processing, where do the Extract, Transform and Load operations run?
Question 2A. All on the target systemB. Extract on the source, Transform and Load on the targetC. Extract and Transform on the target, Load on the sourceD. In a separate middleware serverE. All on the source system
3. In ELT processing, how many of the six operations run on the target system?
Question 3A. Four, including the resource-hungry TransformB. TwoC. All sixD. NoneE. Three
4. What is the first step of ELT processing?
Question 4A. Running the Transform on the sourceB. Extracting from the temp tableC. Loading data into the final tableD. Creating a temp table (DDL) in the target systemE. Deleting the source data
5. Which operation is described as the most resource-hungry in ETL or ELT processing?
Question 5A. ExtractB. TransformC. LoadD. DDLE. Select
6. In which field is ECL processing mainly used?
Question 6A. Data WarehousingB. Video processingC. Network monitoringD. Text AnalyticsE. Financial reconciliation
7. Which of the following is NOT within the scope of ECL processing?
Question 7A. Converting unstructured video, audio, scans or images into structured dataB. Reading text from Word documentsC. Reading text from PDF filesD. Cataloguing text by giving it tagsE. Loading tagged text into a target storage
8. Which tool vendors will always suggest having a Landing Area in the target system?
Question 8A. ECL tool vendorsB. Database vendorsC. ETL tool vendorsD. ELT tool vendorsE. BI tool vendors
9. How is Data Transformation described in relation to ETL developers and KPIs?
Question 9A. An optional step after reportingB. A security controlC. A form of data maskingD. A concern only for database administratorsE. The bread and butter of ETL developers and the starting point of any KPI
10. Which sequence of operations technically describes ELT processing?
Question 10A. E-T-LB. DDL-EL-ETLC. ECL-ETLD. T-E-LE. L-E-T