Transcription
SASInstituteA00-204Sas warehouse architect conceptshttp://killexams.com/exam-detail/A00-204
Answer: AQUESTION: 56Click on the Exhibit button to view the relationship between three tables. Data fromthree sources needs to be joined by Seller ID and Customer ID. Table 1 is theaccepted truth for Seller ID. Customer ID is contained in both Table 2 and Table 3.However, it has not been defined whether Table 2 or Table 3 contributes the valuesfor Customer ID. Which of the following resolves the discrepancies regarding theCustomer ID?A.B.C.D.creating a surrogate key on each of the tablesreviewing tables in a workshop with source ownersperforming data cleansing to reconcile Table 2 with Table 3creating a surrogate key on each of the tables, then reviewing with source ownersAnswer: BQUESTION: 57According to the SAS Rapid Warehousing Methodology, which of the following arerecommended techniques for gathering high level business requirements during theAssessment Phase?A.B.C.D.interviews and workshops onlyprocess modeling and prototypinginterviews, questionnaires, and workshopsinterviews, process modeling, and workshopsAnswer: DQUESTION: 58An interview has been arranged with a business analyst to determine the functional23
requirements of a data warehouse. Which of the following should be reviewed in thediscussion?A.B.C.D.data model designcompany standardsacceptance test planprocess for making business decisionsAnswer: DQUESTION: 59A business analyst has developed a credit scoring model and wishes to apply this toall the customers in a denormalized table. The input table contains over 10 millionrows and the output is to be retained for detailed analysis. Which of the followingtechniques optimizes performance?A.B.C.D.indexingsamplingretaining only the columns required for the analysisensuring that the WORK library is on a different diskAnswer: CQUESTION: 60Which of the following must be considered when sizing disk space for a SAS datawarehouse after the extract, transform and load (ETL) phase?I.catalog spaceII.transaction log spaceIII.temporary table spaceIV.size of the fact and dimension tablesA.B.C.D.I and IV onlyI, II, and III onlyII, III, and IV onlyI, II, III, and IVAnswer: CQUESTION: 61A retail bank wishes to update its warehouse every month with account level end-ofmonth data. Which of the following extract types is the most appropriate in this24
scenario?A.B.C.D.deltassnapshotmessage queuerelational database management system (RDBMS) journalAnswer: BQUESTION: 62Click on the Exhibit button to view a partial sales fact table. According to "The DataWarehouse Lifecycle Toolkit" by Ralph Kimball, which of the following columnswould be described as a "degenerate dimension"?A.B.C.D.Storage CostInvoice Date KeyQuantity OrderedOriginal Order NumberAnswer: DQUESTION: 63Which of the following is the most useful for creating physical tables andrelationships in an Oracle database management system (DBMS)?25
A.B.C.D.spreadsheetsubject modelentity-relationship (E/R) diagramdata definition language with SQLAnswer: DQUESTION: 64According to the SAS Rapid Warehousing Methodology, which of the following aredeliverables from the Requirements Phase?I. subject modelII. training strategyIII. acceptance test planIV. return on investment reportA.B.C.D.II and III onlyI, II, and III onlyII, III, and IV onlyI, II, III, and IVAnswer: CQUESTION: 65Prior to deploying an OLAP solution to 50 users, the OLAP client application mustundergo system testing. Which of the following must be tested during this phase?I.security modelII.data volume of the result setIII.number of concurrent usersIV.time to build supporting OLAP data martA.B.C.D.I and III onlyII and IV onlyI, II, and III onlyI, II, III, and IVAnswer: C26
For More exams visit https://killexams.com/vendors-exam-listKill your exam at First Attempt.Guaranteed!
An interview has been arranged with a business analyst to determine the functional requirements of a data warehouse. Which of the following should be reviewed in the
