DA100 - Practice Questions & ANSWERS
100% CORRECT
An app is the creation of official ___ content. Does it make managing permissions easier? -
Answers:An app is the creation of official packaged content. Managing permissions is easier
with apps.
What are 3 ways to get app access? How about for external users? - Answers:3 ways to get app
access: install through AppSource, receive a direct link, (applies to external users) automatically
install via admin permission.
In an App, where can you add a link to an external resource? - Answers:In the Navigation pane,
Using the New option to add a link to an external resource to the nav pane.
When you unpublish an app, app users lose their _____ such as ____, ____, and _____. -
Answers:Customizations, such as, personal bookmarks, comments, or subscriptions
When giving access permissions in the App, you can give access to specific users, groups or
______. Users/groups with access to the ____ automatically have access to the app. -
Answers:Entire organization
workspace
What data source allows you to display live data using DirectQuery connection mode? -
Answers:Azure SQL Database
What security service prevents information from flowing over into the public internet? -
Answers:Azure ExpressRoute extends on-premise networks into the cloud over a private
connection.
A Power BI ___ license is required in order to us AutoML. Data is prepped for machine learning
using ____. - Answers:Power BI Premium. Dataflows.
,With a Power BI Premium license, you have the ability to share Power BI content with ___. -
Answers:Anyone, even external folks, without purchasing a per-user license. Otherwise external
users would need a Pro license to view shared content.
In _____ admin center, you can manage members that have access to the app workspace, by
modifying _____. - Answers:Office 365 Admin center, clicking Groups
If users get an error message stating the company has turned off signup for Power BI, you need
to run the ______ - Answers:From Microsoft Azure PowerShell, run the Set-
MsolCompanySettings cmdlet. Set-MsolCompanySettings cmdlet sets company-level
configuration settings.
What are the 3 operations you can do with Power BI Rest APIs? - Answers:Create a dataset, add
rows to a dataset, and refresh an imported dataset. (aka 'Push data')
You cannot retrieve rows from a dataset
Power BI Report Server is available with a Power BI ____ license. It does not support ___ or
___ visuals. - Answers:Premium license. R or Python script visuals.
Does removing access to an app automatically remove the person's build and reshare
permissions? Users with build permission also can ____ reports. Users with the Viewer role that
have build permission can ____ data. - Answers:No. You must remove the user from the
manager permissions option in Datasets.
App users can be given Build Permission allowing them to search for shared datasets. Users with
Build permission can also have permission to copy reports from this app to another workspace.
Even users with the Viewer role in the new workspace can export data if they have Build
permission on the datasets in that workspace.
Can Power BI Free license users access a published Power BI app? - Answers:Yes
In order to create a Hierarchy, all the involved columns need to be ____ - Answers:In the same
table
, What is the first operation to do to optimize data loading performance? - Answers:Remove
unnecessary columns and rows.
When asked to create a measure, pay attention to whether all columns are in the same table -
Answers:You can simply create a measure using the FILTER function since all columns you
need are in the same table.
The addition of two different RLS filters allows the member of both of them to see data for ___
and not just the ___ of them. - Answers:The addition of two different RLS filters allows the
member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their
intersection. (I.e. The member will see all the data that have ''USA'' as Store[State] or ''T-shirts''
as Product[ProductName].)
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server
databases contain the same tables. What's the easiest way to swap connection between the 2 dbs?
- Answers:in the Power Query editor, by going to Home> Data source settings, it is possible to
update the origin of the data for the whole model you are working on.
When you use the Pivot feature, you have to take care of the ____ Value Functions displayed in
the ______options - Answers:When you use the Pivot feature, you have to take care of the
Aggregate Value Functions displayed in the Advanced options
As opposed to Text.Replace, _______ replaces an existing value with a new value in the
specified columns of a table. - Answers:Table.ReplaceValue
In order to make sure a table contains no duplicates, what 2 methods can you use? -
Answers:Click on Remove Duplicates on the table columns
Add an Index column to the table making all rows unique
In order to use R scripting in Power BI, you must first download ___. - Answers:Download
Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It
is a complete open source platform for statistical analysis and data science.
100% CORRECT
An app is the creation of official ___ content. Does it make managing permissions easier? -
Answers:An app is the creation of official packaged content. Managing permissions is easier
with apps.
What are 3 ways to get app access? How about for external users? - Answers:3 ways to get app
access: install through AppSource, receive a direct link, (applies to external users) automatically
install via admin permission.
In an App, where can you add a link to an external resource? - Answers:In the Navigation pane,
Using the New option to add a link to an external resource to the nav pane.
When you unpublish an app, app users lose their _____ such as ____, ____, and _____. -
Answers:Customizations, such as, personal bookmarks, comments, or subscriptions
When giving access permissions in the App, you can give access to specific users, groups or
______. Users/groups with access to the ____ automatically have access to the app. -
Answers:Entire organization
workspace
What data source allows you to display live data using DirectQuery connection mode? -
Answers:Azure SQL Database
What security service prevents information from flowing over into the public internet? -
Answers:Azure ExpressRoute extends on-premise networks into the cloud over a private
connection.
A Power BI ___ license is required in order to us AutoML. Data is prepped for machine learning
using ____. - Answers:Power BI Premium. Dataflows.
,With a Power BI Premium license, you have the ability to share Power BI content with ___. -
Answers:Anyone, even external folks, without purchasing a per-user license. Otherwise external
users would need a Pro license to view shared content.
In _____ admin center, you can manage members that have access to the app workspace, by
modifying _____. - Answers:Office 365 Admin center, clicking Groups
If users get an error message stating the company has turned off signup for Power BI, you need
to run the ______ - Answers:From Microsoft Azure PowerShell, run the Set-
MsolCompanySettings cmdlet. Set-MsolCompanySettings cmdlet sets company-level
configuration settings.
What are the 3 operations you can do with Power BI Rest APIs? - Answers:Create a dataset, add
rows to a dataset, and refresh an imported dataset. (aka 'Push data')
You cannot retrieve rows from a dataset
Power BI Report Server is available with a Power BI ____ license. It does not support ___ or
___ visuals. - Answers:Premium license. R or Python script visuals.
Does removing access to an app automatically remove the person's build and reshare
permissions? Users with build permission also can ____ reports. Users with the Viewer role that
have build permission can ____ data. - Answers:No. You must remove the user from the
manager permissions option in Datasets.
App users can be given Build Permission allowing them to search for shared datasets. Users with
Build permission can also have permission to copy reports from this app to another workspace.
Even users with the Viewer role in the new workspace can export data if they have Build
permission on the datasets in that workspace.
Can Power BI Free license users access a published Power BI app? - Answers:Yes
In order to create a Hierarchy, all the involved columns need to be ____ - Answers:In the same
table
, What is the first operation to do to optimize data loading performance? - Answers:Remove
unnecessary columns and rows.
When asked to create a measure, pay attention to whether all columns are in the same table -
Answers:You can simply create a measure using the FILTER function since all columns you
need are in the same table.
The addition of two different RLS filters allows the member of both of them to see data for ___
and not just the ___ of them. - Answers:The addition of two different RLS filters allows the
member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their
intersection. (I.e. The member will see all the data that have ''USA'' as Store[State] or ''T-shirts''
as Product[ProductName].)
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server
databases contain the same tables. What's the easiest way to swap connection between the 2 dbs?
- Answers:in the Power Query editor, by going to Home> Data source settings, it is possible to
update the origin of the data for the whole model you are working on.
When you use the Pivot feature, you have to take care of the ____ Value Functions displayed in
the ______options - Answers:When you use the Pivot feature, you have to take care of the
Aggregate Value Functions displayed in the Advanced options
As opposed to Text.Replace, _______ replaces an existing value with a new value in the
specified columns of a table. - Answers:Table.ReplaceValue
In order to make sure a table contains no duplicates, what 2 methods can you use? -
Answers:Click on Remove Duplicates on the table columns
Add an Index column to the table making all rows unique
In order to use R scripting in Power BI, you must first download ___. - Answers:Download
Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It
is a complete open source platform for statistical analysis and data science.
