The Microsoft DP-500 Questions & Practice Test are Available On-Demand
Valid DP-500 Exam Dumps Ensure you a HIGH SCORE
NEW QUESTION 39
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 defining a data source and view for the Parquet files. You recommend updating the
query to use the view.
Does this meet the goal?
- A. Yes
- B. No
Answer: A
NEW QUESTION 40
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:
NEW QUESTION 41
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:
NEW QUESTION 42
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. auto-binding across pipelines
- B. parameter rules
- C. data source rules
- D. selective deployment
Answer: D
NEW QUESTION 43
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. Disabling cross highlighting/filtering by default
- B. Add a single Apply button to the filter pane to apply changes at once
- C. Add Apply buttons to all basic filters to apply changes when you're ready
- D. Ignore the Privacy Levels and potentially improve performance
- E. Add an Apply button to each slicer to apply changes when you're ready
Answer: C,E
NEW QUESTION 44
You open a Power Bl Desktop report that contains an imported data model and a single report page.
You open Performance analyzer, start recording, and refresh the visuals on the page. The recording produces
the results shown in the following exhibit
What can you identify from the results?
- A. When all the visuals refresh simultaneously, the visuals spend most of the time waiting on other processes to finish.
- B. The Actual/Forecast Billable Hrs YTD visual displays the most data.
- C. The Actual/Forecast Hours by Type visual takes a long time to render on the report page when the data is cross-filtered.
- D. Unoptimized DAX queries cause the page to load slowly.
Answer: A
NEW QUESTION 45
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 46
What should you configure in the deployment pipeline?
- A. a selective deployment
- B. a backward deployment
- C. auto-binding
- D. a data source rule
Answer: C
NEW QUESTION 47
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. 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.
- B. Register a data source.
- C. Create a managed identity in Azure Active Directory (Azure AD).
- D. Assign the Owner role to the Azure Purview managed service identity (MSI) for the Azure Purview resource group.
- E. Assign the Reader role to the Azure Purview managed service identity (MSI) for the Synapse Analytics workspace.
Answer: B,C,D
NEW QUESTION 48
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 49
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 50
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. dataset['Unit Price']
- C. pandas.DataFrame('Unit Price')
- D. ('Unit Price')
Answer: C
NEW QUESTION 51
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 52
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 53
You have an Azure Synapse Analytics dataset that contains data about jet engine performance. You need to
score the dataset to identify the likelihood of an engine failure. Which function should you use in the query?
- A. GROUPING
- B. PREDICT
- C. PIVOT
- D. CAST
Answer: C
NEW QUESTION 54
You need to create Power Bl reports that will display data based on the customers' subscription level.
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 55
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
NEW QUESTION 56
You are planning a Power Bl solution for a customer.
The customer will have 200 Power Bl users. The customer identifies the following requirements:
* Ensure that all the users can create paginated reports.
* Ensure that the users can create reports containing Al visuals.
* Provide autoscaling of the CPU resources during heavy usage spikes.
You need to recommend a Power Bl solution for the customer. The solution must minimize costs. What should
you recommend?
- A. Power Bl Premium per user
- B. Power Bl Report Server
- C. a Power Bl Premium per capacity
- D. Power Bl Pro per user
Answer: A
NEW QUESTION 57
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:
NEW QUESTION 58
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. Remove the alternative result of blank( ) from the divide function.
- B. Replace both calculate functions by using a variable that contains the calculate function.
- C. Create a variable and replace the values for [sales Amount].
- D. Remove "calendar'[Flag] = "YTD" from the code.
Answer: B
NEW QUESTION 59
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 60
......
DP-500 Exam Practice Questions prepared by Microsoft Professionals: https://www.actualtestsit.com/Microsoft/DP-500-exam-prep-dumps.html
Pass DP-500 Exam with Latest Questions: https://drive.google.com/open?id=1aSeTqUGM5jDradegUfiY7iKyKvHyNAxk