Explain functional testing methodology and its role in software quality assurance, including test scenarios, data preparation, and automation.