Practice Assessment
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. MULTI ANSWER. A. a Bin group type B. a Date/time column C. a List group type D. a Numerical column
A & D. 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. https://learn.microsoft.com/training/modules/perform-analytics-power-bi/2-statistical-summary?ns-enrollment-type=learningpath&ns-enrollment-id=learn-bizapps.data-analysis-power-bi
You need to develop a quick measure in Power BI Desktop. Which two elements can you use? Each correct answer presents a complete solution. MULTI ANSWER. A. Calculations B. Conditional columns C. Data Analysis Expression (DAX) queries D. Fields E. Power Query M functions
A & D. When creating a quick measure in Power BI Desktop, you apply calculations to fields. You do not explicitly create a DAX query, but you choose calculations and fields, which result in automatic generation of a DAX query. Conditional columns are separate from quick measures. Unlike quick measures, they create a value for each row in a table and are stored in the .pbix file. Power Query M functions are not directly accessible from the Quick Measure interface. https://learn.microsoft.com/training/modules/design-model-power-bi/8-lab https://learn.microsoft.com/training/paths/dax-power-bi/
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 th
A, B & E. 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. No bookmarks are necessary. It is not necessary to set the destination to a specific page since conditional formatting is used to specify the destination. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/
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. MULTI ANSWER. 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.
A, B & F. The current page capture allows the bookmark to navigate back to the page of capture. The data capture updates filters and drillthrough which should not occur for this bookmark. The display capture updates visual visibility on the report page. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/ https://learn.microsoft.com/power-bi/consumer/end-user-bookmarks
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? A. Funnel B. Slicer C. Treemap D. Waterfall
A. A funnel visualization displays a linear process with sequentially connected stages, with one stage transitioning to the next. A slicer visualization is available in different formats, including list, drop-down, and buttons, but not sequentially connected stages, with one stage transitioning to the next. A treemap visualization displays data as a set of nested rectangles. A waterfall visualization displays a running total as values are added or subtracted. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
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? A. Add a separate date dimension table. B. Add a
A. Adding a separate date dimension table that includes year, month, and week information is the optimal approach which provides the required functionality, while minimizing the model size and administrative effort. Adding a year, month, and week columns to the fact table would increase the amount of administrative effort. Enabling the Auto date/time global or current file option would increase the model size. In addition, it would not provide the ability to describe weekly time periods (only year, quarter, month, and day). https://learn.microsoft.com/training/modules/clean-data-power-bi/4-column-data-types https://learn.microsoft.com/power-bi/guidance/auto-date-time
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement queries multiple tables in a SQL Server database and includes subqueries. When importing data from the data source into Power BI, you receive the following error message: "Timeout expired." You verify that network connection to the SQL Server has sufficient available bandwidth and low latency. You need to minimize the occurrences of the timeout issues indicated by the message. What should you do? A. Di
A. 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. https://learn.microsoft.com/training/modules/get-data/9-import-errors
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? A. Many-to-many B. Many-to-one C. One-to-many D. One-to-one
A. 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. https://learn.microsoft.com/training/modules/design-model-power-bi/6-relationships-cardinality
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? A. CALCULATE B. FILTER C. IGNORE D. SUMX
A. 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. https://learn.microsoft.com/training/paths/dax-power-bi/
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? A. Open Power Query Editor. B. Retrieve the Cosmos DB account key. C. Retrieve the Cosmos DB connection string. D. Switch to the mod
A. 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 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. https://learn.microsoft.com/training/modules/get-data/4-nosql-database
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. MULTI ANSWER. A. Binary B. Date/Time C. Numeric D. Text E. True/False
B & C. Date/time and numeric data types support bins-based grouping. Binary, Boolean, and text data types do not support bins-based grouping. https://learn.microsoft.com/training/modules/perform-analytics-power-bi/4-group-data
In Power BI Desktop, you need to create a role. Which two interfaces can you use? Each correct answer presents a complete solution. MULTI ANSWER. A. Data view B. Model view C. Page view D. Power Query Editor E. Report view
B & E. 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. https://learn.microsoft.com/training/modules/row-level-security-power-bi/
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? A. Card B. Matrix C. Scatter D. Table
B. A matrix visualization displays data in two or more dimensions and cross-highlights with other visuals on the same report page. A card visualization displays a single data point. A scatter visualization is a chart, not a grid. It has two value axes, with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. A table visualization is a grid that contains related data in a grid format, with support for two dimensions only. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
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? A. Clustered bar chart B. Ribbon chart C. Scatterplot D. Treemap
B. 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 employees, 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. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
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? 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. Activating the View as feature will allow you test the row-level security as someone with the Salesperson role. A what-if parameter is intended for visualization and analytics of results of changing a value of a variable, not validating row-level security. Adding a DAX expression filter to the Salesperson table is part of implementing row-level security, which is already completed. A conditional column is computed from other columns or values. https://learn.microsoft.com/training/modules/row-level-security-power-bi/2-static-method
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? 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
B. Before you create a bookmark, you need to configure the report page to show the state you want to capture in the bookmark. Visuals are visible by default, therefore, you must mark them as hidden. To add a bookmark, you first need to update the bookmark after hiding the visuals. Bookmarks can be created in Power BI without publishing to the Power BI service. While spotlight does focus on the clustered bar chart, it does not completely hide the cards. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/
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? 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. DAX Studio, once connected to the data model, can be used to clear the data engine cache. The Clear Cache function can be invoked from DAX Studio, once you connect it to the data model. The Refresh Metadata function can be invoked from DAX Studio to update the metadata of the currently selected model. Adding a blank page to the .pbix file and selecting it is the first step in clearing the visual cache, not the data engine cache. https://learn.microsoft.com/training/modules/optimize-model-power-bi/2-performance
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? A. Average line B. Constant line C. Max line D. Min line
B. Either the X- or Y-axis constant line allows a DAX measure to be used to provide this value for the visual. The Min line populates the minimum value for a series already present in the visual. The Max line populates the maximum value for a series already present in the visual. The Average line populates the average value for a series already present in the visual. https://learn.microsoft.com/power-bi/transform-model/desktop-analytics-pane https://learn.microsoft.com/training/modules/visuals-power-bi/
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? A. Advanced Editor in Power Query Editor B. Power Query Editor C. The Data view D. The Model view
B. Power Query Editor provides the ability to display the column distribution and column quality graphs. Data view provides access to data within a dataset. Model view provides access to the data model of a dataset. Advanced Editor of Power Query Editor provides the ability to work with the M code used for shaping data in Power Query Editor. https://learn.microsoft.com/training/modules/clean-data-power-bi/6-profile-data
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? 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. The #date element designates the starting date, 365 designates the duration counter, and #duration(1,0,0,0) designates the duration interval in days, so this formula results in a listing of days starting on May 31, 2020 and ending 365 days later. https://learn.microsoft.com/training/modules/design-model-power-bi/3-date-table
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? A. #date B. #duration C. List.Combine D. List.Durations
B. 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. https://learn.microsoft.com/training/modules/design-model-power-bi/3-date-table https://learn.microsoft.com/powerquery-m/power-query-m-function-reference
Which native AI visual helps explain correlations for a metric within the dataset? A. Decomposition Tree visual B. Key influencers visual C. Q&A visual D. Smart Narrative visual
B. 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. https://learn.microsoft.com/training/modules/perform-analytics-power-bi/
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? 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. The error message indicates that the Excel workbook does not contain a table. To create it, in the Excel workbook, you need to select the data you want to import, press Ctrl+T or choose the Table button, click OK and save the change. Using the Data Validation button in Excel does not create a table. Organizational and template apps provide a way to implement functionality within Power BI, but, in this case, the issue is caused by an absence of a table in the Excel workbook, so installing an app would have no effect on resolving the issue. https://learn.microsoft.com/training/modules/get-data/9-import-errors
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? A. Clear permissions on the data source in Power BI. B. Use the CAST function in the SQL statement. C. Use the
B. 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. https://learn.microsoft.com/training/modules/get-data/9-import-errors
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? A. Data view B. Model view C. Page view D. Report view
B. 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. https://learn.microsoft.com/training/modules/get-data/6-storage-mode
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? 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 j D. The value of the Unique entry in Column statistics
B. The top and bottom entries in Value distribution identify outliers, which appear, respectively, the greatest and the smallest number of times in that column. The value of the Distinct entry in Column statistics indicates the total count of different values. The value of the Unique entry in Column statistics indicates the total count of different values that appear only once. The min and max values in the Column profile of a text column designate the entries which appear, respectively, first and last in alphabetical order. https://learn.microsoft.com/training/modules/clean-data-power-bi/6-profile-data
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. MULTI ANSWER. A. Drillthrough B. Expand C. Filter D. Highlight
C & D. 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. https://learn.microsoft.com/training/modules/data-driven-story-power-bi/6-advanced-interactions
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. MULTI ANSWER. A. Add a calculated column t
C & D. As part of setting up row-level security, it is necessary to create a role. In addition, it is necessary to add a DAX expression filter to the Salesperson table. This expression checks for a match between the salesperson's User Principal Name attribute and the value in the UPN column. If the two match, the salesperson is allowed to view the content of the corresponding row from the Salesperson table. https://learn.microsoft.com/training/modules/row-level-security-power-bi/3-dynamic-method
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. MULTI ANSWER. A. Decreasing report page load times B. Increasing DAX performance C. Increasing the refresh speed D. Reducing the size of the data model
C & D. 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. https://learn.microsoft.com/training/modules/optimize-model-power-bi/2-performance
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
C & D. The PATH function returns a string with identifiers of all the parents of the current identifier, which is used for flattening. The PATHITEM function returns the item at the specified position of a string, which is also used for flattening. The EXCEPT function returns rows from one table which do not appear in another table, which would require another table. The CROSSJOIN function returns a Cartesian product of all rows from all tables that the function references. The RELATED function returns a related value from another table, which would require another table. https://learn.microsoft.com/training/modules/design-model-power-bi/
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? A. Excel workbook B. Folder C. SharePoint folder D. SharePoint list
C. A SharePoint folder is the only connector that will allow the import of multiple Excel (or CSV) files stored in a OneDrive for Business folder, without using a data gateway. While you can connect to the folder on an on-premises device, it would require a data gateway to refresh in the service. An Excel workbook would only connect to a single Excel file and would also require a data gateway. A SharePoint list connector only connects to SharePoint lists and cannot connect to Excel files. https://learn.microsoft.com/training/modules/get-data/2-data-files https://learn.microsoft.com/power-query/connectors/sharepointfolder
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? A. Card B. Gauge C. Scatter D. Treemap
C. 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. https://learn.microsoft.com/training/modules/perform-analytics-power-bi/3-visuals
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? A. Import all three tables into the data
C. 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. https://learn.microsoft.com/training/modules/clean-data-power-bi/5-combine-tables
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? 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
C. By default, Power BI uses the top 1,000 rows for profiling. To ensure that column distribution considers all rows in the Excel file, you need to modify the Power Query Editor profiling status setting. The Power Query Editor settings, Advanced settings, and Permissions settings have no bearing on the profiling characteristics. https://learn.microsoft.com/training/modules/clean-data-power-bi/6-profile-data
You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? 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. 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. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
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? A. Expand B. Drillthrough C. Filter D. Highlight
C. Filter will show you the filtered data in this visual. So even when showing filtered data that is less than 1% of the unfiltered value, it will still display well in the column visual. Highlight shows you both the unfiltered and filtered values in the visual, for comparison purposes. Drillthrough is a page navigation experience that takes you from one page to another plus applies a set of filters to page navigated to. Expand is a way to navigate down a level using the hierarchy controls. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/ https://learn.microsoft.com/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop
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? 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. Setting the Storage Mode property of tables to Direct Query reduces the model size since only schema of the data source is stored locally. Setting the Storage Mode property of tables to Import will import data into Power BI desktop, effectively increasing the model size. Configuring the Query reduction option Slicers or Filters settings has no effect on data model size. https://learn.microsoft.com/training/modules/optimize-model-power-bi/4-reduce-cardinality
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? A. Data and column visibility only B. Data and hierarchies only C. Data, hierarchies, and column visibility D. Data only
D. A calculated table only duplicates data. Any model configurations such as column visibility or hierarchies must be recreated if needed. https://learn.microsoft.com/training/modules/dax-power-bi-add-calculated-tables/1-introduction
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? A. Add a Table.Buffer applied step to the query. B. Change the query load type from Import to DirectQuery. C. Create a Top N row count para
D. 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. https://learn.microsoft.com/training/modules/clean-data-power-bi/6-profile-data https://learn.microsoft.com/power-query/data-profiling-tools
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 Inventor
D. 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. https://learn.microsoft.com/training/paths/dax-power-bi/
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? 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. The same column must be used in each slicer for them to recognize each other in the sync slicers settings. Slicers can sync even when hidden. Slicers do not need to be the same slicer type. One slicer could be a list, and the other a dropdown. Slicers do not need the same title to allow them to be synced. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/ https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
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? A. Funnel B. Matrix C. Scatter chart D. Slicer
D. The slicer visualization can be used to filter the other visuals on the page. You can enable a search box in a slicer where users can search for values to filter. 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 two or more dimensions and cross-highlights with other visuals on the same report page. A scatter chart visualization is a chart with one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis. The matrix, scatter chart, and funnel do not offer a search box. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
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
D. To construct the resulting table, it is necessary to merge tables using the left outer join kind with the SalesOrderDetails as the first table. Appending tables in this context would not make sense, since they do not have the same columns. Merging using the inner join kind would not produce a table that includes a sales order details row where there is no corresponding sales order row. Full outer join would produce a table that includes sales order row data that do not have corresponding sales order details. https://learn.microsoft.com/training/modules/clean-data-power-bi/5-combine-tables
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? 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 t
D. To prevent users from viewing the hierarchy based on the year, you remove just the year from the date hierarchy fields in the x-axis in the Visualization pane. The quarter, month, and day will remain populated and usable. Modifying the visual Range settings in the Format pane would affect the range of values displayed in the visual. Adding a filter based on the year in the Filters pane would filter the values displayed in the visual, not remove a drilldown level. Adding a filter based on the quarter, month, and day in the Filters pane would filter the values displayed in the visual but would not prevent users from viewing the hierarchy based on the year. https://learn.microsoft.com/training/modules/power-bi-effective-user-experience/
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? A. Bar chart B. Column chart C. Slicer D. Treemap
DA treemap visualization displays data as 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 presents data as horizontal bars. A column chart presents data as vertical columns. https://learn.microsoft.com/training/modules/power-bi-effective-reports/
