NEW QUESTION 1
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a user named User!. User1 is a member of a security group named Contoso PowerB1. User1 has access to a workspace named Contoso Workspace.
You need to prevent User1 from exporting data from the visualizations in Contoso Workspace. Solution: From the Power B1 Admin portal, you modify the Tenant settings.

• A. Yes
• B. No

Answer: B

NEW QUESTION 2
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario.
You need to create a measure of Sales[SalesAmount] where Product[Color] is Red or Product[Size] is 50. Which DAX formula should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: C

NEW QUESTION 3
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one
correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.
You need to recreate the Power View sheets as reports in the Power BI service.
Solution: From the Power BI service, get the data from SharePoint Online, and then click Import. Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

NEW QUESTION 4
You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource. What should you do?

• A. From the app workspace, click Update app, configure the Content settings, and then click Update app.
• B. From the app workspace settings, add a member.
• C. From the app workspace, click Update app, configure the Access setting, and then click Update app.
• D. From the app workspace, share the dashboard.

Answer: C

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource

NEW QUESTION 5
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain data information:
Date[Month] in the mmyyyy format
Date[Date_ID] in the ddmmyyyy format
Date[Date_name] in the mm/dd/yyyy format
Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI desktop to create an analytics solution for the data. End of repeated scenario.
You need to display the month as a three-letter abbreviation, followed by the year, such as jan2021. You add a calculated column in Power BI.
Which DAX formula should you use for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view continent.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
CONCATENATE MMM
References: https://msdn.microsoft.com/en-us/library/ee634811.aspx

NEW QUESTION 6
You open the Power BI Admin portal as shown in the following graphic.

All the app workspaces use the customer’s capacity.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
References:
https://docs.microsoft.com/en-us/azure/power-bi-embedded/scale-capacity https://docs.microsoft.com/en-us/power-bi/developer/embed-sample-for-customers

NEW QUESTION 7
You have the following tables.

You need to create a new table that displays the top 10 customers by the total of SalesAmount.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 8
You have an app workspace that contains two datasets named dataset1 and dataset2. Dataset1 connects to a Microsoft Azure SQL database. Dataset2 connects to a Microsoft Excel file stored in Microsoft OneDrive for Business.
You create a report named Report1 that uses dataset1. You pin Report1 to a dashboard named Dashboard1.
You publish the app workspace to all the users in your organization. You need to delete dataset2 from the app workspace.
What should you do first?

• A. Delete Dashboard1.
• B. Delete Report1.
• C. Unpublish the app.
• D. Configure the refresh settings for Dataset2.

Answer: C

NEW QUESTION 9
You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data. In Power BI Desktop, you have the following query for the cube.

The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records. You need to ensure that the query retrieves all 26,423 records.
What should you do?

• A. From Query Editor, refresh all the data.
• B. Change the query to use Live connection mode.
• C. Delete the Remove Duplicates step.
• D. Add an Unpivot Columns step.

Answer: C

NEW QUESTION 10
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Funnel charts
• B. Custom visuals
• C. Bubble maps
• D. Breadcrumbs
• E. R visuals

Answer: DE

Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart-powerbi-report/

NEW QUESTION 11
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario.
You are implementing the Power BI model.
You need to edit the Product Category query to match the desired Power BI model.
How should you complete the advanced query? To answer, drag the appropriate values to the correct 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 pint.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
Box 1: Table.RemoveColumns
Box 2: Table.RenameColumns References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx https://msdn.microsoft.com/en-us/library/mt260808.aspx

NEW QUESTION 12
You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source. You need to ensure that you can use R visualization.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

• A. Download and install Microsoft R Server.
• B. Download and install RStudio Server on the computer that has Power BI Desktop installed.
• C. Install SQL Server R Services on the server that runs SQL Server.
• D. Enable R Scripting on the computer that has Power BI Desktop installed.
• E. Download and install Microsoft R on the computer that has Power BI Desktop installed.

Answer: E

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals

NEW QUESTION 13
You have a power BI model that contains the following tables:
Assets( AssetsID, AssetName, Purchase_DateID, Value)
Date( DateID, Date, Month, Week, Year)
The tables have relationship. Date is marked as a date table in the Power BI model.
You need to create a measure to calculate the percentage that the total assets value increased since one year ago.
Which DAX formula should you use?

• A. (sum(Assets[Value])–CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(‘Date’[Date])))/CALCULATE(sum(A(‘Date’ [Date]))
• B. CALCULATEx(sum(Assets[Value]) DATESYTD (‘Date’[Date]))/sum(Assets[Value])
• C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (‘Date’ [Date]))
• D. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (‘Date’ [Date]))/sum(Assets[Value])

Answer: C

Explanation:
References:
https://msdn.microsoft.com/en-us/library/ee634825.aspx https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics
https://msdn.microsoft.com/en-us/library/ee634972.aspx

NEW QUESTION 14
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory[Subcategory] contains NULL values. End of Repeated Scenario.
You implement the Power BI model.
You plan to add a table named Date to the model. The table will have columns for the date, year, month, and end of the last month, and will include data from January 1, 2013 to December 31, 2015.
The Date table and the Sales table will have a relationship. Which DAX functions should you use to create the columns?

• A. CALENDARAUTO, YEAR, MONTH, and EOMONTH
• B. CALENDAR, YEAR, MONTH, and ENDOFMONTH
• C. CALENDARAUTO, YEAR, MONTH, and ENDOFMONTH
• D. CALENDAR, YEAR, MONTH, and EOMONTH

Answer: D

Explanation:
References:
https://msdn.microsoft.com/en-us/query-bi/dax/calendar-function-dax https://msdn.microsoft.com/en-us/query-bi/dax/year-function-dax https://msdn.microsoft.com/en-us/query-bi/dax/month-function-dax https://msdn.microsoft.com/en-us/query-bi/dax/eomonth-function-dax

NEW QUESTION 15
You have two tables named Customer and Orders. A sample of the Data in Customer is shown in the following table.

A sample of the data in Orders is shown in the following table.

You need to create the following new table.

You must use Customer as the first table. Which join kind should you use?

• A. Right Anti
• B. Right Outer
• C. Left Anti
• D. Left Outer
• E. Inner

Answer: D

NEW QUESTION 16
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year.
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?

• A. Pin each visualization to the dashboard, and then add a web content tile.
• B. Add a page level filter, and then pin each visualization to the dashboard.
• C. Publish the app workspace.
• D. Pin the report as a live page.

Answer: D

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-live-tile-from-report

NEW QUESTION 17
You have a Power BI model for sales data.
You need to create a measure to calculate the year-to-date sales and to compare those sales to the previous year for the same time period.
Which DAX function should you use?

• A. PARALLELPERIOD
• B. SAMEPERIODLAST YEAR
• C. DATESYTD
• D. PREVIOUSYEAR

Answer: A

Explanation:
References: https://msdn.microsoft.com/en-us/library/ee634873.aspx

NEW QUESTION 18
You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the exhibit).

The model has the following relationships:
Store the District based on DistrictID
Sales to Store based on LocationID
Sales to Date based on PeriodID
Sales to Item based on ItemID
You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.
When the district managers view the sales report, they see Sales by Items for all stores.
You need to ensure that the district managers can see Sales by items for the stores they manage only. How should you configure the relationship from Sales to Item?

• A. Change the Cardinality to One to one (1:1).
• B. Change the Cardinality to One to Many (1.*).
• C. Select Assume Referential Integrity.
• D. Change the Cross filter direction to Both.

Answer: D

Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-admin-rls/

NEW QUESTION 19
Your organization has a team of power users who recently created 20 Power BI dashboards. The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards. What should you do first?

• A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
• B. From the Power BI Admin portal, modify the Privacy Settings.
• C. From the properties of each dashboard, modify the Share dashboard settings.
• D. Instruct each user to install Microsoft Office 2021.

Answer: A

Explanation:
References:
http://www.nubo.eu/en/blog/2021/12/Enable-PowerBI-On-Office-365/

NEW QUESTION 20
Your company has a custom line-of-business application named SalesApp.
The developers of SalesApp want to push data into the Power BI service to create several visualizations. You need to ensure that the developers can push the data from SalesApp to the Power BI service.
What should you do?

• A. Go to portal.azure.com and create a web app.
• B. Go to dev.powerbi.com/apps and register an application.
• C. Go to app.powerbi.com/admin-portal and click Publish to web.
• D. Go to app.powerbi.com and create an app workspace.

Answer: B

Explanation:
References:
https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-register-app-with-azure-ad

NEW QUESTION 21
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the
scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values. End of repeated scenario.
You implement the Power BI model.
You need to edit the Product Category table query to match the desired Power BI model.
How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to frag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
References:
https://msdn.microsoft.com/en-us/library/mt260776.aspx https://msdn.microsoft.com/en-us/library/mt260808.aspx

NEW QUESTION 22
You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)

The model has the following relationships:
Store to District based on DistrictID
Sales to Store based on LocationID
Sales to Date based on PeriodID
Sales to Item based on ItemID
You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.
When the district managers view the Store by Items report, they see items for all the stores. You need to ensure that the district managers can see items for the stores they manage only. How should you configure the relationship from Sales to Item?

• A. Select Assume Referential Integrity.
• B. Change the Cardinality to One to Many (1:*).
• C. Change the Cross filter direction to Both.
• D. Change the Cardinality to One to one (1:1).

Answer: C

Explanation:
References: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-admin-rls/

NEW QUESTION 23
You are creating a report in Power BI Desktop. You are consuming the following tables.

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal month and calendar month. What should you do?

• A. Union Fiscal and Date as one table.
• B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
• C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
• D. Merge Fiscal into the Date table.

Answer: D

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

NEW QUESTION 24
Note: This question is a part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a query for a table named Sales. Sales has a column named CustomerID. The Data type of
CustomerID is Whole Number.
You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
You need to ensure that nonnumeric values in the CustomerID column are set to 0. Solution: From Query Editor, select the CustomerID column and click Replace Errors. Does this meet the goal?

• A. Yes
• B. No

Answer: A

Explanation:
References: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

NEW QUESTION 25
......