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

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

Add to Whishlist

List of questions

Question 61

Report Export Collapse

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?

Yes
Yes
No
No
Suggested answer: A
Explanation:

A grouping is a set of discrete values that are used to group measure fields.

Reference: https://docs.microsoft.com/en-us/power-bi/developer/visuals/capabilities

asked 02/10/2024
Mary Andreou
50 questions

Question 62

Report Export Collapse

You open a Power Bl Desktop report that contains an imported data model and a single report page.

You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces the results shown in the following exhibit

Microsoft DP-500 image Question 36 90313 10022024015932000000

What can you identify from the results?

The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
The Actual/Forecast Billable Hrs YTD visual displays the most data.
The Actual/Forecast Billable Hrs YTD visual displays the most data.
Unoptimized DAX queries cause the page to load slowly.
Unoptimized DAX queries cause the page to load slowly.
When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
Suggested answer: D
Explanation:

Most time is spent in the category Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing. Note: Each visual's log information includes the time spent (duration) to complete the following categories of tasks:

DAX query - if a DAX query was required, this is the time between the visual sending the query, and for Analysis Services to return the results.

Visual display - time required for the visual to draw on the screen, including time required to retrieve any web images or geocoding.

Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performanceanalyzer

asked 02/10/2024
Mr Fraser Watson
39 questions

Question 63

Report Export Collapse

You have a Power Bl dataset that contains the following measure.

Microsoft DP-500 image Question 37 90314 10022024015932000000

You need to improve the performance of the measure without affecting the logic or the results. What should you do?

Replace both calculate functions by using a variable that contains the calculate function.
Replace both calculate functions by using a variable that contains the calculate function.
Remove the alternative result of blank( ) from the divide function.
Remove the alternative result of blank( ) from the divide function.
Create a variable and replace the values for [sales Amount].
Create a variable and replace the values for [sales Amount].
Remove "calendar'[Flag] = "YTD" from the code.
Remove "calendar'[Flag] = "YTD" from the code.
Suggested answer: A
asked 02/10/2024
han wu
50 questions

Question 64

Report Export Collapse

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?

DirectQuery for the external customers and import for the security team.
DirectQuery for the external customers and import for the security team.
DirectQuery for the external customers and DirectQuery for the security team.
DirectQuery for the external customers and DirectQuery for the security team.
Import for the external customers and DirectQuery for the security team.
Import for the external customers and DirectQuery for the security team.
Import for the external customers and import for the security team.
Import for the external customers and import for the security team.
Suggested answer: A
Explanation:

With DirectQuery, queries are sent back to your Azure Synapse Analytics in real time as you explore the data. Real-time queries, combined with the scale of Synapse Analytics enables users to create dynamic reports in minutes against terabytes of data.

Need import for the security team for local security rules.

Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-datawarehouse-with-direct-connect

asked 02/10/2024
Alex Luna
46 questions

Question 65

Report Export Collapse

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?

the DMV list
the DMV list
a Query Plan trace
a Query Plan trace
an All Queries trace
an All Queries trace
a Server Timings trace
a Server Timings trace
Suggested answer: C
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/

asked 02/10/2024
Hassene SAADI
45 questions

Question 66

Report Export Collapse

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?

Tabular Editor
Tabular Editor
Performance analyzer in Power Bl Desktop
Performance analyzer in Power Bl Desktop
Vertipaq Analyzer
Vertipaq Analyzer
DAX Studio
DAX Studio
Suggested answer: 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

asked 02/10/2024
Petros Kapouleas
51 questions

Question 67

Report Export Collapse

You are using DAX Studio to analyze a slow-running report query. You need to identify inefficient join operations in the query. What should you review?

the query statistics
the query statistics
the query plan
the query plan
the query history
the query history
the server timings
the server timings
Suggested answer: B
Explanation:

Open DAX Studio. Paste the query there, enable Query Plan display and Server Timings, run your query (with clear cache), and then study the query plan for large row counts. Once the culprit is identified you can decide how to rewrite your

DAX to make that part faster.

Reference: https://community.powerbi.com/t5/Power-Query/DAX-Query-taking-longer-time/tdp/1171961

https://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf

asked 02/10/2024
Ayanda Zwane
36 questions

Question 68

Report Export Collapse

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 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 connection must be created by a user that is assigned the Storage Blob Data Owner role.
The storage account must have hierarchical namespace enabled.
The storage account must have hierarchical namespace enabled.
Dataflows must exist already for any directly connected Power Bl workspaces.
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.
The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
Suggested answer: B, C
asked 02/10/2024
Earl Frederick
40 questions

Question 69

Report Export Collapse

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

Associate the Power Bl tenant to an Azure Data Lake Storage account.
Associate the Power Bl tenant to an Azure Data Lake Storage account.
Add the managed identity for Data Factory as a member of the workspaces.
Add the managed identity for Data Factory as a member of the workspaces.
Create and save the dataflows to an Azure Data Lake Storage account.
Create and save the dataflows to an Azure Data Lake Storage account.
Create and save the dataflows to the internal storage of Power BL
Create and save the dataflows to the internal storage of Power BL
Suggested answer: A, C
Explanation:

Data used with Power BI is stored in internal storage provided by Power BI by default. With the integration of dataflows and Azure Data Lake Storage Gen 2 (ADLS Gen2), you can store your dataflows in your organization's Azure Data Lake Storage Gen2 account. This essentially allows you to "bring your own storage" to Power BI dataflows, and establish a connection at the tenant or workspace level.

Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflowsazure-data-lake-storage-integration

asked 02/10/2024
Kohsuke Shimizu
41 questions

Question 70

Report Export Collapse

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?

any users that accessed a report that uses the dataset within the last 30 days
any users that accessed a report that uses the dataset within the last 30 days
the workspace admins of any workspace that uses the dataset
the workspace admins of any workspace that uses the dataset
the Power Bl admins
the Power Bl admins
all the workspace members of any workspace that uses the dataset
all the workspace members of any workspace that uses the dataset
Suggested answer: D
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-impactanalysis

asked 02/10/2024
Nick Wells
52 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.