Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
As part of your BAU support management you have admin access to production data. You have been asked by your manager to write a program that deletes employees who have resigned in the last 1 month. How would you proceed?
Use a SQL client, run a query to list the resigned employees and share it with your manager. Once your manager reviews, write the delete query.
Write a stored procedure and schedule it for 12 noon before going for lunch break
Implement the change and inform your manager
Log a change and follow change management process
Any change to production should be cautiously done. Even though you have admin access, all changes need to be analyzed for its impact and approvals sought.
Train with Skillset and pass your certification exam. Faster. Guaranteed.
Study thousands of practice questions that organized by skills and ranked by difficulty.
Create a tailored training plan based on the knowledge you already possess.
Know when you’re ready for the high-stakes exam. Have the confidence that you will pass on your first attempt.