DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
What should you do if you want data to automatically refresh as
you interact with visuals? -
correct answer ✅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.
How do you connect to excel files that contain target figures? The
solution should involve minimum manual work when excel files are
created. -
correct answer ✅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.
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? -
,DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
correct answer ✅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.
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? -
correct answer ✅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.
Which of the following statements are true with respect to
designing a Power BI Desktop project in DirectQuery mode? -
correct answer ✅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.
,DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
Which three transformations are available when you right-click a
column header in the Query Editor window?. -
correct answer ✅Remove
Duplicate
Change type
Count Rows option is not there when you right click on column
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. -
correct answer ✅Implement dynamic row level security
The answer is B. Creating separate reports for each manager will
duplicate the reports and make it difficult 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.
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 ? -
, DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
correct answer ✅True. All Sharepoint report viewers must have a
Power BI Pro License.
Which of the following types of real-time data set in Power BI
always store their data in Azure SQL Database? -
correct answer ✅1. Push datasets
2. Hybrid data sets
- Streaming data set don't store data in Azure SQL database
Which of the following are advantages that Power BI dashboards
have over Power BI reports? -
correct answer ✅Dashboards provide support for data driven
alerts
Dashboards update automatically whenever the data in the
underlying data sets is updated
dashboard and report both offer 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.
Which of the following are advantages that Power BI reports have
over Power BI dashboards? -
Questions & Answers (Grade A+)
What should you do if you want data to automatically refresh as
you interact with visuals? -
correct answer ✅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.
How do you connect to excel files that contain target figures? The
solution should involve minimum manual work when excel files are
created. -
correct answer ✅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.
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? -
,DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
correct answer ✅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.
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? -
correct answer ✅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.
Which of the following statements are true with respect to
designing a Power BI Desktop project in DirectQuery mode? -
correct answer ✅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.
,DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
Which three transformations are available when you right-click a
column header in the Query Editor window?. -
correct answer ✅Remove
Duplicate
Change type
Count Rows option is not there when you right click on column
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. -
correct answer ✅Implement dynamic row level security
The answer is B. Creating separate reports for each manager will
duplicate the reports and make it difficult 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.
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 ? -
, DA-100 Comprehensive Review Exam
Questions & Answers (Grade A+)
correct answer ✅True. All Sharepoint report viewers must have a
Power BI Pro License.
Which of the following types of real-time data set in Power BI
always store their data in Azure SQL Database? -
correct answer ✅1. Push datasets
2. Hybrid data sets
- Streaming data set don't store data in Azure SQL database
Which of the following are advantages that Power BI dashboards
have over Power BI reports? -
correct answer ✅Dashboards provide support for data driven
alerts
Dashboards update automatically whenever the data in the
underlying data sets is updated
dashboard and report both offer 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.
Which of the following are advantages that Power BI reports have
over Power BI dashboards? -
