Data Integrity and Availability Quiz
47 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

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?

<p>Recovery Time Objective. (D)</p> Signup and view all the answers

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

<p>Incremental backups copy data items changed since the last backup. (A)</p> Signup and view all the answers

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

<p>User review of output. (B)</p> Signup and view all the answers

What is the function of data transmission control?

<p>To ensure accurate data over a network. (D)</p> Signup and view all the answers

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

<p>Fault tolerance. (B)</p> Signup and view all the answers

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

<p>It reduces the risk of stolen cash (D)</p> Signup and view all the answers

What does FEDI combine to streamline payment processes?

<p>EFT and EDI (D)</p> Signup and view all the answers

Which step is NOT part of the expenditure cycle?

<p>Generating sales reports (C)</p> Signup and view all the answers

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

<p>A picking ticket (B)</p> Signup and view all the answers

Why is it beneficial for buyers to use FEDI?

<p>It simplifies the transfer of payment and remittance data (B)</p> Signup and view all the answers

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

<p>Bill of lading (D)</p> Signup and view all the answers

What is a primary objective of the expenditure cycle?

<p>Minimize cost (D)</p> Signup and view all the answers

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

<p>Sales department (C)</p> Signup and view all the answers

What action is taken first in the expenditure cycle?

<p>Ordering goods (B)</p> Signup and view all the answers

What role does EDI play in the expenditure cycle?

<p>It facilitates online orders (B)</p> Signup and view all the answers

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

<p>Remittance advice (A)</p> Signup and view all the answers

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

<p>Payment and remittance are sent together electronically (D)</p> Signup and view all the answers

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

<p>Monthly statement (A)</p> Signup and view all the answers

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

<p>Managing customer remittances (D)</p> Signup and view all the answers

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

<p>Credit memo (C)</p> Signup and view all the answers

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

<p>Accounting department (C)</p> Signup and view all the answers

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

<p>Minimize the total inventory costs (A)</p> Signup and view all the answers

What is a reorder point in inventory management?

<p>The specific stock level that triggers a new order (C)</p> Signup and view all the answers

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

<p>By ordering supplies only as needed based on demand (A)</p> Signup and view all the answers

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

<p>To forecast demand and purchase supplies accordingly (B)</p> Signup and view all the answers

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

<p>Just-In-Time (JIT) (A)</p> Signup and view all the answers

What is the primary objective of the revenue cycle?

<p>Providing the right product at the right place and right time (D)</p> Signup and view all the answers

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

<p>Cold site (A)</p> Signup and view all the answers

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

<p>Sales order entry (A)</p> Signup and view all the answers

What is the most expensive option among disaster recovery strategies?

<p>Real time mirroring (A)</p> Signup and view all the answers

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

<p>Restoration of IT functions (C)</p> 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?

<p>Picking ticket (C)</p> 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)?

<p>Periodic testing and revision (A)</p> Signup and view all the answers

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

<p>Real time mirroring (C)</p> Signup and view all the answers

What is the main purpose of input integrity checks?

<p>To minimize errors in data entry (A)</p> Signup and view all the answers

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

<p>Consistency check (D)</p> Signup and view all the answers

What does a limit check validate?

<p>That the data does not exceed specified maximum or minimum limits, but not simultaneously (B)</p> Signup and view all the answers

The purpose of a validity check is to:

<p>Compare transaction data against a master file (A)</p> Signup and view all the answers

What is sequentially pre-numbering forms intended to achieve?

<p>To verify that no documents are missing (A)</p> Signup and view all the answers

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

<p>Field check (B)</p> Signup and view all the answers

What is an example of a reasonableness test?

<p>Checking if a person's age falls within a sensible range (A)</p> Signup and view all the answers

Which input control specifically checks for numerical data?

<p>Sign check (D)</p> Signup and view all the answers

What is the main goal of cancellation data management?

<p>To ensure that data cannot be reused after cancellation (C)</p> Signup and view all the answers

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

<p>Keep them for future reference (A)</p> Signup and view all the answers

Flashcards

Concurrent Update Controls

Mechanisms to prevent multiple users from updating data simultaneously, maintaining data integrity.

Data Integrity Output Controls

Controls that ensure the accuracy and completeness of output data.

External Data Reconciliation

Verifying data from a system against external, independent sources to ensure accuracy.

Preventive Maintenance

Actions taken to prevent system failures, such as regular maintenance of hardware or software.

Signup and view all the flashcards

Fault Tolerance

The system's ability to continue functioning even when hardware or software parts fail.

Signup and view all the flashcards

RPO (Recovery Point Objective)

The maximum acceptable amount of data loss, when a system fails.

Signup and view all the flashcards

Incremental Backup

A backup that copies only the changes made since the last full or incremental backup.

Signup and view all the flashcards

RTO (Recovery Time Objective)

The maximum acceptable time to restore a system after a failure.

Signup and view all the flashcards

EDI for Order Processing

Electronic Data Interchange (EDI) automates order processing between buyer and supplier. The buyer electronically sends an order, and the supplier electronically sends back an invoice.

Signup and view all the flashcards

Picking Ticket

A document that triggers the picking and packing process in a warehouse. It lists the items and quantities to be shipped.

Signup and view all the flashcards

Packing Slip

A document included with a shipment that lists the items and quantities of the order. It does not include prices.

Signup and view all the flashcards

Bill of Lading

A document that shows who is responsible for the goods during transportation and outlines who pays the shipping fees.

Signup and view all the flashcards

Sales Invoice

A document that details the amount owed by the customer for the goods or services provided. It is sent to the customer.

Signup and view all the flashcards

Remittance Advice

A copy of the sales invoice that is returned to the customer with their payment. It shows proof of payment.

Signup and view all the flashcards

Credit Memo

A document authorized by the credit manager that allows the billing department to reduce the customer's outstanding balance.

Signup and view all the flashcards

Monthly Statement

A document sent to customers summarizing their outstanding balance and payments made over a period of time.

Signup and view all the flashcards

Differential Backup

A backup that copies all data that has changed since the last full backup, including all files modified since the last full backup.

Signup and view all the flashcards

Disaster Recovery Plan (DRP)

A plan that outlines how to restore IT systems and functions in case of a disaster. It focuses on bringing IT back online after a disaster.

Signup and view all the flashcards

Cold Site

An empty building that can be used as a temporary backup location for IT systems. It usually includes basic infrastructure but requires additional hardware and software.

Signup and view all the flashcards

Hot Site

A fully equipped backup facility that can be immediately used to restore IT systems. It has pre-installed hardware, software, and network connections.

Signup and view all the flashcards

Real Time Mirroring

A method of maintaining identical copies of data on multiple data centers in real time. This ensures minimal data loss and recovery time.

Signup and view all the flashcards

Business Continuity Plan (BCP)

A plan that outlines how to maintain essential business operations during and after a disaster. It focuses on the overall continuation of business activities.

Signup and view all the flashcards

Revenue Cycle

The series of steps a company takes to generate revenue, from sales order entry to cash collection.

Signup and view all the flashcards

Sales Order Entry

The first step in the revenue cycle, where customer orders are received, checked, and processed. It involves tasks like taking orders, checking credit, and reserving inventory.

Signup and view all the flashcards

EOQ Approach

A traditional method for calculating the optimal order quantity to minimize inventory holding and ordering costs.

Signup and view all the flashcards

Reorder Point

The predetermined stock level at which a new order is placed to avoid running out of inventory.

Signup and view all the flashcards

MRP (Material Requirements Planning)

A system that forecasts demand and plans the purchase of materials based on the projected production schedule.

Signup and view all the flashcards

JIT (Just-in-Time)

A system that orders materials only when they are needed, eliminating the need for large stockpiles.

Signup and view all the flashcards

Supermarket Approach

A system where materials are organized and readily available, like a supermarket, making it efficient to pick and use them.

Signup and view all the flashcards

Input Integrity

Ensuring the accuracy, completeness, and validity of data entered into a system.

Signup and view all the flashcards

Forms Design

Designing input forms that minimize errors and increase efficiency. This includes features like sequential pre-numbering and turnaround documents.

Signup and view all the flashcards

Sequential Pre-Numbering

Assigning sequential numbers to documents to ensure none are missing.

Signup and view all the flashcards

Turnaround Document

A document sent to users for completion, then returned for input, reducing errors by allowing users to review their own data.

Signup and view all the flashcards

Cancellation Data

Mechanisms to prevent duplicate data entries, ensuring records are not accidentally processed multiple times. A trail record is maintained for auditing purposes.

Signup and view all the flashcards

Field Check

Automated input control that verifies the data type and format of the input in a specific field.

Signup and view all the flashcards

Sign Check

Automated input control that verifies the appropriateness of the sign (+ or -) of the input in a field.

Signup and view all the flashcards

Limit Check

Automated input control that verifies the input value is within a specific limit (maximum or minimum).

Signup and view all the flashcards

Range Check

Automated input control that verifies the input value is within a specified range (minimum and maximum).

Signup and view all the flashcards

Size Check

Automated input control that checks the length of the input data to ensure it fits within the allocated storage space.

Signup and view all the flashcards

FEDI

A combination of Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI) that streamlines payment processes by transmitting payment data and order information in one electronic package.

Signup and view all the flashcards

EFT vs. FEDI

While Electronic Funds Transfer (EFT) only transfers money electronically, FEDI incorporates both EFT for payments and EDI for order information, simplifying the payment process and eliminating the need for multiple documents.

Signup and view all the flashcards

Benefits of FEDI

FEDI reduces the risk of lost or stolen cash, streamlines payment and order processes, and automates data transfer between buyer and seller.

Signup and view all the flashcards

Expenditure Cycle

A business process that focuses on the activities involved in acquiring and paying for goods and services. It is similar to the buyer's perspective of the revenue cycle.

Signup and view all the flashcards

4 Steps of Expenditure Cycle

The expenditure cycle involves four steps: 1) Ordering Goods 2) Receiving Goods 3) Approving Supplier Invoice, and 4) Cash Disbursement to Supplier.

Signup and view all the flashcards

Expenditure Cycle Objective

The primary objective of the expenditure cycle is to minimize cost by ensuring efficient and accurate processes for acquiring goods and services.

Signup and view all the flashcards

What is the advantage of using FEDI over separate EDI and EFT?

FEDI streamlines the process by combining data transfer and payment in one step, reducing the need for multiple transactions and ensuring faster and secure data exchange.

Signup and view all the flashcards

What are the key steps in the expenditure cycle?

The expenditure cycle involves ordering goods, receiving goods, approving invoices, and making cash disbursements to suppliers.

Signup and view all the flashcards

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.

Quiz Team

Related Documents

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.

More Like This

Data Integrity Quiz
5 questions

Data Integrity Quiz

PersonalizedSerendipity avatar
PersonalizedSerendipity
Data Integrity Quiz
10 questions

Data Integrity Quiz

CelebratedBeige avatar
CelebratedBeige
Use Quizgecko on...
Browser
Browser