sasbaseprogrammingforsas-資料下載頁
2025-08-12 20:44本頁面
【導(dǎo)讀】datatest;inputname$age;cards;run;datanavigate;setemployees;ifjobcode='NA1'thenjobdesc='Navigator';run;procformat;valuescore1-50='Fail'51-100='Pass';run;format?A.procprintdata=;vartest;formattestscore;run;B.procprintdata=;vartest;formattestscore.;run;C.procprintdata=format=score;vartest;run;D.procprintdata=format=score.;vartest;run;dataloop;x=0;doindex=1to5by2;x=index;end;run;DATAstep?databine;setonetwo;run;procsql;on=;quit;A.B.C.D.datathree;mergeone(in=in1)two(in=in2);bynum;run;THREE?A.procsql;where=;quit;B.procsql;where=;quit;C.procsql;on=;quit;D.procsql;on=;quit;%lettype=RANCH;procsql;wherestyle="&type";quit;%lettype=CONDO;
【正文】 teps 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 Technology Item 1 In the SAS Management Console Metadata Manager plugin, 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 2 When 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 3 Which one of the following scenarios depicts when one must use the explicit SAS SQL PassThrough Facility instead of the SAS/ACCESS Libname engine in order to get a single RDBMS to do all the processing? A. retrieving only certain rows from an RDBMS table B. retrieving only certain columns from an RDBMS table C. retrieving only certain rows and columns from a join of RDBMS tables in the same schema D. retrieving only certain rows and columns from a join of RDBMS tables in different schemas correct_answer = D Item 4 What does the ARM acronym represent? A. Automated Response Management B. Application Response Management C. Automated Response Measurement D. Application Response Measurement correct_answer = D Item 5 In SAS ETL Studio, which of the following occur(s) when a job is deployed? I. Code is saved to a file. II. Job is scheduled to execute. III. Code is generated for the job. IV. Metadata about the deployed job is saved to the current metadata repository. A. I only B. III only C. I and II only D. I, III and IV only correct_answer =
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1