PL-300 Exam samples PowerBI

You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. Which visualization should you use? Select only one answer. 1. funnel 2. slicer 3. treemap 4. waterfall

1 (MS) A funnel visualization displays a linear process with sequentially connected stages, with one stage transitioning to the next. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not sequentially connected stages, with one stage transitioning to the next. A treemap visualization displays data as a set of nested rectangles. A waterfall visualization displays a running total as values are added or subtracted.

You are designing a data model in Power BI. You need to avoid introducing ambiguity into your data model design. Which type of cardinality should you avoid? Select only one answer. 1. many-to-many 2. many-to-one 3. one-to-many 4. one-to-one

1 (MS) Many-to-many cardinality in Power BI should be avoided due to ambiguity, resulting from the presence of non-unique values. One-to-one cardinality in Power BI should be avoided and, if present, should be eliminated by combining the related tables. However, this type does not introduce ambiguity. One-to-many and many-to-one cardinality are two common cardinality types, used for the relationships between a fact and dimension tables.

You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do? Select only one answer. 1. Add a separate date dimension table. 2. Add a year, month, and week columns to the fact table. 3. Enable the Auto date/time current file option. 4. Enable the Auto date/time global option.

1 MS Adding a separate date dimension table that includes year, month, and week information is the optimal approach which provides the required functionality, while minimizing the model size and administrative effort. Adding a year, month, and week columns to the fact table would increase the amount of administrative effort. Enabling the Auto date/time global or current file option would increase the model size. In addition, it would not provide the ability to describe weekly time periods (only year, quarter, month, and day).

You use Power BI Desktop to transform a query that retrieves data from an Excel spreadsheet. You need to view and modify multiple steps in all the M code. Which interface should you use? Select only one answer. 1. Advanced Editor in the Power Query Editor 2. Data view 3. Formula Bar in the Power Query Editor 4. Model view

1 MS The Advanced Editor in the Power Query Editor provides the ability to work with all the M code used for shaping data in a query at once. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. The Formula Bar in the Power Query Editor provides the ability to edit only one step at a time.

You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. When importing data from the data source into Power BI, you receive the following error message: "Timeout expired." You verify that network connection to the SQL Server has sufficient available bandwidth and low latency. You need to minimize the occurrences of the timeout issues indicated by the message. What should you do? Select only one answer. 1. Divide the SQL statement into separate data sources. 2. Implement aggregations in the SQL statement. 3. Implement groupings in the SQL statement. 4.Replace subqueries with nested queries.

1 Official MS page training question with answers provided. Dividing the SQL statement into separate data sources would minimize the amount of processing on the SQL Server side. This would minimize or even eliminate the timeout issues. Groupings, aggregations, and using nested queries would either have no impact on timeout issues or further increase the amount of processing on the SQL Server side, resulting in more frequent timeout issues.

Question 9: You have a dataset that contains revenue data from the past year. You need to use anomaly detection in Power BI to show anomalies in the dataset. What should you configure? 1) Chart type: a) Line b) Pie c) Treemap 2) Chart configuration a)Select show value as option b)Enable cross-report drill-through c)Populate the axis with a date field

1 A 2 C Explanation: 1) Line because Anomaly detection is only supported for line chart visuals containing time series data in the Axis field. 2)Incorrect:* Anomaly Explanations doesn't work with 'Show Value As' options. * Drilling down to go to the next level in the hierarchy isn't supported. Reference:https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

Question 22: You are profiling data by using Power Query Editor You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit. There [answer choice] only once A. are 20 values that occur B. are 365 values that occur C. are 277,329 values that occur D. is one value that occurs The Pear, Flowering species is found more often in column1 than the [answer choice] species A. Ash, Green B. Crabapple, Flowering C. Elm, American D. Spruce, Blue

1 A 2 C https://www.examtopics.com/discussions/microsoft/view/85334-exam-pl-300-topic-3-question-25-discussion/

Question 8: UnitsInStock has 75 non-null values, of which 51 are unique. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. 1) When a table visual is created in a report and UnitsInStock is added to the values, there will be [answer choice] in the table: a)0 b) 1 c)51 d)75 2) Changing the Summarize by setting of the UnitsInStock Column, and then adding the column to a table visual will [answer choice] the number of rows in the table visual: a)maintain b)reduce c)increase

1 D 2 B

Question 4 You publish the dataset to powerbi.com. yes/no: *From case study: its Azure SQL database * 1) You need an on-permises data gateway to refresh the dataset 2) You need to configure a scheduled refresh of the dataset 3)You can use Basic authentication on the dataset to connect to the data.

1 N 2 N 3 N Explanation: 1 No (it's Azure SQLDB; cloud based) 2 No (we need Direct Query) 3 No (we use Azure AD; OAuth2) (Direct Query) = Oauth2 (Although some people say that 3 is a YES) https://www.examtopics.com/discussions/microsoft/view/81929-exam-pl-300-topic-13-question-1-discussion/

Question 9: maintain reduce increase You have a Power BI report named Orders that supports the following analysis: • Total sales over time • The count of orders over time • New and repeat customer counts The data model size is nearing the limit for a dataset in shared capacity. [picture] The Orders table relates to the Customers table by using the CustomerID column. The Orders table relates to the Date by using the OrderDate column. YES/NO 1) Summarizing Orders by the CustomerID, OrderID, anda OrderDate columns will reduce the x model size while still supporting the current analysis 2) Removing the CustomerID column from Orders will reduce the model size while still x Supporting the current analysis. 3) Removing the UnitPrice and Discount columns from Orders will reduce the model size while x Still supporting the current analysis.

1 N 2 N 3 Y https://www.examtopics.com/discussions/microsoft/view/82541-exam-pl-300-topic-2-question-35-discussion/

Question 7: You have a Power Bl report You have the following tables. You have the following DAX measure. Accounts = CALCULATE ( DISTINCTCOUNT (Balances[AccountID]), LASTDATE ('Date'[Date] ) For each of the following statements, select YES if the statement is true. Otherwise, select NO. 1) A table visual that displays the date hierarchy at the year level and the [Accounts ] measure x will show the total number of accounts that were live throughout the year. 2) A table visual that displays the date hierarchy at the month level and the [Accounts ] x measure will show the total number of accounts that were live throughout the month. 3) A table visual that displays the date hierarchy at the day level and the [Accounts ] measure x will show the total number of accounts that were live that day.

1 N 2 N 3 Y Explanation: The date is hierarchy, the lastdate() is based on the hierarchy, which means the measure should be adjusted with the year/month/day level. LASTDATE will return the last date from the current context. If the context is the Year, the last date will be 31/12/year. If the context is the Day, LASTDATE will return the day itself https://learn.microsoft.com/en-us/dax/lastdate-function-dax Source: discussion on https://www.examtopics.com/discussions/microsoft/view/80017-exam-pl-300-topic-2-question-25-discussion/

You have a query named FactSales that retrieves data from a SQL Server table. You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes. You select the existing columns in the query. Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution. Select all answers that apply. 1. Choose Columns 2. Remove Columns 3. Remove Other Columns 4. Transpose

1, 3 MS Using the Choose Columns and Remove Other Columns options will allow you to explicitly select the columns that you want to keep. This enforces the requirement that new columns will not be automatically added in the future. Using Remove Columns will delete the existing columns in the table, and new columns that get added in the future will still be imported automatically. Transpose treats rows as columns, and columns as rows. It will not limit the number of columns being imported.

You have a Power BI dataset. You need to set the dataset as discoverable. Which two configurations will allow the dataset to be marked as discoverable? Each correct answer presents a complete solution. Select all answers that apply. 1. Certify the dataset. 2. Enable RLS on the dataset. 3. Promote the dataset. 4. Publish dataset to a Premium workspace

1, 3 (MS) A certified dataset can be configured to be discoverable for users without access to request permissions to access. A promoted dataset can be configured to be discoverable for users without access to request permissions to access. RLS is not required on a dataset to become discoverable. Premium (capacity or shared) is not required to make a dataset discoverable.

You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety of reports. Which three objects from a report page can be pinned to the dashboard? Select all answers that apply. 1. Custom visual 2. Filter 3. Image 4. Ribbon chart 5. Slicer

1, 3, 4 (MS) Individual filters and slicers cannot be pinned to a dashboard. This is because dashboards are designed to be an "at-a-glance" perspective. Reports are built to be filtered and interactive. Custom visuals, ribbon charts, and images can be pinned from a report page.

In Power BI Desktop, you need to create a measure. Which two interfaces can you use? Each correct answer presents a complete the solution. Select all answers that apply. 1. Data view 2. Model view 3. Page view 4. Power Query Editor 5. Report view

1,5 The Report view provides the ability to create measures. To create a measure, use the context sensitive menu of the Fields list or the Calculations section of the ribbon. The Data view provides access to data within a dataset and includes the option to create a measure in the Calculations section of the ribbon. Model view, Page view, and Power Query Editor do not include the option to create a measure.

You create a Power BI Desktop dataset by importing and transforming a data source based on multiple tables in a SQL Server database. You need to modify the relationship between the tables. Which interface should you use in the Power BI Desktop? Select only one answer. 1. Data view 2. Model view 3. Page view 4. Report view

2 (MS) The relationship between tables is configurable from the Model view. The Data view provides access to data within a dataset. The Report view provides the ability to build reports. The Page view is an option available from within the Report view and is intended to simplify designing and building reports.

You have a Power BI model with the following fact tables and storage modes. FactStoreSales (Import mode) FactOnlineSales (DirectQuery mode) You have a dimension table named DimCalendar that has a relationship to both fact tables. You need to assign a storage mode for DimCalendar. The solution must minimize the time to execute queries that combine data from the dimension table and the fact tables. Which storage mode should you use? Select only one answer. 1. DirectQuery 2. Dual 3. Import 4. none

2 (MS) Using Dual mode means that either an import query can be run when accessing data from FactStoreSales, or a DirectQuery query can be run when accessing data from FactOnlineSales. Using Import mode means the queries are only optimized for FactStoreSales (Import). Using DirectQuery mode means the queries are only optimized for FactOnlineSales (DirectQuery). A storage mode of Import, DirectQuery, or Dual must be assigned.

From Power BI Desktop, you create a data source by importing an Excel file. You plan to identify data anomalies within the data source. Which interface should you use to display the column distribution and column quality graphs? Select only one answer. 1. Advanced Editor in Power Query Editor 2. Power Query Editor 3. the Data view 4. the Model view

2 Official MS page training question with answers provided (MS) Power Query Editor provides the ability to display the column distribution and column quality graphs. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. Advanced Editor of Power Query Editor provides the ability to work with the M code used for shaping data in Power Query Editor.

You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. After you import data from the data source into Power BI, you notice that one of the columns in the resulting dataset appears blank. You verify that the source table does include data. What should you do to resolve the issue? 1. Clear permissions on the data source in Power BI. 2. Use the CAST function in the SQL statement. 3. Use the DATALENGTH function in the SQL statement. 4. Set the privacy levels on the data source

2 Official MS page training question with answers provided. The issue indicates that Power BI is incorrectly interpreting the data type used by the source column. To resolve it, you need to explicitly specify the intended data type, which can be done by using the CAST function. DATALENGTH displays the number of bytes used to represent an expression. Clearing permissions could prevent Power BI from being able to access the target database. Setting the privacy levels of the data source would have no impact on addressing the issue of missing data.

You plan to create a report in Power BI Desktop. You need to create a visualization that displays data in two or more dimensions and cross-highlights with other visuals on the same report page. Which type of visualization should you use? Select only one answer. 1. Card 2. matrix 3. scatter 4. table

2 (MS) A matrix visualization displays data in two or more dimensions and cross-highlights with other visuals on the same report page. A card visualization displays a single data point. A scatter visualization is a chart, not a grid. It has two value axes, with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. A table visualization is a grid that contains related data in a grid format, with support for two dimensions only.

Question 6: You plan to create a report that will display sales data from the last year for multiple regions, You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? Actions 1. Assign users to the role 2. Import the data to Power BI Desktop 3. Add a filter to the report. 4. Create a role definition. 5. Publish the report

2-> 4 -> 5 -> 1 Explanation: Steps of RLS taken from MS documentation: a. Create a report in Microsoft Power BI Desktop. b. Import the data. (2) c. Confirm the semantic model between both tables. d. Create the report visuals. e. Create RLS roles in Power BI Desktop by using DAX. (4) f. Test the roles in Power BI Desktop. g. Deploy the report to Microsoft Power BI service. (5) h. Add members to the role in Power BI service. (1) i. Test the roles in Power BI service. https://learn.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method

You need to create a report in Power BI Desktop that will display the sales data of your company such that customers of a similar age will be grouped into clusters. Which visual should you add to the report? Select only one answer. 1. card 2. gauge 3. scatter 4. treemap

3 (MS) Creating a scatter visual is the first step of applying the clustering technique that groups data into clusters. Card, gauge, and treemap visuals do not support clustering.

You have a bar chart and column chart visual on a report page. Selecting any column from the bar chart visual filters the column chart data to less than 1% of its unfiltered value. Which type of visual interaction should be used when the bar chart is filtering the column chart to ensure that you can easily see the data? Select only one answer. 1. expand 2. drillthrough 3. filter 4. highlight

3 (MS) Filter will show you the filtered data in this visual. So even when showing filtered data that is less than 1% of the unfiltered value, it will still display well in the column visual. Highlight shows you both the unfiltered and filtered values in the visual, for comparison purposes. Drillthrough is a page navigation experience that takes you from one page to another plus applies a set of filters to page navigated to. Expand is a way to navigate down a level using the hierarchy controls.

You have a collection of datasets and reports. You need to share the datasets and report together. This solution must NOT send any email notifications to internal users after sharing. What should you create in the Power BI Service? Select only one answer. 1 a deployment pipeline 2 a workspace 3 an app 4 metrics

3 (MS) Workspace apps can be installed automatically for any user in an organization, and without requiring notifications of installation. Deployment pipelines are used for moving artifacts between test, development, and production environments. Metrics are where you can create goals based off existing datasets. You can add members to a workspace, but they receive a notification that they've been added to the workspace.

You have a Power BI data source that contains the following tables: ProductCategory: Lists the product category ID and category name ProductSubcategory: Lists the product subcategory ID, subcategory name, and the related category ID ProductList: Lists the product ID, name, and subcategory ID You need to optimize the data to create a dimension for use in a star schema data model. How should the tables be transformed before loading into the model? Select only one answer. 1. Import all three tables into the data model and connect them using relationships. 2. Import only the ProductName table into the model. 3. Merge the queries to create a single loaded table for Product. 4. Use the append command to create a single loaded table for product.

3 MS A star schema should have a single table for each dimension or product, so using the combine command is what is required to create a single product table and aim towards a star schema design.

From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows. You plan to identify data anomalies within the data source. You need to ensure that column distribution considers all rows in the Excel file. What should you do? Select only one answer. 1. In the Data Source Settings, modify the Advanced settings. 2. In the Data Source Settings, modify the Edit Permissions settings. 3. In the Power Query Editor window, enable the Column Profile view. 4. In the Power Query Editor window, modify the Query Settings.

3 Official MS page training question with answers provided. By default, Power BI uses the top 1,000 rows for profiling. To ensure that column distribution considers all rows in the Excel file, you need to modify the Power Query Editor profiling status setting. The Power Query Editor settings, Advanced settings, and Permissions settings have no bearing on the profiling characteristics.

You need to use DAX quick measures to generate results to use in a report. Which type of DAX quick measure calculations will NOT work against a DirectQuery table? Select only one answer. 1. aggregate per category 2. mathematical operations 3. time intelligence 4. X-functions

3 Time intelligence functions have performance implications and are disabled for quick measures against DirectQuery tables. Mathematical operations, aggregate per category, and X-functions are all supported against DirectQuery.

You have a Power BI Desktop dataset that includes a table named Salesperson. The table includes a column named UPN. UPN contains the user principal name of the salesperson's Microsoft Entra ID account. You need to ensure that each salesperson will only be able to see the rows in the Salesperson table where the UPN column value matches their User Principal Name. Which two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. 1. Add a calculated column to the Salesperson table. 2. Add a conditional column to the Salesperson table. 3. Add a DAX expression filter to the Salesperson table. 4. Create a role. 5. Create a what-if parameter.

3,4 As part of setting up row-level security, it is necessary to create a role. In addition, it is necessary to add a DAX expression filter to the Salesperson table. This expression checks for a match between the salesperson's User Principal Name attribute and the value in the UPN column. If the two match, the salesperson is allowed to view the content of the corresponding row from the Salesperson table.

You have Power BI Desktop. You need to determine query timings for a report page visual. Which method should you use? Select only one answer. 1. Refresh the data model. 2. Run the Best Practices analyzer in Tabular Editor. 3. Use Session Diagnostics from the Power Query Editor. 4. Use the Performance analyzer.

4 (MS) The Performance analyzer will show the query timings for each object on a report page. Session diagnostics measures Power Query query performance as it relates to refresh times. It is unrelated to measuring DAX performance or report page query timings. The Best Practices analyzer reviews the model for best practices around things like model design, relationships, field naming conventions, and measures. But is unrelated to any query timings for report page visuals.

You are using Power BI Desktop to edit a stacked column chart that displays gross sales data with a date hierarchy that contains year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do? Select only one answer. 1. In the Filters pane, add a filter based on the quarter, month, and day. 2. In the Filters pane, add a filter based on the year. 3. In the Format pane, modify the Maximum Range setting. 4. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.

4 (MS) To prevent users from viewing the hierarchy based on the year, you remove just the year from the date hierarchy fields in the x-axis in the Visualization pane. The quarter, month, and day will remain populated and usable. Modifying the visual Range settings in the Format pane would affect the range of values displayed in the visual. Adding a filter based on the year in the Filters pane would filter the values displayed in the visual, not remove a drilldown level. Adding a filter based on the quarter, month, and day in the Filters pane would filter the values displayed in the visual but would not prevent users from viewing the hierarchy based on the year

You have a query that retrieves data from a table that contains more than 8,000 rows of data. In Power Query Editor, you notice that the column statistics for each column shows a count of exactly 1,000. You need to ensure that the column statistics for each column shows the statistics based on all rows that are returned by the query. What should you do? Select only one answer. 1. Add a Table.Buffer applied step to the query. 2. Change the query load type from Import to DirectQuery. 3. Create a Top N row count parameter for the query. 4. From the query window, select Column profiling on the entire dataset.

4 MS Selecting column profiling for the entire dataset will change the column profiler to analyze the entire query dataset. Adding a Table.Buffer applied step will only cache the entire query in memory during refresh. The query load type in the model will not impact how many rows are used by the column profiler. Using a Top N row count applied step or applying a parameter will not change how the column statistics feature calculates.

From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States. You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column. You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long. What should you do? Select only one answer. 1. From the data view in Power BI Desktop, change the column data type from number to text. 2. From Power Query Editor, add a new applied step at the end of the query to convert the ZIP column from number back to text. 3. From Power Query Editor, delete the changed type step. 4. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.

4 MS To correctly update the data to text you need to replace the number type conversion with a text conversion, and to keep all other data type column transformations. This needs to be done in the Power Query Editor. Adding a new applied step at the end of the query would result in loosing zip codes that start with 0. Changing the data type in Data View is equivalent to adding an applied step at the end of the query and would not preserve leading zeros. Deleting the changed type step would not set the data type to Text.

Question 6: You have a Power BI workspace that contains a single page report named Sales You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Actions: 1)Pin each visual 2)Open powerbi.com 3) Open the Sales report 4) Open Power BI Desktop 5)Pin the page Create a new report

4 -> 3 -> 1 -> 5 -> 2 PDF: 1 -> 2 -> 3

You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? Select only one answer. 18 16 48

48? https://learn.microsoft.com/en-us/training/modules/manage-datasets-power-bi/5-dataset-refresh

Question 19: You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Which three actions should you perform in sequence? To answer, move the appropriate actions from the lists of actions (3) to the answer area and arrange them in the correct order. 1) From Power Query Editor, remover errors from the table 2) From Power Query Editor, append Table2 to Table1 3) From Power Query Editor, merge Table1 and Table2 4) From Power Query Editor, select Table1, and then select Remove duplicates 5) From Power BI Desktop, import the data from Excel, and select Table1 and Table2

5 -> 2 -> 4 Import -> Append -> Remove Duplicates Source: most upvoted in https://www.examtopics.com/discussions/microsoft/view/79390-exam-pl-300-topic-1-question-9-discussion/

Question 21: You are building a Power BI report that uses data from an Azure SQL database named erp1. [pic] You need to perform the following analyses: • Orders sold over time that include a measure of the total order value • Orders by attributes of product sold The solution must minimize update times when interacting with visuals un the report. What should you do? A. From Power Query Editor, merge the Orders query and the Order Line Items query B. From Power Query Editor, merge the Order Line Items query and Products query C. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function D. Calculate the count of orders per product by using a DAX functions

A Explanation: For Orders sold over time we need Orders and for total value we need Order Line items. https://www.examtopics.com/discussions/microsoft/view/81994-exam-pl-300-topic-1-question-7-discussion/

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 Date Order Date Delivery Date You need to support the analysis of sales over time based on all the date foreign keys. Solution: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date. Does this meet the goal? A Yes B No

A Explanation: 1. It's not going to be great solution from the performance side...but that's not part of the requirements 2. Answer is YES.That's not the best solution regarding the performance but it's not the subject. Source: https://www.coursehero.com/file/p4564fhu/You-have-a-Power-BI-report-that-imports-a-date-table-and-a-sales-table-from-an/ Analogical question with wrong solution is: Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table. Does this meet the goal?

What is the purpose of DAX (Data Analysis Expressions) in Power BI? A) To create calculations and custom expressions in Power BI reports. B) To create data models in Power BI. C) To connect to and import data from various data sources.

A Explanation: DAX (Data Analysis Expressions) is a formula language used in Power BI to create calculations and custom expressions in Power BI reports. DAX can be used to create complex calculations and perform operations on data in a Power BI report, making it a powerful tool for data analysis and visualization.

What is the purpose of DirectQuery in Power BI? A) To create reports that are based on live, real-time data. B) To create reports that are based on a static snapshot of data. C) To create reports that are based on data that is stored in the Power BI service.

A Explanation: DirectQuery is a feature in Power BI that allows individuals to create reports that are based on live, real-time data. When using DirectQuery, the report is linked to the data source and updates in real-time as the data changes.

What is the purpose of Power BI Desktop? A) To create and publish reports to the Power BI service. B) To create and share dashboards with others. C) To connect to and import data from various data sources.

A Explanation: Power BI Desktop is a tool for creating and publishing reports to the Power BI service. It allows individuals to create interactive reports and visualizations, connect to and import data from various data sources, and publish reports to the Power BI service for others to view and interact with.

What is the purpose of the Power BI Publish to Web feature? A) To allow users to share Power BI reports and dashboards with individuals outside their organization. B) To host and share Power BI reports within an organization. C) To clean and transform data in Power BI.

A Explanation: Power BI Publish to Web is a feature that allows users to share Power BI reports and dashboards with individuals outside their organization. This feature allows users to create and share interactive reports and dashboards with anyone with a web browser, regardless of whether they have a Power BI account. This can be useful for sharing insights with stakeholders, partners, and customers.

What is the purpose of the Power BI Q&A feature? A) To allow users to ask questions of their data using natural language. B) To allow users to create and share custom visuals in Power BI. C) To store and manage data in the Power BI service.

A Explanation: Power BI Q&A is a feature that allows users to ask questions of their data using natural language. It uses natural language processing and machine learning to understand user questions and generate visualizations based on the data in a Power BI report. This feature makes it easier for users to quickly find insights and gain a better understanding of their data without the need for complex queries or technical knowledge.

What is the purpose of the Power BI Report Server feature? A) To host and share Power BI reports within an organization. B) To allow users to share Power BI reports and dashboards with individuals outside their organization. C) To automate the process of importing data into Power BI.

A Explanation: Power BI Report Server is a feature that allows individuals to host and share Power BI reports within their organization. It provides an on-premises solution for hosting and sharing reports and dashboards, making it easier for organizations to share insights with employees and stakeholders who may not have access to the cloud-based Power BI service. Power BI Report Server also provides a centralized location for managing and organizing reports, making it easier for organizations to stay organized and find the information they need.

What is the purpose of Power BI Report Server? A) To host and share Power BI reports within an organization. B) To publish reports to the Power BI service. C) To connect to and import data from various data sources.

A Explanation: Power BI Report Server is a tool for hosting and sharing Power BI reports within an organization. It allows individuals to publish and share reports on-premises, making it easier for organizations to use Power BI for data analysis and visualization without the need for a cloud-based solution.

5. You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do? A. In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table. B. Add the Weekly_Returns data to the Sales table by using related DAX functions. C. Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.

A Explanation: Scenario: Region managers require a visual to analyze weekly sales and returns. To relate the two tables we need a common column.

Q20)You have a report with a column chart and a bar chart in it. By client segment, the customer count is displayed as a bar graph. Sales are displayed in a column chart by month. The percentage of the month's total sales that belong to the customer segment must be visible when a segment is selected in the bar chart. When the bar chart is used, how should the visual interactions be configured on the column chart in PL-300? A. highlight B. filter C. no impact

A In most visuals, highlighting doesn't remove the unrelated data. Instead it highlights the related data. The rest of the data remains visible but dimmed. Note: By default, visualizations on a report page can be used to cross-filter and cross-highlight the other visualizations on the page. For example, selecting a state on a map visualization highlights the column chart and filters the line chart to display only data that applies to that one state. Incorrect:Not B: Filters remove all but the data you want to focus on. Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters-and-highlighting

Q10)You have a number of reports for your company's HR division. Row-level security is used with the datasets (RLS). The business has several sales territories. An HR manager oversees each sales territory. The HR managers should only be able to deal with data from their region, you must make sure of that. The layout of the reports cannot be altered by the HR managers. How should you grant the HR managers access to the reports? A. Upload the reports to an app and allow access for the HR managers. B. A new workspace should be created, the datasets and reports copied, and the HR managers added as workspace members. C. Publish the reports to a workspace separate from the one that houses the datasets. D. Include the HR managers as users in the workspace that already houses the datasets and reports

A Option A (Publish the reports in an app and grant the HR managers access permission) would be the best option to provide the HR managers with access to the reports while restricting them from modifying the layout. By publishing the reports in an app and granting the HR managers access permission, you can assign them specific roles and permissions that restrict their access to the underlying data while allowing them to view and interact with the reports. The RLS configuration can be set up to ensure that the HR managers can only see data from their own sales region. https://www.examtopics.com/discussions/microsoft/view/80551-exam-pl-300-topic-2-question-2-discussion/

3. You need to create the required relationship for the executive's visual. What should you do before you can create the relationship? A. Change the data type of Sales[region_id] to Whole Number. B. In the Sales table, add a measure for sum(sales_amount). C. Change the data type of sales[sales_id] to Text. D. Change the data type of sales [region_id] to Decimal Number.

A The data type of Sales[region_id] must be changed from varchar to Whole Number, as Sales[region_id] is Integer.

Q16)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table's data during the development process. Solution: You modify the SQL statement by including a WHERE clause. Is the objective being met in PL-300? A. Yes B. No

A The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

Q4)You have many document libraries on your Microsoft SharePoint Online site. There are manufacturing reports saved as Microsoft Excel files in one of the document libraries. The data structure is the same across all manufacturing reports. To load only the manufacturing reports to a table for analysis, you must utilise Power BI Desktop. What ought you to do? A. Retrieve information from a SharePoint folder and type the site URL. Choose Transform, then filter using the manufacturing reports library's folder path. B. Enter the site URL and retrieve information from a SharePoint list. Filter by the folder path to the manufacturing reports library after choosing Combine & Transform. C: Enter the site URL, choose Combine & Load, and then get the data from a SharePoint folder. D. Enter the site URL, choose Combine & Load, and then get data from a SharePoint list.

A https://www.examtopics.com/discussions/microsoft/view/79387-exam-pl-300-topic-1-question-8-discussion/

Q3)In the Customer table, each Customer ID corresponds to a distinct customer. In the Address table, each Address ID corresponds to a distinct address.A query that has one row per client must be made. For each customer, a row must provide their City, State/Region, and Country. What ought you to do? A. Merge the Customer and Address tables. B. Group the Customer and Address tables by the Address ID column. C. Transpose the Customer and Address tables. D. Append the Customer and Address tables.

A https://www.examtopics.com/discussions/microsoft/view/80907-exam-pl-300-topic-1-question-4-discussion/

02. Reference scenario (https://www.edusum.com/scenario/pl-300-scenario2-overview-existing-environment-contoso-ltd-manufacturing-company-produces) Which DAX expression should you use to get the ending balances in the balance sheet reports? a) CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) ) b) CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) ) c) FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) ) d) CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )

A Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter. DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context. Reference: https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

Q2)You create a Power BI report for your company's sales division that imports data from a Microsoft Excel file that is housed in a Microsoft SharePoint folder. The data model includes a number of measurements. From the current data, a Power BI report must be made. The solution must reduce the amount of development work. Which kind of data source need to you employ? A. Power BI dataset B. a SharePoint folder C. Power BI dataflows D. an Excel workbook

A But B is discussed as well. I prefer A since dataset will store everything + number of measures (unlike the Sharepoint folder) https://www.examtopics.com/discussions/microsoft/view/80518-exam-pl-300-topic-1-question-3-discussion/

Question 2: You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection? A. DirectQuery that uses the end-user's credentials B. DirectQuery that uses a database credential C. Import that uses a Microsoft account D. Import that uses a database credential

A Explanation: 1) Direct query not import because of the requirement: "The maximum allowed latency to include transactions in reports is five minutes" Source: Discussion from https://www.examtopics.com/discussions/microsoft/view/84626-exam-pl-300-topic-5-question-2-discussion/

2. You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use? A. FORMAT('Date'[date], "MMM YYYY") B. FORMAT('Date' [date], "M YY") C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#") D. FORMAT('Date' [date_id], "MMM YYYY")

A On the exam, it will be important to check, what format has date_id because if it had yyyymmdd, i would change date_id, not a date column. https://www.examtopics.com/discussions/microsoft/view/75934-exam-da-100-topic-6-question-1-discussion/

Question 4: You have more than 100 published datasets. Ten of the datasets were verified to meet your corporate quality standards. You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do? A. Certify the datasets. B. Promote the datasets. C. Publish the datasets in an app. D. Feature the dataset on The home page.

A, B SOURCE: 1) https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-endorse-content Promotion: Promotion is a way to highlight content you think is valuable and worthwhile for others to use. It encourages the collaborative use and spread of content within an organization. Certification: Certification means that the content meets the organization's quality standards and can be regarded as reliable, authoritative, and ready for use across the organization. 2) https://learn.microsoft.com/en-us/business-applications-release-notes/october18/intelligence-platform/power-bi-service/shared-certified-datasets Once a dataset is certified, it shows up prominently in the new dataset discovery experience, making sure report authors can effortlessly find and leverage these high-quality sources of data.

09. Reference Scenario: (https://www.edusum.com/scenario/pl-300-scenario2-overview-existing-environment-contoso-ltd-manufacturing-company-produces) Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. a) a line chart that shows balances by quarter filtered to account categories that are long-term liabilities b) a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters c) a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities d) a pie chart that shows balances by account category without filters e) a ribbon chart that shows balances by quarter and accounts in the legend

A, C Some say A, E E Ribbon charts show which data category has the highest rank. Ribbon charts are effective at showing rank change, with the highest range (value) always displayed on top for each time period. However in the requirements (below) I dont see a need for ranks. The board must be able to get the following information from the quarterly reports: Revenue trends over time => a Ending balances for each account => c A comparison of expenses versus projections by quarter Changes in long-term liabilities from the previous quarter A comparison of quarterly revenue versus the same quarter during the prior year https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

You plan to publish a dataset from Power BI Desktop. You need to ensure that a server name can be changed after the dataset has been published to the Power BI Service. Which two actions should you perform? Each correct answer presents part of the solution. a) Create a parameter. b) Create a query for the server name. c) From the Data source settings in Power BI Desktop, update the permissions. d)From the Data source settings, update the server source to use a parameter. e)Update the Source applied step of all related queries to reference the server name query.

A, D Official MS page training question with answers provided. A parameter is the only part of a query that can be updated or changed in the Power BI service, by accessing the dataset settings. Updating the server source to use a parameter will update all existing queries pointing to the current server to instead use a parameter with that server name. This parameter can now be changed once this dataset is published to the Power BI service.

Q12)You have a custom connector that gives you the following information for each email sent in the last year: ID, From, To, Subject, Body, and Has Attachments. There are returned more than 10 million records. Based on whom employees send emails to, you create a report that analyses the internal networks of those employees. You must keep the recipients of the report from viewing the examined emails. The model size must be reduced in the solution. What ought you to do in PL-300? A. Change the Subject and Body columns in Model view to Hidden. B. During the import, delete the Subject and Body columns. C. Use row-level security (RLS) to limit the report recipients' ability to view results to those that correspond to the emails they sent.

B A, C: Does not reduce the size of the model.

Q17)You are creating a sales report with two tables in Power BI Desktop. Row-level security (RLS) is set up for both tables. The tables need to be related to one another. The answer must guarantee that the RLS settings are respected by bidirectional cross-filtering. What ought you to do in PL-300? A. Make a relationship between the tables that is inactive and choose to apply the security filter in both directions. B. Establish a relationship between the tables that is active, then choose Apply security filter in both directions. C. Make a relationship between the tables that is inactive and choose Assume referential integrity. D. Establish an active connection between the tables and choose Referential integrity to be assumed.

B By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID. Reference:https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Q4 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 Date Order Date Delivery Date You 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? A Yes B No

B Explanation: Even though you can use USERELATIONSHIP() later, in current situation inactive relationships are useless. https://www.examtopics.com/discussions/microsoft/view/82538-exam-pl-300-topic-2-question-31-discussion/ Other solution that works would be (found analogical question with this solution and most voted answer was YES) Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables.

What is the purpose of the Power BI Paginated Reports feature? A) To create and share interactive reports and dashboards in Power BI. B) To create and share paginated reports with users. C) To store and manage data in the Power BI service.

B Explanation: Power BI Paginated Reports is a feature that allows individuals to create and share paginated reports with users. These reports are optimized for printing and are designed to present data in a tabular format, similar to traditional paper-based reports. Paginated reports are useful for providing detailed information that is best presented in a structured format, such as invoices, receipts, or other financial statements.

What is the purpose of the Power BI Workspace feature? A) To store and manage data in the Power BI service. B) To collaborate with others on Power BI reports and dashboards. C) To automate the process of importing data into Power BI.

B Explanation: Power BI Workspaces is a feature that allows individuals to collaborate with others on Power BI reports and dashboards. This feature allows users to create and share workspaces with others, making it easier for teams to work together on data analysis and visualization projects. Power BI Workspaces also provide a centralized location for managing reports and dashboards, making it easier for teams to stay organized and find the information they need.

Q19)You have a Power BI report that imports two tables from an Azure SQL database: a sales table and a date table. The sales table's date foreign keys are as follows: Due date, purchase date, and delivery date You must back up the historical sales analysis based on all date foreign keys. Solution: You generate measures that filter sales based on the current relationship between the sales table and the date table using the USERELATIONSHIP DAX function. Is the objective being met in PL-300? A. Yes B. No

B Instead, Correct Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables.Reference:https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive Actually the DAX USERELATIONSHIP() function could offer a solution, but not how it is stated as an option: "You create measures that use the USERELATIONSHIP DAX function to filter sales on the ACTIVE relationship between the sales table and the date table." Because the report must be filtered on all 3 dates, the ACTIVE (1) AND INACTIVE (2) relationships should be used with function USERELATIONSHIP, not only the ACTIVE relationship.

03. Reference Scenario: (https://www.edusum.com/scenario/pl-300-scenario2-overview-existing-environment-contoso-ltd-manufacturing-company-produces) You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use? a) stacked area chart b) line chart c) donut chart d) waterfall chart

B Line charts can have many different lines, for example both revenue and cost over time.Reference:https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-line-chart

You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table's data during the development process. Solution: You import the table from Power Query Editor before adding a filter step to the query. Is the objective being met in PL-300? A. Yes B. No

B Not sure about this one since its a case study, and discussions are 50/50. However: The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.Reference:https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Q15)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table's data during the development process. The FILTER function is incorporated into a DAX expression as the solution. Is the objective being met in PL-300? A. Yes B. No

B The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.

Q18)You are using Microsoft Power BI to model data. A sizable Microsoft SQL Server table named Order that contains more than 100 million records is a component of the data model. You must import a portion of the Order table's data during the development process. Solution: You provide a filter at the report level that is dependent on the order date. Is the objective being met in PL-300? A. Yes B. No

B The filter is applied after the data is imported.Instead add a WHERE clause to the SQL statement.Reference:https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only. What should you do? A. To the ConfidentialData table, add a calculated measure that uses the CuRRENTGROUP DAX function. B. Create a row-level security (RLS) role for each department and then define the membership of the role. C Create a slicer that filters Departments based on DepartmentID. D. Create a DepartmentID parameter to filter the Departments table.

B https://www.examtopics.com/discussions/microsoft/view/84556-exam-pl-300-topic-2-question-22-discussion/

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

B https://www.examtopics.com/discussions/microsoft/view/94744-exam-pl-300-topic-2-question-59-discussion/

06. You've created a report that you published to a workspace. A few business users need to have the ability to view the reports. What's the most appropriate way to achieve this? Your solution must consider that the report audience may change in the future and that you've already created other reports in the workspace that will be ready to be shared at a later date. a) Share an app with individual users. b) Share an app with a security group. c) Share report from workspace with individuals. d) Give the users the Viewer role in the workspace.

B sharing an app is most appropriate and since the audience might change sharing with a security group would ensure that a new user could see a report after being assigned to a role.

Question 13: You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power BI dashboard that will include two visuals from each report. You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Which two actions should you perform? Each correct asnwer presents part of the solution. A. Turn on tile flow B. When pining visuals to the dashboard, select Use destination theme. C. Upload a snapshot D. For the browser, set the color preference to dark mode E. Select the dark dashboard theme

B, E Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes

Q5)You have a CSV file with user complaints in it. The file has a column called Logged in it. Each complaint's log entry includes the date and time that it happened. The information in Logged is organised in follows: 2018-12-31 at 08:59. You must be able to use an internal date hierarchy and the logged date to assess the complaints. What ought you to do? A. Use a transformation to pull off the last 11 characters from the Logged column, then change the new column's data type to Date. B. Change the Logged column's data type to Date. C. Use at as the delimiter to split the Logged column. D. Use a transformation to obtain the Logged column's first 11 characters.

C Explanation: Not A - last 11 characters are useless for a date hiearchy Not B - word "at" ruins this solution Or D should work too. But when there is a date 2019-1-1 it has only 8 characters. Taking till 11th character would take "At" into date column and ruin everything.

Question 12: You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access: • External users can access the dashboard • Managers can access the dashboard and a manager specific report • Employees can access the dashboard and a row-level security (RLS) constrained report. You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you do? A. Chat in Microsoft Teams B. Subscriptions C. Comments D. Alerts

C Add a personal comment or start a conversation about a dashboard or report with your colleagues. The comment feature is just one of the ways a business user can collaborate with others. Note: Comments can be added to an entire dashboard, to individual visuals on a dashboard, to a report page, to a paginated report, and to individual visuals on a report page. Add a general comment or add a comment targeted at specific colleagues. Reference:https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment

Question18: You have a Power BI report that uses row-level security (RLS) You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets, or dashboard. What should you do? A. Grant the Read and Build permissions for the Power BI datasets to the Azure network security team. B. Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team C. Instruct the Azure network security team to create security groups. Configure RLS to use the groups. D. Add the Azure network security team as members of the RLS role

C Explanation: Configure row-level security group membership, Working with members. Add members -In the Power BI service, you can add a member to the role by typing in the email address or name of the user or security group. You can use the following groups to set up row level security. Distribution Group -Mail-enabled Group -Security Group Explanation: It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups. Incorrect: Not A: Build permission applies to datasets. When you give users Build permission, they can build new content on your dataset, such as reports, dashboards, pinned tiles from Q&A, paginated reports, and Insights. Reference:https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

You import a Power BI dataset that contains the following tables: • Date • Product • Product Inventory The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table [picture] The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information What should you do? A. Change Summarization for DateKey to Don t Summarize. B. Change the data type of UnitCost to Integer. C. Remove MovementDate. D. Remote the relationship between Date and Product Inventory

C Explanation: Date is already shown in DateKey column so we can remove duplicating column.

Question 7: You have a report in Power BI named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do? A. Apply row-level security (RLS) to the shared dataset B. Clear Allow recipients to share your dashboard and Allow users to build new content using underling datasets for the dataset. C. Select the Don't allow end users to export any data from the service or Report Server Export data option for the report D. Select Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.

C Explanation: To set this options: in Power BI Desktop -> File -> Options and Settings -> Options Current File -> Report Settings There you'll find "Export data" section and 3 options. The last one is "Don't allow end users to export any data from the service or Report server" In PBI service, you can also allow or forbid to export data, but there the only option to prevent data from beeing exportet is "None". Reference: https://data-marc.com/2020/04/13/power-bi-governance-why-you-should-consider-to-disable-export-to-excel/

What is the purpose of the Power BI Dataflows feature? A) To automate the process of importing data into Power BI. B) To clean and transform data in Power BI. C) To store and manage data in the Power BI service.

C Explanation: Power BI Dataflows is a feature that allows individuals to store and manage data in the Power BI service. It enables users to connect to a variety of data sources, clean and transform the data, and store it in the Power BI service for use in reports and dashboards. Power BI Dataflows help streamline the data preparation process and make it easier to share and reuse data across multiple reports and dashboards.

4.What should you create to meet the reporting requirements of the sales department? *Requirements: * The sale department requires reports that contain the number of sales transactions.* A. a measure that uses a formula of SUM (Sales [sales_id]) B. a calculated column that use a formula of COUNTA(sales [sales_id]) C. a measure that uses a formula of COUNTROWS (Sales) D. a calculated column that uses a formula of SUM (Sales [sales_id])

C Explanation: The sale department requires reports that contain the number of sales transactions. The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression. Reference: https://docs.microsoft.com/en-us/dax/countrows-function-dax

08. You have a Power BI tenant. You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted. What should you implement? a) dataset certifications b) row-level security (RLS) c) sensitivity labels d) Microsoft Intune policies

C Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel,PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings. This way your sensitive data remains protected no matter where it is. Reference:https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and-introducing-new-capabilities/

04. Your department wants to see a single visual that explains the factors that contribute to revenue growth the most. Which visualization should you use? a) Decomposition tree b) Funnel chart c) Key influencers d) Stacked column chart

C The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. The key influencers visual is a great choice if you want to :✑ See which factors affect the metric being analyzed. ✑ Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?Reference:https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Q1)You have a fully hosted project management app on Microsoft Teams. Microsoft Power Apps were used in the development of the app. A Power BI report that integrates with the project management software must be written. Which connector ought you to choose? A. Microsoft Teams Personal Analytics B. SQL Server database C. Dataverse D. Dataflows

C When you're using the template, you're connected to your Microsoft Dataverse instance, where your Microsoft Project web app data is stored. https://support.microsoft.com/en-us/office/use-power-bi-desktop-to-connect-with-your-project-data-df4ccca1-68e9-418c-9d0f-022ac05249a2

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.

C You can scheduled refresh for the On-premises data gateway (personal mode) and the On-premises data gateway. You specify refresh options in the following areas of the Power BI service: Gateway connection, Data source credentials, and Scheduled refresh. Reference:https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Q8)A Power BI dataflow is created by a business intelligence (BI) developer that makes use of DirectQuery to retrieve tables from an on-premises Microsoft SQL server. The dataflow's Enhanced Dataflows Compute Engine is activated. The dataflow must be utilised in a report. The answer must adhere to the following criteria: Minimize visual calculations and render times, as well as online processing tasks. Include information from this year, up to and including the day before. What ought you to do? A. Set the DirectQuery mode for a dataflows connection. B. Set up a gateway connection for the dataset and create a dataflows connection with the DirectQuery C. Create a dataflows connection and choose the Import mode. Then, set the connection to refresh every day D. Develop a dataflows connection with the Import mode checked, then use Power Automate to create a solution that will automatically update the data every hour

C https://www.examtopics.com/discussions/microsoft/view/82494-exam-pl-300-topic-1-question-16-discussion/

Question 10: You have a PBIX file that imports several tables from an Azure SQL database. The data will be migrated to another Azure SQL database. You need to change the connections in the PBIX file. The solution must minimize administrative effort. What should you do? A. From Power Query Editor. modify the source of each query. B. From Power Query Editor, create new queries. C. Modify the Data source settings. D. Create a PBIT file, open the file. and change the data sources when prompted.

C https://www.examtopics.com/discussions/microsoft/view/86332-exam-pl-300-topic-4-question-6-discussion/

Question 8: You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do? A. Create a mobile report that contains a column chart B. Enable report readers to personalize visuals C. Add column chart, bookmark, and a button for users to choose a visual D. Create a separate report page for users to view the column chart

C B was discussed as well but personally i prefer C as an answer. Since B would enable users to do much more then switching between chart types which is not required in question. Not sure yet. https://www.examtopics.com/discussions/microsoft/view/81776-exam-pl-300-topic-3-question-26-discussion/

05. You need to ensure that users can effectively navigate your reports by using the keyboard. Which property should you configure? a) Bookmarks b) Layer order c) Mobile layout d) Tab order

D "If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order." Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

Question 3: You have a Power BI workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data in DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do? A. Add the user as a member of Workspace1. B. Share RPT1 with the user. C. Add the user as a Viewer of Workspace1. D. Grant the Build permission for GS1 to the user.

D Explanation: More granular permissions -Power BI provides the Build permission as a complement to the existing permissions, Read and Reshare. All users who already had Read permission for datasets via app permissions, sharing, or workspace access at that time also got Build permission for those same datasets. They got Build permission automatically because Read permission already granted them the right to build new content on top of the dataset, by using Analyze in Excel or Export. With this more granular Build permission, you can choose who can only view the content in the existing report or dashboard and who can create content connected to the underlying datasets. If your dataset is being used by a report outside the dataset workspace, you can't delete that dataset. Instead, you see an error message. Reference:https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions From: https://www.examtopics.com/discussions/microsoft/view/86339-exam-pl-300-topic-4-question-16-discussion/

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.

D One way to add a new dashboard tile is by pinning an entire report page. This is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard. And changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile as well. Pinning live tiles from reports to dashboards is only available in Power BI service (app.powerbi.com). Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

Question 5 You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit. What type of visual should you use? A. key influencers B. smart narrative C. Q&A D. decomposition tree

D Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree

Question 11: You have a Power BI workspace that contains several reports You need to provide a user with the ability to create a dashboard that will use the visuals from the report. What should you do? A. Grant the Read permission for the datasets to the user B. Share the reports with user C. Create a row-level security (RLS) role and add the user to the role D. Add the user as a member of the workspace E. Add the user as a Viewer of the workspace

D Reference:https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces Source:https://www.examtopics.com/discussions/microsoft/view/86333-exam-pl-300-topic-4-question-7-discussion/

Question 14: You have a report that contains a donut chart and clustered colum chart. Interactions between the visuals use the deafault settings. You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column. What should you do? A. Select the donut chart and set the column interaction to Filter. B. Select the donut chart and set the column chart interaction to None. C. Select the column chart and set the donut chart interaction to None. D. Select the column chart and set the donut chart interaction to Filter.

D Reference:https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

07. Reference Scenario: (https://www.edusum.com/scenario/pl-300-scenario2-overview-existing-environment-contoso-ltd-manufacturing-company-produces) What is the minimum number of datasets and storage modes required to support the reports? a) two imported datasets b) a single Direct Query dataset c) two DirectQuery datasets d) a single imported dataset

D SharePoint and Dynamics 365 Business Central don't support Direct queries, SO not B nor C. And if we choose import mode, "an Import model can integrate data from any number of supported data source types"(https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand). So the answer is 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

Q7)You have a sales transaction database stored in Azure SQL. The database is regularly updated. To find phoney transactions, you must create reports from the data. After an update, the data must be accessible within five minutes. How should the data connection be set up? A. Add a SQL statement. B. Set the Command timeout in minutes setting. C. Set Data Connectivity mode to Import. D. Set Data Connectivity mode to DirectQuery.

D Since the data must be accessible in five minutes, "DirectQuery reports always use current data. Seeing underlying data changes requires you to refresh the data, and reimporting large semantic models to refresh data could be unfeasible." https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Q13)You have a report from Microsoft Power BI. The PBIX file is 550 MB in size. By using an App workspace in a shared capacity on powerbi.com, one can see the report. One fact table from an imported dataset is used in the report. There are 12 million rows in the fact table. At 8:00 and 17:00, the dataset will refresh twice daily. The report is one page long and has 10 default visuals in addition to 15 AppSource visuals. When users access and engage with the report, they complain that the visuals take a long time to load. You must offer a suggestion for enhancing the report's functionality. What ought to you suggest in PL-300? A. Use iterator functions in place of any DAX measurements. B. Make visual interactions possible. C. Substitute AppSource visuals for the standard ones. D. Divide the images among several pages.

D This will reduce the number of visuals to load per time ... hence increase performance. https://community.powerbi.com/t5/Desktop/Visuals-are-loading-extremely-slow/td-p/1565668

10. Reference Scenario: (https://www.edusum.com/scenario/pl-300-scenario2-overview-existing-environment-contoso-ltd-manufacturing-company-produces) You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date. You need to reduce the size of the data model. What should you do? a) Round the hour of the Date column to startOfHour b) Change the data type of the Date column to Text c) Trim the Date column d) Split the Date column into two columns, one that contains only the time and another that contains only the date

D Trimming and StartOfHour would cause missing data (hours could be important), by changing data type to text would restrict us from analysis with dates We have to separate date & time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table. Reference:https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi https://apexinsights.net/blog/top-5-tips-to-optimise-data-model

Q11)A user must have the option to add individuals to a workspace. The least privilege principle must be applied to the solution. Which role ought to you give the user? A. Viewer B. Admin C. Contributor D. Member

D https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces

Q9)You are using Power BI Desktop to create a report. You open a data extract that has a coll free text field. The frequency distribution of the string lengths in col1 has to be examined. The size of the model must not be impacted by the solution. What ought you to do? A. Include a DAX computed column in the report that determines the length of col1. B. Include a DAX function that determines the average length of col1 in the report. C. Add a column that determines the length of col. 1 D in the Power Query Editor. Change the distribution for the Column profile in Power Query Editor to group by length for col1.

D https://www.examtopics.com/discussions/microsoft/view/79434-exam-pl-300-topic-2-question-1-discussion/

Q6)In a Microsoft OneDrive folder, you have a Microsoft Excel document. A Power BI dataset must import the file. You must make sure that PowerBI.com can refresh the dataset. How do you link to the file using the two connectors? Each accurate response offers an entire resolution. A. Excel Workbook B. Text/CSV C. Folder D. SharePoint folder E. Web

D, E Explanation: We can import an excel file from multiple connectors (excel workbook, folder, web, share point) but if we must refresh the data from the service with no gateways then We must use web and share point connectors.

Question 5: You plan to create a Power BI dataset to analyze attendance at a school. Data will come from two separate views in an Azure SQL database. [pic] The views can be related based on the Class ID column. Class ID is the unique identifier for the specified class, period, teacher, and school year. F.e., the same class can be taught by the same teacher during two different periods, but the class will have a different class ID. Design a star schema data model by using the data in both views. The solution must facilitate the following analysis: • The count of classes that occur by period • The count of students in attendance by period by day • The average number of students attending a class each month 1) Teachers First name: A. Attendance fact B. Class dimension C. Period (teachers) dimension D. Period fact 2) Period Number A. Attendance fact B. Class dimension C. Period dimension D. Period

Not sure about these: 1C 2B Most upvoted option on: https://www.examtopics.com/discussions/microsoft/view/80707-exam-pl-300-topic-2-question-21-discussion/