Business Intelligence and CRM Systems Test Questions Fully Solved Latest 2025
Business intelligence - Answers Information systems that process data to identify patterns and trends
Data acquisition - Answers Obtaining, cleaning, organizing, and cataloging source data
BI analysis - Answers Creating business intelligence
Publish - Answers Delivering business intelligence to knowledge workers
Push - Answers Delivering business intelligence without user request
Data warehouse - Answers Facility for managing an organization's BI data
Data mart - Answers Data collection addressing the needs of a specific department
Data lake - Answers Central repository for raw unstructured data
Reporting analysis - Answers Sorting, grouping, summing, filtering, and formatting structured data
RFM analysis - Answers Ranking customers based on purchasing patterns
OLAP - Answers Performing arithmetic operations on groups of data
Drill down - Answers Dividing data into more detail
Data mining - Answers Finding patterns and relationships among data for classification and prediction
Unsupervised data mining - Answers Applying statistical techniques to data without creating a model
Cluster analysis - Answers Identifying groups of entities with similar characteristics
Supervised data mining - Answers Developing a model prior to analysis and estimating model
parameters
Regression analysis - Answers Measuring the effect of variables on another variable
Big Data - Answers Data collections characterized by volume, velocity, and variety
MapReduce - Answers Technique for parallel computing using multiple computers
Static reports - Answers Fixed BI documents that do not change
Dynamic reports - Answers Updated BI documents at the time of request
BI server - Answers Extends alert/RSS functionality for user subscriptions
AI - Answers Machine's ability to simulate human abilities for goal achievement
Artificial general intelligence - Answers Creating strong AI that can perform all human tasks
, CRM system - Answers Suite of applications and database for managing customer interactions
Dynamic processes - Answers Flexible and adaptive processes for strategic decisions
EAI - Answers Software suite for integrating existing systems
Information silo - Answers Isolated data in separated information systems
Enterprise resource planning - Answers Suite of applications for consolidating business operations
Process effectiveness - Answers Measure of how well a process achieves organizational strategy
Inter-enterprise processes - Answers Processes spanning multiple independent organizations
Structured processes - Answers Formally defined and standardized day-to-day operations
Customer life cycle - Answers Phases of marketing, acquisition, management, and loss/churn
Workgroup process - Answers Enabling groups to fulfill specific goals of a department
Organizational scope - Answers Three levels: workgroup, enterprise, and inter-enterprise
SAP - Answers Largest vendor of ERP solutions
What are business intelligence (BI) systems? - Answers Information systems that process data to identify
patterns and trends.
What are the three primary activities in the BI process? - Answers Acquiring data, analyzing data, and
publishing results.
How do organizations use data warehouses? - Answers To manage and store BI data.
What are data marts? - Answers Smaller data collections that address specific departmental needs.
What is the difference between data warehouses and data marts? - Answers Data warehouses are larger
and more comprehensive, while data marts are smaller and department-specific.
What is a data lake? - Answers A central repository for raw unstructured data.
What are the problems with operational data? - Answers Operational data may be inconsistent,
incomplete, or of poor quality.
What is reporting analysis? - Answers A technique used to analyze and rank customers based on their
purchasing patterns.
What is RFM analysis? - Answers A specific type of reporting analysis that considers recency, frequency,
and monetary value of customer orders.
Business intelligence - Answers Information systems that process data to identify patterns and trends
Data acquisition - Answers Obtaining, cleaning, organizing, and cataloging source data
BI analysis - Answers Creating business intelligence
Publish - Answers Delivering business intelligence to knowledge workers
Push - Answers Delivering business intelligence without user request
Data warehouse - Answers Facility for managing an organization's BI data
Data mart - Answers Data collection addressing the needs of a specific department
Data lake - Answers Central repository for raw unstructured data
Reporting analysis - Answers Sorting, grouping, summing, filtering, and formatting structured data
RFM analysis - Answers Ranking customers based on purchasing patterns
OLAP - Answers Performing arithmetic operations on groups of data
Drill down - Answers Dividing data into more detail
Data mining - Answers Finding patterns and relationships among data for classification and prediction
Unsupervised data mining - Answers Applying statistical techniques to data without creating a model
Cluster analysis - Answers Identifying groups of entities with similar characteristics
Supervised data mining - Answers Developing a model prior to analysis and estimating model
parameters
Regression analysis - Answers Measuring the effect of variables on another variable
Big Data - Answers Data collections characterized by volume, velocity, and variety
MapReduce - Answers Technique for parallel computing using multiple computers
Static reports - Answers Fixed BI documents that do not change
Dynamic reports - Answers Updated BI documents at the time of request
BI server - Answers Extends alert/RSS functionality for user subscriptions
AI - Answers Machine's ability to simulate human abilities for goal achievement
Artificial general intelligence - Answers Creating strong AI that can perform all human tasks
, CRM system - Answers Suite of applications and database for managing customer interactions
Dynamic processes - Answers Flexible and adaptive processes for strategic decisions
EAI - Answers Software suite for integrating existing systems
Information silo - Answers Isolated data in separated information systems
Enterprise resource planning - Answers Suite of applications for consolidating business operations
Process effectiveness - Answers Measure of how well a process achieves organizational strategy
Inter-enterprise processes - Answers Processes spanning multiple independent organizations
Structured processes - Answers Formally defined and standardized day-to-day operations
Customer life cycle - Answers Phases of marketing, acquisition, management, and loss/churn
Workgroup process - Answers Enabling groups to fulfill specific goals of a department
Organizational scope - Answers Three levels: workgroup, enterprise, and inter-enterprise
SAP - Answers Largest vendor of ERP solutions
What are business intelligence (BI) systems? - Answers Information systems that process data to identify
patterns and trends.
What are the three primary activities in the BI process? - Answers Acquiring data, analyzing data, and
publishing results.
How do organizations use data warehouses? - Answers To manage and store BI data.
What are data marts? - Answers Smaller data collections that address specific departmental needs.
What is the difference between data warehouses and data marts? - Answers Data warehouses are larger
and more comprehensive, while data marts are smaller and department-specific.
What is a data lake? - Answers A central repository for raw unstructured data.
What are the problems with operational data? - Answers Operational data may be inconsistent,
incomplete, or of poor quality.
What is reporting analysis? - Answers A technique used to analyze and rank customers based on their
purchasing patterns.
What is RFM analysis? - Answers A specific type of reporting analysis that considers recency, frequency,
and monetary value of customer orders.
