[2024年更新]DP-500はAzure Enterprise Data Analyst Associateリアルな無料試験練習テスト
無料Azure Enterprise Data Analyst Associate DP-500試験問題を提供します
Microsoft DP-500試験は、データ分析とビジネスインテリジェンスのキャリアを進めたい個人にとって優れた資格です。これは、分析ソリューションの設計と実装に関連するさまざまなトピックについて強い理解力を持つ受験者が求められる難しい試験です。この試験に合格することで、個人はこの分野の専門知識を証明し、キャリアを進めて収入を増やすことができます。
質問 # 70
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.
正解：
解説：
質問 # 71
You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.
You need to review statistics for a DataFrame that includes:
The column name
The column type
The number of distinct values
Whether the column has missing values
Which function should you use?
- A. displayHTML()
- B. display(df)
- C. %%configure
- D. display(df, summary=true)
- E. %%lsmagic
正解：D
解説：
display(df) statistic details
You can use display(df, summary = true) to check the statistics summary of a given Apache Spark DataFrame that include the column name, column type, unique values, and missing values for each column. You can also select on specific column to see its minimum value, maximum value, mean value and standard deviation.
質問 # 72
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.
正解：
解説：
1 - Create a web data source.
2 - Expand the attributes.
3 - Publish the model.
質問 # 73
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.
What should you include in the recommendation?
- A. the on-premises data gateway
- B. Site-to-Site VPN
- C. an XMLA endpoint
- D. Azure Purview
正解：A
解説：
Explanation
Refresh data from an on-premises SQL Server database
The SQL Server database must be accessed by Power BI through an on-premises data gateway.
You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
質問 # 74
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. Enable the XMLA endpoint.
- B. Change the storage mode of the dataset.
- C. Configure a scheduled refresh.
- D. Define an incremental refresh policy.
正解：C
解説：
You cannot schedule a refresh on 15-minute increments. Only 30, unless using XMLA endpoint.
質問 # 75
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
質問 # 76
You have an Azure subscription that contains an Azure Synapse Analytics workspace. You create an Azure Data Lake Storage Gen2 account and upload a CSV file named Filel.csv. You need to use Synapse Studio to query the data in Filel.csv by using a serverless SQL pool. Which Transact-SQL operator should you include in the query?
- A. OPENOUERY
- B. OPCNROWSET
- C. STRIMO_SPLIT
- D. OPEMDATASOURCE
正解：B
質問 # 77
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. Enable the XMLA endpoint.
- C. Change the storage mode of the dataset.
- D. Define an incremental refresh policy.
正解：B
質問 # 78
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
解説：
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.
質問 # 79
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.
正解：
解説：
質問 # 80
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? 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.
正解：
解説：
Explanation
Box 1: SELECTEDMEASURENAME()
SELECTEDMEASURENAME is used by expressions for calculation items to determine the measure that is in context by name.
Syntax: SELECTEDMEASURENAME()
No parameters.
Example:
The following calculation item expression checks if the current measure is Expense Ratio and conditionally applies calculation logic. Since the check is based on a string comparison, it is not subject to formula fixup and will not benefit from object renaming being automatically reflected. For a similar comparison that would benefit from formula fixup, please see the ISSLECTEDMEASURE function instead.
IF (
SELECTEDMEASURENAME = "Expense Ratio",
SELECTEDMEASURE (),
DIVIDE ( SELECTEDMEASURE (), COUNTROWS ( DimDate ) )
)
Box 2: SELECTEDVALUE()
SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.
Syntax:
SELECTEDVALUE(<columnName>[, <alternateResult>])
M1, M2, ... - A list of measures.
Reference: https://docs.microsoft.com/en-us/dax/selectedmeasurename-function-dax
https://docs.microsoft.com/en-us/dax/selectedvalue-function
質問 # 81
You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to modify the source control solution to use an Azure DevOps Git repository. What should you do first?
- A. Create a new pull request.
- B. Change the workspace to live mode.
- C. Change the active branch.
- D. Disconnect from the GitHub repository.
正解：D
解説：
Explanation
By default, Synapse Studio authors directly against the Synapse service. If you have a need for collaboration using Git for source control, Synapse Studio allows you to associate your workspace with a Git repository, Azure DevOps, or GitHub.
Prerequisites
Users must have the Azure Contributor (Azure RBAC) or higher role on the Synapse workspace to configure, edit settings and disconnect a Git repository with Synapse.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control
質問 # 82
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. Enable the XMLA endpoint.
- B. Change the storage mode of the dataset.
- C. Configure a scheduled refresh.
- D. Define an incremental refresh policy.
正解：C
解説：
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.
質問 # 83
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.
正解：
解説：
Explanation
Box 1: three scatterplots
Compare Plots
Example, Draw two plots on the same figure:
import matplotlib.pyplot as plt
import numpy as np
#day one, the age and speed of 13 cars:
x = np.array([5,7,8,7,2,17,2,9,4,11,12,9,6])
y = np.array([99,86,87,88,111,86,103,87,94,78,77,85,86])
plt.scatter(x, y)
#day two, the age and speed of 15 cars:
x = np.array([2,2,8,1,15,8,12,9,7,3,11,4,7,14,12])
y = np.array([100,105,84,105,90,99,90,95,94,100,79,112,91,80,85])
plt.scatter(x, y)
plt.show()
Result:
Chart, scatter chart Description automatically generated
Box 2: three marker symbols
One for each scatterplot. One default, and two defined.
Default is point.
v is triangle down.
^ is triangle up.
Reference: https://www.w3schools.com/python/matplotlib_scatter.asp
https://matplotlib.org/stable/api/markers_api.html
質問 # 84
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
Which four 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.
正解：
解説：
Explanation
Step 1: From powerbi.com, create a new report..
The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Step 2: Add a report measure
Measures are used in some of the most common data analyses. Simple summarizations such as sums, averages, minimum, maximum and counts can be set through the Fields well. The calculated results of measures are always changing in response to your interaction with your reports, allowing for fast and dynamic ad-hoc data exploration.
Step 3: Add visuals to the report
Step 4: Publish the report to the Sales Analytics workspace
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-measures
質問 # 85
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.
正解：
解説：
Explanation
質問 # 86
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the Microsoft SQL Server data warehouse.
What should you include in the recommendation?
- A. the on-premises data gateway
- B. Site-to-Site VPN
- C. an XMLA endpoint
- D. Azure Purview
正解：A
解説：
Refresh data from an on-premises SQL Server database
The SQL Server database must be accessed by Power BI through an on-premises data gateway.
You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).
質問 # 87
You are using an Azure Synapse notebook to create a Python visual.
You run the following code cell to import a dataset named Iris.
A sample of the data is shown in the following table.
You need to create the visual shown in the exhibit. (Click the Exhibit tab.)
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.
正解：
解説：
Explanation
Box 1: pairplot
A pairs plot allows us to see both distribution of single variables and relationships between two variables. Pair plots are a great method to identify trends for follow-up analysis and, fortunately, are easily implemented in Python!
Example, let's plot data using pairplot:
From the picture below, we can observe the variations in each plot. The plots are in matrix format where the row name represents x axis and column name represents the y axis. The main-diagonal subplots are the univariate histograms (distributions) for each attribute.
A picture containing diagram Description automatically generated
Box 2: sepal_width
sepal_width is displayed with a height of 2.5 (between 2.0 and 4.5).
Reference: https://medium.com/analytics-vidhya/pairplot-visualization-16325cd725e6
質問 # 88
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? 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.
正解：
解説：
質問 # 89
You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time.
You use Power Bl Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.
You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.
How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings.
Each option 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.
正解：
解説：
Explanation
質問 # 90
You have a Power Bl tenant that is configured as 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 answer is worth one point.
正解：
解説：
質問 # 91
......
Microsoft DP-500リアルな問題と知能問題集：https://www.passtest.jp/Microsoft/DP-500-shiken.html
DP-500問題集でAzure Enterprise Data Analyst Associate高確率練習問題集：https://drive.google.com/open?id=1hYV9e-dyJeP2ROGGO9C_ISX7iL7njVmB