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

• Question 1:

  What is the minimum number of datasets and storage modes required to support the reports? (What is the minimum number of Power BI datasets needed to support the reports?)

  A. two imported datasets

  B. a single DirectQuery dataset

  C. two DirectQuery datasets

  D. a single imported dataset

  Correct Answer: D

  The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit's data. The analysts must be able to build new reports from the dataset that contains the profit and loss data" => one dataset and two separate workspaces Reason: All data can be imported into one dataset also if these are two logical models. Shared dimensions can be reconsumed in both models.

  Reports and additional materials can be shared to the board with an app. The "profit and loss" data model needs RLS for the analysts and the analysts must have just read access to the original workspace. In a separate workspace with contributer (or more rights) they can create new reports (with live connection to the dataset).

  It is also stated that the new reports mustn't be shared so therefore no need to include them into the app. Import vs. DirectQuery: Due to RLS requirements an imported dataset is needed. It is not possible with file sources and Sharepoint lists.

• Question 2:

  You need to create the dataset. Which dataset mode should you use?

  A. DirectQuery

  B. Import

  C. Live connection

  D. Composite

  Correct Answer: D

• Question 3:

  You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

  A. Change lite OrderlD column in the Orders table to the text data type.

  B. Filter out discontinued products while importing the Product table.

  C. Remove the QuantityPerUnit column from the Products table

  D. Group the Categories table by the CategorylD column.

  Correct Answer: D

• Question 4:

  You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

  A. Add the sales department as a member of the reports workspace

  B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

  C. Distribute an app to the users in the Azure Active Directory group of the sales department.

  D. Share each report to the Azure Active Directory group of the sales department.

  Correct Answer: B

• Question 5:

  You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

  What should you recommend?

  A. Create a shared dataset for each standardized entity.

  B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

  C. For every report, create and use a single shared dataset that contains the standardized data.

  D. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

  Correct Answer: B

• Question 6:

  You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

  A. bar chart

  B. scatterplot

  C. pie chart

  Correct Answer: A

  Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter

  Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.

  The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.

  Reference: https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi

• Question 7:

  You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

  

  A one-to-many relationship exists between the tables.

  The auto date/time option for the data model is enabled.

  You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

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

  NOTE: Each correct answer is worth one point.

  A. Create a relationship between the Date table and the Sales table.

  B. Disable the auto date/time option.

  C. Create a Date table and select Mark as Date Table.

  D. Disable the load on the Date table.

  E. Remove the relationship between the Product table and the Sales table.

  Correct Answer: AC

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases

• Question 8:

  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.

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IOT ID columns are unique to each row in query.

  You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 9:

  You are creating a dashboard by using the Power Bl service.

  You have an existing report page that contains three charts.

  You need to add the charts to the dashboard while maintaining the interactivity between the charts.

  What should you do?

  A. Pin each chart as a tile.

  B. Edit interactions in the report and set all interactions to Filter

  C. Edit the dashboard theme and pin each chart as a file.

  D. Pin the report page as a live tile.

  Correct Answer: D

• Question 10:

  You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity.

  Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Enable query caching for the dataset.

  B. Import the dataset to Microsoft Excel.

  C. From the Power BI service, open a dashboard that uses the dataset.

  D. From the Power BI service, open a report that uses the dataset.

  E. From PowerShell, run the get-powerbireport cmdlet.

  Correct Answer: CD

  After two months of inactivity, scheduled refresh on your dataset is paused. A dataset is considered inactive when no user has visited any dashboard or report built on the dataset. At that time, the dataset owner is sent an email indicating the scheduled refresh is paused. The refresh schedule for the dataset is then displayed as disabled. To resume scheduled refresh, simply revisit any dashboard or report built on the dataset. https://learn.microsoft.com/en-us/power-bi/connectdata/refresh-scheduled- refresh#scheduled-refresh