Microsoft Microsoft Certified: Data Analyst Associate PL-300 Questions & Answers

• Question 11:

  You have a Microsoft Excel file on a file server.

  You create a Power BI report and import a table from the Excel file.

  You publish the report.

  You need to ensure that the data refreshes every four hours.

  What should you do first?

  A. Upload the Excel file to a Power BI workspace.

  B. Create a subscription to the report.

  C. Deploy an on-premises data gateway.

  D. Edit the data source credentials.

  Correct Answer: C

• Question 12:

  You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.

  You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.

  You need to ensure that the data is updated every morning. The solution must minimize configuration effort.

  Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Configure the dataset to use the existing On-premises data gateway.

  B. Deploy an On-premises data gateway in personal mode.

  C. Set the refresh frequency to Daily.

  D. Configure the dataset to use the personal gateway.

  Correct Answer: AC

  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode

• Question 13:

  You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

  You pin the Sales by month visual to Dashboard1.

  In Report1, you change the Sales by month visual to a bar chart.

  You need to ensure that bar chart displays on Dashboard1.

  What should you do?

  A. Edit the details for the dashboard tile of Dashboard1.

  B. Select Refresh visuals for Dashboard1.

  C. the Sales by month bar chart to Dashboard1

  D. Refresh the dataset used by Report1 and Dashboard1.

  Correct Answer: D

• Question 14:

  You have a Power Bl query named Sates that imports the columns shown in the following table.

  

  Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

  You need to reduce the load times of the query without affecting the analysis.

  Which two actions achieve this goal? Each correct answer presents a complete solution.

  NOTL Each correct selection is worth one pant.

  A. Remove the rows in which sales [status] has a value of Canceled.

  B. Change the data type of sale [Delivery_Time] to Integer

  C. Removes (Canceled Date).

  D. Split Sales [Sale_Date] into separate date and time columns.

  E. Remove sales [Sales_Date].

  Correct Answer: AE

  It says: You need to reduce the LOAD times of the query without affecting the analysis. Only answers A and E can reduce the load times. D may reduce only the time needed to process the data. Someone said that E is not the answer because: "All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value". You must read again the decription cause it says " Each answer presents a COMPLETE solutiuon" not part of a solution.

• Question 15:

  You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Add the same slicer to each page and configure Sync slicers.

  B. Edit the interactions of the KPI visualization.

  C. Configure a page-level filter.

  D. Edit the interactions of the slicer that is on the same page as the KPI visualization.

  E. Configure a report-level filter.

  Correct Answer: AD

  Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

  By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

• Question 16:

  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.

  Correct Answer: C

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

• Question 17:

  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 add a new column to the Product Subcategory table that uses the following formula.

  =if [Subcategory] =null then "NA" else [Subcategory]

  Which command should you use in Query Editor?

  A. Column From Examples

  B. Custom Column

  C. Invoke Custom Function

  D. Conditional Column

  Correct Answer: D

  References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

• Question 18:

  You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

  From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.

  You discover that the dataset refresh fails after the refresh runs out of resources.

  What is a possible cause of the issue?

  A. Query folding is not occurring.

  B. You selected Only refresh complete periods.

  C. The data type of the column used to partition the data changed.

  D. A filter is missing on the report.

  Correct Answer: A

  The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called "query folding". It is not recommended that incremental refresh is used when the required query folding cannot take place.

  Reference: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

• Question 19:

  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 tenant

  Which approach provides the widest variety of visuals while adhering to the security policy?

  A. Use default visuals or custom visuals uploaded from a .pbiviz file.

  B. Use only default visuals.

  C. Use default or any custom visuals from the marketplace.

  D. Use default or certified custom visuals.

  Correct Answer: C

• Question 20:

  A manager can represent only a single country.

  You need to use row-level security (RLS) to meet the following requirements:

  The managers must only see the data of their respective country.

  The number of RLS roles must be minimized.

  Which two actions should you perform? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

  B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

  C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

  D. Create one role for each country.

  E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

  Correct Answer: AC

  In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service.

  See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.