Microsoft
MB-280 · Question #46
MB-280 Question #46: Real Exam Question with Answer & Explanation
The correct answer is B. No. While the solution includes transforming the first row to be used as headers and naming the query, the step of removing rows that contain null values is problematic. Removing all rows with null values can lead to significant data loss, particularly if those rows contain relevant
Question
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: Transform the first row to be used as headers, remove rows that contain null values, and name the query. Select Next and your data is now ready for unification. Does this meet the goal?
Options
- AYes
- BNo
Explanation
While the solution includes transforming the first row to be used as headers and naming the query, the step of removing rows that contain null values is problematic. Removing all rows with null values can lead to significant data loss, particularly if those rows contain relevant information.
Community Discussion
No community discussion yet for this question.