[email protected]
搜索
购物车
订单确认

下列DP-500练习题是Microsoft DP-500完整题库的一部分. DP-500完整练习题库共有160道题. Examook最新DP-500练习题库可以助您顺利通过考试. 如果您使用我们的题库没有效果, 我们将全额退还您的购买费用. 想要测试和学习Eaxmook DP-500练习题库? 现在开始吧!

 完整 DP-500 练习题库

Microsoft DP-500 练习题库

DP-500 w练习题库的更新日期是 2025-03-13 .

正在练习第 1页 ，共 6 页.

正在练习第 1题 ，共 32 道题

题目#1

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. pandas.DataFrame('Unit Price')
B. dataset['Unit Price']
C. data = [Unit Price]
D. ('Unit Price')

Explanation:
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
Explanation:
Reference: http://www.learningaboutelectronics.com/Articles/How-to-retrieve-a-column-from-a-pandas-dataframe-object-in-Python.php

题目#2

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 A
B. Option B
C. Option C
D. Option D

Explanation:
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/relational-databases/import-export/specify-field-and-row-terminators-sql-server
https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql

题目#3

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. Unoptimized DAX queries cause the page to load slowly.
D. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.

Explanation:
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.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

题目#4

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. Query Diagnostics in Power Query Editor
C. Performance analyzer in Power Bl Desktop

Explanation:
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.
Reference: https://docs.microsoft.com/en-us/power-query/querydiagnostics

题目#5

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual.
What should you do?

A. Replace long text with abbreviations and acronyms.
B. Configure a unique marker for each series.
C. Configure a distinct color for each series.
D. Move important information to a tooltip.

Explanation:
Themes, contrast and colorblind-friendly colors.
You should ensure that your reports have enough contrast between text and any background colors.
Certain color combinations are particularly difficult for users with color vision deficiencies to distinguish.
These include the following combinations:
green and red
green and brown
blue and purple
green and blue
light green and yellow
blue and grey
green and grey
green and black
Avoid using these colors together in a chart, or on the same report page.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports

考题代码: DP-500考题数: 160 道题更新时间:  2025-03-13

 完整 DP-500 练习题库
 关于 DP-500 考试

热门考试

Shop Categories