Exam 1 (Ch 1 - 6)
In a BPMN collaboration model of the purchase process, which of the following is the appropriate term for the message flows between pools?
choreography
The income statement line item most likely affected by an AIS investment in supply chain that would interface with suppliers would be:
cost of goods sold
The following diagram would result in a database with how many tables?
10
The following UML class diagram should result in how many tables in the relational database?
6
Which of the following best describes a type image?
A UML class added to collect management information, such as category.
Which situation best exemplifies why analysts must understand decision requirements?
A business can only transact with retailers who have a valid business license.
Which of the following symbols depicts an intermediate event?
A circle with a double line perimeter
Which of the following symbols depicts an intermediate event?
A circle with a double line perimeter.
Which of the following statements about foreign keys is not true?
A foreign key should never be linked to a primary key in another table.
Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Cash Receipts will be implemented in the resulting database?
A new table will be created that contains both Sales Order ID and Cash Receipt ID as its composite primary key.
Consider the following diagram. Which of the following best describes how the relationship between Sales Orders and Products will be implemented in the resulting database?
A new table will be created that contains both Sales Order ID and Product ID as its composite primary key.
Which of the following statements best describes the entity integrity rule?
A record's primary key must have a data value.
Which of the following symbols depicts an activity?
A rectangle.
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.
Which of the following best describes a business model?
A simple, abstract representation of a business process or processes
In a BPMN activity diagram, which of the following represent a valid use for an intermediate timer event?
All of these answers are correct: -Represents a time delay -Indicates a delay to a specific date/time -Indicates a delay to a relative date, such as next Thursday
Which of the following statements about the requirements of table design is incorrect?
All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.
Using the following table what will result from the SQL command "SELECT Item SKU, Price"?
All rows but only the 1st and 2nd column.
Using the following table, what will result from the SQL command "SELECT Item SKU, Price"?
All rows but only the 1st and 2nd column.
Which of these database requirements would be solved with a type image?
Allow products to be grouped into categories.
Which of the following best describes how business models help companies manage complexity?
Although business models are a simplification of the actual processes they represent, they incorporate the processes' essential elements.
Which of the following is not a characteristic of a business model?
Always refers to only one business process.
A company would like to implement a management information system that integrates all functional areas within an organization to allow information exchange and collaboration among all parties involved in business operations. Which of the following systems is most effective for this application?
An enterprise resource planning system.
A pool in a BPMN activity represents
An organization/entity
Many fast food restaurants now have kiosks where customers can order without speaking to an employee. This is an example of the _____ strategic role.
Automate
The IT strategic roles of AIS investments are classified as:
Automate, Informate, Transform.
Which of the following is not an attribute of useful information?
Bias
Business rules are an example of which COSO concept?
Control activities
Which of the following best describes the purpose of a gateway in a Business Process Modeling Notation (BPMN) activity diagram?
Controls branching and merging
Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*. Which of the following is the best way to implement that association in your database?
Create a linking table
To convert a conceptual model with a maximum Multiplicities relationship of "many to many" into relationship database tables, one must:
Create a relationship table to handle the many-to-many relationship.
Which of the following tasks cannot be performed through queries in Access?
Create and update relationships
What step should be taken when designing a relational database when a many-to-many relationships exist?
Create two one-to-many relationships.
Which attribute in the following class would make the best primary key?
Customer ID
Which of the following about cloud computing is incorrect?
Data stored in a cloud computing system is always secure.
Which of the following best describes the purpose of swimlanes (or lanes)?
Depict different departments of the same organization in a process.
When creating a BPMN activity model, which of the following is most accurate?
Different modelers given the same set of facts about a business process should develop similar models of the process.
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Cash Disbursements class?
Disbursements are made after purchases are recorded.
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Cash Disbursements classes?
Disbursements are made after the purchases are recorded
Branch profitability is an example of:
Discretionary information.
Consider the following SQL query. Which item best describes the results of the query? SELECT VendorID, Sum(POTotal) FROM [Purchase Orders] GROUP BY VendorID
Displays the vendor ID and the sum of all purchase order totals for that vendor.
Which of the following is an example of information as opposed to just data?
Dress sales in Michigan at Walmart Store #3458
ERPs are useful to auditors for which of the following reasons?
ERPs track details regarding creation, modification, and use of transactions through the organization in a single system.
ERPs are useful to auditors for which of the following reasons?
ERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system.
Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Cash Receipt and Cash classes?
Each cash receipt is deposited into one bank account.
In the following diagram, which of the following provides the best interpretation of the multiplicities for the association between the employees and product categories classes?
Each employee may be assigned to manage many product categories.
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Sunset Partners and Supplier Categories classes?
Each partner can be assigned to manage many supplier categories
Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Employees and the Product Categories classes?
Each product category has one manager.
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Purchases and Products classes?
Each purchase can include many products
Which of the following least reflects the purpose of a business rule in the purchase process?
Ensure suppliers are satisfied
The Sarbanes-Oxley Act of 2002 requires that a company's attest auditors be able to perform which of the following activities?
Evaluate the internal controls in an AIS.
Which of the following is not one of the building blocks used for creating UML Class Diagrams?
Events
Which of the following is not one of the advantages relational data models have over other data models?
Exclusively uses parent/child relationships.
Process documentation does not include which of the following?
External audit workpapers.
The purchase order number is automatically assigned.
Fields
When implementing the database from a UML class diagram, attributes should be mapped to which of the following?
Fields
Which of the following are considered to be mandatory information required by a regulatory body?
Financial reports for the Securities and Exchange Commission
Which of the following are considered to be mandatory information required by a regulatory body?
Financial reports for the Securities and Exchange Commission.
When implementing the database from a UML class diagram, associations should be mapped to which of the following?
Foreign keys.
Which of the following is not a construct in a relational database?
Forms
Which of the following is not a Stewardship and Reporting role of the Accounting/Finance Function in Business?
Human resource management
Accounting information systems
Include records, processes, and reports
An enterprise resource planning system has which of the following advantages over multiple independent functional systems?
Increased responsiveness and flexibility while aiding in the decision making process.
An enterprise resource planning system has which of the following advantages over multiple independent functional systems?
Increased responsiveness and flexibility while aiding in the decision-making process.
A dental practice implemented an upgrade to its AIS that provides the dentists with daily and weekly patient and financial summaries. The practice's upgrade is an example of which IT strategic role?
Informate - up.
A dental practice implemented an upgrade to its AIS that provides the dentists with daily and weekly patient and financial summaries. The practice's upgrade is an example of which IT strategic role?
Informate-up
Bob's manager complains that Bob suffers from "Analysis Paralysis;" that is, he spends too much time reviewing endless reports and is reluctant to make decisions. Bob most likely suffers from _____.
Information overload.
Which of the following is not one of the typical challenges organizations face when implementing an ERP?
Installing the ERP software.
When documenting a purchases and payments business process, which of the following BPMN activity diagram symbols should be used to indicate that accounts payable waits until the end of the month to pay vendors?
Intermediate timer event
Which of the following best describes cloud computing?
Internet based computing where shared resources, software and information are provided to firms on demand.
Consider the non-profit organization Doctors without Borders (Médecins Sans Frontières), a Nobel Peace Prize winning organization that provides medical services in war zones and developing countries. For this type of organization, which of the following would likely be the best measure of business value?
Lives saved.
Effective use of Supply Chain Management software is generally expected to provide all of the following benefits except:
Lower payroll costs.
Discretionary information is most likely to be used in which of the following activities?
Management decision-making.
Which of the following represents a parallel multi-instance task?
Many customers watching one movie.
Which of the following is usually the primary objective for companies when creating mandatory information?
Minimize cost
Which of the following items does not represent a UML class diagram object and its resulting database object?
Multiplicities → Records.
Which of the following is not a type of data model?
Normalization data model
Which of the following is not something a business rules would implement?
Notifications
What is the best description of the relationship between employee (1..1) and vehicle (0..*) in the following UML class diagram?
One-to-many
What is the best description of the relationship between employee and vehicle in the following UML class diagram?
One-to-many.
What is the best description of the relationship between employee and vehicle in the following UML class diagram?
One-to-one.
Message flows in BPMN activity diagrams indicate an exchange between:
Participants in a process
Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1. Which of the following is the best way to implement that association in your database?
Post the primary key of Cash Accounts as a foreign key in Cash Disbursements.
Consider an association between a Cities class and a Neighborhood class in a Unified Modeling Language (UML) Class diagram. The multiplicities next the Cities class are 1..1 and the multiplicities next to the Neighborhoods class are 1..*. Which of the following is the best way to implement that association in your database?
Post the primary key of Cities as a foreign key in Neighborhoods.
Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database?
Post the primary key of Customers as a foreign key in Sales.
Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database?
Post the primary key of Pet Owners as a foreign key in Pets.
Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database?
Post the primary key of Pet Owners as a foreign key in the Pets.
Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1. Which of the following is the best way to implement that association in your database?
Post the primary key of Shipping Companies as a foreign key in Deliveries.
Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database?
Post the primary key of Vendors as a foreign key in Cash Disbursements.
Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database?
Post the primary key of customers as a foreign key in sales
The primary transformation of data into information takes place in which of the following activities?
Processing
Which of the following is not accurate?
Records represent attributes of a table.
A supply chain:
Refers to the flow of materials, information, payments and services.
Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers.
Reports
Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?
Reports
Which of the following is the most likely order of a basic purchases activity model?
Request prices and availability→Place Purchase Order→Receive Items→Send Payment.
Which of the following best describes why the Sarbanes-Oxley Act of 2002 (SOQ) made documentation of business processes essential for businesses?
SOX requires managers to assess and attest to the company's internal controls structures and procedures
Which of the following best describes why the Sarbanes-Oxley Act of 2002 (SOX) made documentation of business processes essential for businesses?
SOX requires managers to assess and attest to the company's internal controls structures and procedures.
Which of the following about SQL is incorrect?
SQL uses the PIVOT function to insert data.
Which of the following is not a valid enforcement level for business rules?
Segregation
Which of the following activities is not associated with the purchase and payments business process?
Selling products and services
The income statement line item most likely affected by an AIS investment in enterprise systems would be:
Selling, General and Administrative Expenses.
Which of the following is not a valid BPMN gateway type?
Serial gateway
Which of the following is not a valid BPMN gateway type?
Serial gateway.
In a BPMN collaboration model of the purchase process, which of the following best describes the purpose of swimlanes?
Showing different jobs in the purchase process
Which of the following best describes a Business Process Modeling Notation (BPMN) message flow?
Shows interactions between participants in a process.
Which of the following best describes the choreography in a BPMN activity diagram?
Shows the interaction of messages between participants in the business process.
Which of the following best describes the orchestration in a BPMN activity diagram?
Shows the sequence of activities within one pool.
Which of the following is not one of the objects used in Microsoft Access?
Sites
Which of the following best describes a DBMS?
Software that can create, modify, and query databases.
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Product Categories and Supplier Categories classes?
Some partners may manage several product categories, and some partners may manage several supplier categories, but there is no direct link between supplier and product categories.
The most likely user of a Microsoft Access Report:
Store manager
Consider the following diagram. How will the database relationship between Employees and Sales Orders be implemented?
The Employee ID will be included as a foreign key in the Sales Orders table.
The property of the primary key in a table in Microsoft Access should be set to:
The Required field = "Yes", the Indexed field = "Yes (No Duplicates)".
Logical database structure models, including UML Class Diagrams, must be able to describe which of the following?
The attributes of the entities
A BPMN activity diagram that contains two blank pools would typically be created in order to highlight which of the following?
The choreography of the business process.
An opaque external pool in a BPMN activity diagram is typically used because
The external pool event is not important for the model.
Which of the following best describes the difference between a Business Process Modeling Notation (BPMN) gateway and a flowcharting decision diamond?
The gateway ony represents branching and not the decision that results in branching.
The Information Value Chain is defined as
The overall transformation of data from a business need to the ultimate decision.
Which of the following is not a desired access control when developing a purchases and payments business process?
The person returning items to the supplier must not view the original purchase order.
Which of the following is not a criterion for selection of a primary key?
The primary key should always be numeric.
Which of the following is an example of an application control for the purchases and payments business process?
The purchase order number is automatically assigned.
What kind data model is most commonly used as a basis for today's enterprise systems?
The relational model.
Which of the following is not something a model of database structures must be able to describe?
The sequence that entities are accessed.
In a BPMN collaboration model of the purchase process, one pool describes the focal organization's activities and the other pool describes what?
The supplier's activities
Which of the following statements is most true:
There are sometimes tradeoffs between information that is relevant and a faithful representation
Which of the following statements is most true:
There are sometimes tradeoffs between information that is relevant and a faithful representation.
When Uber (a ride sharing application) developed their unique platform to match drivers with riders, this was an example of _____ with IT Investments which fundamentally changed how people use car services.
Transforming
Which of the following best describes the purpose of a primary key?
Uniquely identifies each instance of the class.
Which of the following is a well-formed business rule?
-Customers must be over 18 years of age. -Customers may not be under 18 years of age. -Customers must pay in U. S. dollars. -All of these are well-formed business rules. ****
In a BPMN activity diagram, which of the following represent a valid use for an intermediate timer event?
-Represent a time delay -Indicates a delay to a specific date/time -Indicates a delay to a relative date, such as next Thursday -All of these choices are correct***
Which of following are possible options for minimum multiplicities
0 and 1.
Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams?
Use various size class rectangles.
Many companies record both purchase orders and purchases; when would such a company recognize in the financial statements the purchase?
When the products are received from the supplier and accepted.
In Microsoft Access, we use tables in a database for
data storage
Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class?
each quote may result in many future orders
A supply chain system does not include information about
prospective customers
A database being built to support customer purchase information would likely have the following classes except:
Color
Which of the following is not a form of business rules?
Compulsory
The role of accountants in accounting information systems include all except:
Coder
Customer Relationship Management is best defined as:
A system used to manage and nurture a firm's interactions with its current and potential customers.
Which of the following accounts is generally not impacted as part of the Sales and Collections process?
Accounts Payable
A well controlled purchases and payments process would likely have which of the following roles seperated into swimlanes?
Accounts Payable, Receiving & Buyer.
A well controlled purchases and payments process would likely have which of the following roles separated into swimlanes?
Accounts Payable, Receiving, & Buyer
Which of the following general ledger accounts would likely not be impacted in a purchases and payments process?
Accounts Receivable.
Classes in a relational database model for AISs are typically grouped into all of the following categories except:
Activities
Classes in a relational database model for AISs are typically grouped into all of the following categories except:
Activities.
Which of the following items can be best described as a "Resource" in the REA data model?
Cash
Which of the following items can best be described as a "Resource" in the REA data model?
Cash
Which set of multiplicities correctly shows the relationship between the Cash Receipts table and the Sale table for an organization that allows customers to buy on credit and pay in multiple installments?
Cash Receipts (0..N) - Sale (1..1).
Which of the following items can best be described as an "Event" in the REA data model?
Cash collection
Which designation would be the most appropriate for those professionals possessing IT audit, control, and security skills?
Certified Information Systems Auditors (CISA)
Which designation is for CPAs with a broad range of technology knowledge and experience?
Certified Information Technology Professional (CITP).
In a BPMN collaboration model of the purchase process, which of the following is the appropriate term for the message flows between pools?
Choreography
Which of the following is not a likely module of an Enterprise Reporting System (ERP)?
Cloud based computing.
