What combination of SQL techniques should a company use to frequently update customer data in a secure manner?

What combination of SQL techniques should a company use to frequently update customer data in a secure manner?

• A. Triggers and Views
• B. Stored Procedures and Views
• C. Functions and Triggers
• D. Triggers and Functions

Answer: (C)

In the context of securely and effectively updating customer data, utilizing stored procedures combined with views is often a preferred approach. Stored procedures allow for encapsulating the logic required for updates and can include security measures, such as parameter validation and access control, to ensure that only authorized modifications are made. They enhance security by limiting direct access to tables, providing a layer of abstraction where business logic can be applied.

Views, on the other hand, serve as a virtual table that presents data from one or more tables while concealing the underlying table structure. This can limit access to sensitive data, allowing users to see only what they need, thus enhancing security.

The combination of stored procedures and views creates a powerful toolset: stored procedures for performing the updates in a controlled and secure manner, and views for providing a user-friendly and secure interface to the data. This combination not only streamlines the update process but also minimizes the risk of SQL injection and ensures that the data integrity is maintained during frequent updates.

In contrast, while triggers and functions have their uses, they do not provide the same level of control and security as stored procedures when it comes to complex data manipulation and frequent updates. Triggers automatically execute changes based on certain actions, but they may not effectively enforce security