When you want to perform simple queries on a single table.

When you are accessing associations (relationships) of multiple records to avoid N+1 queries.

When you want to optimize the speed of data access to the database.

Eager loading does not affect query performance.

To define a method that applies to all instances of a class.

To execute a block of code in the context of a specific instance, allowing access to instance variables and private methods.

To create a new instance of a class based on another instance.

To cast an object into another class type.

Data warehouse stores current data, while operational database stores historical data.

Data warehouse is optimized for analysis and reporting, while operational database is optimized for daily transactions.

Data warehouse uses a relational model, while operational database uses a NoSQL model.

Data warehouse only stores structured data, while operational database supports multiple data types

Data lake stores raw and diverse data formats (structured, semi-structured, unstructured) until needed for analysis, while data warehouse typically stores cleaned and transformed data in a predefined schema.

Data lake is a smaller version of data warehouse.

Data lake is used for real-time applications, whereas data warehouse is used for batch analytics.

Data lake is another term for data warehouse.

Extracting data from various sources.

Removing duplicates, handling missing values, and correcting formatting errors.

Loading transformed data into the target system.

Scheduling and monitoring ETL workflows.

Ensuring fast query performance.

Automatically detecting and correcting data errors.

Providing data visualization tools for end-users.

Establishing policies, processes, and responsibilities to ensure data quality, security, and compliance.

A technique for compressing data before loading it into a data warehouse.

A process that tracks and records changes (insert, update, delete) in the source database to continuously update the target data in near real-time.

A method for encrypting sensitive data during transmission.

A tool for generating automated data analysis reports.

Managing and scheduling ETL tasks and processes, ensuring they are executed in the correct order and timing.

Transforming data from one format to another.

Connecting to different data sources.

Monitoring the performance of data pipelines.

Speeding up data extraction.

Enabling the creation of flexible, configurable, maintainable, and scalable ETL processes based on data description information.

Reducing data storage costs.

Improving the user interface of ETL tools.