MB-280 Question #112: Real Exam Question with Answer & Explanation

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. A company's IT department has a .CSV file stored on one of their Shared Documents folders within their Microsoft SharePoint sites. The data from the .CSV file is ingested into Dynamics 365 Customer Insights - Data. The file contains a row header and columns of different types, such as quantities and prices. The file also contains some rows with a high proportion of nulls. You need to clean and transform the data in Customer Insights - Data to be ready for unification. Solution: Define column types to be appropriate field types and name the query. Create a full name and full address columns by merging the appropriate columns, if they exist. Select Next and your data is now ready for unification. Does this meet the goal?