更新されたのは2023年05月13日認定試験DP-500問題集で練習テスト問題
更新された検証済みのDP-500問題集と解答で合格保証もしくは全額返金
質問 # 28
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.
正解：
解説：
質問 # 29
You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.
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.
正解：
解説：
1 - From Power BI Desktop, create a role for the sales associates.
2 - From Tabular Editor, set Object Level Security to None for the Customer[Email] column and save the changes.
3 - From Power Bl Desktop, publish the dataset to the sales analytics workspace.
質問 # 30
You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?
- A. Vertipaq Analyzer
- B. DAX Studio
- C. Performance analyzer in Power Bl Desktop
- D. Tabular Editor
正解：C
解説：
Monitor report performance in Power BI Desktop using the Performance Analyzer. Monitoring will help you learn where the bottlenecks are, and how you can improve report performance.
Monitoring performance is relevant in the following situations:
Your Import data model refresh is slow.
Your DirectQuery or Live Connection reports are slow.
Your model calculations are slow.
Slow queries or report visuals should be a focal point of continued optimization.
質問 # 31
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 area. NOTE:
Each correct selection is worth one point.
正解：
解説：
質問 # 32
You have a Power Bl report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency. What should you do?
- A. Change the red background color to orange.
- B. Add additional measures to the table values.
- C. Change the font color of values in the Sales column to white.
- D. Add icons to represent the sales status of each product.
正解：A
質問 # 33
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.
正解：
解説：
Reference:
https://matplotlib.org/stable/api/markers_api.html
質問 # 34
You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula
engine.
What should you use?
- A. Vertipaq Analyzer
- B. DAX Studio
- C. Performance analyzer in Power Bl Desktop
- D. Tabular Editor
正解：C
質問 # 35
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.
正解：
解説：
質問 # 36
You have an Azure Synapse Analytics serverless SQL pool.
You need to catalog the serverless SQL pool by using Azure Purview.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
- B. Register a data source.
- C. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
- D. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
- E. Create a managed identity in Azure Active Directory (Azure AD).
正解：B、D、E
質問 # 37
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. a pie chart
- C. a bar chart
- D. an area chart
正解：C
質問 # 38
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. The query is timing out.
- B. Elevated permissions are being used to query records.
- C. All the query steps are folding.
- D. Some query steps are folding.
正解：C
解説：
Understanding folding with Query Diagnostics
One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were 'pushed down' by Power Query to be performed by the back-end data source, which is also known as 'folding'. If we want to see what folded, we can look at what is the 'most specific' query, or queries, that get sent to the back-end data source. We can look at this for both ODATA and SQL.
質問 # 39
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining an external table for the Parquet files and updating the query to use the table Does this meet the goal?
- A. Yes
- B. No
正解：B
解説：
Topic 2, Litware, Inc.
Azure Resources
Litware has the following Azure resources:
* An Azure Synapse Analytics workspace named synapseworkspace1
* An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
* A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool
SQLDW contains a dimensional model that contains the following table.
SQLDW contains the following additional tables.
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customeriD], dbo.Customer
[CustomerEmail], dbo.ProductfProductID] and dbo.Product[ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Power BI
Litware has a new Power Bl tenant that contains an empty workspace named Sales Analytics.
All users have Power B1 Premium per user licenses.
IT data analysts are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company's sales analytics goals. The dataset will be refreshed every 30 minutes.
Analytics Goals
Litware identifies the following analytics goals:
* Provide historical reporting of sales by product and channel over time.
* Allow sales managers to perform ad hoc sales reporting with minimal effort.
* Perform market basket analysis to understand which products are commonly purchased in the same transaction.
* Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Litware plans to monitor the adoption of Power Bl reports over time. The company wants custom Power Bl usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Security Requirements
Litware identifies the following security requirements for the analytics environment:
* All the users in the sales department and the marketing department must be able to see Power B1 reports that contain market basket analysis and data about which customers are likely to purchase a product.
* Customer contact data in SQLDW and the Power B1 dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.
* Sales associates must be prevented from seeing the CustomerEmail column in Power B1 reports.
* Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
* SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
* Power Bl content must be deployed to test and production by using deployment pipelines.
* All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power Bl reports in Synapse Studio.
質問 # 40
You have five Power Bl reports that contain R script data sources and R visuals.
You need to publish the reports to the Power Bl service and configure a daily refresh of datasets.
What should you include in the solution?
- A. a workspace that connects to an Azure Data Lake Storage Gen2 account
- B. a Power Bl Embedded capacity
- C. an on-premises data gateway (personal mode)
- D. an on-premises data gateway (standard mode)
正解：C
解説：
To schedule refresh of your R visuals or dataset, enable scheduled refresh and install an on-premises data gateway (personal mode) on the computer containing the workbook and R.
質問 # 41
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. Theme colors
- B. Divergent colors
- C. Sentiment colors
- D. First-level elements colors
正解：A、C
質問 # 42
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each
value may be used once, more than once. may need to drag the split bar between panes or scroll to view
content.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 43
You plan to modify a Power Bl dataset.
You open the Impact analysis panel for the dataset and select Notify contacts.
Which contacts will be notified when you use the Notify contacts feature?
- A. all the workspace members of any workspace that uses the dataset
- B. the workspace admins of any workspace that uses the dataset
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the Power Bl admins
正解：D
質問 # 44
You have a Power Bl dataset that contains the following measure.
You need to improve the performance of the measure without affecting the logic or the results. What should
you do?
- A. Remove "calendar'[Flag] = "YTD" from the code.
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Create a variable and replace the values for [sales Amount].
- D. Remove the alternative result of blank( ) from the divide function.
正解：B
質問 # 45
You need to create Power BI reports that will display data based on the customers' subscription level.
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.
正解：
解説：
1 - Create row-level security (RLS) roles
2 - Create a DAX expression.
3 - Add members to row-level security (RLS) roles
質問 # 46
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 dataset named Datasetl.
In Datasetl, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Power Bl Desktop, you group the measures in a display folder.
Does this meet the goal?
- A. Yes
- B. No
正解：B
解説：
Solution: From DAX Studio, you write a query that uses grouping sets.
A grouping is a set of discrete values that are used to group measure fields.
質問 # 47
You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
How should you complete the Python code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 48
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 dataset named Dataset1.
In Dataset1, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Tabular Editor, you create a calculation group.
Does this meet the goal?
- A. Yes
- B. No
正解：B
質問 # 49
You have a Power BI Premium capacity.
You need to increase the number of virtual cores associated to the capacity.
Which role do you need?
- A. capacity admin
- B. Power Platform admin
- C. Power Bl admin
- D. Power Bl workspace admin
正解：C
解説：
Change capacity size
Power BI admins and global administrators can change Power BI Premium capacity. Capacity admins who are not a Power BI admin or global administrator don't have this option.
質問 # 50
You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes.
What should you do first?
- A. Configure a scheduled refresh.
- B. Define an incremental refresh policy.
- C. Change the storage mode of the dataset.
- D. Enable the XMLA endpoint.
正解：A
解説：
To get to the Scheduled refresh screen:
1. In the navigation pane, under Datasets, select More options (...) next to a dataset listed.
2. Select Schedule refresh.
質問 # 51
......
試験エンジンはDP-500試験無料お試しサンプル365日更新されます：https://www.passtest.jp/Microsoft/DP-500-shiken.html
DP-500のPDF問題とテストエンジンには115問があります：https://drive.google.com/open?id=13zHvNlh5xgzwot7lLBSn6A4lGCZeFbTz