PL 300 Practice Test
You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the SharePoint server. You need to recommend a solution to ensure that the dataset for the report can automatically refresh daily. What should you include in the recommendation? - An on-premises data gateway - A site-to-site virtual private network - A Point to Site virtual private network
- An on-premises data gateway An on-premises SharePoint server requires the use of a Power BI gateway since it's an on-premises data source.
You plan to run Power BI Desktop Performance Analyzer. You need to ensure that the data engine cache will NOT impact the test results without restarting Power BI Desktop. What should you do first? -Connect DAX Studio to the data model. -Invoke the Clear Cache function. -Invoke the Refresh Metadata function.
- Connect DAX studio to the data model. DAX Studio, once connected to the data model, can be used to clear the data engine cache.
From Power BI Desktop, you create a data source by importing a Cosmos DB for NoSQL item collection. You connect to the Cosmos DB account, database, and collection, but the preview displays only a list of items named Record. You need to select individual fields from items in the collection that you want to load into Power BI Desktop. What should you do first? -Open PQE -Retrieve the Cosmos DB account key -Switch to the model view
- Open Power Query Editor To view individual item fields, open PQE and use the expander button on column 1 header to display the list of fields.
You have an Excel spreadsheet that contains three columns labeled Year, 2021, and 2012. The entries in rows for the first column consists of names of the individual months in the year while the other two columns contain the sales amount for each month for the corresponding year. You import data from the Excel spreadsheet into Power BI Desktop.You need to transform the data so it will consist of three columns, with the first one containing month, the second containing year, and the third containing the sales amount for that month and year. Which transformation should you use first? -Pivot -Unpivot -Transpose Table
- Unpivot Unpivot will allow you to shape the current table into the one with the year, month, and sales amount columns. Pivot would be applicable in the opposite scenario in which flat data needs to be reorganized into one containing aggregate values for each unique value in each column. Transposing would switch rows and columns
You create a data model in Power BI Desktop that contains DAX calculated columns and measures. You now need to create a report. In which two places can a DAX calculated column be used, but a DAX calculated measure cannot be used? - as a filter in the "Filters on this page" well of the Filters pane - as a filter in the "Filters on this visual" well of the Filters pane - as an item in the "Add drill-through fields here" well of the Visualizations pane - as an item in the Fields well of a slicer
- as a filter in the "Filters on this page" well of the Filters pane, as an item in the Fields well of a slicer Unlike measures, a calculated column can be used in a slicer to place filter options on the report page. DAX measures can only be placed per visual, in the "Filters on this visual" well of the Filter Pane.
In Power BI Desktop, you plan to use M-language to define a common date table spanning a period of 10 years. You need identify the M language function that would allow you to specify that rows in the table should represent consecutive days within the date range you designated. Your solution must minimize administrative effort. -#date -#duration -List.Combine -List.Duration
-#duration The #duration function of the M language allows you to specify the datetime values that will be entered into individual rows of a data table
You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? - Enable the script visuals options in the Visualization pane of PBI Desktop - Enable preview features in PBI Desktop -Configure global Python scripting options in PBI Desktop
-- Enable the script visuals options in the Visualization pane of PBI Desktop Enabling script visuals is required before creating a custom Python visual in PBI Desktop.
You are modifying a report in Power BI Desktop. The report contains a single report page that has three card visuals and one clustered bar chart. You need to create a bookmark that displays only the clustered bar chart and hides the cards. What should you do first? -Add a bookmark in the Bookmarks Pane. -Hide the three cards in the Selection Pane. -Publish the report to the Power BI Service.
--Hide the three cards in the Selection Pane. Before you create a bookmark, you must mark visuals as hidden for this specific scenario
What is the number of consecutive refresh failures that will automatically disable the refresh schedule? -2 -4 -6 -8
-4 If there are 4 consecutive data set refresh failures, the refresh schedule will be automatically disabled.
You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? -8 -24 -48
-48 48 refreshes per dat with Premium
You manage a Power BI workspace in shared capacity. The workspace contains a dataset named DS1. You plan to schedule the refresh of DS1. What is the maximum number of data refreshes per day? -8 -6 -4 -10
-8 The maximum number of refreshes per day for a Power BI workspace in a shared capacity is 8
You implement the Q&A feature in a report, so users can get answers to their questions on their own. You need to improve your Q&A search capabilities for end-users. Which two configurations can you add? - Add a linguistic schema to the dataset. - Add synonyms to model fields. - Configure the dataset as a composite model.
-Add a linguistic schema to the dataset, Add synonyms to model fields Adding synonyms to model fields will help users search for them. A linguistic schema describes terms and phrases that Q&A should understand for objects within a dataset, including parts of speech, synonyms, and phrasings related to the dataset.
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? -Add a separate date dimension table. -Add a year, month, and week columns to the fact table. -Enable the Auto date/time current file option.
-Add a separate date dimension table. Adding a separate date dimension table that includes year, month, and week info is the optimal apporach which provides the functionality, while minimizing the model size and admin effort.
You have a Power BI Desktop dataset based on a star schema data source. You need to use Data Analysis Expression (DAX) to create a date table in the dataset and populate the table with a range of dates based on the earliest and latest date within the dataset. Which function should you choose? -CALENDAR -CALENDARAUTO -DATE -DATEDIFF
-CALENDARAUTO Calendarauto function generates a range of dates based on the earliest and latest date within the dataset.
You are creating a report in a Power BI Desktop by using a dataset that contains sales data. You need to create a measure that always provides the value of total sales for the year 2022, regardless of which year is selected in any visual in the same report. Which DAX function should you use in combination with the SUM function to override the context and provide the result? - calculate - filter - ignore - sumx
-Calculate Calculate function provides the results of the calculation with the ability to override the context.
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? -Choose columns -Remove columns -Remove other columns
-Choose Columns -Remove other columns 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.
From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate. You add a button to the Main page for navigation.You need to implement a solution that meets the following requirements: The navigation destination must change based on the output of a DAX measure named [Error Rate]. If [Error Rate] is greater than 5%, the button must display the text "Error Rate" and navigate to the Error Rate page. Otherwise, the button must display the text "On-time Rate" and navigate to the On-Time Rate page. What 3 should you perform? -Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. -Set the button type to Page Navigation and then use conditional formatting to specify the destination. -Use conditional formatting to set the button text.
-Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. -Set the button type to Page Navigation and then use conditional formatting to specify the destination. -Use conditional formatting to set the button text. To configure a button for conditional page navigation, you need to create a DAX measure that outputs the correct destination page name. Then configure the button to use page navigation and use the newly created DAX measure to specify the navigation destination. To change the button text to match the page name, conditional formatting must be used to set the text to equal the newly created DAX measure
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? -Create a parameter -Create a query for the server name -From the Data source setting in PBI Desktop, update the permissions -From the Data source settings, update the server source to use a parameter -Update the Source applied step of all related queries to reference the server name query
-Create a parameter -From the Data source settings, update the server source to use a parameter A parameter is the only part of a query that can be updated or changed in the PBI service. 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.
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? - add a DAX expression filter to the Salesperson table -Create a role -create a what-if parameter
-Create a role -add a DAX expression filter to the Salesperson table When setting row level security, it's necessary to create a role and adding a DAX expression filter. 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 a fact table that contains sales data and the following two date columns: OrderDate & ShipDate. Both columns have a relationship to the Date column in the Calendar table, and DAX measures have been configured to use these relationships for calculations related to order or ship dates. You need to ensure that by default, the Calendar table does NOT filter the fact table, unless it is using a DAX measure that uses these relationships. What should you do? -Disable Make this relationship active for both relationships. -Enable Make this relationship active for both relationships. -Enable Apply security filter in both directions for both relationships.
-Disable Make this relationship active for both relationships. You can have multiple inactive relationships between two tables in Power BI datasets. DAX measures can then use the USERELATIONSHIP function to activate a relationship for calculations. Relationship direction isn't required for either the relationships or measures to work in this model setup. Only one active relationship can exist between two tables in a Power BI dataset.
You need to create a bookmark that toggles the visibility of a visual. This bookmark must only toggle the visibility state and perform no other action. Which 3 configurations should you make? -Disable the Data option -Disable the Current Page option -Disable the Display option -Enable the Current Page option -Enable the Data option -Enable the Display option.
-Disable the Data option, Disable the Current Page option, Enable the Display option
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 need to minimize the occurrences of the timeout issues indicated by the message. What should you do? -Divide the SQL statement into separate data sources -Implement Aggregations in the SQL statement -Replace subqueries with nested queries
-Divide the SQL statement into separate data sources Combine half the columns in one query and the other half in a different query, power query can merge those two queries back together after importing.
You have a Power BI Desktop dataset that includes a table named Employees containing a row for each employee with the following columns: Employee ID Employee Name Manager ID Manager Name You need to flatten the parent-child hierarchy in the Employees table by adding an extra column that will contain a listing of employee IDs for all direct and indirect managers of each employee. Which two Data Analysis Expression (DAX) functions should you use? Each correct answer presents part of the solution. -PATHCROSSJOIN -EXCEPT PATHITEM -PATHITEM CROSSJOIN -RELATED
-EXCEPTPATH, PATHITEM CROSSJOIN
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 -filter -drillthrough -highlight
-Filter 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.
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? - From Power Query Editor, delete the changed type step. - 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. -From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
-From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column. To correctly update the data to text, you need to replace the # type conversion with a text conversion, and to keep all other data type column transformations. This needs to be done in PQE.
You need to create a new hierarchy in Power BI Desktop. What should you do first? -From the Model view, drag-and-drop one column onto another column in the fields pane -From the Model view, right-click and select Create hierarchy. -From the report view, drag-and-drop one column onto another column in the fields pane
-From the Model view, right-click and select Create hierarchy. To create a new hierarchy in PBI Desktop, you must select Create Hierarchy from the model view or report view.
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using Import instead of DirectQuery? -Full support for the Q&A Power BI service -Full support for the Quick Insights Power BI Service -Minimized local disk space usage -Minimized need for data refresh
-Full support for the Q&A Power BI service -Full support for the Quick Insights Power BI Service The import storage mode is fully supported with the Q&A and Quick Insights Power BI services
You are editing a report in Power BI Desktop. You need to adjust the behavior of the report by editing interactions. Which two types of interaction behavior can you change between visuals? -Highlight -Filter -Expand
-Highlight, filter A filter will show you the filtered data in the visual. Highlight is the default interaction between visuals. It shows you both the unfiltered and filtered values in the visuals, for comparison purposes.
You create a report that displays the sales data grouped by department. You need to use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for their department. What should you do first? -In PBI Desktop, create a role -In PBI Desktop, define filter parameters -Upgrade the Power BI workspace to Premium SKU
-In PBI Desktop, create a role To use row level security so employees in each dept can onl ysee the sales data for that dept, you first need to create a role and a corresponding DAX expression
You manage a Power BI workspace in shared capacity. The workspace contains a report that uses a dataset named DS1. You need to implement an incremental refresh of DS1. What should you do first? -In Power BI Desktop, define filter parameters. -In Power BI Desktop, define the incremental refresh policy. -Publish the dataset to the Power BI service.
-In Power BI Desktop, define filter parameters. To implement an incremental refresh of the dataset, you first need to define an incremental refresh policy, which, in turn, requires defining filter parameters.
You need to create a row level security (RLS) role for a dataset. What should you do first? -Assign workspace members to the security group in the Power BI service. -In Power BI Desktop, open Manage roles. - In Power BI Desktop, open the Advanced Editor in the Power Query Editor.
-In Power BI Desktop, open Manage roles. RLS roles are created or modified from the Manage roles space, in Power BI Desktop
When importing data from an Excel workbook into Power BI, you receive the error message: "We couldn't find any data formatted as a table." What should you do to resolve the error? -In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change. - In the Excel workbook, select the data you want to import, create a table, and save the change. - In Power BI, add a template app.
-In the Excel workbook, select the data you want to import, create a table, and save the change. Go back to the excel workbook, select data you want, Ctrl + T (to create a table), save
From Power BI Desktop, you create a data source by importing an Excel file that contains 10,000 rows. How do you ensure that column distribution considers all rows in the Excel file? -In the Power Query Editor window, enable the Column Profile view. -In the Data Source Settings, modify the Edit Permissions settings. -In the Power Query Editor window, modify the Query Settings.
-In the Power Query Editor window, enable the Column Profile view. To ensure that column distribution considers all rows in the Excel file, modify the Power Query Editor profiling status setting.
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? -In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis -In the Format pane, modify the Maximum Range setting. -In the Filters pane, add a filter based on the year.
-In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis To prevent users from viewing the hierarchy based on the year, you remove just the year from the data hierarchy fields in the x-axis in the Visualization pane.
You have implemented role-based security that restricts access to a Power BI Desktop dataset for users who are assigned the role named Salespeople. You need to validate that the implementation works. What should you do? - In Power Query Editor, add a conditional column to the Salesperson table -In the Report view, activate the View as feature -In the Report view, add a DAX expression filter to the Salesperson table -In the Report view, create a what-if parameter.
-In the report view, activate the View as feature. Activating the View As feature will allow you to test row-level security as someone with the Salesperson role.
You are creating a Power BI dashboard. You need to apply a custom theme to the dashboard from another Power BI dashboard theme. Which type of file should you use -CSV -JSON -XML
-JSON Themes use JSON file format. To copy themes between workspaces, you can download and upload them as JSON files.
Given this DAX expression "Current Inventory Count = CALCULATE ( SUM ( 'Warehouse'[Inventory Count] ))" You need to ensure that Current Inventory Count returns only the current total number of inventory items, rather than the sum of all inventory items that includes item counts from previous days. What DAX function should you include in the query? -LASTDATE -COUNTDISTINCT -CALENDAR
-LASTDATE
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? -Merge the queries to create a single loaded table for Product -Import only the ProductName into the model -Import all 3 tables into data model and connect them using relationships
-Merge the queries to create a single loaded table for Product 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.
You load the SalesOrders and SalesOrderDetails tables into Power BI Desktop. The tables have a relationship based upon the SalesOrderID column. You need to combine the two tables into one table. The solution must meet the following requirements: There is a row for every SalesOrderDetails row in the resulting table, even if there is no corresponding SalesOrders row. For every SalesOrderDetails row, the row in the resulting table includes the corresponding SalesOrders row data if the SalesOrder row exists. Any SalesOrder row data that does not have corresponding SalesOrderDetails rows is not included in the resulting table. What should you do to combine the two tables? -Merge the tables using the full outer join kind based on the sales order id. -Merge the tables using the left outer join kind based on the sales order id. -Merge the tables using the inner join kind based on the sales order id.
-Merge the tables using the left outer join kind based on the sales order id. To construct the resulting table, it is necessary to merge tables using the left outer join kind with the SOD as the first table,.
You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365 credentials. Which two location types should you recommend? -local file -OneDrive for business -personal OneDrive account -SharePoint - team sites
-OneDrive for business, SharePoint - team sites Store flat files in OneDrive for Business and Sharepoint Online to configure scheduled refresh using Microsoft 365 credentials. Power BI prefers OneDrive Business over Personal due to its better integration with 365 and support for scheduled refresh. Collaboration is also limited in OD Personal.
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? -Data view -Model View -Power Query Editor
-PQE PQE provides the ability to display column distri and column quality graphs.
You need to determine query timings for a report page visual. Which method should you use? -Use the performance analyzer -Use session diagnostics from the PQE -Refresh the data model
-Performance Analyzer -The Performance Analyzer will show the query timings for each object on a report page. Session diagnostic measures PQ query performance as it relates to refresh times, it is unrelated to measuring DAX performance or page query timings.
You have an Excel spreadsheet that contains two columns as follows: -Category: Contain names of categories -Subcategory: Contain names of subcategories for each category You import the Excel spreadsheet into Power BI Desktop. You need to transform the data to meet the following requirements: -Have multiple columns, where one column represents one category -Have a single row that includes the total count of subcategories for each category Which transformation should you use? -Pivot columns -Unpivot columns -Transpose Table
-Pivot Columns The pivot column operation converts data into a table by aggregating values in a column. In this case, you can pivot the columns to calculate the count of product subcategories in each product category.
You need to create a Power BI Dashboard. Which tool do you use? -Power BI Desktop -Power BI Service
-Power BI Service The Power BI Service supports creating power bi dashboards
You need to reduce the cardinality of a column in a Power BI dataset. What should you do? -reduce the number of distinct values -replace number of distinct values -add a suffix to each value in the column
-Replace the number of distrinct values A column that has a lot of repeated values and a low number of distinct values will have a low cardinality.
The ProductID column contains values that have a prefix of PD followed by five numbers. For example: pd15332. You plan to convert the ProductID values to numbers (integer). You need to remove the leading two letters from the current ProductID values. Which command should you use? -Remove rows -Replace errors -Replace values -Trim
-Replace values Only Replace values command allows the removal of leading characters from the column values. Trim removes leading and tailing whitespace.
In Power BI Desktop, you need to create a measure. Which two interfaces can you use? -Data view -Model view -PQE -Report view
-Report view, data view 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.
You need to add a new visual to a Power BI Dashboard. This visual does NOT exist on a report in the workspace. What should you do first? - Select Ask a Question about your data - Select Add a tile - Open the file menu
-Select Ask a Question about your data The Q&A feature lets you create a visual by typing in a question about your data. This new visual can then be pinned to the dashboard, without adding it to a report
You are designing a data model for Power BI Desktop. You need to reduce the model size. Which technique should you use to reduce the model size? -Configure the Query reduction option Filters settings. -Configure the Query reduction option Slicers settings. -Set the Storage Mode property of tables to Direct Query -Set the Storage Mode property of tables to Import.
-Set the Storage Mode property of tables to Direct Query. Setting the storage mode property of tables to direct query reduces the model size since only schema of the data source is stored locally
You have multiple Excel files stored in a folder synced with OneDrive for Business. You need to import data from the files. The solution must NOT use a data gateway. Which type of connector should you use? - Excel workbook - Folder - SharePoint folder
-SharePoint folder A SharePoint folder is the only connector that will allow the import of multiple Excel files stored in a OneDrive for business folder, without using a data gateway.
You need to create a DAX formula that will list 10 best-selling products sorted by their total sales. Which DAX function should you use -rankx -topn -maxa
-TOPN The TOPN function returns Top N rows of a specified table.
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? -aggregate per category -mathematical operations -time intelligence -X-functions
-Time Intelligence Time intelligence functions have performance implications and are disabled for quick measures against DirectQuery tables.
You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a RLS table that contains a column with the emails of users in the following format: [email protected] Which function should be used in the code for the RLS role to match the users Microsoft Entra ID login credentials with the emails contained in the RLS table column? -TREATAS -USEROBJECTID -USERPRINCIPALNAME
-USERPRINCIPALNAME USERPRINCIPALNAME would return the Microsoft Entra ID login in the format of "[email protected]".
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? - Clear permissions on the data source in Power BI. - Use the CAST function in the SQL statement. - Use the DATALENGTH function in the SQL statement.
-Use the CAST function in the SQL statement This error happens when PBI incorrectly interprets the data type, to resolve: use the CAST function to specify intended datatype
You connect Power Query Editor to a database table. You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future. What transformation should you use? - Select Row ID, then use the Remove Other Columns command. -Use the Remove Column command on the Row ID column. -Use the Select Columns command and chose the columns to keep.
-Use the Select Columns command and chose the columns to keep. Only the Select Columns command will let you choose columns to keep, delete the columns you do not want, and prevent new columns from showing up in the table in the future.
You are evaluating whether you need to create a dashboard in Power BI. In which scenario do you need a dashboard instead of a report in Power BI? -You need to add slicers -You need to display visuals that use different datasets -You need to display visuals on multiple pages
-You need to display visuals that use different datasets Combining data from multiple datasets is one feature that is available in dashboards but not in reports. Dashboards can only contain a single page.
You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram? -Bin group type -date/time column -list group type -numerical column
-a bin group type, numerical column -The group is created against a numerical column using bins. The bin group type is an auto grouping of items into bucketed bins (groups)
You manage a Power BI workspace. You need to delegate the task to update workspace metadata. The solution must use the principle of least privilege. Which role should you use? -viewer -admin -member
-admin Admin role is the only one that has the permission to update workspace metadata
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? -a deployment pipeline -a workspace -an app
-an app Apps can be installed automatically for any user in an org, and w/out requiring notifications of installation.
You have a Power BI model. You need to assign items to a display folder. Which three items can be assigned to a display folder? -calculated column -column -measure -report -table
-calculated column, column, measure Columns, calculated columns, and measures can be assigned a display folder.
You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals reach a certain threshold. Which three types of visuals support the alert functionality? - card - gauge - KPI -treemap -waterfall
-card, guage, kpi Alerts are available with KPI visuals, guages, and cards
You need to set your Power BI dashboard to discoverable. Which two configurations will allow the dataset to be marked as discoverable? -enable the RLS on the dataset -certify the dataset -promote the dataset
-certify the dataset -promote the dataset A certified dataset and a promoted dataset can be configured to be discoverable for users without access to request permissions to access.
You need to make changes to your data sources. Which three changes are supported by the Data Source Settings in PQE? -adding a column -clearing permissions -editing permissions -modifying the file path -renaming a column
-clearing permissions, editing permissions, modifying the file path The Data Source Settings in PQ interface supports editing and clearing permissions, and modifying the path of the data source.
You need to add an analytics line to a visual. The value for the line must equal the result of a DAX measure that always returns a consistent single value. The DAX measure must only be used to populate the analytics line. -max line -average line -constant line
-constant line Either the X or Y axis constant line allows a DAX measure to be used to provide this value for the visual.
You manage a Power BI workspace. You need to delegate the task to schedule data refreshers. The solution must use the principle of least privilege. Which role should you use? -admin -member -contributor
-contributor The Contributor role is the least privileged role that grants permissions to schedule data refreshes. The Member role grants permission to schedule data refreshes but is more privileged than Contributor. The Admin role grants the permissions to schedule data refreshes but is more privileged than Member.
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? -Custom visual -filter -image -ribbon chart
-custom visual, image, ribbon chart Dashboards are designed to be an "at-a-glance" perspective. Reports are built to be filtered and interactive (can't be pinned to a dashboard) Custom visuals, ribbon charts, and images can be pinned to a dashboard.
You plan to use the calculated table functionality to add a duplicate table in Power BI Desktop. Which characteristics of the original table will be duplicated? -data and column visibility only -data and hierarchies only -data only
-data only A calculated table only duplicates data. Any model configurations like column visibility or hierarchies must be recreated if needed
Which two data types can be used to display a continuous axis on a visual? -binary -date -decimal number -text
-date, decimal number **Think Dates and decimal numbers are never ending
What two types of data support bin-based grouping? -binary -date/time -numeric -text
-date/time, numeric
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? -directquery -dual import
-dual 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 assessing data from FactOnlineSales.
You have a Power BI report that uses a dataset that is imported from a database. You add a slicer to a report. You need to sync the slicer to use it on other report pages. What is required to sync slicers between report pages? -each slicer must be the same slicer type -each slicer must use the same column -each slicer must be visible
-each slicer must use the same column The same column must be used in each slicer for them to recognize each other in the sync slicers settings
You have a Power BI Desktop model. You need to determine when to use implicit and explicit measures. What is a feature of an implicit measure that explicit measure does NOT have? --end-users can change the aggregation type of implicit measures from the Values well of a visual -implicit measures can be used with field parameters -implicit measures can be used as a drill through field -implicit measures can be used to create quick measures
-end-users can change the aggregation type of implicit measures from the Values well of a visual Implicit measures can select from one of nine aggregations when placed in the Values well of a visual. Both implicit and explicity measures can be used as a drillthrough field, create quick measures, and field parameters
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? -Funnel -Slicer -Treemap
-funnel A funnel visualization displays a linear process with sequentially connected stages, with one stage transitioning to the next.
You need to create a custom R visual by using Power BI Desktop. What do you need to do first? -enable preview features in Power BI desktop -install R on your computer -Enable the script visuals option in the Visualization pane of Power BI Desktop.
-install R on your computer To create a custom R visual by using Power BI Desktop, you first need to install R on your computer.
Which native AI visual helps explain correlations for a metric within the dataset? -key influencers visual -Q&A visual -Smart Narrative visual
-key influence visual The key influencers visual helps you understand correlated factors impacting a particular metric
You have designed a star schema to simplify your data. You need to understand the relationship between the tables in the star schema. What is the relationship between the fact table and dimension tables? many-to-one one-to-many
-many to one There is a many-to-one relationship between a fact table and dimension table. For each row in a dimension table there may be multiple matching rows in a fact table.
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? -table -scatter -matrix
-matrix a matrix visualizaton displays data in 2 or more dimensions and cross-highlights with other visuals on the same report page
You plan to build a Power BI report and set up conditional formatting of data fields. You need to identify two visuals that support the conditional formatting functionality. Which two types of visuals should you identify? -guaage -matrix -scatter plot -table -treemap
-matrix, table Matrix and table support conditional formatting.
You have a Power BI dataset that gets data from a table in a SQL Server database. From which view in Power BI Desktop can you modify the storage mode of the table? -data view -model view -page view
-model view The storage mode of a table in PBI Desktop is configurable from the model view.
You upload reports to the Power BI service and pin several visuals to a dashboard. You plan to create alerts rules for several visuals. What are two locations you can view the alerts? -email -report -notification center
-notification center, email Notifications are available in the notification center. You can also send notifs via email.
You decide to remove unnecessary columns from your data model. What are two potential performance benefits of doing this? -increasing DAX performance -increasing the refresh speed -reducing the size of the data model
-reducing the size of the data model, increasing the refresh speed Fewer columns mean there is less data to import and will reduce the model size and decrease the time it takes to refresh the model
In PBI Desktop, you need to create a role. Which two interfaces can you use? -report view -PQE -data view -model view
-report view, model view Model view allows you to create and manage relations and creating roles. Report view allows you to manage roles and create roles
You need to create a visual that displays sales by employees, trending over months. The visual must clearly show how employees are performing against each other and have a ranking for each period. Which visual should you use? -clustered bar chart -ribbon chart -scatterplot
-ribbon chart A ribbon chart places the highest ranked value at the top of the stacked column each month and shows those ranked changes over time.
You plan to get data from flat files for a Power BI dataset. You need to select a location to store the files. Which location requires an on-premises data gateway? -shared folder on a local network -sharepoint online teams sites -personal onedrive account
-shared folder on a lcoal network The shared folder on a local network will require a gateway as it is not available on the internet
You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? -the filtered (cross-highlighted) -a report page tooltip with cross-highlighted data -the un-filtered (non-cross-highlighted) tool data
-the filtered (cross-highlighted) Report tooltips will apply the filter from cross-highlighted data in to the tooltip.
You import an Excel file into PBI Desktop and begin to analyze the data in PQE. You need to identify outliers in a text column within the data source. Which information should you use from Power Query Editor? - the min and max values in Column profile - the top and bottom entries in Value distribution -the value of the Unique entry in column stats
-the top and bottom entries in Value distribution The top and bottom entries in Value distribution identify outliers, which appear, respectively, the greatest and the smallest number of times in that column.
You plan to create a report in Power BI Desktop. You need to identify the type of visualization that displays data as a set of nested rectangles. Which visualization should you use? -bar chart -slicer -treemap
-treemap A treemap displays data as a set of nested rectangles
You need to assign an app workspace role for users who consume reports. Users should only have permissions to examine the report. Which role should you assign to users? -admin role -viewer role -member role
-viewer role The Viewer role only has reader access to view reports and dashboards. The contributor role can create, update, or publish content. The Member role has many edit permissions in a workspaces, the Admin role has all the edit permissions in a workspace.
You plan to create a report in Power BI Desktop. You need to create a visualization to display a running total. The solution must meet the following requirements: The initial and the final value columns must start on the horizontal axis. The intermediate values must be floating columns. Which type of visualization should you use? -watefall -scatter -matrix
-waterfall waterfall visualization is a chart that displays a running total, with the initial and the final value columns starting on the horizontal axis while the intermediate values are floating columns.
You plan to create a Power BI workspace. You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created. Which setting should you configure when creating the workspace? -develop a template app -workspace onedrive -license mode
-workspace onedrive The Workspace OneDrive setting allows you to configure a Microsoft 365 group whose SharePoint Online document library is available to workspace users once the workspace is created.
You have a Power BI Desktop PBIX file that contains a single page report with multiple visuals. You plan to use Performance Analyzer to evaluate the performance of the visuals. You need to eliminate the impact of visual caching during the evaluation. What should you do first? -reopen the PBIX file -add a blank page to the PBIX file -Start recording
Add a blank page to the PBIX file -To eliminate the impact of visual caching during a performance evaluation when using Performance Analyzer to evaluate visuals, you first add a blank page to report > select that page > then reopen the PBIX file.
You need to enhance a data model by using Power BI Desktop. Data for which two model items can be created using the DAX language? -calculated table -numeric range parameter -hierarchies
calculated table, numeric range parameter Calculated tables, numeric range parameters (used to create a table and measure) are both generated with DAX queries
You need to develop a quick measure in Power BI Desktop. Which two elements can you use? -calculations -DAX -fields -m function
calculations, fields When creating a quick measure in Desktop, you apply calculations to fields. You do not explicitly create a DAX query, but you choose calculations and fields
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? -many-to-many -many-to-one -one-to-many -one-to-one
many-to-many Many-to-many cardinality in Power BI should be avoided due to ambiguity, resulting from the presence of non-unique values
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you should use the DirectQuery storage mode or the Import storage mode. What are two benefits of using DirectQuery instead of Import? -Full support for the Q&A Power BI service -Full support for the Quick Insights Power BI Service -Minimized local disk space usage -Minimized need for data refresh
minimized local disk space usage, minimized need for data refresh DirectQuery minimizes local disk space use and eliminates the need for data refresh
You plan to certify a Power BI dataset. You need to identify at which level within your organization the permissions to certify a dataset are assigned. Which level should you identify? -dataset -workspace -tenant
tenant admin users who have permissions to certify a dataset are defined in the Dataset Certification Tenant Admin Setting
You plan to optimize the performance of Power BI Desktop queries against a remote data source. You need to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report. Which option should you configure in Power BI Desktop? -Filters Query reduction settings -the Reduce number of queries sent by Query reduction settings -the Slicers Query reduction settings
the Reduce number of queries sent by Query reduction settings
