Exam (elaborations)
DA100 - Practice Questions QUESTIONS WITH ALL PASSED ANSWERS 2024
- Course
- Institution
DA100 - Practice Questions QUESTIONS WITH ALL PASSED ANSWERS 2024
[Show more]
Seller
Follow
Content preview
10/31/24, 3:05 AM DA100 - Practice Questions Flashcards | QuizletEUNICE
DA100 - Practice Questions WITH ALL PASSED ANSWERS
2024
Terms in this set (189)
An app is the creation of official ___ content. An app is the creation of official packaged content. Managing permissions is easier
Does it make managing permissions easier? with apps.
What are 3 ways to get app access? How 3 ways to get app access: install through AppSource, receive a direct link, (applies to
about for external users? external users) automatically install via admin permission.
In an App, where can you add a link to an In the Navigation pane, Using the New option to add a link to an external resource
external resource? to the nav pane.
When you unpublish an app, app users lose Customizations, such as, personal bookmarks, comments, or subscriptions
their _____ such as ____, ____, and _.
When giving access permissions in the App, Entire organization
you can give access to specific users, workspace
groups or ___ _. Users/groups with access
to the __ automatically have access to the
app.
What data source allows you to display live Azure SQL Database
data using DirectQuery connection mode?
What security service prevents information Azure ExpressRoute extends on-premise networks into the cloud over a private
from flowing over into the public internet? connection.
A Power BI ___ license is required in order to Power BI Premium. Dataflows.
us AutoML. Data is prepped for machine
learning using ____.
With a Power BI Premium license, you have Anyone, even external folks, without purchasing a per-user license. Otherwise
the ability to share Power BI content with external users would need a Pro license to view shared content.
___.
In __ admin center, you can manage Office 365 Admin center, clicking Groups
members that have access to the app
workspace, by modifying _ _.
If users get an error message stating the From Microsoft Azure PowerShell, run the Set-MsolCompanySettings cmdlet. Set-
company has turned off signup for Power MsolCompanySettings cmdlet sets company-level configuration settings.
BI, you need to run the ______
Create a dataset, add rows to a dataset, and refresh an imported dataset. (aka 'Push
What are the 3 operations you can do with
data')
Power BI Rest APIs?
You cannot retrieve rows from a dataset
https://quizlet.com/601131794/da100-practice-questions-flash-cards/ 1/8
, 10/31/24, 3:05 AM DA100 - Practice Questions Flashcards | Quizlet
Power BI Report Server is available with a Premium license. R or Python script visuals.
Power BI ____ license. It does not support ___
or ___ visuals.
Does removing access to an app No. You must remove the user from the manager permissions option in Datasets.
automatically remove the person's build App users can be given Build Permission allowing them to search for shared
and reshare permissions? Users with build datasets. Users with Build permission can also have permission to copy reports from
permission also can ___ reports. Users with this app to another workspace.
the Viewer role that have build permission Even users with the Viewer role in the new workspace can export data if they have
can __ data. Build permission on the datasets in that workspace.
Can Power BI Free license users access a Yes
published Power BI app?
In order to create a Hierarchy, all the In the same table
involved columns need to be ____
What is the first operation to do to optimize Remove unnecessary columns and rows.
data loading performance?
When asked to create a measure, pay You can simply create a measure using the FILTER function since all columns you
attention to whether all columns are in the need are in the same table.
same table
The addition of two different RLS filters allows the member of both of them to see
The addition of two different RLS filters
data for the RLS_1 as well as for the RLS_2, not just their intersection. (I.e. The member
allows the member of both of them to see
will see all the data that have ''USA'' as Store[State] or ''T-shirts'' as
data for ___ and not just the ___ of them.
Product[ProductName].)
Consider two Microsoft SQL Server in the Power Query editor, by going to Home> Data source settings, it is possible to
databases named SQLtest and SQLlive. update the origin of the data for the whole model you are working on.
Both the server databases contain the
same tables. What's the easiest way to swap
connection between the 2 dbs?
When you use the Pivot feature, you have When you use the Pivot feature, you have to take care of the Aggregate Value
to take care of the Value Functions Functions displayed in the Advanced options
displayed in the ____ options
As opposed to Text.Replace, ___ replaces Table.ReplaceValue
an existing value with a new value in the
specified columns of a table.
In order to make sure a table contains no Click on Remove Duplicates on the table columns
duplicates, what 2 methods can you use? Add an Index column to the table making all rows unique
Download Microsoft R. Microsoft R Open is the enhanced distribution of R from
In order to use R scripting in Power BI, you
Microsoft Corporation. It is a complete open source platform for statistical analysis
must first download ___.
and data science.
Two visuals have help identify possible Key Influencer and Decomposition tree visuals
causes for data anomalies is ___ and ___.
Node.js. The language you use to create a custom visual is JavaScript. Node.js is an
You plan to create a custom visualization
open-source, cross-platform, back-end JavaScript runtime environment that runs on
for Power BI. What do you install first?
the V8 engine and executes JavaScript code outside a web browser.
Where do you go to add synonyms to the You add Q&A synonyms in Power BI Desktop in the Modeling tab's Properties pane.
Q&A? In Power BI ___ in the ___ tab's _____
pane.
Where do you enable Q&A and add a You enable Q&A in Power BI Service on the dataset and you can add a featured
featured question? question.
https://quizlet.com/601131794/da100-practice-questions-flash-cards/ 2/8
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 mbitheeunice2015. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.49. 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