MCQ Bank
A company collects customer data from sales, marketing, and finance departments into a single repository for analysis. Which characteristic of a Data Warehouse is demonstrated?
- A) Fragmentation
- B) Duplication
- C) Integration
- D) Volatility
A company wants to analyze customer reviews. Before applying sentiment analysis, what should be done first?
- A) Regression
- B) Clustering
- C) Classification
- D) Text Preprocessing
Which process is commonly used to transfer data into a Data Warehouse?
- A) Compilation
- B) ETL
- C) CRUD
- D) SQL Injection
A sentiment analysis system receives the text: "The movie was AMAZING!!!" Which preprocessing step would help standardize the word "AMAZING"?
- A) Lowercasing
- B) Clustering
- C) Regression
- D) Classification
What is the primary purpose of a Data Warehouse?
- A) To process daily transactions
- B) To manage computer hardware
- C) To support decision-making through data analysis
- D) To store temporary files
A retail company wants to analyze sales data collected over the last five years from different branches. Which system would be most suitable for this purpose?
- A) Transaction Processing System (TPS)
- B) Data Warehouse
- C) Operating System
- D) Database Management System
A manager wants to compare yearly sales trends over the past ten years. Which Data Warehouse characteristic supports this requirement?
- A) Dynamic
- B) Time-Variant
- C) Subject-Oriented
- D) Volatile
Which of the following is a text preprocessing technique used to split text into individual words?
- A) Stemming
- B) Lemmatization
- C) Classification
- D) Tokenization
What is the main purpose of removing stop words during text preprocessing?
- A) To improve processing efficiency by removing common words
- B) To classify text automatically
- C) To increase document size
- D) To add more keywords
Which preprocessing technique converts words such as "running," "runs," and "runner" to their root form?
- A) Tokenization
- B) Stop Word Removal
- C) Parsing
- D) Stemming