ETLT — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. What does ETLT stand for?
Question 1A. Extract, Test, Load and TransferB. Extract, Transform, Load and TransformC. Encode, Transmit, Log and TrackD. Extract, Transfer, Link and TagE. Evaluate, Train, Learn and Test
2. What does the Extract step of ETLT involve?
Question 2A. Extracting data from various sources such as databases, applications, logs or other systemsB. Cleaning and normalising dataC. Loading data into a target warehouseD. Building a semantic layerE. Generating reports for management
3. What is the purpose of the first Transform in ETLT?
Question 3A. Loading data into the targetB. Archiving old dataC. Cleaning, structuring and enriching the extracted data so it is suitable for analysisD. Deleting duplicate sourcesE. Encrypting the target database
4. What does the Load step of ETLT involve?
Question 4A. Reading logs from the sourceB. Cleaning the extracted recordsC. Enriching data with external sourcesD. Loading the transformed data into a target database or data warehouse for reporting and analysisE. Removing the semantic layer
5. Where does the second Transform of ETLT take place?
Question 5A. Before extraction beginsB. Inside the source systemsC. During the network transferD. In the landing zone before stagingE. After the data has been loaded into the target system
6. What additional purpose does the extra stage in ETLT serve within the ETL world?
Question 6A. Supporting semantic layersB. Replacing the extract stepC. Removing the need for a data warehouseD. Encrypting source systemsE. Eliminating data cleansing
7. What idea does ETLT emphasise about data integration and transformation?
Question 7A. That it should be done once and never repeatedB. That it is an ongoing, iterative process rather than a one-time eventC. That it must always happen before loadingD. That it only applies to batch systemsE. That it should be handled by business users
8. In which kind of architecture is the ETLT approach described as especially relevant?
Question 8A. Paper-based archivesB. Single-user desktop toolsC. Modern data architectures where real-time or near-real-time processing is increasingly importantD. Mainframe batch systems from the 1980sE. Standalone spreadsheets
9. Which of the following is NOT one of the operations listed under the first Transform of ETLT?
Question 9A. Data cleansingB. NormalisationC. AggregationD. Extraction from source logsE. Enrichment
10. How is ETLT described relative to the usual ETL process?
Question 10A. As a competing process that replaces ETL entirelyB. As a synonym for ELTC. As a process with no loading stepD. As an older technique that predates ETLE. As a helpful addition to ETL that makes data even more useful and organised