Exam (elaborations)
DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONS RATED A.
- Course
- Institution
DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONS RATED A.
[Show more]
Content preview
DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONSRATED A.
1. What should you do if you want data to Direct query. No data is import-
automatically refresh as you interact with ed to Power BI Desktop. As
visuals? you create or interact with a
visualization, Power BI Desk-
top queries the underlying data
source, i.e. you're always view-
ing current data.
2. How do you connect to excel files Connect to the files with folder
that contain target figures? The solution connector and use the combine
should involve minimum manual work binaries functionality. Connect-
when excel files are created. ing to files separately will take
time if there are lot of files in the
folder. Its always better to con-
nect to folder if files have same
structure. If you copy new files in
that folder with same structure,
that file will be loaded automat-
ically without doing any change
to data sources.
3. Imagine you have created a query named Modify the customers query by
Customers in a Power BI Desktop to ap- adding an index column
pend the rows from three external tables Index column option is available
with customer data into a single output in query editor to add indexed
table named Customers. What would be column starting from 0, 1 or cus-
the best approach to add a new fabricat- tom number.
ed ID column to the Customers table to
ensure that every row in the Customers
table contains a unique ID value?
4. Which two of the following strate- Refactor imported tables into a
gies are recommended when design- star schema
ing the queries to import data from an denormalize the data model to
OLTP-style database into a Power BI make it better suited for data
Desktop project? analysis and reporting.
Denormalization and star
schema is desired to transform
, DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONS
RATED A.
the data in the format that is
best fit for visualizations.
5. Which of the following statements are No support for parent child DAX
true with respect to designing a Power BI functions
Desktop project in DirectQuery mode? 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 hierar-
chies.
6. Which three transformations are avail- Remove
able when you right-click a column head- Duplicate
er in the Query Editor window?. Change type
Count Rows option is not there
when you right click on column
7. How can you make sure that each cate- Implement dynamic row level
gory manager can see sales of their cat- security
egory only and CEO to see all sales in the The answer is B. Creating sep-
same report? Your solution must involve arate reports for each man-
minimal effort. ager 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 appropri-
ate 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 every-
thing.
8. In order to use the Power BI web part in True. All Sharepoint report view-
SharePoint Online, the report author as ers must have a Power BI Pro
well as all the report consumers require License.
, DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONS
RATED A.
a Power BI Pro license. Is this statement
true ?
9. Which of the following types of real-time 1. Push datasets
data set in Power BI always store their 2. Hybrid data sets
data in Azure SQL Database? - Streaming data set don't store
data in Azure SQL database
10. Which of the following are advantages Dashboards provide support for
that Power BI dashboards have over Pow- data driven alerts
er BI reports? Dashboards update automati-
cally 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.
11. Which of the following are advantages Reports provide a better inter-
that Power BI reports have over Power BI active filtering and drilldown ex-
dashboards? perience
Reports provide story telling ca-
pabilities using bookmarks
Report definitions can be saved
using an external file format
(PBIX) and checked into source
control
Reports don't support stream-
ing datasets. This feature is
available in dashboard tiles.
12. Which three properties of a tile can be Title
edited in the Power BI dashboard from Subtitle
the Tile details window? Destination link
13.
, DA-100 (Comprehensive Review) QUESTIONS AND ACCURATE SOLUTIONS
RATED A.
What do you need to append to the URL ?collapseNavigation = true
of a Power BI dashboard in order to open When you append ?collapse-
it with the navigation pane collapsed by Navigation=true at the end of a
default? Power BI dashboard URL, it will
take you to the Power BI Dash-
board with the navigation pane
collapsed
14. Which feature is used to create alterna- Synonyms
tive name for fields in tables. It will make
it much easier for users to ask questions
on dashboards?
15. Which page view types are available in a. Fit to page
the Power BI Report View? b. Fit to width
c. Actual size
16. When using the "Split Column by Delim- At each occurrence of the de-
iter" transformation, which option may limiter
result in more than two new columns? Using "At each occurrence
of the delimiter", number of
columns will depend on number
of times a delimiter is used in
string/text.
17. Select the feature that allows you to nav- Web scraping
igate through HTML tags to get the data Web Scraping is the new fea-
from website? ture of Power bi that allows to
navigate through HTML tags to
get data from website
18. What is the use of "Select Related Table" It will import tables that have
option while importing data from SQL physical relationships with se-
server? lected tables
Select related tables will import
all other tables that have rela-
tion with this table.
19. These types will be converted to
related data types
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller saraciousstuvia. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.09. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now