Pl-300 Microsoft Practice Questions
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. Copy visual as image Export data Pin visual Spotlight
Pin visual The Pin visual option allows you to pin the visual to an existing dashboard or create a new one. The Copy visual as image option allows you to copy a visual as an image to Clipboard. The Export data option allows you to export data in the xlsx or csv formats, but not create a dashboard. The Spotlight option allows you to highlight a visual on the report page, but not create a dashboard. Introduction to dashboards - Training | Microsoft Learn
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. An on-premises data gateway A Point to Site virtual private network (VPN) A Site-to-Site virtual private network (VPN) Azure Data Box
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. VPN-based solutions would provide connectivity to an Azure virtual network, but not Power BI service. Azure Data Box is a solution for migrating data to Azure, which is not applicable in this scenario. Use a Power BI gateway to connect to on-premises data sources - Training | Microsoft Learn
You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? Select only one answer. Install Python on your computer. Configure global Python scripting options in Power BI Desktop. Enable the script visuals option in the Visualization pane of Power BI Desktop. Enable preview features in Power BI Desktop.
Enable the script visuals option in the Visualization pane of Power BI Desktop. Enabling the script visuals option in the Visualization pane of Power BI Desktop is required before creating custom Python visuals in Power BI Desktop. Installing Python is not required. Configuring global Python scripting options in Power BI Desktop is not required to create Python visuals. The ability to create a custom Python visual by using Power BI Desktop has no dependency on enabling preview features. Add an R or Python visual - Training | Microsoft Learn
You need to prevent a hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset. What should you do? Select only one answer. Enable Mark as date table for the Calendar table. From the Global options in Power BI Desktop, disable Auto Date/Time for new files. From the Current File options in Power BI Desktop, disable Auto Date/Time for new files. Set the Data Category to None for all Date and DateTime fields.
From the Current File options in Power BI Desktop, disable Auto Date/Time for new files. Disabling Auto Date/Time for new files from the Current File options will disable all Auto Date/Time tables in this dataset. Enabling Mark as date table for the Calendar table will only disable the auto datetime tables for this table. Other date or datetime columns in the model will still have auto datetime tables associated with them. Disabling the Global option Auto Date/Time for new files means that new files will no longer have Auto Date/Time enabled, but files in the current dataset will still have it enabled until it is disabled. Changing the data category will not impact the auto date table feature. Create a date table - Training | Microsoft Learn Auto date/time in Power BI Desktop - Power BI | Microsoft Learn Auto date/time guidance in Power BI Desktop - Power BI | Microsoft Learn
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. Refresh the data model. Use the Performance analyzer. Use Session Diagnostics from the Power Query Editor. Run the Best Practices analyzer in Tabular Editor.
Use the Performance analyzer. The Performance analyzer will show the query timings for each object on a report page. Session diagnostics measures Power Query query performance as it relates to refresh times. It is unrelated to measuring DAX performance or report page query timings. The Best Practices analyzer reviews the model for best practices around things like model design, relationships, field naming conventions, and measures. But is unrelated to any query timings for report page visuals. Review performance of measures, relationships, and visuals - Training | Microsoft Learn
You need to use a DAX measure (field value) to supply a single value for your visual. Which type of analytics line supports should you use? Select only one answer. constant line trend line forecast find anomalies
constant line Either the X or Y axis constant line allows a DAX measure to be used to provide this value for the visual. The trend line is an auto generated value. The forecast line is an auto generated value. The anomalies line is an auto generated value. Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn Work with Power BI visuals - Training | Microsoft Learn
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. Add synonyms to model fields. Configure the dataset as a composite model. Add a linguistic schema to the dataset. Organize the dataset columns and measures into logical folders in the Fields pane.
Add synonyms to model fields. Add a linguistic schema to the dataset. Adding synonyms to model fields will help users search for them. For example, you can give a synonym of (Actuals) for the (Sales) measure. A linguistic schema describes terms and phrases that Q&A should understand for objects within a dataset, including parts of speech, synonyms, and phrasings that relate to that dataset. Composite models are not supported by Q&A today. Organizing fields by display folders will not impact Q&A search capabilities. Use the Q&A visual - Training | Microsoft Learn
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. CALENDAR CALENDARAUTO DATE DATEDIFF
CALENDARAUTO The CALENDARAUTO function generates a range of dates based on the earliest and latest date within the dataset. The CALENDAR function generates a range of dates, but it requires providing the start and end date. The DATE function returns the specified date in the datetime format. The DATEDIFF function returns an interval between two dates. Create a date table - Training | Microsoft Learn
You import data from a .csv file to Power Query Editor. The data includes a column named ZIP that contains zip codes. 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. What should you do? Select only one answer. 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, delete the changed type step. From Power BI desktop, change the column data type from number to text.
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 number type conversion with a text conversion, and to keep all other data type column transformations. This needs to be done in the Power Query Editor. Evaluate and change column data types - Training | Microsoft Learn
You have a Power BI dataset that gets data from a table in a SQL Server database. From which in Power BI Desktop can you modify the storage mode of the table? Select only one answer. Data view Model view Report view Page view
Model view The storage mode of a table in Power BI Desktop is configurable from the Model view, not the Data or Report view. Page view is an option available from within the Report view. Select a storage mode - Training | Microsoft Learn
You plan to use Power BI Desktop to create a report with multiple visualizations. You need to create a standalone chart that will be dedicated to filtering other visuals on the same report page. Which type of visualization should you use? Select only one answer. funnel matrix scatter slicer
Slicer The slicer visualization is a standalone chart that can be used to filter the other visuals on the page. A funnel visualization is a chart that that has sequential connected stages, where items flow sequentially from one stage to the next. A matrix visualization displays data in a two or more dimensions and cross-highlights with other visuals on the same report page. A scatter visualization is a chart with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. Choose an effective visualization - Training | Microsoft Learn
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. an on-premises data gateway an on-premises data gateway (personal mode) a virtual network data gateway an ExpressRoute connection
an on-premises data gateway An on-premises gateway is designed to allow multiple users to access multiple data sources. An on-premises data gateway only allows one user to access multiple data sources. A virtual network data gateway is designed to allow multiple users to access multiple online data sources. However, it isn't installed locally and only works with data sources secured by virtual networks. Use a Power BI gateway to connect to on-premises data sources - Training | Microsoft Learn On-premises data gateway - Power BI | Microsoft Learn
You have Power BI Desktop. You need to create data for your model items. 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. calculated table numeric range parameter enter data tables display folder
calculated table numeric range parameter Calculated tables are generated with DAX queries. Numeric range parameters create a table and measure, both generated with DAX queries. The enter data button creates a manual table using the M language and Power Query. Display folders are a way to visually organize measures, columns, or hierarchies. DAX is not used to create them. Introduction to DAX - Training | Microsoft Learn
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? Select only one answer. data only data and hierarchies only data and column visibility only data, hierarchies, and column visibility
data only A calculated table only duplicates data. Any model configurations such as column visibility or hierarchies must be recreated if needed. Introduction - Training | Microsoft Learn
You need to create a visual that display 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. ribbon chart treemap clustered bar 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. A treemap is not meant for displaying changes over time and wouldn't easily show ranked comparisons between employees. The clustered bar chart can be used to show changes over time, and a clustered bar chart will show comparisons between employee, but no ranking data is provided between employees. A scatterplot is typically used to compare a relationship between two (or more) calculations and their categorical distribution between each other. Choose an effective visualization - Training | Microsoft Learn Use ribbon charts in Power BI - Power BI | Microsoft Learn
You need to create a new hierarchy in Power BI Desktop. What should you do first? Select only one answer. From the Report view, drag-and-drop one column onto another column in the Fields pane. 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, right-click and select Create hierarchy.
From the Model view, right-click and select Create hierarchy. To create a new hierarchy in Power BI Desktop, you must select Create hierarchy from the Model view. The option to create hierarchies from the Report view was removed as an option in 2021 because too many hierarchies were being accidentally created during development. You cannot drag-and-drop one field onto another to create a new hierarchy in the model view. You can only use this method to add additional fields to an already existing hierarchy. Work with dimensions - Training | Microsoft Learn
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. In Power BI Desktop, define filter parameters. In Power BI Desktop, define the incremental refresh policy. Upgrade the Power BI workspace to the Premium SKU. 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. An incremental refresh policy does not require upgrading to the Premium SKU. Publishing the dataset to the Power BI service is required for the incremental refresh policy to take effect, so it's the last step of setting up an incremental refresh. Configure incremental refresh settings - Training | Microsoft Learn
Which native AI visual helps explain correlations for a metric within the dataset? Select only one answer. Q&A visual Key influencers visual Decomposition Tree visual Smart Narrative visual
Key influencers visual The Key influencers visual helps you understand correlated factors impacting a particular metric. The Q&A visual allows end-users to ask natural language questions to create AI generated charts based on the questions. The Decomposition Tree visual lets you visualize data between multiple dimensions and drill down in any order. The Smart Narrative visual lets you combine natural language text with metrics from your model in sentence forms. Find important factors with the Key influencers visual - Training | Microsoft Learn
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. Data view Model view Report view Page view Power Query Editor
Model view Report view The Model view provides the ability to design and implement structure of a dataset and include the option to create a role. The Report view provides the ability to manage roles, including their creation. The Data view provides access to data within a dataset Power Query Editor provides the ability to transform and analyze data. The Page view is an option available from within the Report view and is intended to simplify designing and building reports. Implement row-level security - Training | Microsoft Learn
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. Card Scatter Treemap Gauge
Scatter A scatter visual displays a relationship between values associated with two axes: one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. It is particularly suitable for identifying outliers because it displays them away from the bulk of data. A card visual displays a single data point. A treemap visual displays data as a set of nested rectangles. A gauge visual displays a circular arc including a single value that measures progress toward a goal or target. Identify outliers with Power BI visuals - Training | Microsoft Learn
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. MAXA MAXX RANKX TOPN
TOPN The TOPN function returns Top N rows of the specified table, such as, for example, top 10 best-selling products sorted by their total sales. The MAXA function returns the largest value in a column. The MAXX function evaluates an expression for each row and returns the largest value. The RANKX function returns ranking of a number in a list of numbers for each row of a target table. Explore statistical summary - Training | Microsoft Learn
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. Use the Remove Column command on the Row ID column. Use the Transpose command, then filter the rows to remove Row ID. Use the Select Columns command and chose the columns to keep. Select Row ID, then use the Remove Other Columns command.
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. Shape the initial data - Training | Microsoft Learn
You have a Power BI data source that contains the following tables: Category: Lists the product category Subcategory: Lists the product subcategory ProductName: Lists the name of the product You need to optimize the star schema model for the Power BI dataset. How should the tables be imported into the model? Select only one answer. Import all three tables into the data model and connect them using relationships. Use the combine command to create a single loaded table for product. Import only the ProductName table into the model. Use the append command to create a single loaded table for product.
Use the combine command 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. Combine multiple tables into a single table - Training | Microsoft Learn
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. editing permissions modifying the file path clearing permissions adding a column renaming a column
editing permissions modifying the file path clearing permissions The Data Source Settings in the Power Query interface supports editing permissions, clearing permissions, and modifying the path of the data source file. Any structural changes to a file, such as adding, removing, or renaming columns are not supported by the Data Source Settings in the Power Query interface. Get data from files - Training | Microsoft Learn
You plan to get data for a Power BI dataset from flat files. You need a location type to store the files. The data must NOT automatically synchronize between the original file and the dataset. Which location type should you recommend? Select only one answer. local file SharePoint - Team Sites personal OneDrive account OneDrive for Business
local file The local file option will result in importing the file contents without providing automatic synchronization between the original file and the dataset. SharePoint - Team Sites, personal OneDrive accounts, and OneDrive for Business provide the ability to automatically synchronize flat files and Power BI datasets. Get data from files - Training | Microsoft Learn
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. reducing the size of the data model increasing the refresh speed increasing DAX performance decreasing report page load times
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. Since row counts aren't changing, the calculation speed of any existing DAX measures won't change. Report page load times are primarily determined by number of visuals (objects) on the page, and DAX performance. Neither of which are impacted by unnecessary model columns. Review performance of measures, relationships, and visuals - Training | Microsoft Learn
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. mathematical operations time intelligence aggregate per category X-functions
time intelligence Time intelligence functions have performance implications and are disabled for quick measures against DirectQuery tables. Mathematical operations, aggregate per category, and X-functions are all supported against DirectQuery. Introduction to DAX - Training | Microsoft Learn Use quick measures for common and powerful calculations - Power BI | Microsoft Learn
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. Which syntax should you use? Select only one answer. #date #duration List.Combine List.Durations
#duration The #duration function of the M language allows you to specify the datetime values that will be entered into individual rows of a date table. The #date function creates a date value based on the date parameters you specify. The List.Combine() combines multiple lists into one. List.Durations returns a list of count duration values, rather than dates. Create a date table - Training | Microsoft Learn Power Query M function reference - PowerQuery M | Microsoft Learn
You manage a Power BI workspace in a shared capacity. The workspace contains a dataset named DS1. You plan to schedule a refresh of DS1. What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule? Select only one answer. 2 4 16 64
4 If there are 4 consecutive data set refresh failures, the refresh schedule will be automatically disabled. Configure a dataset scheduled refresh - Training | Microsoft Learn
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 Data Analysis Expression (DAX) function should you use in combination with the SUM function to override the context and provide the result? Select only one answer. CALCULATE IGNORE FILTER SUMX
CALCULATE The CALCULATE function provides the result of the calculation with the ability to override the context. The IGNORE function modifies the behavior of the SUMMARIZECOLUMNS function by omitting specific expressions from the BLANK/NULL evaluation. The FILTER function returns a table that represents a subset of another table or expression. The SUMX function returns the sum of an expression evaluated for each row in a table. Use the Calculate function - Training | Microsoft Learn
You are editing a Power BI Desktop report visual that displays gross sales data with the hierarchy based on a year, quarter, month, and day. You need to prevent users from viewing the hierarchy based on the year. What should you do first? Select only one answer. In the Visualization pane, remove all date hierarchy fields from the Axis well. In the Visualization pane, modify the Format visual Range settings. In the Filters pane, add a filter based on the year. In the Filters pane, add a filter based on the quarter, month, and day.
In the Visualization pane, remove all date hierarchy fields from the Axis well. To prevent users from viewing the hierarchy based on the year, you should first remove all date hierarchy fields from the Axis well in the Visualization pane. Modifying the Format visual Range settings in the Visualization pane would affect the range of values displayed in the visual. Adding a filter based on the year in the Filters pane would filter the values displayed in the visual. Adding a filter based on the quarter, month, and day in the Filters pane would filter the values displayed in the visual, but would not prevent users from viewing the hierarchy based on the year. Use basic interactions - Training | Microsoft Learn
You plan to create a report in Power BI Desktop that will display sales opportunity 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. funnel slicer treemap waterfall
funnel A funnel visualization displays a linear process with sequentially connected stages, with one stage transitioning to the next. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not sequentially connected stages, with one stage transitioning to the next. A treemap visualization displays data a set of nested rectangles. A waterfall visualization displays a running total as values are added or subtracted. Choose an effective visualization - Training | Microsoft Learn
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. one-to-one one-to-many many-to-one many-to-many
many-to-many Many-to-many cardinality in Power BI should be avoided due to ambiguity, resulting from the presence of non-unique values. One-to-one cardinality in Power BI should be avoided and, if present, should be eliminated by combining the related tables. However, this type does not introduce ambiguity. One-to-many and many-to-one cardinality are two common cardinality types, used for the relationships between a fact and dimension tables. Work with relationships and cardinality - Training | Microsoft Learn
You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? Select only one answer. the un-filtered (non-cross-highlighted) total data the filtered (cross-highlighted) data both the un-filtered and filtered (cross-highlighted) data a report page tooltip with cross-highlighted data
the filtered (cross-highlighted) data By default, report tooltips will apply the filter from the cross-highlighted data into the tooltip. Report page tooltips need to be manually created, and are not assigned to a visual by default. Create report tooltip pages in Power BI - Power BI | Microsoft Learn Create a data-driven story with Power BI reports - Training | Microsoft Learn
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. bar chart column chart slicer treemap
treemap A treemap visualization displays data a set of nested rectangles. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not nested rectangles. A bar chart visualization present data as horizontal bars. A column chart present data as vertical columns. Choose an effective visualization - Training | Microsoft Learn
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. Select Add a tile. Select Ask a question about your data. Open the File menu. Open See Related Content.
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. Inside the file menu and the tiles menu there are no "visual" options. See Related Content displays related content like reports, datasets, etc. You can't create a new visual from here. Explore data by asking questions - Training | Microsoft Learn
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. Create a parameter. Create a query for the server name. 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. From the Data source settings in Power BI Desktop, update the permissions.
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 Power BI service, by accessing the dataset settings. Updating the server source to use a parameter will update all existing queries pointing to the current server to instead use a parameter with that server name. This parameter can now be changed once this dataset is published to the Power BI service. Get data from relational data sources - Training | Microsoft Learn Parameterize your data source! - Data - Marc (data-marc.com) Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD How to Parameterize Data Sources in Power BI | phData
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. Implement groupings in the SQL statement. Implement aggregations in the SQL statement. Replace subqueries with nested queries. Divide the SQL statement into separate data sources.
Divide the SQL statement into separate data sources. Dividing the SQL statement into separate data sources would minimize the amount of processing on the SQL Server side. This would minimize or even eliminate the timeout issues. Groupings, aggregations, and using nested queries would either have no impact on timeout issues or further increase the amount of processing on the SQL Server side, resulting in more frequent timeout issues. Resolve data import errors - Training | Microsoft Learn
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. End-users can change the aggregation type of implicit measure from the Values well of a visual. Implicit measures can be used to create Quick measures. Implicit measures can be used as a Drillthrough field. Implicit measures can be used with Field Parameters.
End-users can change the aggregation type of implicit measure 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 Explicit measures can be used as a Drillthrough field, to create quick measures, and with Field Parameters. Introduction - Training | Microsoft Learn Next
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. Add a Table.Buffer applied step to the query. From the query window, select Column profiling on the entire dataset. Change the query load type from Import to DirectQuery. Create a Top N row count parameter for the query.
From the query window, select Column profiling on the entire dataset. Selecting column profiling for the entire dataset will change the column profiler to analyze the entire query dataset. Adding a Table.Buffer applied step will only cache the entire query in memory during refresh. The query load type in the model will not impact how many rows are used by the column profiler. Using a Top N row count applied step or applying a parameter will not change how the column statistics feature calculates. Profile data in Power BI - Training | Microsoft Learn Using the data profiling tools - Power Query | Microsoft Learn
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. In Power BI Desktop, create a role. In Power BI Desktop, define filter parameters. Deploy the report to the Power BI service. Upgrade the Power BI workspace to the Premium SKU.
In Power BI Desktop, create a role. To use row-level security to ensure that, once the report is published, employees in each department can only see the sales data for that department, you first need to create a role and a corresponding DAX expression. Filter parameters are used for other purposes, such as incremental refresh policy, not row-level security. Deploying the report to the Power BI service is required for the row-level security to take effect, so it takes place after creating the relevant roles. Row-level security does not require upgrading to the Premium SKU. Configure row-level security with the static method - Training | Microsoft Learn
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. It reduces the number of datasets, refreshes, and storage requirements in the Power BI service. It increases the speed of the reports and visuals connected to the Power BI datasets. It prevents sensitive data from being shared with report consumers. It increases the number of scheduled refreshes that can be configured for the Power BI dataset.
It reduces the number of datasets, refreshes, and storage requirements in the Power BI service. When multiple reports use the same Power BI dataset vs each having their own import model, you reduce the number of datasets that are needed to be published to the Power BI service. Fewer datasets mean fewer refreshes, less storage space requirements, and less overhead for admins. Get data from Azure Analysis Services - Training | Microsoft Learn Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn
You have a Power BI Desktop dataset that includes a table named Warehouse. The Warehouse table includes a column named Inventory Count, which contains the current number of items for each row, of a particular type on a given day. You have the following Data Analysis Expression (DAX) query that calculates the sum of all values in the Inventory Count column of the Warehouse table: 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? Select only one answer. LASTDATE DISTINCTCOUNT CALENDAR CALENDARAUTO
LASTDATE The LASTDATE function will ensure that the SUM function applies only to the last date of the time period, resulting in a semi-additive behavior. The DISTINCTCOUNT function counts the number of distinct values in a column, which results in additive behavior. The CALENDAR function returns a table with a column named Date that contains a contiguous set of dates based on the start date and end date that you specify. The CALENDARAUTO function returns a table with a column named Date that contains a contiguous set of dates based on data in the model. Create semi-additive measures - Training | Microsoft Learn
You create a Power BI Desktop 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. Open Power Query Editor. Switch to the model view. Retrieve the Cosmos DB account key. Retrieve the Cosmos DB connection string.
Open Power Query Editor. This behavior is by design. The Preview pane in Power BI shows a list of Record items when connecting to a collection of JSON formatted items. To view individual item fields, open the Power Query window and use the Expander button on the right hand side of the Column1 header to display the list of fields. Switching to the model view would not benefit us in any way, since the data has not been imported yet. Retrieving Cosmos DB account key or connection string at this point is meaningless, since that was required to connect to Cosmos DB account, which has been already completed. Get data from a NoSQL database - Training | Microsoft Learn
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? Select only one answer. remove columns transpose table Unpivot Pivot
Unpivot Selecting Unpivot will allow you to shape the current table into the one with the year, month, and sales amount columns, which will need to be renamed afterwards. 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 tables and columns. Removing columns would result in a table with insufficient data to perform unpivot. Shape the initial data - Training | Microsoft Learn Unpivot columns - Power Query | Microsoft Learn
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? Select only one answer. Use the CAST function in the SQL statement. Use the DATALENGTH function in the SQL statement. Set the privacy levels on the data source. Clear permissions on the data source in Power BI.
Use the CAST function in the SQL statement. The issue indicates that Power BI is incorrectly interpreting the data type used by the source column. To resolve it, you need to explicitly specify the intended data type, which can be done by using the CAST function. DATALENGTH displays the number of bytes used to represent an expression. Clearing permissions could prevent Power BI from being able to access the target database. Setting the privacy levels of the data source would have no impact on addressing the issue of missing data. Resolve data import errors - Training | Microsoft Learn
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. You need to add slicers. You need to add filters. 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. The ability to combine data from multiple datasets is one of the features that is available in dashboards but not supported in reports. Dashboards do not include the Filter, Visualization, and Fields panes that are available in Power BI Desktop when working with dashboards. Dashboards, unlike reports, contain only a single page. Introduction to dashboards - Training | Microsoft Learn
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 Numerical column a DateTime column a List group type a Bin group type
a Numerical column a List group type The group is created against a numerical column using bins The Bin group type is an auto grouping of items into bucketed bins (groups). It will display well as a histogram. A DateTime column isn't required to display histogram type data against a numerical column. A List group type is a manual grouping of items into new group names/categories. It doesn't create auto (binned) groups. Explore statistical summary - Training | Microsoft Learn
You have a report in Power BI. 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. filter highlight drillthrough expand
filter highlight A filter will show you the filtered data in this visual. Highlight is the default interaction between visuals. It shows you both the unfiltered and filtered values in the visual, for comparison purposes. Drillthrough is a page navigation experience that takes you from one page to another plus applies a set of filters to page navigated to. Expand is a way to navigate down a level using the hierarchy controls. Use advanced interactions and drill through - Training | Microsoft Learn Change how visuals interact in a report - Power BI | Microsoft Learn
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. 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. The Import storage, unlike DirectQuery does not minimize local disk space usage and does not eliminate the need for data refresh. Both the DirectQuery and Import storage modes support per table configuration Select a storage mode - Training | Microsoft Learn
