Question 1

Many-to-many relationships are implemented by posting a foreign key.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

What step should be taken when designing a relational database when a many-to-many relationships exists?

Accepted Answer

A) No action is needed. 
B) Create a boundary event. 
C) Create two one-to-many relationships. 
D) Recreate the foreign key. 
A) No action is needed. 
B) Create a boundary event. 
C) Create two one-to-many relationships. 
D) Recreate the foreign key.

Question 4

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

Accepted Answer

A) The Sales Order ID will be included as a foreign key in the Employees table. 
B) The Employee ID will be included as a primary key in the Employees table. 
C) The Sales Order ID will be included as a primary key in the Employees table. 
D) The Employee ID will be included as a foreign key in the Sales Orders table. 
A) The Sales Order ID will be included as a foreign key in the Employees table. 
B) The Employee ID will be included as a primary key in the Employees table. 
C) The Sales Order ID will be included as a primary key in the Employees table. 
D) The Employee ID will be included as a foreign key in the Sales Orders table.

Question 5

Which of the following best describes the purpose of a BPMN collapsed sub-process?

Accepted Answer

A) A series of events is hidden from view as the information is not well controlled. 
B) The collapsed process will be modeled at a later time. 
C) A series of events is hidden from view as the information is not necessary to the model. 
D) The collapsed process contains too many errors. 
A) A series of events is hidden from view as the information is not well controlled. 
B) The collapsed process will be modeled at a later time. 
C) A series of events is hidden from view as the information is not necessary to the model. 
D) The collapsed process contains too many errors.

Question 6

An intermediate error event can be used to model process exceptions.

Accepted Answer

A) True 
 B)False

Question 7

Application controls limit who can change records in a system.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) Access controls limit who can change records and application controls ensure data integrity and provide an audit trail of any changes. 
B) Access controls limit how many records can be changed and application controls ensure segregation of duties. 
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) Access controls limit who can change records and application controls ensure data integrity and provide an audit trail of any changes. 
B) Access controls limit how many records can be changed and application controls ensure segregation of duties. 
C) Access controls are "prohibited" business rules and application controls are "allowed" business rules. 
D) There is no difference between access and application controls.

Question 10

Review the following diagram.Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class?

Accepted Answer

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

Question 11

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?

Accepted Answer

A) A new table will be created that contains both Sales Order ID and Product ID as its composite primary key. 
B) The Product ID will be included as a foreign key in the Sales Orders table. 
C) The Sales Order ID will be included as a foreign key in the Products table. 
D) The Quantity Ordered field will be included as a foreign key in the Products table. 
A) A new table will be created that contains both Sales Order ID and Product ID as its composite primary key. 
B) The Product ID will be included as a foreign key in the Sales Orders table. 
C) The Sales Order ID will be included as a foreign key in the Products table. 
D) The Quantity Ordered field will be included as a foreign key in the Products table.

Question 12

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?

Accepted Answer

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

Question 13

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?

Accepted Answer

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

Question 14

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

Accepted Answer

A) The Sales Order ID will be included as a foreign key in the Customers table. 
B) The Customer ID will be included as a foreign key in the Sales Orders table. 
C) The Customer ID will be included as a primary key in the Customer table. 
D) The Sales Order ID will be included as a primary key in the Customer table. 
A) The Sales Order ID will be included as a foreign key in the Customers table. 
B) The Customer ID will be included as a foreign key in the Sales Orders table. 
C) The Customer ID will be included as a primary key in the Customer table. 
D) The Sales Order ID will be included as a primary key in the Customer table.

Question 15

Segregation of duties is an example of a COSO control activity.

Accepted Answer

A) True 
 B)False

Many-to-many relationships are implemented by posting a foreign key.

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

What step should be taken when designing a relational database when a many-to-many relationships exists?

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

Which of the following best describes the purpose of a BPMN collapsed sub-process?

An intermediate error event can be used to model process exceptions.

Application controls limit who can change records in a system.

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

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

Review the following diagram.Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class?

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?

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?

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?

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

Segregation of duties is an example of a COSO control activity.

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Relational Databases and Enterprise Systems

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 5: Sales and Collections Business Process

Many-to-many relationships are implemented by posting a foreign key.

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

What step should be taken when designing a relational database when a many-to-many relationships exists?

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

Which of the following best describes the purpose of a BPMN collapsed sub-process?

An intermediate error event can be used to model process exceptions.

Application controls limit who can change records in a system.

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

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

Review the following diagram.Which answer provides the best interpretation of the multiplicities for the association between the Quote class and the Order class?

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?

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?

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?

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

Segregation of duties is an example of a COSO control activity.

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Relational Databases and Enterprise Systems

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Data Analytics in Accounting: Tools and Practice

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters