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.

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

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

You have an Azure Synapse Analytics workspace that is connected to a data lake.
You train an Open Neural Network Exchange (ONNX) model named Model1.
You need to implement Model1.
What should you do first?

A. Score Model1 by using OPENJSON().

B. Load Model1 into a binary variable.

C. Load Model1 into a character variable.

D. Score Model1 by using PREDICT().

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?

A. rollup

B. freqItems

C. explain

D. describe

HOTSPOT -
You have an Azure Synapse notebook.
You need to create the visual shown in the following exhibit.
 
How should you complete the code? 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.

HOTSPOT -
You have an Azure Synapse workspace named Workspace1.
You need to use PySpark in a notebook to read data from a SQL pool as an Apache Spark DataFrame and display the top five rows.
How should you complete the code? To answer, select the appropriate options in the answer area.
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.

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

You are creating an external table by using an Apache Spark pool in Azure Synapse Analytics. The table will contain more than 20 million rows partitioned by date. The table will be shared with the SQL engines.
You need to minimize how long it takes for a serverless SQL pool to execute a query data against the table.
In which file format should you recommend storing the table data?

A. CSV

B. Delta

C. JSON

D. Apache Parquet

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.
You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use OPENROWSET and infer the schema shown in the following table.
 
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend defining an external table for the Parquet files and updating the query to use the table.
Does this meet the goal?

A. Yes

B. No

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?

A. freqItems

B. corr

C. summary

D. rollup

You have a Power BI tenant that is linked to an Azure AD tenant. The tenant contains a group named Group1.
You create a paginated report that does NOT use row-level security (RLS).
You need to send a copy of the report to Group1 every Monday at 9 AM UTC.
Which two actions should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Create a subscription for Group1.

B. Publish the paginated report to a Pro workspace.

C. Create a data alert for Group1.

D. Publish the paginated report to a Premium Per User workspace.

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.
You need to recommend changes to the Power BI tenant to meet the technical requirements for external data sharing.
Which tenant setting should you recommend disabling?

A. Allow shareable links to grant access to everyone in your organization

B. Allow Azure Active Directory guest users to edit and manage content in the organization

C. Users can reassign personal workspaces

D. Show Azure Active Directory guests in lists of suggested people

HOTSPOT -
You are using an Azure Synapse notebook to create a Python visual.
You run the following code cell to import a dataset named Iris.
 
A sample of the data is shown in the following table.
 
You need to create the visual shown in the exhibit. (Click the Exhibit tab.)
 
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.
 

DRAG DROP -
You are using DAX Studio to query an XMLA endpoint.
You need to identify the duplicate values in a column named Email in a table named Subscription.
How should you complete the DAX expression? 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.
 

You have a Power BI tenant and an Azure subscription named Sub1. The Power BI tenant and Sub1 are linked to a single Azure AD tenant.
In Sub1, you create a storage account named storage1.
You need to configure a Power BI workspace to store dataflows in storage1. The solution must use the principle of least privilege.
Which three roles should you assign for storage1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Reader

B. Storage Blob Data Contributor

C. Contributor

D. Owner

E. Storage Blob Data Owner

F. Storage Blob Data Reader

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.

HOTSPOT
-
You have an Azure Synapse Analytics workspace that contains an Apache Spark pool.
You create a notebook and configure a cell that runs the following SparkSQL query.
SELECT ProductID, ProductName, Category
From products
-
You need to create a column chart by using the built-in charting capability. The solution must visualize the distribution of product IDs across product categories.
How should you complete the column chart? To answer, select the appropriate options in the answer area.
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.
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 creating a perspective that contains the commonly used fields.
Does this meet the goal?

A. Yes

B. No

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 create Power BI 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.
 

You have a Power BI report hosted on the Power BI service. The report displays expenses by department for department managers and contains a line chart that shows expenses by month.
You need to ensure that users can choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.
What should you do?

A. Create a mobile report that contains a column chart.

B. Add a column chart a bookmark, and a button for users to choose a visual.

C. Enable report readers to personalize visuals.

D. Create a separate report page for users to view a column chart.

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 remove the IoT ID column and retain the IoT GUID column.
Does this meet the goal?

A. Yes

B. No

HOTSPOT
-
You deploy an 80-GB compressed data model to a Power BI Premium workspace.
You discover that the model has the following issues:
•	The model recently increased excessively in size.
•	Date columns are formatted inconsistently.
•	Measures calculate slowly.
Which tool should you use to troubleshoot each issue? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

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

A. Remove the data source permissions.

B. Delete all the Power Query Editor objects.

C. Modify the source of each query.

D. Update all the parameter values.

E. Delete all the calculated tables.

You have a Power BI report named Report1. Report1 is connected to an imported dataset that contains a matrix. The matrix displays five measures.
When users view the report, they discover that the matrix is slow to render.
You need to review the execution times and durations in the formula engine and the storage engine for the DAX query executed by the matrix.
What should you use?

A. DAX Studio

B. SQL Server Profiler

C. Performance analyzer

D. Vertipaq Analyzer

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?

A. summary

B. explain

C. cov

D. corr

HOTSPOT
-
You have a Power BI tenant that uses a primary domain named fabrikam.com and contains a Power BI Premium workspace named Workspace1. Workspace1 contains a dataset named DS1. DS1 is an imported model that has one data source.
You have a guest user named
user1@contoso.com
that is assigned the Contributor role for Workspace1.
You need to ensure that User1 can connect to the XMLA endpoint of DS1.
How should you complete the URL of the XMLA connection? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

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 Query query in a Power BI report. The query maps source database columns to the input columns of a time series machine learning model.
You discover that the model fails to process a source time field.
You need to ensure that the model processes the field.
Solution: You convert the time column into the Text data type.
Does this meet the requirement?

A. Yes

B. No

You are optimizing a dataflow in a Power BI 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. Execute foldable operations before non-foldable operations.

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

C. Execute non-foldable operations before foldable operations.

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

E. Reduce the memory assigned to the dataflows.

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 recommend a solution to add new fields to the financial data Power BI dataset with data from the Microsoft SQL Server data warehouse.
What should you include in the recommendation?

A. Azure Purview

B. an XMLA endpoint

C. Site-to-Site VPN

D. the on-premises data gateway

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

B. CONVERT

C. FIRST_VALUE

D. FOR_JSON

HOTSPOT
-
You have a hybrid tenant in Microsoft Azure Active Directory (AD), part of Microsoft Entra, that syncs by using Azure AD Connect.
You are building a dataset by using Power BI Desktop. The dataset will be deployed to the Power BI service.
You need to implement object-level security (OLS) based on a table named User Corporate Role that contains the following two columns:
•	User: Contains user identities synced from on-premises Active Directory in the form of Domainuser
•	Corporate Role: A text column
What should you use to configure OLS, and which Power BI function should you use to retrieve the user identities? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
 

You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request.
Which type of authentication should you use?

A. organizational account

B. Basic

C. Web API

D. Anonymous

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.
You are using an Azure Synapse Analytics serverless SQL pool to query a collection of Apache Parquet files by using automatic schema inference. The files contain more than 40 million rows of UTF-8-encoded business names, survey names, and participant counts. The database is configured to use the default collation.
The queries use OPENROWSET and infer the schema shown in the following table.
 
You need to recommend changes to the queries to reduce I/O reads and tempdb usage.
Solution: You recommend using OPENROWSET WITH to explicitly specify the maximum length for businessName and surveyName.
Does this meet the goal?

A. Yes

B. No

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.
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 DAX Studio, you write a query that uses grouping sets.
Does this meet the goal?

A. Yes

B. No

HOTSPOT -
You are creating a Power BI 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.
 

HOTSPOT -
You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files representing hourly telemetry data. The data is organized in folders by the year, month, and day according to when the telemetry was captured.
You have the following query in Power Query Editor.
 
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
 

You have a development workspace in the Power BI service.
You plan to use Tabular Editor to develop and deploy a new dataset, and then use Power BI Desktop to create and publish a report to the Power BI service.
Which three components should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. the Read Write XMLA endpoint in a capacity

B. a Premium Per User workspace

C. the Read Write XMLA endpoint in the tenant

D. a .pbix file that has an imported dataset

E. a .pbix file that has a live connection

You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibit. (Click the Tables tab.)
 
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.)
 
You need to reduce the model size by eliminating invalid relationships.
Which column should you remove?

A. Sales[Sales Amount]

B. Sales[Row ID]

C. Sales[Sales ID]

D. Plan[Row ID]

You are configuring a Power BI report for accessibility as shown in the following table.
 
You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.
Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Theme colors

B. Divergent colors

C. Sentiment colors

D. First-level elements colors

You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model.
You change a fact table named Table1 into a hybrid table.
What else occurred on DM1 automatically after the change?

A. Table1 was removed from the scheduled refresh.

B. Dimension tables that relate to Table1 were changed to dual storage mode.

C. A related aggregation table was created.

D. A DirectQuery partition was added to Table1.

You have a Power BI tenant that contains 10 workspaces.
You need to create dataflows in three of the workspaces. The solution must ensure that data engineers can access the resulting data by using Azure Data Factory.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Create and save the dataflows to the internal storage of Power BI.

B. Add the managed identity for Data Factory as a member of the workspaces.

C. Associate the Power BI tenant to an Azure Data Lake Storage account.

D. Create and save the dataflows to an Azure Data Lake Storage account.

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

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.
Which two possible tools can you use to identify what causes the report to render slowly? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Synapse Studio

B. DAX Studio

C. Azure Data Studio

D. Performance analyzer in Power BI Desktop

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

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 a file named File1.txt that has the following characteristics:
A header row -
Tab delimited values -
UNIX-style line endings -
You need to read File1.txt by using an Azure Synapse Analytics serverless SQL pool.
Which query should you execute?

A. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘t’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 2 -)

B. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘,’,ROWTERMINATOR = ‘n’,FIRSTROW= 2 -)

C. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘,’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 2 -)

D. SELECT*FROM OPENROWSET(BULK ‘file1.txt’,DATA_SOURCE = ‘Sql1’,FORMAT = ‘CSV’, PARSER_VERSION = ‘2.0’,FIELDTERMINATOR = ‘t’,ROWTERMINATOR = ‘0x0a’,FIRSTROW= 1 -)

You have a Power BI report that contains a bar chart. The bar chart displays sales by country.
You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader.
What should you configure on the bar chart?

A. conditional formatting

B. the layer order

C. alt text

D. the tab order