Question 71

You have a Power Bl report named Orders that supports the following analysis:
* Total sales over time
* The count of orders over time
* New and repeat customer counts
The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

Question 72

You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
  • Question 73

    You have a Power BI report.
    You need to create a calculated table to return the 100 highest spending customers.
    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 74

    You have a Power Bi report. The report contains a visual that snows gross sales by date The visual has anomaly detection enabled.
    No anomalies ate detected
    You need to increase the likelihood that anomaly detection will identify anomalies in the report.
    What should you do?
  • Question 75

    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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.
    You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.
    Solution: You modify the source step of the queries to use DataSourceExcel as the file path.
    Does this meet the goal?