Question 126
You have a Power Bl report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 127
You have a power BI tenant that hosts the datasets shown in the following table.
You have the following requirements:
* The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
* Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point
You have the following requirements:
* The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
* Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point
Question 128
You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?
Question 129
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?
Question 130
You import a Power Bl dataset that contains the following tables:
* Date
* Product
* Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?
* Date
* Product
* Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.
The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?