PyQdeck LogoPyQdeckSubjects
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 MiningA Data Warehouse is generally built using which schema for decision support? (i) Hierarchical Schema (ii) Star or Snowflake Schema (iii) Relational Schema (iv) Network Schema20252mDATABASE 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 does not involve in data mining? (i) Knowledge extraction (ii) Data archaeology (iii) Data exploration (iv) Data transformation20202mData MiningWhat is OLAP? Explain the main components of a Data Warehouse system.20257m
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