Helping Hand Questions for PL-300

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

You need to create a relationship in the dataset for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?