DP-500のPDF試験材料2024年最新の実際に出るDP-500問題集
更新されたのはMicrosoft DP-500問題集PDFオンラインエンジン
Microsoft DP-500試験は、Microsoftテクノロジーを使用して企業規模のアナリティクスソリューションを設計および実装するスキルと知識を証明するための優れた機会です。この試験に合格することで、データ駆動型の意思決定を支援するスケーラブルなアナリティクスソリューションの設計と実装において、自己の熟練度を証明することができます。また、この認定は、データアナリティクス分野で新しい機会を開くことで、キャリアアップを支援することもできます。
質問 # 36
You have a Power Bl dataset that has the query dependencies 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.
正解：
解説：
質問 # 37
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. Create a variable and replace the values for [sales Amount].
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Remove "calendar'[Flag] = "YTD" from the code.
- D. Remove the alternative result of blank( ) from the divide function.
正解：B
質問 # 38
You have new security and governance protocols for Power Bl reports and datasets. The new protocols must
meet the following requirements.
* New reports can be embedded only in locations that require authentication.
* Live connections are permitted only for workspaces that use Premium capacity datasets.
Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer
presents part of the solution. NOTE: Each correct selection is worth one point.
- A. From Tenant settings, set Publish to web to Disable.
- B. From Capacity settings, set XMLA Endpoint to Read Write.
- C. From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
- D. From Embed Codes, delete all the codes.
- E. From the Premium per user settings, set XMLA Endpoint to Off.
正解：C
質問 # 39
You are creating a Power 81 single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?
- A. the tab order
- B. the layer order
- C. the X position
- D. the bookmark order
正解：A
解説：
Tab order is the order in which users interact with the items on a page using the keyboard. Generally, we want tab order to be predictable and to closely match the visual order on the page (unless there is a good reason to deviate).
Note: If you are using the keyboard to navigate in a Power BI report, the order in which you arrive at visuals will not follow your vision unless you set the new tab order property. If you have low or no vision, this becomes an even bigger issue because you may not be able to see that you are navigating visuals out of visual order because the screen reader just reads whatever comes next.
質問 # 40
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. Create a variable and replace the values for [sales Amount].
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Remove "calendar'[Flag] = "YTD" from the code.
- D. Remove the alternative result of blank( ) from the divide function.
正解：B
質問 # 41
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
質問 # 42
You need to recommend a security solution for the Power Bl tenant to control external data sharing. The solution must meet the technical requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation
質問 # 43
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. No
- B. Yes
正解：A
質問 # 44
You open a Power Bl Desktop report that contains an imported data model and a single report page.
You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit
What can you identify from the results?
- A. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
- B. The Actual/Forecast Billable Hrs YTD visual displays the most data.
- C. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
- D. Unoptimized DAX queries cause the page to load slowly.
正解：C
解説：
Most time is spent in the category Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.
Note: Each visual's log information includes the time spent (duration) to complete the following categories of tasks:
DAX query - if a DAX query was required, this is the time between the visual sending the query, and for Analysis Services to return the results.
Visual display - time required for the visual to draw on the screen, including time required to retrieve any web images or geocoding.
Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.
質問 # 45
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
質問 # 46
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?
- A. selective deployment
- B. parameter rules
- C. auto-binding across pipelines
- D. data source rules
正解：A
質問 # 47
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. Change the workspace to live mode.
- B. Disconnect from the GitHub repository.
- C. Create a new pull request.
- D. Change the active branch.
正解：B
解説：
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
質問 # 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 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
解説：
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.
質問 # 49
You need to create Power Bl 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.
正解：
解説：
質問 # 50
The group registers the Power Bl tenant as a data source1.
You need to ensure that all the analysts can view the assets in the Power Bl tenant The solution must meet the technical requirements for Microsoft Purview and Power BI.
What should you do?
- A. Search the data catalog.
- B. Create a scan.
- C. Deploy a Power Bl gateway.
- D. Create a linked service.
正解：B
質問 # 51
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.
- A. Publish the complete dataset.
- B. Publish an initial dataset that is less than 10 GB.
- C. Increase the Max Offline Dataset Size setting.
- D. Restart the capacity.
- E. Invoke a refresh to load historical data based on the incremental refresh policy.
正解：A、E
解説：
Enable large datasets
Steps here describe enabling large datasets for a new model published to the service. For existing datasets, only step 3 is necessary.
Create a model in Power BI Desktop. If your dataset will become larger and progressively consume more memory, be sure to configure Incremental refresh.
Publish the model as a dataset to the service.
In the service > dataset > Settings, expand Large dataset storage format, set the slider to On, and then select Apply.
Enable large dataset slider
Invoke a refresh to load historical data based on the incremental refresh policy. The first refresh could take a while to load the history. Subsequent refreshes should be faster, depending on your incremental refresh policy.
質問 # 52
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?
- A. Sales[Sales Amount]
- B. Sales[Sales ID]
- C. Sales[RowlD]
- D. Plan[RowlD]
正解：C
解説：
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.
質問 # 53
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.
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
質問 # 54
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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.
正解：
解説：
Explanation
Step 1: Install the on-premises data gateway (standard mode)
The personal mode is only for a single user, not to be used for a shared dataset.
Step 2: From powerbi.com, add a data source to the gateway clusters
After you install the on-premises data gateway, you can add data sources that can be used with the gateway.
Add a data source
Under Data Source Type, select SQL Server.
After you fill in everything, select Create. You can now use this data source for scheduled refresh or DirectQuery against a SQL Server that's on-premises. You see Created New data source if it succeeded.
Step 3: From powerbi.com, configure Dataset1 to use a data gateway.
Connect a dataset to a SQL Server database
In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network. Follow these steps to add your on-premises SQL Server database as a data source to a gateway and then connect your dataset to this data source.
Sign in to Power BI. In the upper-right corner, select the settings gear icon and then select Settings.
On the Datasets tab, select the dataset AdventureWorksProducts, so you can connect to your on-premises SQL Server database through a data gateway.
Expand Gateway connection and verify that at least one gateway is listed.
Under Actions, expand the toggle button to view the data sources and select the Add to gateway link.
On the Gateways management page, on the Data Source Settings tab, enter and verify the following information, and select Add.
On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
質問 # 55
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.
正解：
解説：
質問 # 56
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
正解：
解説：
Explanation
Box 1: Yes
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
Box 2: No
Table.SelectRows returns a table of rows from the table, that matches the selection condition.
Box 3: Yes
Azure Data Lake Storage has higher throughput and IOPS.
Note: Azure Blob Storage is a general purpose, scalable object store that is designed for a wide variety of storage scenarios. Azure Data Lake Storage is a hyper-scale repository that is optimized for big data analytics workloads.
Azure Data Lake Storage use Cases: Batch, interactive, streaming analytics and machine learning data such as log files, IoT data, click streams, large datasets Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
https://docs.microsoft.com/en-us/powerquery-m/table-selectrows
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-comparison-with-blob-storage
質問 # 57
......
MicrosoftのDP-500認定試験は、Microsoft AzureやMicrosoft Power BIを使用して企業規模のアナリティクスソリューションを設計・実装する専門家の能力を証明するために設計されています。この認定は、候補者が最新のテクノロジーを活用して複雑な組織の分析ニーズを満たすスケーラブルで信頼性の高いセキュアなソリューションを設計・実装する能力を認定します。
Microsoft DP-500問題集PDFのベストを目指すなら問題集を使おう！高得点目指すならここ：https://jp.fast2test.com/DP-500-premium-file.html
DP-500のPDFで問題解答！PDFサンプル問題は信頼され続ける：https://drive.google.com/open?id=1njUFlD9HKIGozaydmvGQylL2CkjoU083