Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Distinguish between filtering and interpreting. (Objective 2)

Answered: 1 week ago