Download WGU D465 - Data Applications and more Exams Nursing in PDF only on Docsity!
WGU D465 - Data Applications |
QUESTIONS AND ANSWERS|100%
CORRECT||NEW UPDATE
R kland klPython klsimilarities kl- klBoth klwidely klused klin kldata klscience klwith klextensive kllibraries. R klunique klchallenges kl- klSteeper kllearning klcurve, kllimited klweb kldev klcapabilities. Advantage klof klstoring klcode klin klR kl- klAllows klreproducibility kland klcollaboration klamong klanalysts. Programming kllanguages kland kluse klcases kl- klPython: klweb kldev, kldata klscience, klML, klautomation. MIN klfunction klin klspreadsheets kl- klReturns klthe klsmallest klvalue klin kla klcell klrange. COUNTIF klfunction klin klspreadsheets kl- klCounts klcells klmeeting kla klspecified klcondition. Pivot kltable klelements kl- klRows, klcolumns, klvalues, klfilters klfor kldata klaggregation. SELECT klcommand klin klSQL kl- klRetrieves kldata klfrom klone klor klmore kldatabase kltables. JOIN klcommands klin klSQL kl- klINNER, klLEFT, klRIGHT, klFULL klOUTER klJOIN kltypes.
Delimiter klfor klcode klchunks kl- klTriple klbackticks klor klmarkup klto kldefine klcode klsections. Output klformats klfor kldocuments kl- klHTML, klPDF, klWord kl(docx), klMarkdown. Presentation klformats kl- klSlides, klDashboards, klInteractive klweb klapps. Knit klbutton klin klR kl- klCompiles klR klMarkdown klinto kldesired kloutput klformats. Symbol klfor klcomments klin klR kl- klPound klsign kl(#) klprecedes klcomments klin klR. Nested klfunction klusage kl- klSimplifies kloperations, klimproves klcode klreadability. Logical kloperators kl- klAND kl(&&), klOR kl(||), klNOT kl(!). Advantage klof kltidyverse kl- klCohesive kldata klmanipulation klpackages klin klR. Functions klin klggplot2 kl- klggplot(), klgeom_point(), klgeom_line(), klaes(). Plus klsign klin klggplot2 kl- klAdds kllayers klto klggplot klobjects klfor klcustomization. Common klerrors klin klggplot2 kl- klIncorrect klaesthetic klmappings, klsyntax klmisunderstanding. Basic klaesthetic klattributes klin klggplot2 kl- klx-axis, kly-axis, klcolor klfor klplot klcustomization. Smoothing klline klusage kl- klVisual klrepresentation klof kltrends klin kldata.
VALUE kl- klCOUNTIF What klis klan klexample klof klan klarray klin kla klspreadsheet? All klcells klwith klnumber klvalues Cells klD7, klE14, kland klF The klvalues klin klcells klB2 klthrough klB All klcells klwith klvalues klgreater klthan kl 100 kl- klThe klvalues klin klcells klB2 klthrough klB Which klfunction klwill klcalculate klthe klsum klof klthe klproducts klof klthe klcorresponding klitems klin klthe klarrays klM1:M4 kland klP1:P4? =SUMPRODUCT(M1:M4, klP1:P4) =MULTIPLY(M1:M4, klP1:P4) =PRODUCT(M1:M4, klP1:P4) =ARRAY(M1:M4, klP1:P4) kl- kl=SUMPRODUCT(M1:M4, klP1:P4) Fill klin klthe klblank: klThe kl_____ klof kla klpivot kltable klorganize kland klgroup klthe klselected kldata klhorizontally. columns rows filters values kl- klrows Which klspreadsheet kltool klfinds klan klaverage klvalue klusing klvalues klgenerated klwithin kla klpivot kltable?
Filter Data klvalidation Conditional klformatting Calculated klfield kl- klCalculated klfield In kla klSQL klquery, klwhat klis klthe klpurpose klof klthe klmodulo kl(%) kloperator? kl Return klthe klremainder klof kla kldivision klcalculation Convert kla kldecimal klto kla klpercent Apply klan klexponent klto kla klvalue kl Find klthe klsquare klroot klof kla klnumber kl- klReturn klthe klremainder klof kla kldivision klcalculation A kldata klprofessional klwrites kla klquery klthat kluses klmore klthan klone klarithmetic kloperator. klWhat kldo klthey kladd klto klthe klquery klto klcontrol klthe klorder klof klthe klcalculations? Dollar klsign kl($) Parenthesis kl[()] kl Colon kl[:] Backslash kl[/] kl- klParenthesis kl[()] Spreadsheet klcell klD5 klcontains klthe kldecimal kl.74. klWhich klformula klwill klconvert klit klto kla klpercentage? =D5% =D5, =D5(100)
- klWHERE kldaily_growth_rate_percentage kl= kl0.
- kl) Plant klvarieties klthat klgrow klexactly kl0.05 klpercent klper klday A klrandom klsubset klof klAfrican klplant klspecies kl Plant klvarieties klthat klare klequal klto kl0.05 klinches kltall kl All klplant klspecies klthat klexist klin klthe klpublic kldataset kl- klPlant klvarieties klthat klgrow klexactly kl0. klpercent klper klday Fill klin klthe klblank: klA kldata klanalyst kluses kl_____ klto klcopy kldata klfrom klone kltable klinto kla kltemporary kltable klwithout kladding klthe klnew kltable klto klthe kldatabase. TEMP COPY klTO WITH SELECT klINTO kl- klSELECT klINTO Why klmight kla kldata klprofessional kladd kla klCREATE klTABLE klstatement klto kla kltemporary kltable? Include klmetadata klabout klthe kldata klin klthe kltable Automate klcalculations klin klthe kltable Give klmultiple klpeople klaccess klto klthe kltable Create kla klsecond kltable klwithin klthe kltemporary kltable kl- klGive klmultiple klpeople klaccess klto klthe kltable Array kl- klA klcollection klof klvalues klin klspreadsheet klcells
Calculated klfield kl- klA klnew klfield klwithin kla klpivot kltable klthat klcarries klout klcertain klcalculations klbased klon klthe klvalues klof klother klfields Data klsecurity kl- klProtecting kldata klfrom klunauthorized klaccess klor klcorruption klby kladopting klsafety klmeasures Data klvalidation klprocess kl- klThe klprocess klof klchecking kland klrechecking klthe klquality klof kldata klso klthat klit klis klcomplete, klaccurate, klsecure kland klconsistent GROUP klBY kl- klA klSQL klclause klthat klgroups klrows klthat klhave klthe klsame klvalues klfrom kla kltable klinto klsummary klrows Modulo kl- klAn kloperator kl(%) klthat klreturns klthe klremainder klwhen klone klnumber klis kldivided klby klanother Profit klmargin kl- klA klpercentage klthat klindicates klhow klmany klcents klof klprofit klhas klbeen klgenerated klfor kleach kldollar klof klsale Summary kltable kl- klA kltable klused klto klsummarize klstatistical klinformation klabout kldata SUMPRODUCT kl- klA klfunction klthat klmultiplies klarrays kland klreturns klthe klsum klof klthose klproducts Temporary kltable kl- klA kldatabase kltable klthat klis klcreated kland klexists kltemporarily klon kla kldatabase klserver Underscores kl- klLines klused klto klunderline klwords kland klconnect kltext klcharacters A kldata klanalyst klat kla klrecycling klcompany klmanually klrecalculates klthe klnew klcolumn klmaterials_sorter. klThey klwant klto klidentify klany klrows klwith klvalues klthat kldo klnot klmatch klthose
The klsum klof klall klvalues klin klcells klK20 klto klK70 klfor klwhich klthe klvalue klin klcells klL20 klto klL70 klis klgreater klthan klor klequal klto kl50. The klcount klof klthe klnumber klof klcells klin klthe klarray klK20:K70 klthat klhave kla klvalue klgreater klthan klor klequal klto kl50. kl- klThe klsum klof klall klvalues klin klcells klL20 klto klL70 klthat klcorrespond klto klvalues klin klcells klK20 klto klK70 klthat klare klgreater klthan klor klequal klto kl50. Which klof klthe klfollowing klstatements klaccurately kldescribe klpivot kltables? klSelect klall klthat klapply. The klcalculated klfield klin kla klpivot kltable klis klused klto klapply klfilters klbased klon klspecific klcriteria. The klvalues klin kla klpivot kltable klare klused klto klcalculate kland klcount kldata. kl A klpivot kltable klis kla kldata klsummarization kltool. The klrows klof kla klpivot kltable klorganize kland klgroup kldata klhorizontally. kl- klThe klvalues klin kla klpivot kltable klare klused klto klcalculate kland klcount kldata. kl A klpivot kltable klis kla kldata klsummarization kltool. The klrows klof kla klpivot kltable klorganize kland klgroup kldata klhorizontally. A kldata klanalyst klat klan klengineering klcompany klcalculates klthe klnumber klof klspreadsheet klrows klthat klcontain klthe klvalue klturbine. klWhich klfunction kldo klthey kluse? =COUNTIF(C1:C100,"turbine") =COUNTIF(C1:C100,turbine) =COUNTIF(C1:C100,"=turbine") =COUNTIF(turbine=C1:C100) kl- kl=COUNTIF(C1:C100,"turbine") Fill klin klthe klblank: klTo klcopy kldata klfrom klone kltable klinto kla kl_____, kla kldata klprofessional kluses klthe klSELECT klINTO klstatement. kl temporary kltable
new kltable defined klfunction table klview kl- kltemporary kltable Fill klin klthe klblank: klTo klcombine klrows klfrom kltwo klor klmore kltables klbased klon kla kl_____ klcolumn, kldata klprofessionals kluse klthe klSQL klJOIN klclause. unique kl dissimilar foreign related kl- klrelated A kldata klanalyst klwants klto klretrieve klonly klrecords klfrom kla kldatabase klthat klhave klmatching klvalues klin kltwo kldifferent kltables. klWhich klJOIN klfunction klshould klthey kluse? OUTER klJOIN RIGHT klJOIN INNER klJOIN LEFT klJOIN kl- klINNER klJOIN You klwrite kla klSQL klquery klthat klwill klcount klvalues klin kla klspecified klrange. klWhich klfunction klshould klyou klinclude klin klyour klquery klto klonly klcount kleach klvalue klonce, kleven klif klit klappears klmultiple kltimes? COUNT klRANGE COUNT klDISTINCT COUNT COUNT klVALUES kl- klCOUNT klDISTINCT
- klFROM klproducts
- klSELECT klprice
- klFROM klsales
- klWHERE klprice kl= kl(SELECT klMAX kl(salary)
- klFROM klsales) kl- kl1. klSELECT klprice
- klFROM klsales
- klWHERE klprice kl= kl(SELECT klMAX kl(salary)
- klFROM klsales)
- klSELECT klemployee_id
- klFROM klemployees
- klWHERE kldepartment_id klIN kl(SELECT kldepartment_id
- klFROM kldepartments
- klWHERE kllocation_id kl= kl1000) When klworking klwith klsubqueries, klwhich klquery klwill klexecute klfirst? Rightmost Outermost Innermost Leftmost kl- klInnermost Which klHAVING klclause klindicates klto klonly klretrieve klproducts klthat klhave klbeen klsold klmore klthan kl 100 kltimes? HAVING klCOUNT(order_items.product_id) kl> kl 100
HAVING klCOUNT(order_items.product_id) kl< kl 100 HAVING kl(order_items.product_id) kl> kl 100 HAVING kl(order_items.product_id kl> kl100) kl- klHAVING klCOUNT(order_items.product_id) kl> kl 100 Fill klin klthe klblank: klA kldata klprofessional kluses klthe klSQL kl_____ klstatement klto klreturn klrecords klthat klmeet klconditions klby klincluding klan klif/then klstatement klin kla klquery. CASE HAVING WHEN CONCAT kl- klCASE Absolute klreference kl- klA klreference klwithin kla klfunction klthat klis kllocked klso klthat klrows kland klcolumns klwon't klchange klif klthe klfunction klis klcopied Aggregation kl- klThe klprocess klof klcollecting klor klgathering klmany klseparate klpieces klinto kla klwhole Aliasing kl- klTemporarily klnaming kla kltable klor klcolumn klin kla klquery klto klmake klit kleasier klto klread kland klwrite COUNT klDISTINCT kl- klA klSQL klfunction klthat klonly klreturns klthe kldistinct klvalues klin kla klspecified klrange Data klaggregation kl- klThe klprocess klof klgathering kldata klfrom klmultiple klsources kland klcombining klit klinto kla klsingle, klsummarized klcollection INNER klJOIN kl- klA klSQL klfunction klthat klreturns klrecords klwith klmatching klvalues klin klboth kltables
NOSPACE
VALUE kl- klTRIM Fill klin klthe klblank: klThe klspreadsheet klfunction kl_____ klcan klbe klused klto kltally klthe klnumber klof klcells klin kla klrange klthat klare klnot klempty. RANGE COUNT COUNT klDISTINCT RETURN kl- klCOUNT A kljunior kldata klanalyst klwrites klthe klfollowing klformula: kl=AVERAGE($C$1:$C$100). klWhat klare klthe klpurposes klof klthe kldollar klsigns kl($)? klSelect klall klthat klapply. kl Average klthe klvalues klin klcells klC1 klto klC100 klregardless klof klwhether klthe klformula klis klcopied. Ensure klrows kland klcolumns kldo klnot klchange. Create klan klabsolute klreference. Perform klthe klcalculation klmore klefficiently. kl- klCreate klan klabsolute klreference. Ensure klrows kland klcolumns kldo klnot klchange. What klwill klthis klquery klreturn?
- klSELECT kl*
- klFROM klBooks_table
- klLEFT klJOIN klBiography_table
All klrecords klin klthe klbiography kltable kland klany klmatching klrows klfrom klthe klbooks kltable All klrecords klin klboth klthe klbooks kltable kland klthe klbiography kltable All klrows klfrom klthe klbooks kltable kljoined kltogether klwith klthe klbiography kltable All klrecords klin klthe klbooks kltable kland klany klmatching klrows klfrom klthe klbiography kltable kl- klAll klrecords klin klthe klbooks kltable kland klany klmatching klrows klfrom klthe klbiography kltable A klspreadsheet klcell klcontains klthe klcoldest kltemperature klever klrecorded klin klAustria: kl- kldegrees klCelsius. klWhich klfunction klwould klconvert klthat klto klFahrenheit? kl =CONVERT(-37, klF, klC) =CONVERT(-37, klC, klF) =CONVERT(-37, kl"F", kl"C") =CONVERT(-37, kl"C", kl"F") kl- kl=CONVERT(-37, kl"F", kl"C") Fill klin klthe klblank: klA kldata klprofessional kluses kl_____ klin klorder klto klensure klspreadsheet klvalues klare klstatic, klrather klthan klcarrying klover kla klpreexisting klformula klor klfunction. conditional klformatting formatting paste klvalues klonly data klvalidation kl- klpaste klvalues klonly Which kldata-validation klmenu kloption klhighlights kldata klentry klerrors klto klensure klspreadsheet klformulas klcontinue klto klrun klcorrectly? Reject klinvalid klinputs Forbid klentry Deny kltext
RETURN kl 50 ONLY kl 50 kl- klLIMIT kl 50 A kldata klprofessional klruns kla klquery klthat klwill klreturn kla kldataset klcontaining klnumbers klout klto klfive kldecimal klplaces. klWhich klSQL klfunction klwill kllimit klthe klrecords klto kltwo kldecimal klplaces? LEN NUM LIMIT ROUND kl- klROUND Which klfunction klwill klreturn klthe klnumber klof klcharacters klin klspreadsheet klcell klF8 klin klorder klto klconfirm klit klcontains klexactly kl 15 klcharacters? =LEN(F8, kl15) =LEN(15) =LEN(F8) =LEN(15, klF8) kl- kl=LEN(F8) ROUND kl- klA klSQL klfunction klthat klreturns kla klnumber klrounded klto kla klcertain klnumber klof kldecimal klplaces Fill klin klthe klblank: klA kljunior kldata klanalyst klat kla klhealthcare klorganization kluses klthe klspreadsheet kl_____ klfunction klto kllocate klspecific klcharacters klfrom klinsurance klprovider klaccount klnumbers. FROM FIND
WHERE
IDENTIFY kl- klFIND A kldata klanalyst klworks klwith kla klspreadsheet klcontaining klproduct klinformation klthat kloften klhas klvery kllong kltext klstrings. klTo klcheck klfor klconsistency, klthey kluse kla klfunction klto klcount klthe klnumber klof klcharacters klin klcell klP12. klWhat klis klthe klcorrect klsyntax klof klthe klfunction? =LEN(P:12) =LEN(P,12) =LEN(P:P12) =LEN(P12) kl- kl=LEN(P12) You klprepare kla klproject kltracker klspreadsheet. klNext klto kleach klproject klis klthe klname klof klthe klteam klmember klresponsible. klWhat klspreadsheet kltool klwill klcreate kla kldrop-down kllist klwith klteam klmember klnames klto klsave klyou kltime klwhen klassigning klthe klprojects? Data klvalidation Conditional klformatting Pop-up klmenus Find kl- klData klvalidation An klanalyst klworks klwith kla kldataset klof klfinancial kldata klthat klis klformatted klin klU.S. kldollars. klHowever, klit klshould klbe klformatted klas klJapanese klyen. klWhat klspreadsheet kltool klshould klthey kluse klto klcorrect klthe klformat? Format klas klcurrency Format klas klyen Format klas klamount Format klas klmoney kl- klFormat klas klcurrency
