DA-100 COMPREHENSIVE REVIEW QUESTIONS
1. What should you do if you want data to automatically refresh as you interact
with visuals?: Direct query. No data is imported to Power BI Desktop. As you create or interact with a visualization,
Power BI Desktop queries the underlying data source, i.e. you're always viewing current data.
2. How do you connect to excel files that contain target figures? The solution
should involve minimum manual work when excel files are created.: Connect to the
files with folder connector and use the combine binaries functionality. Connecting to files separately will take time if there
are lot of files in the folder. Its always better to connect to folder if files have same structure. If you copy new files in that folder
with same structure, that file will be loaded automatically without doing any change to data sources.
3. Imagine you have created a query named Customers in a Power BI Desktop
to append the rows from three external tables with customer data into a single
output table named Customers. What would be the best approach to add a
new fabricated ID column to the Customers table to ensure that every row in
the Customers table contains a unique ID value?: Modify the customers query by adding an
index column
Index column option is available in query editor to add indexed column starting from 0, 1 or custom number.
4. Which two of the following strategies are recommended when designing the
queries to import data from an OLTP-style database into a Power BI Desktop
project?: Refactor imported tables into a star schema
denormalize the data model to make it better suited for data analysis and reporting.
Denormalization and star schema is desired to transform the data in the format that is best fit for visualizations.
5. Which of the following statements are true with respect to designing a Power
BI Desktop project in DirectQuery mode?: No support for parent child DAX functions
When in DirectQuery mode, it's not possible to use the family of DAX PATH() functions that generally handle Parent-Child
structures, such as chart of accounts, or employee hierarchies.
6. Which three transformations are available when you right-click a column
,header in the Query Editor window?.: Remove
D
u
p
l
i
c
a
t
e
C
h
a
n
g
e
t
y
p
e
Count Rows option is not there when you right click on column
7. How can you make sure that each category manager can see sales of their
category only and CEO to see all sales in the same report? Your solution
must involve minimal effort.: Implement dynamic row level security
,The answer is B. Creating separate reports for each manager will duplicate the reports and make it diflcult to maintain
them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate
choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a
separate role to view everything.
8. In order to use the Power BI web part in SharePoint Online, the report
author as well as all the report consumers require a Power BI Pro license. Is
this statement true ?: True. All Sharepoint report viewers must have a Power BI Pro License.
9. Which of the following types of real-time data set in Power BI always
store their data in Azure SQL Database?: 1. Push datasets
2. Hybrid data sets
- Streaming data set don't store data in Azure SQL database
10. Which of the following are advantages that Power BI dashboards have over
Power BI reports?: Dashboards provide support for data driven alerts
Dashboards update automatically whenever the data in the underlying data sets is updated
dashboard and report both otter Q&A functionality. dashboards are not interactive. Only a case of interaction is if you pin
a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other
tiles.
11. Which of the following are advantages that Power BI reports have
over Power BI dashboards?: Reports provide a better interactive filtering and drilldown experience
Reports provide story telling capabilities using bookmarks
Report definitions can be saved using an external file format (PBIX) and checked into source control
Reports don't support streaming datasets. This feature is available in dashboard tiles.
12. Which three properties of a tile can be edited in the Power BI dashboard from
the Tile details window?: Title
Sub
title
Desti
, natio
n
link
13. What do you need to append to the URL of a Power BI dashboard in
order to open it with the navigation pane collapsed by default?: ?collapseNavigation
= true When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the
Power BI Dashboard with the navigation pane collapsed
14. Which feature is used to create alternative name for fields in tables. It
will make it much easier for users to ask questions on dashboards?: Synonyms
1. What should you do if you want data to automatically refresh as you interact
with visuals?: Direct query. No data is imported to Power BI Desktop. As you create or interact with a visualization,
Power BI Desktop queries the underlying data source, i.e. you're always viewing current data.
2. How do you connect to excel files that contain target figures? The solution
should involve minimum manual work when excel files are created.: Connect to the
files with folder connector and use the combine binaries functionality. Connecting to files separately will take time if there
are lot of files in the folder. Its always better to connect to folder if files have same structure. If you copy new files in that folder
with same structure, that file will be loaded automatically without doing any change to data sources.
3. Imagine you have created a query named Customers in a Power BI Desktop
to append the rows from three external tables with customer data into a single
output table named Customers. What would be the best approach to add a
new fabricated ID column to the Customers table to ensure that every row in
the Customers table contains a unique ID value?: Modify the customers query by adding an
index column
Index column option is available in query editor to add indexed column starting from 0, 1 or custom number.
4. Which two of the following strategies are recommended when designing the
queries to import data from an OLTP-style database into a Power BI Desktop
project?: Refactor imported tables into a star schema
denormalize the data model to make it better suited for data analysis and reporting.
Denormalization and star schema is desired to transform the data in the format that is best fit for visualizations.
5. Which of the following statements are true with respect to designing a Power
BI Desktop project in DirectQuery mode?: No support for parent child DAX functions
When in DirectQuery mode, it's not possible to use the family of DAX PATH() functions that generally handle Parent-Child
structures, such as chart of accounts, or employee hierarchies.
6. Which three transformations are available when you right-click a column
,header in the Query Editor window?.: Remove
D
u
p
l
i
c
a
t
e
C
h
a
n
g
e
t
y
p
e
Count Rows option is not there when you right click on column
7. How can you make sure that each category manager can see sales of their
category only and CEO to see all sales in the same report? Your solution
must involve minimal effort.: Implement dynamic row level security
,The answer is B. Creating separate reports for each manager will duplicate the reports and make it diflcult to maintain
them. Creating a slicer in the report is not going to secure data at all. Dynamic row-level security is the most appropriate
choice given that there is a table that can be used to filter categories based on the active username. The CEO can have a
separate role to view everything.
8. In order to use the Power BI web part in SharePoint Online, the report
author as well as all the report consumers require a Power BI Pro license. Is
this statement true ?: True. All Sharepoint report viewers must have a Power BI Pro License.
9. Which of the following types of real-time data set in Power BI always
store their data in Azure SQL Database?: 1. Push datasets
2. Hybrid data sets
- Streaming data set don't store data in Azure SQL database
10. Which of the following are advantages that Power BI dashboards have over
Power BI reports?: Dashboards provide support for data driven alerts
Dashboards update automatically whenever the data in the underlying data sets is updated
dashboard and report both otter Q&A functionality. dashboards are not interactive. Only a case of interaction is if you pin
a live page. Even in that case that visual that contains live report page will be interactive but it cannot interact with other
tiles.
11. Which of the following are advantages that Power BI reports have
over Power BI dashboards?: Reports provide a better interactive filtering and drilldown experience
Reports provide story telling capabilities using bookmarks
Report definitions can be saved using an external file format (PBIX) and checked into source control
Reports don't support streaming datasets. This feature is available in dashboard tiles.
12. Which three properties of a tile can be edited in the Power BI dashboard from
the Tile details window?: Title
Sub
title
Desti
, natio
n
link
13. What do you need to append to the URL of a Power BI dashboard in
order to open it with the navigation pane collapsed by default?: ?collapseNavigation
= true When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will take you to the
Power BI Dashboard with the navigation pane collapsed
14. Which feature is used to create alternative name for fields in tables. It
will make it much easier for users to ask questions on dashboards?: Synonyms
