ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 6 - PL-600 discussion

Report
Export

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

Answers
A.

Power Platform dataflows

B.

Data Import Wizard

Answers
B.

Data Import Wizard

C.

import from CSV

Answers
C.

import from CSV

D.

Microsoft Excel Online

Answers
D.

Microsoft Excel Online

Suggested answer: B

Explanation:

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

asked 05/10/2024
RAOUL AMODIO
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first