You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need to ensure that users can use Q&A from the Power BI service for the dataset.What should you do?

From the Power Bi service, select Turn on Q& A for this dataset.

From the Power BI service, add an enterprise gateway to the dataset.

From Power BI Desktop, add synonyms and suggested questions.

From Power BI Desktop, add a Q&A visual to the report.

From the Power Bi service, select Turn on Q& A for this dataset.

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 scenarioYou 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 add a measure to rank total sales by product. The results must appear as shown in the following table. Which DAX formula should you use?

Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Dense)

Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)

Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Dense)

Product Ranking= RANKX (ALL, (‘Product’), [SalesAmount], , DESC, Skip)

Product Ranking= RANKX (ALL (‘Product’), [SalesAmount], , Asc, Dense

You manage a Power BI model has a table named Sales and product.You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”

Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”

Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

In the Power BI service, you create an app workplace that contains several dashboards.You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards. What should you do?

Share the dashboard, and then modify the Access settings of the dashboard.

Modify the members of the app workspace.

Configure security for the dataset used by the app.

Share the dashboard, and then modify the Access settings of the dashboard.

From the app workspace, click Update app, and then configure the Access settings.

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?

From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

From the Power BI Admin portal, modify the Privacy Settings.

From the properties of each dashboard, modify the Share dashboard settings.

Instruct each user to install Microsoft Office 2016.

You embed a Power BI report in a Microsoft SharePoint Online page.A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: “This content isn’t available”. User1 is unable to view the report.You verify that you can access the SharePoint Online page and that the Power BI report displays as expected. You need to ensure that User1 can view the report form SharePoint Online.What should you do?

Modify the members of the app workplace.

Edit the settings of the Power BI web part.

Modify the members of the app workplace.

Share the dashboards in the app workspace.

You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company. The reports display the data configured as shown in the following table. You need to ensure that the users of the reports can locate the correct report by using natural language queries. What should you do?

From the properties of the dataset, modify the Q&A and Cortana settings.

From the properties of the dataset, create four Featured Q&A Questions.

From the Format settings of the reports, modify the Page Information.

From the properties of the dataset, modify the Q&A and Cortana settings.

From the properties of the workspace, modify the Language Settings.

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard.How should you configure the connection to the data source?

Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

You have an on-premises Power BI Report Server.You plan to create a report in Power BI Desktop and publish the report to the report server.Which data source should the report use?

a Microsoft SQL Server Analysis Services (SSAS) database

a Microsoft SQL Server database

a Microsoft SQL Server Analysis Services (SSAS) database

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?

From the app workspace, click Update app, configure the Access setting, and then click Update app.

From the app workspace, click Update app, configure the Content settings, and then click Update app.

From the app workspace settings, add a member.

From the app workspace, click Update app, configure the Access setting, and then click Update app.

From the app workspace, share the dashboard.

You have an app workspace named Retail Analysis in the Power BI service.You need manage the members that have access to the app workspace.What should you do?

From the Office 365 Admin center, click Groups.

From the Power BI Admin portal, click Usage metrics.

From the Office 365 Admin center, click Users.

From the Office 365 Admin center, click Groups.

From the Power BI Admin portal, click Tenant settings.

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 the same in each question in this series.You have a Microsoft SQL Server database that contains the following tables. The following columns contain date 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 formatThe Order table contains more than one million rows.The Store table has a 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.You need to create a relationship between the Monthly_returns table and Date[Date_ID].What should you do before you create the relationship?

In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.

In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.

To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

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 the same in each question in this series.You have a Microsoft SQL Server database that contains the following tables. The following columns contain date 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 formatThe Order table contains more than one million rows.The Store table has a 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.You need to create a relationship between the Order table and the Store table on the Store_ID column. What should you do before you create the relationship?

In the Store table query, use the Table.TrasformColumnTypes function.

In the Order table query, use the Table.TrasformRows function.

In the Store table query, use the Table.TrasformRows function.

In the Store table query, use the Table.TrasformColumnTypes function.

In the Order table query, use the Table.TrasformColumnTypes function.

You have the following table named Location. The GeoCode column represents the country where each customer is located.You create a map visualization as shown in the exhibit. (Click the Exhibit tab.) You need to ensure that the map displays the country locations.What should you do?

Change the name of the GeoCode column to Country.

Replace the values in the GeoCode column with postal codes or zip codes.

Change the name of the GeoCode column to Country.

Change the name of the Location table to Country.

Change the Default Summarization of the GeoCode column.

Add a Geoportal column to the Location table.

Change the Data Type of the GeoCode column.

Microsoft PL-300 Practice Test 4 - Free Online Exam Prep & Questions

You have a report that includes a card visualization.

You need to apply the following conditional formatting to the card while minimizing design effort.

For values that are greater than or equal to 100, the font of the data label must be dark red.

For values that are less than 100, the font of the data label must be dark gray.

Which type of format should you use?

Become a Premium Member for full access

Unlock Premium Member

Microsoft PL-300 Practice Test 4

Question

Microsoft PL-300 Practice Tests

Practice Tests