认证考试题库附有答案

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)[单选题]*○BasicMetrics○NestedMetrics○CompoundMetrics○AdvancedMetrics13.Whatofthefollowingtoolscanbeusedtocreateanewmetric?(B)[单选题]*○Facteditor○Metriceditor○Attributeeditor○Noneoftheabove14.WhichMicroStrategyobjectenablesuserstodynamicallydefinesomepartofareport?(D)[单选题]*○Attributes○BasicFilters○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?（