合格させるDP-500ブレーン問題集で更新されたのは認定サンプル問題
オンラインDP-500テストブレーン問題集とテストエンジン
Microsoft DP-500試験に合格するには、データモデリング、データ準備、データビジュアライゼーション、および分析展開など、いくつかの分野で熟練を示す必要があります。候補者は、Azure Data Factory、Azure Stream Analytics、およびAzure DatabricksなどのAzureサービスを使用してデータパイプラインを構築し、データを使用可能な形式に変換することができる必要があります。さらに、レポートやダッシュボードを作成するために使用されるPower Query、Power Pivot、およびPower ViewなどのPower BIの機能に精通している必要があります。
質問 # 26
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.
正解：
解説：
質問 # 27
You are implementing a reporting solution that has the following requirements:
* Reports for external customers must support 500 concurrent requests. The data for these reports is
approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to
restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?
- A. DirectQuery for the external customers and DirectQuery for the security team.
- B. DirectQuery for the external customers and import for the security team.
- C. Import for the external customers and DirectQuery for the security team.
- D. Import for the external customers and import for the security team.
正解：B
質問 # 28
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 a data source and view for the Parquet files. You recommend updating the
query to use the view.
Does this meet the goal?
- A. No
- B. Yes
正解：B
質問 # 29
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
質問 # 30
You need to save Power Bl dataflows in an Azure Storage account.
Which two prerequisites are required to support the configuration? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
- A. The storage account must be protected by using an Azure Firewall.
- B. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
- C. Dataflows must exist already for any directly connected Power Bl workspaces.
- D. The storage account must have hierarchical namespace enabled.
- E. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
正解：D、E
質問 # 31
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. [UserPermissions] - USERPRINCIPALNAME()
- B. [UserPermissions] - USERNAME()
- C. [User] = USERNAMEQ()
- D. [User] = USERPRINCIPALNAME()
- E. [User] = USEROBJECTID()
正解：C
質問 # 32
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. Elevated permissions are being used to query records.
- B. All the query steps are folding.
- C. The query is timing out.
- D. Some query steps are folding.
正解：B
解説：
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.
質問 # 33
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 specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. No
- B. Yes
正解：A
質問 # 34
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.
正解：
解説：
質問 # 35
You have a Power Bl dataset that contains the following measures:
* Budget
* Actuals
* Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only.
You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate
values to the targets. Each value 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.
正解：
解説：
質問 # 36
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. Add the managed identity for Data Factory as a member of the workspaces.
- B. Create and save the dataflows to an Azure Data Lake Storage account.
- C. Create and save the dataflows to the internal storage of Power BL
- D. Associate the Power Bl tenant to an Azure Data Lake Storage account.
正解：A、D
質問 # 37
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.
正解：
解説：
質問 # 38
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. Create a variable and replace the values for [sales Amount].
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Remove "calendar'[Flag] = "YTD" from the code.
- D. Remove the alternative result of blank( ) from the divide function.
正解：B
質問 # 39
You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.
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 - From Power BI Desktop, create a role for the sales associates.
2 - From Tabular Editor, set Object Level Security to None for the Customer[Email]...
3 - From Power BI Desktop, publish the dataset to the Sales Analytics workspace.
質問 # 40
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. No
- B. Yes
正解：A
解説：
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.
質問 # 41
You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 42
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as
shown in the following exhibit.
How should you configure the chart? To answer, select the appropriate options in the answer area. NOTE:
Each correct selection is worth one point.
正解：
解説：
質問 # 43
You are optimizing a Power Bl data model by using DAX Studio.
You need to capture the query events generated by a Power Bl Desktop report.
What should you use?
- A. a Server Timings trace
- B. a Query Plan trace
- C. an All Queries trace
- D. the DMV list
正解：A
質問 # 44
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 BI 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 denormalizing the data model.
Does this meet the goal?
- A. No
- B. Yes
正解：B
解説：
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.
質問 # 45
......
リアルMicrosoft DP-500試験問題集には正解115問題と解答があります：https://jp.fast2test.com/DP-500-premium-file.html
Microsoft DP-500認定のリアル2023年最新の模擬試験：https://drive.google.com/open?id=1njUFlD9HKIGozaydmvGQylL2CkjoU083