DP-500認定お試し[2023年04月06日] 最新DP-500のPDF問題集 [Q59-Q81]

DP-500認定お試し[2023年04月06日] 最新DP-500のPDF問題集

ベストMicrosoft DP-500学習ガイドと問題集でof2023年更新

Microsoft DP-500試験は、Microsoft AzureとMicrosoft Power BIを使用して企業規模の分析ソリューションを設計および実装する責任を持つ専門家の知識とスキルをテストするために設計されています。この試験は、データ分析、データモデリング、およびデータ可視化の経験がある個人、およびデータエンジニア、データアナリスト、およびビジネスインテリジェンス専門家と協力する個人を対象としています。

DP-500試験は、AzureサービスとPower BIを使用したソリューションを実装する経験を持つプロフェッショナルを対象としています。この試験は、データプロフェッショナル、データアーキテクト、ビジネスインテリジェンスプロフェッショナルを対象としており、エンタープライズスケールの分析ソリューションを設計および実装する能力を証明することを目的としています。DP-500試験に合格することで、候補者のAzureサービスとPower BIを使用した安全でスケーラブルで信頼性の高いソリューションの実装スキルが検証されます。さらに、候補者の組織のビジネス要件を満たすように設計および実装する能力が証明されます。

MicrosoftのDP-500認定試験は、Microsoft AzureやMicrosoft Power BIを使用して企業規模のアナリティクスソリューションを設計・実装する専門家の能力を証明するために設計されています。この認定は、候補者が最新のテクノロジーを活用して複雑な組織の分析ニーズを満たすスケーラブルで信頼性の高いセキュアなソリューションを設計・実装する能力を認定します。

質問 # 59
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 using openrowset with to explicitly define the collation for businessName and surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?

A. No
B. Yes

正解：B

解説：
Query Parquet files using serverless SQL pool in Azure Synapse Analytics.
Important
Ensure you are using a UTF-8 database collation (for example Latin1_General_100_BIN2_UTF8) because string values in PARQUET files are encoded using UTF-8 encoding. A mismatch between the text encoding in the PARQUET file and the collation may cause unexpected conversion errors. You can easily change the default collation of the current database using the following T-SQL statement: alter database current collate Latin1_General_100_BIN2_UTF8'.
Note: If you use the Latin1_General_100_BIN2_UTF8 collation you will get an additional performance boost compared to the other collations. The Latin1_General_100_BIN2_UTF8 collation is compatible with parquet string sorting rules. The SQL pool is able to eliminate some parts of the parquet files that will not contain data needed in the queries (file/column-segment pruning). If you use other collations, all data from the parquet files will be loaded into Synapse SQL and the filtering is happening within the SQL process. The Latin1_General_100_BIN2_UTF8 collation has additional performance optimization that works only for parquet and CosmosDB. The downside is that you lose fine-grained comparison rules like case insensitivity.

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

質問 # 61
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. In the dataset. change the fact table from an import table to a hybrid table.
B. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.
C. Turn off auto refresh when publishing the dataset changes to the Power Bl service.
D. Enable the large dataset storage format for workspace.

正解：A

解説：
Hybrid tables
Hybrid tables are tables with incremental refresh that can have both import and direct query partitions. During a clean deployment, both the refresh policy and the hybrid table partitions are copied. When deploying to a pipeline stage that already has hybrid table partitions, only the refresh policy is copied. To update the partitions, refresh the table.
Refreshes are faster - Only the most recent data that has changed needs to be refreshed.

質問 # 62
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 workspace admin
D. Power Bl admin

正解：D

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

質問 # 63
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. Add icons to represent the sales status of each product.
B. Add additional measures to the table values.
C. Change the red background color to orange.
D. Change the font color of values in the Sales column to white.

正解：C

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

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

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

正解：A

質問 # 67
You have an Azure Synapse notebook.
You need to create the visual shown in the following exhibit.

How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解：

解説：

Reference:
https://matplotlib.org/3.1.1/api/_as_gen/matplotlib.pyplot.suptitle.html#matplotlib.pyplot.suptitle

質問 # 68
You have a Power Bl report that contains the table shown in the following exhibit.

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota
for returns. You need to ensure that the table is accessible to consumers of reports who have color vision
deficiency. What should you do?

A. Remove the icons and use red, yellow, and green background colors instead.
B. Change the icons to use a different shape for each color.
C. Move the conditional formatting icons to a tooltip report.
D. Add alt text to explain the information that each color conveys.

正解：A

質問 # 69
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. First-level elements colors
D. Sentiment colors

正解：A、D

質問 # 70
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. auto-binding across pipelines
C. data source rules
D. parameter rules

正解：D

解説：
Note: Create deployment rules
When working in a deployment pipeline, different stages may have different configurations. For example, each stage can have different databases or different query parameters. The development stage might query sample data from the database, while the test and production stages query the entire database.
When you deploy content between pipeline stages, configuring deployment rules enables you to allow changes to content, while keeping some settings intact. For example, if you want a dataset in a production stage to point to a production database, you can define a rule for this. The rule is defined in the production stage, under the appropriate dataset. Once the rule is defined, content deployed from test to production, will inherit the value as defined in the deployment rule, and will always apply as long as the rule is unchanged and valid.

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

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

正解：

解説：

1 - Install the on-premises data gateway (standard mode)
2 - From powerbi.com, add a data source to the gateway clusters
3 - From powerbi.com, configure Dataset1 to use a data gateway.
Reference:
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

質問 # 73
You have a sales report as shown in the following exhibit.

The sales report has the following characteristics:
The measures are optimized.
The dataset uses import storage mode.
Data points, hierarchies, and fields cannot be removed or filtered from the report page.
From powerbi.com, users experience slow load times when viewing the report.
You need to reduce how long it takes for the report to load without affecting the data displayed in the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Change the report theme to monochromatic.
B. Replace the single-value cards with a multi-row card.
C. Replace all the filters on the Filters pane with visual slicers on the report page.
D. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.

正解：B、D

質問 # 74
You are creating a Python visual in Power Bl Desktop.
You need to retrieve the value of a column named Unit Price from a DataFrame.
How should you reference the Unit Price column in the Python code?

A. data = [Unit Price]
B. dataset['Unit Price']
C. pandas.DataFrame('Unit Price')
D. ('Unit Price')

正解：C

解説：
You can retrieve a column in a pandas DataFrame object by using the DataFrame object name, followed by the label of the column name in brackets.
So if the DataFrame object name is dataframe1 and the column we are trying to retrieve the 'X' column, then we retrieve the column using the statement, dataframe1['X'].
Here's a simple Python script that imports pandas and uses a data frame:
import pandas as pd
data = [['Alex',10],['Bob',12],['Clarke',13]]
df = pd.DataFrame(data,columns=['Name','Age'],dtype=float)
print (df)
When run, this script returns:
Name Age
0 Alex 10.0
1 Bob 12.0
2 Clarke 13.0

質問 # 75
You use Vertipaq Analyzer to analyze a model.
The Relationships tab contains the results 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.

正解：

解説：

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

正解：A

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

正解：B

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

正解：

解説：

質問 # 79
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. Remove the data source permissions.
B. Delete all the calculated tables.
C. Modify the source of each query.
D. Update all the parameter values.
E. Delete all the Power Query Editor objects.

正解：C、D

解説：
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/learn/modules/dax-power-bi-add-calculated-tables/1-introduction

質問 # 80
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. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
C. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
D. In the dataset, delete the fact table.

正解：B

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

質問 # 81
......

有効なDP-500試験最新問題で2023年最新の学習ガイド：https://www.passtest.jp/Microsoft/DP-500-shiken.html

トップクラスMicrosoft DP-500試験最先端学習ガイド！練習問題バージョン：https://drive.google.com/open?id=13zHvNlh5xgzwot7lLBSn6A4lGCZeFbTz

関するブログ

もっと

DP-500 無料問題集