Practice Free DP-500 Exam Online Questions
HOTSPOT
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.
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 import for the security team.
- B . DirectQuery for the external customers and DirectQuery 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.
HOTSPOT
You have the Power BI workspaces 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.
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 . Add alt text to explain the information that each color conveys.
- B . Move the conditional formatting icons to a tooltip report.
- C . Change the icons to use a different shape for each color.
- D . Remove the icons and use red, yellow, and green background colors instead.
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 . Set Use datasets across workspaces to Enabled
- B . Publish the financial data to the web.
- C . Grant the Build permission for the financial data to each customer.
- D . Configure the FinData workspace to use a Power Bl Premium capacity.
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 . Request the authors of the deployment pipeline datasets to reduce the number of datasets republished during development.
- B . In the dataset, delete the fact table.
- C . Configure the dataset to use a composite model that has a DirectQuery connection to the fact table.
- D . From Capacity settings in the Power Bi Admin portal, reduce the Max Intermediate Row Set Count setting.
You need to provide users with a reproducible method to connect to a data source and transform the data by using an Al function.
The solution must meet the following requirement
• Minimize development effort.
• Avoid including data in the file.
Which type of file should you create?
- A . PBIDS
- B . PBIX
- C . PBIT
You have a Power Bl tenant.
You need to ensure that all reports use a consistent set of co applied to existing reports.
colors and fonts. The solution must ensure that the colors and fonts can be
What should you create?
- A . a report theme file
- B . a PBIX file
- C . a Power Bl template
HOTSPOT
You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen2 account.
You need to query all the files in the ‘csv/taxi/’ folder and all its subfolders. All the files are in CSV format and have a header row.
How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already been created. The solution must minimize development and administrative effort.
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.
