Questions

Here is a list of questions to test your knowledge:

• What is the difference between a lookup join, an inner join, and a full join?
• Give one real-world example of how to use a full join.
• Why would you need to connect data from external sources with Salesforce objects? Give one practical example.
• Explain how to combine aggregation and grouping using two data streams in one recipe.
• The Multiple Row Formula option must be selected to perform window functions. What are window functions, and when might you use them?
• What is a flatten transformation, and what is a use case for this?