NEW QUESTION 1

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 2

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.

Answer: D

NEW QUESTION 3

You have a Power Bl workspace named Workspacel that contains five dataflows.
You need to configure Workspacel to store the dataflows in an Azure Data Lake Storage Gen2 account What should you do first?

• A. Delete the dataflow queries.
• B. From the Power Bl Admin portal, enable tenant-level storage.
• C. Disable load for all dataflow queries.
• D. Change the Data source settings in the dataflow queries.

Answer: D

NEW QUESTION 4

You have a Power Bl dataset that contains the following measures:
• Budget
• Actuals
• Forecast
You create a report that contains 10 visuals.
You need provide users with the ability to use a slicer to switch between the measures in two visuals only. You create a dedicated measure named cg Measure switch.
How should you complete the DAX expression for the Actuals measure? To answer, drag the appropriate values to the targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 5

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

Answer: A

NEW QUESTION 6

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

Answer: B

NEW QUESTION 7

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.

Answer: A

NEW QUESTION 8

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 9

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 10

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. Replace both calculate functions by using a variable that contains the calculate function.
• B. Remove the alternative result of blank( ) from the divide function.
• C. Create a variable and replace the values for [sales Amount].
• D. Remove "calendar'[Flag] = "YTD" from the code.

Answer: A

NEW QUESTION 11

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. pandas.DataFrame('Unit Price')
• B. dataset['Unit Price']
• C. data = [Unit Price]
• D. ('Unit Price')

Answer: A

NEW QUESTION 12

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 13

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. Set Use datasets across workspaces to Enabled
• B. Publish the financial data to the web.
• C. Grant the Build permission for the financial data to each customer.
• D. Configure the FinData workspace to use a Power Bl Premium capacity.

Answer: C

NEW QUESTION 14

You are running a diagnostic against a query as shown in the following exhibit.

What can you identify from the diagnostics query?

• A. All the query steps are folding.
• B. Elevated permissions are being used to query records.
• C. The query is timing out.
• D. Some query steps are folding.

Answer: D

NEW QUESTION 15

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 16

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.

• A. Yes
• B. Not Mastered

Answer: A

NEW QUESTION 17
......