2025 WITH 100% CORRECT ANSWERS
Brian works for a CPA firm and is in the process of preparing data for the analysis of client
financial statement information for an audit. Brian would likely take each of the following steps
to clean the data except:
- Format negative numbers to ensure consistency across numerical values
- Create a calculated field to further prepare the financial statement data for additional analysis
- Address inconsistent data types, such as date/time, doubles, string, and integer
- Remove unnecessary headings or subtotals that would otherwise obstruct synthesis or analysis
- CORRECT ANSWER✔✔create a calculated field to further prepare the financial statement data
for additional analysis (this is an example of the synthesis stage in the data life cycle)
Each of the following would be considered a complexity when obtaining data from an external
source except:
- safety
- format
- copyrights
- integrity - CORRECT ANSWER✔✔format because data can come in different formats, but
through the preparation and synthesis stages of the data life cycle, the data may be cleaned up
how many steps are there in the data life cycle - CORRECT ANSWER✔✔8