ACD301 practice question 4 of 10

You are planning a strategy around data volume testing for an Appian application that queries and writes to a MySQL database. You have administrator access to the Appian application and to the database. What are two key considerations when designing a data volume testing strategy?

Full set: 45 questions
Answer options
A: Data from previous tests needs to remain in the testing environment prior to loading prepopulated data.
B: Large datasets must be loaded via Appian processes.
C: The amount of data that needs to be populated should be determined by the project sponsor and the stakeholders based on their estimation. Correct answer
D: Testing with the correct amount of data should be in the definition of done as part of each sprint. Correct answer
E: Data model changes must wait until towards the end of the project.
Correct Answer:
C. The amount of data that needs to be populated should be determined by the project sponsor and the stakeholders based on their estimation.; D. Testing with the correct amount of data should be in the definition of done as part of each sprint.
Explanation

A successful data volume testing strategy requires establishing realistic data targets and integrating testing into the development lifecycle. The volume of data for testing should be based on current and projected production usage, which must be defined by business stakeholders and project sponsors to ensure the tests are meaningful. Furthermore, incorporating performance testing with this data volume into the "Definition of Done" for each sprint ensures that performance issues are identified and addressed early and iteratively, preventing major problems late in the project.

Why Incorrect

A. Retaining data from previous tests creates an inconsistent baseline, making test results unreliable and non-repeatable. Test environments should be reset to a known state before each run.
B. Using Appian processes to load large datasets for test setup is highly inefficient. Direct database utilities are significantly faster and are the appropriate tools for pre-populating the environment.
E. Deferring data model changes until the end of the project is a major anti-pattern. It introduces significant risk and can lead to extensive, costly rework across the entire application.

References

1. Appian Corporation

"Performance Testing" Documentation.

Reference for C: In the "Prepare for the Test" section

under "Prepare the Test Environment

" the guide states: "Populate the environment with a representative dataset. Determine the expected volume of data in production after a period of time (for example

1-3 years)." This directly supports that data volume should be based on stakeholder-driven estimations of production usage.

Reference for D: The "Overview" section emphasizes an iterative approach: "Performance testing should be an iterative process that is conducted throughout the project lifecycle

not a one-time event at the end of a project." This aligns with making testing part of the sprint's "Definition of Done."

2. Pressman

R. S.

& Maxim

B. R. (2020). Software Engineering: A Practitioner's Approach (9th ed.). McGraw-Hill.

Reference for D: Chapter 5

"Agile Development

" discusses the "Definition of Done" (DoD). A comprehensive DoD typically includes quality assurance criteria such as the completion of performance and load testing for the features developed within the sprint

confirming that continuous testing is a core agile principle.

3. University of Washington

CSE 403: Software Engineering

"Testing I" Lecture Notes.

Reference for A & B: Course materials on software testing frequently emphasize the principles of test environment management

which include ensuring a clean

known state before test execution (contradicting A) and using the most efficient methods to establish that state (contradicting B). The goal is to test the application's performance

not the data loading mechanism itself

unless that is the specific test case.

Scroll to Top