1 5 points An array (range) of cells across a column in Microsoft Excel would be considered which of the following terms under the data hierarchy? Data field Database File Record 2 5 points A specific database field in Table 1 both serves as a unique identifier in Table 2 and is used to link both of the tables as a relational database. What is the correct term for this database field in Table 2? Primary key Foreign key Both A and B Neither A nor B 3 5 points 5 Which of the following statements about the referential integrity rule is not true? It states that the foreign key in one table must match one of the primary keys in the related table It applies only to relational databases It increases the veracity of data All of the above statements about the referential integrity rule are true 5 points Data validation in Microsoft Excel functions as which type of database control? Authenticity Data integrity Lockout Transaction 5 points Kobe Bryant is currently involved in Step 3 of REA modeling, and as such he is trying to determine the proper relationship for sales orders to sales invoice numbers. Which relationship should he select? One-to-one (1:1) One-to-many (1:N) Many-to-many (N:N) There is not enough information to determine the appropriate category for this relationship Which of the following statements regarding XBRL is not true? OOOO XBRL adoption requires accountants to annually tag data for their clients XBRL is a variant of XML used for reporting financial information XBRL creates unique searchable tags for each data item XBRL is required by the SEC for only publicly traded companies 7 5 points Nuno Canavarro wants to protect sensitive information that he plans on emailing to his client. Which of the following data techniques should he use to best accomplish this? Data encryption Two-factor authentication Firewall Intrusion detection system (IDS) 8 5 points Kevin Shields is an accountant with a large accounting firm. In early March, Kevin received an email from the firm that explained that there had been an error updating his password and that provided a link to a website with instructions for re-entering his password. Something about the email made Kevin suspicious, so he called the firm's IT department and found that the email was fake. The email was an example of: Identity theft Spam Phishing Spoofing 9 5 points For Questions 9-10, refer to the following script: Lou Reed is the primary accountant and 1 of 87 employees at The Velvet Underground (TVU), a company that manufactures professional grade recording equipment and mixing boards. TVU's sales revenue grew from $250,000 in 2018 to $1 million in 2019, prompting Lou to upgrade his QuickBooks software. By the end of their third year, 2019, TVU had already turned a $150,000 profit. At that time, Lou performed analytics to estimate how promising sales of a new device TVU planned to sell could be. Each time Lou used analytics, he had to access a number of different databases to find all the data he needed. Which of the following options best describes TVU's accounting information system (AIS)? The AIS is a system independent from the other departmental information systems The AIS is part of an enterprise resource planning (ERP) system The AIS is a system concerned primarily with front-office operations All of the above 10 5 points For Questions 9-10, refer to the following script: Lou Reed is the primary accountant and 1 of 87 employees at The Velvet Underground (TVU), a company that manufactures professional grade recording equipment and mixing boards. TVU's sales revenue grew from $250,000 in 2018 to $1 million in 2019, prompting Lou to upgrade his QuickBooks software. By the end of their third year, 2019, TVU had already turned a $150,000 profit. At that time, Lou performed analytics to estimate how promising sales of a new device TVU planned to sell could be. Each time Lou used analytics, he had to access a number of different databases to find all the data he needed. Which type of data analytics did Lou use? Prescriptive Predictive