2023年最新の100%無料DP-500日常練習試験には150問があります [Q40-Q58]

2023年最新の100%無料DP-500日常練習試験には150問があります

DP-500試験資料Microsoft学習ガイド

Microsoft DP-500認定試験は、Microsoft AzureおよびMicrosoft Power BIを使用して企業規模のアナリティクスソリューションを設計および実装するスキルを検証するために設計されたプロフェッショナル向けの試験です。データの指数関数的な増加に伴い、企業はアナリティクスソリューションに頼って洞察を得て、情報に基づいた意思決定を行っています。DP-500試験は、候補者がこれらのソリューションを設計および実装する能力を検証し、役割で優れたスキルを持っていることを保証します。

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

質問 # 40
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 Power Bl Desktop, you create a hierarchy.
Does this meet the goal?

A. Yes
B. No

正解：B

解説：
Instead use the 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.
Note: A hierarchy is an ordered set of values that are linked to the level above. An example of a hierarchy could be Country, State, and City. Cities are in a State, and States make up a Country. In Power BI visuals can handle hierarchy data and provide controls for the user to navigate up and down the hierarchy.
Reference:
https://powerbi.tips/2018/09/how-to-navigate-hierarchies/

質問 # 41
You have a file named File1.txt that has the following characteristics:
* A header row
* Tab delimited values
* UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?

A. Option C
B. Option B
C. Option A
D. Option D

正解：C

解説：
Use FIELDTERMINATOR ='\t' for tab.
Use ROWTERMINATOR ='\0x0A ' for UNIX-style line endings
Use FIRSTROW= 2 for a header row
Note: Using Row Terminators
The row terminator can be the same character as the terminator for the last field. Generally, however, a distinct row terminator is useful. For example, to produce tabular output, terminate the last field in each row with the newline character (\n) and all other fields with the tab character (\t).
If you want to output a line feed character only (LF) as the row terminator - as is typical on Unix and Linux computers - use hexadecimal notation to specify the LF row terminator. For example:
bcp -r '0x0A'
FIRSTROW
FIRSTROW =first_row Specifies the number of the first row to load. The default is 1. This indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql

質問 # 42
Note: This question is part of a scries 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 creating a perspective that contains the commonly used fields.
Does this meet the goal?

A. Yes
B. No

正解：B

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

質問 # 43
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 Billable Hrs YTD visual displays the most data.
B. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
C. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
D. Unoptimized DAX queries cause the page to load slowly.

正解：B

質問 # 44
You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

A. the server timings
B. the query history
C. the query plan
D. the query statistics

正解：C

解説：
Open DAX Studio.
Paste the query there, enable Query Plan display and Server Timings, run your query (with clear cache), and then study the query plan for large row counts. Once the culprit is identified you can decide how to rewrite your DAX to make that part faster.
Reference:
https://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf

質問 # 45
You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace. What should you do?

A. From the Corporate Data Models and User Experience workspace, set License mode to Premium per user
B. From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.
C. From the Developer settings, set Allow service principals to use Power Bl APIs to Enable.
D. From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.

正解：A

質問 # 46
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 X position
B. the tab order
C. the bookmark order
D. the layer order

正解：A

質問 # 47
You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?

A. an Apache Spark pool
B. a serverless SQL pool
C. a Data Explorer pool
D. a dedicated SQL pool

正解：A

解説：
In Azure Synapse, training machine learning models can be performed on the Apache Spark Pools with tools like PySpark/Python, Scala, or .NET.

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

正解：B

質問 # 49
You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to
score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?

A. PIVOT
B. GROUPING
C. CAST
D. PREDICT

正解：A

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

質問 # 51
You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics.
You need to present the data distribution statistics from a DataFrame in a tabular view.
Which method should you invoke on the DataFrame?

A. freqlcems
B. corr
C. rollup
D. summary

正解：B

解説：
pandas.DataFrame.corr computes pairwise correlation of columns, excluding NA/null values.
Incorrect:
* freqItems
pyspark.sql.DataFrame.freqItems
Finding frequent items for columns, possibly with false positives. Using the frequent element count algorithm described in https://doi.org/10.1145/762471.762473, proposed by Karp, Schenker, and Papadimitriou.'
* summary is used for index.
* There is no panda method for rollup. Rollup would not be correct anyway.

質問 # 52
You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?

A. a pie chart
B. an area chart
C. a stacked bar chart
D. a bar chart

正解：B

解説：
The matplotlib.pyplot.fill_between function fills the area between two horizontal curves.
The curves are defined by the points (x, y1) and (x, y2). This creates one or multiple polygons describing the filled area.

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

正解：A

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

正解：B

質問 # 55
You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?

A. Some query steps are folding.
B. Elevated permissions are being used to query records.
C. The query is timing out.
D. All the query steps are folding.

正解：D

解説：
Understanding folding with Query Diagnostics
One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were 'pushed down' by Power Query to be performed by the back-end data source, which is also known as 'folding'. If we want to see what folded, we can look at what is the 'most specific' query, or queries, that get sent to the back-end data source. We can look at this for both ODATA and SQL.

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

正解：B

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