ACC 409 FINAL EXAM QUESTIONS AND ANSWERS WITH
COMPLETE SOLUTIONS GRADED A++
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. Inbound Logistics - Operations - Outbound logistics
A business process is the
Sequence of activities performed by a business for acquiring, producing, and selling
good and services.
Purpose of a gateway in a business process modeling notation (BPMN) activity
diagram
Controls branching and merging
The information value chain is defined as:
The overall transformation of data from a business need to the ultimate decision.
,What is an association?
The relationship between two classes
What is a supply chain?
Refers to the flow of materials, information, payments and services.
An accounts payable clerk is responsible for recording invoices. The
responsibility of the clerk for the event is represented by
swimlane
Purpose of an event in a BPMN activity diagram
Affects the flow of the business process.
not a criterion for the selection of a primary key
Longer key values are better than shorter key values
A dental practice implemented an upgrade to its AIS that provides the dentists
with daily and weekly patient and financial summaries. The practice's upgrade is
an example of which IT strategic role?
Informate - up.
Consider an association between a Customers class and a Sale class in a UML
Class diagram. The multiplicities next to the Customers class are 1..1 and the
multiplicities next to the Sale class are 0..*. What is the best way to implement
that association in your database?
Post the primary key of Customers as a foreign key in Sales.
Consider the following SQL query. What 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
Activities associated with the sales and collection business process
1. Billing customers
2. Selling products and services
3. Recording customer payments
In Microsoft Access, we use "Tables" for:
Data storage
At the beginning of Jane's shift there was $100 in the cash register. At the end of
the shift there was $650 in currency and $150 in checks. According to the cash
register printout, the total sales was $660 and the sales tax was 45. What was the
amount of cash short or over?
$5 short
Consider an association between a Sales class and an Inventory class in a 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?
Create a linking table.
What best describes the difference between access controls and application
controls?
Access controls limit who can change records and application controls provide an audit
trail of any changes.
COMPLETE SOLUTIONS GRADED A++
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. Inbound Logistics - Operations - Outbound logistics
A business process is the
Sequence of activities performed by a business for acquiring, producing, and selling
good and services.
Purpose of a gateway in a business process modeling notation (BPMN) activity
diagram
Controls branching and merging
The information value chain is defined as:
The overall transformation of data from a business need to the ultimate decision.
,What is an association?
The relationship between two classes
What is a supply chain?
Refers to the flow of materials, information, payments and services.
An accounts payable clerk is responsible for recording invoices. The
responsibility of the clerk for the event is represented by
swimlane
Purpose of an event in a BPMN activity diagram
Affects the flow of the business process.
not a criterion for the selection of a primary key
Longer key values are better than shorter key values
A dental practice implemented an upgrade to its AIS that provides the dentists
with daily and weekly patient and financial summaries. The practice's upgrade is
an example of which IT strategic role?
Informate - up.
Consider an association between a Customers class and a Sale class in a UML
Class diagram. The multiplicities next to the Customers class are 1..1 and the
multiplicities next to the Sale class are 0..*. What is the best way to implement
that association in your database?
Post the primary key of Customers as a foreign key in Sales.
Consider the following SQL query. What 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
Activities associated with the sales and collection business process
1. Billing customers
2. Selling products and services
3. Recording customer payments
In Microsoft Access, we use "Tables" for:
Data storage
At the beginning of Jane's shift there was $100 in the cash register. At the end of
the shift there was $650 in currency and $150 in checks. According to the cash
register printout, the total sales was $660 and the sales tax was 45. What was the
amount of cash short or over?
$5 short
Consider an association between a Sales class and an Inventory class in a 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?
Create a linking table.
What best describes the difference between access controls and application
controls?
Access controls limit who can change records and application controls provide an audit
trail of any changes.
