CSBI - CERTIFIED SPECIALIST BUSINESS INTELLIGENCE EXAM READY
- VERIFIED QUESTIONS AND ANSWERS - COMPREHENSIVE LATEST
VERSION
**Q1. What is Business Intelligence (BI)?**
ANSWER Business Intelligence is a technology-driven process for analyzing
data and presenting actionable information to help executives, managers, and
other corporate end users make informed business decisions.
**Q2. What are the key components of a BI system?**
ANSWER The key components are: Data Sources, ETL (Extract, Transform,
Load), Data Warehouse, OLAP, Data Mining, and Reporting/Dashboard tools.
**Q3. What is the difference between BI and Business Analytics?**
ANSWER BI focuses on descriptive and diagnostic analytics (what happened
and why), while Business Analytics includes predictive and prescriptive
analytics (what will happen and what should we do).
**Q4. What is a Data Warehouse?**
ANSWER A Data Warehouse is a centralized repository that stores integrated
data from multiple sources, optimized for reporting and analysis rather than
transaction processing.
**Q5. What are the characteristics of a Data Warehouse according to Bill
Inmon?**
ANSWER Subject-oriented, Integrated, Time-variant, and Non-volatile (SITV).
**Q6. What is the difference between OLTP and OLAP?**
,ANSWER OLTP (Online Transaction Processing) handles day-to-day operations
with normalized data. OLAP (Online Analytical Processing) supports complex
analysis with denormalized, aggregated data.
**Q7. What is ETL?**
ANSWER ETL stands for Extract, Transform, Load - the process of extracting
data from source systems, transforming it to fit operational needs, and loading
it into the target data warehouse.
**Q8. What is ELT and how does it differ from ETL?**
ANSWER ELT (Extract, Load, Transform) loads raw data first and transforms it
within the target system. It leverages the processing power of modern data
warehouses like Snowflake or BigQuery.
**Q9. What is a Star Schema?**
ANSWER A Star Schema is a dimensional data model with a central fact table
surrounded by denormalized dimension tables, resembling a star shape.
**Q10. What is a Snowflake Schema?**
ANSWER A Snowflake Schema is a normalized version of the Star Schema
where dimension tables are further broken down into sub-dimensions,
reducing redundancy but increasing complexity.
**Q11. What is a Fact Table?**
ANSWER A Fact Table contains quantitative metrics (measures) and foreign
keys to dimension tables. It represents business events or transactions.
**Q12. What is a Dimension Table?**
ANSWER A Dimension Table contains descriptive attributes that provide
context to the facts, such as time, geography, product, or customer details.
,**Q13. What is a Slowly Changing Dimension (SCD)?**
ANSWER SCD refers to dimensions that change over time. Type 1 overwrites,
Type 2 maintains history with versioning, and Type 3 keeps limited history with
additional columns.
**Q14. What is a Surrogate Key?**
ANSWER A Surrogate Key is an artificial primary key used in dimension tables,
typically an auto-incrementing integer, independent of business meaning.
**Q15. What is a Natural Key?**
ANSWER A Natural Key is a primary key that has business meaning and exists
in the source system, such as a Product ID or Customer Number.
**Q16. What is Data Mining?**
ANSWER Data Mining is the process of discovering patterns, correlations, and
insights from large datasets using statistical and machine learning techniques.
**Q17. What is a KPI (Key Performance Indicator)?**
ANSWER A KPI is a measurable value that demonstrates how effectively an
organization is achieving key business objectives.
**Q18. What is a Dashboard?**
ANSWER A Dashboard is a visual display of the most important information
needed to achieve one or more objectives, consolidated on a single screen.
**Q19. What is the difference between a Dashboard and a Report?**
, ANSWER A Dashboard provides at-a-glance real-time or near-real-time visual
summaries, while a Report is typically more detailed, static, and formatted for
distribution.
**Q20. What is Self-Service BI?**
ANSWER Self-Service BI enables business users to access and analyze data
without heavy reliance on IT, using intuitive tools like Power BI, Tableau, or
Qlik.
**Q21. What is Data Governance?**
ANSWER Data Governance is the overall management of data availability,
usability, integrity, and security in an enterprise.
**Q22. What is Master Data Management (MDM)?**
ANSWER MDM is a method of managing an organization's critical data (master
data) to provide a single point of reference, ensuring consistency and accuracy.
**Q23. What is Data Quality?**
ANSWER Data Quality refers to the condition of data based on factors like
accuracy, completeness, consistency, timeliness, validity, and uniqueness.
**Q24. What is a Data Mart?**
ANSWER A Data Mart is a subset of a data warehouse focused on a specific
business line, department, or subject area.
**Q25. What is the difference between a Data Warehouse and a Data Lake?**
ANSWER A Data Warehouse stores structured, processed data for BI. A Data
Lake stores raw, unstructured, and semi-structured data in native format for
advanced analytics and ML.
- VERIFIED QUESTIONS AND ANSWERS - COMPREHENSIVE LATEST
VERSION
**Q1. What is Business Intelligence (BI)?**
ANSWER Business Intelligence is a technology-driven process for analyzing
data and presenting actionable information to help executives, managers, and
other corporate end users make informed business decisions.
**Q2. What are the key components of a BI system?**
ANSWER The key components are: Data Sources, ETL (Extract, Transform,
Load), Data Warehouse, OLAP, Data Mining, and Reporting/Dashboard tools.
**Q3. What is the difference between BI and Business Analytics?**
ANSWER BI focuses on descriptive and diagnostic analytics (what happened
and why), while Business Analytics includes predictive and prescriptive
analytics (what will happen and what should we do).
**Q4. What is a Data Warehouse?**
ANSWER A Data Warehouse is a centralized repository that stores integrated
data from multiple sources, optimized for reporting and analysis rather than
transaction processing.
**Q5. What are the characteristics of a Data Warehouse according to Bill
Inmon?**
ANSWER Subject-oriented, Integrated, Time-variant, and Non-volatile (SITV).
**Q6. What is the difference between OLTP and OLAP?**
,ANSWER OLTP (Online Transaction Processing) handles day-to-day operations
with normalized data. OLAP (Online Analytical Processing) supports complex
analysis with denormalized, aggregated data.
**Q7. What is ETL?**
ANSWER ETL stands for Extract, Transform, Load - the process of extracting
data from source systems, transforming it to fit operational needs, and loading
it into the target data warehouse.
**Q8. What is ELT and how does it differ from ETL?**
ANSWER ELT (Extract, Load, Transform) loads raw data first and transforms it
within the target system. It leverages the processing power of modern data
warehouses like Snowflake or BigQuery.
**Q9. What is a Star Schema?**
ANSWER A Star Schema is a dimensional data model with a central fact table
surrounded by denormalized dimension tables, resembling a star shape.
**Q10. What is a Snowflake Schema?**
ANSWER A Snowflake Schema is a normalized version of the Star Schema
where dimension tables are further broken down into sub-dimensions,
reducing redundancy but increasing complexity.
**Q11. What is a Fact Table?**
ANSWER A Fact Table contains quantitative metrics (measures) and foreign
keys to dimension tables. It represents business events or transactions.
**Q12. What is a Dimension Table?**
ANSWER A Dimension Table contains descriptive attributes that provide
context to the facts, such as time, geography, product, or customer details.
,**Q13. What is a Slowly Changing Dimension (SCD)?**
ANSWER SCD refers to dimensions that change over time. Type 1 overwrites,
Type 2 maintains history with versioning, and Type 3 keeps limited history with
additional columns.
**Q14. What is a Surrogate Key?**
ANSWER A Surrogate Key is an artificial primary key used in dimension tables,
typically an auto-incrementing integer, independent of business meaning.
**Q15. What is a Natural Key?**
ANSWER A Natural Key is a primary key that has business meaning and exists
in the source system, such as a Product ID or Customer Number.
**Q16. What is Data Mining?**
ANSWER Data Mining is the process of discovering patterns, correlations, and
insights from large datasets using statistical and machine learning techniques.
**Q17. What is a KPI (Key Performance Indicator)?**
ANSWER A KPI is a measurable value that demonstrates how effectively an
organization is achieving key business objectives.
**Q18. What is a Dashboard?**
ANSWER A Dashboard is a visual display of the most important information
needed to achieve one or more objectives, consolidated on a single screen.
**Q19. What is the difference between a Dashboard and a Report?**
, ANSWER A Dashboard provides at-a-glance real-time or near-real-time visual
summaries, while a Report is typically more detailed, static, and formatted for
distribution.
**Q20. What is Self-Service BI?**
ANSWER Self-Service BI enables business users to access and analyze data
without heavy reliance on IT, using intuitive tools like Power BI, Tableau, or
Qlik.
**Q21. What is Data Governance?**
ANSWER Data Governance is the overall management of data availability,
usability, integrity, and security in an enterprise.
**Q22. What is Master Data Management (MDM)?**
ANSWER MDM is a method of managing an organization's critical data (master
data) to provide a single point of reference, ensuring consistency and accuracy.
**Q23. What is Data Quality?**
ANSWER Data Quality refers to the condition of data based on factors like
accuracy, completeness, consistency, timeliness, validity, and uniqueness.
**Q24. What is a Data Mart?**
ANSWER A Data Mart is a subset of a data warehouse focused on a specific
business line, department, or subject area.
**Q25. What is the difference between a Data Warehouse and a Data Lake?**
ANSWER A Data Warehouse stores structured, processed data for BI. A Data
Lake stores raw, unstructured, and semi-structured data in native format for
advanced analytics and ML.
