• ホーム
  • ブログ
  • DP-500練習問題集で検証済みで更新された164問題あります [Q93-Q115]

DP-500練習問題集で検証済みで更新された164問題あります [Q93-Q115]

Share

DP-500練習問題集で検証済みで更新された164問題あります

更新されたDP-500試験問題集でPDF問題とテストエンジン


Microsoft DP-500認定試験は、データストレージソリューションの設計と実装、データ処理ソリューションの設計と実装、データ分析ソリューションの設計と実装、データ視覚化ソリューションの設計と実装、Azure Synapse分析の実装など、さまざまなトピックで構成されています。試験に合格した候補者は、Microsoft AzureおよびMicrosoft Power BIを使用して、エンタープライズスケール分析ソリューションの設計と実装に習熟することができます。


DP-500認定試験は、エンタープライズスケール分析ソリューションに関連するさまざまなトピックをカバーする包括的な試験です。試験で取り上げられている重要なトピックには、データストレージソリューションの設計と実装、データ処理ソリューションの設計と実装、データ分析ソリューションの設計と実装、データ視覚化ソリューションの設計と実装、データ保護ソリューションの設計と実装などがあります。この認定試験に合格することにより、専門家はこれらの分野の専門知識を実証し、Microsoft AzureとMicrosoft Power BIを使用してエンタープライズスケール分析ソリューションを設計および実装する能力を証明できます。


Microsoft DP-500認定試験は、Microsoft AzureとMicrosoft Power BIを使用して、エンタープライズスケール分析ソリューションの設計と実装のスキルを検証したい専門家向けに設計されています。この認定は、ビッグデータを扱い、スケーラブルなデータソリューションの作成に関する専門知識を実証したいと考えている建築家、開発者、およびデータエンジニアに最適です。この試験に合格すると、現代のビジネスのニーズを満たすデータソリューションを構築および維持するために必要なスキルと知識があることが示されています。

 

質問 # 93
You need to build a Transact-SQL query to implement the planned changes for the internal users.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation
Box 1: PREDICT
Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.
The example below shows a sample query using prediction function. An additional column with name Score and data type float is created containing the prediction results. All the input data columns as well as output prediction columns are available to display with the select statement.
-- Query for ML predictions
SELECT d.*, p.Score
FROM PREDICT(MODEL = (SELECT Model FROM Models WHERE Id = 1),
DATA = dbo.mytable AS d, RUNTIME = ONNX) WITH (Score float) AS p;
Box 2: WITH
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-predict


質問 # 94
You need to identify the root cause of the data refresh issue.
What should you use?

  • A. the Usage Metrics Report in powerbi.com
  • B. Performance analyzer in Power Bl Desktop
  • C. Query Diagnostics in Power Query Editor

正解：C

解説：
Users indicate that the data in Power BI reports is stale. You discover that the refresh process of the Power BI model occasionally times out.
With Query Diagnostics, you can achieve a better understanding of what Power Query is doing at authoring and at refresh time in Power BI Desktop. While we'll be expanding on this feature in the future, including adding the ability to use it during full refreshes, at this time you can use it to understand what sort of queries you're emitting, what slowdowns you might run into during authoring refresh, and what kind of background events are happening.
Topic 3, Fabrikam, Inc.
Overview
Fabrikam, Inc. is a software company that develops educational software for higher education.
Fabrikam has the following business units:
* Finance and Accounting
* Sales and Marketing
* Operations
* Product
The Product business unit contains the following groups:
* User experience designers
* Software engineers
* Product managers
* Testers
The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team.
Fabrikam has three Azure Synapse Analytics workspaces named workspace! prod, workspace 1 test, and workspaceldev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power Bl.
The company imports the following files into the Data Lake Storage accounts:
* User experience data stored as JSON files
* Finance data stored as CSV files
* Sales data stored as CSV files
Fabrikam has a Power Bl tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQuery datasets. All reports are interactive.
Fabrikam has three frequently used workspaces as shown in the following table.

The Corporate Data Models workspace contains a dataset named Financial Model that is used by reports in the P&L workspace. Financial Model is maintained by the enterprise analytics team. The Corporate Data Models workspace and the User Experience workspace have corresponding development and test workspaces.
Administrators report an increase in the maintenance of Power Bl tenant assets due to analysts in the Finance and Accounting business unit who create new Power Bl datasets when the existing datasets already meet their needs.
Analysts in the Product business unit report the following issues:
* Datasets are published to the User Experience workspace, while the data sources reference workspace! test.
* The parsing of user experience data in Power Query is very slow.
The enterprise analytics team identifies two DAX measures in the Financial Model dataset that are consistently slow to execute. The team must identify all the reports that use the Financial Model dataset and notify the report owners of changes to the measures.
Members of the enterprise analytics team report that creating Power Bl reports and adjusting tables and views in Azure Synapse is tedious because they must switch between the Power Bl workspaces and the Azure Synapse workspaces.
The information security team identifies that the user experience data is being shared externally.
Fabrikam plans to implement the following changes:
* Power Bl will be registered as a data source in Microsoft Purview.
* The analysts in the Product business unit will create a more automated process for deploying Power Bl reports and datasets to the User Experience workspace.
The enterprise analytics team plans to perform the following tasks:
* Update the DAX calculations in the Financial Model dataset.
* Create views in the Azure Synapse workspaces to speed up the parsing of user experience data.
* Create and document the change management process for shared Power Bl datasets.
From Microsoft Purview, analysts in all the business units must be able to see all the assets in the Power Bl tenant and the Azure Synapse workspaces. Power Bl asset information must include lineage to identify the data sources used by each report.
The information security team must identify all the Power Bl reports and datasets that contain Personally Identifiable Information (Pll).
Fabrikam requires a security solution for the Power Bl tenant. The solution must meet the following requirements:
* Access to the tenant by external users must be approved by a manager and granted by the IT group.
* The external users must be prevented from publishing or modifying content in the tenant
* Users must be prevented from sharing Power Bl reports publicly to the internet.
The new process for deploying Power Bl reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.


質問 # 95
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.

正解：

解説：


質問 # 96
You plan to 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. the workspace admins of any workspace that uses the dataset
  • B. the Power Bl admins
  • C. all the workspace members of any workspace that uses the dataset
  • D. any users that accessed a report that uses the dataset within the last 30 days

正解：C

解説：
Notify contacts
If you've made a change to a dataset or are thinking about making a change, you might want to contact the relevant users to tell them about it. When you notify contacts, an email is sent to the contact lists of all the impacted workspaces. Your name appears on the email so the contacts can find you and reply back in a new email thread.


質問 # 97
You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.
You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.
In which file format should you recommend storing the table data?

  • A. JSON
  • B. CSV
  • C. Delta
  • D. Apache Parquet

正解：D

解説：
Explanation
Prepare files for querying
If possible, you can prepare files for better performance:
* Convert large CSV and JSON files to Parquet. Parquet is a columnar format. Because it's compressed, its file sizes are smaller than CSV or JSON files that contain the same data. Serverless SQL pool skips the columns and rows that aren't needed in a query if you're reading Parquet files. Serverless SQL pool needs less time and fewer storage requests to read it.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-serverless-sql-pool
https://stackoverflow.com/questions/65320949/parquet-vs-delta-format-in-azure-data-lake-gen-2-store


質問 # 98
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. Define an incremental refresh policy.
  • D. Configure a scheduled refresh.

正解：D

解説：
You cannot schedule a refresh on 15-minute increments. Only 30, unless using XMLA endpoint.


質問 # 99
You have two Power BI reports named Report1 and Report2.
Report1 connects to a shared dataset named Dataset1.
Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.
You need to prepare Report2 to use Dataset1.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Delete all the Power Query Editor objects.
  • B. Delete all the calculated tables.
  • C. Modify the source of each query.
  • D. Update all the parameter values.
  • E. Remove the data source permissions.

正解：C、D

解説：
Explanation
C: Power BI Desktop also comes with Power Query Editor. Use Power Query Editor to connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.
D: Common uses for parameters
Here are some of the most common ways to use parameters.
Control paginated report data
* Filter paginated report data at the data source by writing dataset queries that contain variables.
* Etc.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview
https://docs.microsoft.com/en-us/learn/modules/dax-power-bi-add-calculated-tables/1-introduction


質問 # 100
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 the alternative result of blank( ) from the divide function.
  • B. Remove "calendar'[Flag] = "YTD" from the code.
  • C. Create a variable and replace the values for [sales Amount].
  • D. Replace both calculate functions by using a variable that contains the calculate function.

正解：D


質問 # 101
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation
Box 1: the unified audit log in Microsoft 365
Security admins must identify when users export reports from Power BI within five days of a new sensitivity label being applied to the artifacts in Power BI.
Use the audit log
If your task is to track user activities across Power BI and Microsoft 365, you work with auditing in Microsoft
365 compliance or use PowerShell. Auditing relies on functionality in Exchange Online, which automatically supports Power BI.
You can filter the audit data by date range, user, dashboard, report, dataset, and activity type. You can also download the activities in a csv (comma-separated value) file to analyze offline.
Box 2: Power BI activity log
Power BI admins must identify updates or changes to the Power BI capacity.
Use the activity log
Power BI administrators can analyze usage for all Power BI resources at the tenant level by using custom reports that are based on the Power BI activity log.
Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing


質問 # 102
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?

  • A. Grant the sales managers admin access to the existing Power Bl workspace.
  • B. Create a PBIT file and distribute the file to the sales managers.
  • C. Create a deployment pipeline and grant the sales managers access to the pipeline.
  • D. Grant the sales managers the Build permission for the existing Power Bl datasets.

正解：B

解説：
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.


質問 # 103
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


質問 # 104
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.

正解：

解説：

1 - From powerbi.com, create a new report..
2 - Add a report measure
3 - Add visuals to the report
4 - Publish the report to the Sales Analytics workspace


質問 # 105
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.

A sample of the data in the Commission table is shown in the following table.

You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation
Box 1: Join
Box 2: LeftOuter
Left outer join
One of the join kinds available in the Merge dialog box in Power Query is a left outer join, which keeps all the rows from the left table and brings in any matching rows from the right table.
Diagram, table Description automatically generated

Reference: https://docs.microsoft.com/en-us/power-query/merge-queries-left-outer


質問 # 106
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. No
  • B. Yes

正解：A

解説：
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.


質問 # 107
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


質問 # 108
You deploy a tabular model to the Power Bl service. The model is developed and maintained by using Microsoft Visual Studio. Power Bl connects to the model by using the Connect live option.
You need to recommend a source control solution for the model and the report files.
What should you include in the recommendation for each type of file? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：


質問 # 109
You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.
During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB." You need to ensure that you can refresh the dataset.
What should you do?

  • A. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
  • B. Change License mode to Premium per user.
  • C. Change the location of the Premium capacity.
  • D. Turn on Large dataset storage format.

正解：C

解説：
Explanation
Assigning workspaces to capacities
Workspaces can be assigned to a Premium capacity in the Power BI Admin portal or, for a workspace, in the Workspace pane.
Note: Capacity limits
Workspace storage limits, whether for My Workspace or an app workspace, depend on whether the workspace is in shared or Premium capacity.
* Shared capacity limits
For workspaces in shared capacity:
There is a per-workspace storage limit of 10 GB.
Premium Per User (PPU) tenants have a 100 TB storage limit.
When using a Pro license, the total usage can't exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.
* Premium capacity limits
For workspaces in Premium capacity:
There is a limit of 100 TB per Premium capacity.
There is no per-user storage limit.
Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.
Incorrect:
Not C: If your organization is using the original version of Power BI Premium, you're required to migrate to the modern Premium Gen2 platform. Microsoft began migrating all Premium capacities to Gen2.
Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-capacity-manage-gen2
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi


質問 # 110
The enterprise analytics team needs to resolve the DAX measure performance issues.
What should the team do first?

  • A. Use Tabular Editor to create calculation groups.
  • B. Use DAX Studio to review the Vertipaq Analyzer metrics.
  • C. Use DAX Studio to get detailed statistics on the server timings.
  • D. Use Performance analyzer in Power Bl Desktop to get the DAX durations.

正解：D


質問 # 111
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.

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-buffer


質問 # 112
You have a Power Bl report hosted on the Power Bl service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month. You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

  • A. Create a separate report page for users to view a column chart.
  • B. Enable report readers to personalize visuals.
  • C. Add a column chart, a bookmark, and a button for users to choose a visual.
  • D. Create a mobile report that contains a column chad.

正解：C


質問 # 113
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


質問 # 114
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


質問 # 115
......

最新（2024)Microsoft DP-500試験問題集：https://www.passtest.jp/Microsoft/DP-500-shiken.html

最適な練習法にはMicrosoft DP-500試験の素晴らしいDP-500試験問題PDF：https://drive.google.com/open?id=1KXBvPJErExD2y1knOCf4lukCCcp1vjPj

関するブログ

もっと
DP-500 無料問題集