ITSS 4351 - EXAM REVIEW || with Errorless Solutions
100%.
What is the definition of Business Intelligence? correct answers using data to make informed
business decisions
Need for BI (Business Intelligence) and how it helps the business. correct answers Business
intelligence (BI) - data analytics that involves gathering, analyzing, and presenting data visually.
help inform and improve business decision-making by making data easier to interpret and act on.
What are the drivers of Business Intelligence Growth in the industry correct answers - Data
Explosion
- Competitive Advantage
- Real-time Analytics
- Self-Service BI
- Cloud Computing
- AI and Machine Learning
- Regulatory Compliance and Risk Management
- Evolving Visualization and Reporting Capabilities
Understanding of BI Architecture correct answers standards and policies for organizing data with
the help of computer-based techniques and technologies that create business intelligence systems
used for online data visualization, reporting, and analysis
4 components are data warehouse, business analytics, business performance management and
user interface
Various components of BI like Data warehouse, ETL, etc. correct answers The five layers are
data source, ETL (Extract-Transform-Load), data warehouse, end user, and metadata layers. The
rest of this section describes each of the layers.
Popular tools used for BI. correct answers Dashboards.
Visualizations.
Reporting.
Predictive Analytics.
Data Mining.
ETL.
OLAP.
Drill-Down.
What are the Operational Sources in BI? correct answers primary data repositories or systems
from which data is collected and processed for analysis and reporting
, Understanding of Data Analytics Techniques correct answers process of collecting, cleaning,
sorting, and processing raw data to extract relevant and valuable information to help businesses.
What are the different types of Data Mining? correct answers clustering,
data cleaning,
association,
data warehousing,
machine learning,
data visualization,
classification,
neural networks,
prediction.
Describe the Business Intelligence Process correct answers Gathering data and organizing it
through reporting
Data Warehouse - ETL correct answers Data Warehouse - ETL
What is a data warehouse? correct answers a facility for managing an organization's BI data
Few characteristics of a Data warehouse correct answers Are often deployed as a central
database for the enterprise.
Provide ETL (extract, transform, load) data processing capability. ...
Store metadata.
Include access to reporting tools.
data warehouse components correct answers -Source Systems (operational databases)
-Extraction-Transformation-Load (ETL) Infrastructure
-Data Warehouse
-Front-End (BI) applications
What are the types of architecture available for the data warehouse? correct answers single-tier,
two-tier and three-tier data warehouses
What is the consideration for a different database used in the data warehouse? correct answers
Help ensure that the chosen database aligns with the requirements of the data warehousing
environment and facilitates efficient data processing, storage, and analysis
advantages and disadvantages of each architecture type correct answers Single-Tier Architecture:
Simplicity, Cost-Effective, Performance.
Two-Tier Architecture: Improved Performance, Scalability, Fault Tolerance
Three-Tier Architecture: Scalability and Performance, Flexibility, Enhanced Fault Tolerance
Name a few factors that affect architectural decisions. correct answers Functional Requirements,
100%.
What is the definition of Business Intelligence? correct answers using data to make informed
business decisions
Need for BI (Business Intelligence) and how it helps the business. correct answers Business
intelligence (BI) - data analytics that involves gathering, analyzing, and presenting data visually.
help inform and improve business decision-making by making data easier to interpret and act on.
What are the drivers of Business Intelligence Growth in the industry correct answers - Data
Explosion
- Competitive Advantage
- Real-time Analytics
- Self-Service BI
- Cloud Computing
- AI and Machine Learning
- Regulatory Compliance and Risk Management
- Evolving Visualization and Reporting Capabilities
Understanding of BI Architecture correct answers standards and policies for organizing data with
the help of computer-based techniques and technologies that create business intelligence systems
used for online data visualization, reporting, and analysis
4 components are data warehouse, business analytics, business performance management and
user interface
Various components of BI like Data warehouse, ETL, etc. correct answers The five layers are
data source, ETL (Extract-Transform-Load), data warehouse, end user, and metadata layers. The
rest of this section describes each of the layers.
Popular tools used for BI. correct answers Dashboards.
Visualizations.
Reporting.
Predictive Analytics.
Data Mining.
ETL.
OLAP.
Drill-Down.
What are the Operational Sources in BI? correct answers primary data repositories or systems
from which data is collected and processed for analysis and reporting
, Understanding of Data Analytics Techniques correct answers process of collecting, cleaning,
sorting, and processing raw data to extract relevant and valuable information to help businesses.
What are the different types of Data Mining? correct answers clustering,
data cleaning,
association,
data warehousing,
machine learning,
data visualization,
classification,
neural networks,
prediction.
Describe the Business Intelligence Process correct answers Gathering data and organizing it
through reporting
Data Warehouse - ETL correct answers Data Warehouse - ETL
What is a data warehouse? correct answers a facility for managing an organization's BI data
Few characteristics of a Data warehouse correct answers Are often deployed as a central
database for the enterprise.
Provide ETL (extract, transform, load) data processing capability. ...
Store metadata.
Include access to reporting tools.
data warehouse components correct answers -Source Systems (operational databases)
-Extraction-Transformation-Load (ETL) Infrastructure
-Data Warehouse
-Front-End (BI) applications
What are the types of architecture available for the data warehouse? correct answers single-tier,
two-tier and three-tier data warehouses
What is the consideration for a different database used in the data warehouse? correct answers
Help ensure that the chosen database aligns with the requirements of the data warehousing
environment and facilitates efficient data processing, storage, and analysis
advantages and disadvantages of each architecture type correct answers Single-Tier Architecture:
Simplicity, Cost-Effective, Performance.
Two-Tier Architecture: Improved Performance, Scalability, Fault Tolerance
Three-Tier Architecture: Scalability and Performance, Flexibility, Enhanced Fault Tolerance
Name a few factors that affect architectural decisions. correct answers Functional Requirements,
