DA-100, DA-100, DATA ANALYST
D. rSplit rthe rDate rcolumn rinto rtwo rcolumns, rone rthat rcontains ronly rthe rtime
rand ranother rthat rcontains ronly rthe rdate. r- rcorrect ranswers-You rhave ra
rlarge rdataset rthat rcontains rmore rthan r1 rmillion rrows. rThe rtable rhas ra
rdatetime rcolumn rnamed rDate. rYou rneed rto rreduce rthe rsize rof rthe rdata
rmodel. rWhat rshould ryou rdo?
· rA. rRound rthe rhour rof rthe rDate rcolumn rto rstartOfHour.
· rB. rChange rthe rdata rtype rof rthe rDate rcolumn rto rText.
· rC. rTrim rthe rDate rcolumn.
· rD. rSplit rthe rDate rcolumn rinto rtwo rcolumns, rone rthat rcontains ronly rthe
rtime rand ranother rthat rcontains ronly rthe rdate.
· rB. rRemove rthe rSubject rand rBody rcolumns rduring rthe rimport. r- rcorrect
ranswers-You rhave ra rcustom rconnector rthat rreturns rID, rFrom, rTo, rSubject,
rBody, rand rHas rAttachments rfor revery remail rsent rduring rthe rpast ryear.
rMore rthan r10 rmillion rrecords rare rreturned. rYou rbuild ra rreport ranalyzing
rthe rinternal rnetworks rof remployees rbased ron rwhom rthey rsend remails rto.
rYou rneed rto rprevent rreport rrecipients rfrom rreading rthe ranalyzed remails.
rThe rsolution rmust rminimize rthe rmodel rsize. rWhat rshould ryou rdo?
· rA. rImplement rrow-level rsecurity r(RLS) rso rthat rthe rreport rrecipients rcan
ronly rsee rresults rbased ron rthe remails rthey rsent.
,· rB. rRemove rthe rSubject rand rBody rcolumns rduring rthe rimport.
· rC. rFrom rModel rview, rset rthe rSubject rand rBody rcolumns rto rHidden.
A. rGroup rthe rimpressions rby rAd_id, rSite_name, rand rImpression_date.
rAggregate rby rusing rthe rCountRows rfunction.
B. rCreate rone-to-many rrelationships rbetween rthe rtables. r- rcorrect ranswers-
The rImpressions rtable rcontains rapproximately r30 rmillion rrecords rper rmonth.
rYou rneed rto rcreate ran rad ranalytics rsystem rto rmeet rthe rfollowing
rrequirements:
✑ rPresent rad rimpression rcounts rfor rthe rday, rcampaign, rand rSite_name.
rThe ranalytics rfor rthe rlast ryear rare rrequired.
✑ rMinimize rthe rdata rmodel rsize.
Which rtwo ractions rshould ryou rperform? rEach rcorrect ranswer rpresents rpart
rof rthe rsolution.
A. rGroup rthe rimpressions rby rAd_id, rSite_name, rand rImpression_date.
rAggregate rby rusing rthe rCountRows rfunction.
B. rCreate rone-to-many rrelationships rbetween rthe rtables.
C. rCreate ra rcalculated rmeasure rthat raggregates rby rusing rthe rCOUNTROWS
rfunction.
D. rCreate ra rcalculated rtable rthat rcontains rAd_id, rSite_name, rand
rImpression_date.
· rD. rweb rcontent r- rcorrect ranswers-Your rcompany rhas rtraining rvideos rthat
rare rpublished rto rMicrosoft rStream. rYou rneed rto rsurface rthe rvideos rdirectly
rin ra rMicrosoft rPower rBI rdashboard. rWhich rtype rof rtile rshould ryou radd?
· rA. rvideo
· rB. rcustom rstreaming rdata
· rC. rtext rbox
· rD. rweb rcontent
· rD. rColumn rquality r- rcorrect ranswers-You ropen ra rquery rin rPower rQuery
rEditor. rYou rneed rto ridentify rthe rpercentage rof rempty rvalues rin reach
rcolumn ras rquickly ras rpossible. rWhich rData rPreview roption rshould ryou
rselect?
· rA. rShow rwhitespace
· rB. rColumn rprofile
· rC. rColumn rdistribution
· rD. rColumn rquality
· rC. rEnable rColumn rprofiling rbased ron rentire rdataset.
, · rE. rSelect rColumn rprofile. r- rcorrect ranswers-You rhave ra rprospective
rcustomer rlist rthat rcontains r1,500 rrows rof rdata. rThe rlist rcontains rthe
rfollowing rfields:
✑ rFirst rname
✑ rLast rname
✑ rEmail raddress
✑ rState/Region
✑ rPhone rnumber
You rimport rthe rlist rinto rPower rQuery rEditor. rYou rneed rto rensure rthat rthe
rlist rcontains rrecords rfor reach rState/Region rto rwhich ryou rwant rto rtarget ra
rmarketing rcampaign. rWhich rtwo ractions rshould ryou rperform? r
· rA. rOpen rthe rAdvanced rEditor.
· rB. rSelect rColumn rquality.
· rC. rEnable rColumn rprofiling rbased ron rentire rdataset.
· rD. rSelect rColumn rdistribution.
· rE. rSelect rColumn rprofile.
1. rRemove rColumn
2. rList.Select
3. rText.EndsWith r- rcorrect ranswers-HOTSPOT r-You rhave ran rAPI rthat
rreturns rmore rthan r100 rcolumns. rThe rfollowing ris ra rsample rof rcolumn
rnames.
✑ rclient_notified_timestamp
✑ rclient_notified_source
✑ rclient_notified_sourceid
✑ rclient_notified_value
✑ rclient_responded_timestamp
✑ rclient_responded_source
✑ rclient_responded_sourceid
✑ rclient_responded_value
You rplan rto rinclude ronly ra rsubset rof rthe rreturned rcolumns. rYou rneed rto
rremove rany rcolumns rthat rhave ra rsuffix rof rsourceid. rHow rshould ryou
rcomplete rthe rPower rQuery rM rcode? rTo ranswer, rselect rthe rappropriate
roptions rin rthe ranswer rarea.
1. rConvert rthe rlist rto ra rtable
2. rExpand rthe rcolumns
3. rSet rthe rdata rtypes r- rcorrect ranswers-DRAG rDROP r- rYou rare rbuilding ra
rdataset rfrom ra rJSON rfile rthat rcontains ran rarray rof rdocuments.You rneed rto
D. rSplit rthe rDate rcolumn rinto rtwo rcolumns, rone rthat rcontains ronly rthe rtime
rand ranother rthat rcontains ronly rthe rdate. r- rcorrect ranswers-You rhave ra
rlarge rdataset rthat rcontains rmore rthan r1 rmillion rrows. rThe rtable rhas ra
rdatetime rcolumn rnamed rDate. rYou rneed rto rreduce rthe rsize rof rthe rdata
rmodel. rWhat rshould ryou rdo?
· rA. rRound rthe rhour rof rthe rDate rcolumn rto rstartOfHour.
· rB. rChange rthe rdata rtype rof rthe rDate rcolumn rto rText.
· rC. rTrim rthe rDate rcolumn.
· rD. rSplit rthe rDate rcolumn rinto rtwo rcolumns, rone rthat rcontains ronly rthe
rtime rand ranother rthat rcontains ronly rthe rdate.
· rB. rRemove rthe rSubject rand rBody rcolumns rduring rthe rimport. r- rcorrect
ranswers-You rhave ra rcustom rconnector rthat rreturns rID, rFrom, rTo, rSubject,
rBody, rand rHas rAttachments rfor revery remail rsent rduring rthe rpast ryear.
rMore rthan r10 rmillion rrecords rare rreturned. rYou rbuild ra rreport ranalyzing
rthe rinternal rnetworks rof remployees rbased ron rwhom rthey rsend remails rto.
rYou rneed rto rprevent rreport rrecipients rfrom rreading rthe ranalyzed remails.
rThe rsolution rmust rminimize rthe rmodel rsize. rWhat rshould ryou rdo?
· rA. rImplement rrow-level rsecurity r(RLS) rso rthat rthe rreport rrecipients rcan
ronly rsee rresults rbased ron rthe remails rthey rsent.
,· rB. rRemove rthe rSubject rand rBody rcolumns rduring rthe rimport.
· rC. rFrom rModel rview, rset rthe rSubject rand rBody rcolumns rto rHidden.
A. rGroup rthe rimpressions rby rAd_id, rSite_name, rand rImpression_date.
rAggregate rby rusing rthe rCountRows rfunction.
B. rCreate rone-to-many rrelationships rbetween rthe rtables. r- rcorrect ranswers-
The rImpressions rtable rcontains rapproximately r30 rmillion rrecords rper rmonth.
rYou rneed rto rcreate ran rad ranalytics rsystem rto rmeet rthe rfollowing
rrequirements:
✑ rPresent rad rimpression rcounts rfor rthe rday, rcampaign, rand rSite_name.
rThe ranalytics rfor rthe rlast ryear rare rrequired.
✑ rMinimize rthe rdata rmodel rsize.
Which rtwo ractions rshould ryou rperform? rEach rcorrect ranswer rpresents rpart
rof rthe rsolution.
A. rGroup rthe rimpressions rby rAd_id, rSite_name, rand rImpression_date.
rAggregate rby rusing rthe rCountRows rfunction.
B. rCreate rone-to-many rrelationships rbetween rthe rtables.
C. rCreate ra rcalculated rmeasure rthat raggregates rby rusing rthe rCOUNTROWS
rfunction.
D. rCreate ra rcalculated rtable rthat rcontains rAd_id, rSite_name, rand
rImpression_date.
· rD. rweb rcontent r- rcorrect ranswers-Your rcompany rhas rtraining rvideos rthat
rare rpublished rto rMicrosoft rStream. rYou rneed rto rsurface rthe rvideos rdirectly
rin ra rMicrosoft rPower rBI rdashboard. rWhich rtype rof rtile rshould ryou radd?
· rA. rvideo
· rB. rcustom rstreaming rdata
· rC. rtext rbox
· rD. rweb rcontent
· rD. rColumn rquality r- rcorrect ranswers-You ropen ra rquery rin rPower rQuery
rEditor. rYou rneed rto ridentify rthe rpercentage rof rempty rvalues rin reach
rcolumn ras rquickly ras rpossible. rWhich rData rPreview roption rshould ryou
rselect?
· rA. rShow rwhitespace
· rB. rColumn rprofile
· rC. rColumn rdistribution
· rD. rColumn rquality
· rC. rEnable rColumn rprofiling rbased ron rentire rdataset.
, · rE. rSelect rColumn rprofile. r- rcorrect ranswers-You rhave ra rprospective
rcustomer rlist rthat rcontains r1,500 rrows rof rdata. rThe rlist rcontains rthe
rfollowing rfields:
✑ rFirst rname
✑ rLast rname
✑ rEmail raddress
✑ rState/Region
✑ rPhone rnumber
You rimport rthe rlist rinto rPower rQuery rEditor. rYou rneed rto rensure rthat rthe
rlist rcontains rrecords rfor reach rState/Region rto rwhich ryou rwant rto rtarget ra
rmarketing rcampaign. rWhich rtwo ractions rshould ryou rperform? r
· rA. rOpen rthe rAdvanced rEditor.
· rB. rSelect rColumn rquality.
· rC. rEnable rColumn rprofiling rbased ron rentire rdataset.
· rD. rSelect rColumn rdistribution.
· rE. rSelect rColumn rprofile.
1. rRemove rColumn
2. rList.Select
3. rText.EndsWith r- rcorrect ranswers-HOTSPOT r-You rhave ran rAPI rthat
rreturns rmore rthan r100 rcolumns. rThe rfollowing ris ra rsample rof rcolumn
rnames.
✑ rclient_notified_timestamp
✑ rclient_notified_source
✑ rclient_notified_sourceid
✑ rclient_notified_value
✑ rclient_responded_timestamp
✑ rclient_responded_source
✑ rclient_responded_sourceid
✑ rclient_responded_value
You rplan rto rinclude ronly ra rsubset rof rthe rreturned rcolumns. rYou rneed rto
rremove rany rcolumns rthat rhave ra rsuffix rof rsourceid. rHow rshould ryou
rcomplete rthe rPower rQuery rM rcode? rTo ranswer, rselect rthe rappropriate
roptions rin rthe ranswer rarea.
1. rConvert rthe rlist rto ra rtable
2. rExpand rthe rcolumns
3. rSet rthe rdata rtypes r- rcorrect ranswers-DRAG rDROP r- rYou rare rbuilding ra
rdataset rfrom ra rJSON rfile rthat rcontains ran rarray rof rdocuments.You rneed rto
