Lloyds Groups Interview Questions and Answers

Design a system to load data from on-premise to cloud

• Set up a secure VPN connection between on-premise and cloud

• Use ETL tools like Apache NiFi or Talend to extract, transform, and load data

• Implement data encryption and compression for secure data transfer

• Schedule regular data syncs to ensure data consistency

• Monitor data transfer performance and troubleshoot any issues

Use SQL query with MAX function to find highest salary in a table.

• Use SELECT MAX(salary) FROM employees;

• Make sure to replace 'employees' with the actual table name.

• Consider using GROUP BY clause if there are multiple departments or categories.