B4 Flashcards
A report that does not currently exist but that needs to be created on demand without having to get a software developer involved is known as a/an:
a. Ad hoc report. b. Exception report. c. Demand report. d. Scheduled report.
An ad hoc report is a report that does not currently exist but that needs to be created on demand without having to get a software developer involved.
Choice “c” is incorrect. A demand report is a specific report that can be printed or viewed on demand.
Choice “b” is incorrect. An exception report is a report produced when a specific condition or “exception” occurs.
Choice “d” is incorrect. Scheduled reports are the more traditional reports that display information in a predefined format and that are made available on a regular basis.
Avon Corporation has a management information system. From the management information system, several different reports are available, including reports that are monthly budget vs. actual reports, reports that highlight where sales representatives have not met their assigned sales quotas, account analysis reports that can be requested by accountants as needed as a part of the closing process, and reports that are created by end users to obtain information as needed at any time during the month. The 4 types of reports are best described as:
a. Scheduled reports, exception reports, demand reports, and ad hoc reports. b. Demand reports, scheduled reports, exception reports, and ad hoc reports. c. Scheduled reports, ad hoc reports, exception reports, and demand reports. d. Exception reports, scheduled reports, demand reports, and ad hoc reports.
Scheduled reports, exception reports, demand reports, and ad hoc reports.
Choice “a” is correct. Monthly reports of budget vs. actual data are normally called scheduled reports that are produced without anybody having to request them. Reports that highlight sales representatives not having met their assigned sales quotas are normally called exception reports. Reports that analyze accounts, or that provide other specific and non-changeable information, but only on demand, are normally called demand reports. Reports that provide information as requested by the end user, and are available on demand, are normally called ad hoc reports.
Note that these names are generic names.
In an accounting information system, which of the following types of computer files most likely would be a master file?
a. Payroll transactions. b. Cash receipts. c. Inventory subsidiary. d. Cash disbursements.
Inventory subsidiary.
Choice “c” is correct. The question can be readily addressed by using the “odd man out” principle. Just look at the other three choices. Each of them is a transaction file of some type; one of them is even called a transaction file. The other two (cash disbursements and cash receipts) are both transactions in a non-computerized accounting system and are transaction files in a computerized accounting system.
A distributed processing environment would be most beneficial in which of the following situations?
a. Large volumes of data are generated centrally and fast access is not required. b. Small volumes of data are generated centrally, fast access is required, and summaries are needed monthly at many locations. c. Small volumes of data are generated at many locations, fast access is required, and summaries of the data are needed promptly at a central site. d. Large volumes of data are generated at many locations and fast access is required.
Large volumes of data are generated at many locations and fast access is required.
A distributed (or decentralized) processing environment would be the most beneficial when large volumes of data are generated at many (remote) locations and fast access to the data is required. In centralized processing, there is always some delay (however small these days) in transmitting large volumes of data or transactions to the central site to be processed and then to be able to access the processed information. Decentralized processing eliminates that particular problem (although it does present other problems). Note that there seems to be an implied assumption in this question that the (remote) locations need access only to their own local data and not to all of the data for all locations. This choice seems to be better than choice “c”.
Choice “a” is incorrect. If large volumes of data are generated centrally, centralized processing would probably be more beneficial, regardless of whether or not fast access to that data is required. This choice implies that little, if any, data or transactions are generated at the remote locations so there would be no real need for distributed processing.
Choice “c” is incorrect. If summaries of the data are needed “promptly” at the central site, centralized processing MIGHT be more beneficial. Since only small volumes of data are generated at the remote locations, there would probably not be much delay in transmitting that data to the central location and probably not much delay in accessing that data. Since only summaries of the data are needed at the central location, those summaries could probably be readily prepared at the remote locations. This choice is the next best, and a case could certainly be made that the choice is correct. The decision could readily come down to summaries of “what” data. Is it summaries of all of the data generated by all locations or summaries of only the data generated by the remote location? If the former is what is meant, centralized processing would be more beneficial. If the latter is what is meant, distributed processing would probably be more beneficial.
what type of processing methods can you use for Batch Processing?
sequential storage or random access storage device.
magnetic tape and or disks
What type of computerized data processing system would be most appropriate for a company that is opening a new retail location?
a. Sequential-file processing. b. Batch processing. c. Direct-access processing. d. Real-time processing.
Real-time processing
Choice “d” is correct. In this question, a new “retail” location is being opened. Retail locations will normally have a large number of small transactions (think of a convenience store selling beer and chips), and that might make batch processing look to be most appropriate. However, it is important to know the current status of inventory so that inventory (what is and what is not selling) can be properly replenished (think of Walmart and its supply chain systems) and so that quick price reductions can be made for inventory that is not selling. This last factor makes real-time processing most appropriate.
Choice “b” is incorrect. There is nothing wrong with batch processing, but batch processing would probably not be used these days in the situation described in the question. In the past, batch processing was used to upload transaction data from individual stores to the retailer’s centralized processors (with the remainder of the processing being done centrally and possibly in batch); however, real time processing would be better (and more expensive). This kind of decision is almost always a cost/benefit decision. It would certainly be possible, in this situation, to have the retail store transactions uploaded after the close of business in batch, further processing of the transactions to be done centrally in batch, and new inventory figures transmitted back to the store in batch after the central processing is complete.
Choice “a” is incorrect. Sequential file processing is almost totally restricted to batch processing. Before direct access media were available at a reasonable cost, sequential file processing was used extensively. Tapes (which are commonly used for sequential files) are normally restricted to backups and storage for very large amounts of data that are too expensive to be stored on disk and for which there is no real need for relatively quick access.
Choice “c” is incorrect. Direct access processing is not a term used to describe a processing method. Direct access refers to the method of accessing data on a storage medium. Direct access means that you can go directly to a location on a storage device without reading through all of the data as would be necessary in sequential access.
Which of the following tasks would be included in a document flowchart for processing cash receipts?
a. Compare control and remittance totals. b. Record returns and allowances. c. Authorize and generate a voucher. d. Authorize and generate an invoice.
Compare control and remittance totals
Choice “a” is correct. A task (a box on a document or system flowchart) to compare control totals and remittance totals would be included in the processing of cash receipts. Note that this is a very general step that could appear on almost any document flowchart. All of the other choices in this question are specific to a particular type of processing.
Choice “b” is incorrect. Recording returns and allowances would not be included in the processing of cash receipts. Anything returned will not be received in cash. Returns and allowances would be included in the processing (and thus the document flowchart) of sales.
Choice “d” is incorrect. Authorizing and generating invoices would not be included in the processing of cash receipts. Invoices would be included in the processing of sales.
Choice “c” is incorrect. Authorizing and generating vouchers would not be included in the processing of cash receipts. Vouchers would be included in the processing of accounts payable and payments.
Compared to online real-time processing, batch processing has which of the following disadvantages?
a. Additional computing resources are required. b. Additional personnel are required. c. Stored data are current only after the update process. d. A greater level of control is necessary.
Stored data are current only after the update process
Choice “c” is correct. Batch processing means that transactions are processed in batches on a periodic basis. Because the transactions are processed on a periodic basis, the data that is being updated can only be considered current just after the update. At any other time, it is possible that a transaction has occured that would affect the data.
Choice “d” is incorrect. There is no greater level of control necessary for batch processing versus online real-time (online) processing.
Choice “a” is incorrect. There is nothing that says that additional computing resources are required for batch processing versus online processing. In fact, online processing normally requires more computing resources, which is one reason why online processing has become popular once computing resources became cheaper and thus more available.
Which of the following are components of a Business Information System (BIS)?
a. Hardware, software, network, people, and data. b. Software, reports, data, and networks. c. Queries, data, reports, and people. d. Hardware, software, and reports.
Hardware, software, network, people, and data
Business Information Systems (BIS) allow a business to perform the following functions on data:
a. Collect, process, store, transform, and distribute. b. Process, report, and store. c. Distribute, collect, report, and transform. d. Initiate, process, distribute, transform, and store.
Collect, process, store, transform, and distribute.
Which of the following is an open, royalty free standard that can be used to facilitate data aggregation, transfer, and connectivity between disparate or stand-alone systems?
a. XBRL. b. HTTP. c. Linux. d. CAT5.
XBRL, the acronym for eXtensible Business Reporting Language, is derived from XML (eXtensible markup language). XBRL is an open, royalty-free, Internet-based information standard for business reporting of all kinds. XBRL labels data so that they are provided with context that remains with them and brings conformity to the names by which they are recognized by disparate software.
Which of the following transaction processing modes provides the most accurate and complete information for decision making?
a. Batch. b. Online, real-time. c. Distributed. d. Application.
Online, Real-Time (OLRT) Processing is an immediate processing method in which each transaction goes through all processing steps (data entry, data validation, and master file update) before the next transaction is processed. OLRT files are always current, and error detection is immediate.
Compared to batch processing, real-time processing has which of the following advantages?
a. Timeliness of information. b. Efficiency of processing. c. Ease of implementation. d. Ease of auditing.
Timeliness of information
Choice “a” is correct. Compared to batch processing, real-time processing has the advantage of timeliness of information because data is processed and records updated immediately when a transaction is entered.
What statement best describes some of the general characteristics of Accounting Information Systems?
a. AIS systems can only handle large volumes of identical transactions. b. AIS systems cannot handle nonrecurring transactions. c. All AIS systems are uniform since all businesses must deal with the same issues. d. AIS systems generally have similar capabilities; however, the applications implemented for a particular business are generally modified to meet the specific needs of that business.
Choice “d” is correct. An AIS is customized to the needs of a particular business or enterprise. The requirements of a manufacturer (including inventory and production) will be different from the requirements of a service firm that might not have any inventory.
Choice “c” is incorrect. AIS systems likely have similar capabilities, but the extent to which they are implemented will vary based on the requirements of the specific business.
Choice “a” is incorrect. An AIS can typically handle any transaction it is set up for. However, many AIS are set up to handle a large volume of transactions.
Choice “b” is incorrect. Nonrecurring transactions can be accommodated by an AIS. Typically, the initial organization of the business, debt issuance, capital outlay, etc., represent types of nonrecurring transactions that should be easily handled by an AIS.
Security Federated Insurance Company numbers its insurance policies with a 10 character code that identifies the type of property or casualty insurance sold, the policy year, the customer type, and a customer number. Numbering of this character is an example of:
a. Sequential code. b. Group code. c. Block code. d. Object code.
Group coding embeds intelligence into the identification numbers associated with a particular item. The identification of different features of an insurance policy with specific numbering scheme is an example of group coding.
Data processing methods are generally described as either batch or online real-time processing (OLRT). These data processing methods are distinguished by the timing of:
a. Data creation. b. Data deletion. c. Data reading. d. Data updating.
Data updating.
Choice “d” is correct. Batch processing updates data periodically (when a batch is processed) while on-line real time processing updates data immediately when transactions are entered.
Which of the following statements is not correct for segregation of duties in an IT environment?
a. The duties of system analysts and application programmers should never be combined. b. Segregation of duties in an IT environment normally revolves around granting and/or restricting access to production data and/or production programs. c. Segregation of duties in an IT environment is defined as dividing responsibilities for different portions of a transaction among several different people. d. The IT department is a support group in that it normally does not initiate or authorize transactions.
Choice “a” is correct as it is the only incorrect statement. The duties of system analysts and application programmers can be, and often are, combined. The duties of system programmers and application programmers should not be combined.
Choice “d” is incorrect because the statement is true. The IT department is a support group that normally does not initiate or authorize transactions.
Choice “b” is incorrect because the statement is true. Segregation of duties normally revolves around granting and/or restricting access to production programs and/or production data.
Choice “c” is incorrect because the statement is true. Segregation of duties in an IT environment is defined as dividing responsibilities for different portions of a transaction among several different people.
Which of the following areas of responsibility would normally be assigned to a systems programmer in a computer system environment?
a. Data communications hardware and software. b. Systems analysis and applications programming. c. Computer operations. d. Operating systems and compilers.
Operating systems and compilers.
What is the steps in the systems development life cycle? mnemonic A DITTO:
systems Analysis Design (conceptual and physical) Implementation and conversion Training Testing Operations and maintenance
What does COBIT (control objectives for information and related technology do/stand for?
provides managers, auditors and IT users with a set of measures, indicators, processes and best practices to maximize the benefit of IT