CACC 696 Exam Review Questions And
Answers
What are internal controls that prevent fraud? -
correct answer ✅1. Independent Verification
2. Transaction Authorization
3. Segregation of Duties
4. Supervision
5. Accounting Records
6. Access Control
What is segregation of duties? -
correct answer ✅Separating key operations to prevent one person
having control over critical processes
What does the Accounting Clerk Flowchart look like? -
correct answer ✅Daily Procedures -> End of Month Procedures
What is a data warehouse? -
correct answer ✅A relational database that can be accessed using
queries and other tools
Do companies separate data warehouses from operational databases? -
correct answer ✅Yes
, CACC 696 Exam Review Questions And
Answers
What are the purposes of data warehousing? -
correct answer ✅1. Optimize the business
2. Strategic benefit can be gained by sharing data externally
3. Able to provide customers with information quickly
4. Internet technologies and OLAP applications can share data
warehouse with trading departments
What are control issues with data warehouses? -
correct answer ✅1. Authorization of users at customer and supplier
sites
2. Users views
3. Access Privileges for outside users controlled by passwords
4. Internet Sessions should be secured using firewall, encryption and
digital signatures
5. Periodic Audits to assess the risk assessment and review of access
levels granted
What is the procedure of building a data warehouse? -
correct answer ✅1. Modeling the data in the data warehouse
2. Extracting data from operational databases
3. Cleansing extracted data
4. Transforming data into the warehouse model
5. Loading the data into the date warehouse database
Answers
What are internal controls that prevent fraud? -
correct answer ✅1. Independent Verification
2. Transaction Authorization
3. Segregation of Duties
4. Supervision
5. Accounting Records
6. Access Control
What is segregation of duties? -
correct answer ✅Separating key operations to prevent one person
having control over critical processes
What does the Accounting Clerk Flowchart look like? -
correct answer ✅Daily Procedures -> End of Month Procedures
What is a data warehouse? -
correct answer ✅A relational database that can be accessed using
queries and other tools
Do companies separate data warehouses from operational databases? -
correct answer ✅Yes
, CACC 696 Exam Review Questions And
Answers
What are the purposes of data warehousing? -
correct answer ✅1. Optimize the business
2. Strategic benefit can be gained by sharing data externally
3. Able to provide customers with information quickly
4. Internet technologies and OLAP applications can share data
warehouse with trading departments
What are control issues with data warehouses? -
correct answer ✅1. Authorization of users at customer and supplier
sites
2. Users views
3. Access Privileges for outside users controlled by passwords
4. Internet Sessions should be secured using firewall, encryption and
digital signatures
5. Periodic Audits to assess the risk assessment and review of access
levels granted
What is the procedure of building a data warehouse? -
correct answer ✅1. Modeling the data in the data warehouse
2. Extracting data from operational databases
3. Cleansing extracted data
4. Transforming data into the warehouse model
5. Loading the data into the date warehouse database
