Exam (elaborations)
DA-100, DA-100, DATA ANALYST
- Course
- Institution
DA-100, DA-100, DATA ANALYST
[Show more]
Seller
Follow
Content preview
DA-100, DA-100, DATA ANALYSTD. 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
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 CATEJOHNS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now