DP-500 無料問題集「Microsoft Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI」

You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The dataset uses Import storage mode and contains the following data sources:
* A CSV file in an Azure Storage account
* An Azure Database for PostgreSQL database
You plan to use deployment pipelines to promote the content from development to test to production. There will be different data source locations for each stage. What should you include in the deployment pipeline to ensure that the appropriate data source locations are used during each stage?

Note: This question is part of a scries 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 creating a perspective that contains the commonly used fields.
Does this meet the goal?

You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

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?

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?

You have an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that the SQL pool is scanned by Azure Purview.
What should you do first?

You have the following code in an Azure Synapse notebook.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the code.
NOTE: Each correct selection is worth one point.

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 Power Bl Premium capacity.
From the Power Bl Premium Capacity Metrics app, you discover the following:
* There is insufficient CPU to execute dataset refreshes.
* Out-of-memory throttling occurs when the dataset is waiting.
You need to recommend a solution to resolve the performance issues.
Solution: You scale up the capacity.
Does this meet the goal?

You have a Power Bl dataset that has only the necessary fields visible for report development.
You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.
What should you do?

You have a team of business analysts that uses Power Bl for departmental analytics.
The team creates and manages PBIX files.
You need to implement a source control solution for the PBIX files. The solution must meet the following requirements:
* Provide version tracking and roll back.
* Minimize version conflicts between edits.
* Ensure that all the analysts can access the files.
* Prevent multiple analysts from editing the same version of a file.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.