M1C5

Which of the following business purposes can be met by implementing Data warehouse in an organisation?

• Business continuity can be ensured in case of disaster.
• Data in the data ware house can work as a backup
• The data in the warehouse can be used for meeting regulatory requirements.
• Business decisions can be taken and future policies can be framed based on actual transactional data.

Answer explanation

Purpose of Data warehouse is to take business decisions and frame future policies based on the analysis of transactional data. It cannot act as an alternative to backup. Purpose of the data ware house is not for business continuity nor is it for regulatory requirements.

Which of the following is a characteristic of a decision support system (DSS)?

• DSS is aimed at solving highly structured problem.
• DSS combines the use of models with non-traditional data access and retrieval functions.
• DSS emphasizes flexibility in decision making approach of users.
• DSS supports only structured decision-making tasks.

Answer explanation

It goes with the purpose and definition of decision support system.

Which of the following audit tools is MOST useful to an IS auditor when an audit trail is required?

• Integrated test facility (ITF)
• Continuous and intermittent simulation (CIS)
• Audit hooks
• Snapshots

Answer explanation

Snapshot is the right answer as in this technique, IS auditor can create evidence through IMAGE capturing. A snapshot tool is most useful when an audit trail is required. ITF can be used to incorporate test transactions into a normal production run of a system. CIS is useful when transactions meeting certain criteria need to be examined. Audit hooks are useful when only select transactions or processes need to be examined.

A retail company recently installed data warehousing client software in multiple, geographically diverse sites. Due to time zone differences between the sites, updates to the warehouse are not synchronized. This will affect which of the following most?

• Data availability
• Data completeness
• Data redundancy
• Data accuracy

Answer explanation

One of the major bottlenecks in data ware house is time synchronisation as the data of different time zones is merged in data ware house. It ultimately results in in-complete data for decision making purposes.

The cashier of a company has rights to create bank master in TALLY. This error is a reflection of poor definition for which type of control:

• User Controls
• Application Control
• Input Control
• Output Control

Answer explanation

User controls are not properly defined. User controls need to be defined based on NEED TO KNOW and NEED TO DO basis. The above is reflection of a greater problem of improper assessment of user profiles created in the system

An employees has left the company. The first thing to do is to:

• Hire a replacement employee.
• Disable his/her access rights.
• Ask the employee to clear all dues/advances.
• Escort employee out of company premises

Answer explanation

The first thing to do as soon as an employee leaves the company is to disable his/her access rights in system. This needs to be done to prevent frauds being committed. Other answers may be valid but are not the first thing to do.

As part of auditing Information Security of a multinational bank, an auditor wants to assess the security of information in ATM facilities. Under which privacy policy should he look for details pertaining to security guards and CCTV surveillance of ATM’s?

• Physical Access and Security Policy
• Acceptable use of Information Assets Policy
• Asset Management Policy
• Business Continuity Management Policy Key.

Answer explanation

Physical security describes security measures that are designed to restrict unauthorized access to facilities, equipment and resources, and to protect personnel and property from damage or harm (such as espionage, theft, or terrorist attacks). Physical security involves the use of multiple layers of interdependent systems which include CCTV surveillance, security guards, Biometric access, RFID cards, access cards protective barriers, locks, access control protocols, and many other techniques. B is incorrect - An acceptable use policy (AUP), also known as an Acceptable Usage policy or Fair Use policy, is a set of rules applied by the owner or manager of a network, website or large computer system that restrict the ways in which the network, website or system may be used. C is incorrect – This policy defines the requirements for Information Asset’s protection. It includes assets like servers, desktops, handhelds, software, network devices etc. Besides, it covers all assets used by an organization- owned or leased. D is incorrect – This policy defines the requirements to ensure continuity of business critical operations. It is designed to minimize the impact of an unforeseen event (or disaster) and to facilitate return of business to normal levels.

Neural Networks and Fuzzy Logics are classified under which category of Artificial intelligence?

• Cognitive Science
• Robotics
• Natural Sciences
• Virtual Reality

Answer explanation

Cognitive Science. This is an area based on research in disciplines such as biology, neurology, psychology, mathematics and allied disciplines. It focuses on how human brain works and how humans think and learn. Applications of AI in the cognitive science are Expert Systems, Learning Systems, Neural Networks, Intelligent Agents and Fuzzy Logic. B, C and D are incorrect. B. Robotics: This technology produces robot machines with computer intelligence and human-like physical capabilities. This area includes applications that give robots visual perception, capabilities to feel by touch, dexterity and locomotion. C. Natural Languages: Being able to 'converse' with computers in human languages is the goal of research in this area. Interactive voice response and natural programming languages, closer to human conversation, are some of the applications. D. Virtual reality is another important application that can be classified under natural interfaces.

In an inter school competition on Artificial Intelligence, four children develop software which performs the following different functions respectively. Which of them is a correct example of the use of basic Artificial Intelligence?

• Predictive & self-learning word-processing software
• A calculation software which arrives at the arithmetic total of figures keyed in
• A password system which allows access based upon keying in of the correct password
• A software which rejects invalid dates like 32nd March 2019.

Answer explanation

The word-processing software pops up suggested words based upon the first few words keyed in by the user. Also, when the user keys in a new word which is not available in its repertoire, it adds it to its collection & reflects it as an option the next time similar letters are initiated. In effect, the software is able to observe & record patterns and improves through ‘learning’. The other answers in Options B to D involve the basic computing functions of a computer which are based on a ‘go / no-go’ logic which does not involve pattern recognition or further learning. Hence, the correct answer is only as in Option A which displays characteristics of artificial intelligence.

Which are the business activities which are strong contenders for conversion to e-commerce?

• Those that are paper-based, time consuming & inconvenient for customers
• Those relating to software development
• Those relating to the ‘electronic’ aspects of commerce
• Those that are not paper-based, speedy & convenient for customers.

Answer explanation

Maximum mileage can be gained from e-commerce by converting those business activities which are paper-based, time consuming & inconvenient for customers as indicated in Option A. This will help us reduce paperwork, accelerate delivery & make it convenient for customers to operate from the comfort of their homes as also at any other place of their convenience. Hence, the other options are wrong.