Free Microsoft Power BI Data Analyst Exam PL-300 Exam Practice Test

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?

• 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

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.Does this meet the goal?

• Yes
• No

You are creating a visual to show the ranking of product categories by sales revenue.Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenantWhich approach provides the widest variety of visuals while adhering to the security policy?

• Use default visuals or custom visuals uploaded from a .pbiviz file.
• Use only default visuals.
• Use default or any custom visuals from the marketplace.
• Use default or certified custom visuals.

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create a median line by using the Salary measure.Does this meet the goal?

• Yes
• No

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

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.In powerbi.com, when users load the visual, they only see some of the customers.What is the cause of the issue?

• The visual was built by using a different version of R.
• The data comes from a Microsoft SQL Server source.
• The data is deduplicated.
• Too many records were sent to the visual.

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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:Due DateOrder DateDelivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?

• Yes
• No

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&

• You have a table named Customer that has the following measure. Customer Count = DISTINCTCOUNT(Customer[CustomerID]) Users frequently refer to customers as subscribers. You need to ensure that the users can get a useful result for 'subscriber count' by using Q&A. The solution must minimize the size of the model. What should you do?
• Add a description of 'subscriber count' to the Customer Count measure.
• Set Summarize By to None for the CustomerlD column.
• Add a description of 'Subscriber' to the Customer table.
• Add a synonym of 'subscriber' to the Customer table.

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:Customer IDCustomer NamePhoneEmail AddressAddress IDAddress contains the following columns:Address IDAddress Line 1Address Line 2CityState/RegionCountryPostal CodeThe Customer ID and Address ID columns represent unique rows.You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.What should you do?

• Merge the Customer and Address tables.
• Transpose the Customer and Address tables.
• Group the Customer and Address tables by the Address ID column.
• Append the Customer and Address tables.

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.What should you do?

• From each report in powerbi.com. select Refresh visuals
• From Power Bl Desktop, download the PBIX file and refresh the data.
• Configure a scheduled refresh without using an on-premises data gateway.
• Configure a scheduled refresh by using an on-premises data gateway