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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

HOTSPOT

You are creating a Power Bl Desktop report.

You add a Python visual to the report page.

You plan to create a scatter chart to visualize the data.

You add Python code to the Python script editor.

You need to create the scatter chart.

How should you complete the Python code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: matplotlib.pyplot

Create a scatter plot

Let’s create a scatter plot to see if there’s a correlation between age and weight.

Under Paste or type your script code here, enter this code:

import matplotlib.pyplot as plt

dataset.plot(kind=’scatter’, x=’Age’, y=’Weight’, color=’red’)

plt.show()

Box 2: chart.show()

Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals#create-a-scatter-plot

You have the following Python code in an Apache Spark notebook.

Which type of chart will the code produce?

Reveal Solution Hide Solution

You use Azure Synapse Analytics and Apache Spark notebooks to You need to use PySpark to gain access to the visual libraries.

Which Python libraries should you use?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses Import storage mode. You need to ensure that the report page updates all the visuals every 30 minutes.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: main

Code must always be merged to the main branch before being published, and the main branch must be used for publishing resources.

Collaboration branch – Your Azure Repos collaboration branch that is used for publishing. By default, its master. Change this setting in case you want to publish resources from another branch. You can select existing branches or create new.

Each Git repository that’s associated with a Synapse Studio has a collaboration branch. (main or master is the default collaboration branch).

Box 2: workspace_publish

A branch named dev123 will be created to support the development of a new feature.

The workspace templates must be stored in the publish branch.

Creating feature branches

Users can also create feature branches by clicking + New Branch in the branch dropdown.

By default, Synapse Studio generates the workspace templates and saves them into a branch called workspace_publish. To configure a custom publish branch, add a publish_config.json file to the root folder in the collaboration branch.

Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/cicd/source-control