ExamGecko
Login
Home / Microsoft / DP-500 / List of questions
Ask Question

Microsoft DP-500 Practice Test - Questions Answers, Page 3

Add to Whishlist

List of questions

Question 21

Report Export Collapse

DRAG DROP

You need to ensure that the new process for deploying reports and datasets to the User Experience workspace meets the technical requirements.

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.


Microsoft DP-500 image Question 21 90272 10022024015932000
Correct answer: Microsoft DP-500 image answer Question 21 90272 10022024015932000
Explanation:

Create a Power BI deployment pipeline.

Create deployment rules for the development and test stages.

Assign the workspaces to the correct stages.


asked 02/10/2024
Miguel Seron Blasco
33 questions

Question 22

Report Export Collapse

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 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 get detailed statistics on the server timings.
Use DAX Studio to review the Vertipaq Analyzer metrics.
Use DAX Studio to review the Vertipaq Analyzer metrics.
Use Tabular Editor to create calculation groups.
Use Tabular Editor to create calculation groups.
Suggested answer: A
asked 02/10/2024
gregory damon
47 questions

Question 23

Report Export Collapse

You need to optimize the workflow for the creation of reports and the adjustment of tables by the enterprise analytics team.

What should you do?

Add a tenant-level storage connection to Power Bl
Add a tenant-level storage connection to Power Bl
Create a linked service in workspace1.
Create a linked service in workspace1.
Create an integration runtime in workspace1.
Create an integration runtime in workspace1.
From the Tenant setting, enable Use global search for Power BL
From the Tenant setting, enable Use global search for Power BL
Suggested answer: B
asked 02/10/2024
DMITRY Yunov
39 questions

Question 24

Report Export Collapse

You need to meet the technical requirements for deploying reports and datasets to the User Experience workspace. What should you do?

From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.
From the Corporate Data Models and User Experience workspaces, select Allow contributors to update the app.
From the Corporate Data Models and User Experience workspace, set License mode to Premium per user
From the Corporate Data Models and User Experience workspace, set License mode to Premium per user
From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.
From the Tenant settings, set Allow specific users to turn on external data sharing to Enable.
From the Developer settings, set Allow service principals to use Power Bl APIs to Enable.
From the Developer settings, set Allow service principals to use Power Bl APIs to Enable.
Suggested answer: B
asked 02/10/2024
Andre Passos
44 questions

Question 25

Report Export Collapse

You need to recommend changes to the Power Bl tenant to meet the technical requirements for external data sharing. Which tenant setting should you recommend disabling?

Allow shareable links to grant access to everyone in your organization
Allow shareable links to grant access to everyone in your organization
Allow Azure Active Directory guest users to edit and manage content in the organization
Allow Azure Active Directory guest users to edit and manage content in the organization
Users can reassign personal workspaces
Users can reassign personal workspaces
Show Azure Active Directory guests in lists of suggested people
Show Azure Active Directory guests in lists of suggested people
Suggested answer: B
asked 02/10/2024
S Muchobor
43 questions

Question 26

Report Export Collapse

The group registers the Power Bl tenant as a data source1.

You need to ensure that all the analysts can view the assets in the Power Bl tenant The solution must meet the technical requirements for Microsoft Purview and Power BI.

What should you do?

Create a scan.
Create a scan.
Deploy a Power Bl gateway.
Deploy a Power Bl gateway.
Search the data catalog.
Search the data catalog.
Create a linked service.
Create a linked service.
Suggested answer: A
asked 02/10/2024
Vagner Nicodemo
35 questions

Question 27

Report Export Collapse

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.

Increase the Max Offline Dataset Size setting.
Increase the Max Offline Dataset Size setting.
Invoke a refresh to load historical data based on the incremental refresh policy.
Invoke a refresh to load historical data based on the incremental refresh policy.
Restart the capacity.
Restart the capacity.
Publish an initial dataset that is less than 10 GB.
Publish an initial dataset that is less than 10 GB.
Publish the complete dataset.
Publish the complete dataset.
Suggested answer: B, E
Explanation:

Enable large datasets

Steps here describe enabling large datasets for a new model published to the service. For existing datasets, only step 3 is necessary.

Create a model in Power BI Desktop. If your dataset will become larger and progressively consume more memory, be sure to configure Incremental refresh.

Publish the model as a dataset to the service.

In the service > dataset > Settings, expand Large dataset storage format, set the slider to On, and then select Apply.

Enable large dataset slider

Invoke a refresh to load historical data based on the incremental refresh policy. The first refresh could take a while to load the history. Subsequent refreshes should be faster, depending on your incremental refresh policy.

Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models

asked 02/10/2024
Yucel Cetinkaya
47 questions

Question 28

Report Export Collapse

You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains a dataset.

During a scheduled refresh, you receive the following error message: "Unable to save the changes since the new dataset size of 11,354 MB exceeds the limit of 10,240 MB." You need to ensure that you can refresh the dataset.

What should you do?

Turn on Large dataset storage format.
Turn on Large dataset storage format.
Connect Workspace1 to an Azure Data Lake Storage Gen2 account
Connect Workspace1 to an Azure Data Lake Storage Gen2 account
Change License mode to Premium per user.
Change License mode to Premium per user.
Change the location of the Premium capacity.
Change the location of the Premium capacity.
Suggested answer: D
Explanation:

Assigning workspaces to capacities

Workspaces can be assigned to a Premium capacity in the Power BI Admin portal or, for a workspace, in the Workspace pane.

Note: Capacity limits

Workspace storage limits, whether for My Workspace or an app workspace, depend on whether the workspace is in shared or Premium capacity.

* Shared capacity limits

For workspaces in shared capacity:

There is a per-workspace storage limit of 10 GB.

Premium Per User (PPU) tenants have a 100 TB storage limit.

When using a Pro license, the total usage can't exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenant.

* Premium capacity limits

For workspaces in Premium capacity:

There is a limit of 100 TB per Premium capacity.

There is no per-user storage limit.

Workspace storage usage is shown as 0 (as shown in this screenshot) if the workspace is assigned to a Premium capacity.

Incorrect:

Not C: If your organization is using the original version of Power BI Premium, you're required to migrate to the modern Premium Gen2 platform. Microsoft began migrating all Premium capacities to

Gen2.

Reference: https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-capacitymanage-gen2

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-inpower-bi

asked 02/10/2024
suhail tholakkal
34 questions

Question 29

Report Export Collapse

You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.

Microsoft DP-500 image Question 3 90280 10022024015932000000

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?

[UserPermissions] - USERNAME()
[UserPermissions] - USERNAME()
[UserPermissions] - USERPRINCIPALNAME()
[UserPermissions] - USERPRINCIPALNAME()
[User] = USERPRINCIPALNAME()
[User] = USERPRINCIPALNAME()
[User] = USERNAME()
[User] = USERNAME()
[User] = USEROBJECTID()
[User] = USEROBJECTID()
Suggested answer: D
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

asked 02/10/2024
Ivan Pavlek
45 questions

Question 30

Report Export Collapse

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
Disabling cross highlighting/filtering by default
Add a single Apply button to the filter pane to apply changes at once
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 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
Add Apply buttons to all basic filters to apply changes when you're ready
Ignore the Privacy Levels and potentially improve performance
Ignore the Privacy Levels and potentially improve performance
Suggested answer: B, C
Explanation:

Reduce queries Reduce the number of queries sent by Power BI using the Query reduction settings. For slicers, select the "Add an Apply button to each slicer to apply changes when you're ready" option. For filters, select "Add a single Apply button to the filter pane to apply changes at once (preview)."

Reference: https://maqsoftware.com/insights/power-bi-best-practices

asked 02/10/2024
Graham Munengami
37 questions
Total 162 questions
Go to page: of 17
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
DRAG DROP 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.
HOTSPOT 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
You are creating a Python visual in Power Bl Desktop. You need to retrieve the value of a column named Unit Price from a DataFrame. How should you reference the Unit Price column in the Python code?
You have an Azure Synapse Analytics serverless SQL pool. You need to catalog the serverless SQL pool by using Azure Purview. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Power Bl report that contains one visual. You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?
You have a Power Bl report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed. What should you do?
HOTSPOT You are using an Azure Synapse notebook to create a Python visual. You run the following code cell to import a dataset named Iris. A sample of the data is shown in the following table. You need to create the visual shown in the exhibit. (Click the Exhibit tab.) 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.
DRAG DROP 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.
HOTSPOT 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.