Studied by 4 people
Which of the following diagrams most accurately illustrates an information system?
Design > Prototype > Feedback > User
Design > Build > Test > Implement
Input > Process > Storage > Output
Economic Event > Journal > Ledger > Financial Report
Input > Process > Storage > Output
The primary transformation of data into information takes place in which of the following activities?
Input
Storage
Processing
Output
Processing
A simple information system includes all of the following elements except
Processing
Storage
Input
Reporting
Reporting
The Information Value Chain is defined as:
The flow of materials, information, payments, and services
The use of computer technology to provide information about business activities to employees across the firm
The overall transformation of data from a business need to the ultimate decision
A centralized database that collects data throughout the firm
The overall transformation of data from a business need to the ultimate decision
The role of accountants in an accounting information system include all of the following except
User
Manager
Coder
Evaluator
Coder
The correct order of effects in the value chain are
Inbound logistics > operations > service
inbound logistics > outbound logistics > marketing & sales
inbound logistics > operations > outbound logistics
inbound logistics > operations > shipping
inbound logistics > operations > outbound logistics
One of the most important wats that ERPs benefit organizations and their business processes is:
Current information is made available to all users involved in the activities and decisions associated with a company’s business processes
Information is stored in many specialized, distributed databases that each serve separate business processes
Reducing the amount of time to complete business processes by eliminating all controls associated with the processes
Preventing external business partners from accessing the orgnaization’s data
Current information is made available to all users involved in the activities and decisions associated with a company’s business processes
A supply chain system does not include information about:
Current customers
Prospective customers
Availability of inventory
Current suppliers
Prospective customers
Many fast food restaurants now have kiosks where customers can order without speaking to an employee. This is an example of
automate
informate-up
transform
informate-down
automate
The income statements account most likely affected by an AIS investment in customer relationship managements would be
Revnues
COGS
Selling, general and administrative expenses
Unearned revenue
Revenues
Which of the following is NOT a type of data model discussed in our material
Normalization data model Network data model Relational data model Hierarchical data model
Normalization data model
What kind of data model is most commonly used as a basis for today's enterprise systems?
The normalization model
The network model
The relational model
The hierarchical model
The relational model
Which of the following is NOT a construct in a relational database?
Records
Attributes
Tables
Forms
Forms
Which of the following items can best be described as a "Resource" in the REA data model?
Purchase
Sales
Cashier
Cash
Cash
Which of the following items can best be described as an "Event" in the REA data model?
Cash
Cashier
Customer
Cash Collection
Cash Collection
Which of the following about SQL is INCORRECT?
SQL is a language designed to query data in a relational database
SQL is based on relational algebra and allows a user to query and update the database
SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query
SQL uses the PIVOT function to insert data
SQL uses the PIVOT function to insert data
Which of the following about cloud computing is INCORRECT?
Data stored in a cloud computing system is always secure
If the internet connection goes down the system will not function
Cloud computing is internet-based computing where shared resources, software, and information are provided to firms on demand
Cloud computing can easily hosts enterprise system applications
Data stored in a cloud computing system is always secure
Which of the following is a correct statement about primary keys?
A primary cannot be used in another table as a foreign key
Most tables in a database may not require primary keys
The data values of a primary key must be different (i.e., unique)
A primary is always another table's foreign key
The data values of a primary key must be different (i.e., unique)
Which of the following is a correct statement about foreign keys?
An attribute cannot be a foreign key used in different tables
Most foreign keys should not have any data values
A foreign key must be another table's primary key
All foreign keys cannot not be blank (null)
A foreign key must be another table's primary key
Name and describe 1 of the 7 ways cloud ERP helps organizations build resilience and agility. From the Oracle NetSuite White paper we discussed in class.
Cloud ERP helps organizations build resilience and agility by allowing remote work. This allows the employees to not need to be on-site to access internal databases, and they can access them remotely. It also utilizes internal controls halt any possible deceptions from employees. This overall increases the productivity and efficiency of the organization.
Which of the following best described the difference between access controls and application controls?
Access controls limit how many records can be changed and application controls ensure segregation of data
Access controls are “prohibited” business roles and application controls are “allowed” business rules
Access controls limit who can change records and application controls ensures data integrity and provide an audit trail of any changes
There is no difference between access and application controls
Access controls limit who can change records and application controls ensures data integrity and provide an audit trail of any changes
Business rules are an example of which COSO concept
Internal control
activity models
control environment
control activites
control activities
Sales order 1..* 0..* Cash Receipts
A new table will be created that contains both sales order ID and Cash Receipt ID as its composite primary key
Which of the following best describes the purpose of an intermediate error event
Shows the interchange between two pools
Depicts the sequence of activities in one pool
Illustrates the process flow when an exception occurs
Contains a series of activities that are hidden from view
Illustrates the process flow when an exception occurs
Which of the following best describes the purpose of a BPMN collapsed sub-process
A series of events is hidden from view as the information is not necessary to the model
The collapsed process will be modeled at a later time
A series of events is hidden from view as the information is not well controlled
The collapsed process contains too many errors
A series of events is hidden from view as the information is not necessary to the model
Which of the following events is generally not impacted as part of the sales and collections process
Accounts payable
Cash
Accounts recievable
Inventory
Accounts payable
Which of the following is not an example of a business rule?
Inventory must be maintained in a secure location
Employee who receives checks can not change invoices
Managers must approve orders over $10,000
The credit department must approve all sales on account
Inventory must be maintained in a secure location
Which of the following best describes the choreography in a BPMN activity diagram
Hides the activities that are not of interest in the analysis of business process
Follows the sequence of flow from start to end
Shows the interaction of messages between participants in the business process
Shows the sequence of activities within one pool
Shows the interaction of messages between participants in the business process
Product categories 0..* 1..1 Employees
Each product category has one manager or employee can have 0 to many product categories
Products 1..* 0..* Order
An order may include many products or there are 0 to many products in an order
Which of the following is the best reason that a collaboration model would not be used to diagram the conversion process?
All conversion activities are internal to the organization.
A collaboration model does not include swimlanes.
The orchestration of the activities is not shown in a collaboration model.
The choreography between pools is not shown in a collaboration model.
All conversion activities are internal to the organization.
Which of the following is the most likely order of a basic conversion activity model?
Authorize Production→Issue Raw Materials→Perform Work→Complete Production.
Customer Order→Perform Work→Review Work→Ship Product.
Authorize Production→Order Materials→Apply Overhead→Complete Production.
Customer Order→Issue Raw Materials→Apply Overhead→Ship Product.
Authorize Production→Issue Raw Materials→Perform Work→Complete Production.
Which of the following least reflects the purpose of a business rule in the conversion process?
Segregating authorizing, issuing, and conversion work duties.
Limiting who can view and change records in the system.
Return defective items to suppliers promptly.
Assuring that all products meet quality standards.
Return defective items to suppliers promptly.
Products 1..1 0..* product authoriztion
Each product authorization is related to one product
Start > authorize production > issue raw materials > perform work > complete production > end
Conversion process: quantity of raw materials to be released is calculated upon?
Work-in-Process.
The Bills of Materials.
The quantities of raw materials purchased.
Economic order quantities.
The Bills of Materials.
Lightening bolt is
Gateway.
Activity loop.
Exception event.
Collapsed subprocess.
Exception event.
Which of the following is the primary overall objective of the conversion process?
Issue raw materials efficiently.
Ensure that enough finished products are available to meet anticipated demand.
Make finished products to order.
Transfer finished goods to warehouse inventory accurately.
Ensure that enough finished products are available to meet anticipated demand.
When creating a UML class diagram to support the conversion process, which of the following approaches provides a way to meet both accounting and general management information requirements?
The COSO framework.
BPMN guidelines.
A star schema.
The REA framework.
The REA framework.
Materials 1..* 0..* Material Issue
A Material Issue must include at least one material, but may include many materials.
Which of the following is the most likely foreign key for the Bill of Materials table?
Prod_auth_ID
Product_ID
Issue_Sequence
Material_description
Product_ID
Note 
Flashcard (155)