SAS Base Programming for SAS.doc

SAS Base Programming for SAS 9Item 1The following program is submitted. data test; input name $ age;cards;John +35;run;Which values are stored in the output data set? A. name age-John 35 B. name age-John (missing value)C. name age-(missing value) (missing value)D. The DATA step fails execution due to data errors. correct_answer = A Item 2The following observation is stored in a SAS data set named EMPLOYEES: LNAME FNAME JOBCODE-Whitley Sam na1 If the DATA step below is executed, what will be the value of the variable JOBDESC in the output SAS data set when this observation is processed: data navigate; set employees; if jobcode = NA1 then jobdesc = Navigator;run;A. navigator B. Navigator C. NAVIGATOR D. a missing value correct_answer = D Item 3The following SAS program is submitted: proc format; value score 1 - 50 = Fail 51 - 100 = Pass;run;Which one of the following PRINT procedure steps correctly applies the format? A. proc print data = sasuser.class; var test; format test score;run;B. proc print data = sasuser.class; var test; format test score.;run;C. proc print data = sasuser.class format = score; var test;run;D. proc print data = sasuser.class format = score.; var test; run;correct_answer = B Item 4Given the following DATA step: data loop; x = 0; do index = 1 to 5 by 2; x = index ; end;run;Upon completion of execution, what are the values of the variables X and INDEX in the SAS data set named LOOP? A. x = 3, index = 3 B. x = 3, index = 4 C. x = 5, index = 5 D. x = 5, index = 6 E. x = 5, index = 7 correct_answer = E Item 5Given that the data set named ONE contains 10 observations and the data set named TWO contains 10 observations, how many observations will be contained in the data set named COMBINE that is created in the following DATA step? data combine; set one two;run;A. 10 B. 20 C. 0, the DATA step will fail due to syntax errors D. 10 to 20, depending on how many observations match correct_answer = B SAS Advanced Programming for SAS 9Item 1Given the following SAS data sets ONE and TWO: The following SAS program is submitted: proc sql; select one.*, sales from one right join two on one.year = two.year;quit;Which one of the following reports is generated? A.B.C.D.correct_answer = D Item 2Given the following SAS data sets ONE and TWO: The following SAS program is submitted creating the output table THREE: data three;merge one (in = in1) two (in = in2); by num;run;Which one of the following SQL programs creates an equivalent SAS data set THREE? A. proc sql;create table three as select * from one full join two where one.num = two.num;quit;B. proc sql;create table three as select coalesce(one.num, two.num) as NUM, char1, char2 from one full join two where one.num = two.num;quit;C. proc sql;create table three as select one.num, char1, char2 from one full join two on one.num = two.num;quit;D. proc sql;create table three as select coalesce(one.num, two.num) as NUM, char1, char2 from one full join two on one.num = two.num;quit;correct_answer = D Item 3The following SAS program is submitted: %let type = RANCH;proc sql; create view houses as select * from sasuser.houses where style = &type;quit;%let type = CONDO;proc print data = houses;run;The report that is produced displays observations whose value of STYLE are all equal to RANCH. Which one of the following functions on the WHERE clause resolves the current value of the macro variable TYPE? A. GET B. SYMGET C. %SYMGET D. &RETRIEVE correct_answer = B Item 4The SAS data set SASDATA.SALES has a simple index on the variable DATE and a variable named REVENUE with no index. In which one of the following SAS programs is the DATE index considered for use? A. proc print data = sasdata.sales; by date;run;B. proc print data = sasdata.sales; where month(date) = 3;run;C. data march; set sasdata.sales; if 01mar2002d date 31mar2002d;run;D. data march; set sasdata.sales; where date 50000;run;correct_answer = A SAS Warehouse Architect ConceptsItem 1A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements. According to The Data Warehouse Lifecycle Toolkit by Ralph Kimball, which of the following should be included on the agenda? A. number of users B. routine reporting C. database design D. corporate objectives correct_answer = B Item 2According to the SAS Rapid Warehouse Methodology, which of the following occurs during the Final Test phase? I. system test II. integration test III. performance test IV. change management A. I and III only B. I, II, and III only C. I, III, and IV only D. I, II, III, and IV correct_answer = C Item 3A client has a customer-oriented data mart currently in place. A new data mart is being developed using customer information from the current data mart and a new customer-oriented data source. There is a requirement to provide rollups across data marts using this customer information. Which of the following meets this requirement? A. building a separate customer dimension for each data mart B. appending both customer sources and adding attributes identifying the source from where customer information was derived C. using a surrogate primary key similar to the production systems so that they may be reused or merged with other system keys D. building a conformed customer dimension by creating a master table of customers with a clean customer key and many well-maintained attributes correct_answer = A Item 4A warehouse architect has completed the logical design of a dimensional data model and is developing the corresponding physical model. Which of the following must be considered in the physical design of the dimensional data model? I. data volume II. usage patterns III. source data repository IV. warehouse data repository A. I and II only B. I and IV only C. I, II, and IV D. II, III, and IV correct_answer = C Item 5A large data warehouse source extract requires table joins from a live relational database management system (RDBMS) transactional system. Which of the following are possible negative effects of the above action? I. two phase commit locking II. blocking transaction commits III. exhausting temporary table space IV. degraded OLTP query performance A. I and II only B. III and IV only C. I, II, and III D. II, III, and IV correct_answer = D SAS Warehouse Development SpecialistItem 1Which of the following is most important when deciding on the data structure of a data mart? A. data access tools to be used B. XML data exchange standards C. metadata naming conventions D. extract, transform, and load (ETL) tool to be used correct_answer = A Item 2For a particular project, legal regulations require that only current data for an individual is stored in the CUSTOMER dimension of a data warehouse. According to The Data Warehouse Toolkit, by Ralph Kimball, which of the following slowly changing dimension techniques is the most appropriate for updating the CUSTOMER dimension? A. Type I B. Type II C. Type III D. Type IV correct_answer = A Item 3Within SAS/Warehouse Administrator, which of the following actions may be enabled by the metadata record such that a data source is visible in a data warehouse environment? I. Defining the extraction process II. Registering the location of a DBMS table III. Registering the location of a SAS table or view IV. Defining the logical and physical models represented A. I and II only B. III and IV only C. I, II and III only D. I, II, III and IV correct_answer = C Item 4Which of the following enable changed data capture from a source system with no date/time modification stamps? I. Use a program to read the database log files to detect changed records. II. Process a complete refresh from the source system into the data warehouse. III. Identify an effective date within the source data and utilize it to detect changes. IV. Compare the current warehouse data to the full source input and generate deltas. A. I and II only B. II and III only C. I and IV only D. III and IV only correct_answer = C Item 5Which of the following steps are executed during the system testing process? I. confirming that all test data loads were successful II. developing error handling procedures for failed tests III. ensuring that processes perform together as specified in the test plan IV. verifying that data quality and performance meet agreed upon specifications A. I and III only B. II and IV only C. I, II and IV only D. I, III and IV only correct_answer = D SAS Warehouse TechnologyItem 1In the SAS Management Console Metadata Manager plug-in, what are the valid values for the type of audit to perform on a metadata repository? A. Added, Deleted, Modified or All B. Added, Deleted, Updated or All C. Inserted, Deleted, Modified or All D. Inserted, Deleted, Updated or All correct_answer = B Item 2When using the Change Management feature of SAS ETL Studio, what type of data may be changed? A. ETL process source code deployed for scheduling B. Physical data in the tables of the warehouse C. Existing transformations in the ETL Process Library D. Metadata in the SAS metadata repository correct_answer = D Item 3Which one of the following scena