Q10
Single choice
You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:
1. Customer_Name
2. Customer ID
3. Website
The Contacts table contains the following columns:
1. Contact ID
2. Contact Email
3. Contact Name
4. Customer Name
A web-based contact form is used to fill the Contacts table. The data is not sanitized.
You need to create a merge for the Customer and Contacts tables.
What should you do?