Salesforce App Builder Practice Exam

In which scenario is ETL a better choice than Lightning Connect?

1. Need to create or update external data.

2. External data must follow sharing rules.

3. Generate reports from external data.

4. All of the above.

The correct answer is: All of the above.

ETL (Extract, Transform, Load) is an ideal solution in scenarios where there is a need to handle data integration involving complex transformations or where significant data manipulation is required. It excels in cases where data needs to be created or updated from external sources, allowing businesses to incorporate this data into their Salesforce environment efficiently. This means that if there is a requirement for data to be brought into Salesforce and transformed to align with its structure, ETL proves to be a valuable tool. In addition, ETL is suitable where external data needs to conform to sharing rules set within Salesforce. When data integration involves sharing considerations, ETL processes can adequately handle these requirements by ensuring that only the relevant data adheres to the established sharing settings when it is loaded into the Salesforce system. Moreover, for generating reports from external data, ETL is advantageous as it allows for comprehensive data aggregation and transformation before being loaded into Salesforce. This capability enables users to create meaningful insights and reports by processing the data into a usable format that fits their analytical needs. In contrast, Lightning Connect is designed for real-time access to external data without needing to import it into Salesforce, which may not be suitable for all scenarios. Therefore, ETL is a comprehensive approach in situations involving the creation,