PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2025 paper

Module 1: Data Warehousing and Business Analysis

20252m

Which of the following is NOT a component of a data warehouse?

(i) Data Extraction Tools
(ii) Metadata Repository
(iii) Word Processing Tools
(iv) Data Cleaning Tools

Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iii) Word Processing Tools

The standard components of a data warehouse are all built around moving, cleaning, storing, and describing data:

Component Role
Data Extraction Tools Pull data from source/operational systems
Data Cleaning Tools Fix inconsistencies, remove noise/duplicates
Data Transformation Tools Convert data into the warehouse's target format
Load/Refresh Tools Populate the warehouse and keep it updated
Metadata Repository Stores "data about data" — schemas, mappings, lineage
OLAP Servers Support multidimensional query/analysis

Word Processing Tools are general office-productivity software (like MS Word) — they have no functional role in the ETL/warehouse pipeline, making (iii) the odd one out.

Similar questions

Data MiningWhich of the following is NOT a component of a data warehouse? (i) Metadata (ii) ETL tools (iii) OLAP (iv) Web server20242mData MiningWhich of the following does not involve in data mining? (i) Knowledge extraction (ii) Data archaeology (iii) Data exploration (iv) Data transformation20202mDATABASE MANAGEMENT SYSTEMWhich of the following refers to the “data about data”? - (i) Directory - (ii) Warehouse - (iii) Sub Data - (iv) Meta Data20242mData MiningWhich of the following is NOT a step in data preprocessing? (i) Data Cleaning (ii) Data Reduction (iii) Data Integration (iv) Data Encryption20252m
PreviousA Data Warehouse is generally built using which schema for decision support? (i) Hierarchical Schema (ii) Star or Snowflake Schema (iii) Relational Schema (iv) Network SchemaNextData Reduction aims to: (i) Delete irrelevant data (ii) Remove all missing data (iii) Increase data redundancy (iv) Reduce data volume but produce the same analysis results
Student FinanceWeb Platform

Pocketly — Personal Finance for Students

Keep your hostel and college expenses under control. Track accounts, log spending in seconds, and stay within your monthly budget.

Open Pocketly