Latest Microsoft DP-500 First Attempt, Exam real Dumps Updated [Jul-2022]
Get the superior quality DP-500 Dumps Questions from ITPassLeader. Nobody can stop you from getting to your dreams now. Your bright future is just a click away!
NEW QUESTION 20
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 DirectQuery for the security team.
- B. Import for the external customers and DirectQuery for the security team.
- C. Import for the external customers and import for the security team.
- D. DirectQuery for the external customers and import for the security team.
Answer: D
NEW QUESTION 21
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 22
You need to recommend an automated solution to monitor Power Bl user activity. The solution must meet the
following requirements:
* Security admins must identify when users export reports from Power Bl within five days of a new sensitivity
label being applied to the artifacts in Power Bl.
* Power Bl admins must identify updates or changes to the Power Bl capacity.
* The principle of least privilege must be used.
Which log should you include in the recommendation for each group? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 23
You are configuring an aggregation table as shown in the following exhibit.
The detail table is named FactSales and the aggregation table is named FactSales(Agg).
You need to aggregate SalesAmount for each store.
Which type of summarization should you use for SalesAmount and StoreKey? To answer, select the
appropriate options in the answer area,
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 24
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. [UserPermissions] - USERNAME()
- D. [User] = USERPRINCIPALNAME()
- E. [User] = USERNAMEQ()
Answer: E
NEW QUESTION 25
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. Publish the financial data to the web.
- D. Grant the Build permission for the financial data to each customer.
Answer: D
NEW QUESTION 26
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 27
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. DAX Studio
- B. Tabular Editor
- C. Vertipaq Analyzer
- D. Performance analyzer in Power Bl Desktop
Answer: D
NEW QUESTION 28
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 29
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. the Power Bl admins
- C. any users that accessed a report that uses the dataset within the last 30 days
- D. the workspace admins of any workspace that uses the dataset
Answer: B
NEW QUESTION 30
You are using Azure Synapse Studio to explore a dataset that contains data about taxi trips.
You need to create a chart that will show the total trip distance according to the number of passengers as
shown in the following exhibit.
How should you configure the chart? To answer, select the appropriate options in the answer area. NOTE:
Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 31
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. Move the conditional formatting icons to a tooltip report.
- B. Change the icons to use a different shape for each color.
- C. Add alt text to explain the information that each color conveys.
- D. Remove the icons and use red, yellow, and green background colors instead.
Answer: D
NEW QUESTION 32
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 Pro per user
- B. Power Bl Report Server
- C. a Power Bl Premium per capacity
- D. Power Bl Premium per user
Answer: D
NEW QUESTION 33
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. Search the data catalog.
- B. Register a data source.
- C. Create a data share connection.
- D. Create a data policy.
Answer: A
NEW QUESTION 34
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 35
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. Divergent colors
- C. Sentiment colors
- D. Theme colors
Answer: A
NEW QUESTION 36
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 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 specify the maximum length for businessName
and surveyName.
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION 38
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. Enable the XMLA endpoint.
- B. Configure a scheduled refresh.
- C. Define an incremental refresh policy.
- D. Change the storage mode of the dataset.
Answer: A
NEW QUESTION 39
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. Elevated permissions are being used to query records.
- D. All the query steps are folding.
Answer: B
NEW QUESTION 40
What should you configure in the deployment pipeline?
- A. auto-binding
- B. a backward deployment
- C. a selective deployment
- D. a data source rule
Answer: A
NEW QUESTION 41
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. an XMLA endpoint
- C. the on-premises data gateway
- D. Site-to-Site VPN
Answer: C
NEW QUESTION 42
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. pandas.DataFrame('Unit Price')
- C. dataset['Unit Price']
- D. ('Unit Price')
Answer: B
NEW QUESTION 43
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 Report setting, select Personalize visuals.
- B. From Visual options in Report settings, select Use the modern visual header with updated styling options.
- C. From Tabular Editor, create a new perspective.
- D. From the Bookmarks pane, select Focus mode, and then select Add.
Answer: A
NEW QUESTION 44
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 45
......
Guaranteed Success with Valid Microsoft DP-500 Dumps: https://certlibrary.itpassleader.com/Microsoft/DP-500-dumps-pass-exam.html