Unique Top-selling DP-500 Exams - New 2022 Microsoft Pratice Exam
Azure Enterprise Data Analyst Associate Dumps DP-500 Exam for Full Questions - Exam Study Guide
NEW QUESTION 15
You need to implement object-level security (OLS) in the Power Bl dataset for the sales associates.
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:
Topic 2, Contoso, Ltd
Overview
Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.
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 16
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 specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
NEW QUESTION 17
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. Create and save the dataflows to the internal storage of Power BL
- C. Add the managed identity for Data Factory as a member of the workspaces.
- D. Create and save the dataflows to an Azure Data Lake Storage account.
Answer: A,C
NEW QUESTION 18
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. Import for the external customers and import for the security team.
- B. DirectQuery for the external customers and import for the security team.
- C. DirectQuery for the external customers and DirectQuery for the security team.
- D. Import for the external customers and DirectQuery for the security team.
Answer: B
NEW QUESTION 19
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. ('Unit Price')
- B. data = [Unit Price]
- C. dataset['Unit Price']
- D. pandas.DataFrame('Unit Price')
Answer: D
NEW QUESTION 20
You have a Power Bl dataset that has the query dependencies 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 21
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 Dataset1.
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 Tabular Editor, you create a calculation group.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
NEW QUESTION 22
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. The query is timing out.
- B. Some query steps are folding.
- C. All the query steps are folding.
- D. Elevated permissions are being used to query records.
Answer: B
NEW QUESTION 23
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. Enable Power Bl embedded.
- B. Add a Microsoft Power Automate visual to the report page.
- C. Configure the data sources to use a streaming dataset
- D. Enable the XMIA endpoint.
- E. Select Auto page refresh.
- F. Configure the data sources to use DirectQuery.
Answer: A,E
NEW QUESTION 24
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. Publish the financial data to the web.
- C. Set Use datasets across workspaces to Enabled
- D. Configure the FinData workspace to use a Power Bl Premium capacity.
Answer: A
NEW QUESTION 25
You need to create the customized Power Bl usage reporting. The Usage Metrics Report dataset has already
been created. The solution must minimize development and administrative effort.
Which four 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:
NEW QUESTION 26
You need to populate the CustomersWithProductScore table.
How should you complete the stored procedure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Topic 1, Litware, Inc. Overview
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells
goods both online and at its stores located in six countries.
Azure Resources
Litware has the following Azure resources:
* An Azure Synapse Analytics workspace named synapseworkspace1
* An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
* A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool
SQLDW contains a dimensional model that contains the following table.
SQLDW contains the following additional tables.
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from
dbo.Customer [customeriD], dbo.Customer
[CustomerEmail], dbo.ProductfProductID] and dbo.Product[ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in
SQLDW up to three days after being created. The records do NOT change after three days.
Power BI
Litware has a new Power Bl tenant that contains an empty workspace named Sales Analytics.
All users have Power B1 Premium per user licenses.
IT data analysts are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company's sales analytics goals. The dataset will be
refreshed every 30 minutes.
Analytics Goals
Litware identifies the following analytics goals:
* Provide historical reporting of sales by product and channel over time.
* Allow sales managers to perform ad hoc sales reporting with minimal effort.
* Perform market basket analysis to understand which products are commonly purchased in the same
transaction.
* Identify which customers should receive promotional emails based on their likelihood of purchasing
promoted products.
Litware plans to monitor the adoption of Power Bl reports over time. The company wants custom Power Bl
usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace
each month.
Security Requirements
Litware identifies the following security requirements for the analytics environment:
* All the users in the sales department and the marketing department must be able to see Power B1 reports that
contain market basket analysis and data about which customers are likely to purchase a product.
* Customer contact data in SQLDW and the Power B1 dataset must be labeled as Sensitive. Records must be
kept of any users that use the sensitive data.
* Sales associates must be prevented from seeing the CustomerEmail column in Power B1 reports.
* Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
* SQLDW and datalake1 will act as the development environment. Once feature development is complete, all
entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
* Power Bl content must be deployed to test and production by using deployment pipelines.
* All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power Bl reports in Synapse Studio.
NEW QUESTION 27
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. Denormalize the tables in DB1.
- C. Remove the relationships from Dataset1.
- D. Normalize the tables in DB1.
Answer: D
NEW QUESTION 28
You are configuring a Power Bl report for accessibility as shown in the following table.
You need to change the default colors of all three visuals to make the report more accessible to users who have
color vision deficiency. Which two settings should you configure in the Customize theme window? Each
correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A. First-level elements colors
- B. Sentiment colors
- C. Divergent colors
- D. Theme colors
Answer: A
NEW QUESTION 29
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. Private
- B. Organizational
- C. Public
- D. None
Answer: A
NEW QUESTION 30
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.
- A. Add a single Apply button to the filter pane to apply changes at once
- B. Disabling cross highlighting/filtering by default
- C. Add an Apply button to each slicer to apply changes when you're ready
- D. Ignore the Privacy Levels and potentially improve performance
- E. Add Apply buttons to all basic filters to apply changes when you're ready
Answer: C,E
NEW QUESTION 31
You have the following Python code in an Apache Spark notebook.
Which type of chart will the code produce?
- A. a pie chart
- B. a stacked bar chart
- C. a bar chart
- D. an area chart
Answer: C
NEW QUESTION 32
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?
- A. From Visual options in Report settings, select Use the modern visual header with updated styling options.
- B. From Tabular Editor, create a new perspective.
- C. From Report setting, select Personalize visuals.
- D. From the Bookmarks pane, select Focus mode, and then select Add.
Answer: C
NEW QUESTION 33
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 34
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. Configure a scheduled refresh.
- B. Enable the XMLA endpoint.
- C. Define an incremental refresh policy.
- D. Change the storage mode of the dataset.
Answer: B
NEW QUESTION 35
......
Best way to practice test for Microsoft DP-500: https://www.trainingquiz.com/DP-500-practice-quiz.html
DP-500 Dump Ready - Exam Questions and Answers: https://drive.google.com/open?id=1fDwYXEdFQdLfTOpA5slDrRaPb6BkllIu
