Data Engineering UNIT-II

What is the first step in the Data Engineering Life Cycle?

• Data Storage

• Data Collection

• Data Analysis

• Data Visualization

Which of the following is a key task in data cleaning?

• Normalizing data

• Identifying missing values

• Removing duplicates

• All of the above

What is the purpose of ETL (Extract, Transform, Load) in data engineering?

• To visualize data

• To migrate raw data into a usable format

• To create machine learning models

• To delete old data

Which tool is commonly used for distributed data storage?

• MySQL

• Hadoop

• Excel

• Tableau

What is the role of a data pipeline in the data engineering process?

• To visualize data

• To automate the flow of data between systems

• To delete redundant data

• To perform real-time data backups

What is the main purpose of data normalization?

• To increase data redundancy

• To reduce data anomalies

• To store data in multiple formats

• To enhance data visualization

Which of the following is a common data format used in data engineering?

• CSV

• HTML

• XML

• All of the above

What is the function of a data warehouse?

• To visualize data trends

• To store large volumes of historical data

• To perform real-time data processing

• To clean and prepare data

What is the primary benefit of using a cloud-based data warehouse?

• Lower operational costs

• Scalability and flexibility

• Faster data retrieval

• Increased data security

Which programming language is widely used for data manipulation in data engineering?

• Java

• Python

• C++

• Ruby