認證考試題庫附有答案

MicroStrategy認證考試MCA題庫[復制]ArchitectingMicroStrategySchema1.BasicschemaobjectsincludeallEXCEPTthefollowing:（A）[單選題]*○Filters○Attributes○Tables○Fact2.

WhattypeofanattributeistheStudentattributeshownintheimageabove?(A)[單選題]*○Heterogeneous○Homogeneous○Compound3.AcustomerpurchasedanewcamerafromStoreX.Atpayment,thecashierrecordsthecustomer’szipcode,creditcardinformation,anditeminformation.Whereisthisinformationmostlikelystoredfirst?（C）[單選題]*○ETLprocess○Datawarehouse○Sourcesystem4.WhatstatementaboutschemaobjectsisNOTcorrect?（B）[單選題]*○Schemaobjectsarelogicalobjectsthatrelateapplicationobjectstodatawarehousecontent.○Schemaobjectcanbecreatedontheflywhileareportisbeingcreated○Theyarethebridgebetweenthereportingenvironmentandthedatawarehouse.○Assuch,thebasicschemaobjectsmustbecreatedbeforeanyothertasks5.TheTimelayerinaprojectcontainstheLU_DAY,LU_MONTH,LU_QUARTER,andLU_YEARtables.Whichofthefollowingstatementsaboutmanagingtablesistrue?（B）[單選題]*○UsingtheRemovefromLayeroptionfortheLU_DAYtablewithintheTimelayerwouldremovethetablefromtheTimelayerandtheproject.○UsingtheRemovefromLayeroptionfortheLU_DAYtablewithintheTimelayerwouldremovethetablefromtheTimelayerbutnotfromtheproject.○UsingtheDeleteoptionfortheLU_DAYtablewithintheTimelayerwouldremovethetableonlyfromtheTimelayer.6.Whichofthefollowingexpressionsisanexampleofasimplefactexpression?（B）[單選題]*○Freight*0.25○Unit_Sales○([Units_Received]/[Freight])7.Whichofthefollowingstatementsaboutfactsistrue?(D)[單選題]*○Factdataisstoredintablesinthemetadatadatabase.○Youcreateattributesbaseduponfacts.○Factscanbeplaceddirectlyonthereporttemplate.○Metricsarereportobjectsthatcanperformcalculationsonfacts.8.WhichstatementaboutmetricsisNOTcorrect?（A）[單選題]*○MetricscanbecreatedusingtheArchitecttoolinDeveloper.○Metricsareusedtoaggregatefacts○Metricsareapplicationobjectsbuiltfromfactsorothermetrics○Metricscaninvolvesimplemathematicaloperators,constants,orcomplexstatisticalfunctions.PhysicalSchemaComponents9.Thedatawarehouseforauniversitystoresinformationaboutstudents,courses,instructors,anddepartments.Astudentcanregisterforoneormorecourses.Eachcourseisofferedmultipletimesduringeachsemester.Aninstructorcouldteachoneormorecourses.Eachinstructorbelongstoaspecificdepartment.HowwouldyoudefinetherelationshipbetweentheStudentattributeandtheInstructorattribute?(C)[單選題]*○Onetomany○Onetoone○Manytomany10.WhichofthefollowingstatementsaboutprojectcreationinMicroStrategyArchitectistrue?(B)[單選題]*○YoucancreatetheprojectobjectinMicroStrategyArchitectgraphicalinterface.○YoucancreatetheprojectobjectintheProjectCreationAssistant○YoucancreateuserhierarchiesontheProjectTablesViewtabintheArchitectgraphicalinterface.○Youmustre-createthemetadatashellbeforeyoucancreateanewprojectinanexistingmetadata.11.WhattoolcanbeusedtocreateaDSN?（C）[單選題]*○ProjectSourceManager○ConfigurationWizard○ConnectivityWizard○DatabaseInstancesManagerBuildingAnalyticalApplications12.Transformations,LevelMetrics,Non-AggregatableMetricsareexamplesof:(D)[單選題]*○B(yǎng)asicMetrics○NestedMetrics○CompoundMetrics○AdvancedMetrics13.Whatofthefollowingtoolscanbeusedtocreateanewmetric?(B)[單選題]*○Facteditor○Metriceditor○Attributeeditor○Noneoftheabove14.WhichMicroStrategyobjectenablesuserstodynamicallydefinesomepartofareport?(D)[單選題]*○Attributes○B(yǎng)asicFilters○Facts○Prompts15.WhichstatementaboutfiltersisNOTcorrect?(A)[單選題]*○Filterscanonlybecreatedwithinareport○Youcancreatefiltersindependentofanyreport○Youcanusefilterstobuildanotherfilter.○Youcanusedattributes,metrics,andprompttocreateafilter.16.Whatistheprimarymodeofaccessforendusers?(B)[單選題]*○Architect○MicroStrategyWeb○Developer○Email17.MicroStrategyprovidescomprehensiveflexibilitytoenablereportingfrom:（D）[單選題]*○Userordepartmentaldata○ERPsystems○Datawarehouseappliances○Alloftheabove18.WhatisthepurposeofcreatingaDSNforadatabase?（A）[單選題]*○Tobeabletoconnecttothatdatabase○Tocreatephysicaltableinthedatabase○Toconnecttoaprojectobject○Alloftheabove19.TheDSNtothemetadataisnamedMy_HR_MD.TheDSNtothedatawarehouseisnamedHR_WH.WhichofthefollowingobjectsusestheHR_WHDSNtoestablishconnectivitytothedatawarehouse?（B）[單選題]*○Three-tierprojectsource○Databaseinstance○Two-tierprojectsource○Alloftheabove20.WhichstatementaboutaprojectsourceisNOTcorrect?（）[單選題]*○Itpointstothedatawarehousedatabase○Canbetwo-tierorthree-tier○Aprojectsourceisapointertoametadatadatabase.○NoneoftheaboveAdministration21.Anewusercanbecreatedusing:(A)[單選題]*○UserEditorintheUserManager○ProjectSourceManager○ConfigurationWizard○ConnectivityWizard22.Allusersbelongtoatleastonegroup(A)[單選題]*○True○False23.Inordertocreateasecurityrole,youusethesecurityroleeditorwhichisaccessiblethrough:(A)[單選題]*○Administration–ConfigurationManagers○ConnectivityWizard○DatabaseInstanceManager○ConfigurationWizardAdvancedDocumentsandReports24.

ThedocumentdisplayedusesadatasetwithsevensubcategoriesunderElectronics.TheRevenuePerUnitSoldvalue,calculatedbydividingRevenuebyUnitsSold,isanexampleofa:(C)[單選題]*○Derivedelement○Summarymetric○Derivedmetric○Viewfilter25.

Theaccompanyingimageisanexampleofwhichreportviewmode?(A)[單選題]*○GridGraphView○GridView○GraphView26.

Whichofthefollowingstatementsaboutthelockedpanelstackdisplayedintheimageistrue?（