Enable Mark as date table for the Calendar table. This answer is correct. From the Current File options in Power BI Desktop, disable Auto Date/Time This answer is correct.

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. Calculated column Column Report Measure Table

Calculated column This answer is correct. Column This answer is correct. Measure This answer is correct.

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 and column visibility only data and hierarchies only data, hierarchies, and column visibility data only

Data only This answer is correct.

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. as a filter in the “Filters on this visual” well of the Filters pane as a filter in the “Filters on this page” well of the Filters pane as an item in the “Add drill-through fields here” well of the Visualizations pane as an item in the Fields well of a slicer

As a filter in the “Filters on this page” well of the Filters pane This answer is correct. as an item in the Fields well of a slicer This answer is correct.

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. Calculations Conditional columns Data Analysis Expression (DAX) queries Fields Power Query M functions

Calculations This answer is correct. Fields This answer is correct.

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? CALENDAR CALENDARAUTO DISTINCT COUNT LAST DATE

LASTDATE This answer is correct.

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 as a Drillthrough field. Implicit measures can be used to create Quick measures. 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. This answer is correct.

You need to reduce the cardinality of a column in a Power BI dataset. What should you do? Select only one answer. Add a prefix to each value in the column. Add a suffix to each value in the column. Replace null values with a value of 0. Reduce the number of distinct values

Reduce the number of distinct values This answer is correct. A column that has a lot of re

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. the Filters Query reduction settings the Persistent filters of Report settings the Reduce number of queries sent by Query reduction setting the Slicers Query reduction settings

The Reduce number of queries sent by Query reduction setting This answer is correct.

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. Run the Best Practices analyzer in Tabular Editor. Use Session Diagnostics from the Power Query Editor. Use the Performance analyzer.

Use the Performance analyzer. This answer is correct.

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. In Power Query Editor, add a conditional column to the Salesperson table. In the Report view, activate the View as feature. In the Report view, add a DAX expression filter to the Salesperson table. In the Report view, create a what-if parameter.

In the Report view, activate the View as feature. This answer is correct.

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. allows users to change the data source connection in the DAX measure improves the overall readability of the resulting DAX measure has additional functions that can be used in the DAX measure improves the overall performance of the resulting DAX measure

Improves the overall performance of the resulting DAX measure This answer is correct. improves the overall readability of the resulting DAX measure This answer is correct.

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 This answer is correct.

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? Funnel Matrix Scatter chart Slicer

Slicer This answer is correct.

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? combo funnel scatter waterfall

Waterfall This answer is correct.

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 This answer is correct.

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. funnel slicer treemap waterfall

Funnel This answer is correct.

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. clustered bar chart ribbon chart scatterplot treemap

Ribbon chart This answer is correct.

From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate. You add a button to the Main page for navigation. You need to implement a solution that meets the following requirements: The navigation destination must change based on the output of a DAX measure named [Error Rate]. If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page. Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page. What three actions should you perform? Each correct answer presents part of the solution.Select all answers that apply. Set the button type to Page Navigation and then use conditional formatting to specify the destination. Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. Set the button type to Bookmark and then use conditional formatting to specify the destination. Set the navigation destination to the Error Rate page. Use conditional formatting to set the button text.

Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. This answer is correct. Set the button type to Page Navigation and then use conditional formatting to specify the destination. This answer is correct. Use conditional formatting to set the button text. This answer is correct.

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. In the Filters pane, add a filter based on the quarter, month, and day. In the Filters pane, add a filter based on the year. In the Format pane, modify the Maximum Range setting. In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis.

In the Visualization pane, remove the year field from the date hierarchy fields in the X-axis. This answer is correct.

You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? Select only one answer. a report page tooltip with cross-highlighted data both the un-filtered and filtered (cross-highlighted) data the un-filtered (non-cross-highlighted) total data the filtered (cross-highlighted) data

The filtered (cross-highlighted) data This answer is correct.

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. Each slicer must be the same slicer type. Each slicer must be visible. Each slicer must have the same title. Each slicer must use the same column.

Each slicer must use the same column. This answer is correct.

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 gauge scatter treemap

Scatter This answer is correct.

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. Binary Date/time Text True/false Numeric

Date/time This answer is correct. Numeric This answer is correct.

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 Bin group type a Date/time column a List group type a Numerical column

A Bin group type This answer is correct. a Numerical column This answer is correct.

Which native AI visual helps explain correlations for a metric within the dataset? Select only one answer. Decomposition Tree visual Key influencers visual Q&A visual Smart Narrative visual

Key influencers visual This answer is correct.

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. Average line Constant line Max line Min line

Constant line This answer is correct.

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. full support for the Q&A Power BI service minimized need for data refresh full support for the Quick Insights Power BI service minimized local disk space usage

Minimized local disk space usage This answer is correct. minimized need for data refresh This answer is correct.

SharePoint folder

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. Clear permissions on the data source in Power BI. Use the CAST function in the SQL statement. Use the DATALENGTH function in the SQL statement. Set the privacy levels on the data source.

Use the CAST function in the SQL statement. This answer is correct.

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. In the Data Source Settings, modify the Advanced settings. In the Data Source Settings, modify the Edit Permissions settings. In the Power Query Editor window, enable the Column Profile view. In the Power Query Editor window, modify the Query Settings.

In the Power Query Editor window, enable the Column Profile view. This answer is correct.

From the query window, select Column profiling on the entire dataset. This answer is correct.

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. Change the query connection type from Import to DirectQuery. In Power Query Editor, enable column profiling from the View ribbon. Load the data into the data model. From the status bar, change profiling status to entire dataset.

From the status bar, change profiling status to entire dataset. This answer is correct.

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. Choose Columns Remove Columns Remove Other Columns Transpose

Choose Columns This answer is correct. Remove Other Columns This answer is correct.

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. Select the Country column and then select Pivot Column. Select the Country column and then select Unpivot Other Columns. Select the first sales data column and then select Unpivot Columns. Select Transpose.

Select the Country column and then select Unpivot Other Columns. This answer is correct.

From the Power Query Editor, you import data from a .csv file. The data includes a column named ZIP that contains postal codes from the United States.You notice that Power Query Editor automatically applies the Whole Number data type to the ZIP column.You need to ensure that the ZIP column uses the Text data type and that all values remain 5 characters long.What should you do? From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column. From the data view in Power BI Desktop, change the column data type from number to text. 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, delete the changed type step.

From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column. This answer is correct.

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. Import all three tables into the data model and connect them using relationships. Merge the queries 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.

Merge the queries to create a single loaded table for Product. This answer is correct.

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?Select only one answer. Add a separate date dimension table. Add a year, month, and week columns to the fact table. Enable the Auto date/time current file option. Enable the Auto date/time global option.

Add a separate date dimension table. This answer is correct.

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. Append the tables. Merge the tables using the full outer join kind based on the sales order id. Merge the tables using the inner join kind based on the sales order id. Merge the tables using the left outer join kind based on the sales order id.

Merge the tables using the left outer join kind based on the sales order id. This answer is correct.

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 filters. You need to display visuals that use different datasets. You need to add slicers. You need to display visuals on multiple pages.

You need to display visuals that use different datasets. This answer is correct.

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. card gauge treemap waterfall KPI

Card This answer is correct. gauge This answer is correct. KPI This answer is correct.

You plan to certify a Power BI dataset. You need to identify at which level within your organization the permissions to certify a dataset are assigned. Which level should you identify? Select only one answer. Dataset Tenant Workbook Workspace

Tenant This answer is correct.

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 Point to Site virtual private network (VPN) a Site-to-Site virtual private network (VPN) an on-premises data gateway Azure Data Box

An on-premises data gateway This answer is correct.

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 deployment pipeline a workspace an app metrics

An app This answer is correct.

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. Admin Contributor Member Viewer

Contributor This answer is correct.

You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? Select only one answer. 1 8 16 48

48 This answer is correct.

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. Admin role Contributor role Member role Viewer role

Viewer role This answer is correct.

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. local file OneDrive for Business Personal OneDrive account SharePoint – Team Sites

OneDrive for Business This answer is correct. SharePoint – Team Sites This answer is correct.

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. Data view Model view Page view Report view

Model view This answer is correct.

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. minimized local disk space usage full support for the Q&A Power BI service full support for the Quick Insights Power BI service minimized need for data refresh

Minimized local disk space usage This answer is correct. minimized need for data refresh This answer is correct.

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. In the Excel workbook, select the data you want to import, select the Data Validation button, and save the change. In the Excel workbook, select the data you want to import, create a table, and save the change. In Power BI, add a template app. In Power BI, add an organizational app.

In the Excel workbook, select the data you want to import, create a table, and save the change. This answer is correct.

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. Clear permissions on the data source in Power BI. Use the CAST function in the SQL statement. Use the DATALENGTH function in the SQL statement. Set the privacy levels on the data source.

Use the CAST function in the SQL statement. This answer is correct.

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. the min and max values in Column profile the top and bottom entries in Value distribution the value of the Distinct entry in Column statistics the value of the Unique entry in Column statistics

The top and bottom entries in Value distribution This answer is correct.

Select the Country column and then select Unpivot Other Columns. This answer is correct.

Open Power Query Editor. This answer is correct.

You have an Excel spreadsheet that contains two columns as follows: Category: Contain names of categories Subcategory: Contain names of subcategories for each category You import the Excel spreadsheet into Power BI Desktop. You need to transform the data to meet the following requirements: Have multiple columns, where one column represents one category Have a single row that includes the total count of subcategories for each category Which transformation should you use? Pivot Columns Unpivot Columns Rename Columns Transpose Columns

Pivot Columns This answer is correct.

You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do? Add a separate date dimension table. Add a year, month, and week columns to the fact table. Enable the Auto date/time current file option. Enable the Auto date/time global option.

Add a separate date dimension table. This answer is correct.

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? Append the tables. Merge the tables using the left outer join kind based on the sales order id. Merge the tables using the full outer join kind based on the sales order id. Merge the tables using the inner join kind based on the sales order id.

Merge the tables using the left outer join kind based on the sales order id. This answer is correct.

You need to create a Power BI dashboard. Which tool should you use? Select only one answer. Power BI Desktop Power Query Editor the Power BI mobile app the Power BI service

The Power BI service This answer is correct.

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 filters. You need to add slicers. You need to display visuals on multiple pages. You need to display visuals that use different datasets.

You need to display visuals that use different datasets. This answer is correct.

Card This answer is correct. gauge This answer is correct. KPI This answer is correct.

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 report an email Microsoft Teams the Notification Center

An email This answer is correct. the Notification Center This answer is correct.

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. Allow contributors to update the app Develop a template app License mode Workspace OneDrive

Workspace OneDrive This answer is correct.

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 This answer is correct.

Contributor This answer is correct.

You have a Power BI Premium per user workspace. What is the maximum number of refreshes that can be scheduled each day? Select only one answer. 1 8 16 48

48 This answer is correct.

Slicer This answer is correct.

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. Card matrix scatter table

Matrix This answer is correct.

Treemap This answer is correct.

You need to create a custom R visual by using Power BI Desktop. What do you need to do first? Select only one answer. Configure global R scripting options in Power BI Desktop. Enable preview features in Power BI Desktop. Enable the script visuals option in the Visualization pane of Power BI Desktop. Install R on your computer.

Install R on your computer. This answer is correct.

You need to create a custom Python visual by using Power BI Desktop. What do you need to do first? Select only one answer. Configure global Python scripting options in Power BI Desktop. Enable preview features in Power BI Desktop. Enable the script visuals option in the Visualization pane of Power BI Desktop. Install Python on your computer.

Enable the script visuals option in the Visualization pane of Power BI Desktop. This answer is correct.

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. drillthrough expand filter highlight

Filter This answer is correct. highlight This answer is correct.

Ribbon chart This answer is correct.

From Power BI Desktop, you open a Power BI report that contains three pages named Main, Error Rate, and On-time Rate.You add a button to the Main page for navigation.You need to implement a solution that meets the following requirements:The navigation destination must change based on the output of a DAX measure named [Error Rate].If [Error Rate] is greater than 5%, the button must display the text “Error Rate” and navigate to the Error Rate page.Otherwise, the button must display the text “On-time Rate” and navigate to the On-Time Rate page.What three actions should you perform? Each correct answer presents part of the solution. Create a DAX measure that outputs the correct page name based on the value of [Error Rate]. Set the button type to Page Navigation and then use conditional formatting to specify the destination. Set the button type to Bookmark and then use conditional formatting to specify the destination. Set the navigation destination to the Error Rate page. Use conditional formatting to set the button text.

Matrix This answer is correct. table This answer is correct.

Filter This answer is correct.

You have a visual that is being cross-highlighted. By default, what data will be displayed in a report tooltip? Select only one answer. a report page tooltip with cross-highlighted data both the un-filtered and filtered (cross-highlighted) data the filtered (cross-highlighted) data the un-filtered (non-cross-highlighted) total data

The filtered (cross-highlighted) data This answer is correct.

Date/time This answer is correct. Numeric This answer is correct.

A Bin group type This answer is correct. a Numerical column This answer is correct.

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. Binary Date Decimal Number Text

Date This answer is correct. Decimal Number This answer is correct.

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. Data view Model view Page view Report view

Model view This answer is correct.

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. Disable Make this relationship active for both relationships. Enable Apply security filter in both directions for both relationships. Enable Make this relationship active for both relationships. Set the cross-filter direction to both for each relationship.

Disable Make this relationship active for both relationships. This answer is correct.

POWER BI [PI-300]

Practice Known Questions

Exams

Learn New Questions

POWER BI [PI-300] - Leaderboard

POWER BI [PI-300] - Details

Levels:

Questions: