PL - 300 Microsoft Power BI Data Analyst Practice Questions
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. a. Data view b. Page view c. Power Query Editor d. Report view
a. Data view d. Report view
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? Select only one answer. a. clustered bar chart b. ribbon chart c. scatterplot d. treemap
b. ribbon chart
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? Select only one answer. a. You need to add filters. b. You need to add slicers. c. You need to display visuals on multiple pages. d. You need to display visuals that use different datasets.
d. You need to display visuals that use different datasets.
You need to create a Power BI dashboard. Which tool should you use? Select only one answer. a. Power BI Desktop b. Power Query Editor c. the Power BI mobile app d. the Power BI service
d. the Power BI service
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? Select only one answer. a. bar chart b. column chart c. slicer d. treemap
d. treemap
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. Select all answers that apply. 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. Create a parameter. d. From the Data source settings, update the server source to use a parameter.
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. a. Custom visual b. Filter c. Image d. Ribbon chart e. Slicer
a. Custom visual c. Image d. Ribbon chart
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? Select only one answer. a. Add a blank page to the PBIX file. b. Connect DAX Studio to the data model. c. Reopen the PBIX file. d. Start recording.
a. Add a blank page to the PBIX file.
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? Each correct answer presents a complete solution. Select all answers that apply. a. Add a linguistic schema to the dataset. b. Add synonyms to model fields. c. Configure the dataset as a composite model. d. Organize the dataset columns and measures into logical folders in the Fields pane.
a. Add a linguistic schema to the dataset. b. Add synonyms to model fields.
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? Select only one answer. a. Admin b. Contributor c. Member d. Viewer
a. Admin
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. a. Advanced Editor in the Power Query Editor b. Data view c. Formula Bar in the Power Query Editor d. Model view
a. Advanced Editor in the Power Query Editor
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? Select only one answer. a. CALCULATE b. FILTER c. IGNORE d. SUMX
a. CALCULATE
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? Each correct answer presents part of the solution. Select all answers that apply. a. Calculated column b. Column c. Measure d. Report e. Table
a. Calculated column b. Column c. Measure
You need to develop a quick measure in Power BI Desktop. Which two elements can you use? Each correct answer presents a complete solution. Select all answers that apply. a. Calculations b. Conditional columns c. Data Analysis Expression (DAX) queries d. Fields e. Power Query M functions
a. Calculations d. Fields
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. a. Certify the dataset. b. Enable RLS on the dataset. c. Promote the dataset. d. Publish dataset to a Premium workspace.
a. Certify the dataset. c. Promote the dataset.
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. a. Choose Columns b. Remove Columns c. Remove Other Columns d. Transpose
a. Choose Columns c. Remove Other Columns
You need to reduce the size of a Power BI model that contains two dimension tables named Date and Location, and one fact table named Temperatures. The Temperatures table contains the following fields: Reading Time (datetime) DateKey (date) LocationKey (whole number) Temp C (decimal) You have one row for every 5-minute interval for each location. The Temperatures table is related to the Date and Location dimensions by using many-to-one relationships. You need to reduce the cardinality of the table. The solution must ensure that the dataset supports reports that analyze average temperature by hour and location. What two actions should you perform? Each correct answer presents part of the solution. Select all answers that apply. a. Create a column that contains the time values for the start of the hour of the Reading Time value. b. Disable the query load on the Temperatures query in the Power Query Editor. c. Remove th
a. Create a column that contains the time values for the start of the hour of the Reading Time value. d. Use the Group By functionality to aggregate the rows by hour, DateKey, and LocationKey and then create an average Temp C value per row.
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? Select only one answer. a. Disable Make this relationship active for both relationships. b. Enable Apply security filter in both directions for both relationships. c. Enable Make this relationship active for both relationships. d. Set the cross-filter direction to both for each relationship.
a. Disable Make this relationship active for both relationships.
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. a. Divide the SQL statement into separate data sources. b. Implement aggregations in the SQL statement. c. Implement groupings in the SQL statement. d. Replace subqueries with nested queries.
a. Divide the SQL statement into separate data sources.
You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset. What two tasks should you perform? Each correct answer presents a complete solution Select all answers that apply. a. Enable Mark as date table for the Calendar table. b. From the Current File options in Power BI Desktop, disable Auto Date/Time c. From the Global options in Power BI Desktop, disable Auto Date/Time for new files. d. Set the Data Category to None for all Date and DateTime fields.
a. Enable Mark as date table for the Calendar table. b. From the Current File options in Power BI Desktop, disable Auto Date/Time
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? Select only one answer. a. End-users can change the aggregation type of implicit measure from the Values well of a visual. b. Implicit measures can be used as a Drillthrough field. c. Implicit measures can be used to create Quick measures. d. Implicit measures can be used with Field Parameters.
a. End-users can change the aggregation type of implicit measure from the Values well of a visual.
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? Select only one answer. a. In Power BI Desktop, define filter parameters. b. In Power BI Desktop, define the incremental refresh policy. c. Publish the dataset to the Power BI service. d. Upgrade the Power BI workspace to the Premium SKU.
a. In Power BI Desktop, define filter parameters.
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? Select only one answer. a. Open Power Query Editor. b. Retrieve the Cosmos DB account key. c. Retrieve the Cosmos DB connection string. d. Switch to the model view.
a. Open Power Query Editor.
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? Select only one answer. a. Pivot Columns b. Rename Columns c. Transpose Table d. Unpivot Columns
a. Pivot Columns
You need to create a histogram that will display ranges of integers in groups. Which two resources do you need to create the histogram? Each correct answer presents part of the solution. Select all answers that apply. a. a Bin group type b. a Date/time column c. a List group type d. a Numerical column
a. a Bin group type d. a Numerical column
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? Each correct answer presents a complete solution. Select all answers that apply. a. as a filter in the "Filters on this page" well of the Filters pane b. as a filter in the "Filters on this visual" well of the Filters pane c. as an item in the "Add drill-through fields here" well of the Visualizations pane d. as an item in the Fields well of a slicer
a. as a filter in the "Filters on this page" well of the Filters pane d. as an item in the Fields well of a slicer
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? Each correct answer presents a complete solution. Select all answers that apply. a. calculated table b. display folder c. hierarchies d. numeric range parameter
a. calculated table d. numeric range parameter
You plan to build a Power BI dashboard and set up alerts that will notify you when data presented in the visuals on the dashboard reach specific thresholds. Which three types of visuals support the alert functionality? Each correct answer presents a complete solution. Select all answers that apply. a. card b. gauge c. KPI d. treemap e. waterfall
a. card b. gauge c. KPI
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? Each correct answer presents a complete solution. Select all answers that apply. a. full support for the Q&A Power BI service b. full support for the Quick Insights Power BI service c. minimized local disk space usage d. minimized need for data refresh e. support for per table configuration
a. full support for the Q&A Power BI service b. full support for the Quick Insights Power BI service
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. a. funnel b. slicer c. treemap d. waterfall
a. funnel
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. a. many-to-many b. many-to-one c. one-to-many d. one-to-one
a. many-to-many
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 use? Select only one answer. a. CALENDAR b. CALENDARAUTO c. DATE d. DATEDIFF
b. CALENDARAUTO
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? Select only one answer. a. Add a blank page to the .pbix file and select it. b. Connect DAX Studio to the data model. c. Invoke the Clear Cache function. d. Invoke the Refresh Metadata function.
b. Connect DAX Studio to the data model.
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? Select only one answer. a. Add a blank page to the .pbix file and select it. b. Connect DAX Studio to the data model. c. This answer is correct.Invoke the Clear Cache function. d. Invoke the Refresh Metadata function.
b. Connect DAX Studio to the data model.
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. Which type of analytics line should you use? Select only one answer. a. Average line b. Constant line c. Max line d. Min line
b. Constant line
You manage a Power BI workspace. You need to delegate the task to schedule data refreshes. The solution must use the principle of least privilege. Which role should you use? Select only one answer. a. Admin b. Contributor c. Member d. Viewer
b. Contributor
You need to create a visual that will display information on a continuous axis. Which two data types can be used to display a continuous axis on a visual? Each correct answer presents a complete solution. Select all answers that apply. a. Binary b. Date c. Decimal Number d. Text
b. Date c. Decimal Number
You plan to use Power BI Desktop to analyze sales data of your company. You need to identify two types of data you will be able to use for creating bins that group the sales data. Which two data types should you identify? Each correct answer presents a complete solution. Select all answers that apply. a. Binary b. Date/time c. Numeric d. Text e. True/false
b. Date/time c. 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? Select only one answer. a. DirectQuery b. Dual c. Import d. none
b. Dual
You are analyzing query data by using Power Query Editor. You need to ensure that the Column statistics are based on an analysis of the entire dataset. What should you do? Select only one answer. a. Change the query connection type from Import to DirectQuery. b. From the status bar, change profiling status to entire dataset. c. In Power Query Editor, enable column profiling from the View ribbon. d. Load the data into the data model.
b. From the status bar, change profiling status to entire dataset.
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. The solution must minimize development effort. What should you do first? Select only one answer. a. Add a bookmark in the Bookmarks Pane. b. Hide the three cards in the Selection Pane. c. Publish the report to the Power BI Service. d. Select the Spotlight option on the clustered bar chart.
b. Hide the three cards in the Selection Pane.
You manage a Power BI workspace that includes a dataset with your company's sales data. 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? Select only one answer. a. Deploy the report to the Power BI service. b. In Power BI Desktop, create a role. c. In Power BI Desktop, define filter parameters. d. Upgrade the Power BI workspace to the Premium SKU.
b. In Power BI Desktop, create a role.
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? Select only one answer. a. In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change. b. In the Excel workbook, select the data you want to import, create a table, and save the change. c. In Power BI, add a template app. d. In Power BI, add an organizational app.
b. In the Excel workbook, select the data you want to import, create a table, and save the change.
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? Select only one answer. a. In Power Query Editor, add a conditional column to the Salesperson table. b. In the Report view, activate the View as feature. c. In the Report view, add a DAX expression filter to the Salesperson table. d. In the Report view, create a what-if parameter.
b. In the Report view, activate the View as feature.
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? Select only one answer. a. CSV b. JSON c. XML d. YAML
b. JSON
Which native AI visual helps explain correlations for a metric within the dataset? Select only one answer. a. Decomposition Tree visual b. Key influencers visual c. Q&A visual d. Smart Narrative visual
b. Key influencers visual
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. a. Data view b. Model view c. Page view d. Report view
b. Model view
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? Select only one answer. a. Data view b. Model view c. Page view d. Report view
b. Model view
In Power BI Desktop, you need to create a role. Which two interfaces can you use? Each correct answer presents a complete solution. Select all answers that apply. a. Data view b. Model view c. Page view d. Power Query Editor e. Report view
b. Model view e. Report view
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? Each correct answer presents a complete solution. Select all answers that apply. a. local file b. OneDrive for Business c. Personal OneDrive account d. SharePoint - Team Sites
b. OneDrive for Business d. SharePoint - Team Sites
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. a. Advanced Editor in Power Query Editor b. Power Query Editor c. the Data view d. the Model view
b. Power Query Editor
You have a query that has a column named Country and columns for each month of sales data. The names of the sales data columns use a format of Month Year, for example January 2022. The month columns contain the Sales Amount values for each month. You need to reshape the table to have all sales amount values in a single column. A new column should also be added and contain the relevant month year for each row of data. What should you do from the Power Query Editor? Select only one answer. a. Select the Country column and then select Pivot Column. b. Select the Country column and then select Unpivot Other Columns. c. Select the first sales data column and then select Unpivot Columns. d. Select Transpose.
b. Select the Country column and then select Unpivot Other Columns.
You have the following Power Query M formula that generates a range of dates. = List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0)) What is the resulting date range? Select only one answer. a. a list of days ending on May 31, 2020 and starting 365 days earlier b. a list of days starting on May 31, 2020 and ending 365 days later c. a list of months ending in May 2020 and starting 12 months earlier d. a list of months starting in May 2020 and ending 12 months later
b. a list of days starting on May 31, 2020 and ending 365 days later
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? Each correct answer presents a complete solution. Select all answers that apply. a. a report b. an email c. Microsoft Teams d. the Notification Center
b. an email d. the Notification Center
You need to make changes to your data sources. Which three changes are supported by the Data Source Settings in the Power Query interface? Each correct answer presents a complete solution. Select all answers that apply. a. adding a column b. clearing permissions c. editing permissions d. modifying the file path e. renaming a column
b. clearing permissions c. editing permissions d. modifying the file path
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? Select only one answer. a. many-to-many b. many-to-one c. one-to-many d. one-to-one
b. many-to-one
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. a. Card b. matrix c. scatter d. table
b. matrix
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? Each correct answer presents a complete solution. Select all answers that apply. a. gauge b. matrix c. scatter chart d. table e. treemap
b. matrix d. table
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query Editor. You need to identify outliers in a text column within the data source. Which information should you use from Power Query Editor? Select only one answer. a. the min and max values in Column profile b. the top and bottom entries in Value distribution c. the value of the Distinct entry in Column statistics d. the value of the Unique entry in Column statistics
b. the top and bottom entries in Value distribution
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? Select only one answer. a. 1 b. 4 c. 8 d. 24
c. 8
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. a. Add a calculated column to the Salesperson table. b. Add a conditional column to the Salesperson table. c. Add a DAX expression filter to the Salesperson table. d. Create a role. e. Create a what-if parameter.
c. Add a DAX expression filter to the Salesperson table. d. Create a role.
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 three configurations should you make? Each correct answer presents part of the solution. Select all answers that apply. a. Disable the Data option. b. Disable the Current Page option. c. Disable the Display option. d. Enable the Current Page option. e. Enable the Data option. f. Enable the Display option.
c. Disable the Display option. d. Enable the Current Page option. e. Enable the Data option.
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. Select all answers that apply. a. PATHCROSSJOIN b. EXCEPT PATHITEM c. EXCEPTPATH d. PATHITEM CROSSJOIN e. RELATED
c. EXCEPTPATH d. PATHITEM CROSSJOIN
You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? Select only one answer. a. Configure global Python scripting options in Power BI Desktop. b. Enable preview features in Power BI Desktop. c. Enable the script visuals option in the Visualization pane of Power BI Desktop. d. Install Python on your computer.
c. Enable the script visuals option in the Visualization pane of Power BI Desktop.
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. a. In the Data Source Settings, modify the Advanced settings. b. In the Data Source Settings, modify the Edit Permissions settings. c. In the Power Query Editor window, enable the Column Profile view. d. In the Power Query Editor window, modify the Query Settings.
c. In the Power Query Editor window, enable the Column Profile view.
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. a. Import all three tables into the data model and connect them using relationships. b. Import only the ProductName table into the model. c. Merge the queries to create a single loaded table for Product. d. Use the append command to create a single loaded table for product.
c. Merge the queries to create a single loaded table for Product.
You need to create a dashboard from a published report in Power BI. Which option in the report should you use? Select only one answer. a. Copy visual as image b. Export data c. Pin visual d. Spotlight
c. Pin visual
You have a table that contains a column named ProductID. 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? Select only one answer. a. Remove Rows b. Replace Errors c. Replace Values d. Trim
c. Replace Values
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? Select only one answer. a. Configure the Query reduction option Filters settings. b. Configure the Query reduction option Slicers settings. c. Set the Storage Mode property of tables to Direct Query. d. Set the Storage Mode property of tables to Import.
c. Set the Storage Mode property of tables to Direct Query.
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? Select only one answer. a. Excel workbook b. Folder c. SharePoint folder d. SharePoint list
c. SharePoint folder
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 only one answer. a. Select Row ID, then use the Remove Other Columns command. b. Use the Remove Column command on the Row ID column. c. Use the Select Columns command and chose the columns to keep. d. Use the Transpose command, then filter the rows to remove Row ID.
c. Use the Select Columns command and chose the columns to keep.
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. a. a deployment pipeline b. a workspace c. an app d. metrics
c. an app
You have several on-premises Microsoft SQL Server databases. You need to provide Power BI Service users access to the data sources without exposing the database servers directly to the internet. The solution must minimize the configurations that must be performed by each user. What should you deploy? Select only one answer. a. a virtual network data gateway b. an ExpressRoute connection c. an on-premises data gateway d. an on-premises data gateway (personal mode)
c. an on-premises data gateway
Your company has a SharePoint server located in a datacentre in Montreal. 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? Select only one answer. a. a Point to Site virtual private network (VPN) b. a Site-to-Site virtual private network (VPN) c. an on-premises data gateway d. Azure Data Box
c. an on-premises data gateway
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. a. expand b. drillthrough c. filter d. highlight
c. filter
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? Each correct answer presents a complete solution. Select all answers that apply. a. drillthrough b. expand c. filter d. highlight
c. filter d. highlight
You decide to start using variables when creating DAX formulas. What are two benefits of using variables in DAX measures over using original expressions? Each correct answer presents a complete solution. Select all answers that apply. a. allows users to change the data source connection in the DAX measure b. has additional functions that can be used in the DAX measure c. improves the overall performance of the resulting DAX measure d. improves the overall readability of the resulting DAX measure
c. improves the overall performance of the resulting DAX measure d. improves the overall readability of the resulting DAX measure
You decide to remove unnecessary columns from your data model. What are two potential performance benefits of doing this? Each correct answer presents a complete solution. Select all answers that apply. a. decreasing report page load times b. increasing DAX performance c. increasing the refresh speed d. reducing the size of the data model
c. increasing the refresh speed d. reducing the size of the data model
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? Each correct answer presents a complete solution. Select all answers that apply. a. full support for the Q&A Power BI service b. full support for the Quick Insights Power BI service c. minimized local disk space usage d. minimized need for data refresh
c. minimized local disk space usage d. minimized need for data refresh
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. a. card b. gauge c. scatter d. treemap
c. scatter
You plan to create a report in Power BI Desktop that will display the relationship between the number of orders and the number of orders shipped by product category. You need to identify the visual that will clearly identify outliers in the data set by displaying them away from the bulk of data. Which visual should you use? Select only one answer. a. card b. gauge c. scatter d. treemap
c. scatter
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? Select only one answer. a. the Filters Query reduction settings b. the Persistent filters of Report settings c. the Reduce number of queries sent by Query reduction setting d. the Slicers Query reduction settings
c. the Reduce number of queries sent by Query reduction setting
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. a. aggregate per category b. mathematical operations c. time intelligence d. X-functions
c. time intelligence
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? Select only one answer. a. Each slicer must be the same slicer type. b. Each slicer must be visible. c. Each slicer must have the same title. d. Each slicer must use the same column.
d. Each slicer must use the same column.
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. a. From the data view in Power BI Desktop, change the column data type from number to text. b. 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. c. From Power Query Editor, delete the changed type step. d. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
d. From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
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. a. In the Filters pane, add a filter based on the quarter, month, and day. b. In the Filters pane, add a filter based on the year. c. In the Format pane, modify the Maximum Range setting. d. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.
d. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.
You need to create a custom R visual by using Power BI Desktop. What do you need to do first? Select only one answer. a. Configure global R scripting options in Power BI Desktop. b. Enable preview features in Power BI Desktop. c. Enable the script visuals option in the Visualization pane of Power BI Desktop. d. Install R on your computer.
d. Install R on your computer.
You have created a Power BI dataset and need to create multiple reports. What is a benefit of using a Power BI dataset as a data source for multiple reports compared to each report having a separate dataset? Select only one answer. a. It increases the number of scheduled refreshes that can be configured for the Power BI dataset. b. It increases the speed of the reports and visuals connected to the Power BI datasets. c. It prevents sensitive data from being shared with report consumers. d. It reduces the number of datasets, refreshes, and storage requirements in the Power BI service.
d. It reduces the number of datasets, refreshes, and storage requirements in the Power BI service.
You have an Azure SQL database that contains two tables named SalesOrders and SalesOrderDetails. 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? Select only one answer. a. Append the tables. b. Merge the tables using the full outer join kind based on the sales order id. c. Merge the tables using the
d. Merge the tables using the left outer join kind based on the sales order id.
You need to reduce the cardinality of a column in a Power BI dataset. What should you do? Select only one answer. a. Add a prefix to each value in the column. b. Add a suffix to each value in the column. c. Replace null values with a value of 0. d. Reduce the number of distinct values
d. Reduce the number of distinct values
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 only one answer. a. Open See Related Content. b. Open the File menu. c. Select Add a tile. d. Select Ask a question about your data.
d. Select Ask a question about your data.
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? Select only one answer. a. OneDrive for Business b. Personal OneDrive account c. SharePoint Online Team Sites d. Shared folder on a local network
d. Shared folder on a local network
You plan to use Power BI Desktop to create a report with multiple visualizations. You need to create a visual that supports the following: filters other visuals on the same report page allows users to search for values by which to filter the other visuals Which type of visualization should you use? Select only one answer. a. Funnel b. Matrix c. Scatter chart d. Slicer
d. Slicer
You plan to use Power BI Desktop to analyze sales data for products sold by your company. 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? Select only one answer. a. MAXA b. MAXX c. RANKX d. TOPN
d. TOPN
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? Select only one answer. a. NAMEOF b. TREATAS c. USEROBJECTID d. USERPRINCIPALNAME
d. USERPRINCIPALNAME
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. a. Refresh the data model. b. Run the Best Practices analyzer in Tabular Editor. c. Use Session Diagnostics from the Power Query Editor. d. Use the Performance analyzer.
d. Use the Performance analyzer.
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? Select only one answer. a. Admin role b. Contributor role c. Member role d. Viewer role
d. Viewer role
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? Select only one answer. a. Allow contributors to update the app b. Develop a template app c. License mode d. Workspace OneDrive
d. Workspace OneDrive
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? Select only one answer. a. combo b. funnel c. scatter d. waterfall
d. waterfall
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. a. Add a Table. b. Buffer applied step to the query. c. Change the query load type from Import to DirectQuery. d. Create a Top N row count parameter for the query. e. From the query window, select Column profiling on the entire dataset.
e. From the query window, select Column profiling on the entire dataset.
