Reliable DP-500 Dumps Questions Available as Web-Based Practice Test Engine
Correct and Up-to-date Microsoft DP-500 BrainDumps
Exam DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Candidates for this exam should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.
Passing score: 700. Learn more about exam scores.
Part of the requirements for: Microsoft Certified: Azure Enterprise Data Analyst Associate
NEW QUESTION 14
You have a Power Bl dataset that contains the following measure.
You need to improve the performance of the measure without affecting the logic or the results. What should
you do?
- A. Replace both calculate functions by using a variable that contains the calculate function.
- B. Create a variable and replace the values for [sales Amount].
- C. Remove "calendar'[Flag] = "YTD" from the code.
- D. Remove the alternative result of blank( ) from the divide function.
Answer: A
NEW QUESTION 15
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. summary
- B. rollup
- C. explain
- D. freqltems
Answer: A
NEW QUESTION 16
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. Configure the data sources to use DirectQuery.
- B. Configure the data sources to use a streaming dataset
- C. Add a Microsoft Power Automate visual to the report page.
- D. Select Auto page refresh.
- E. Enable Power Bl embedded.
- F. Enable the XMIA endpoint.
Answer: D,E
NEW QUESTION 17
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?
- A. Change License mode to Premium per user.
- B. Change the location of the Premium capacity.
- C. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
- D. Turn on Large dataset storage format.
Answer: D
NEW QUESTION 18
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?
- A. Yes
- B. No
Answer: B
NEW QUESTION 19
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:
NEW QUESTION 20
You are using GitHub as a source control solution for an Azure Synapse Studio workspace. You need to
modify the source control solution to use an Azure DevOps Git repository. What should you do first?
- A. Disconnect from the GitHub repository.
- B. Create a new pull request.
- C. Change the active branch.
- D. Change the workspace to live mode.
Answer: A
NEW QUESTION 21
You need to recommend a solution to add new fields to the financial data Power Bl dataset with data from the
Microsoft SQL Server data warehouse.
What should you include in the recommendation?
- A. Azure Purview
- B. the on-premises data gateway
- C. an XMLA endpoint
- D. Site-to-Site VPN
Answer: B
NEW QUESTION 22
You have a file named File1.txt that has the following characteristics:
* A header row
* Tab delimited values
* UNIX-style line endings
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?
A)
B)
C)
D)
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: D
NEW QUESTION 23
You have a 2-GB Power Bl dataset.
You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize
how long it will take to apply changes to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. Enable service principal authentication for read-only admin APIs.
- B. Enable XMLA read-write.
- C. Turn on Large dataset storage format.
- D. Connect the target workspace to an Azure Data Lake Storage Gen2 account.
Answer: B
NEW QUESTION 24
You have a Power Bl workspace named Workspacel that contains five dataflows.
You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account
What should you do first?
- A. Delete the dataflow queries.
- B. Disable load for all dataflow queries.
- C. From the Power Bl Admin portal, enable tenant-level storage.
- D. Change the Data source settings in the dataflow queries.
Answer: D
NEW QUESTION 25
You need to configure a source control solution for Azure Synapse Analytics. The solution must meet the
following requirements:
* Code must always be merged to the main branch before being published, and the main branch must be used
for publishing resource
* The workspace templates must be stored in the publish branch.
* A branch named dev123 will be created to support the development of a new feature.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 26
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.
- A. Increase the Max Offline Dataset Size setting.
- B. Publish the complete dataset.
- C. Invoke a refresh to load historical data based on the incremental refresh policy.
- D. Publish an initial dataset that is less than 10 GB.
- E. Restart the capacity.
Answer: B,E
NEW QUESTION 27
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and
Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 28
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
- A. Associate the Power Bl tenant to an Azure Data Lake Storage account.
- B. Add the managed identity for Data Factory as a member of the workspaces.
- C. Create and save the dataflows to the internal storage of Power BL
- D. Create and save the dataflows to an Azure Data Lake Storage account.
Answer: A,B
NEW QUESTION 29
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 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 normalizing the data model.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
NEW QUESTION 30
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?
- A. DirectQuery for the external customers and import for the security team.
- B. Import for the external customers and DirectQuery for the security team.
- C. DirectQuery for the external customers and DirectQuery for the security team.
- D. Import for the external customers and import for the security team.
Answer: A
NEW QUESTION 31
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. all the workspace members of any workspace that uses the dataset
- 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. the Power Bl admins
Answer: D
NEW QUESTION 32
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?
- A. Move important information to a tooltip.
- B. Replace long text with abbreviations and acronyms.
- C. Configure a distinct color for each series.
- D. Configure a unique marker for each series.
Answer: D
NEW QUESTION 33
You have a Power Bl dataset. The dataset contains data that is updated frequently.
You need to improve the performance of the dataset by using incremental refreshes.
Which four actions should you perform in sequence to enable the incremental refreshes? To answer, move the
appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
NEW QUESTION 34
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 35
You have a Power Bl dataset that has only the necessary fields visible for report development.
You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.
What should you do?
- A. Configure object-level security (OLS).
- B. From Tabular Editor, create a new role.
- C. Hide all the fields in the dataset.
- D. From Tabular Editor, create a new perspective.
Answer: C
NEW QUESTION 36
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.
- A. Register a data source.
- B. Assign the Storage Blob Data Reader role to the Azure Purview managed service identity (MSI) for the storage account associated to the Synapse Analytics workspace.
- C. Create a managed identity in Azure Active Directory (Azure AD).
- D. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
- E. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
Answer: A,C,E
NEW QUESTION 37
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 are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files
by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business
names, survey names, and participant counts. The database is configured to use the default collation.
The queries use open row set and infer the schema shown in the following table.
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend using openrowset with to explicitly define the collation for businessName and
surveyName as Latim_Generai_100_BiN2_UTF8.
Does this meet the goal?
- A. No
- B. Yes
Answer: B
NEW QUESTION 38
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 39
......
100% Reliable Microsoft DP-500 Exam Dumps Test Pdf Exam Material: https://www.briandumpsprep.com/DP-500-prep-exam-braindumps.html
Current DP-500 dumps Preparation through Our Practice Test: https://drive.google.com/open?id=1_B_PiPFMeq0eJnnDpaKpR3alfr2DEYNA
