Accy 310 MidTerm Test
1. A business model is typically a graphical depiction of the essential business process information.
T
1. Accountants now face a challenge of helping businesses optimize processes.
T
A systems analyst analyzes a business problem that might be addressed by an information system and recommends software or systems to address that problem.
T
A well-designed and well-functioning AIS can be expected to create value by providing relevant information helpful to management to increase revenues and reduce expenses.
T
An accounting information system (AIS) is defined as being an information system that records, processes and reports on transactions to provide financial and nonfinancial information for decision making and control.
T
An efficient Enterprise System can significantly lower the cost of support processes included in sales, general, and administrative expenses.
T
An enterprise system is a centralized database that collects data from throughout the firm. This includes data from orders, customers, sales, inventory and employees.
T
Business value includes all those items, events and interactions that determine the financial health and well-being of the firm.
T
CRM software often includes the use of database marketing tools to learn more about the customers and to develop strong firm-to-customer relationships.
T
Documentation can be thought of as a tool for information transmission and communication
T
Information is defined as being data organized in a meaningful way that is useful to the user.
T
Information overload is defined as the difficulty a person faces in understanding a problem and making a decision as a consequence of too much information.
T
Service Activities as defined in the value chain are those activities that provide the support of customers after the products and services are sold to them (e.g. warranty repairs, parts, instruction manuals, etc.).
T
The Certified Information Systems Auditor (CISA) is a professional designation generally sought by those performing IT audits
T
The Certified Information Technology Professional is the position created by the AICPA to recognize CPAs who have the ability to provide skilled professional services on Information Technology
T
The Sarbanes-Oxley Act of 2002 is a federal law in the United States that set new and enhanced standards for all U.S. public companies, their management and public accounting firms.
T
The characteristics of relevant information include predictive value, feedback value and timeliness.
T
1. A generalization relationship models a grouping of things that share common characteristics.
t
1. A pool in a BPMN model does not actually have to display any activities.
t
1. An activity can depict a single action or some logical combination of actions depending on the required level of detail to achieve the objectives of the business process analysis.
t
1. An intermediate error event can be used to model process exceptions.
t
1. Associations can indicate the roles that one Class takes in its business relationship with another Class.
t
1. BPMN models can describe the collaboration between two organizations using pools.
t
1. Business Process Modeling Notation (BPMN) activity diagrams are conceptually similar to process maps.
t
1. Business Process Modeling Notation (BPMN) activity diagrams depict events as circles.
t
1. Business rules set criteria for branching in activity models.
t
1. In Business Process Modeling Notation (BPMN), activities are named with a short verb phrase placed within the rectangle.
t
1. In Unified Modeling Language (UML) Class diagrams, a Class is represented by a rectangle.
t
1. In Unified Modeling Language (UML) attributes are characteristics of individual instances of a Class.
t
1. In Unified Modeling Language (UML) foreign keys allow tables to be linked together in a database.
t
1. In Unified Modeling Language (UML) primary keys cannot by NULL.
t
1. In Unified Modeling Language (UML) the options for maximum multiplicity values are 1 and *.
t
1. In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).
t
1. Models should be simpler than the processes and systems they depict.
t
1. One-to-many relationships are implemented by posting a foreign key.
t
1. Opportunity flowcharts identify opportunities for process improvement by separating value-added from non-value-added activities.
t
1. SQL is based on relational algebra and allows a user to query and update the database.
t
1. Segregation of duties is an example of a COSO control activity.
t
1. Swimlanes (or lanes) identify participants, e.g., functions or departments, in a process.
t
1. The "Where" SQL clause can be used to link two tables.
t
1. The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams.
t
1. The asterisk (*) following the SELECT SQL statement is a wild card indicating all columns should be selected.
t
1. Three types of data models used today are: the hierarchical model, the network model and the relational model.
t
1. Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.
t
1. When building a database from Unified Modeling Language (UML) Class diagrams, each instance of each Class becomes a row in the corresponding table.
t
1. While hierarchical and network data models require relationships to be formed at the database creation, relational data models allow relationships to be created and updated as needed.
t
Access is a simple database management system that can be used to run databases for individuals and small firms.
t
Cloud computing is an internet-based computing where shared resources, software, and information is provided to firms on demand
t
Type images can be used to allow process information to be summarized by category
t
1. Activity models are analagous to which of the following? A. The prototype for a new car model B. A blueprint C. The instructions in a recipe D. A car's steering system
B
1. A business process constrains business rules.
F
1. Documentation helps with training but won't help with regulatory compliance issues.
F
A value chain is defined as the flow of materials, information, payments, and services from customer to supplier.
F
Accounting Information Systems at this date are all computerized
F
Accounting and Finance is a primary activity in the value chain.
F
An enterprise system is primarily used to manage and nurture a firm's interactions with its current and potential clients.
F
Data is defined as being information organized in a meaningful way that is useful to the user
F
Outbound logistics are the activities associated with receiving and storing raw materials and other partially completed materials, and distributing those materials to manufacturing when and where they are needed.
F
Production of a 1040 tax form from the AIS to be delivered to the Internal Revenue Service is an example of discretionary information.
F
Relevant information is that information that is free from bias and error.
F
The Certified Information Technology Professional (CITP) is a professional designation for those with a broad range of technology knowledge and does not require a CPA.
F
The characteristics of reliable information are that the information is verifiable, without bias and timely.
F
The main financial benefit of Customer Relationship Management practices reduces the cost of goods sold
F
To be valuable business partners, accountants must understand how the business delivers value to its employees
F
1. A pool in a BPMN activity model represents: A. An entire organization/entity. B. A department or functional area. C. A specific individual. D. A logical activity.
a
1. Business models provide value in all of the following areas except which one? A. Employee performance appraisal B. Managing complexity C. Specifying systems requirements D. Eliciting requirements for new systems
a
1. Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to 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? A. Post the primary key of Cities as a foreign key in Neighborhoods B. Post the primary key of Neighborhoods as a foreign key in Cities C. Create a linking table D. None of the above
a
1. 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? A. Post the primary key of Customers as a foreign key in Sales B. Post the primary key of Sales as a foreign key in Customers C. Create a linking table D. None of the above
a
1. 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? A. Post the primary key of Pet Owners as a foreign key in Pets B. Post the primary key of Pets as a foreign key in Pet Owners C. Create a linking table D. None of the above AICPA: Analytic
a
1. In Microsoft Access, we use "Forms" for A. Data entry B. Data storage C. Date retrieve D. Two of the above
a
1. In order to perform their required roles and be valuable business partners, accountants must understand all of the following except: A. How the business identifies and designs its products and services B. How the business collects data, summarizes it, and communicates business information C. How the business delivers value, interacts with other businesses, and is a good corporate citizen D. What risks the business faces, and how internal controls can mitigate those risks
a
1. Logical database structure models, including UML Class Diagrams, must be able to describe which of the following? A. The entities in the domain of interest B. The activities performed in the business process C. The operations performed on the database D. The Bachman diagram
a
1. 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? A. Each cash receipt is deposited into one bank account. B. Each order increases accounts receivable. C. The company only has one bank account. D. Some cash receipts are not deposited into a bank account.
a
1. The property of the primary key in a table in Microsoft Access should be set to: A. The required field = "Yes", the Indexed field = "Yes (No Duplicates)" B. The Required field = "NO" and the Indexed field = "Yes (No Duplicates)" C. The Required field = "Yes" and the Indexed field = "Yes (Duplicated)" D. The Required field = "NO" and the Indexed field = "Yes (No Duplicates)"
a
1. When connecting to an opaque external pool in a BPMN activity diagram, message flows connect to: A. The edge of the opaque pool. B. The edge of the swimlane. C. The nearest sequence flow. D. The appropriate data store.
a
1. Which of following are possible options for minimum multiplicities? A. 0 and 1 B. 0 and * C. * and 1 d 0, 1, and
a
1. Which of the following BPMN shapes represents a data object? A. B. C. D.
a
1. Which of the following best describes a business model? A. A simple, abstract representation of a business process or processes. B. A sequence of business activities. C. An evaluation of potential business process improvements. D. None of the above.
a
1. Which of the following best describes the difference between access controls and application controls? A. Access controls limit who can change records and application controls provide an audit trail of any changes. B. Access controls implement business rules and application controls do not. C. Access controls are "prohibited" business rules and application controls are "allowed" business rules. D. There is no difference between access and application controls.
a
1. Which of the following best describes the purpose of an activity model? A. An activity model describes the sequence of workflow in a business process. B. An activity model constrains and guides process operations. C. An activity model depicts data structures. D. None of the above.
a
1. Which of the following is a difference between Business Process Modeling Notation (BPMN) activity diagrams and flowcharts? A. BPMN symbols can show a variety of intermediate events that affect the sequence flow. B. Flowcharts have symbols to represent the start and end of a process. C. BPMN diagrams show the sequence flow of activities. D. Flowcharts can be annotated with text.
a
1. Which of the following is most similar to the relationship between the UML class diagram and the database? A. The relationship between a blueprint and building B. The relationship between driving directions and a map C. The relationship between raw materials and finished goods D. The relationship between cooking instructions and ingredients
a
1. Which of the following is not a Stewardship and Reporting role of the Accounting/Finance Function in Business? A. Human Resource management B. Regulatory compliance C. Tax returns D. Statutory reporting
a
1. Which of the following is not a building block for Business Process Modeling Notation (BPMN) diagrams? A. Associations B. Events C. Gateways D. Sequence flows
a
1. Which of the following is not a form of business rules? A. Compulsory B. Obligatory C. Prohibited D. Allowed
a
1. Which of the following is not a valid enforcement level for business rules? A. Authorization B. Pre-override C. Strict Enforcement D. Post-override
a
23. Which of the following best describes the choreography in a BPMN activity diagram? A. Shows the interaction of messages between participants in the business process B. Hides activities that are not of interest in the analysis of the business process C. Shows the sequence of activities within one pool D. Follows the sequence flow from start to end
a
26. Customer Relationship Management is defined as: a. A system used to manage and nurture a firm's interactions with its current and potential customers. b. A system used to track a customer's past purchases c. A system used to connect a firm's suppliers with a firm's customers. d. A system used to advertise current items on sale to customers.
a
26. Many hospitals and doctor's offices are beginning to digitize the medical records of their patients. This is an example of the ____________ strategic role. a. Automate b. Informate - up c. Transform d. Informate - down
a
26. The IT strategic roles of AIS investments are classified as: a. Automate, Informate, Transform. b. Value creation, Value Destruction, Value Neutral. c. Digitize, Report, Transform. d. Automate, Digitize, Transport.
a
26. The income statement account most likely affected by an AIS investment in customer relationship management (CRM) would be: a. Revenues. b. Cost of Goods Sold. c. Selling, General and Administrative Expenses. d. Unearned Revenue.
a
26. Which of the following are considered to be mandatory information required by a regulatory body? a. Financial reports for the Securities and Exchange Commission b. The amount of taxes saved by a merger c. The total dollar value of fireworks that are sold on July 4 d. The cost to build an all-new Starbucks restaurant in Abu Dhabi
a
41. Which of the following is considered one of the primary benefits of ERPs? A. ERPs allow an organization to integrate information related to multiple business functions (i.e., manufacturing, human resources, finance, etc.). B. ERPs all operate using cloud computing technology. C. ERPs create protected data silos for each function in the organization. D. ERPs use relational data models, which are required by the Sarbanes-Oxley Act of 2002
a
41. Which of the following is not one of the advantages relational data models have over other data models? A. Exclusively uses parent/child relationships B. Increased flexibility and scalability C. Simplicity D. Reduced information redundancy
a
41. Which of the following operators would be used in a SQL query designed to simply display database records? A. SELECT B. INSERT C. DISPLAY D. VIEW
a
One common way of measuring the effectiveness of the Supply Chain is through the fill rate. Which of the following best describes the fill rate? a. The percentage, in monetary value, of a supplier's order which is actually delivered to the organization. b. The number of items per hour that receiving employees can move from the receiving dock to the warehouse. c. The rate at which the stock in warehouse storage bins increases. The average amount of time it takes for the organization to fulfill customers' orders.
a
One of the most important ways that ERPs benefit organizations and their business processes is: a. Current information is made available to all users involved in the activities and decisions associated with a company's business processes. b. Information is stored in many specialized, distributed databases that each serve separate business processes. c. Reducing the amount of time to complete business processes by eliminating all controls associated with the processes. d. Preventing external business partners from accessing the organization's data.
a
The Sarbanes-Oxley Act of 2002 requires that a company's attest auditors be able to perform which of the following activities? a. Evaluate the internal controls in an AIS. b. Assess the value of a company's IT assets. c. Take over the company's AIS if necessary. Design and implement the controls used in the AIS
a
Which of the following is not a characteristic of useful information? a. Easy to understand b. Feedback value c. Timeliness d. Representational Faithfulness
a
1. An enterprise resource planning system has which of the following advantages over multiple independent functional systems? A. Modifications can be made to each module without affecting other modules. B. Increased responsiveness and flexibility while aiding in the decision-making process, C. Increased amount of data redundancy since more than one module contains the same information. D. Reduction in costs for implementation and training.
b
1. 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? A. Post the primary key of Cash Disbursements as a foreign key in Cash Accounts B. Post the primary key of Cash Accounts as a foreign key in Cash Disbursements C. Create a linking table D. None of the above
b
1. 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?
b
1. 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? A. Post the primary key of Deliveries as a foreign key in Shipping Companies B. Post the primary key of Shipping Companies as a foreign key in Deliveries C. Create a linking table D. None of the above
b
1. Entity-relationship diagrams (ERDs) are similar in content and purpose to Unified Modeling Language (UML) Class diagrams. Which of the following is not a basic building block of ERDs? A. Relationships B. Associations C. Attributes D. Entities
b
1. In Microsoft Access, we use "Tables" for: A. Data entry B. Data storage C. Date retrieve D. Two of the above
b
1. In Microsoft Access, we use tables in a database for: A. Data entry B. Data storage C. Data retrieval D. Two of the above are correct.
b
1. Message flows in BPMN activity diagrams indicate an exchange between: A. Activities in the same swimlane B. Participants in different pools C. Gateways in different swimlanes D. Events in the same pool
b
1. Refer to the following diagram. Which of the following answers does not provide a valid interpretation of the multiplicities for the association between the Employees and the Sales classes? A. Only one employee participates in each sale. B. Several employees participate in each sale. C. Some employees do not participate in sales. D. Some employees participate in several sales.
b
1. Refer to the following diagram. Which of the following answers does not provide a valid interpretation of the multiplicities for the association between the Inventory and the Product Category classes? A. Every product category is managed by one employee. B. Every product category includes at least one inventory item. C. Some product categories do not include inventory items. D. Every inventory item is in at most one product category.
b
1. 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? A. Each employee must be assigned to manage at least one product category. B. Each product category has one manager. C. Each product category can have no managers or multiple managers. D. Each employee can manage only one product category.
b
1. Review the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class? A. Quotes and orders are entered into the system at the same time. B. Each quote may result in many future Orders. C. The same Sunset Partner both prepares quotes and records orders. D. Each order must result from a prior quote.
b
1. Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction? A. Materials Management B. Sales and Distribution C. Production Planning and Control D. Logistics Execution
b
1. Which of the following BPMN shapes represents a Parallel Gateway? A. B. C. D.
b
1. Which of the following BPMN shapes represents a parallel multi-instance task?
b
1. Which of the following best describes a Business Process Modeling Notation (BPMN) message flow? A. Shows the sequence of activities in a process. B. Shows interactions between participants in a process. C. Affects the flow of a business process. D. Shows branching and merging in a business process.
b
1. Which of the following best describes how business models help companies manage complexity? A. Because business models can't exceed one page, managers can understand how the business works at a glance. B. Although business models are a simplification of the actual processes they represent, they incorporate the processes' essential elements. C. Business models' limitations force managers to simplify the company's actual processes. D. Business models must display every detailed task and activity, which allows managers to visualize the complexity inherent in its business processes.
b
1. Which of the following best describes the difference between a Business Process Modeling Notation (BPMN) gateway and a flowcharting decision diamond? A. Only the decision diamond shows branching of the sequence flow. B. The gateway ony represents branching and not the decision that results in branching. C. Only the gateway shows branching of the sequence flow. D. The decision diamond can depict more branching options.
b
1. Which of the following best describes the purpose of swimlanes (or lanes)? A. Depict different organizations involved in a process. B. Depict different departments of the same organization in a process. C. Depict interactions between organizations in a process. D. Depict the sequence of tasks in a process.
b
1. Which of the following best describes why the Sarbanes-Oxley Act of 2002 (SOX) made documentation of business processes essential for businesses? A. SOX mandates that accountants create the business rules and documenation associated with a company's business processes B. SOX requires managers to assess and attest to the company's internal controls structures and procedures C. SOX explicitly states that business processes must be documented D. SOX allows thorough documentation of business processes to act as a substitute for a full review of internal control structures and procedures
b
1. Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams? A. Opt for simplicity B. Model each process separately C. Avoid crossing lines whenever possible D. Avoid confusing abbreviations
b
1. Which of the following is not a category of operational decision used in creating business rules? A. Calculation B. Event C. Risk D. Opportunity AICPA: Analytic
b
1. Which of the following is not a purpose of documentation? A. Training B. Determining staffing C. Describing current processes D. Establishing accountability
b
1. Which of the following is not a valid BPMN gateway type? A. Parallel gateway B. Serial gateway C. Inclusive gateway D. Exclusive gateway
b
1. Which of the following is not an Accounting/Finance Operations role of the Accounting/Finance Function in Business? A. Financial close - completing period end accounts B. Stakeholder assurance C. People management D. Financial consolidation, reporting and analysis
b
1. Which of the following is not one of the building blocks used for creating UML Class Diagrams? A. Classes B. Events C. Associations D. None of the other options are used in UML Class Diagrams
b
1. Which of the following is not something a model of database structures must be able to describe? A. The entities or things in the domain of interest B. The sequence that entities are accessed C. The cardinalities that describe how many instances of one entity can be related to another D. The attributes or characteristics of the entities and relationships
b
1. Which of the following statements about foreign keys is not true? A. A foreign key can be a combination of attributes B. A foreign key cannot be NULL C. Foreign key must match values of the linked primary key D. Foreign keys support a defined association
b
1. Which of the following symbols depicts an intermediate event? A. An arrow B. A circle with a double line perimeter C. A rectangle D. A circle with a wide single line perimeter
b
1. Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class? A. Trucks B. The number of trucks used in the delivery C. The employee driving the truck D. The customer receiving the delivery
b
1. Which type of data models allows each record to have multiple parent and child records? A. The hierarchical mode B. The network model C. The relational model D. None of the above
b
23. Business rules are an example of which COSO concept? A. Internal control B. Control activities C. Control environment D. Activity models
b
23. Which of the following activities is not associated with the sales and collection business process? A. Recording customer payments B. Maintaining vendor records C. Selling products and services Billing customers
b
26. A supply chain system does not include information about: a. Current customers. b. Prospective customers. c. Availability of inventory. d. Current suppliers.
b
26. A supply chain: a. Refers to the supplies needed to build products. b. Refers to the flow of materials, information, payments and services. c. Is similar in function and purpose to the value chain. d. Does not apply to a service firm like an accounting firm.
b
26. Business Value is defined as: a. The monetary value of a business. b. Items, events and interactions that determine the financial health and well-being of the firm. c. The cost to acquire a business by an outsider. d. The overall value of taking data and transforming it in to information needed for decision making.
b
26. The income statement line item most likely affected by an AIS investment in supply chain that would interface with suppliers would be: a. Revenues. b. Cost of Goods Sold. c. Selling, General and Administrative Expenses. d. Research and Development Expenses. AACSB: Reflective Thinking
b
37. Which of the following items can best be described as an "Agent" in the REA data model? A. Purchases. B. Accounts payable clerk. C. Raw material inventory. D. None of the above is correct.
b
41. ERPs are useful to auditors for which of the following reasons? A. ERPs use cloud computing technology, which allows auditors to review transactions from anywhere. B. ERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system. C. ERPs are required by the Sarbanes-Oxley Act of 2002. D. ERPs are spread across multiple logical databases, allowing auditors to minimize disruption to processing when reviewing ERP activity.
b
41. 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? A. Tables B. Reports C. Forms D. Macros
b
41. Which of the following best describes a DBMS? A. The manager(s) in charge of a company's databases B. Software that can create, modify and query databases C. A language used to retrieve data from databases D. A database created using Microsoft software
b
41. Which of the following is not a potential disadvantage of using cloud computing to host an organization's ERP? A. Uncertainty about the data security of sensitive information hosted offsite B. Reduced internal processing and storage needs for the organization C. Uncertainty about the adequacy of the host's processing speed and availability Requires a reliable Internet connection
b
41. Which of the following is not one of the objects used in Microsoft Access? A. Tables B. Sites C. Forms D. Macros
b
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? a. Automate. b. Informate - up. c. Transform d. Informate - down.
b
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? a. Fund balance (i.e., the net of revenues less expenditures). b. Lives saved. c. Donations raised. d. Volunteers deployed.
b
Which of the following is usually the primary objective for companies when creating mandatory information? a. The value of the information exceeds the cost to produce it. b. Minimize cost. c. Improve business decisions. d. Ensure proper controls over business processes.
b
Which of the following systems would a company be most likely to employ for the primary purpose of generating additional sales revenue? a. MDBMS. b. CRM. c. SCM. d. OCR.
b
23. Which of the following best describes the orchestration in a BPMN activity diagram? A. Shows the interaction of messages between participants in the business process B. Hides activities that are not of interest in the analysis of the business process C. Shows the sequence of activities within one pool D. Follows the sequence flow from start to end
c
1. A boundary event in a BPMN activity model: A. Takes place at the edge of a swimlane B. Occurs at the border of a pool. C. Is attached to the edge of an activity. d Occurs as a message leaves a pool
c
1. Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Sales class are 0..* and the multiplicities next to the Inventory class are 1..*. Which of the following is the best way to implement that association in your database? A. Post the primary key of Sales as a foreign key in Inventory B. Post the primary key of Inventory as a foreign key in Sales C. Create a linking table D. None of the above
c
1. 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? A. Post the primary key of Accountants as a foreign key in States B. Post the primary key of States as a foreign key in Accountants C. Create a linking table D. None of the above
c
1. Which attribute in the following class would make the best primary key? A. Customer B. Customer Name C. E-mail address D. Customer ID
d
1. Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Orders and Cash Receipt classes? A. Some customers pay for their orders in advance. B. Some orders result in several payments from the customers. C. Each cash receipt pays for at least one order, but it could pay for many orders. D. Each cash receipt pays for a minimum of 0 orders and a maximum of 1 order.
c
1. To convert a conceptual model with a maximum multiplicities relationship of "many to many" into relationship database tables, one must A. Create a foreign key in one of the tables to link the two tables. B. Create a relation with no attributes of its own. C. Create a relationship table to handle the many-to-many relationship. D. Many-to-many relationship cannot be represented in Access.
c
1. What is the best description of the relationship between employee and vehicle in the following UML class diagram? A. Zero-to-one B. Zero-to-zero C. One-to-one D. One-to-many
c
1. What is the main purpose of using foreign keys in a relational database design? A. It provides useful financial data value in the table. B. It is required in all tables. C. It is used to link tables. D. None of the above is correct.
c
1. What kind data model is most commonly used as a basis for today's enterprise systems? A. The hierarchical mode B. The network model C. The relational model D. None of the above
c
1. What kind of data model is most commonly used in today's business environment? A. Hierarchical data model B. Network data model C. Relational data model D. All of the above
c
1. When implementing the database from a UML class diagram, attributes should be mapped to which of the following? A. Tables B. Relationships C. Fields D. Indexes
c
1. Which of the following BPMN shapes represents a data store?
c
1. Which of the following about SQL is incorrect? A. SQL is a language designed to query data in a relational database. B. SQL is based on relational algebra and allows a user to query and update the database. C. SQL is very user-friendly. D. SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.
c
1. Which of the following best describes the purpose of a BPMN collapsed sub-process? A. Shows the interchange between two pools. B. Depicts the sequence of activities in one pool. C. Contains a series of activities that are hidden from view. D. Illustrates the process flow when an exception occurs.
c
1. Which of the following best describes the purpose of an event in a Business Process Modeling Notation (BPMN) activity diagram? A. Shows where the work takes place. B. Describes the sequence of workflow. C. Affects the flow of the business process. D. Controls branching and merging.
c
1. Which of the following correctly describes the Referential Integrity Rule? A. The primary key of a table must have data values (cannot be null) B. Each attribute in a table must have a unique name C. The data value for a foreign key could be null D. Values of a specific attribute must be of the same type
c
1. Which of the following is not a Business Management Support role of the Accounting/Finance Function in Business? A. Management information B. Planning, budgeting and forecasting C. Financial consolidation, reporting and analysis D. Investment appraisal
c
1. Which of the following is not a common element of activity models regardless of the specific modeling notation? A. Events to start and stop the workflow B. Sequence of flow between tasks C. Multiplicities D. Decision points that affect the process flow
c
1. Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database? A. Map Classes to Tables B. Map Attributes to Table Fields C. Map Associations to Primary Keys D. Map Associations to Foreign Keys
c
1. Which of the following is not a type of data model? A. Hierarchical data model B. Network data model C. Normalization data model Relational data model
c
1. Which of the following is not part of the business analysis process? A. Ascertaining information about current and future business processes. B. Using business process modeling tools. C. Using IT to make finance and accounting processes more efficient and effective. D. Documenting current and future business processes.
c
1. Which of the following is the best description of an association? A. A group of classes B. The lines in a UML Class diagram C. The relationship between two classes D. The number of times one class is related to another
c
1. Which of the following symbols depicts an activity? A. An arrow B. A circle with a double line perimeter C. A rectangle A circle with a wide single line perimeter
c
1. Which of the following symbols is used to depict different organizations in one Business Process Modeling Notation (BPMN) diagram? A. Gateway B. Message flow C. Pool D. Intermediate event
c
23. Consider the following diagram. Which answer provides the best interpretation of the multiplicities for the association between the Sales Orders class and the Cash Receipts class? A. A single cash receipt may apply to only one sales order B. Sales orders and cash receipts must be entered into the system at the same time C. Customers may pay for sales orders in multiple payments D. An employee might never record a sales order
c
23. In the generic REA model for the sales and collections process, the multiplicities between the Sales and Cash Receipts classes are displayed with question marks. Which of the following best explains this? A. The direction of process flow depends on the nature of the business. B. The quantities of items sold can't be determined until the sale occurs. C. The actual values will depend on the nature of the business. D. The customer determines the multiplicities for this association.
c
23. Which of the following best describes the purpose of an intermediate timer event? A. Shows the timing of messages between two pools B. Determines when the business process begins C. Illustrates the process flow when a delay occurs D. Contains a series of activities that are hidden from view
c
23. Which of the following is not one of the elements to be identified when developing business rules? A. Important business events B. Conditions that affects the intention/objective for an event C. Access controls that limit who can use information D. Actions to be taken based on conditions
c
26. According to a recent study, the informate-up IT strategic role is defined as systems that: a. Replace human labor in automating business processes. b. Provide information about business activities to all employees. c. Provide information about business activities to senior management. d. Fundamentally redefine business processes and relationships.
c
26. Activity-based costing is an example of: a. Information overload. b. Mandatory information. c. Discretionary information. d. Enterprise System.
c
26. EBay uses information technology to sell goods on the internet. This would be an example of the ___________ strategic role. a. Automate b. Informate - up c. Transform d. Informate - down
c
26. The Information Value Chain is defined as: a. The flow of materials, information, payments, and services. b. The use of computer technology to provide information about business activities to employees across the firm. c. The overall transformation of data from a business need to the ultimate decision. d. A centralized database that collects data from throughout the firm.
c
26. The correct order of effects in the value chain are: a. Inbound Logistics Operations Service b. Inbound Logistics Outbound Logistics Marketing & Sales c. Inbound Logistics Operations Outbound Logistics d. Inbound Logistics Operations Service
c
26. The income statement line item most likely affected by an AIS investment in enterprise systems would be: a. Revenues. b. Cost of Goods Sold. c. Selling, General and Administrative Expenses. d. Unearned Revenue.
c
26. The role of accountants in accounting information systems include all except: a. User. b. Manager. c. Operator. d. Evaluator.
c
26. Which designation is for CPAs with a broad range of technology knowledge and experience? a. Certified Internal Auditor (CIA) b. Certified Public Accountant (CPA) c. Certified Information Technology Professional (CITP) d. Certified Information Systems Auditors (CISA)
c
37. Which of the following items can best be described as a "Resource" in the REA data model? A. Cashier B. Sales C. Cash D. Two of the above are correct.
c
37. Which of the following items can best be described as an "Event" in the REA data model? A. Cash. B. Cashier. C. Cash collection. D. None of the above is correct.
c
41. Which of the following is not one of the typical challenges organizations face when implementing an ERP? A. Integrating with external business partners' information systems B. Converting data from legacy systems to the ERP C. Installing the ERP software D. Successfully completing a large project in an organization
c
41. Which of the following items does not represent a UML class diagram object and its resulting database object? A. Classes Tables B. Attributes Fields C. Multiplicities Records D. Associations Relationships
c
41. Which of the following statements best describes the entity integrity rule? A. A database entity must fit within the REA model B. A record's foreign key value must be null C. A record's primary key must have a data value D. All values of an attribute must be of the same data type
c
Accounting information systems: a. Are always computerized. b. Report only accounting information. c. Include records, processes and reports. d. Are for computer games.
c
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 ____________. a. Data gridlock. b. Discretionary information. c. Information overload. d. Data redundancy.
c
Discretionary information is most likely to be used in which of the following activities? a. Preparing required Environmental Protection Agency emissions reports. b. Filing a 10-K with the SEC. c. Management decision-making. Payroll tax reporting
c
Effective use of Supply Chain Management software is generally expected to provide all of the following benefits except: a. Reduced inventory carrying costs. b. Lower production costs. c. Reduced gross margins. d. Better communications with suppliers.
c
Investors reward companies most that announce IT initiatives with which type of strategic role? a. Automate. b. Informate - up. c. Transform. Informate - down
c
The primary transformation of data into information takes place in which of the following activities? a. Input. b. Storage. c. Processing. d. Output.
c
Which of the following diagrams most accurately illustrates an information system? a. b. c. d.
c
Which of the following most accurately describes IFAC's description of accounting and IT? a. IT is an important peripheral discipline to accounting. b. Accounting and IT are indistinguishable from one another. c. It is difficult to conceive of accounting independent from IT. d. Accounting is an important peripheral discipline to IT.
c
Which of the following resources is usually not modeled as an entity (table) in an REA data model? A. Cash B. Inventory C. Accounts receivable Property, plant and equipment
c
1. Which of the following BPMN shapes represents an Error Event? A. B. C. D.
d
1. When creating a BPMN activity model, which of the following is most accurate? A. Modeling is an artistic endeavor; therefore different modelers given the same set of facts about a business process will likely develop very different models of the process. B. The resulting BPMN activity model should closely match the structure of the subsequent database. C. All activity models should include gateways. D. Different modelers given the same set of facts about a busines process should develop similar models of the process.
d
1. A Query in a program language can be used to A. Update data B. Report data C. Retrieve data D. All of the above
d
1. 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? A. A decision support system. B. An executive support system. C. An office automation system. D. An enterprise resource planning system.
d
1. Associations in UML Class Diagrams should include a description in which of the following situations? A. Associations should always include descriptions B. The decision criterion(a) affecting the process flow direction is not clear C. The attributes of the related class are not clear D. The business purpose of the association is not clear
d
1. Process documentation does not include which of the following? A. Process models B. Business rules C. User manuals D. External audit workpapers
d
1. Refer to the following diagram. Which of the following answers provides the best interpretation of the multiplicities for the association between the Order class and the Products class? A. Each order must specify the same products as the previous quote. B. Each product has been ordered at least once. C. An order does not have to include a product. D. An order may include many products. AICPA: Analytic
d
1. When implementing the database from a UML class diagram, associations should be mapped to which of the following? A. Tables B. Fields C. Relationships D. Foreign keys
d
1. Which of the following about cloud computing is incorrect? A. Cloud computing is Internet-based computing where shared resources, software, and information are provided to firms on demand. B. Cloud Computing can easily host enterprise system applications. C. Security is a major issue to consider when using cloud computing D. Clients using cloud computing do not need to periodically back up data
d
1. Which of the following best describes the purpose of a gateway in a Business Process Modeling Notation (BPMN) activity diagram? A. Shows where the work takes place. B. Describes the sequence of workflow. C. Affects the flow of the business process. D. Controls branching and merging.
d
1. Which of the following best describes the purpose of a primary key? A. Allows linking two or more tables B. Indicates the minimum multiplicities for an association C. Matches values of foreign keys in other classes D. Uniquely identifies each instance of the class
d
1. Which of the following best describes the purpose of an intermediate error event? A. Shows the interchange between two pools. B. Depicts the sequence of activities in one pool. C. Contains a series of activities that are hidden from view. D. Illustrates the process flow when an exception occurs.
d
1. Which of the following is a well-formed business rule? A. Customers must be over 18 years of age B. Customers may not be under 18 years of age C. Customers must pay in U. S. dollars D. All of these are well-formed business rules
d
1. Which of the following is considered a class in the relational database model? A. Customer B. Sale C. Cash D. All of the above are correct
d
1. Which of the following is not a criterion for selection of a primary key? A. The primary key cannot be NULL (blank) B. The primary key should be controlled by the organization assigning it C. Primary keys with sequential values make it easier to spot gaps in the data D. Longer key values are better than shorter key values
d
1. Which of the following statements about the requirements of table design is incorrect? A. Each attribute in a table must have a unique name. B. Values of a specific attribute must be of the same type. C. Each attribute (column) of a record (row) must be single-valued. D. All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.
d
1. Which of the following tasks cannot be performed through queries in Access? A. Retrieve and display data B. Calculations of data C. Data sorting D. Create and update relationships
d
1. Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales? A. Cash Collection (1..1) - Sale (1..N) B. Cash Collection (1..N) - Sale (1..1) C. Cash Collection (1..N) - Sale (1..1) D. Cash Collection (1..1) - Sale (1..1)
d
23. Which of the following best describes the use of type images in UML class modeling? A. Allow companies to include graphic images in class models B. Used to enumerate a many-to-many association between two REA classes C. Allow modelers to distinguish between types of activities in an activity diagram D. Allow categorization of REA classes based on management's information needs
d
23. Which of the following occurs at the same time a sale of goods occurs? A. Reduction in accounts receivable B. Increase in inventory C. Increase in accounts payable D. Recognition of cost of goods sold
d
26. A simple information system includes all but the following elements except: a. Processing. b. Storage. c. Input. d. Reporting.
d
26. According to a recent study, the transform IT strategic role is defined as systems that: a. Replace human labor in automating business processes. b. Provide information about business activities to all employees. c. Provide information about business activities to senior management. d. Fundamentally redefine business processes and relationships.
d
26. An example of an AIS that primarily addresses internal business processes includes: a. Supply chain software. b. Customer relationship management software. c. B2B transaction software. d. Enterprise systems.
d
26. Support activities in the value chain do not include: a. Firm Infrastructure. b. Human Resource Management. c. Procurement. d. Accounting and Finance.
d
26. Which designation would be most appropriate for those professionals possessing IT audit, control and security skills? a. Certified Internal Auditor (CIA) b. Certified Public Accountant (CPA) c. Certified Information Technology Professional (CITP) d. Certified Information Systems Auditors (CISA)
d
41. A foreign key in a database table is always: A. A unique identifier for a record in that table B. A numeric field C. The name of a UML class D. A primary key in a related table
d
41. Classes in a relational database model for AISs are typically grouped into all of the following categories except: A. Events B. Agents C. Resources D. Activities
d
41. Consider the following SQL query. Which item best describes the results of the query? SELECT VendorID, Sum(POTotal) FROM [Purchase Orders] GROUP BY VendorID A. Displays all purchase order lines for all vendors B. Adds new purchase order information to the purchase orders table C. Displays the vendor ID and all purchase order totals in the purchase orders table D. Displays the vendor ID and the sum of all purchase order totals for that vendor
d
41. 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? A. Cash Receipts (1..1) - Sale (1..1) B. Cash Receipts (1..N) - Sale (0..N) C. Cash Receipts (1..1) - Sale (N..M) D. Cash Receipts (0..N) - Sale (1..1)
d
Which of the following is not a primary activity in the Value Chain? a. Outbound Logistics. b. Marketing. c. Inbound Logistics. Information Technology
d
1. A Class is a separately identifiable collection of business relationships.
f
1. A database should have exactly the same number of tables as there are Classes in the Unified Modeling Language (UML) Class diagram from which the database is developed.
f
1. Activity models are a relatively new process modeling tool.
f
1. An aggregation relationship is a form of generalization relationships.
f
1. Business Process Modeling Notation (BPMN) activity diagrams depict activities as circles.
f
1. Business Process Modeling Notation (BPMN) activity models typically show the sequence of flow from right to left and top to bottom.
f
1. Business Process Modeling Notation (BPMN) start events are shown using ovals and flowchart start events are shown using circles.
f
1. Classes could be grouped into Resources (R), Entities (E), and Assets (A) in data modeling.
f
1. Data Flow Diagrams start with a circle indicating the start event.
f
1. Each attribute in a table can have several names.
f
1. Gateways only show decisions and possible branching as a result of the decision.
f
1. In Access, users can edit database information in reports.
f
1. In Unified Modeling Language (UML) primary keys may be blank.
f
1. In Unified Modeling Language (UML) the options for maximum multiplicity values are 0 and *.
f
1. In Unified Modeling Language (UML) the options for minimum multiplicity values are 0, 1, and 2.
f
1. In Unified Modeling Language (UML) the options for minimum multiplicity values are 1 and *.
f
1. In a collaboration model using BPMN, the interaction between participants is called orchestration.
f
1. Many-to-many relationships are implemented by posting a foreign key.
f
1. One-to-one relationships are implemented by creating a linking table.
f
1. The SQL command "Group by" can be used to order an amount in a descending order.
f
A BPMN process flow can start in one pool and end in the collaborating pool
f
Access offers modules, which are defined by users to automate processes like opening a specific form
f
Application controls limit who can change records in a system
f
Because business models are simpler than the processes they depict, they are limited in their ability to integrate local views of a process
f
Business rules are unrelated to COSO control activities, although they serve an important purpose
f
In Unified Modeling Language (UML) Class diagrams, Associations are represented by dashed lines
f
In a hierarchical data model, data elements are related in many-to-many relationships
f
Obligatory business rules state what should not occur
f
Queries in Access are utilized by users to enter data into tables and view existing records
f
