Scenario: In an ETL process, you find that certain records in the target database are missing compared to the source. What kind of data validation problem does this indicate?
- Data Accuracy Issue
- Data Completeness Issue
- Data Consistency Issue
- Data Integrity Issue
This indicates a data completeness issue. Data completeness refers to ensuring that all expected data is present and available. In this case, the absence of certain records in the target database suggests that the ETL process did not properly transfer all the data from the source to the target.
Loading...
Related Quiz
- You want to delete all records from a table named "Employees" where the salary is below a certain threshold. Which SQL statement should you use for this task?
- In the context of compliance and regulatory testing, what is the purpose of penetration testing?
- In stress testing, the objective is to identify the system's ____________ point.
- What is the primary purpose of test data generation tools in database testing?
- Which database system feature can help improve query performance by storing precomputed results?