| 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.
many-to-many
many-to-one
one-to-many
one-to-one | many-to-many
This answer is correct. |
| You need to prevent hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset.
What two tasks should you perform? Each correct answer presents a complete solution
Select all answers that apply.
From the Current File options in Power BI Desktop, disable Auto Date/Time
From the Global options in Power BI Desktop, disable Auto Date/Time for new files.
Enable Mark as date table for the Calendar table.
Set the Data Category to None for all Date and DateTime fields. | 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. |
| You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
Select only one answer.
Excel workbook
Folder
SharePoint folder
SharePoint list | 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. |
| 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. 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. | 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. |
