About WordPress
Log In

Search

Toggle Side Panel

Sign in

Search for:

Search for:

WC100 – If you don't do this before your data analytics project, you risk getting it all wrong!

0% Complete

0/0 Steps

Webclass 100: Replay and PDF
Webclass 100: Take the quiz and get your CPE certificate

1 Quiz
- Webclass 100: If you don’t do this before your data analytics project, you risk getting it all wrong!

Quizzes

Webclass 100: Secret number

Participants 13

Bee
Be
admin
Claire
Hanh Huynh

Show more

Quiz 1 of 2

← Previous Next→

Webclass 100: If you don’t do this before your data analytics project, you risk getting it all wrong!

admin June 9, 2026

WC100 – If you don’t do this before your data analytics project, you risk getting it all wrong!
Webclass 100: Take the quiz and get your CPE certificate
Webclass 100: If you don’t do this before your data analytics project, you risk getting it all wrong!

Time limit: 0

Quiz Summary

0 of 10 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Review
Answered
Correct
Incorrect

Question 1 of 10

1. Question

Q1. What are four possible reasons for the general ledger data that you extracted not matching the trial balance?

1/ Journal entries were removed from the file that you received; 2/ The date field that was used to filter the data was not the posting date but the input date or the document date; 3/ A filter was applied on a business area, posting key, the wrong company code, etc. 4/ The data was accidentally truncated because it was exported to Excel (which is limited to around 1M lines, because of a special character or one of the files not being transferred via FPT)
Correct Incorrect Correct answer

1/ The data was extracted without using a SAP extractor tool; 2/ The data was filtered on the posting date rather than the document date; 3/ The data contains the periods 13 to 16; 4/ The IT department forgot to filter on the business area
Correct Incorrect Correct answer

Correct

Incorrect
Question 2 of 10

2. Question

Q2. If you are using a SAP extractor, then the data extracted can never be incomplete?

False: the data can still be incomplete if one of the files is not copied over to the data analytics server or if there are special characters in the data that prevent data import, for the rest of the file
Correct Incorrect Correct answer

True: using a data extractor provides 100% confidence that the data obtained from SAP will be complete and accurate
Correct Incorrect Correct answer

Correct

Incorrect
Question 3 of 10

3. Question

Q3. If you are using a SAP extractor, then the data extracted can never be incomplete?

False: the data can still be incomplete if one of the files is not copied over to the data analytics server or if there are special characters in the data that prevent data import, for the rest of the file
Correct Incorrect Correct answer

True: using a data extractor provides 100% confidence that the data obtained from SAP will be complete and accurate
Correct Incorrect Correct answer

Correct

Incorrect
Question 4 of 10

4. Question

Q4. Is the auditor more objective if they obtain the data directly from the system or if they obtain the data from the business?

From the system
Correct Incorrect Correct answer

From the business
Correct Incorrect Correct answer

Correct

Incorrect
Question 5 of 10

5. Question

Q5. When doing data reconciliations we will analyze the balances per account on the balance sheet.

False: data reconciliation is about checking that the transactional data obtained is complete and accurate and is done before going on to balance sheet analysis or other types of analysis
Correct Incorrect Correct answer

True: when doing data reconciliation we will calculate the opening and closing balance per general ledger account
Correct Incorrect Correct answer

Correct

Incorrect
Question 6 of 10

6. Question

Q6. When doing a reconciliation between the general ledger and the trial balance, we should look at the total debit and credit or we should look at the net

Net
Correct Incorrect Correct answer

Total debit and credit
Correct Incorrect Correct answer

Correct

Incorrect
Question 7 of 10

7. Question

Q7. When doing a reconciliation between the general ledger and the trial balance, we should include the periods 13 to 16

Yes
Correct Incorrect Correct answer

No
Correct Incorrect Correct answer

Correct

Incorrect
Question 8 of 10

8. Question

Q8. Which table in SAP will help us to know the calendar date of the beginning of the fiscal period?

T009B
Correct Incorrect Correct answer

T001
Correct Incorrect Correct answer

Correct

Incorrect
Question 9 of 10

9. Question

Q9. Is there a possibility within SAP that the BSAK/BSIK lines can be different to the K lines in the BSEG table?

No, because the BSEG table is like a view of the BSAK/BSIK table and other tables
Correct Incorrect Correct answer

Yes, due to an update following closing
Correct Incorrect Correct answer

Correct

Incorrect
Question 10 of 10

10. Question

Q10. How might process mining help you during the reconciliation process?

You can check whether or not the operational data (purchase orders and sales orders, etc) is of the same order of magnitude as the financial data
Correct Incorrect Correct answer

You can check whether or not the financial data matches the balance sheet and P&L
Correct Incorrect Correct answer

Correct

Incorrect