PL-300 Exam – Practice 13 Welcome to your PL-300 Exam - Practice 13 Question 1 You should create a report that shows the company‘s sales performance. The sales team asked you to add a single visualization that could help identify the factors that affect sales and influence success. Which of the following visualization would you use? None of these Key influencers Funnel chart Q&A visualization Question 2 You build a map of 3,40,000 students using an R visual. You ensure that the values of student_id, longitude, and latitude are added in the fields sent to the visual. Each Student_id is unique representing an individual student. But when the visual is loaded by the users in Power BI, it shows the details for only some of the students; not all. What is the reason behind this issue? The data was duplicated The number of records to be shown were higher than the capacity of R visuals A different version of R was used to build the visual The data originates from a Microsoft SQL Server source Question 3 You are working on the K slidingWindow for a model training and stuck with the inference. How many data points should be accessible from the source file during inference to get valid results? K+1 points K*K points K points K-1 points Question 4 You have recently joined an organization as a Database Administrator Associate. Your senior has asked you to create aggregation for a particular database. Which of the following methods cant be used to create the aggregation? Aggregations can be created by using Data visualization tools in Power BI Desktop. Aggregations can be created by using Power Query Editor in Power BI Desktop. If you have access to the database, the summary can be created by creating a table with the summary and then importing the table into Power BI Desktop. If you have access to the database, the aggregation can be created by creating a view for the aggregation and then importing the view into Power BI Desktop. Question 5 True or False: In Power BI, by default column profiling is based on the top 1,000 rows. True False Question 6 What does it mean to “assume referential integrity“ when developing relationships between tables in Power BI Desktop? It is considered that there are no null or empty values in any data table in the relations. The Require Referential Integrity setting causes queries to use INNER JOIN statements instead of OUTER JOIN statements, which increases the efficiency of the query. It automatically considers the relationship as one to one. It allows the calculated columns to be considered as relationship columns between the tables. Question 7 Which of the following options is not a privacy level in Power BI desktop? Private Confidential Public Organizational Question 8 Which of the following options is not a Microsoft 365 sensitivity label? highly confidential public none general Question 9 In Power BI, column _____ shows the number of valid, error, and empty cells in a column. distribution quality analysis profile Question 10 Select from the list below the types that are not valid in the M programming language? Table Record Point List Question 11 In Power BI, column _____ include(s) characteristics like count, error, empty, distinct, unique, zero, min, max, and average. wide statistics analytics charts Question 12 What is the first parameter in the DAX function PATHITEM? the level you want to be returned type the text path describing the hierarchy the name of the field you‘re interested in Question 13 You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you? Yes No Question 14 Which of the following is a way to improve performance when retrieving data in Power BI? Pulling the data only in Power BI Service and not in Power BI Desktop. Combining the date and time columns into a single column. Using the SELECT SQL statement in SQL queries when retrieving data from a relational database. Performing some calculations in the original data source. Question 15 You are creating a sales report that should consist of several pages. Each page is to contain the response to a specific business query.You decide to create a menu page that displays all business queries. Users should be able to click on any business query and then be redirected to the page with the answer to the query they clicked on. You also need to make sure that the menu page works when it is published to any workspace.What would you do to make this work? Add a text box and link for each business query. Create a Power Apps visual with a dropdown list. This list will consist of all business queries. Add filters to the menu page. Add a button for each business query and set the action type to Bookmark. Question 16 Your team is working on a project where there will be different scenarios for using the decomposition tree. For which purposes would you NOT recommend using the decomposition tree? To perform a root cause analysis. To perform what-if analysis with integrated parameters. To automatically analyze the selected dimensions to check where the metric has the lowest or highest value. To visualize the data across multiple dimensions. Question 17 What is the second parameter in the DAX function LOOKUPVALUE? the table in which to look the field with the value you‘re searching for the name of the field you‘re interested in the value you want to match on Question 18 Which Power BI license type is the standard license required for most Power BI development work? Embedded Premium Per User Premium Per Capacity Pro Question 19 You are developing a Power BI report for a large data set. You want to improve the performance of the dataset update by performing an incremental update. Which of the following statements about this scenario are true? RangeStart and RangeEnd are two PowerQuery parameters needed for incremental refresh. Use the “Incremental Update“ function for all data sources A date field is required in a table in the dataset. Use the Incremental Refresh feature only for data sources that support query folding. Question 20 Why is it advisable to avoid NULL values in a numeric column? A DAX expression with the MAX function over such data gives wrong results. A DAX expression with an AVERAGE function over such data returns incorrect results. A DAX expression with the SUM function over such data will give wrong results. None of these Question 21 Which of the following statements correctly defines the rules for creating table relationships when designing a data model? (Choose two) A relationship between two tables can be created using multiple fields from each table. A relationship between two tables must be created with a single field from each table. You can create several relations between two tables and all of these relations can be marked as active. You can create multiple relationships between two tables, but only one of these relationships can be marked as active. Question 22 Which of the following statements about calculated columns in Power BI is false? A calculated column is populated when it‘s created. A calculated column does not add to the dataset size. A calculated column‘s values are updated when the dataset is refreshed. Calculated column values are stored in the Power BI dataset like those of a standard column. Question 23 Which of the following tasks can be performed ONLY by the workspace admin? (Choose three) Creating, editing, or deleting the content in the workspace Publish, update, and/or share an app in a workspace Configure data refreshes Add/remove other users Question 24 Which of the following lists presents the phases of Power BI report creation in correct order? analyze, define, develop, test, deploy requirements, design, implementation development, test, production test, development, test, production Question 25 In Power BI, Power Query Editor is available through the ______ menu. Transform Query Tools Analyze Question 26 Which of the following elements can you set in a bookmark? (Choose three) Sort order Slicers, including slicer type and slicer state Visual selection state Properties of fields Question 27 You develop a dataset named from the flat files and use incremental refresh. The dataset is deployed to Premium Power BI along with other related reports. You discover that the incremental refresh for the dataset fails due to lack of resources. Which of the following could be a possible reason for this issue? None of these Data type for the column that is utilized for data partition has changed. Query folding is not happening. No filter is applied to the file. Question 28 True or False: The queries in the query editor do not have to be loaded into the data model. You can decide and select whether they should be loaded or not. True False Question 29 True or False: The nodes in a decomposition tree are fixed and cannot be changed by the end users viewing the report. True False Question 30 Your team leader has asked you to print some Power BI reports and distribute them to team members during the meeting. Before you start printing the reports, you notice that some tables show fewer rows than there actually are. Which of the following is the correct method to fix this problem? Expand the table to the whole page Reduce the table size by grouping the rows Create a paginated report Create a customize tooltip Question 31 Can you create a relationship between two columns with different DATA TYPE? Yes, but the cardinality of the relationship must be set as one to many. Yes, but the cardinality of the relationship must be set as many to many. No, the columns in a relationship must have the same data type. Yes, the latest versions of Power BI Desktops fully support the creation of relationships between such columns. Question 32 You model the data using Microsoft Power BI. The data model consists of a large Microsoft SQL Server table called “Transactions“ and more than 120 million records.During the development phase, it is necessary to import a sample of data from the “Transactions“ table.You decide to write a DAX expression that uses a filter function.Will this help you achieve your goal? Yes No Question 33 You want to split your query into two parts. Which of the following options would you use in Power BI? Format Query Extract previous None of these Split Query Question 34 For what reasons is the Lineage view in Power BI important? (Choose three) Saves time by simplifying your task of identifying reports and dashboards that haven‘t been refreshed. It helps in analyzing the data sets and finding the patterns, trends, and outliers. Allows you to manage your workspaces and observe the impact of a single change in one dataset to reports and dashboards. Simplifies the troubleshooting process because you can see the path that the data takes from source to destination and determine pain points and bottlenecks. Question 35 Which of the following statements about Slicer Visual in a Power BI report are true? You can configure the Slicer Visual based on the date column to use sliders. When adding a field to the Field Well of a Slicer Visual, you can use either a key figure or a column. The purpose of using a Slicer Visual in Power BI reports is to provide an interactive filtering experience for report consumers. A slicer visual from the report can be pinned to a dashboard to make the dashboard interactive. Question 36 You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R Scripting in Power BI Desktop? You must install Microsoft R on your system where Power BI Desktop is already installed. None of these You need to install R Studio on your system where Power BI Desktop is already installed. R scripting is available by default in Power BI Desktop. You do not need to perform any special action to use R-Scripting. Question 37 You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use? Power BI Report Builder Power BI Desktop optimized for Report Server None of these Power BI Desktop Question 38 Which three parameters are required in the API requests for training and inference? (Choose three) startTime source endTime ratio Question 39 Note: This Question is part of a series of Questions that present the same scenario. Each Question in the series contains a unique solution that might meet the stated goals. Some Question sets might have more than one correct solution, while others might not have a correct solution.After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.Does this meet the goal? Yes No Question 40 What is the difference between a calculated column and a measure in Power BI? A calculated column is computed at the row level, while a measure is computed at the aggregate level A calculated column is computed at the aggregate level, while a measure is computed at the row level A calculated column is used for filtering data, while a measure is used for sorting data A calculated column is used for sorting data, while a measure is used for filtering data Question 41 For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use? Power BI dataset a SharePoint folder Power BI dataflows an Excel workbook Question 42 What is the difference between a calculated column and a calculated table in Power BI? A calculated column is computed at the row level, while a calculated table is computed at the table level A calculated column is computed at the table level, while a calculated table is computed at the row level A calculated column is used for filtering data, while a calculated table is used for sorting data A calculated column is used for sorting data, while a calculated table is used for filtering data Question 43 You have multiple dashboards.You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally IdentifiableInformation (PII). The solution must minimize configuration effort and impact on the dashboard design.What should you use? A. Microsoft Information Protection sensitivity labels B. tiles C. comments D. Active Directory groups Question 44 Note: This Question is part of a series of Questions that present the same scenario. Each Question in the series contains a unique solution that might meet the stated goals. Some Question sets might have more than one correct solution, while others might not have a correct solution.After you answer a Question in this section, you will NOT be able to return to it. As a result, these Questions will not appear in the review screen.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:✑ Due Date✑ Order Date✑ Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal? Yes No Question 45 How can you ensure that a report is up-to-date in Power BI? A. Manually refresh the report B. Use a scheduled refresh C. Use a live connection to the data source D. Use a direct query to the data source Question 46 A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do? Create a dataflows connection that has DirectQuery mode selected. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset. Create a dataflows connection that has Import mode selected and schedule a daily refresh. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly. Question 47 You need to create a data source that can be used by Power Automate. Which type of data source should you use? SQL Server Common Data Service SharePoint OneDrive Question 48 You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard.You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point. Ask a Question by using Q&A Hide the report page Pin the visual to the dashboard. Use quick insights on the dashboard. Add the visual to the report. Question 49 How can you handle data that is not in the correct format for analysis? Use data transformation tools Use data modeling tools Use data visualization tools Use data profiling tools Question 50 You have a collection of reports for the HR department of your company.You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.Which type of visualization should you use? ribbon chart scatter chart line chart key influencers Question 51 You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default 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? Select the donut chart and set the column chart interaction to Filter. Select the column chart and set the donut chart interaction to Filter. Select the donut chart and set the column chart interaction to None. Select the column chart and set the donut chart interaction to None. Question 52 From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.What should you do? From powerbi.com, add users to the HR role for the dataset. From powerbi.com, share the dataset to the HR team members. From Power BI Desktop, change the Row-Level Security settings. From Power BI Desktop, import a table that contains the HR team members. Question 53 How can you ensure that a report is using the correct dataset in Power BI? Use a data source filter Use a report-level filter Use a page-level filter Use a visual-level filter Question 54 You have a Power BI report.You have a table named Data1 that contains 10 million rows.Data1 is used in the following visuals:✑ A card that shows the number of records✑ A bar chart that shows total transaction amount by territory✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territoryYou need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.What should you do? Add a count field of the transaction amount to the size bucket of the scatter plot. Add a trend line to the scatter plot. Enable high-density sampling on the scatter plot. Apply a row filter to the Data1 query in Power Query Editor. Time's up Trần Quân PL-300 Exam – Practice 12 PL-300 Exam – Practice 14