Get DP-500 Braindumps & DP-500 Real Exam Questions
Microsoft DP-500 Actual Questions and Braindumps
NEW QUESTION 21
You are running a diagnostic against a query as shown in the following exhibit.
What can you identify from the diagnostics query?
- A. Some query steps are folding.
- B. All the query steps are folding.
- C. Elevated permissions are being used to query records.
- D. The query is timing out.
Answer: A
NEW QUESTION 22
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 server timings
- B. the query history
- C. the query plan
- D. the query statistics
Answer: C
NEW QUESTION 23
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 moving all the measures to a calculation group.
Does this meet the goal?
- A. Yes
- B. No
Answer: B
NEW QUESTION 24
You need to integrate the external data source to support the planned changes.
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:
NEW QUESTION 25
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. Yes
- B. No
Answer: A
NEW QUESTION 26
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. freqltems
- C. rollup
- D. summary
Answer: D
NEW QUESTION 27
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. dataset['Unit Price']
- B. data = [Unit Price]
- C. pandas.DataFrame('Unit Price')
- D. ('Unit Price')
Answer: C
NEW QUESTION 28
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 29
You have an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that the SQL pool is scanned by Azure Purview.
What should you do first?
- A. Register a data source.
- B. Create a data share connection.
- C. Search the data catalog.
- D. Create a data policy.
Answer: C
NEW QUESTION 30
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 31
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. None
- B. Public
- C. Organizational
- D. Private
Answer: D
NEW QUESTION 32
You have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and
display the top five
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 33
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. Set Use datasets across workspaces to Enabled
- C. Grant the Build permission for the financial data to each customer.
- D. Publish the financial data to the web.
Answer: C
NEW QUESTION 34
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 the location of the Premium capacity.
- B. Turn on Large dataset storage format.
- C. Connect Workspace1 to an Azure Data Lake Storage Gen2 account
- D. Change License mode to Premium per user.
Answer: B
NEW QUESTION 35
You have a dataset that contains a table named UserPermissions. UserPermissions contains the following data.
You plan to create a security role named User Security for the dataset. You need to filter the dataset based on
the current users. What should you include in the DAX expression?
- A. [User] = USEROBJECTID()
- B. [UserPermissions] - USERPRINCIPALNAME()
- C. [User] = USERPRINCIPALNAME()
- D. [UserPermissions] - USERNAME()
- E. [User] = USERNAMEQ()
Answer: E
NEW QUESTION 36
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 Tabular Editor, create a new perspective.
- B. From Report setting, select Personalize visuals.
- C. From Visual options in Report settings, select Use the modern visual header with updated styling options.
- D. From the Bookmarks pane, select Focus mode, and then select Add.
Answer: B
NEW QUESTION 37
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. Configure a unique marker for each series.
- C. Replace long text with abbreviations and acronyms.
- D. Configure a distinct color for each series.
Answer: B
NEW QUESTION 38
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. Create a new pull request.
- B. Change the active branch.
- C. Change the workspace to live mode.
- D. Disconnect from the GitHub repository.
Answer: D
NEW QUESTION 39
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 A
- C. Option D
- D. Option B
Answer: B
NEW QUESTION 40
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.
- A. The connection must be created by a user that is assigned the Storage Blob Data Owner role.
- B. The storage account must be created in a separate Azure region from the Power Bl tenant and workspaces.
- C. The storage account must have hierarchical namespace enabled.
- D. The storage account must be protected by using an Azure Firewall.
- E. Dataflows must exist already for any directly connected Power Bl workspaces.
Answer: A,C
NEW QUESTION 41
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 42
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: B
NEW QUESTION 43
You have a Power Bl workspace that contains one dataset and four reports that connect to the dataset. The
dataset uses Import storage mode and contains the following data sources:
* A CSV file in an Azure Storage account
* An Azure Database for PostgreSQL database
You plan to use deployment pipelines to promote the content from development to test to production. There
will be different data source locations for each stage. What should you include in the deployment pipeline to
ensure that the appropriate data source locations are used during each stage?
- A. data source rules
- B. selective deployment
- C. auto-binding across pipelines
- D. parameter rules
Answer: B
NEW QUESTION 44
......
DP-500 Dumps To Pass Microsoft Exam in 24 Hours - Free4Dump: https://www.free4dump.com/DP-500-braindumps-torrent.html
Buy Latest DP-500 Exam Q&A PDF - One Year Free Update: https://drive.google.com/open?id=1lvufi9i_SrzqJTI9R_Am0bC5j2b5DjA2