Previous

Next

Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

Jim creates a dataflow by using Power Query to import a list of conference attendees into an existing contact table in Dataverse. The process adds the attendees to the contact table, even when they already exist, based on their email address, which is a key column in Dataverse. Why did the existing contact records fail to update?

Duplicate rules must be configured for email addresses.

Column mapping must be set for the email address as a key.

The dataflow incremental refresh setting is set to full refresh.

2.

You create a dataflow that imports records in a Dataverse table based on an Excel spreadsheet located in a OneDrive for Business folder. After you update the file and save it, the new records aren't visible in the destination table. What could cause this situation?

The automatic refresh setting should be set to trigger on file updates.

The file property for last modification must be changed.

The refresh setting is set to refresh manually and must be triggered.

3.

A transformed column containing the street number and name is missing during import to a Dataverse table. What could cause this situation?

The column must be mapped to a column of the Dataverse table.

The source columns for this transformed column are already mapped.

Transformed columns are unavailable to map to Dataverse columns.

You must answer all questions before checking your work.

Continue