Tentamen (uitwerkingen)

DA100 - Practice (Questions and answers) LATEST UPDATE

0 keer verkocht

Vak
DA100

Instelling
DA100

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....

[Meer zien]

Voorbeeld 3 van de 22 pagina's

Bekijk voorbeeld

Geupload op 29 oktober 2024
Aantal pagina's 22
Geschreven in 2024/2025
Type Tentamen (uitwerkingen)
Bevat Vragen en antwoorden

da100

Instelling DA100
Vak DA100

Volgen

ACADEMICMATERIALS

Lid sinds 1 jaar 324 documenten verkocht

€7,88

In winkelwagen

Op verlanglijstje

100% tevredenheidsgarantie
Direct beschikbaar na je betaling
Lees online óf als PDF
Geen vaste maandelijkse kosten

DA100 - Practice Questions
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].)

With a Power BI Premium license, you have the ability to share Power BI content with
___. - ✔️✔️Anyone, even external folks, without purchasing a per-user license.
Otherwise external users would need a Pro license to view shared content.

What are 3 ways to get app access? How about for external users? - ✔️✔️3 ways to
get app access: install through AppSource, receive a direct link, (applies to external
users) automatically install via admin permission.

In an App, where can you add a link to an external resource? - ✔️✔️In the Navigation
pane, Using the New option to add a link to an external resource to the nav pane.

When you unpublish an app, app users lose their _____ such as ____, ____, and
_____. - ✔️✔️Customizations, such as, personal bookmarks, comments, or
subscriptions

An app is the creation of official ___ content. Does it make managing permissions
easier? - ✔️✔️An app is the creation of official packaged content. Managing
permissions is easier with apps.

When giving access permissions in the App, you can give access to specific users,
groups or ______. Users/groups with access to the ____ automatically have access to
the app. - ✔️✔️Entire organization
workspace

What data source allows you to display live data using DirectQuery connection mode? -
✔️✔️Azure SQL Database

What security service prevents information from flowing over into the public internet? -
✔️✔️Azure ExpressRoute extends on-premise networks into the cloud over a private
connection.

A Power BI ___ license is required in order to us AutoML. Data is prepped for machine
learning using ____. - ✔️✔️Power BI Premium. Dataflows.

,In _____ admin center, you can manage members that have access to the app
workspace, by modifying _____. - ✔️✔️Office 365 Admin center, clicking Groups

If users get an error message stating the company has turned off signup for Power BI,
you need to run the ______ - ✔️✔️From Microsoft Azure PowerShell, run the Set-
MsolCompanySettings cmdlet. Set-MsolCompanySettings cmdlet sets company-level
configuration settings.

What are the 3 operations you can do with Power BI Rest APIs? - ✔️✔️Create a
dataset, add rows to a dataset, and refresh an imported dataset. (aka 'Push data')
You cannot retrieve rows from a dataset

Power BI Report Server is available with a Power BI ____ license. It does not support
___ or ___ visuals. - ✔️✔️Premium license. R or Python script visuals.

Does removing access to an app automatically remove the person's build and reshare
permissions? Users with build permission also can ____ reports. Users with the Viewer
role that have build permission can ____ data. - ✔️✔️No. You must remove the user
from the manager permissions option in Datasets.
App users can be given Build Permission allowing them to search for shared datasets.
Users with Build permission can also have permission to copy reports from this app to
another workspace.
Even users with the Viewer role in the new workspace can export data if they have Build
permission on the datasets in that workspace.

Can Power BI Free license users access a published Power BI app? - ✔️✔️Yes

In order to create a Hierarchy, all the involved columns need to be ____ - ✔️✔️In the
same table

What is the first operation to do to optimize data loading performance? - ✔️✔️Remove
unnecessary columns and rows.

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.

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

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

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, Bancontact of creditcard en je bent klaar. Geen abonnement nodig.

Focus op de essentie

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper ACADEMICMATERIALS. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €7,88. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Start met verkopen

Tentamen (uitwerkingen)

DA100 - Practice (Questions and answers) LATEST UPDATE

Document informatie

Onderwerpen

Geschreven voor

Verkoper

Ontvangen beoordelingen

Voorbeeld van de inhoud