Azure Enterprise Data Analyst Associate Certified Official Practice Test DP-500 - Oct-2023
Ace Microsoft DP-500 Certification with Actual Questions Oct 12, 2023 Updated
The DP-500 certification exam is an excellent opportunity for IT professionals, business analysts, and data architects to deepen their understanding of enterprise-scale analytics solutions using Microsoft Azure and Power BI. Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI certification can help professionals stand out to employers and advance their careers in the data analytics industry.
NEW QUESTION # 62
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. PBIT
- C. PBIX
Answer: B
Explanation:
A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.
A PBIT file acts as a Power BI template. It doesn't include any data from your source systems.
NEW QUESTION # 63
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. Configure the FinData workspace to use a Power Bl Premium capacity.
- B. Grant the Build permission for the financial data to each customer.
- C. Publish the financial data to the web.
- D. Set Use datasets across workspaces to Enabled
Answer: B
NEW QUESTION # 64
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?
- A. Create calculated columns in Dataset1.
- B. Remove the relationships from Dataset1.
- C. Normalize the tables in DB1.
- D. Denormalize the tables in DB1.
Answer: C
NEW QUESTION # 65
You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage
mode. You need to ensure that the report page updates all the visuals every 30 minutes. Which two actions
should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth
one point.
- A. Add a Microsoft Power Automate visual to the report page.
- B. Configure the data sources to use a streaming dataset
- C. Configure the data sources to use DirectQuery.
- D. Enable Power Bl embedded.
- E. Enable the XMIA endpoint.
- F. Select Auto page refresh.
Answer: D,F
NEW QUESTION # 66
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. Replace all the filters on the Filters pane with visual slicers on the report page.
- B. Change the report theme to monochromatic.
- C. Replace the product category charts with a bar chart for sales and a hierarchy of Category and Sub Category on the axis.
- D. Replace the single-value cards with a multi-row card.
Answer: C,D
NEW QUESTION # 67
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?
- A. Sales[Sales Amount]
- B. Sales[Sales ID]
- C. Plan[RowlD]
- D. Sales[RowlD]
Answer: D
Explanation:
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.
NEW QUESTION # 68
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? To answer, drag the appropriate values to the targets. Each value may be used once, more than once. 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 # 69
You need to build a Transact-SQL query to implement the planned changes for the internal users.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 70
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal-workspaces
NEW QUESTION # 71
You are creating a Power Bl Desktop report.
You add a Python visual to the report page.
You plan to create a scatter chart to visualize the data.
You add Python code to the Python script editor.
You need to create the scatter chart.
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.
Answer:
Explanation:
NEW QUESTION # 72
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 Datasetl, 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 Power Bl Desktop, you group the measures in a display folder.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
Explanation:
Solution: From DAX Studio, you write a query that uses grouping sets.
A grouping is a set of discrete values that are used to group measure fields.
NEW QUESTION # 73
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 history
- B. the query statistics
- C. the server timings
- D. the query plan
Answer: D
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
NEW QUESTION # 74
You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.
You need to create a Transact-SQL query that will return the source IP address.
Which function should you use in the select statement to retrieve the source IP address?
- A. CONVERT
- B. FOR.JSON
- C. FIRST VALUE
- D. JS0N_VALUE
Answer: D
NEW QUESTION # 75
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. Change the icons to use a different shape for each color.
- C. Remove the icons and use red, yellow, and green background colors instead.
- D. Move the conditional formatting icons to a tooltip report.
Answer: A
Explanation:
Report accessibility checklist, All Visuals.
* Ensure alt text is added to all non-decorative visuals on the page.
* Avoid using color as the only means of conveying information. Use text or icons to supplement or replace the color.
* Check that your report page works for users with color vision deficiency.
* Etc.
NEW QUESTION # 76
You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?
- A. Sales[Sales Amount]
- B. Sales[Sales ID]
- C. Plan[RowlD]
- D. Sales[RowlD]
Answer: D
Explanation:
Sales[Row ID] has 858,786 missing keys and 858,789 Max From Cardinality.
Note: The Max From Cardinality column defines the cost of the relationship which is the amount of time DAX needs to transfer the filters from the dimensions table to the fact table.
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 # 77
You have a Power Bl data model.
You need to refresh the data from the source every 15 minutes.
What should you do first?
- A. Define an incremental refresh policy.
- B. Configure a scheduled refresh.
- C. Change the storage mode of the dataset.
- D. Enable the XMLA endpoint.
Answer: D
NEW QUESTION # 78
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 the Power BI 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 denormalizing the data model.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
Explanation:
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 # 79
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. PBIT
- C. PBIX
Answer: A
NEW QUESTION # 80
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?
- A. Tabular Editor
- B. Performance analyzer in Power Bl Desktop
- C. DAX Studio
- D. Vertipaq Analyzer
Answer: B
NEW QUESTION # 81
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. PBIT
- C. PBIX
Answer: A
Explanation:
A PBIT file is a template created by Power BI Desktop, a Microsoft application used to create reports and visualizations. It contains queries, visualization settings, data models, reports, and other data added by the user.
A PBIT file acts as a Power BI template. It doesn't include any data from your source systems.
NEW QUESTION # 82
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?
- A. data = [Unit Price]
- B. ('Unit Price')
- C. dataset['Unit Price']
- D. pandas.DataFrame('Unit Price')
Answer: D
Explanation:
You can retrieve a column in a pandas DataFrame object by using the DataFrame object name, followed by the label of the column name in brackets.
So if the DataFrame object name is dataframe1 and the column we are trying to retrieve the 'X' column, then we retrieve the column using the statement, dataframe1['X'].
Here's a simple Python script that imports pandas and uses a data frame:
import pandas as pd
data = [['Alex',10],['Bob',12],['Clarke',13]]
df = pd.DataFrame(data,columns=['Name','Age'],dtype=float)
print (df)
When run, this script returns:
Name Age
0 Alex 10.0
1 Bob 12.0
2 Clarke 13.0
NEW QUESTION # 83
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 workspace admins of any workspace that uses the dataset
- B. any users that accessed a report that uses the dataset within the last 30 days
- C. all the workspace members of any workspace that uses the dataset
- D. the Power Bl admins
Answer: D
NEW QUESTION # 84
......
Microsoft DP-500 exam is a comprehensive test that covers a wide range of topics, including data storage solutions, data processing, and data visualization. Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI certification exam is designed to test the skills of professionals in various areas of data analysis, such as data management, data warehousing, and data visualization.
Try Free and Start Using Realistic Verified DP-500 Dumps Instantly.: https://www.actualvce.com/Microsoft/DP-500-valid-vce-dumps.html
2023 The Most Effective DP-500 with 115 Questions Answers: https://drive.google.com/open?id=14xP4BT2zgNekVQkYUgQ9OH2VcosoYjSA