DATA WAREHOUSING PRELIM EXAM PART 1

What is a common method for data extraction from databases?

• Using pandas

• JDBC

• Informatica

Which method is NOT typically used for data transformation?

• Handling missing values

• Removing duplicates

• Inner joins

Which technique is NOT used for data cleaning?

• Imputation

• Standardizing data

• Temporal filtering

What is a key aspect of data loading using staging tables?

• It involves inserting data into a database in small batches

• Staging tables are permanent storage structures

• Staging tables are used for preprocessing and validating data

Which tool is NOT used for data extraction?

• Talend

• SSIS

• tidyverse

What is NOT a part of data transformation?

• Filtering

• Aggregation

• Bulk loading

What does incremental loading involve?

• Reloading the entire dataset each time new data is added

• Adding new or updated data without reloading the entire dataset

• Loading data without any preprocessing steps

Which method is NOT used for data extraction?

• Scripting

• Cleaning

• Connectors

What is the purpose of filtering in data transformation?

• Converting data types

• Standardizing date and time representations

• Selecting relevant subsets of data based on specific conditions

Which join type combines datasets based on all available data?

• Inner join

• Outer join

• Left join