最新の2022年最新の実際に出ると確認されたDP-500問題集で100%無料DP-500試験問題集
無料提供中で2022年最新のに更新されたMicrosoft DP-500試験問題と解答
質問 38
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 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 normalizing the data model.
Does this meet the goal?
- A. No
- B. Yes
正解: B
質問 39
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly
telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry
was captured.
You have the following query in Power Query Editor.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point
正解:
解説:
質問 40
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. Define an incremental refresh policy.
- D. Configure a scheduled refresh.
正解: B
質問 41
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. Replace both calculate functions by using a variable that contains the calculate function.
- B. Create a variable and replace the values for [sales Amount].
- C. Remove "calendar'[Flag] = "YTD" from the code.
- D. Remove the alternative result of blank( ) from the divide function.
正解: A
質問 42
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 have hierarchical namespace enabled.
- 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 connection must be created by a user that is assigned the Storage Blob Data Owner role.
- E. The storage account must be protected by using an Azure Firewall.
正解: A,D
質問 43
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. data source rules
- B. parameter rules
- C. auto-binding across pipelines
- D. selective deployment
正解: D
質問 44
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.
正解:
解説:
Topic 1, Litware, Inc. Overview
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells
goods both online and at its stores located in six countries.
Azure Resources
Litware has the following Azure resources:
* An Azure Synapse Analytics workspace named synapseworkspace1
* An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
* A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool
SQLDW contains a dimensional model that contains the following table.
SQLDW contains the following additional tables.
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from
dbo.Customer [customeriD], dbo.Customer
[CustomerEmail], dbo.ProductfProductID] and dbo.Product[ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in
SQLDW up to three days after being created. The records do NOT change after three days.
Power BI
Litware has a new Power Bl tenant that contains an empty workspace named Sales Analytics.
All users have Power B1 Premium per user licenses.
IT data analysts are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company's sales analytics goals. The dataset will be
refreshed every 30 minutes.
Analytics Goals
Litware identifies the following analytics goals:
* Provide historical reporting of sales by product and channel over time.
* Allow sales managers to perform ad hoc sales reporting with minimal effort.
* Perform market basket analysis to understand which products are commonly purchased in the same
transaction.
* Identify which customers should receive promotional emails based on their likelihood of purchasing
promoted products.
Litware plans to monitor the adoption of Power Bl reports over time. The company wants custom Power Bl
usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace
each month.
Security Requirements
Litware identifies the following security requirements for the analytics environment:
* All the users in the sales department and the marketing department must be able to see Power B1 reports that
contain market basket analysis and data about which customers are likely to purchase a product.
* Customer contact data in SQLDW and the Power B1 dataset must be labeled as Sensitive. Records must be
kept of any users that use the sensitive data.
* Sales associates must be prevented from seeing the CustomerEmail column in Power B1 reports.
* Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
* SQLDW and datalake1 will act as the development environment. Once feature development is complete, all
entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
* Power Bl content must be deployed to test and production by using deployment pipelines.
* All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power Bl reports in Synapse Studio.
質問 45
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.
正解:
解説:
質問 46
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. All the query steps are folding.
- B. The query is timing out.
- C. Elevated permissions are being used to query records.
- D. Some query steps are folding.
正解: D
質問 47
You need to create Power Bl reports that will display data based on the customers' subscription level.
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.
正解:
解説:
質問 48
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. Create and save the dataflows to the internal storage of Power BL
- B. Create and save the dataflows to an Azure Data Lake Storage account.
- C. Add the managed identity for Data Factory as a member of the workspaces.
- D. Associate the Power Bl tenant to an Azure Data Lake Storage account.
正解: C,D
質問 49
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. explain
- B. summary
- C. rollup
- D. freqltems
正解: B
質問 50
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 workspace admins of any workspace that uses the dataset
- B. all the workspace members of any workspace that uses the dataset
- C. the Power Bl admins
- D. any users that accessed a report that uses the dataset within the last 30 days
正解: C
質問 51
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. First-level elements colors
- B. Divergent colors
- C. Theme colors
- D. Sentiment colors
正解: A
質問 52
You develop a solution that uses a Power Bl Premium capacity. The capacity contains a dataset that is
expected to consume 50 GB of memory.
Which two actions should you perform to ensure that you can publish the model successfully to the Power Bl
service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Invoke a refresh to load historical data based on the incremental refresh policy.
- B. Restart the capacity.
- C. Publish an initial dataset that is less than 10 GB.
- D. Publish the complete dataset.
- E. Increase the Max Offline Dataset Size setting.
正解: B,D
質問 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 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 DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?
- A. No
- B. Yes
正解: A
質問 54
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and
Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解:
解説:
質問 55
You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset is used by one
report.
You need to prevent project managers from accessing the data in two columns in Table1 named Budget and
Forecast.
Which four 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.
正解:
解説:
質問 56
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the
Microsoft SQL Server data warehouse.
What should you include in the recommendation?
- A. an XMLA endpoint
- B. the on-premises data gateway
- C. Site-to-Site VPN
- D. Azure Purview
正解: B
質問 57
You need to recommend a solution for the customer workspaces to support the planned changes.
Which two configurations should you include in the recommendation? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.
- A. Publish the financial data to the web.
- B. Set Use datasets across workspaces to Enabled
- C. Grant the Build permission for the financial data to each customer.
- D. Configure the FinData workspace to use a Power Bl Premium capacity.
正解: C
質問 58
......
Microsoft DP-500 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
DP-500問題集PDFとテストエンジン試験問題：https://jp.fast2test.com/DP-500-premium-file.html
無料提供中で最新のDP-500認定有効な試験問題集はこれ：https://drive.google.com/open?id=1njUFlD9HKIGozaydmvGQylL2CkjoU083