Question 46

You need to recommend a solution to resolve the query issue of the serverless SQL pool. The solution must minimize impact on the users.
What should you in the recommendation?
  • Question 47

    You have a Power BI report named Report1. Repor1 is connected to an imported dataset that contains a matrix. The matrix displays five measures. When users view the report they discover that the matrix is slow to render.
    You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix. What should you use?
  • Question 48

    You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
    You need to present the data distribution statistics from a DataFrame in a tabular view.
    Which method should you invoke on the DataFrame?
  • Question 49

    You have an Azure Synapse Analytics serverless SQL pool.
    You need to return a list of files and the number of rows in each file.
    How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
    NOTE: Each correct selection is worth one point.

    Question 50

    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 the Power Bl data model shown in the exhibit. (Click the Exhibit tab.)

    Users indicate that when they build reports from the data model, the reports take a long time to load.
    You need to recommend a solution to reduce the load times of the reports.
    Solution: You recommend moving all the measures to a calculation group.
    Does this meet the goal?