Jackline
DA-100 Comprehensive Review with answers and 100% sure answers
Terms in this set (285)
What should you do if you want data to Direct query. No data is imported to Power BI Desktop. As you create or interact with a
automatically refresh as you interact with visualization, Power BI Desktop queries the underlying data source, i.e. you're always viewing
visuals? current data.
Connect to the files with folder connector and use the combine binaries functionality.
How do you connect to excel files that contain
Connecting to files separately will take time if there are lot of files in the folder. Its always
target figures? The solution should involve
better to connect to folder if files have same structure. If you copy new files in that folder with
minimum manual work when excel files are
same structure, that file will be loaded automatically without doing any change to data
created.
sources.
DA-100 Comprehensive Review
1/16
,Imagine you have created a query named Modify the customers query by adding an index column
Customers in a Power BI Desktop to append the Index column option is available in query editor to add indexed column starting from 0, 1 or
rows from three external tables with customer custom number.
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?
We have an expert-written solution to this problem!
Which two of the following strategies are Refactor imported tables into a star schema
recommended when designing the queries to denormalize the data model to make it better suited for data analysis and reporting.
import data from an OLTP-style database into a Denormalization and star schema is desired to transform the data in the format that is best fit
Power BI Desktop project? for visualizations.
Which of the following statements are true with No support for parent child DAX functions
respect to designing a Power BI Desktop When in DirectQuery mode, it's not possible to use the family of DAX PATH() functions that
project in DirectQuery mode? generally handle Parent-Child structures, such as chart of accounts, or employee hierarchies.
Remove
Which three transformations are available
Duplicate
when you right-click a column header in the
Change type
Query Editor window?.
Count Rows option is not there when you right click on column
Implement dynamic row level security
How can you make sure that each category The answer is B. Creating separate reports for each manager will duplicate the reports and
manager can see sales of their category only make it difficult to maintain them. Creating a slicer in the report is not going to secure data at
and CEO to see all sales in the same report? all. Dynamic row-level security is the most appropriate choice given that there is a table that
Your solution must involve minimal effort. 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 True. All Sharepoint report viewers must have a Power BI Pro License.
SharePoint Online, the report author as well as
all the report consumers require a Power BI Pro
license. Is this statement true ?
Which of the following types of real-time data 1. Push datasets
set in Power BI always store their data in Azure 2. Hybrid data sets
SQL Database? - Streaming data set don't store data in Azure SQL database
DA-100 Comprehensive Review
2/16
, 10/30/24, 3:18 PM
Dashboards provide support for data driven alerts
Which of the following are advantages that Dashboards update automatically whenever the data in the underlying data sets is updated
Power BI dashboards have over Power BI dashboard and report both offer Q&A functionality. dashboards are not interactive. Only a
reports? 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.
Reports provide a better interactive filtering and drilldown experience
Which of the following are advantages that Reports provide story telling capabilities using bookmarks
Power BI reports have over Power BI Report definitions can be saved using an external file format (PBIX) and checked into source
dashboards? control
Reports don't support streaming datasets. This feature is available in dashboard tiles.
Which three properties of a tile can be edited Title
in the Power BI dashboard from the Tile details Subtitle
window? Destination link
What do you need to append to the URL of a ?collapseNavigation = true
Power BI dashboard in order to open it with the When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will
navigation pane collapsed by default? take you to the Power BI Dashboard with the navigation pane collapsed
Which feature is used to create alternative Synonyms
name for fields in tables. It will make it much
easier for users to ask questions on
dashboards?
a. Fit to page
Which page view types are available in the
b. Fit to width
Power BI Report View?
c. Actual size
When using the "Split Column by Delimiter" At each occurrence of the delimiter
transformation, which option may result in more Using "At each occurrence of the delimiter", number of columns will depend on number of
than two new columns? times a delimiter is used in string/text.
Select the feature that allows you to navigate Web scraping
through HTML tags to get the data from Web Scraping is the new feature of Power bi that allows to navigate through HTML tags to get
website? data from website
What is the use of "Select Related Table" option It will import tables that have physical relationships with selected tables
while importing data from SQL server? Select related tables will import all other tables that have relation with this table.
DA-100 Comprehensive Review
3/16
DA-100 Comprehensive Review with answers and 100% sure answers
Terms in this set (285)
What should you do if you want data to Direct query. No data is imported to Power BI Desktop. As you create or interact with a
automatically refresh as you interact with visualization, Power BI Desktop queries the underlying data source, i.e. you're always viewing
visuals? current data.
Connect to the files with folder connector and use the combine binaries functionality.
How do you connect to excel files that contain
Connecting to files separately will take time if there are lot of files in the folder. Its always
target figures? The solution should involve
better to connect to folder if files have same structure. If you copy new files in that folder with
minimum manual work when excel files are
same structure, that file will be loaded automatically without doing any change to data
created.
sources.
DA-100 Comprehensive Review
1/16
,Imagine you have created a query named Modify the customers query by adding an index column
Customers in a Power BI Desktop to append the Index column option is available in query editor to add indexed column starting from 0, 1 or
rows from three external tables with customer custom number.
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?
We have an expert-written solution to this problem!
Which two of the following strategies are Refactor imported tables into a star schema
recommended when designing the queries to denormalize the data model to make it better suited for data analysis and reporting.
import data from an OLTP-style database into a Denormalization and star schema is desired to transform the data in the format that is best fit
Power BI Desktop project? for visualizations.
Which of the following statements are true with No support for parent child DAX functions
respect to designing a Power BI Desktop When in DirectQuery mode, it's not possible to use the family of DAX PATH() functions that
project in DirectQuery mode? generally handle Parent-Child structures, such as chart of accounts, or employee hierarchies.
Remove
Which three transformations are available
Duplicate
when you right-click a column header in the
Change type
Query Editor window?.
Count Rows option is not there when you right click on column
Implement dynamic row level security
How can you make sure that each category The answer is B. Creating separate reports for each manager will duplicate the reports and
manager can see sales of their category only make it difficult to maintain them. Creating a slicer in the report is not going to secure data at
and CEO to see all sales in the same report? all. Dynamic row-level security is the most appropriate choice given that there is a table that
Your solution must involve minimal effort. 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 True. All Sharepoint report viewers must have a Power BI Pro License.
SharePoint Online, the report author as well as
all the report consumers require a Power BI Pro
license. Is this statement true ?
Which of the following types of real-time data 1. Push datasets
set in Power BI always store their data in Azure 2. Hybrid data sets
SQL Database? - Streaming data set don't store data in Azure SQL database
DA-100 Comprehensive Review
2/16
, 10/30/24, 3:18 PM
Dashboards provide support for data driven alerts
Which of the following are advantages that Dashboards update automatically whenever the data in the underlying data sets is updated
Power BI dashboards have over Power BI dashboard and report both offer Q&A functionality. dashboards are not interactive. Only a
reports? 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.
Reports provide a better interactive filtering and drilldown experience
Which of the following are advantages that Reports provide story telling capabilities using bookmarks
Power BI reports have over Power BI Report definitions can be saved using an external file format (PBIX) and checked into source
dashboards? control
Reports don't support streaming datasets. This feature is available in dashboard tiles.
Which three properties of a tile can be edited Title
in the Power BI dashboard from the Tile details Subtitle
window? Destination link
What do you need to append to the URL of a ?collapseNavigation = true
Power BI dashboard in order to open it with the When you append ?collapseNavigation=true at the end of a Power BI dashboard URL, it will
navigation pane collapsed by default? take you to the Power BI Dashboard with the navigation pane collapsed
Which feature is used to create alternative Synonyms
name for fields in tables. It will make it much
easier for users to ask questions on
dashboards?
a. Fit to page
Which page view types are available in the
b. Fit to width
Power BI Report View?
c. Actual size
When using the "Split Column by Delimiter" At each occurrence of the delimiter
transformation, which option may result in more Using "At each occurrence of the delimiter", number of columns will depend on number of
than two new columns? times a delimiter is used in string/text.
Select the feature that allows you to navigate Web scraping
through HTML tags to get the data from Web Scraping is the new feature of Power bi that allows to navigate through HTML tags to get
website? data from website
What is the use of "Select Related Table" option It will import tables that have physical relationships with selected tables
while importing data from SQL server? Select related tables will import all other tables that have relation with this table.
DA-100 Comprehensive Review
3/16
