A company sells antique books. The company stores data about book locations in an existing system by using the following database fields: Room, Shelf. The company must import the data from the existing system into a Power Platform solution. Existing data into must be modified to match the design of the new solution. You need to recommend a solution to combine the room and shelf fields into a single column during the import process. Which tool should you recommend? A. Power Platform dataflows B. Data Import Wizard C. import from CSV D. Microsoft Excel Online  Suggested Answer: B Dataverse includes a web application tool called Import Data Wizard. You use this tool to import data records from one or more comma-separated values (.csv), XML Spreadsheet 2003 (.xml), or text files. Use transformation mapping to modify data before importing it. For example, split a full name that is contained in the source file into a first name and a last name to match the target columns for a table. Note: To implement data import, you typically do the following: ✑ Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file. ✑ Create a data map or use an existing data map. ✑ Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file. ✑ Create a data map or use an existing data map. ✑ Associate an import file with a data map. ✑ Upload the content from a source file to the associated import file. ✑ Parse the import file. ✑ Transform the parsed data. ✑ Upload the transformed data into the target Dataverse server. Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/import-data https://docs.microsoft.com/en-us/powerapps/developer/data-platform/add-transformation-mappings-import This question is in PL-600 Microsoft Power Platform Solution Architect Exam For getting Microsoft Certified: Power Platform Solution Architect Expert Certificate Disclaimers: The website is not related to, affiliated with, endorsed or authorized by Microsoft. The website does not contain actual questions and answers from Microsoft's Certification Exams. Trademarks, certification & product names are used for reference only and belong to Microsoft.
Please login or Register to submit your answer