Free Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Exam DP-500 Exam Practice Test

You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1. DB1 is a transactional database in the third normal form.You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality. What should you include in the recommendation?

• Create calculated columns in Dataset1.
• Remove the relationships from Dataset1.
• Normalize the tables in DB1.
• Denormalize the tables in DB1.

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.

• The storage account must be protected by using an Azure Firewall.
• The connection must be created by a user that is assigned the Storage Blob Data Owner role.
• The storage account must have hierarchical namespace enabled.
• Dataflows must exist already for any directly connected Power Bl workspaces.
• The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.

You have a Power BI Premium capacity.You need to increase the number of virtual cores associated to the capacity. Which role do you need?

• Power Bl workspace admin
• capacity admin
• Power Platform admin
• Power Bl admin

You have new security and governance protocols for Power Bl reports and datasets. The new protocols must meet the following requirements.New reports can be embedded only in locations that require authentication.Live connections are permitted only for workspaces that use Premium capacity datasets.Which three actions should you recommend performing in the Power Bl Admin portal? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• From Tenant settings, disable Allow XMLA endpoints and Analyze in Excel with on-premises datasets.
• From the Premium per user settings, set XMLA Endpoint to Off.
• From Embed Codes, delete all the codes.
• From Capacity settings, set XMLA Endpoint to Read Write.
• From Tenant settings, set Publish to web to Disable.

You are creating a Power B1 single-page report.Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.You need to ensure that the users can consume content on a report page in a logical order. What should you configure on the report page?

• the bookmark order
• the X position
• the layer order
• the tab order

The enterprise analytics team needs to resolve the DAX measure performance issues. What should the team do first?

• Use Performance analyzer in Power Bl Desktop to get the DAX durations.
• Use DAX Studio to get detailed statistics on the server timings.
• Use DAX Studio to review the Vertipaq Analyzer metrics.
• Use Tabular Editor to create calculation groups.

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?

• Register a data source.
• Search the data catalog.
• Create a data share connection.
• Create a data policy.

You deploy a tabular model named DM! to a Power Bl Premium capacity. DM1 was created as an import model.You change a fact table named Table1 into a hybrid table. What else occurred on DM1 automatically after the change?

• Dimension tables that relate to Table1 were changed to dual storage mode.
• A related aggregation table was created.
• Table1 was removed from the scheduled refresh.
• A DirectQuery partition was added to Table1.

You have a Power Bl dataset that uses DirectQuery against an Azure SQL database. Multiple reports use the dataset.A database administrator reports that too many queries are being sent from Power Bl to the database.You need to reduce the number of queries sent to the database. The solution must meet the following requirements:DirectQuery must continue to be used.Visual interactions in all the reports must remain as they are configured currently.Consumers of the reports must only be allowed to apply filters from the Filter pane. Which two settings should you select? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• Disabling cross highlighting/filtering by default
• Add a single Apply button to the filter pane to apply changes at once
• Add an Apply button to each slicer to apply changes when you're ready
• Add Apply buttons to all basic filters to apply changes when you're ready
• Ignore the Privacy Levels and potentially improve performance

You plan to generate a line chart to visualize and compare the last six months of sales data for two departments. You need to increase the accessibility of the visual. What should you do?

• Replace long text with abbreviations and acronyms.
• Configure a unique marker for each series.
• Configure a distinct color for each series.
• Move important information to a tooltip.