Microsoft Microsoft Certifications DP-500 Questions & Answers

• Question 91:

  You have a Power Bl report that contains the visual shown in the following exhibit.

  

  You need to make the visual more accessible to users who have color vision deficiency. What should you do?

  A. Change the font color of values in the Sales column to white.

  B. Change the red background color to orange.

  C. Add icons to represent the sales status of each product.

  D. Add additional measures to the table values.

  Correct Answer: C

• Question 92:

  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. Replace long text with abbreviations and acronyms.

  B. Configure a unique marker for each series.

  C. Configure a distinct color for each series.

  D. Move important information to a tooltip.

  Correct Answer: B

• Question 93:

  You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs in the Apache Parquet format. A sample of the data is shown in the following table.

  

  You need to create a Transact-SQL query that will return the source IP address.

  Which function should you use in the select statement to retrieve the source IP address?

  A. JS0N_VALUE

  B. FOR.JSON

  C. CONVERT

  D. FIRST VALUE

  Correct Answer: A

• Question 94:

  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 Tabular Editor, create a new perspective.

  C. From the Bookmarks pane, select Focus mode, and then select Add.

  D. From Visual options in Report settings, select Use the modern visual header with updated styling options.

  Correct Answer: A

• Question 95:

  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. Public

  B. Organizational

  C. Private

  D. None

  Correct Answer: A

• Question 96:

  You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multiple joins. You need to reduce the load time of the dataflow. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  A. Reduce the memory assigned to the dataflows.

  B. Execute non-foldable operations before foldable operations.

  C. Execute foldable operations before non-foldable operations.

  D. Place the ingestion operations and transformation operations in a single dataflow.

  E. Place the ingestion operations and transformation operations in separate dataflows.

  Correct Answer: CD

• Question 97:

  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. Add alt text to explain the information that each color conveys.

  B. Move the conditional formatting icons to a tooltip report.

  C. Change the icons to use a different shape for each color.

  D. Remove the icons and use red, yellow, and green background colors instead.

  Correct Answer: C

• Question 98:

  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. Invoke a refresh to load historical data based on the incremental refresh policy.

  C. Restart the capacity.

  D. Publish an initial dataset that is less than 10 GB.

  E. Publish the complete dataset.

  Correct Answer: BD

• Question 99:

  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 query statistics

  B. the query plan

  C. the query history

  D. the server timings

  Correct Answer: B

• Question 100:

  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. [UserPermissions] - USERNAME()

  B. [UserPermissions] - USERPRINCIPALNAME()

  C. [User] = USERPRINCIPALNAME()

  D. [User] = USERNAME()

  E. [User] = USEROBJECTID()

  Correct Answer: D