CSBI FINAL EXAM WITH ALL CORRECT & VERIFIED
ANSWERS (UPDATED TO PASS)
3 parts of data deluge Correct answer-variety, volume and velocity (NOT VARIANCE)
which of the following is not a component of a data warehouse?
-lightly summarized data
-current detail data
-metadata
-component key Correct answer-COMPONENT KEY
what are the five C's of data Correct answer-clean, consistent, conformed, current, and
comprehensive
data and information do not mean the same Correct answer-true
the BI road map allows functionalities to be completed in a single release Correct answer-FALSE
what risks do business people face with respect to expertise and experience while introducing new BI
technologies and analytical techniques? Correct answer-organizations will not have the expertise
in the new concepts and techniques to effectively use the new tools
which of these are not considered when targeting scope of a BI project
-data source feeds
-high-level business deliverables
-technology introduced
-leave requirements of BI team Correct answer-leave requirements of BI team
which is the best benefit to justify a BI solution Correct answer-revenue optimization
a BI road map can list projects with attributes of key business initiatives supported and business
process involved Correct answer-TRUE
the basic reason that BI projects fails and customers do not like the deliverable is Correct answer-
requirements analysis document was not done carefully
the business systems analyst should be able to Correct answer-understand the business model and
processes
in order to gather business requirements, you need to interview the BI developers Correct answer-
FALSE
if data shadow systems are found during the requirements process you should plan to Correct
answer-reverse-engineer or bottoms-up approach to scope out their value
when defining data quality requirements, you should keep in mind Correct answer-data quality
problems are often caused by conflicting data silos
the key topics in the requirements doc does NOT include
-success criteria
-team member job descriptions
, -data requirements
-business requirements Correct answer-Team member job descriptions
which of the following is not a primary deliverable for the set of requirements the team agrees upon
-list of people working on or assisting in documentation
-name of person responsible for training
-issues and concerns
-project assumptions Correct answer-Name of person responsible for training
which of the following is NOT preparation area for 'preparation for interview' of conducting
interview?
-background info on the enterprise and interviewees
-technical specification on mind of the end-user
-inviting participants and providing the information from your objective
-creating a list of subject areas and ideally specific questions to be covered in the interview Correct
answer-Technical specifications on mind of the end-users
tableau is one of the report designing tools used in BI Correct answer-TRUE
data warehouse architecture is based on Correct answer-RDBMS
defining the physical data models is the deliverable for which of the following architectural plans?
Correct answer-information
the information that describes how to access the data in its original native data storage is called
Correct answer-technical metadata
an application would be designated as the systems of record for accounting data Correct answer-
TRUE
one of the roles of the enterprise data warehouse is that is provides business information that has
been integrated and transformed to BI applications for business analysis. What is it called Correct
answer-System of Analytics
product architecture do not have to do anything with the technology requirements. They are just
business specifications Correct answer-FALSE
BI technical architecture is composed of four major functional layers. Which of the following is NOT
one of the layers of BI technical architecture
-Business integration
-data warehouse and BI data stores
-business intelligence (and analytical applications)
-data sources Correct answer-Business Integration
structured, unstructured, and semi-structured data need to be integrated on a real-time basis
Correct answer-TRUE
which on is NOT business analytics
-descriptive analytics
-predictive analytics
-prescriptive analytics
ANSWERS (UPDATED TO PASS)
3 parts of data deluge Correct answer-variety, volume and velocity (NOT VARIANCE)
which of the following is not a component of a data warehouse?
-lightly summarized data
-current detail data
-metadata
-component key Correct answer-COMPONENT KEY
what are the five C's of data Correct answer-clean, consistent, conformed, current, and
comprehensive
data and information do not mean the same Correct answer-true
the BI road map allows functionalities to be completed in a single release Correct answer-FALSE
what risks do business people face with respect to expertise and experience while introducing new BI
technologies and analytical techniques? Correct answer-organizations will not have the expertise
in the new concepts and techniques to effectively use the new tools
which of these are not considered when targeting scope of a BI project
-data source feeds
-high-level business deliverables
-technology introduced
-leave requirements of BI team Correct answer-leave requirements of BI team
which is the best benefit to justify a BI solution Correct answer-revenue optimization
a BI road map can list projects with attributes of key business initiatives supported and business
process involved Correct answer-TRUE
the basic reason that BI projects fails and customers do not like the deliverable is Correct answer-
requirements analysis document was not done carefully
the business systems analyst should be able to Correct answer-understand the business model and
processes
in order to gather business requirements, you need to interview the BI developers Correct answer-
FALSE
if data shadow systems are found during the requirements process you should plan to Correct
answer-reverse-engineer or bottoms-up approach to scope out their value
when defining data quality requirements, you should keep in mind Correct answer-data quality
problems are often caused by conflicting data silos
the key topics in the requirements doc does NOT include
-success criteria
-team member job descriptions
, -data requirements
-business requirements Correct answer-Team member job descriptions
which of the following is not a primary deliverable for the set of requirements the team agrees upon
-list of people working on or assisting in documentation
-name of person responsible for training
-issues and concerns
-project assumptions Correct answer-Name of person responsible for training
which of the following is NOT preparation area for 'preparation for interview' of conducting
interview?
-background info on the enterprise and interviewees
-technical specification on mind of the end-user
-inviting participants and providing the information from your objective
-creating a list of subject areas and ideally specific questions to be covered in the interview Correct
answer-Technical specifications on mind of the end-users
tableau is one of the report designing tools used in BI Correct answer-TRUE
data warehouse architecture is based on Correct answer-RDBMS
defining the physical data models is the deliverable for which of the following architectural plans?
Correct answer-information
the information that describes how to access the data in its original native data storage is called
Correct answer-technical metadata
an application would be designated as the systems of record for accounting data Correct answer-
TRUE
one of the roles of the enterprise data warehouse is that is provides business information that has
been integrated and transformed to BI applications for business analysis. What is it called Correct
answer-System of Analytics
product architecture do not have to do anything with the technology requirements. They are just
business specifications Correct answer-FALSE
BI technical architecture is composed of four major functional layers. Which of the following is NOT
one of the layers of BI technical architecture
-Business integration
-data warehouse and BI data stores
-business intelligence (and analytical applications)
-data sources Correct answer-Business Integration
structured, unstructured, and semi-structured data need to be integrated on a real-time basis
Correct answer-TRUE
which on is NOT business analytics
-descriptive analytics
-predictive analytics
-prescriptive analytics
