Quickly and Easily Pass Microsoft Exam with DP-500 real Dumps Updated on Apr-2023
Realistic DP-500 Dumps Questions To Gain Brilliant Result
The Microsoft DP-500 certification exam is designed for professionals who are interested in designing and implementing enterprise-scale analytics solutions using Microsoft Azure and Microsoft Power BI. This certification is intended for data engineers, data scientists, and other IT professionals who are looking to expand their skillset in the field of data analytics.
NEW QUESTION # 65
You have a sales report as shown in the following exhibit.
The sales report has the following characteristics:
The measures are optimized.
The dataset uses import storage mode.
Data points, hierarchies, and fields cannot be removed or filtered from the report page.
From powerbi.com, users experience slow load times when viewing the report.
You need to reduce how long it takes for the report to load without affecting the data displayed in the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Change the report theme to monochromatic.
- B. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.
- C. Replace all the filters on the Filters pane with visual slicers on the report page.
- D. Replace the single-value cards with a multi-row card.
Answer: B,D
NEW QUESTION # 66
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.
Answer:
Explanation:
1 - Install the on-premises data gateway (standard mode)
2 - From powerbi.com, add a data source to the gateway clusters
3 - From powerbi.com, configure Dataset1 to use a data gateway.
Reference:
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
NEW QUESTION # 67
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?
- A. the query plan
- B. the query statistics
- C. the server timings
- D. the query history
Answer: A
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://www.sqlbi.com/wp-content/uploads/DAX-Query-Plans.pdf
Topic 1, Contoso, Ltd
Data Infrastructure
Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines.
The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access alt the data.
Contoso has one Power Bl workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool.
Users frequently query the Synapse Analytics workspace by using Transact-SQL.
User Problems
Contoso identifies the following user issues:
* Some users indicate that the visuals in Power Bl reports are slow to render when making filter selections.
* Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.
* Users indicate that the data in Power Bl reports is stale. You discover that the refresh process of the Power Bl model occasionally times out Planned Changes Contoso plans to implement the following changes:
* Into the existing Power Bl dataset, integrate an external data source that is accessible by using the REST API.
* Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
* Provide all the customers with their own Power Bl workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
* Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
* Deploy prebuilt datasets to Power Bl to simplify the query experience of the customers.
* Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.
NEW QUESTION # 68
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. an All Queries trace
- B. the DMV list
- C. a Server Timings trace
- D. a Query Plan trace
Answer: A
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.
NEW QUESTION # 69
You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. Reduce the memory assigned to the dataflows.
- B. Execute non-foldable operations before foldable operations.
- C. Place the ingestion operations and transformation operations in separate dataflows.
- D. Execute foldable operations before non-foldable operations.
- E. Place the ingestion operations and transformation operations in a single dataflow.
Answer: C,D
Explanation:
Using the compute engine to improve performance
Take the following steps to enable workloads trigger the compute engine, and always improve performance:
For computed and linked entities in the same workspace:
Ensure you perform the operations that fold, such as merges, joins, conversion, and others.
For ingestion focus on getting the data into the storage as fast as possible, using filters only if they reduce the overall dataset size. It's best practice to keep your transformation logic separate from this step, and allow the engine to focus on the initial gathering of ingredients. Next, separate your transformation and business logic into a separate dataflow in the same workspace, using linked or computed entities; doing so allows for the engine to activate and accelerate your computations. In our analogy, it's like food preparation in the kitchen: food preparation is typically a separate and distinct step from gathering your raw ingredients, and a pre-requisite for putting the food in the oven. Similarly, your logic needs to be prepared separately before it can take advantage of the compute engine.
NEW QUESTION # 70
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
Answer: 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.
NEW QUESTION # 71
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.
Answer:
Explanation:
NEW QUESTION # 72
You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in
the following table.
Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each
pool type 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.
Answer:
Explanation:
NEW QUESTION # 73
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?
- A. explain
- B. sample
- C. freqltems
- D. describe
Answer: D
Explanation:
pandas.DataFrame.describe
Descriptive statistics include those that summarize the central tendency, dispersion and shape of a dataset's distribution, excluding NaN values.
Analyzes both numeric and object series, as well as DataFrame column sets of mixed data types. The output will vary depending on what is provided.
NEW QUESTION # 74
You have a Power Bl report that contains the visual shown in the following exhibit.
You need to make the visual more accessible to users who have color vision deficiency. What should you do?
- A. Add icons to represent the sales status of each product.
- B. Add additional measures to the table values.
- C. Change the font color of values in the Sales column to white.
- D. Change the red background color to orange.
Answer: D
NEW QUESTION # 75
You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.
Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type 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.
Answer:
Explanation:
Reference:
https://www.royalcyber.com/blog/data-services/dedicated-sql-pool-vs-serverless-sql/
NEW QUESTION # 76
You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Dataset certification is disabled for the Power Bl tenant.
- B. You have insufficient permissions.
- C. The workspace is in shared capacity.
- D. The sensitivity level for the dataset is set to Highly Confidential.
- E. Row-level security (RLS) is missing from the dataset.
Answer: A,B
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content
NEW QUESTION # 77
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. any users that accessed a report that uses the dataset within the last 30 days
- C. the workspace admins of any workspace that uses the dataset
- D. all the workspace members of any workspace that uses the dataset
Answer: A
NEW QUESTION # 78
You are building a Power Bl dataset that contains a table named Calendar. Calendar contains the following
calculated column.
pfflag = IF('Calendar'[Date] < TOOAYQ, "Past", "Future")
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following
requirements:
* Returns the fiscal prior year-to-date value for [sales Amount]
* Uses a fiscal year end of June 30
* Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 79
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.
Answer:
Explanation:
Reference:
https://matplotlib.org/stable/gallery/lines_bars_and_markers/bar_stacked.html
https://matplotlib.org/stable/api/legend_api.html
NEW QUESTION # 80
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. Elevated permissions are being used to query records.
- B. The query is timing out.
- C. All the query steps are folding.
- D. Some query steps are folding.
Answer: C
Explanation:
Understanding folding with Query Diagnostics
One of the most common reasons to use Query Diagnostics is to have a better understanding of what operations were 'pushed down' by Power Query to be performed by the back-end data source, which is also known as 'folding'. If we want to see what folded, we can look at what is the 'most specific' query, or queries, that get sent to the back-end data source. We can look at this for both ODATA and SQL.
NEW QUESTION # 81
You are building a Power Bl dataset that will use two data sources.
The dataset has a query that uses a web data source. The web data source uses anonymous authentication.
You need to ensure that the query can be used by all the other queries in the dataset.
Which privacy level should you select for the data source?
- A. Public
- B. Organizational
- C. Private
- D. None
Answer: C
NEW QUESTION # 82
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. Grant the Build permission for the financial data to each customer.
- B. Configure the FinData workspace to use a Power Bl Premium capacity.
- C. Publish the financial data to the web.
- D. Set Use datasets across workspaces to Enabled
Answer: B,D
Explanation:
Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace
NEW QUESTION # 83
You use Vertipaq Analyzer to analyze a model.
The Relationships tab contains the results 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.
Answer:
Explanation:
NEW QUESTION # 84
......
To prepare for the DP-500 certification exam, candidates should have a strong understanding of Microsoft Azure and Power BI, as well as experience working with data and analytics in a professional setting. Microsoft offers a variety of training resources and study materials to help candidates prepare for the exam, including online courses, practice exams, and study guides.
Start your DP-500 Exam Questions Preparation: https://www.pass4surequiz.com/DP-500-exam-quiz.html
A Fully Updated DP-500 Exam Dumps - PDF Questions and Testing Engine: https://drive.google.com/open?id=1HO6N9vIDXHzVki7oDDrFkx294BsSduXt