D217 (AIS) Accounting Information Systems PRACTICE PASSED 163
QUESTIONS AND ANSWERS TIPS Western Governors University
Correct 163
Incorrect 0
Your answers
, Prescriptive analytics tells the user what actions should be taken in response to
specific questions. For example, some companies use predictive analytics to
optimize trade promotions. Prescriptive analytics helps them determine which
campaigns to run and for which products.
This is the compensating control function that allows a manager to review all
content of sales for accuracy.
Conceptually, the PDC framework addresses all necessary areas regarding
preventing, detecting, and correcting errors, but it fails to give specific examples of
controls to implement.
Don't know?
2 of 163
Definition
A data mart is a data warehouse created for a single function or
department. Modern data warehouses may contain gigabytes of data
for use by all business functions and departments. To maximize value
for single functions or departments, a data mart may be created within
the data warehouse that contains the data specific to the function's
requirements. For example, a sales data mart will contain all of the data
related to customers, salespeople, inventory, sales orders, etc., but not
manufacturing or financial data.
Give this one a try later!
, Statement on Auditing Standards No.
Seals of assurance
109 requires
Closed Database architecture is A data mart is
Don't know?
3 of 163
Definition
The purpose of the sales invoice is to bill the customer. The sales
invoice will be sent to the customer for payment. At the same time the
invoice will also update inventory, send a journal to the general ledger,
and record the sales journal.
Give this one a try later!
When a cash disbursement in
The update anomaly in unnormalized
payment of an accounts payable is
tables
recorded
Which operation represents the steps The purpose of the sales
for the encryption of data? invoice is to
Don't know?
, 4 of 163
Term
Why is the general ledger history file used for comparative financial
reports?
Give this one a try later!
The general ledger history file serves
The general ledger history file is
as a backup for lost transaction
primarily for storing customer data.
records.
The same format and account
structures allow for transactions The general ledger history file is used
to be grouped and categorized to track employee payroll changes.
consistently from year to year.
Don't know?
5 of 163
Term
The update anomaly in unnormalized tables
Give this one a try later!
QUESTIONS AND ANSWERS TIPS Western Governors University
Correct 163
Incorrect 0
Your answers
, Prescriptive analytics tells the user what actions should be taken in response to
specific questions. For example, some companies use predictive analytics to
optimize trade promotions. Prescriptive analytics helps them determine which
campaigns to run and for which products.
This is the compensating control function that allows a manager to review all
content of sales for accuracy.
Conceptually, the PDC framework addresses all necessary areas regarding
preventing, detecting, and correcting errors, but it fails to give specific examples of
controls to implement.
Don't know?
2 of 163
Definition
A data mart is a data warehouse created for a single function or
department. Modern data warehouses may contain gigabytes of data
for use by all business functions and departments. To maximize value
for single functions or departments, a data mart may be created within
the data warehouse that contains the data specific to the function's
requirements. For example, a sales data mart will contain all of the data
related to customers, salespeople, inventory, sales orders, etc., but not
manufacturing or financial data.
Give this one a try later!
, Statement on Auditing Standards No.
Seals of assurance
109 requires
Closed Database architecture is A data mart is
Don't know?
3 of 163
Definition
The purpose of the sales invoice is to bill the customer. The sales
invoice will be sent to the customer for payment. At the same time the
invoice will also update inventory, send a journal to the general ledger,
and record the sales journal.
Give this one a try later!
When a cash disbursement in
The update anomaly in unnormalized
payment of an accounts payable is
tables
recorded
Which operation represents the steps The purpose of the sales
for the encryption of data? invoice is to
Don't know?
, 4 of 163
Term
Why is the general ledger history file used for comparative financial
reports?
Give this one a try later!
The general ledger history file serves
The general ledger history file is
as a backup for lost transaction
primarily for storing customer data.
records.
The same format and account
structures allow for transactions The general ledger history file is used
to be grouped and categorized to track employee payroll changes.
consistently from year to year.
Don't know?
5 of 163
Term
The update anomaly in unnormalized tables
Give this one a try later!
