NYC Associate Staff Analyst (DCAS) —
Certification Practice Exam Questions
With Correct Answers (Verified
Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf A+ Grade
Guarantee Verified By Professionals
1. A city agency is reviewing quarterly spending reports and notices recurring variances
between projected and actual expenditures. What is the most appropriate first step for
an analyst?
A. Immediately reduce next quarter’s budget
B. Verify data accuracy and source documents
C. Report staff for budget mismanagement
D. Discontinue the reporting process
Answer: Verify data accuracy and source documents ✓
Rationale: Analysts must first validate data integrity before drawing conclusions or
recommending actions.
2. Which tool is most appropriate for summarizing large datasets and identifying trends?
A. Word processor
B. Spreadsheet software
C. Email client
D. Presentation software
Answer: Spreadsheet software ✓
Rationale: Spreadsheets allow sorting, filtering, and statistical analysis of data.
3. A dataset contains duplicate entries affecting report accuracy. What should an analyst do
first?
A. Delete all records
B. Identify and verify duplicates before removal
, C. Ignore duplicates if they are small in number
D. Report the issue without action
Answer: Identify and verify duplicates before removal ✓
Rationale: Data cleaning requires validation to avoid removing legitimate records.
4. What is the primary purpose of a variance analysis?
A. To forecast employee performance
B. To compare planned vs actual results
C. To create marketing strategies
D. To assign job duties
Answer: To compare planned vs actual results ✓
Rationale: Variance analysis identifies differences between expected and actual
performance.
5. In budgeting, “encumbrance” refers to:
A. Money already spent
B. Funds reserved for future obligations
C. Tax revenue collected
D. Emergency reserves
Answer: Funds reserved for future obligations ✓
Rationale: Encumbrances are commitments that reduce available budget balance.
6. A report contains inconsistent formatting across departments. What is the best
corrective action?
A. Ignore inconsistencies
B. Standardize reporting templates
C. Delete inconsistent reports
D. Replace staff
Answer: Standardize reporting templates ✓
Rationale: Standardization ensures comparability and consistency.
7. Which metric best measures central tendency in a skewed dataset?
A. Mean
B. Median
C. Range
D. Variance
Answer: Median ✓
Rationale: Median is less affected by extreme values.
, 8. A supervisor requests a summary of operational inefficiencies. What should the analyst
prioritize?
A. Personal opinions
B. Verified performance data
C. Anecdotal evidence
D. Social media feedback
Answer: Verified performance data ✓
Rationale: Decisions must be based on objective, validated data.
9. What is the main advantage of pivot tables?
A. Graphic design
B. Data aggregation and summarization
C. Email automation
D. Virus detection
Answer: Data aggregation and summarization ✓
Rationale: Pivot tables efficiently summarize large datasets.
10. A dataset shows missing values. What is the most appropriate first action?
A. Delete entire dataset
B. Investigate cause of missing data
C. Replace all with zero
D. Ignore missing values
Answer: Investigate cause of missing data ✓
Rationale: Understanding the cause ensures proper handling of missing values.
11. Which of the following is an example of qualitative data?
A. Annual revenue
B. Number of employees
C. Customer satisfaction feedback
D. Monthly expenses
Answer: Customer satisfaction feedback ✓
Rationale: Qualitative data describes non-numeric attributes.
12. The purpose of internal controls in financial management is to:
A. Increase spending
B. Ensure accuracy and prevent fraud
C. Reduce staffing
D. Speed up hiring
Certification Practice Exam Questions
With Correct Answers (Verified
Answers) Plus Rationales 2026 Q&A |
Instant Download Pdf A+ Grade
Guarantee Verified By Professionals
1. A city agency is reviewing quarterly spending reports and notices recurring variances
between projected and actual expenditures. What is the most appropriate first step for
an analyst?
A. Immediately reduce next quarter’s budget
B. Verify data accuracy and source documents
C. Report staff for budget mismanagement
D. Discontinue the reporting process
Answer: Verify data accuracy and source documents ✓
Rationale: Analysts must first validate data integrity before drawing conclusions or
recommending actions.
2. Which tool is most appropriate for summarizing large datasets and identifying trends?
A. Word processor
B. Spreadsheet software
C. Email client
D. Presentation software
Answer: Spreadsheet software ✓
Rationale: Spreadsheets allow sorting, filtering, and statistical analysis of data.
3. A dataset contains duplicate entries affecting report accuracy. What should an analyst do
first?
A. Delete all records
B. Identify and verify duplicates before removal
, C. Ignore duplicates if they are small in number
D. Report the issue without action
Answer: Identify and verify duplicates before removal ✓
Rationale: Data cleaning requires validation to avoid removing legitimate records.
4. What is the primary purpose of a variance analysis?
A. To forecast employee performance
B. To compare planned vs actual results
C. To create marketing strategies
D. To assign job duties
Answer: To compare planned vs actual results ✓
Rationale: Variance analysis identifies differences between expected and actual
performance.
5. In budgeting, “encumbrance” refers to:
A. Money already spent
B. Funds reserved for future obligations
C. Tax revenue collected
D. Emergency reserves
Answer: Funds reserved for future obligations ✓
Rationale: Encumbrances are commitments that reduce available budget balance.
6. A report contains inconsistent formatting across departments. What is the best
corrective action?
A. Ignore inconsistencies
B. Standardize reporting templates
C. Delete inconsistent reports
D. Replace staff
Answer: Standardize reporting templates ✓
Rationale: Standardization ensures comparability and consistency.
7. Which metric best measures central tendency in a skewed dataset?
A. Mean
B. Median
C. Range
D. Variance
Answer: Median ✓
Rationale: Median is less affected by extreme values.
, 8. A supervisor requests a summary of operational inefficiencies. What should the analyst
prioritize?
A. Personal opinions
B. Verified performance data
C. Anecdotal evidence
D. Social media feedback
Answer: Verified performance data ✓
Rationale: Decisions must be based on objective, validated data.
9. What is the main advantage of pivot tables?
A. Graphic design
B. Data aggregation and summarization
C. Email automation
D. Virus detection
Answer: Data aggregation and summarization ✓
Rationale: Pivot tables efficiently summarize large datasets.
10. A dataset shows missing values. What is the most appropriate first action?
A. Delete entire dataset
B. Investigate cause of missing data
C. Replace all with zero
D. Ignore missing values
Answer: Investigate cause of missing data ✓
Rationale: Understanding the cause ensures proper handling of missing values.
11. Which of the following is an example of qualitative data?
A. Annual revenue
B. Number of employees
C. Customer satisfaction feedback
D. Monthly expenses
Answer: Customer satisfaction feedback ✓
Rationale: Qualitative data describes non-numeric attributes.
12. The purpose of internal controls in financial management is to:
A. Increase spending
B. Ensure accuracy and prevent fraud
C. Reduce staffing
D. Speed up hiring
