An auditor is examining a SQL query used to generate a report of all sales transactions for the fiscal year 2024. The query is:<br/>SELECT * FROM Sales WHERE SaleDate > '2024-01-01' AND SaleDate < '2024-12-31'.<br/>What is the potential issue with this query regarding data completeness?

Q: What mistakes do candidates make on this CPA question?

Assuming > includes the date specified.

Answer options:

It includes transactions from 2025.

It excludes transactions occurring exactly on January 1st and December 31st.

It returns duplicate records.

It fails to filter by Customer ID.

How to approach this question

Analyze the operators. > means 'strictly greater than'. If SaleDate is '2024-01-01', is it > '2024-01-01'? No.

Full Answer

B.It excludes transactions occurring exactly on January 1st and December 31st.✓ Correct

The operators > (greater than) and < (less than) are exclusive. To include the first and last days of the year, the query should use >= and <=, or the BETWEEN operator.

Common mistakes

Assuming > includes the date specified.

Question 07 All questions Question 09

Practice the full CPA ISC Practice Exam 4

82 questions · hints · full answers · grading

More questions from this exam

Q01A CPA is advising a client who is migrating their legacy on-premise ERP system to a cloud environ...Hard Q02An auditor is reviewing the Service Level Agreement (SLA) for a client using a public cloud provi...Hard Q03A company uses an Infrastructure as a Service (IaaS) model. During an IT audit, the auditor disco...Hard Q04An organization is implementing the COSO Enterprise Risk Management (ERM) framework to govern its...Hard Q05During a walkthrough of an order-to-cash process, the auditor observes that the sales manager can...Hard

View all 82 questions →