Name: Score:
47 Multiple choice questions
Definition 1 of 47
RLS roles are created or modified from the Manage roles space. You can assign AD
users/groups to an existing role in the security settings, but new RLS roles must be created in
Power BI desktop or other model authoring external tool. RLS configurations cannot be
accessed from any Power Query window. Before you can assign users to a security group, it
first needs to be created for the model in Power BI Desktop.
RLL
MIPS
PLM
RLS
Definition 2 of 47
Admin: Mos privileged
Member : privileged
Contributor: least privileged
Viewer: does not grant the permissions
Access to power bi reports, privilege in terms of viewing data
Manage a Power BI workspace, privilege in terms of schedule data refresh
Get data 3 identify outliers in a text colun in power query editor
Delete power bi datasets, privilege in terms of removing data
,Definition 3 of 47
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.
Get data
Share
Raw data
Embed
Definition 4 of 47
Date data types display well on a continuous (range) axis where report users understand
chronological order. Number data types display well on a continuous (range) axis where report
users understand the order between min and max values. Binary data and text (categorical)
data cannot be displayed on a continuous (range) axis. Date, time, or number are the only data
types comparable with a continuous axis.
Data type for a continuous axis
Get data 5, data source which uses a sql select
Make changes to data sources
Get data 3 identify outliers in a text colun in power query editor
,Definition 5 of 47
The Workspace OneDrive setting allows you to configure a Microsoft 365 group whose
SharePoint Online document library is available to workspace users once the workspace is
created. The Allow contributors to update the app for this workspace setting is meant to
provide additional permissions for workspace contributors. The Develop a template app
setting allows you to set up a template app workspace. The license mode allows you to
choose between Pro, Premium per user, Premium per capacity, and Embedded licensing.
Reports And dashboard
Workplace OneDrive setting
Interface to create a measure
Visual caching
Definition 6 of 47
The Report view provides the ability to create measures. To create a measure, use the context
sensitive menu of the Fields list or the Calculations section of the ribbon. The Data view
provides access to data within a dataset and includes the option to create a measure in the
Calculations section of the ribbon. Model view, Page view, and Power Query Editor do not
include the option to create a measure.
Analytics line
Interface to create a measure
Make changes to data sources
Auto date/time setting
, Definition 7 of 47
A parameter is the only part of a query that can be updated or changed in the Power BI
service, by accessing the dataset settings. Updating the server source to use a parameter will
update all existing queries pointing to the current server to instead use a parameter with that
server name. This parameter can now be changed once this dataset is published to the Power
BI service.
Develop a quick measure in Power BI Desktop, which two elemenets can you use
Publish a dataset from POwer BI Desktop, ensure a server name can be chagned
Get data 5, Data source which uses a SQL SELECT, 'Timeout expired'
Get data 4, column Statistics Are Based on an analysis of the entire dataset.
Definition 8 of 47
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.
M language, syntax should use allow you to specify that rows in the table should
represent consecutive days within the date range you designated.
Understand the relationship between the tables in the star schema.
Get data 5, data source which uses a sql select, 'timeout expired'
What are two benefits of using Import instead of DirectQuery? Each correct answer
presents a complete solution.
47 Multiple choice questions
Definition 1 of 47
RLS roles are created or modified from the Manage roles space. You can assign AD
users/groups to an existing role in the security settings, but new RLS roles must be created in
Power BI desktop or other model authoring external tool. RLS configurations cannot be
accessed from any Power Query window. Before you can assign users to a security group, it
first needs to be created for the model in Power BI Desktop.
RLL
MIPS
PLM
RLS
Definition 2 of 47
Admin: Mos privileged
Member : privileged
Contributor: least privileged
Viewer: does not grant the permissions
Access to power bi reports, privilege in terms of viewing data
Manage a Power BI workspace, privilege in terms of schedule data refresh
Get data 3 identify outliers in a text colun in power query editor
Delete power bi datasets, privilege in terms of removing data
,Definition 3 of 47
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.
Get data
Share
Raw data
Embed
Definition 4 of 47
Date data types display well on a continuous (range) axis where report users understand
chronological order. Number data types display well on a continuous (range) axis where report
users understand the order between min and max values. Binary data and text (categorical)
data cannot be displayed on a continuous (range) axis. Date, time, or number are the only data
types comparable with a continuous axis.
Data type for a continuous axis
Get data 5, data source which uses a sql select
Make changes to data sources
Get data 3 identify outliers in a text colun in power query editor
,Definition 5 of 47
The Workspace OneDrive setting allows you to configure a Microsoft 365 group whose
SharePoint Online document library is available to workspace users once the workspace is
created. The Allow contributors to update the app for this workspace setting is meant to
provide additional permissions for workspace contributors. The Develop a template app
setting allows you to set up a template app workspace. The license mode allows you to
choose between Pro, Premium per user, Premium per capacity, and Embedded licensing.
Reports And dashboard
Workplace OneDrive setting
Interface to create a measure
Visual caching
Definition 6 of 47
The Report view provides the ability to create measures. To create a measure, use the context
sensitive menu of the Fields list or the Calculations section of the ribbon. The Data view
provides access to data within a dataset and includes the option to create a measure in the
Calculations section of the ribbon. Model view, Page view, and Power Query Editor do not
include the option to create a measure.
Analytics line
Interface to create a measure
Make changes to data sources
Auto date/time setting
, Definition 7 of 47
A parameter is the only part of a query that can be updated or changed in the Power BI
service, by accessing the dataset settings. Updating the server source to use a parameter will
update all existing queries pointing to the current server to instead use a parameter with that
server name. This parameter can now be changed once this dataset is published to the Power
BI service.
Develop a quick measure in Power BI Desktop, which two elemenets can you use
Publish a dataset from POwer BI Desktop, ensure a server name can be chagned
Get data 5, Data source which uses a SQL SELECT, 'Timeout expired'
Get data 4, column Statistics Are Based on an analysis of the entire dataset.
Definition 8 of 47
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.
M language, syntax should use allow you to specify that rows in the table should
represent consecutive days within the date range you designated.
Understand the relationship between the tables in the star schema.
Get data 5, data source which uses a sql select, 'timeout expired'
What are two benefits of using Import instead of DirectQuery? Each correct answer
presents a complete solution.
