DA100 - Practice Test Questions With 100% Correct Answers.
2 views 0 purchase
Course
DA100
Institution
DA100
Do dashboards support the Drill Down feature? - ️️No. The Drill Down feature is not
currently available for dashboards experience. You have to share the data as a report
with your colleagues.
How do you ensure that when printing a report, all data in a table will be displayed and
not just t...
DA100 - Practice Test
Do dashboards support the Drill Down feature? - ✔️✔️No. The Drill Down feature is not
currently available for dashboards experience. You have to share the data as a report
with your colleagues.
How do you ensure that when printing a report, all data in a table will be displayed and
not just the current view? - ✔️✔️Create a paginated report. Paginated reports are
designed to be printed or shared. They're called paginated because they're formatted to
fit well on a page. They display all the data in a table, even if the table spans multiple
pages. Power BI Report Builder is the standalone tool for authoring paginated reports
for the Power BI service.
Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the
server databases contain the same tables. What's the easiest way to swap connection
between the 2 dbs? - ✔️✔️in the Power Query editor, by going to Home> Data source
settings, it is possible to update the origin of the data for the whole model you are
working on.
When you use the Pivot feature, you have to take care of the ____ Value Functions
displayed in the ______options - ✔️✔️When you use the Pivot feature, you have to
take care of the Aggregate Value Functions displayed in the Advanced options
As opposed to Text.Replace, _______ replaces an existing value with a new value in
the specified columns of a table. - ✔️✔️Table.ReplaceValue
In order to make sure a table contains no duplicates, what 2 methods can you use? -
✔️✔️Click on Remove Duplicates on the table columns
Add an Index column to the table making all rows unique
In order to use R scripting in Power BI, you must first download ___. - ✔️✔️Download
Microsoft R. Microsoft R Open is the enhanced distribution of R from Microsoft
Corporation. It is a complete open source platform for statistical analysis and data
science.
Two visuals have help identify possible causes for data anomalies is ____ and ___. -
✔️✔️Key Influencer and Decomposition tree visuals
Where do you go to add synonyms to the Q&A? In Power BI ___ in the ___ tab's _____
pane. - ✔️✔️You add Q&A synonyms in Power BI Desktop in the Modeling tab's
Properties pane.
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 ACADEMICMATERIALS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
