The data in a data warehouse are updated when transactions are processed.
FALSECorrect
The Generally Accepted Auditing Standards (GAAS) issued by PCAOB provide guidelines for conducting an IS/IT audit.
FALSECorrect
The goal of information security management is to maintain confidentiality, integrity and availability of a firm's information.
TRUECorrect
The main objective of the ISO 27000 series is to provide a model for establishing, implementing, operating, monitoring, maintaining, and improving information security.
TRUECorrect
The Object Management Group maintains the standard for Unified Modeling Language (UML) Class diagrams.
TRUECorrect
The property of the primary key in a table in Microsoft Access should be set to:
"Yes (No Duplicates)"Correct
The Purchase Orders table would contain two foreign keys to implement the associations with Employees.
TRUECorrect
The Purchase Orders table would have five foreign keys.
FALSECorrect
The Purchase Orders table would have the same foreign keys as the Purchases table.
FALSECorrect
The Purchases table would have four foreign keys.
TRUECorrect
The purpose of a company's firewall is to:
All of the choicesCorrect
The risk of a company's internal auditing processes failing to catch the misstated dollar amount of revenue on the company's income statement is classified as inherent risk.
FALSECorrect
The Sarbanes-Oxley Act of 2002 (SOX) 2002 requires the management of all companies and their auditors to assess and report on the design and effectiveness of internal control over financial reporting annually.
FALSECorrect
The SQL command "Group by" can be used to order an amount in a descending order.
FALSECorrect
Three types of data models used today are: the hierarchical model, the network model and the relational model.
TRUECorrect
To be valuable business partners, accountants must understand how the business delivers value to its employees.
FALSECorrect
Type images can be used to allow process information to be summarized by category.
TRUECorrect
Unified Modeling Language (UML) Class diagrams describe the logical structure of a database system.
TRUECorrect
Virtual private network (VPN) is a private network, provided by a third party, for exchanging information through a high capacity connection.
FALSECorrect
What is the man-in-the-middle threat for wireless LANs?
The attacker actively intercepts communications between wireless clients and access points to obtain authentication credentials and data.Correct
What is the primary objective of data security controls?
To ensure that data storage media are subject to authorization prior to access, change, or destruction.Correct
What kind data model is most commonly used as a basis for today's enterprise systems?
The relational modelCorrect
When client's accounts payable computer system was relocated, the administrator provided support through a dial-up connection to server. Subsequently, the administrator left the company. No changes were made to the accounts payable system at that time. Which of the following situations represents the greatest security risk?
User accounts are not removed upon termination of employees.Correct
Which designation is for CPAs with a broad range of technology knowledge and experience?
Certified Information Technology Professional (CITP)Correct
Which designation would most appropriate for those professionals possessing an IT audit, control and security skills?
Certified Information Systems Auditors (CISA)Correct
Which of following are possible options for minimum multiplicities?
0 and 1Correct
Which of the following are considered to be mandatory information required by a regulatory body?
Financial reports for the Securities and Exchange CommissionCorrect
Which of the following best describes the difference between access controls and application controls?
Access controls limit who can change records and application controls provide an audit trail of any changes.Correct
Which of the following best describes the purpose of a bill of material class?
Links each raw material item to one or more finished good items.Correct
Which of the following best describes the purpose of an intermediate error event?
Illustrate process flow when an exception occurs.Correct
Which of the following businesses is least likely to employ a conversion process?
Retail StoreCorrect
Which of the following control activities should be taken to reduce the risk of incorrect processing in a newly installed computerized accounting system?
Independently verify the transactions.Correct
Which of the following correctly describes the Referential Integrity Rule?
The data value for a foreign key could be nullCorrect
Which of the following is considered an application input control?
Edit check.Correct
Which of the following is considered as class in the relational database model?
All of the choices are correctCorrect
Which of the following is not a basic activity in the conversion process?
Ship products to storesCorrect
Which of the following is not a Business Management Support role of the Accounting/Finance Function in Business?
Financial consolidation, reporting and analysisCorrect
Which of the following is not a common element of activity models regardless of the specific modeling notation?
MultiplicitiesCorrect
Which of the following is not a component of internal control as defined by COSO?
Inherent riskCorrect
Which of the following is not a criterion for selection of a primary key?
Longer key values are better than shorter key values.Correct
Which of the following is not a form of business rules?
CompulsoryCorrect
Which of the following is not a management control for wireless networks?
Conducting appropriate awareness training on wireless networksCorrect
Which of the following is not a step in using a Unified Modeling Language (UML) Class model to prepare a database?
Map Associations to Primary Keys.Correct
Which of the following is not a Stewardship and Reporting role of the Accounting/Finance Function in Business?
Human Resource managementCorrect
Which of the following is not an Accounting/Finance Operations role of the Accounting/Finance Function in Business?
Stakeholder assuranceCorrect
Which of the following is not something a model of database structures must be able to describe?
The sequence that entities are accessedCorrect
Which of the following is the best reason that a collaboration model would not be used to diagram the conversion process?
All conversion activities are internal to the organization.Correct
Which of the following is the best way to compensate for the lack of adequate segregation of duties in a small organization?
Allowing for greater management oversight of incompatible activities.Correct
Which of the following least reflects the purpose of a business rule in the conversion process?
Ensuring no production without a customer orderCorrect
Which of the following represents an inherent limitation of internal controls?
The CEO can request a check with no purchase order.Correct
Which of the following statement is correct regarding internal control?
An inherent limitation to internal control is the fact that controls can be circumvented by management override.Correct
Which of the following statements about foreign keys is not true?
A foreign key cannot be NULL.Correct
Which of the following statements is incorrect about digital signature?
A digital signature is a message digest encrypted using the document creator's public key.Correct
Which of the following statements presents an example of a general control for a computerized system?
Restricting access to the computer center by use of biometric devices.Correct
Which of the following statements regarding the black-box approach for systems auditing is correct?
The auditors first calculating expected results from the transactions entered into the system. Then, the auditors compare these calculations to the processing or output results.Correct
Which of the following tasks cannot be performed through queries in access?
Enter data into tablesCorrect
Which of the following types of businesses is least likely to employ a conversion process?
Retail storeCorrect
Which of the statements regarding the data warehouse is incorrect?
Includes data for the current fiscal year onlyCorrect
Which SAP modules would a manufacturing company use to create a delivery order for a sales transaction?
Sales and DistributionCorrect
Which type of data models allows each record to have multiple parent and child records?