BAN Exam 2 Questions & Answers
2024/2025
Which of the following is not a consideration at the program/project planning step? - ANSWERSselecting
database software
True or False: Application developers and business representatives should be involved when design
standards are developed. - ANSWERSTrue
Which of the following staff positions is responsible for determining the business needs and translating
them into architectural, data, and BI application requirements? - ANSWERSBusiness Analyst
True or False: It is often times helpful to begin the BI application development before the first ETL
process concludes.. - ANSWERSTrue
True or False: Documentation is usually unnecessary when collecting the business requirements of a data
warehouse. - ANSWERSFalse
Which of the following is the last step in the dimensional modeling process flow? - ANSWERSFinal Design
Documentation
Between which two steps in the dimensional modeling process flow is it necessary to iterate and test? -
ANSWERSDetailed dimensional model development and model and review validation
At which stage of the dimensional modeling process should slowly changing dimension techniques be
identified? - ANSWERSDetailed dimensional model development
Which of the following is not a step in the development of a detailed dimensional model? -
ANSWERSIdentify a business sponsor
2024/2025
Which of the following is not a consideration at the program/project planning step? - ANSWERSselecting
database software
True or False: Application developers and business representatives should be involved when design
standards are developed. - ANSWERSTrue
Which of the following staff positions is responsible for determining the business needs and translating
them into architectural, data, and BI application requirements? - ANSWERSBusiness Analyst
True or False: It is often times helpful to begin the BI application development before the first ETL
process concludes.. - ANSWERSTrue
True or False: Documentation is usually unnecessary when collecting the business requirements of a data
warehouse. - ANSWERSFalse
Which of the following is the last step in the dimensional modeling process flow? - ANSWERSFinal Design
Documentation
Between which two steps in the dimensional modeling process flow is it necessary to iterate and test? -
ANSWERSDetailed dimensional model development and model and review validation
At which stage of the dimensional modeling process should slowly changing dimension techniques be
identified? - ANSWERSDetailed dimensional model development
Which of the following is not a step in the development of a detailed dimensional model? -
ANSWERSIdentify a business sponsor
