Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Required: Match the terms with their respective definitions in the left column below. Term Definition A standard format for data files and fields typically needed
Required: Match the terms with their respective definitions in the left column below. Term Definition A standard format for data files and fields typically needed to support an external audit Datasets that are too large and complex for businesses' existing systems to handle using their traditional capabilities to capture, store, manage, and analyze these datasets The science of examining raw data, removing excess noise from the dataset, and organizing data with the purpose of drawing conclusions for decision making a. Audit Data Standards b. Data Analvtics d. The unauthorized access to or acquisition of data in electronic form containing personal information Breach of Security e. The process of cleaning and scrubbing the data before data analysis can take pace f. Social Security number or driver's license number Extract, Transform and Load ersonal Identifying Information Required: Data analytics can be disaggregated into two parts: ETL (extract, transform, and load) or analysis. Classify each of the following processes as either ETL or analysis. Process ETL/Analysis Removal of extraneous data and noise b. Looking for trends in the data that might predict new sales opportunities c. Finding the necessary data from the financial reporting system to give to the external auditor for analysis Analysis d. Performance of a test of internal controls by the external auditor e. Considering Champaign, Ilinois, weather patterns to predict corn production in the immediate area f. Consolidating large volumes of data from multiple sources and platforms TL Analysis ETL Analysis TL Required: ldentify which of the following, on their own, are personal identifying information (PI) and which are not personal identifying information (non-PII) Information PI/Non-PlI on-PIl on-PII a. Financial information b. Address of employment c. Personal telephone number P d. Fingerprints e. Social Security number f. Geographic indicators g. Vehicle ID number Non-Pl
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started