Exam (elaborations)
DA-100 PRACTICE EXAM QUESTIONS AND ANSWERS FREQUENTLY TESTED AND RATED A.
- Course
- Institution
DA-100 PRACTICE EXAM QUESTIONS AND ANSWERS FREQUENTLY TESTED AND RATED A.
[Show more]
Content preview
DA-100 PRACTICE EXAM QUESTIONS ANDANSWERS FREQUENTLY TESTED AND RATED A.
In Q&A, do you need to create a measure to be able to use aggregations?
What if you need more than one condition?
Correct Answer -You do not need to create measures to be able to use the
aggregations. You can define an aggregation such as "sum of" in the Q&A
expression. You can define the 'sum of work orders > 1000' as 'high
workload'. If you need more than one condition, you will need to create a
measure with DAX and use the measure in the condition.
Performance: Hidden columns cannot be ______. Do they reduce the size and
improve performance of the model?
Correct Answer -Hidden columns are not searched when using Power Bl.
However, a hidden column is still processed. Hiding a column does not
reduce the size of the model or improve performance.
[ds] When changing an Excel data source does it need to retain the same
folder and filepath as the original?
Correct Answer -You can change the file path for an Excel file in Data source
settings in Power Bl Desktop. The file can be in a different folder on your
local computer and can have a different name.
[cn] What feature allows you to navigate HTML tags to get website data?
Correct Answer -Web Scraping is the new feature of Power bi that allows
navigating through HTML tags to get data from the website.
[tf] Using Merge Queries what 2 join types can you perform?
Correct Answer -The Merge Queries method performs an operation similar
,to a JOIN in SQL. You can specify whether the merge performs an inner or an
outer Join.
[ds] Visuals that refer to the DirectQuery table always show the latest values
in the _______. How is this different from calculated tables?
Correct Answer -Normally, calculated tables always show the data when the
dataset is refreshed, but if the calculated table refers to a DirectQuery table,
visuals that refer to the DirectQuery table always show the latest values in
the underlying source, the data warehouse.
[tf] In order to correct inconsistent data, use the _____ transformation.
Correct Answer -You should apply the Replace Values transform on the
Country column to change the country names so that they are consistent.
[az] ______ reflects the structure and hierarchy of tables in graphical format.
Correct Answer -Query dependency reflects the structure and hierarchy of
tables in graphical format.
[pf] Your manager encounters slowness with a Power Bl report. The network
and server are operating at optimal speed. You need to identify issues
affecting report performance. What 2 tools can you use to troubleshoot?
Correct Answer -
[pf] Performance Analyzer shows you how much time it take to _____ and
_____.
Correct Answer -how much time it takes to render a visual and how long it
takes to retrieve data.
,[pf] Use ___ to identify PowerBI report performance issues. It allows you to
diagnose ___ performance and ____ included in it.
Correct Answer -You can also use Query Diagnostics to identify Power Bl
report performance issues. Query Diagnostics allows you to diagnose query
performance and transformations included in it. A query could have
multiple steps. A step could be a transformation or a simple query.
[ds] You use ___ to create dataflows which uses the ____ language.
Correct Answer -You should use Power Query to create dataflows. You
should not use DAX functions to create dataflows. Power Query uses the M
language
[az] Column distribution shows data _____.
Correct Answer -You should use Column distribution to find data anomalies
or outliers. Data anomalies are outliers in the data. Finding the anomalies
helps you identify what the normal distribution of the data looks like and, it
identifies data that should be investigated. The Column distribution option
in Power Query shows the distribution of data that allows you to find the
anomalies.
You should be aware that the preview is based on the first 1,000 rows. You
should select the Column profiling based on the entire data set to verify that
the column contains unique values.
[az] Column distribution allows you to show ____and _____values for each
column in a single view.
Correct Answer -You should use the Column distribution option to check
distinct and unique rows for each column in a dataset. Column distribution
allows you to show distinct and unique values for each column in a single
view.
, You can use either Column distribution or Column profile to show if the
values in a column are unique, but only Column distribution shows distinct
rows. You should select profiling based on the entire data set.
[az] Column quality shows the number and percentage of ___, ___, and ___
values in a column. Column quality and column ___ check for ___ or ___
values.
Correct Answer -Column quality is an option in Power Query that shows the
number and percentage of valid, error, and empty values in a column.
You can use the Column quality and Column profile options to check empty
or error values.
[az] Column profile shows the ____ and ____ of data in a column. It also
shows ___ or ___ values for the selected column.
Correct Answer -Column profile is an option in Power Query that shows the
statistics and distribution of data in a column.
Column profile allows you to analyze value distribution along with distinct,
unique, empty or error values for the selected column.
[tf] The custom column option allows you to create a new column from
Power Query editor either by using an example or providing a column
formula.
Correct Answer -
[ds] Data connectivity mode is used to set the storage mode to ____ or ____
Query.
Correct Answer -The Data connectivity mode is the option you can use when
connecting to data to set the storage mode as Import or Direct Query.
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 $15.89. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
80796 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now