• ホーム
  • ブログ
  • DP-500試験問題集を試そう！ベストDP-500試験問題トレーニングを提供しています [Q59-Q83]

DP-500試験問題集を試そう！ベストDP-500試験問題トレーニングを提供しています [Q59-Q83]

Share

DP-500試験問題集を試そう！ベストDP-500試験問題トレーニングを提供しています

実践サンプルと問題集指導には2023年最新のDP-500有効なテスト問題集


DP-500試験に合格することは、エンタープライズスケール分析ソリューションの専門知識を実証するための優れた方法であり、業界の他の専門家から際立っています。この認定を取得することにより、潜在的な雇用主やクライアントにスキルを紹介し、データエンジニアリングとビジネスインテリジェンスの分野で高賃金の仕事を獲得する可能性を高めることができます。データ駆動型の洞察と分析ソリューションに対する需要の増加に伴い、DP-500試験はあなたのキャリアへの貴重な投資です。


Microsoft DP-500認定試験に合格するには、データ処理、データストレージ、データの視覚化などの重要な概念に関する知識を実証する必要があります。また、Microsoft AzureとPower BIを使用して、データソリューションを設計、実装、および管理する能力を示す必要があります。この試験では、Azure Data Factory、Azure Databricks、Azure Stream Analytics、Power BI Desktopなど、幅広いトピックについて説明しています。この試験に合格することにより、雇用主にデータ駆動型の決定を下すために必要なスキルと知識があることを実証できます。

 

質問 # 59
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo. Dim Product. You need to write a query to meet the following requirements:
* Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties.
* Specify the quartile in which each product's list price falls within each product category.
How should you complete the query? To answer, select the appropriate options in the answer area.

正解：

解説：

Explanation


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


質問 # 61
You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.

You plan to create a security role named User Security for the dataset. You need to filter the dataset based on the current users. What should you include in the DAX expression?

  • A. [User] = USERNAME()
  • B. [UserPermissions] - USERNAME()
  • C. [User] = USERPRINCIPALNAME()
  • D. [User] = USEROBJECTID()
  • E. [UserPermissions] - USERPRINCIPALNAME()

正解：A

解説：
USERNAME() returns the domain name and username from the credentials given to the system at connection time.
It should be compared to column name of User, which in DAX is expressed through [User].


質問 # 62
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. CONVERT
  • B. FOR.JSON
  • C. JS0N_VALUE
  • D. FIRST VALUE

正解：C


質問 # 63
You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account.
You need to query all the files in the 'csv/taxi/' folder and all its subfolders. All the files are in CSV format and have a header row.
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: BULK 'csv/taxi*.CSV',
*.CSV to get all the CSV files.
Box 2: FIRSTROW=2
As there is a header we should read from the second line.
Note: FIRSTROW = 'first_row'
Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.
Incorrect:
Not FIRSTROW=1. FIRSTROW=1 is used when there is no header.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset


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


質問 # 65
You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
* Returns the fiscal prior year-to-date value for [sales Amount]
* Uses a fiscal year end of June 30
* Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

Explanation

Box 1: CALCULATETABLE
CALCULATETABLE evaluates a table expression in a modified filter context.
Syntax: CALCULATETABLE(<expression>[, <filter1> [, <filter2> [, ...]]]) Incorrect:
* SUMMARIZECOLUMNS
SUMMARIZECOLUMNS returns a summary table over a set of groups.
Syntax: SUMMARIZECOLUMNS( <groupBy_columnName> [, < groupBy_columnName >]...,
[<filterTable>]...[, <name>, <expression>]...)
* CROSSJOIN returns a table that contains the Cartesian product of all rows from all tables in the arguments.
The columns in the new table are all the columns in all the argument tables.
Syntax: CROSSJOIN(<table>, <table>[, <table>]...)
* UNION creates a union (join) table from a pair of tables.
Syntax: UNION(<table_expression1>, <table_expression2> [,<table_expression>]...) Box 2: SAMEPERIODLASTYEAR SAMEPERIODLASTYEAR returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
Syntax: SAMEPERIODLASTYEAR(<dates>)
The dates returned are the same as the dates returned by this equivalent formula: DATEADD(dates, -1, year) Example:
The following sample formula creates a measure that calculates the previous year sales of Reseller sales.
= CALCULATE(SUM(ResellerSales_USD[SalesAmount_USD]),
SAMEPERIODLASTYEAR(DateTime[DateKey))
Box 3: TODAY()
TODAY() returns the current date.
The TODAY function is useful when you need to have the current date displayed on a worksheet, regardless of when you open the workbook. It is also useful for calculating intervals.
Example:
The following sample formula creates a measure that calculates the 'Running Total' for Internet sales.
= CALCULATE(SUM(InternetSales_USD[SalesAmount_USD]), DATESYTD(DateTime[DateKey])) Reference: https://docs.microsoft.com/en-us/dax/calculatetable-function-dax
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
https://docs.microsoft.com/en-us/dax/datesytd-function-dax


質問 # 66
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[RowlD]
  • B. Sales[Sales Amount]
  • C. Plan[RowlD]
  • D. Sales[Sales ID]

正解：D

解説：
Explanation
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.
Reference: https://blog.enterprisedna.co/vertipaq-analyzer-tutorial-relationships-referential-integrity/


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


質問 # 68
You have a Power BI tenant.
You plan to register the tenant in an Azure Purview account.
You need to ensure that you can scan the tenant by using Azure Purview.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. From the Microsoft 365 admin center, create a Microsoft 365 group.
  • B. From the Power Bl Admin center, set Share content with external users to Enabled.
  • C. From the Azure Active Directory admin center, create a security group.
  • D. From the Power Bl Admin center, set Allow service principals to use read-only Power Bl admin APIs to Enabled.
  • E. From the Power Bl Admin center, set Allow live connections to Enabled.

正解：B、D

解説：
Explanation
Scan same-tenant Power BI using Azure IR and Managed Identity in public network.
Make sure Power BI and Microsoft Purview accounts are in the same tenant.
Make sure Power BI tenant Id is entered correctly during the registration.
From Azure portal, validate if Microsoft Purview account Network is set to public access.
From Power BI tenant Admin Portal, make sure Power BI tenant is configured to allow public network.
(D) In Azure Active Directory tenant, create a security group.
From Azure Active Directory tenant, make sure Microsoft Purview account MSI is member of the new security group.
On the Power BI Tenant Admin portal, validate if Allow service principals to use read-only Power BI admin APIs is enabled for the new security group.
Associate the security group with Power BI tenant
Log into the Power BI admin portal.
Select the Tenant settings page.
(C) Select Admin API settings > Allow service principals to use read-only Power BI admin APIs (Preview).
Select Specific security groups.
Select Admin API settings > Enhance admin APIs responses with detailed metadata > Enable the toggle to allow Microsoft Purview Data Map automatically discover the detailed metadata of Power BI datasets as part of its scans.
Reference: https://docs.microsoft.com/en-us/azure/purview/register-scan-power-bi-tenant


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


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

正解：

解説：


質問 # 71
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 normalizing the data model.
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/


質問 # 72
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 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 admin access to the existing Power Bl workspace.

正解：B

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


質問 # 73
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power Bi service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.
When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?

  • A. From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.
  • B. In the dataset, delete the fact table.
  • C. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
  • D. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.

正解：C

解説：
Explanation
Previously in Power BI Desktop, when you used a DirectQuery in a report, no other data connections, whether DirectQuery or import, were allowed for that report. With composite models, that restriction is removed. A report can seamlessly include data connections from more than one DirectQuery or import data connection, in any combination you choose.
The composite models capability in Power BI Desktop consists of three related features:
* Composite models: Allows a report to have two or more data connections from different source groups, such as one or more DirectQuery connections and an import connection, two or more DirectQuery connections, or any combination thereof.
* Etc.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models


質問 # 74
You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries. Which Python libraries should you use?

  • A. Matplotlib only
  • B. Matplotlib and Seaborn
  • C. Matplotlib and TensorFlow
  • D. TensorFlow only
  • E. Seaborn only
  • F. Seaborn and TensorFlow

正解：B

解説：
Matplotlib
You can render standard plotting libraries, like Matplotlib, using the built-in rendering functions for each library.
Matplotlib is a plotting library for the Python programming language and its numerical mathematics extension NumPy.
Additional libraries
Beyond these libraries, the Azure Synapse Analytics Runtime also includes the following set of libraries that are often used for data visualization:
Seaborn
Seaborn is a Python data visualization library based on matplotlib. It provides a high-level interface for drawing attractive and informative statistical graphics.
Reference:
https://seaborn.pydata.org/


質問 # 75
You have a Power Bl tenant that contains 10 workspaces.
You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can
access the resulting data by using Azure Data Factory.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point

  • A. Associate the Power Bl tenant to an Azure Data Lake Storage account.
  • B. Create and save the dataflows to the internal storage of Power BL
  • C. Add the managed identity for Data Factory as a member of the workspaces.
  • D. Create and save the dataflows to an Azure Data Lake Storage account.

正解：A、C


質問 # 76
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. Create a data share connection.
  • B. Register a data source.
  • C. Search the data catalog.
  • D. Create a data policy.

正解：C


質問 # 77
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and Forecast.
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 Power BI Desktop, create a role named Project Managers.
2 - Open Tabular Editor
3 - From Power BI Desktop, add a DAX filter to the Project Managers role.
4 - For Table1, the Budget and Forecast columns, set the permissions to None.


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

正解：

解説：

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces


質問 # 79
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. OPEMDATASOURCE
  • B. OPCNROWSET
  • C. STRIMO_SPLIT
  • D. OPENOUERY

正解：B


質問 # 80
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. Azure Purview
  • B. an XMLA endpoint
  • C. Site-to-Site VPN
  • D. the on-premises data gateway

正解：D


質問 # 81
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. Define an incremental refresh policy.
  • B. Enable the XMLA endpoint.
  • C. Change the storage mode of the dataset.
  • D. Configure a scheduled refresh.

正解：D

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


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

正解：

解説：


質問 # 83
......


Microsoft DP-500認定試験は、Microsoft AzureおよびMicrosoft Power BIを使用するプロフェッショナルにとって、世界的に認知された主要な認定試験として認識されています。この認定試験は、Microsoftのクラウドベースのプラットフォームを使用して大規模なデータソリューションを設計、実装、および維持するための最新技術とベストプラクティスに対する候補者の深い理解を証明します。

 

最新100%合格率保証付きの素晴らしいDP-500試験問題PDF：https://www.goshiken.com/Microsoft/DP-500-mondaishu.html

DP-500有効な認定試験問題集解答学習ガイド：https://drive.google.com/open?id=1F7YMbR2CRat0q8p9ibY7tX9J6-F8I6Ip

関するブログ

もっと
DP-500無料問題集