Data Integrity and Availability Quiz

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary purpose of concurrent update controls?

To enhance data recovery procedures.

To ensure only one person can input data at a time. (correct)

To allow simultaneous processing of multiple transactions.

To facilitate data backups.

Which integrity control involves comparing data to ensure it matches?

Reconciliation procedures. (correct)

External data reconciliation.

Data transmission control.

User review of output.

Which control measure is NOT considered a preventive control?

Fault tolerance.

Data center location and design.

RPO. (correct)

Training.

What does RTO stand for in data recovery contexts?

Recovery Time Objective. Signup and view all the answers

What is the primary difference between incremental backups and full backups?

Incremental backups copy data items changed since the last backup. Signup and view all the answers

Which of the following is NOT a type of preventive maintenance mentioned?

User review of output. Signup and view all the answers

What is the function of data transmission control?

To ensure accurate data over a network. Signup and view all the answers

Which of the following controls helps a system maintain functionality during hardware or software failures?

Fault tolerance. Signup and view all the answers

What is the primary benefit of using Electronic Funds Transfer (EFT)?

It reduces the risk of stolen cash Signup and view all the answers

What does FEDI combine to streamline payment processes?

EFT and EDI Signup and view all the answers

Which step is NOT part of the expenditure cycle?

Generating sales reports Signup and view all the answers

What is required to trigger the pick and pack order process in a warehouse?

A picking ticket Signup and view all the answers

Why is it beneficial for buyers to use FEDI?

It simplifies the transfer of payment and remittance data Signup and view all the answers

Which document indicates who is responsible for the goods while in transit?

Bill of lading Signup and view all the answers

What is a primary objective of the expenditure cycle?

Minimize cost Signup and view all the answers

In the billing process, from which department is the pricing information required?

Sales department Signup and view all the answers

What action is taken first in the expenditure cycle?

Ordering goods Signup and view all the answers

What role does EDI play in the expenditure cycle?

It facilitates online orders Signup and view all the answers

What document is generated when customer payment is returned to the billing department?

Remittance advice Signup and view all the answers

How does submission of payment via FEDI differ from traditional methods?

Payment and remittance are sent together electronically Signup and view all the answers

Which document provides a summary of the remaining balance that a customer owes?

Monthly statement Signup and view all the answers

What is the function of the cashier in the cash collection process?

Managing customer remittances Signup and view all the answers

What document is used to authorize the billing department to credit accounts receivable?

Credit memo Signup and view all the answers

Which department is responsible for updating accounts receivable using information from sales invoices?

Accounting department Signup and view all the answers

What is the primary purpose of the Economic Order Quantity (EOQ) approach?

Minimize the total inventory costs Signup and view all the answers

What is a reorder point in inventory management?

The specific stock level that triggers a new order Signup and view all the answers

How does Just-In-Time (JIT) inventory management minimize problems?

By ordering supplies only as needed based on demand Signup and view all the answers

What is the key concept behind Material Requirements Planning (MRP)?

To forecast demand and purchase supplies accordingly Signup and view all the answers

Which of the following approaches eliminates the risk of inventory issues by ordering based on current demand?

Just-In-Time (JIT) Signup and view all the answers

What is the primary objective of the revenue cycle?

Providing the right product at the right place and right time Signup and view all the answers

What type of disaster recovery option involves having an empty building and contracting for hardware and software?

Cold site Signup and view all the answers

Which step in the revenue cycle involves checking and approving customer credit?

Sales order entry Signup and view all the answers

What is the most expensive option among disaster recovery strategies?

Real time mirroring Signup and view all the answers

Which of the following is least likely the focus of a Business Continuity Plan (BCP)?

Restoration of IT functions Signup and view all the answers

In the sales order entry process, what document is used to inform inventory control about the items to be sent?

Picking ticket Signup and view all the answers

What is a key component that is important for both Disaster Recovery Plan (DRP) and Business Continuity Plan (BCP)?

Periodic testing and revision Signup and view all the answers

Which recovery options have a Recovery Point Objective (RPO) and Recovery Time Objective (RTO) closest to zero?

Real time mirroring Signup and view all the answers

What is the main purpose of input integrity checks?

To minimize errors in data entry Signup and view all the answers

Which of the following is NOT a type of integrity check mentioned?

Consistency check Signup and view all the answers

What does a limit check validate?

That the data does not exceed specified maximum or minimum limits, but not simultaneously Signup and view all the answers

The purpose of a validity check is to:

Compare transaction data against a master file Signup and view all the answers

What is sequentially pre-numbering forms intended to achieve?

To verify that no documents are missing Signup and view all the answers

Which type of check ensures that the data within a field matches an expected type?

Field check Signup and view all the answers

What is an example of a reasonableness test?

Checking if a person's age falls within a sensible range Signup and view all the answers

Which input control specifically checks for numerical data?

Sign check Signup and view all the answers

What is the main goal of cancellation data management?

To ensure that data cannot be reused after cancellation Signup and view all the answers

What should be done with the original files after cancellation to maintain audit trails?

Keep them for future reference Signup and view all the answers

Study Notes

Processing Integrity and Availability

Integrity checks data for accuracy, completeness, and correctness
Availability ensures data is usable for operations needs
Integrity is broken down into three components: inputs, processing, and outputs

Input Controls

Form design minimizes data entry errors
Sequential pre-numbering verifies no documents are missing
Turnaround documents eliminate errors by returning documents for completion
Cancellation data prevents duplicate entries
Automated entry controls include:
- Field checks verify data in fields is correct
- Sign checks ensure data follows expected signs (positive/negative)
- Limit checks prevent exceeding maximum or minimum limits.
- Range checks verify data within specified ranges
- Size checks verify appropriate data size
- Completeness checks ensure all required data is present
- Validity checks compare data to a master file for accuracy.
- Reasonableness test validates data for logical consistency
- Check digit verification verifies data entry accuracy.

Batch Processing Controls

For processing large amounts of data, not real-time
Sequence checks verify data order is correct
Batch totals (hash total, financial total, record count) allow for error detection .

Online Real-time Processing Controls

Prompting verifies completeness
Closed-loop verification uses input data to verify related data

Processing Controls

Data matching verifies data consistency between different sources.
File labels ensure that updated files are used
Recal of batch totals are used to compare totals (financial, hash, and record count) to trailer records
Cross-footing is a calculation method to verify the accuracy of accounting records.
Zero-balance test verifies that credits and debits balance.
Write protection protects data from modification
Concurrent update controls prevent simultaneous data entry by different users.

Output Controls

User review of output involves manual review of outputs by users.
Reconciliation procedures compare system data with external data.
External data reconciliation compares system data with external data sets.
Data transmission controls are used to safeguard transmission of data.

Availability Controls

Preventive maintenance ensures system hardware and software are functioning correctly.
Fault tolerance ensures the system can continue operating even with hardware or software failures.
Data center location and design are critical for physical security.
Training for personnel is necessary for maintaining proper procedures.
Patch management and antivirus protection is critical

Disaster Recovery Plan (DRP)

Plans to restore IT functions when a disaster occurs
Three options: cold site, hot site, real-time mirroring

Business Continuity Plan (BCP)

Focuses on business process continuity
Periodic testing and revision of the BCP is critical

Revenue Cycle

Primary objective is to provide the right product at the right place at the right time.
Sales order entry involves taking customer orders, checking credit and inventory, and responding to inquiries.
Shipping includes picking and packing orders, and shipping goods.
Billing involves generating invoices.
Cash collection involves collecting payments.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge on the concepts of data integrity and availability. This quiz covers important aspects such as input controls and various automated entry checks to ensure data accuracy and completeness. Perfect for those studying information systems or data management.