Power BI
What function should you use for DAX to create a table in the dataset and populate the table with a range of dates based on the earliest and latest date within the dataset?
#CALENDARAUTO
What DAX function should you include in the query 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?
#LASTDATE
Which function should be used in the code for the RLS role to match the users Azure AD login credentials with the emails contained in the RLS table column?
#USERPRINCIPALNAME
Which syntax should you use for 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. Solution must minimize administrative effort.
#duration
In which two places can a DAX calculated column be used, but a DAX calculated measure cannot used?
1. as an item in fields well of a slicer 2. as a filter in the "filters on this visual" well of the filters pane 3. as a filter in the "filters on this page" well of the filters pane 4. as an item in the "add drill-through fields here" well of the visualizations pane
What is the number of consecutive refresh failures of DS1 that will automatically disable the refresh schedule?
4
Maximum number of refreshes that can be scheduled each day in Power BI Premium per user workspace?
48
What is the maximum number of data refreshes per day?
8
Resulting date range for a power query m formula for a calendar table: =List.Dates(#date(2020,05,31), 365, #duration(1,0,0,0))
A list of days starting on May 31, 2020 and ending 365 days later.
What should you do to ensure you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Solution must minimize the model size and administrative effort.
Add a separate date dimension table.
Which two configurations can you add to improve your Q&A search capabilities for end-users?
Add synonyms to model fields & add a linguistic schema to the dataset.
What interface should you use to modify the M code used for data shaping?
Advanced Editor in Power Query Editor.
What should you include in the recommendation to ensure that the dataset for the report can automatically refresh daily?
An on-premises data gateway
Which DAX function should you use in combination with the SUM function to override the context and provide the result?
CALCULATE
Two elements to use to develop a quick measure in Power BI desktop.
Calculations & Fields
Which three items can be assigned to a display folder?
Column, calculated column, measure.
Which two actions should you perform 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?
Create a role and Add a DAX expression filter to the Salesperson table.
Which object from a report page can be pinned to the dashboard?
Custom Visual, Ribbon Chart & Image
Which two interfaces can you use to create a measure?
Data and Report view
Which two data types can be used to display a continuous axis on a visual?
Date & Decimal Number
Two types of data you will be able to use for creating bins that group the sales data.
Date/time & Numeric
What should you do to ensure that by default, the Calendar table does NOT filter the fact table, unless using a DAX measure that use these relationships?
Disable Make this relationship active for both relationships.
What should you do to ensure that by default, the calendar table does NOT filter the fact table, unless using a DAX measure that use these relationships.
Disable Make this relationship active for both relationships.
Which three configurations should you make to create a bookmark that toggles the visibility of a visual and perform no other action.
Disable the data option, enable the display option and disable the current page option.
What should you do to minimize the occurrence of the timeout issues indicated by the message? (SQL select statement, when importing data receive "timeout expired.")
Divide the SQL statement into separate data sources.
A dimension table has a relationship to both fact tables and need to assign a storage mode. Which storage mode should you use to minimize the time to execute queries that combine data from the dimension table to the fact tables.
Dual
What is required to sync slicers between report pages?
Each slicer must use the same column.
What do you need to do first to create a custom Python visual by using PowerBI Desktop?
Enable the script visuals option in the Visualization Pane of PB Desktop.
What should you do to ensure that the ZIP column uses the Text data type?
From Power Query Editor, update the current changed type step and replace convert from number to text for the ZIP column.
Prevent a hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset.
From the Current File options in Power BI Desktop, disable Auto Date/Time for new files.
What should you do to prevent a hidden date tables from being auto generated by Power BI Desktop for every date or datetime data type column in a dataset?
From the Current File options in Power BI Desktop, disable Auto Date/Time for new files.
Create a new hierarchy in Power BI Desktop first step.
From the Model view, right-click and select Create hiearchy.
What should you do to ensure the column statistics for each column shows the statistics based on all rows that are returned by the query?
From the query window, select #strong Column profiling on the entire dataset #strong.
What should you do when analyzing query data by using Power Query Editor to ensure that the column statistics is based on an analysis of the entire dataset?
From the status bar, change profiling status to entire dataset.
What should you do in this situation? Analyzing query data by using Power Query Editor and need to ensure that the column statistics is based on an analysis of the entire dataset.
From the status bar, changing profiling status to entire dataset.
Power BI data source to analyze the data to meet requirement.
Hide the Top 10 filter in the visual level filters for this visual in the Filters pane.
Create a row level security (RLS) role for a dataset first step.
In Power BI Desktop, open Manage roles.
What should you do to resolve the error "we couldn't find any data formatted as a table" when importing data from an excel workbook into Power BI.
In the Excel workbook, select the data you want to import, press Ctrl + T, and save the change.
Need to ensure column distribution considers all 10,000 rows in the excel file, what should you do?
In the Power Query Editor window, modify the profiling status.
What should you do to validate the implementation works for role-base security that restricts access to PB Desktop dataset for users who are assigned the role named Salespeople?
In the Report view, activate the View as feature.
What should you do to validate the implementation works for a role-based security implementation that restricts access to a Power BI desktop dataset for users who are assigned the role named Salespeople.
In the report view, activate the view as a feature.
What should you do first to prevent users from viewing the hierarchy based on the year?
In the visualization pane, remove all date hierarchy fields from the Axis well.
What should you do to reduce the cardinality of a column in a dataset?
Increase the number of distinct values while lowering the number of unique values.
What do you need to do first to create a custom R visual by using Power BI desktop?
Install R on your computer.
Benefit of using a Power BI dataset as a data source for multiple reports compared to each report having a separate dataset?
It reduces the number of datasets, refreshes, and storage requirements in the Power BI service.
Which type of file should you use to apply a custom theme to the dashboard from another PB dashboard theme?
JSON
Which native AI visual helps explain correlations for a metric within the dataset?
Key influencers visual.
Which two types of visuals support the conditional formatting functionality?
Matrix & Table
Need to select individual fields from items in the collection that you want to load into Power BI Desktop, what should you do first?
Open Power Query Editor
which two DAX functions should you use to flatten the parent-child hierarchy by adding an extra column that will contain a listing of ids for all direct and indirect managers of each employee?
PATH and PATHITEM
You need to create a dashboard from a published report in Power BI. Which option in the report should you use?
Pin visual
Need to transform data for requirements (multiple columns, single row for total count), what transformation should you use?
Pivot Columns
Which interface should you use to display the column distribution and column quality graphs?
Power Query Editor
Which command should you use to convert the ProductID values to number (integer) and to remove the leading two letters from the current ProductID values?
Replace Values
What should you do from the Power Query Editor to reshape the table to have a single column for sales data and a new column should be added and contain the relevant month year for each row of data?
Select the Country column and then select Unpivot Other Columns.
Which pane should you use to designate the visual that the bookmark should reference?
Selection
What should you do to reduce the model size when you are designing a data model for Power BI Desktop based on data stored in Azure SQL Database?
Set the Storage Mode property of tables to Direct Query.
What technique should you use to reduce the model size of a data model for Power BI Desktop?
Set the storage mode property of table to direct query
Which type of connector should you use to import data from the files? Solution must NOT use a data gateway.
SharePoint Folder
Which level should you identify within your organization the permissions to certify a dataset are assigned?
Tenant
Which tool should you use to create a PB dashboard?
The Power BI Service
What transformation should you use to transform the data so it will consist of 3 columns, with the first one containing the month, second containing year and third containing sales amount for that month and year.
Unpivot
What transformation should you use to remove the Row ID column? Solution must ensure that new columns do NOT display in the table model during scheduled refresh in the future.
Use the Select Columns command and choose the columns to keep.
How should tables be imported into the model to optimize the star schema model for the Power BI dataset.
Use the combine command to create a single loaded table for product.
Which method should you use to determine query timings for a report page visual?
Use the performance analyzer
What type of visualization should you use to display a running total (and other requirements)?
Waterfall
In which scenario do you need a dashboard instead of a report in Power BI?
You need to display visuals that use different datasets.
what should you create in the powerbi service to share the datasets and report together? solution must NOT send any email notifications to internal users after sharing
an app
what are two locations you can view the alerts?
an email, the notification center
What should you deploy to minimize configurations that must be performed by each user?
an on-premises data gateway
what solution should you recommend to ensure dataset for the report can automatically refresh daily?
an on-premises data gateway.
Data for which two model items can be created using the DAX language.
calculated table & numeric range parameter
which three types of visuals support the alert functionality?
card, gauge, kpi
which two configuration will allow the dataset to be marked as discoverable?
certify and promote the dataset
What should you do to ensure that the data engine cache will NOT impact the test results without restarting power bi.
connect DAX studio to the data model.
Which type of analytics line supports should you use for a DAX measure (field value) to supply a single value for visal?
constant line
which object from a report page can be pinned to the dashboard?
custom visual, ribbon chart, image
Calculated table functionality to add duplicate table, what characteristics of the original table will be duplicated?
data only
Which three changes are supported by the Data Source Settings in the Power Query intercface?
editing permissions, modifying the file path, clearing permissions.
What is a feature of an implicit measure that explicit measure does NOT have?
end-users can change the aggregation type of implicit measure from the values well of a visual
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?
filter
what should you do to ensure that the column statistics is based on an analysis of the entire dataset?
from the status bar, change profiling status to entire dataset.
Type of cardinality to avoid when avoid introducing ambiguity into data model design.
many-to-many
What are two benefits of using DirectQuery instead of Import?
minimized local disk space usage and minimized need for data refresh
What is the relationship between the fact tables and dimension table in the star schema?
one-to-many
what should you do first to select individual fields from items in the collection you want to load into pb desktop?
open power query editor.
Which location type should you recommend that requires you to provide credentials of a Microsoft account.
personal OneDrive account
which option should you configure in PB desktop to optimize performance of queries against a remote data source?
reduce the number of queries sent by query reduction settings.
Two potential performance benefits of removing unnecessary columns from your data model.
reducing the size of the data model & increasing the refresh speed
Visual that will display sales data of your company such that customers with similar age will be grouped into clusters.
scatter
Which visual will clearly identify outliers in the data set by displaying them away from teh bulk of data?
scatter
what should you do first to add a new visual to PB dashboard when the visual does NOT exist on a report in the workspace?
select ask a question about your data.
What should you do from the power query editor for the country and column?
select the country column and then selet unpivot other columns.
Which type of DAX quick measure calculations will NOT work against a DirectQuery table?
time intelligence
how should the tables be imported into the model to optimize the star schema for the pb dataset?
use the combine command to create a single loaded table for product.
Which role should you use to delegate the task to schedule data refreshes? The solution must use the principle of least privilege.
Contributor
What should you do to combine two tables into one from an Azure SQL database?
Merge the tables using the left outer join kind based on the sales order id.
Which interface should you use in the PB desktop to modify the relationship between tables?
Model View
From which in Power BI desktop can you modify the storage mode of the table?
Model view
What two resources do you need to create histogram that will display ranges of integers in groups?
Numerical column and Bin group type
Which two types of interaction behavior can you change between visuals to adjust the behavior of the report by editing interactions?
filter & highlight
What are two benefits of using Import instead of DirectQuery?
full support for the Q&A Power BI service and for the Quick Insights Power BI service
What visualization do you need to display a linear process with sequentially connected stages with one stage transitioning to the next?
funnel
What are two benefits of using variables in DAX measures over using original expressions?
improves the overall readability of the resulting DAX measure and the overall performance of the resulting DAX measure.
Which location type should you recommend to store the files? The data must NOT automatically synchronize between the original file and the dataset.
local file
What type of visualization should you use to create a standalone chart that will be dedicated to filtering other visuals on the same report page?
slicer
By default, what data will be displayed in a report tooltip in a visual that is being cross-highlighted?
the filtered (cross-highlighted) data
Which option should you configure in PB desktop to disable the default behavior that automatically applies cross highlighting and filtering of visuals within the same report?
the reduce number of queries sent by query reduction setting
What information should you use from Power Query Editor to identify outliers in a text column within the data source?
the top and bottom entries in Value distribution.
What visualization do you need to display data as a set of nested rectangles
treemap
What should you do to resolve the issue when you import data source and notice one of the columns in the resulting dataset appears blank, and verify the source table does include data?
use the CAST function in the SQL statement.
which role should you assign to users who consume reports in an app workspace role? users should only have permissions to examine the report
viewer role
which setting should you configure when creating the workspace?
workspace onedrive
