[2024年更新]早速ゲットしてトップランクのMicrosoft DP-500試験問題集
パスする秘訣はDP-500をゲットして認証された試験エンジンPDF
質問 # 97
You need to integrate the external data source to support the planned changes.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of
actions to the answer area and arrange them in the correct order.
正解：
解説：
質問 # 98
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?
- A. Grant the sales managers the Build permission for the existing Power Bl datasets.
- B. Create a deployment pipeline and grant the sales managers access to the pipeline.
- C. Create a PBIT file and distribute the file to the sales managers.
- D. Grant the sales managers admin access to the existing Power Bl workspace.
正解：C
解説：
Explanation
Allow sales managers to perform ad hoc sales reporting with minimal effort Power BI report templates contain the following information from the report from which they were generated:
Report pages, visuals, and other visual elements
The data model definition, including the schema, relationships, measures, and other model definition items All query definitions, such as queries, Query Parameters, and other query elements What is not included in templates is the report's data.
Report templates use the file extension .PBIT (compare to Power BI Desktop reports, which use the .PBIX extension).
Note: With Power BI Desktop, you can create compelling reports that share insights across your entire organization. With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. Templates in Power BI Desktop help you jump-start and standardize report creation.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-templates
質問 # 99
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?
- A. No
- B. Yes
正解：A
解説：
Explanation
Instead denormalize For Performance.
Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.
Reference: https://www.mssqltips.com/sqlservertutorial/3211/denormalize-for-performance/
質問 # 100
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.
正解：
解説：
https://matplotlib.org/stable/gallery/lines_bars_and_markers/bar_stacked.html
https://matplotlib.org/stable/api/legend_api.html
質問 # 101
You are optimizing a Power Bl data model by using DAX Studio.
You need to capture the query events generated by a Power Bl Desktop report.
What should you use?
- A. a Server Timings trace
- B. an All Queries trace
- C. a Query Plan trace
- D. the DMV list
正解：B
解説：
The All Queries trace in Dax Studio supports capturing the query events from all client tools (not just queries sent from DAX Studio like the Query Plan and Server Timings features do). The 'All Queries" trace is really useful when you wish to see the queries that are generated by a client tool like Power BI Desktop.
質問 # 102
You have the Power BI workspaces shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation
Box 1: Infrastrucrue Svcs
Infrastrucrue Svcs is a Premium workspace.
If users have a free license and the workspace is stored in Premium (dedicated) capacity, they will be able to view and interact with the content in that workspace.
If users have a free license and the workspace is stored in shared capacity (not premium), they will not be able to see the content in shared workspace, only "My workspace".
If users have pro license, they will be able to view and interact with the content in that workspace.
Box 2: Admin
We need to activate the Orpaned workspace.
An orphaned workspace is one that does not have an admin assigned.
If you're a Service Admin, you can now view all of your organization's workspaces through the Admin Portal in the user interface.
Graphical user interface, table Description automatically generated with medium confidence
It's easy to Recover an orphan from this screen. Simply select the workspace and click Recover, then add yourself or another user as an admin.
Reference:
https://community.powerbi.com/t5/Service/Difference-between-Public-and-Private-workspace/m-p/1382219
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces
質問 # 103
You are configuring a Power Bl report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Sentiment colors
- B. First-level elements colors
- C. Divergent colors
- D. Theme colors
正解：A、D
解説：
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes
質問 # 104
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?
- A. Search the data catalog.
- B. Create a data share connection.
- C. Create a data policy.
- D. Register a data source.
正解：A
質問 # 105
You have the following Python code in an Apache Spark notebook.
Which type of chart will the code produce?
- A. a stacked bar chart
- B. an area chart
- C. a bar chart
- D. a pie chart
正解：B
解説：
Explanation
The matplotlib.pyplot.fill_between function fills the area between two horizontal curves.
The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.
Reference: https://matplotlib.org/3.5.0/api/_as_gen/matplotlib.pyplot.fill_between.html
質問 # 106
You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the following requirements:
* Code must always be merged to the main branch before being published, and the main branch must be used for publishing resource
* The workspace templates must be stored in the publish branch.
* A branch named dev123 will be created to support the development of a new feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation
Box 1: main
Code must always be merged to the main branch before being published, and the main branch must be used for publishing resources.
Collaboration branch - Your Azure Repos collaboration branch that is used for publishing. By default, its master. Change this setting in case you want to publish resources from another branch. You can select existing branches or create new.
Each Git repository that's associated with a Synapse Studio has a collaboration branch. (main or master is the default collaboration branch).
Box 2: workspace_publish
A branch named dev123 will be created to support the development of a new feature.
The workspace templates must be stored in the publish branch.
Creating feature branches
Users can also create feature branches by clicking + New Branch in the branch dropdown.
By default, Synapse Studio generates the workspace templates and saves them into a branch called workspace_publish. To configure a custom publish branch, add a publish_config.json file to the root folder in the collaboration branch.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control
質問 # 107
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?
- A. No
- B. Yes
正解：A
解説：
Explanation
Instead denormalize For Performance.
Even though it might mean storing a bit of redundant data, schema denormalization can sometimes provide better query performance. The only question then becomes is the extra space used worth the performance benefit.
Reference: https://www.mssqltips.com/sqlservertutorial/3211/denormalize-for-performance/
質問 # 108
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as shown in the following exhibit.
How should you configure the chart? To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 109
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Synapse Studio
- B. Azure Data Studio
- C. DAX Studio
- D. Performance analyzer in Power Bl Desktop
正解：C、D
解説：
Some users indicate that the visuals in Power BI reports are slow to render when making filter selections.
B: You can investigate a slow query in a Power BI report using DAX Studio, looking at the query plan and the server timings.
D: Use Power BI Desktop Performance Analyzer to optimize the report or model.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/report-performance-troubleshoot
質問 # 110
You have the Power BI workspaces shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information
presented in the graphic.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 111
You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache
Parquet format. A sample of the data is shown in the following table.
You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?
- A. FOR.JSON
- B. FIRST VALUE
- C. CONVERT
- D. JS0N_VALUE
正解：D
質問 # 112
You have a Power Bl dataset. The dataset contains data that is updated frequently.
You need to improve the performance of the dataset by using incremental refreshes.
Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
解説：
1 - Create RangeStart and RangeEnd parameters.
2 - Apply a custom Date/Time filter to the data.
3 - Define the incremental refresh policy for the table.
4 - Publish the model to the Power BI service.
質問 # 113
You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue.
You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.
What should you do?
- A. Populate the alt text with a static value.
- B. Add the value to the chart title text.
- C. Convert the card into a text box.
- D. Populate the alt text by using conditional formatting with a DAX measure.
正解：D
質問 # 114
......
Microsoft DP-500認定を獲得すると、新しいキャリアの機会が開かれ、収益の可能性が高まります。この認定は、世界中の企業によって認識されており、混雑した雇用市場で目立つことができます。あなたがあなたのキャリアを前進させようとしているか、新しいキャリアを始めようとしているかどうかにかかわらず、Microsoft DP-500認定試験はあなたの将来への貴重な投資です。この試験に合格することにより、Microsoft Azure and Power BIを使用して、エンタープライズスケール分析ソリューションの設計と実装に関する専門知識を実証できます。
DP-500試験問題は練習は2024年最新の164問題：https://www.passtest.jp/Microsoft/DP-500-shiken.html
DP-500試験問題集パスと最新テスト問題集：https://drive.google.com/open?id=13zHvNlh5xgzwot7lLBSn6A4lGCZeFbTz