AIS Final Exam

Which of the following is a well-formed business rule? a. Customers must pay in U. S. dollars. b. Customers must be over 18 years of age. c. Customers may not be under 18 years of age. d. All of these are well-formed business rules.

d. All of these are well-formed business rules.

Which of the following is not a characteristic of a business model? a. Contains business process information. b. Graphical. c. Simple. d. Always refers to only one business process.

d. Always refers to only one business process

Which of the following notations is used to depict different organizations in one Business Process Modeling Notation (BPMN) diagram? a. Message flow. b. Intermediate event. c. Gateway. d. Pool.

d. Pool.

Which of the following is the best description of an association? a. The number of times one class is related to another. b. Grouping of items. c. A group of classes. d. The relationship between two classes

d. The relationship between two classes

Which of the following best describes the difference between access controls and application controls?

Access controls limit who can change records and application controls ensure data integrity and provide an audit trail of any changes.

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

Using the following table what will result from the SQL command "SELECT *, WHERE [Price] = $5"?

All columns, rows 1 & 3

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.

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?

Customers may pay for sales orders in multiple payments.

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.

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?

Each cash receipt pays for at least one order, but it could pay for many orders.

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.

In the following diagram, which of the following provides the best interpretation of the multiplicities for the association between the employees and purchases classes?

Each purchase must be made by one employee.

When implementing the database from a UML class diagram, associations should be mapped to which of the following?

Foreign keys

In order to perform their required roles and be valuable business partners, accountants must understand all of the following except:

How the business identifies and designs its products and services

Which of the following best describes the purpose of an intermediate timer event?

Illustrates the process flow when a delay occurs.

The correct order of effects in the value chain are:

Inbound logistics --> operations --> outbound logistics

Accounting information systems is:

Include records, processes and reports

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.

A boundary event in a BPMN activity model:

Is attached to the edge of an activity

What is the main purpose of using foreign keys in a relational database design?

It is used to link tables

What is the best description of the relationship between instructor and course in the following UML class diagram?

Many to many

Which type of data models allows each record to have multiple parent and child records?

Network model

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.

Which of the following two tables would likely result in a many-to-many relationship in a purchases and payments class diagram?

Purchase Order and Products.

Which of the following would likely be a primary key in a purchases table?

Purchase_Order_Number

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

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.

Investors reward companies most that announce IT initiatives with which type of strategic role?

Transform

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

True or False? Accountants now face a challenge of helping businesses optimize process

True

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.

Which of following are possible options for minimum multiplicities? a. 0 and 1. b. 0, 1, and *. c. 0 and *. d. * and 1.

a. 0 and 1.

Which of the following best describes a type image? a. A UML class added to collect management information, such as category. b. A description attached to a UML association when there are multiple associations between classes. c. A description attached to a BPMN gateway that clarifies the nature of the gateway. d. A BPMN activity that allows a business process to branch based on type.

a. A UML class added to collect management information, such as category.

Which of the following accounts is generally not impacted as part of the Sales and Collections process? a. Accounts Payable b. Inventory c. Cash d. Accounts Receivable

a. Accounts Payable

Which of the following least reflects the purpose of a business rule in the purchase process? a. Ensure suppliers are satisfied b. Ensure an audit trail c. Require segregation of order, receiving, and payment duties d. Ensure suppliers are paid on time

a. Ensure suppliers are satisfied

Process documentation does not include which of the following? a. External audit workpapers. b. Business rules. c. Process models. d. User manuals.

a. External audit workpapers

Which of the following activities is not associated with the sales and collection business process? a. Maintaining vendor records. b. Selling products and services. c. Recording customer payments. d. Billing customers.

a. Maintaining vendor records.

Which of the following is not something a business rule would implement? a. Notifications b. Segregation of Duties c. Authorization d. Approval

a. Notifications

Which of the following is not accurate? a. Records represent attributes of a table. b. Fields represent attributes of a class. c. Rows in a table are called records. d. Columns in a table are called fields.

a. Records represent attributes of a table.

Which of the following is not a desired access control when developing a purchases and payments business process? a. The person returning items to the supplier must not view the original purchase order. b. The person paying the supplier must not be able to modify the purchase order. c. The person placing the purchase order must not receive the items. d. The person receiving the order must not see the original purchase order quantities.

a. The person returning items to the supplier must not view the original purchase order.

In a BPMN activity diagram, which of the following represent a valid use for an intermediate timer event? a. Represent a time delay b. All of these choices are correct c. Indicates a delay to a specific date/time d. Indicates a delay to a relative date, such as next Thursday

b. All of these choices are correct

Which of the following is not one of the building blocks used for creating UML Class Diagrams? a. Classes. b. Events. c. None of these other choices are used in UML Class Diagrams. d. Associations.

b. Events.

Which of the following is not a valid enforcement level for business rules? a. Strict Enforcement. b. Segregation. c. Pre-override. d. Post-override.

b. Segregation.

Which of the following is an example of an application control for the purchases and payments business process? a. Management approval is required for large purchases. b. The purchase order number is automatically assigned. c. The employee who receives supplier goods must not be the same employee who ordered the goods. d. Defective items should be returned to suppliers promptly.

b. The purchase order number is automatically assigned.

Which of the following best represents a business rule in a decision table where the decision table relates to shipping rules? a. Type of payment for the shipping. b. What to charge the customer for shipping based on location. c. Customer status in a rewards program. d. Choice of shipping carrier.

b. What to charge the customer for shipping based on location.

Which of the following symbols depicts an activity? a. An arrow. b. A circle with a wide single line perimeter. c. A rectangle. d. A circle with a double line perimeter.

c. A rectangle.

Which of the following is not a likely module of an Enterprise Reporting System (ERP)? a. Sales and Distribution. b. Financial Accounting. c. Cloud based computing. d. Payroll.

c. Cloud based computing.

A pool in a BPMN activity model represents:

An organization/entity.

When implementing the database from a UML class diagram, attributes should be mapped to which of the following?

Attributes

The IT strategic roles of AIS investments are classified as:

Automate, informate, transform

Which of the following systems would a company be most likely to employ for the primary purpose of generating additional sales revenue?

CRM

Which of the following items can best be described as a "Resource" in the REA data model? a. Two of the above are correct. b. Cash. c. Sales. d. Cashier.

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 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

Business rules are an example of which COSO concept?

Control activities

One of the most important ways 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.

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?

5

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 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.

In Microsoft Access, we use "Forms" for:

Data entry

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?

Every product category includes at least one inventory item.

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.

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 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?

Post the primary key of Cities as a foreign key in Neighborhoods

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

The purchase is generally recorded in the financial statements when which of the following activities takes place?

Receive items.

What kind of data model has the greatest ability to scale?

Relational data model

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?

Several employees participate in each sale.

Which of the following best describes the orchestration in a BPMN activity diagram?

Shows the sequence of activities within one pool.

Consider the following diagram. How will the database relationship between Customers and Sales Orders be implemented?

The Customer ID will be included as a foreign key in the Sales Orders table.

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)".

The Information Value Chain is defined as:

The overall transformation of data from a business need to the ultimate decision

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 situation best exemplifies why anaylsts must understand process decision requirements? a. A business can only transact with retailers who have a valid business license b. A business sells multiple types of widgets c. A business has three bank accounts d. A business accepts cash, checks and all major credit cards

a. A business can only transact with retailers who have a valid business license

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. Reduced information redundancy. c. Simplicity. d. Increased flexibility and scalability.

a. Exclusively uses parent/child relationships.

Which of the following best describes how business models help companies manage complexity? a. Business models' limitations force managers to simplify the company's actual processes. b. Although business models are a simplification of the actual processes they represent, they incorporate the processes' essential elements. c. Because business models can't exceed one page, managers can understand how the business works at a glance. d. Business models must display every detailed task and activity, which allows managers to visualize the complexity inherent in its business processes.

b. Although business models are a simplification of the actual processes they represent, they incorporate the processes' essential elements.

Which of the following is not an example of a business rule? a. Managers must approve orders over $10,000 b. Inventory must be maintained in a secure location c. The credit department must approve all sales on account d. Employee who receives checks can not change invoices

b. Inventory must be maintained in a secure location

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. Shows branching and merging in a business process. d. Affects the flow of a business process.

b. Shows interactions between participants in a process.

Which of the following is not an application control when placing a purchase order? a. System provided purchase order number. b. System provided type image. c. System provided default values. d. System provided range and limit checks.

b. System provided type image.

Which of the following best describes the difference between a Business Process Modeling Notation (BPMN) gateway and a flowcharting decision diamond? a. Only the gateway shows branching of the sequence flow. b. The gateway only represents branching and not the decision that results in branching. c. The decision diamond can depict more branching options. d. Only the decision diamond shows branching of the sequence flow.

b. The gateway ony represents branching and not the decision that results in branching.

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 attributes or characteristics of the entities and relationships. d. The cardinalities that describe how many instances of one entity can be related to another.

b. The sequence that entities are accessed.

Which of the following is not part of the business analysis process? a. Documenting current and future business processes. b. Using business process modeling tools. c. Auditing business processes. d. Ascertaining information about current and future business processes.

c. Auditing business processes.

Which of the following tasks cannot be performed through queries in access? a. Retrieve and display data. b. Data sorting. c. Create and update relationships. d. Calculations of data.

c. Create and update relationships.

When creating a BPMN activity model, which of the following is most accurate? a. All activity models should include gateways. b. The resulting BPMN activity model should closely match the structure of the subsequent database. c. Different modelers given the same set of facts about a busines process should develop similar models of the process. d. 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.

c. Different modelers given the same set of facts about a busines process should develop similar models of the process.

Business models provide value in all of the following areas except which one? a. Specifying systems requirements. b. Eliciting requirements for new systems. c. Employee performance appraisal. d. Managing complexity.

c. Employee performance appraisal.

Which of the following is not a construct in a relational database? a. Tables b. Attributes c. Forms d. Records

c. Forms

Which of the following represents a parallel multi-instance task? a. One employee taking pizza orders. b. Two baristas working at a Starbucks counter.Incorrect c. Many customers watching one movie. d. One employee taking an order while another collects payment in a drive-through.

c. Many customers watching one movie.

Which of the following best describes the choreography in a BPMN activity diagram? a. Hides activities that are not of interest in the analysis of the business process. b. Follows the sequence flow from start to end. c. Shows the interaction of messages between participants in the business process. d. Shows the sequence of activities within one pool.

c. Shows the interaction of messages between participants in the business process.

Which of the following is not one of the objects used in Microsoft Access? a. Tables. b. Forms. c. Sites. d. Macros.

c. Sites.

Activity models are analagous to which of the following? a. A blueprint. b. The prototype for a new car model. c. The instructions in a recipe. d. A car's steering system.

c. The instructions in a recipe.

Which of the following is not a criterion for selection of a primary key? a. Primary keys with sequential values make it easier to spot gaps in the data. b. The primary key cannot be NULL (blank). c. The primary key should always be numeric. d. The primary key should be controlled by the organization assigning it.

c. The primary key should always be numeric.

Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams? a. Avoid crossing lines whenever possible. b. Avoid confusing abbreviations. c. Use various size class rectangles. d. Opt for simplicity.

c. Use various size class rectangles.

A Query in a program language such as Structured Query Language (SQL) can be used to: a. Retrieve data. b. Update data. c. Report data. d. All of the choices are correct.

d. All of the choices are correct.

Which of the following best describes the purpose of an activity model? a. An activity model depicts data structures. b. None of the choices are correct. c. An activity model constrains and guides process operations. d. An activity model describes the sequence of workflow in a business process.

d. An activity model describes the sequence of workflow in a business process.

Which of the following best describes the purpose of an intermediate error event? a. Contains a series of activities that are hidden from view. b. Depicts the sequence of activities in one pool. c. Shows the interchange between two pools. d. Illustrates the process flow when an exception occurs.

d. Illustrates the process flow when an exception occurs.