DP-500 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
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.Register a data source.
B.Search the data catalog.
C.Create a data share connection.
D.Create a data policy.

正解:

Question No : 2
You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes .
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A.Enable Power Bl embedded.
B.Configure the data sources to use DirectQuery.
C.Configure the data sources to use a streaming dataset
D.Select Auto page refresh.
E.Enable the XMIA endpoint.
F.Add a Microsoft Power Automate visual to the report page.

正解:

Question No : 3
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.freqltems
B.explain
C.rollup
D.summary

正解:

Question No : 4
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.Seaborn only
B.Matplotlib and Seaborn
C.Matplotlib only
D.Matplotlib and TensorFlow
E.TensorFlow only
F.Seaborn and TensorFlow

正解:

Question No : 5
You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?

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

正解:

Question No : 6
HOTSPOT
You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
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.

正解:

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

正解:

Question No : 8
You have a Power Bl report that contains one visual.
You need to provide users with the ability to change the visual type without affecting the view for other users.
What should you do?

A.From Report setting, select Personalize visuals.
B.From Tabular Editor, create a new perspective.
C.From the Bookmarks pane, select Focus mode, and then select Add.
D.From Visual options in Report settings, select Use the modern visual header with updated styling options.

正解:

Question No : 9
HOTSPOT
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.

正解:

Question No : 10
HOTSPOT
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.

正解:

Question No : 11
DRAG DROP
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.

正解:

Question No : 12
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')

正解:

Question No : 13
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.Sentiment colors
C.Divergent colors
D.First-level elements colors

正解:

Question No : 14
DRAG DROP
You have a Power Bl dataset. The dataset contains data that is updated frequently.
You need to improve the performance of the dataset by using incremental refreshes.
Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

正解:

Question No : 15
HOTSPOT
You are configuring an aggregation table as shown in the following exhibit.

The detail table is named FactSales and the aggregation table is named FactSales(Agg).
You need to aggregate SalesAmount for each store.
Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

正解:

Microsoft DP-500 問題練習