Exam (elaborations)
PL - 300 MICROSOFT POWER BI DATA ANALYST PRACTICE QUESTIONS WITH PASSED ANSWERS, GRADED A+.
- Course
- Institution
PL - 300 MICROSOFT POWER BI DATA ANALYST PRACTICE QUESTIONS WITH PASSED ANSWERS, GRADED A+.
[Show more]
Content preview
PL - 300 MICROSOFT POWER BI DATAANALYST PRACTICE QUESTIONS WITH
PASSED ANSWERS, GRADED A+
You ffplan ffto ffget ffdata fffor ffa ffPower ffBI ffdataset fffrom ffflat fffiles. ffYou ffneed ffto ffselect
ffa fflocation fffor ffthe fffiles. ffThe fflocation ffmust ffprovide ffthe ffability ffto ffconfigure
ffscheduled ffrefresh fffor ffthe ffdataset ffby ffusing ffMicrosoft ff365 ffcredentials.
Which fftwo fflocation fftypes ffshould ffyou ffrecommend? ffEach ffcorrect ffanswer ffpresents
ffa ffcomplete ffsolution. ffSelect ffall ffanswers ffthat ffapply.
a. fflocal fffile
b. ffOneDrive fffor ffBusiness
c. ffPersonal ffOneDrive ffaccount
d. ffSharePoint ff- ffTeam ffSites ff- ffAnswer ffb. ffOneDrive fffor ffBusiness
d. ffSharePoint ff- ffTeam ffSites
You ffplan ffto ffadd ffdata ffto ffPower ffBI ffDesktop fffrom ffa ffnew ffdata ffsource. ffYou ffare
ffevaluating ffwhether ffyou ffshould ffuse ffthe ffDirectQuery ffstorage ffmode ffor ffthe ffImport
ffstorage ffmode.
What ffare fftwo ffbenefits ffof ffusing ffDirectQuery ffinstead ffof ffImport? ffEach ffcorrect
ffanswer ffpresents ffa ffcomplete ffsolution.
Select ffall ffanswers ffthat ffapply.
a. fffull ffsupport fffor ffthe ffQ&A ffPower ffBI ffservice
b. fffull ffsupport fffor ffthe ffQuick ffInsights ffPower ffBI ffservice
c. ffminimized fflocal ffdisk ffspace ffusage
d. ffminimized ffneed fffor ffdata ffrefresh ff- ffAnswer ffc. ffminimized fflocal ffdisk ffspace
ffusage
d. ffminimized ffneed fffor ffdata ffrefresh
You ffhave ffdesigned ffa ffstar ffschema ffto ffsimplify ffyour ffdata.
You ffneed ffto ffunderstand ffthe ffrelationship ffbetween ffthe fftables ffin ffthe ffstar ffschema.
What ffis ffthe ffrelationship ffbetween ffthe fffact fftable ffand ffdimension fftables?
Select ffonly ffone ffanswer.
a. ffmany-to-many
b. ffmany-to-one
c. ffone-to-many
d. ffone-to-one ff- ffAnswer ffb. ffmany-to-one
,You ffcreate ffa ffPower ffBI ffDesktop ffdataset ffby ffimporting ffand fftransforming ffa ffdata
ffsource ffbased ffon ffmultiple fftables ffin ffa ffSQL ffServer ffdatabase.
You ffneed ffto ffmodify ffthe ffrelationship ffbetween ffthe fftables.
Which ffinterface ffshould ffyou ffuse ffin ffthe ffPower ffBI ffDesktop?
Select ffonly ffone ffanswer.
a. ffData ffview
b. ffModel ffview ff
c. ffPage ffview
d. ffReport ffview ff- ffAnswer ffb. ffModel ffview
You ffare ffdesigning ffa ffdata ffmodel ffin ffPower ffBI.
You ffneed ffto ffavoid ffintroducing ffambiguity ffinto ffyour ffdata ffmodel ffdesign.
Which fftype ffof ffcardinality ffshould ffyou ffavoid?
Select ffonly ffone ffanswer.
a. ffmany-to-many
b. ffmany-to-one
c. ffone-to-many
d. ffone-to-one ff- ffAnswer ffa. ffmany-to-many
You ffneed ffto ffcreate ffa ffPower ffBI ffdashboard.
Which fftool ffshould ffyou ffuse?
Select ffonly ffone ffanswer.
a. ffPower ffBI ffDesktop
b. ffPower ffQuery ffEditor
c. ffthe ffPower ffBI ffmobile ffapp
d. ffthe ffPower ffBI ffservice ff- ffAnswer ffd. ffthe ffPower ffBI ffservice
You ffare ffevaluating ffwhether ffyou ffneed ffto ffcreate ffa ffdashboard ffin ffPower ffBI.
In ffwhich ffscenario ffdo ffyou ffneed ffa ffdashboard ffinstead ffof ffa ffreport ffin ffPower ffBI?
Select ffonly ffone ffanswer.
a. ffYou ffneed ffto ffadd fffilters. ff
b. ffYou ffneed ffto ffadd ffslicers.
c. ffYou ffneed ffto ffdisplay ffvisuals ffon ffmultiple ffpages.
d. ffYou ffneed ffto ffdisplay ffvisuals ffthat ffuse ffdifferent ffdatasets. ff- ffAnswer ffd. ffYou
ffneed ffto ffdisplay ffvisuals ffthat ffuse ffdifferent ffdatasets.
You ffneed ffto ffcreate ffa ffdashboard fffrom ffa ffpublished ffreport ffin ffPower ffBI.
Which ffoption ffin ffthe ffreport ffshould ffyou ffuse?
Select ffonly ffone ffanswer.
a. ffCopy ffvisual ffas ffimage
b. ffExport ffdata
, c. ffPin ffvisual
d. ffSpotlight ff- ffAnswer ffc. ffPin ffvisual
You ffupload ffreports ffto ffthe ffPower ffBI ffservice ffand ffpin ffseveral ffvisuals ffto ffa
ffdashboard.
You ffplan ffto ffcreate ffalerts ffrules fffor ffseveral ffvisuals.
What ffare fftwo fflocations ffyou ffcan ffview ffthe ffalerts? ffEach ffcorrect ffanswer ffpresents
ffa ffcomplete ffsolution.
Select ffall ffanswers ffthat ffapply.
a. ffa ffreport
b. ffan ffemail
c. ffMicrosoft ffTeams
d. ffthe ffNotification ffCenter ff- ffAnswer ffb. ffan ffemail
d. ffthe ffNotification ffCenter
Your ffcompany ffhas ffa ffSharePoint ffserver fflocated ffin ffa ffdatacentre ffin ffMontreal.
You ffplan ffto ffcreate ffa ffreport ffin ffthe ffPower ffBI ffservice ffthat ffwill ffuse ffMicrosoft
ffExcel fffiles ffstored ffon ffthe ffSharePoint ffserver.
You ffneed ffto ffrecommend ffa ffsolution ffto ffensure ffthat ffthe ffdataset fffor ffthe ffreport ffcan
ffautomatically ffrefresh ffdaily.
What ffshould ffyou ffinclude ffin ffthe ffrecommendation?
Select ffonly ffone ffanswer.
a. ffa ffPoint ffto ffSite ffvirtual ffprivate ffnetwork ff(VPN)
b. ffa ffSite-to-Site ffvirtual ffprivate ffnetwork ff(VPN)
c. ffan ffon-premises ffdata ffgateway
d. ffAzure ffData ffBox ff- ffAnswer ffc. ffan ffon-premises ffdata ffgateway
You ffhave ffa ffrow fflevel ffsecurity ffrole ff(RLS) ffin ffa ffdataset ffcalled ffUser ffSecurity
ffGroup. ffThis ffrole ffneeds ffto fffilter ffa ffRLS fftable ffthat ffcontains ffa ffcolumn ffwith ffthe
ffemails ffof ffusers ffin ffthe fffollowing ffformat:
name@company.com
Which fffunction ffshould ffbe ffused ffin ffthe ffcode fffor ffthe ffRLS ffrole ffto ffmatch ffthe ffusers
ffMicrosoft ffEntra ffID fflogin ffcredentials ffwith ffthe ffemails ffcontained ffin ffthe ffRLS fftable
ffcolumn?
Select ffonly ffone ffanswer.
a. ffNAMEOF
b. ffTREATAS
c. ffUSEROBJECTID
d. ffUSERPRINCIPALNAME ff- ffAnswer ffd. ffUSERPRINCIPALNAME
You ffhave ffa ffPower ffBI ffdataset.
You ffneed ffto ffset ffthe ffdataset ffas ffdiscoverable.
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 LucieLucky. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now