ISTQB Exam CTAL-TM Topic 10 Question 4 Discussion

Actual exam question for ISTQB's CTAL-TM exam

Question #: 4
Topic #: 10

An old stock control system is being decommissioned and replaced with a new system that has been running successfully in the live environment for the last few months. The stakeholders would like to -

* retain historical information held in the database to comply with their data retention policy (which requires order information to be retained for 7 years)

* query the historical information by running pre-written SQL queries.

* all commands must be invoked by keyboard as one of the end users is unable to use a mouse

The pre-written SQL queries will be designed, developed and tested by the developers who are decommissioning the system and writing the data migration routine.

As the system to be decommissioned is integrated to other systems that will remain operational, the stakeholders have requested that testing incorporates all systems that are part of the stock control suite.

The stakeholders and project manager have identified the following risks, in priority order -

* 1st - Data has not been successfully migrated to an archived data store, resulting in the inability to query past stock levels and re-order details.

* 2nd - Historical data for the last 7 years is unavailable, resulting in the failure to meet the data retention policy.

* 3rd - Failure of existing systems within the stock control suite, adversely affecting the operational running of the business

The risks are to form the basis of the test objectives. Which three of the following test activities, work products and/or resources achieves the test objectives?

a. Use of the live database to test the data migration does not corrupt or lose data

b. A test plan detailing the test approach for ST. SIT & OT test levels

c. Accessibility testing of the pre-defined SQL queries

d. Security and Penetration testing of the archived database

e Performance testing of the data migration exercise to ensure it completes in the time specified by the stakeholders

f. Functional testing of the pre-defined SQL queries

g. Regression testing of the end to end process for maintaining specified stock levels.

Aa, c and g.

Bb, d and f.

Ca, e and g.

Da, b and d.

Show Suggested Answer

Suggested Answer: D

by Katina at Mar 08, 2025, 10:18 AM

Limited Time Offer

25%

Off

Get Premium CTAL-TM Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Fatima

1 months ago

Hey, as long as the end user can bash those keys without a mouse, I'm happy. Accessibility testing is key, for sure. But I think C covers all the bases - gotta make sure that data migration is lightning-fast!

upvoted 0 times

Ronny

7 days ago

Yeah, I think option C covers all the important test activities we need to achieve the test objectives.

upvoted 0 times

...

Afton

18 days ago

I agree, but we also need to focus on the performance testing of the data migration to meet stakeholder requirements.

upvoted 0 times

...

Kattie

30 days ago

Accessibility testing is definitely important, we need to make sure everyone can use the system.

upvoted 0 times

...

Hyun

1 months ago

I see your point, Garry. Option A does seem to address the key risks effectively. Let's go with that.

upvoted 0 times

...

Garry

2 months ago

But option A covers testing of data migration, accessibility of SQL queries, and regression testing. It seems more aligned with the risks identified.

upvoted 0 times

...

Theron

2 months ago

Haha, I bet the developers who wrote those SQL queries are hoping for a nice long vacation after this project. Gotta make sure those queries work like a charm, eh? I'd say A is the way to go.

upvoted 0 times

Raylene

7 days ago

Yeah, A seems like the best choice to ensure the data migration and testing goes smoothly.

upvoted 0 times

...

Glory

10 days ago

Definitely, they better hope those queries work smoothly or they might not get that vacation after all.

upvoted 0 times

...

Kayleigh

17 days ago

I agree, those developers must be feeling the pressure to make sure those SQL queries are spot on.

upvoted 0 times

...

Antonette

2 months ago

I'm not sure about option A. I think option B) b, d and f might be more comprehensive.

upvoted 0 times

...

Hyun

2 months ago

I agree with you, Garry. Those activities seem to cover the test objectives well.

upvoted 0 times

...

Maryln

2 months ago

I'm going with B. Security and penetration testing of the archived database is a must, and functional testing of the SQL queries is important too. Can't afford any data breaches or broken queries!

upvoted 0 times

Shaun

1 months ago

Functional testing is also important to ensure the queries work correctly.

upvoted 0 times

...

Colton

1 months ago

I agree, security testing is crucial to prevent any breaches.

upvoted 0 times

...

Felicia

1 months ago

B) b, d and f.

upvoted 0 times

...

Garry

2 months ago

I think we should choose option A) a, c and g for the test activities.

upvoted 0 times

...

Doretha

2 months ago

Nah, I'd go with C. Performance testing of the data migration is crucial to ensure it completes on time, and that's not mentioned in A. Plus, regression testing is a given.

upvoted 0 times

...

Emerson

2 months ago

Hmm, I think the answer is A. We need to ensure the data migration doesn't corrupt the data, test the accessibility of the SQL queries, and do regression testing of the end-to-end process. Seems like the most comprehensive approach to meet the test objectives.

upvoted 0 times

Avery

2 months ago

I think testing the accessibility of the SQL queries is crucial as well.

upvoted 0 times

...

Dean

2 months ago

I agree, we definitely need to make sure the data migration is done correctly.

upvoted 0 times

...