Exam (elaborations)
DA100 - Practice Questions with 100% Correct Answers |Verified
- Course
- Institution
DA100 - Practice Questions with 100% Correct Answers |Verified
[Show more]
Content preview
DA100 - Practice Questions with 100% CorrectAnswers |Verified
When asked to create a measure, pay attention to whether all columns are in the same table -
✔✔You can simply create a measure using the FILTER function since all columns you need
are in the same table.
The addition of two different RLS filters allows the member of both of them to see data for ___
and not just the ___ of them. - ✔✔The addition of two different RLS filters allows the
member of both of them to see data for the RLS_1 as well as for the RLS_2, not just their
intersection. (I.e. The member will see all the data that have ''USA'' as Store[State] or ''T-shirts''
as Product[ProductName].)
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
You plan to create a custom visualization for Power BI. What do you install first? -
✔✔Node.js. The language you use to create a custom visual is JavaScript. Node.js is an open-
source, cross-platform, back-end JavaScript runtime environment that runs on the V8 engine
and executes JavaScript code outside a web browser.
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.
Where do you enable Q&A and add a featured question? - ✔✔You enable Q&A in Power BI
Service on the dataset and you can add a featured question.
In a Line and Clustered Column Chart, in order to create consistency between the 2 scale
values, set the Y-axis start and end settings to ____. - ✔✔Set to Auto the Y-axis 'start' and
'end' settings
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.
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.
, Does publish to web support RLS? - ✔✔No
What connection mode is not support by Publish to Web? What datasets are not supported? -
✔✔Live connection, shared and certified datasets
What 3 type of visuals are not supports by Publish to Web? - ✔✔Q&A, Python and R visuals
Is exporting data or shared reports supported in Publish to Web? - ✔✔No
On-premise data gateway allows for multiple ____ to connect to _______ on-premise data
sources, a single gateway that supports all services. - ✔✔Users, multiple
Personal mode is for a single user and cant be______. Good for scenarios where you are the
only person who creates reports. - ✔✔Shared with others
Where can you disable or prevent reports from being Publish to Web ? - ✔✔You can disable
it in Power BI Admin portal
Can Contributor roles publish apps? - ✔✔No
Viewers can only ___ with reports. - ✔✔Interact
Admins can add/remove people and delete the _____ - ✔✔Workspace
____ and ___ roles can create, delete and publish content to the workspace. - ✔✔Members
and contributors
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 Examsplug. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.24. 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