1. You are optimizing a Power BI data model by using DAX Studio.
You need to capture the query events generated by a Power BI Desktop report.
What should you use?

2. You are creating a Python visual in Power BI 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?

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

Which type of chart will the code produce?

4. 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?

5. You have a Power BI dataset that has only the necessary fields visible for report development.
You need to ensure that end users see only 25 specific fields that they can use to personalize visuals.
What should you do?

6. You are creating a Power BI single-page report.
Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader.
You need to ensure that the users can consume content on a report page in a logical order.
What should you configure on the report page?

7. You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data.
You need to review statistics for a DataFrame that includes:

The column name –

The column type –

The number of distinct values –
Whether the column has missing values
Which function should you use?

8. You have two Power BI reports named Report1 and Report2.
Report1 connects to a shared dataset named Dataset1.
Report2 connects to a local dataset that has the same structure as Dataset1. Report2 contains several calculated tables and parameters.
You need to prepare Report2 to use Dataset1.
Which two actions should you perform?

9. Your company is migrating its current, custom-built reporting solution to Power BI.
The Power BI tenant must support the following scenarios:
40 reports that will be embedded in external websites. The websites control their own security. The reports will be consumed by 50 users monthly.
Forty-five users that require access to the workspaces and apps in the Power BI Admin portal. Ten of the users must publish and consume datasets that are larger than 1 GB.
Ten developers that require Text Analytics transformations and paginated reports for datasets. An additional 15 users will consume the reports.
You need to recommend a licensing solution for the company. The solution must minimize costs.
Which two Power BI license options should you include in the recommendation?

10. You are attempting to configure certification for a Power BI dataset and discover that the certification setting for the dataset is unavailable.
What are two possible causes of the issue?

11. You have a Power BI Premium capacity.
You need to increase the number of virtual cores associated to the capacity.
Which role do you need?

12. You have a deployment pipeline for a Power BI workspace. The workspace contains two datasets that use import storage mode.
A database administrator reports a drastic increase in the number of queries sent from the Power BI service to an Azure SQL database since the creation of the deployment pipeline.
An investigation into the issue identifies the following:
One of the datasets is larger than 1 GB and has a fact table that contains more than 500 million rows.
When publishing dataset changes to development, test, or production pipelines, a refresh is triggered against the entire dataset.
You need to recommend a solution to reduce the size of the queries sent to the database when the dataset changes are published to development, test, or production.
What should you recommend?

13. 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?

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

15. You have a Power BI tenant.
You plan to register the tenant in an Azure Purview account.
You need to ensure that you can scan the tenant by using Azure Purview.
Which two actions should you perform?