HOTSPOT
-
You have a Power BI report and dataset in Power BI Desktop. The dataset contains a calculation group named CG1 that contains four calculation items. The Current calculation item is 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.
 

You have a 2-GB Power BI dataset.
You need to ensure that you can redeploy the dataset by using Tabular Editor. The solution must minimize how long it will take to apply changes to the dataset from powerbi.com.
Which two actions should you perform in powerbi.com? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Enable service principal authentication for read-only admin APIs.

B. Connect the target workspace to an Azure Data Lake Storage Gen2 account.

C. Turn on Large dataset storage format.

D. Enable XMLA read-write.

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
Existing environment -
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries.
Azure Resources -
Litware has the following Azure resources:
An Azure Synapse Analytics workspace named synapseworkspace1
An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool -
SQLDW contains a dimensional model that contains the following tables.
 
SQLDW contains the following additional tables.
 
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customerID], dbo.Customer [CustomerEmail], dbo.Product [ProductID] and dbo.Product [ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Power BI -
Litware has a new Power BI tenant that contains an empty workspace named Sales Analytics.
All users have Power BI Premium per user licenses.
IT data analytics are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company’s sales analytics goals. The dataset will be refreshed every 30 minutes.
Requirements -
Analytics Goals -
Litware identifies the following analytics goals:
Provide historical reporting of sales by product and channel over time.
Allow sales managers to perform ad hoc sales reporting with minimal effort.
Perform market basket analysis to understand which products are commonly purchased in the same transaction.
Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Litware plans to monitor the adoption of Power BI reports over time. The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Security Requirements -
Litware identifies the following security requirements for the analytics environment:
All the users in the sales department and the marketing department must be able to see Power BI reports that contain market basket analysis and data about which customers are likely to purchase a product.
Customer contact data in SQLDW and the Power BI dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.
Sales associates must be prevented from seeing the CustomerEmail column in Power BI reports.
Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
Power BI content must be deployed to test and production by using deployment pipelines.
All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power BI reports in Synapse Studio.
What should you configure in the deployment pipeline?

A. a selective deployment

B. auto-binding

C. a backward deployment

D. a data source rule

HOTSPOT
-
You are enhancing a Power BI model that has DAX calculations.
You need to create a DAX measure that returns the year-to-date total sales from the same date from the previous calendar year.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

You have a Power BI data model.
You need to refresh the data from the source every 15 minutes.
What should you do first?

A. Configure a scheduled refresh.

B. Change the storage mode of the dataset.

C. Enable the XMLA endpoint.

D. Define an incremental refresh policy.

You are planning a Power BI solution for a customer.
The customer will have 200 Power BI users. The customer identifies the following requirements:
Ensure that all the users can create paginated reports.
Ensure that the users can create reports containing AI visuals.
Provide autoscaling of the CPU resources during heavy usage spikes.
You need to recommend a Power BI solution for the customer. The solution must minimize costs.
What should you recommend?

A. a Power BI Premium per capacity

B. Power BI Report Server

C. Power BI Premium per user

D. Power BI Pro per user

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

After you answer a question in this question, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
From Power Query Editor, you profile the data shown in the following exhibit.
 
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.
Solution: You split the IoT DateTime column into a column named Date and a column named Time.
Does this meet the goal?

A. Yes

B. No

You are creating a Power BI report that will contain multiple visuals.
You need to ensure that the report is accessible to users who use a screen reader.
Which two configurations should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. consistent colors for each visual

B. consistent fonts for each visual

C. alt text for each visual

D. the tab order for each page

E. Play Axis for each page

HOTSPOT
-
You have a Power BI tenant that contains two workspaces named WorkspaceA and WorkspaceB. WorkspaceA contains centralized datasets.
You need to ensure that users can create reports by using the datasets in WorkspaceA and store the reports in WorkspaceB.
Which setting should you enable and for which resource? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

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. Configure a unique marker for each series.

B. Replace long text with abbreviations and acronyms.

C. Move important information to a tooltip.

D. Configure a distinct color for each series.

You plan to modify a Power BI 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. the Power BI admins

B. the workspace admins of any workspace that uses the dataset

C. all the workspace members of any workspace that uses the dataset

D. any users that accessed a report that uses the dataset within the last 30 days

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 a Power Bi dataset named Dataset1.
In Dataset1, you currently have 50 measures that use the same time intelligence logic.
You need to reduce the number of measures, while maintaining the current functionality.
Solution: From Power BI Desktop, you create a hierarchy.
Does this meet the goal?

A. Yes

B. No

You have a Power BI dataset named Dataset1 that uses DirectQuery against an Azure SQL database named DB1.
DB1 is a transactional database in the third normal form.
You need to recommend a solution to minimize how long it takes to execute the query. The solution must maintain the current functionality.
What should you include in the recommendation?

A. Remove the relationships from Dataset1.

B. Normalize the tables in DB1.

C. Create calculated columns in Dataset1.

D. Denormalize the tables in DB1.

HOTSPOT
-
You have a Power BI model that contains three tables named Sales, Marketing, and Delivery. The Sales table relates to the Marketing and Delivery tables. The Marketing and Delivery tables do NOT relate to each other.
You need to create a measure to meet the following requirements:
•	Sum the values in a column named Sales[SalesAmount].
•	Ensure that the tables and relationships remain unchanged.
•	If a user applies a filter to a column named Marketing[Region], apply the same filter to a column named Delivery[Region].
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

You have an Azure subscription that contains an Azure Synapse Analytics workspace.
You create an Azure Data Lake Storage Gen2 account and upload a CSV file named File1.csv.
You need to use Synapse Studio to query the data in File1.csv by using a serverless SQL pool.
Which Transact-SQL operator should you include in the query?

A. OPENQUERY

B. OPENROWSET

C. STRING_SPLIT

D. OPENDATASOURCE

You need to provide users with a reproducible method to connect to a data source and transform the data by using an AI function. The solution must meet the following requirement:
Minimize development effort.
Avoid including data in the file.
Which type of file should you create?

A. PBIT

B. PBIDS

C. PBIX

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 BI 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 normalizing the data model.
Does this meet the goal?

A. Yes

B. No

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?

A. Turn off auto refresh when publishing the dataset changes to the Power BI service.

B. In the dataset, change the fact table from an import table to a hybrid table.

C. Enable the large dataset storage format for workspace.

D. Create a dataset parameter to reduce the fact table row count in the development and test pipelines.

You have a Power BI dataflow named DF1 that contains the following columns:
•	OrderID
•	SaleDate
•	ProductID
•	SalesAmount
•	ProductCategory
You create a Power BI dataset named DS1 that uses DF1 as a data source. DS1 creates an aggregated view of the data in DF1. The view contains the following columns:
•	SaleMonth
•	SalesAmount
•	ProductCategory
You need to minimize how long it takes to refresh DS1.
What should you do first?

A. Add a computed entity to DF1.

B. Create a custom function in DS1.

C. Create a linked entity in DF1.

D. Add a computed column to DS1.

You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1.
You plan to deploy a data lake that will record the history of transactions executed against Pool1.
You need to recommend which type of file to use to store the history. The solution must ensure that the history is written in the scope of the related transaction.
Which file type should you recommend?

A. JSON

B. Avro

C. Delta

D. Parquet

DRAG DROP -
You have a Power BI 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.
 

You have an Azure SQL database named DB1.
You have a Power BI tenant that contains 20 workspaces. Multiple workspaces contain datasets that use DB1 as a data source.
You need to identity how many datasets use DB1 as a data source across the tenant.
What should you use?

A. an XLMA endpoint

B. the Power BI REST API

C. Power BI data source files

D. lineage view

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
General Overview -
Fabrikam, Inc. is a software company that develops educational software for higher education.
Organizational Structure -
Fabrikam has the following business units:
•	Finance and Accounting
•	Sales and Marketing
•	Operations
•	Product
The Product business unit contains the following groups:
•	User experience designers
•	Software engineers
•	Product managers
•	Testers
The Operations business unit contains an information technology (IT) group. The IT group contains an enterprise analytics team and an information security team.
Existing Environment -
Data Storage -
Fabrikam has three Azure Synapse Analytics workspaces named workspace1prod, workspace1test, and workspace1dev. Each workspace is connected to an Azure Data Lake Storage account and contains a lake database that is accessed by using the built-in serverless SQL pool. The data in the Data Lake Storage accounts is available in the lake databases for analysts from every business unit to query and analyze by using Power BI.
The company imports the following files into the Data Lake Storage accounts:
•	User experience data stored as JSON files
•	Finance data stored as CSV files
•	Sales data stored as CSV files
Reporting -
Fabrikam has a Power BI tenant that contains 30 workspaces in Pro license mode. The data in the workspaces is a mix of Import and DirectQueiy datasets. All reports are interactive.
Fabrikam has three frequently used workspaces as shown in the following table.
 
The Corporate Data Models workspace contains a dataset named Financial Model that is used by reports in the P&L workspace. Financial Model is maintained by the enterprise analytics team. The Corporate Data Models workspace and the User Experience workspace have corresponding development and test workspaces.
User Problems -
Administrators report an increase in the maintenance of Power BI tenant assets due to analysts in the Finance and Accounting business unit who create new Power BI datasets when the existing datasets already meet their needs.
Analysts in the Product business unit report the following issues:
•	Datasets are published to the User Experience workspace, while the data sources reference workspace1test.
•	The parsing of user experience data in Power Query is very slow.
The enterprise analytics team identifies two DAX measures in the Financial Model dataset that are consistently slow to execute. The team must identify all the reports that use the Financial Model dataset and notify the report owners of changes to the measures.
Members of the enterprise analytics team report that creating Power BI reports and adjusting tables and views in Azure Synapse is tedious because they must switch between the Power BI workspaces and the Azure Synapse workspaces.
The information security team identifies that the user experience data is being shared externally.
Requirements -
Planned Changes -
Fabrikam plans to implement the following changes:
•	Power BI will be registered as a data source in Microsoft Purview.
•	The analysts in the Product business unit will create a more automated process for deploying Power BI reports and datasets to the User Experience workspace.
The enterprise analytics team plans to perform the following tasks:
•	Update the DAX calculations in the Financial Model dataset.
•	Create views in the Azure Synapse workspaces to speed up the parsing of user experience data.
•	Create and document the change management process for shared Power BI datasets.
Technical Requirements -
From Microsoft Purview, analysts in all the business units must be able to see all the assets in the Power BI tenant and the Azure Synapse workspaces. Power BI asset information must include lineage to identify the data sources used by each report.
The information security team must identify all the Power BI reports and datasets that contain Personally Identifiable Information (PII).
Fabrikam requires a security solution for the Power BI tenant. The solution must meet the following requirements:
•	Access to the tenant by external users must be approved by a manager and granted by the IT group.
•	The external users must be prevented from publishing or modifying content in the tenant.
•	Users must be prevented from sharing Power BI reports publicly to the internet.
The new process for deploying Power BI reports and datasets to the User Experience workspace must ensure that the datasets point to the lake database to which the relevant dataset is deployed. The views in each lake database must present the data in a tabular format.
The enterprise analytics team needs to notify the report owners of the planned changes. The solution must minimize administrative effort.
What should the team do?

A. Locate all the downstream reports, identify all the users that are assigned the Admin role, and then send an email to each user.

B. Write a PowerShell script to access the Power BI API that retrieves a list of downstream reports and a list of workspace administrators, and then send an email to each workspace administrator.

C. Perform impact analysis on the Financial Model dataset to notify the workspace contacts.

D. Perform impact analysis feature on the lake database data source to notify the workspace contacts.

You have a Power BI workspace named workspace1 that contains three reports and two dataflows.
You have an Azure Data Lake Storage account named storage1.
You need to integrate workspace1 and storage1.
What should you do first?

A. In storage1, create a folder named dataflows.

B. Delete the dataflows from workspace1.

C. In storage1, create a folder named reports.

D. Delete the reports from workspace1.

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

You develop a solution that uses a Power BI 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 BI service? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Restart the capacity.

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

C. Increase the Max Offline Dataset Size setting.

D. Invoke a refresh to load historical data based on the incremental refresh policy.

E. Publish the complete dataset.

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?

A. From Tabular Editor, create a new role.

B. Configure object-level security (OLS).

C. From Tabular Editor, create a new perspective.

D. Hide all the fields in the dataset.

HOTSPOT
-
You have a Power BI tenant that is configured as 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 answer is worth one point.
 

You have an Apache Spark notebook that contains PySpark code and is used to explore data in an Azure Synapse Analytics workspace.
You need to create data visualizations in the notebook by using built-in libraries.
Which two libraries can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Gleam

B. Plotly

C. Seaborn

D. Matplotlib

You have a PostgreSQL database named db1.
You have a group of data analysts that will create Power BI datasets. Each analyst will use data from a different schema in db1.
You need to simplify the process for the analysts to initially connect to db1 when using Power BI Desktop.
Which type of file should you use?

A. PBIT

B. PBIX

C. PBIDS

DRAG DROP -
You have an Azure Synapse Analytics serverless SQL pool.
You need to return a list of files and the number of rows in each file.
How should you complete the Transact-SQL statement? 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.
 

HOTSPOT -
You are building a Power BI dataset that contains a table named Calendar. Calendar contains the following calculated column.
 
You need to create a measure that will perform a fiscal prior year-to-date calculation that meets the following requirements:
Returns the fiscal prior year-to-date value for [Sales Amount]
Uses a fiscal year end of June 30
Produces no result for dates in the future
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

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?

A. Power BI workspace admin

B. capacity admin

C. Power Platform admin

D. Power BI admin

You plan to deploy a Power BI Premium tenant.
You need to specify the capacity of the tenant.
Which unit should you use?

A. RU/s

B. v-cores

C. QPUs

D. DTUs

You have a Power BI 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. Add additional measures to the table values.

B. Change the red background color to orange.

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

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

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
Existing environment -
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries.
Azure Resources -
Litware has the following Azure resources:
An Azure Synapse Analytics workspace named synapseworkspace1
An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool -
SQLDW contains a dimensional model that contains the following tables.
 
SQLDW contains the following additional tables.
 
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customerID], dbo.Customer [CustomerEmail], dbo.Product [ProductID] and dbo.Product [ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Power BI -
Litware has a new Power BI tenant that contains an empty workspace named Sales Analytics.
All users have Power BI Premium per user licenses.
IT data analytics are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company’s sales analytics goals. The dataset will be refreshed every 30 minutes.
Requirements -
Analytics Goals -
Litware identifies the following analytics goals:
Provide historical reporting of sales by product and channel over time.
Allow sales managers to perform ad hoc sales reporting with minimal effort.
Perform market basket analysis to understand which products are commonly purchased in the same transaction.
Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Litware plans to monitor the adoption of Power BI reports over time. The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Security Requirements -
Litware identifies the following security requirements for the analytics environment:
All the users in the sales department and the marketing department must be able to see Power BI reports that contain market basket analysis and data about which customers are likely to purchase a product.
Customer contact data in SQLDW and the Power BI dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.
Sales associates must be prevented from seeing the CustomerEmail column in Power BI reports.
Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
Power BI content must be deployed to test and production by using deployment pipelines.
All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power BI reports in Synapse Studio.
How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?

A. an incremental refresh of Product where the ModifiedDate value is during the last three days.

B. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.

C. a full refresh of all the tables

D. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.

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? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. From the Microsoft 365 admin center, create a Microsoft 365 group.

B. From the Power BI Admin center, set Allow live connections to Enabled.

C. From the Power BI Admin center, set Allow service principals to use read-only Power BI admin APIs to Enabled.

D. From the Azure Active Directory admin center, create a security group.

E. From the Power BI Admin center, set Share content with external users to Enabled.

You are using GitHub as a source control solution for an Azure Synapse Studio workspace.
You need to modify the source control solution to use an Azure DevOps Git repository.
What should you do first?

A. Disconnect from the GitHub repository.

B. Create a new pull request.

C. Change the workspace to live mode.

D. Change the active branch.

You have five Power BI reports that contain R script data sources and R visuals.
You need to publish the reports to the Power BI service and configure a daily refresh of datasets.
What should you include in the solution?

A. a Power BI Embedded capacity

B. a workspace that connects to an Azure Data Lake Storage Gen2 account

C. an on-premises data gateway (personal mode)

D. an on-premises data gateway (standard mode)

HOTSPOT
-
You have a team of business analysts that uses Power BI for departmental analytics.
The team creates and manages PBIX files.
You need to implement a source control solution for the PBIX files. The solution must meet the following requirements:
•	Provide version tracking and roll back.
•	Minimize version conflicts between edits.
•	Ensure that all the analysts can access the files.
•	Prevent multiple analysts from editing the same version of a file.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

You have a kiosk that displays a Power BI 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.

A. Configure the data sources to use DirectQuery.

B. Select Auto page refresh.

C. Enable Power BI embedded.

D. Enable the XMLA endpoint.

E. Add a Microsoft Power Automate visual to the report page.

F. Configure the data sources to use a streaming dataset.

DRAG DROP -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
Contoso, Ltd. is a company that sells enriched financial data to a variety of external customers.
Contoso has a main office in Los Angeles and two branch offices in New York and Seattle.
Existing Environment -
Data Infrastructure -
Contoso has a 50-TB data warehouse that uses an instance of SQL Server on Azure Virtual Machines.
The data warehouse populates an Azure Synapse Analytics workspace that is accessed by the external customers. Currently, the customers can access all the data.
Contoso has one Power BI workspace named FinData that contains a single dataset. The dataset contains financial data from around the world. The workspace is used by 10 internal users and one external customer. The dataset has the following two data sources: the data warehouse and the Synapse Analytics serverless SQL pool.
Users frequently query the Synapse Analytics workspace by using Transact-SQL.
User Problems -
Contoso identifies the following user issues:
Some users indicate that the visuals in Power BI reports are slow to render when making filter selections.
Users indicate that queries against the serverless SQL pool fail occasionally because the size of tempdb has been exceeded.
Users indicate that the data in Power BI reports is stale. You discover that the refresh process of the Power BI model occasionally times out.
Planned Changes -
Contoso plans to implement the following changes:
Into the existing Power BI dataset, integrate an external data source in JSON that is accessible by using the REST API.
Build a new dataset in the FinData workspace by using data from the Synapse Analytics dedicated SQL pool.
Provide all the customers with their own Power BI workspace to create their own reports. Each workspace will use the new dataset in the FinData workspace.
Implement subscription levels for the customers. Each subscription level will provide access to specific rows of financial data.
Deploy prebuilt datasets to Power BI to simplify the query experience of the customers.
Provide internal users with the ability to incorporate machine learning models loaded to the dedicated SQL pool.
You need to integrate the external data source to support the planned changes.
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.
 

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?

A. Change the Data source settings in the dataflow queries.

B. Disable load for all dataflow queries.

C. Delete the dataflow queries.

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Overview -
Existing environment -
Litware, Inc. is a retail company that sells outdoor recreational goods and accessories. The company sells goods both online and its stores located in six countries.
Azure Resources -
Litware has the following Azure resources:
An Azure Synapse Analytics workspace named synapseworkspace1
An Azure Data Lake Storage Gen2 account named datalake1 that is associated with synapseworkspace1
A Synapse Analytics dedicated SQL pool named SQLDW
Dedicated SQL Pool -
SQLDW contains a dimensional model that contains the following tables.
 
SQLDW contains the following additional tables.
 
SQLDW contains a view named dbo.CustomerPurchases that creates a distinct list of values from dbo.Customer [customerID], dbo.Customer [CustomerEmail], dbo.Product [ProductID] and dbo.Product [ProductName].
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Power BI -
Litware has a new Power BI tenant that contains an empty workspace named Sales Analytics.
All users have Power BI Premium per user licenses.
IT data analytics are workspace administrators. The IT data analysts will create datasets and reports.
A single imported dataset will be created to support the company’s sales analytics goals. The dataset will be refreshed every 30 minutes.
Requirements -
Analytics Goals -
Litware identifies the following analytics goals:
Provide historical reporting of sales by product and channel over time.
Allow sales managers to perform ad hoc sales reporting with minimal effort.
Perform market basket analysis to understand which products are commonly purchased in the same transaction.
Identify which customers should receive promotional emails based on their likelihood of purchasing promoted products.
Litware plans to monitor the adoption of Power BI reports over time. The company wants custom Power BI usage reporting that includes the percent change of users that view reports in the Sales Analytics workspace each month.
Security Requirements -
Litware identifies the following security requirements for the analytics environment:
All the users in the sales department and the marketing department must be able to see Power BI reports that contain market basket analysis and data about which customers are likely to purchase a product.
Customer contact data in SQLDW and the Power BI dataset must be labeled as Sensitive. Records must be kept of any users that use the sensitive data.
Sales associates must be prevented from seeing the CustomerEmail column in Power BI reports.
Sales managers must be prevented from modifying reports created by other users.
Development Process Requirements
Litware identifies the following development process requirements:
SQLDW and datalake1 will act as the development environment. Once feature development is complete, all entities in synapseworkspace1 will be promoted to a test workspace, and then to a production workspace.
Power BI content must be deployed to test and production by using deployment pipelines.
All SQL scripts must be stored in Azure Repos.
The IT data analysts prefer to build Power BI reports in Synapse Studio.
You need to configure the Sales Analytics workspace to meet the ad hoc reporting requirements.
What should you do?

A. Grant the sales managers the Build permission for the existing Power BI datasets.

B. Grant the sales managers admin access to the existing Power BI workspace.

C. Create a deployment pipeline and grant the sales managers access to the pipeline.

D. Create a PBIT file and distribute the file to the sales managers.

DRAG DROP -
You are configuring Azure Synapse Analytics pools to support the Azure Active Directory groups shown in the following table.
 
Which type of pool should each group use? To answer, drag the appropriate pool types to the groups. Each pool type 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.
 

You have a group of data scientists who must create machine learning models and run periodic experiments on a large dataset.
You need to recommend an Azure Synapse Analytics pool for the data scientists. The solution must minimize costs.
Which type of pool should you recommend?

A. a Data Explorer pool

B. an Apache Spark pool

C. a dedicated SQL pool

D. a serverless SQL pool

You have a Power BI 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. Change the icons to use a different shape for each color.

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

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

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 a Power BI Premium capacity.
From the Power BI Premium Capacity Metrics app, you discover the following:
•	There is insufficient CPU to execute dataset refreshes.
•	Out-of-memory throttling occurs when the dataset is waiting.
You need to recommend a solution to resolve the performance issues.
Solution: You scale up the capacity.
Does this meet the goal?

A. Yes

B. No

DRAG DROP
-
You have a Power BI data model that contains two tables named Products and Sales.
A one-to-many relationship exists between the tables.
You have a report that contains a report-level filter for Products.
You need to create a DAX measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.
How should you complete the measure? To answer, drag the appropriate DAX functions to the correct targets. Each function 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.