2024年最新のDP-500問題集レビュー専門クイズ学習材料
DP-500テスト準備トレーニング練習試験問題 練習テスト
質問 # 13
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. [User] = USEROBJECTID()
- B. [User] = USERNAME()
- C. [User] = USERPRINCIPALNAME()
- D. [UserPermissions] - USERPRINCIPALNAME()
- E. [UserPermissions] - USERNAME()
正解：B
解説：
Explanation
USERNAME() returns the domain name and username from the credentials given to the system at connection time.
It should be compared to column name of User, which in DAX is expressed through [User].
Reference: https://docs.microsoft.com/en-us/dax/username-function-dax
質問 # 14
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo. Dim Product. You need to write a query to meet the following requirements:
* Return the ranked position of each product ordered by list price descending within each product category, allowing gaps in the ranking values after ties.
* Specify the quartile in which each product's list price falls within each product category.
How should you complete the query? To answer, select the appropriate options in the answer area.
正解：
解説：
Explanation
質問 # 15
You have a shared dataset in Power Bl named Dataset1.
You have an on-premises Microsoft SQL Server database named DB1.
You need to ensure that Dataset1 refreshes data from DB1.
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.
正解：
解説：
Explanation
Step 1: Install the on-premises data gateway (standard mode)
The personal mode is only for a single user, not to be used for a shared dataset.
Step 2: From powerbi.com, add a data source to the gateway clusters
After you install the on-premises data gateway, you can add data sources that can be used with the gateway.
Add a data source
Under Data Source Type, select SQL Server.
After you fill in everything, select Create. You can now use this data source for scheduled refresh or DirectQuery against a SQL Server that's on-premises. You see Created New data source if it succeeded.
Step 3: From powerbi.com, configure Dataset1 to use a data gateway.
Connect a dataset to a SQL Server database
In Power BI Desktop, you connected directly to your on-premises SQL Server database, but the Power BI service requires a data gateway to act as a bridge between the cloud and your on-premises network. Follow these steps to add your on-premises SQL Server database as a data source to a gateway and then connect your dataset to this data source.
* Sign in to Power BI. In the upper-right corner, select the settings gear icon and then select Settings.
* On the Datasets tab, select the dataset AdventureWorksProducts, so you can connect to your on-premises SQL Server database through a data gateway.
* Expand Gateway connection and verify that at least one gateway is listed.
* Under Actions, expand the toggle button to view the data sources and select the Add to gateway link.
* On the Gateways management page, on the Data Source Settings tab, enter and verify the following information, and select Add.
* On the Datasets tab, expand the Gateway connection section again. Select the data gateway you configured, which shows a Status of running on the machine where you installed it, and select Apply.
Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql
質問 # 16
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. an All Queries trace
- C. a Query Plan trace
- D. the DMV list
正解：B
解説：
Explanation
The All Queries trace in Dax Studio supports capturing the query events from all client tools (not just queries sent from DAX Studio like the Query Plan and Server Timings features do). The 'All Queries" trace is really useful when you wish to see the queries that are generated by a client tool like Power BI Desktop.
Reference: https://daxstudio.org/documentation/features/all-queries-trace/
質問 # 17
You discover a poorly performing measure in a Power Bl data model.
You need to review the query plan to analyze the amount of time spent in the storage engine and the formula engine.
What should you use?
- A. Vertipaq Analyzer
- B. Performance analyzer in Power Bl Desktop
- C. DAX Studio
- D. Tabular Editor
正解：B
解説：
Explanation
Monitor report performance in Power BI Desktop using the Performance Analyzer. Monitoring will help you learn where the bottlenecks are, and how you can improve report performance.
Monitoring performance is relevant in the following situations:
Your Import data model refresh is slow.
Your DirectQuery or Live Connection reports are slow.
Your model calculations are slow.
Slow queries or report visuals should be a focal point of continued optimization.
Reference: https://docs.microsoft.com/en-us/power-bi/guidance/monitor-report-performance
Topic 2, 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.
質問 # 18
You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power Bi service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.
When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?
- A. From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.
- B. Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
- C. In the dataset, delete the fact table.
- D. Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
正解：D
解説：
Previously in Power BI Desktop, when you used a DirectQuery in a report, no other data connections, whether DirectQuery or import, were allowed for that report. With composite models, that restriction is removed. A report can seamlessly include data connections from more than one DirectQuery or import data connection, in any combination you choose.
The composite models capability in Power BI Desktop consists of three related features:
* Composite models: Allows a report to have two or more data connections from different source groups, such as one or more DirectQuery connections and an import connection, two or more DirectQuery connections, or any combination thereof.
* Etc.
質問 # 19
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.
正解：
解説：
Explanation
質問 # 20
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
正解：
解説：
Explanation
Box 1: Yes
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
Box 2: No
Table.SelectRows returns a table of rows from the table, that matches the selection condition.
Box 3: Yes
Azure Data Lake Storage has higher throughput and IOPS.
Note: Azure Blob Storage is a general purpose, scalable object store that is designed for a wide variety of storage scenarios. Azure Data Lake Storage is a hyper-scale repository that is optimized for big data analytics workloads.
Azure Data Lake Storage use Cases: Batch, interactive, streaming analytics and machine learning data such as log files, IoT data, click streams, large datasets Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
https://docs.microsoft.com/en-us/powerquery-m/table-selectrows
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-comparison-with-blob-storage
質問 # 21
You manage a dataset that contains the two data sources as shown in the following table.
When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together.
Please rebuild this data combination."
You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.
You need to resolve the error. The solution must provide the highest privacy possible.
Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation
Box 1: Private
This Formula.Firewall error is the result of Power Query's Data Privacy Firewall (aka the Firewall) Note: Folding is a term that refers to converting expressions in M (such as filters, renames, joins, and so on) into operations against a raw data source (such as SQL, OData, and so on).
Box 2: Organizational
Organizational Limits the visibility of a data source to a trusted group of people. It is isolated from all Public data sources, but is visible to other Organizational data sources. A common example is a Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.
Reference:
https://support.microsoft.com/en-us/office/set-privacy-levels-power-query-cc3ede4d-359e-4b28-bc72-9bee7900b
質問 # 22
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry dat a. 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
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-selectrows
https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-comparison-with-blob-storage
質問 # 23
You deploy a tabular model to the Power Bl service. The model is developed and maintained by using Microsoft Visual Studio. Power Bl connects to the model by using the Connect live option.
You need to recommend a source control solution for the model and the report files.
What should you include in the recommendation for each type of file? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
質問 # 24
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. Yes
- B. No
正解：B
解説：
Explanation
Instead use Solution: You recommend using OPENROWSET WITH to explicitly define the collation for businessName and surveyName as Latin1_General_100_BIN2_UTF8.
Query Parquet files using serverless SQL pool in Azure Synapse Analytics.
Important
Ensure you are using a UTF-8 database collation (for example Latin1_General_100_BIN2_UTF8) because string values in PARQUET files are encoded using UTF-8 encoding. A mismatch between the text encoding in the PARQUET file and the collation may cause unexpected conversion errors. You can easily change the default collation of the current database using the following T-SQL statement: alter database current collate Latin1_General_100_BIN2_UTF8'.
Note: If you use the Latin1_General_100_BIN2_UTF8 collation you will get an additional performance boost compared to the other collations. The Latin1_General_100_BIN2_UTF8 collation is compatible with parquet string sorting rules. The SQL pool is able to eliminate some parts of the parquet files that will not contain data needed in the queries (file/column-segment pruning). If you use other collations, all data from the parquet files will be loaded into Synapse SQL and the filtering is happening within the SQL process. The Latin1_General_100_BIN2_UTF8 collation has additional performance optimization that works only for parquet and CosmosDB. The downside is that you lose fine-grained comparison rules like case insensitivity.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/query-parquet-files
質問 # 25
You plan to 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 Power Bl admins
- B. all the workspace members of any workspace that uses the dataset
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the workspace admins of any workspace that uses the dataset
正解：B
解説：
Explanation
Notify contacts
If you've made a change to a dataset or are thinking about making a change, you might want to contact the relevant users to tell them about it. When you notify contacts, an email is sent to the contact lists of all the impacted workspaces. Your name appears on the email so the contacts can find you and reply back in a new email thread.
Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-dataset-impact-analysis
質問 # 26
You have a Power Bl report that contains the table shown in the following exhibit.
The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?
- A. Move the conditional formatting icons to a tooltip report.
- B. Remove the icons and use red, yellow, and green background colors instead.
- C. Add alt text to explain the information that each color conveys.
- D. Change the icons to use a different shape for each color.
正解：C
解説：
Explanation
Report accessibility checklist, All Visuals.
* Ensure alt text is added to all non-decorative visuals on the page.
* Avoid using color as the only means of conveying information. Use text or icons to supplement or replace the color.
* Check that your report page works for users with color vision deficiency.
* Etc.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports
質問 # 27
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/
質問 # 28
You have a Power BI workspace named Workspace1 that contains five dataflows.
You need to configure Workspace1 to store the dataflows in an Azure Data Lake Storage Gen2 account.
What should you do first?
- A. Disable load for all dataflow queries.
- B. From the Power Bl Admin portal, enable tenant-level storage.
- C. Delete the dataflow queries.
- D. Change the Data source settings in the dataflow queries.
正解：B
解説：
Configuring Azure connections is an optional setting with additional properties that can optionally be set:
* Tenant Level storage, which lets you set a default, and/or
* Workspace-level storage, which lets you specify the connection per workspace You can optionally configure tenant-level storage if you want to use a centralized data lake only, or want this to be the default option.
質問 # 29
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.
正解：
解説：
質問 # 30
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 Power Bl admins
- B. all the workspace members of any workspace that uses the dataset
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the workspace admins of any workspace that uses the dataset
正解：B
解説：
Notify contacts
If you've made a change to a dataset or are thinking about making a change, you might want to contact the relevant users to tell them about it. When you notify contacts, an email is sent to the contact lists of all the impacted workspaces. Your name appears on the email so the contacts can find you and reply back in a new email thread.
質問 # 31
......
試験問題解答ブレーン問題集でDP-500試験問題集PDF問題：https://www.goshiken.com/Microsoft/DP-500-mondaishu.html
DP-500試験問題集、DP-500練習テスト問題：https://drive.google.com/open?id=1nGPyTRFykWscUs6bvfADt1tHoTZfVpf0