Domain 3: Processing

Question 1

What is the main goal of the Processing phase of Data Analytics?

Answer 1

• To transform the data and make it more consumable by the analytics and visualization tools.
• Choosing the right ETL tool based on workload requirements, performance, cost, and orchestration needs

Question 2

What are the goals of ETL?

Answer 2

ETL helps you transform, flatten, and enrich your data from source to target. The goal is to:

• Handle terabytes and petabytes of data
• Simplify querying disparate data sets
• Combine existing and legacy data with modern data sets
• Prepare data for machine learning

Question 3

What are some of the issues you face with ETL?

Answer 3

• Data volumes may grow
• Additional data sources may be added
• A large proportion of ETL is hand-coded
• Data formats may change over time
• Target schemas may change