Chapter 4, Cleansing, Transforming, and Shaping Data

1. If you need to transform a column by adding a prefix to every record, which transform would you use?
   1. Format
   2. Pivot
   3. Replace Values
   4. Parse
2. What is used to combine data from multiple queries or tables?
   1. Merge query
   2. Join query
   3. Append query
   4. Left Outer query
3. What are some of the ways Power BI can be used to enrich data using AI?
   1. Linear regression, language detection, key phrase extraction, and sentiment analysis
   2. Language detection, key phrase extraction, and sentiment analysis
   3. Language detection and key phrase extraction
   4. Image tagging, key phrase extraction, language detection, and sentiment analysis