<< Prev Question Next Question >>

Question 20/54

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (54q)
Question 1: One of the data sources being ingested into Microsoft Dynami...
Question 2: The loyalty operations lead at your organization wants a fil...
Question 3: You need to populate a marketing list in Dynamics 365 Sales ...
Question 4: You have the contributor security role. Your company has Mic...
Question 5: You need to fix the problem with exports to Dynamics 365 Sal...
Question 6: You are implementing Dynamics 365 Customer Insights - Data a...
Question 7: Note: This question is part of a series of questions that pr...
Question 8: You are a Customer Data Platform Specialist. Your company's ...
Question 9: You are a Customer Data Platform Specialist. The chief marke...
Question 10: You are a Customer Data Platform Specialist. Audience insigh...
Question 11: You ate taking over administrative responsibilities tor a Dy...
Question 12: You are a Customer Data Platform Specialist. You are configu...
Question 13: Your company uses Microsoft Dynamics 365 Customer Insights -...
Question 14: You recently configured a customer lifetime value (CIV) mode...
Question 15: You are a Customer Data Platform Specialist. Your informatio...
Question 16: You are a Customer Data Platform Specialist. The marketing t...
Question 17: Note: This question is part of a series of questions that pr...
Question 18: Your organization is using Dynamics 365 Customer Insights - ...
Question 19: Note: This question is part of a series of questions that pr...
Question 20: Note: This question is part of a series of questions that pr...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: You consult for an organization that is implementing Dynamic...
Question 24: You are a Customer Data Platform Specialist. You need to cre...
Question 25: Your team developed and integrated a batch inferencing pipel...
Question 26: You are a Customer Data Platform Specialist. You are in the ...
Question 27: You are a Customer Data Platform Specialist. You are asked t...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: Your organization is using Microsoft Power Query when connec...
Question 30: You are a Customer Data Platform Specialist. Your organizati...
Question 31: You are implementing Microsoft Dynamics 365 Customer Insight...
Question 32: Your team developed and integrated a batch inferencing pipel...
Question 33: Note: This question is part of a series of questions that pr...
Question 34: Your organization's marketing team is in the process of mapp...
Question 35: You are the administrator for a new Dynamics 365 Customer In...
Question 36: Note: This question is part of a series of questions that pr...
Question 37: You are a Customer Data Platform Specialist. You are impleme...
Question 38: You are a Customer Data Platform Specialist. Your company ha...
Question 39: Your data analytics team wants to create a custom machine le...
Question 40: You are a Customer Data Platform Specialist. You completed a...
Question 41: The marketing team wants to create a segment for a new email...
Question 42: You are a Customer Data Platform Specialist. You are creatin...
Question 43: You are a contributor for a Dynamics 365 Customer Insights -...
Question 44: You need to unify the different data sources within Microsof...
Question 45: Some of the data stored by your company needs to adhere to s...
Question 46: You are a Customer Data Platform Specialist. You are creatin...
Question 47: You need to export all the data in Dynamics 365 Customer Ins...
Question 48: Online orders are ingested into Dynamics 365 Customer Insigh...
Question 49: You are configuring data unification for a new Microsoft Dyn...
Question 50: You are a Customer Data Platform Specialist. You already hav...
Question 51: The marketing team wants to invite cycling club customers to...
Question 52: You are a Customer Data Platform Specialist. Your marketing ...
Question 53: You want to address the IT operations teams goal. What is th...
Question 54: You are a Customer Data Platform Specialist. You completed u...