A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft Power Platform solution.
You need to recommend a data-loading solution.
What should you recommend?

You are designing a data model for a Microsoft Power Platform solution.
The data model must meet the following requirements:
* When an account is assigned to a new salesperson, all opportunities that ate associated with the account must be assigned to the new salesperson.
* When a salesperson assigns a lead to another salesperson, all phone call activities related to the lead must be assigned to the new salesperson.
You need to recommend cascading strategies for the data model.
Which cascading strategy should you recommend? To answer, drag the appropriate cascading strategies to the correct requirements. Each cascading strategy may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worthone point.

You are designing a model-driven app that provides marketing, sales, and service operations to a company.
The app must integrate with the following systems and data sources:
* A third-party marketing system for lead generation and website submissions.
* A Microsoft Excel Online file that contains manufacturing data on relevant products.
* A separate Microsoft Dataverse environment.
You need to recommend Power Automate connectors for the app.
Which connections should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You are overseeing the data migration for a Microsoft Power Platform solution.
The migration team is performing a test migration with a subset of data. The migration team reports the following findings:
Users who own account rows are receiving system generated emails.
Data that is not part of the migration is being added to the Contact and Appointment tables.
The size of the log listed on the Power Platform admin center Capacity page has increased significantly.
You need to recommend strategies to resolve the reported issues.
What should you recommend? To answer, drag the appropriate resolution to the correct migration problem.
Each resolution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Hotspot Question
A company plans to transition from an existing proprietary solution to a Power Platform solution.
The company is consolidating data from several sources.
The company reports the following data quality issues with the existing solution:
- Users often encounter a character limit when entering data.
- The database includes multiple instances of duplicate records.
You need to recommend solutions to ensure that the data quality issues are not present in the Power Platform solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.