Question 141
You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.


Select the appropriate yes or no.

Question 142
You have a Rawer Bl report That imports a dace table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
* Due Date
* Order Date
* Delivery Date
You need to support the analysis of sales over time based on all three dates at the same time.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
* Due Date
* Order Date
* Delivery Date
You need to support the analysis of sales over time based on all three dates at the same time.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.
Does this meet the goal?
Question 143
You have the Azure SQL databases shown in the following table.

You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.

You plan to build a single PBIX file to meet the following requirements:
* Data must be consumed from the database that corresponds to each stage of the development lifecycle.
* Power Bl deployment pipelines must NOT be used.
* The solution must minimize administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
Question 144
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
Question 145
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?



