Sample Questions

Sample questions are provided for each exam to illustrate the various question types that may appear. For some credentials, a practice exam is also available.
The following sample questions are not inclusive and do not necessarily represent all of the types of questions that comprise the exams. The questions are not designed to assess an individual's readiness to take a certification exam.

Expand/Collapse AllExpand All Expand/Collapse AllCollapse All

SAS Base Programming
Question 1
The following program is submitted.
data WORK.TEST;
  input Name $ Age;
datalines;
John +35
;
run;
Which values are stored in the output data set?
  1. Name              Age
    ---------------------
    John               35 
  2. Name              Age
    ---------------------
    John              (missing value)
  3. Name              Age
    ---------------------
    (missing value)   (missing value)
  4. The DATA step fails execution due to data errors.
correct_answer = "A"
Question 2
Given the SAS data set WORK.ONE:
 Id  Char1
---  -----
182  M
190  N
250  O
720  P
and the SAS data set WORK.TWO:
 Id  Char2
---  -----
182  Q
623  R
720  S
The following program is submitted:
data WORK.BOTH;
   merge WORK.ONE WORK.TWO;
   by Id;
run;
What is the first observation in the SAS data set WORK.BOTH?
  1. Id  Char1  Char2
    ---  -----  -----
    182  M
    
  2. Id  Char1  Char2
    ---  -----  -----
    182         Q
    
  3. Id  Char1  Char2
    ---  -----  -----
    182  M      Q
    
  4. Id  Char1  Char2
    ---  -----  -----
    720  P      S
    
correct_answer = "C"
Question 3
Given the text file COLORS.TXT:
----+----1----+----2----+----
RED    ORANGE  YELLOW  GREEN
BLUE   INDIGO  PURPLE  VIOLET
CYAN   WHITE   FUCSIA  BLACK
GRAY   BROWN   PINK    MAGENTA
The following SAS program is submitted:
data WORK.COLORS;
  infile 'COLORS.TXT';
  input @1 Var1 $ @8 Var2 $ @;
  input @1 Var3 $ @8 Var4 $ @;
run;
What will the data set WORK.COLORS contain?
  1. Var1     Var2     Var3    Var4
    ------   ------   ------  ------
    RED      ORANGE   RED     ORANGE
    BLUE     INDIGO   BLUE    INDIGO
    CYAN     WHITE    CYAN    WHITE
    GRAY     BROWN    GRAY    BROWN
    
  2. Var1     Var2     Var3    Var4
    ------   ------   ------  ------
    RED      ORANGE   BLUE    INDIGO
    CYAN     WHITE    GRAY    BROWN
    
  3. Var1     Var2     Var3    Var4
    ------   ------   ------  ------
    RED      ORANGE   YELLOW  GREEN
    BLUE     INDIGO   PURPLE  VIOLET
    
  4. Var1     Var2     Var3    Var4
    ------   ------   ------  ------
    RED      ORANGE   YELLOW  GREEN
    BLUE     INDIGO   PURPLE  VIOLET
    CYAN     WHITE    FUCSIA  BLACK
    GRAY     BROWN    PINK    MAGENTA
    
correct_answer = "A"
Question 4
Given the SAS data set WORK.INPUT:
Var1     Var2
------   -------
A        one
A        two
B        three
C        four
A        five
The following SAS program is submitted:
data WORK.ONE WORK.TWO;
  set WORK.INPUT;
  if Var1='A' then output WORK.ONE;
  output;
run;
How many observations will be in data set WORK.ONE?

Enter your numeric answer in the space below.


correct_answer = "8"
Question 5
The following SAS program is submitted:
data WORK.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 WORK.LOOP?
  1. X = 3, Index = 5
  2. X = 5, Index = 5
  3. X = 5, Index = 6
  4. X = 5, Index = 7
correct_answer = "D"
Question 6
The 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?
  1. proc print data = SASUSER.CLASS;
       var test;
       format test score;
    run;
    
  2. proc print data = SASUSER.CLASS;
       var test;
       format test score.;
    run;
    
  3. proc print data = SASUSER.CLASS format = score;
       var test;
    run;
    
  4. proc print data = SASUSER.CLASS format = score.;
       var test;  
    run;
    
correct_answer = "B"
Question 7
This item will ask you to provide a line of missing code;

The SAS data set WORK.INPUT contains 10 observations, and includes the numeric variable Cost.

The following SAS program is submitted to accumulate the total value of Cost for the 10 observations:
data WORK.TOTAL;
  set WORK.INPUT;
  <insert code here>
  Total=Total+Cost;
run;
Which statement correctly completes the program?
  1. keep Total;
  2. retain Total 0;
  3. Total = 0;
  4. If _N_= 1 then Total = 0;
correct_answer = "B"
Question 8
This question will ask you to provide a line of missing code.

Given the following data set WORK.SALES:
SalesID  SalesJan  FebSales  MarchAmt
-------  --------  --------  --------
W6790          50       400       350
W7693          25       100       125
W1387           .       300       250
The following SAS program is submitted:
data WORK.QTR1;
   set WORK.SALES;
   array month{3} SalesJan FebSales MarchAmt;
   <insert code here>
run;
Which statement should be inserted to produce the following output?
SalesID  SalesJan  FebSales  MarchAmt  Qtr1
-------  --------  --------  --------  ----
W6790          50       400       350   800
W7693          25       100       125   250
W1387           .       300       250   550
  1. Qtr1 = sum(of month{_ALL_});
  2. Qtr1 = month{1} + month{2} + month{3};
  3. Qtr1 = sum(of month{*});
  4. Qtr1 = sum(of month{3});
correct_answer = "C"
Question 9
Given the following SAS error log
  44   data WORK.OUTPUT;
  45     set SASHELP.CLASS;
  46     BMI=(Weight*703)/Height**2;
  47     where bmi ge 20;
  ERROR: Variable bmi is not on file SASHELP.CLASS.
  48   run;
What change to the program will correct the error?
  1. Replace the WHERE statement with an IF statement
  2. Change the ** in the BMI formula to a single *
  3. Change bmi to BMI in the WHERE statement
  4. Add a (Keep=BMI) option to the SET statement
correct_answer = "A"
Question 10
The following SAS program is submitted:
data WORK.TEMP;
  Char1='0123456789';
  Char2=substr(Char1,3,4);
run;
What is the value of Char2?
  1. 23
  2. 34
  3. 345
  4. 2345
correct_answer = "D"


SAS Advanced Programming
Question 1
Given 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?
  1. []
  2. []
  3. []
  4. []
correct_answer = "D"
Question 2
Given 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?
  1. proc sql;
    create table three as
       select *
          from one full join two
          where one.num = two.num;
    quit;
    
  2. 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;
  3. proc sql;
    create table three as
       select one.num, char1, char2
          from one full join two
          on one.num = two.num;
    quit;
  4. 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"
Question 3
The 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?
  1. GET
  2. SYMGET
  3. %SYMGET
  4. &RETRIEVE
correct_answer = "B"
Question 4
The 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?
  1. proc print data = sasdata.sales;
       by date;
    run;
  2. proc print data = sasdata.sales;
       where month(date) = 3;
    run;
  3. data march;
       set sasdata.sales;
       if '01mar2002'd < date < '31mar2002'd;
    run;
  4. data march;
       set sasdata.sales;
       where date < '31mar2002'd or revenue > 50000;
    run;
correct_answer = "A"
Question 5
Given the following SQL procedure output:
TablePhysical Obs% Deleted
EMPLOYEE_ADDRESSES4245.0%
EMPLOYEE_PAYROLL4245.0%
Which SQL query will produce a report for tables in the ORION library which have had at least 5% of their physical rows deleted, as shown above?
  1. select MEMNAME 'Table', NOBS 'Physical Obs'
         , DELOBS/NOBS '% Deleted' format=percent6.1
       from dictionary.tables
       where LIBNAME='ORION' AND DELOBS/NOBS >= .05;
  2. select Table_Name, Num_Rows 'Physical Obs'
         , Deleted_Rows/Num_Rows '% Deleted' format=percent6.1
       from dictionary.DBA_TABLES
       where TABLESPACE_NAME='ORION'
         AND Deleted_Rows/Num_Rows >= .05;
  3. select MEMNAME 'Table', NLOBS 'Physical Obs'
         , DELOBS/NLOBS LABEL='% Deleted' format=percent6.1
       from dictionary.tables
       where LIBNAME='ORION' AND DELOBS/NLOBS >= .05;
  4. select MEMNAME 'Table', NOBS 'Physical Obs'
         , DELOBS/NOBS LABEL='% Deleted' format=percent6.1
       from dictionary.members
       where LIBNAME='ORION' AND DELOBS/NOBS >= .05;
correct_answer = "A"
Question 6
The following SAS program is submitted:
options
;
%abc(work.look,Hello,There);

In the text box above, complete the options statement that will produce the following log messages:
M*****(ABC):   title1 "Hello" ;
M*****(ABC):   title2 "There" ;
M*****(ABC):   proc print data=work.look ;
M*****(ABC):   run ;
correct_answer = "mprint"
Question 7
The following SAS program is submitted:
%macro mysum(n);
  %if &n > 1 %then  %eval(&n + %mysum(%eval(&n-1)));
  %else &n;
%mend;

%put %mysum(4);
Which output is written to the log?
  1. 10
  2. 4+3+2+1
  3. 7
  4. A character operand was found in the %EVAL function or %IF condition where a numeric operand is required.
correct_answer = "A"
Question 8
A local permanent data set has the following characteristics:
  • 80 character variables, length 200, storing 28 bytes of non-repeating characters
  • 120 numeric variables, length 8, 14 digits
  • 4000 observations
What is the best way to reduce the storage size of this data set?
  1. Compress the data set with character compression
  2. Reduce length of character variables to 28 bytes
  3. Compress the data set with binary compression
  4. Reduce length of character variables to 6 bytes
correct_answer = "B"
Question 9
The following program is submitted to check the variables Xa, Xb, and Xc in the SASUSER.LOOK data set:
data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
   set SASUSER.LOOK(keep=Xa Xb Xc);
   length _Check_ $ 10 ;
   if Xa=. then _check_=trim(_Check_)!!" Xa" ;
   if Xb=. then _check_=trim(_Check_)!!" Xb" ;
   if Xc=. then _check_=trim(_Check_)!!" Xc" ;
   put Xa= Xb= Xc= _check_= ;
run ;
When is the PUT statement executed?
  1. when the code is submitted
  2. only when the WORK.BAD_DATA view is used
  3. both when the code is submitted and the view is used
  4. never, the use of _null_ in a view is a syntax error
correct_answer = "B"


Clinical Trials Programming
Question 1
What is the main focus of Good Clinical Practices (GCP)?
  1. harmonized data collection
  2. standard analysis practices
  3. protection of subjects
  4. standard monitoring practices
correct_answer = "C"
Question 2
Vital Signs are a component of which SDTM class?
  1. Findings
  2. Interventions
  3. Events
  4. Special Purpose
correct_answer = "A"
Question 3
Which option in the PROC EXPORT procedure overwrites an existing file?
  1. NEW
  2. OVERWRITE
  3. REPLACE
  4. KEEP
correct_answer = "C"
Question 4
Given the following data set WORK.DEMO:
   PTID       Sex    Age    Height    Weight
 689574     M      15     80.0      115.5
 423698     F      14     65.5       90.0
 758964     F      12     60.3       87.0
 653347     F      14     62.8       98.5
 493847     M      14     63.5      102.5
 500029     M      12     57.3       83.0
 513842     F      12     59.8       84.5
 515151     F      15     62.5      112.5
 522396     M      13     62.5       84.0
 534787     M      12     59.0       99.5
 875642     F      11     51.3       50.5
 879653     F      15     75.3      105.0
 542369     F      12     56.3       77.0
 698754     F      11     50.5       70.0
 656423     M      16     72.0      150.0
 785412     M      12     67.8      121.0
 785698     M      16     72.0      110.0
 763284     M      11     57.5       85.0
 968743     M      14     60.5       85.0
 457826     M      18     74.0      165.0
The following SAS program is submitted:
  proc print data=WORK.DEMO(firstobs=5 obs=10); 
    where Sex='M'; 
  run;
How many observations will be displayed?
  1. 4
  2. 6
  3. 7
  4. 8
correct_answer = "B"
Question 5
Given the following partial data set:
  SUBJID   SAF   ITT   OTH
    101     1     .     1
    103     1     1     1
    106     1     1     1
    107     1     .     1
The following SAS program is submitted:
  proc format;
    value stdypfmt
          1="Safety"
          2="Intent-to-Treat"
          3="Other";
  run;

  data test;
    set temp (keep=SUBJID ITT SAF OTH );
    by subjid;
    length STDYPOP $200;
    array pop{*} SAF ITT OTH ;
    do i=1 to 3;
      if STDYPOP="" and pop{i}=1 then STDYPOP=put(i, stdypfmt.);
      else if STDYPOP^="" and pop{i}=1 then STDYPOP = trim(STDYPOP)||"/"||put(i, stdypfmt.);
    end;
  run;
What is the value of STDYPOP for SUBJID=107?

correct_answer = "Safety/Other"

Question 6
This question will ask you to provide a line of missing code.

Given the data set WORK.STUDYDATA with the following variable list:
  #    Variable    Type    Len    Label
  2    DAY         Char      8    Study Day
  3    DIABP       Num       8    Diastolic Blood Pressure
  1    TRT         Char      8    Treatment
The following SAS program is submitted:
  proc means data=WORK.STUDYDATA noprint;
    <insert code here>
    class TRT DAY;
    var DIABP;
    output out=WORK.DIAOUT mean=meandp;
  run;
WORK.DIAOUT should contain:
  • the mean diastolic blood pressure values for every day by treatment group
  • the overall mean diastolic blood pressure for each treatment group
Which statement correctly completes the program to meet these requirements?
  1. where trt or trt*day;
  2. types trt trt*day;
  3. by trt day;
  4. id trt day;
correct_answer = "B"
Question 7
The following SAS program is submitted:
   %let member1=Demog; 
   %let member2=Adverse; 
   %let Root=member;
   %let Suffix=2; 
   %put &&&Root&Suffix; 
What is written to the SAS log?
  1. &member2
  2. Adverse
  3. &&&Root&Suffix
  4. WARNING: Apparent symbolic reference ROOT2 not resolved.
correct_answer = "B"
Question 8
This question will ask you to provide a line of missing code.

The following SAS program is submitted:
  proc format ;
    value dayfmt  1='Sunday'
                  2='Monday'
                  3='Tuesday'
                  4='Wednesday'
                  5='Thursday'
                  6='Friday'
                  7='Saturday' ;
  run ;

  proc report data=diary ;
    column subject day var1 var2 ;
    <insert code here>
  run ;
In the DIARY data set, the format DAYFMT is assigned to the variable DAY. Which statement will cause variable DAY to be printed in its unformatted order?
  1. define day / order 'Day' ;
  2. define day / order order=data 'Day' ;
  3. define day / order noprint 'Day' ;
  4. define day / order order=internal 'Day' ;
correct_answer = "D"
Question 9
You are using SAS software to create reports that will be output in a Rich Text Format so that it may be read by Microsoft Word. The report will span multiple pages and you want to display a '(Continued)' text at the end of each page when a table spans multiple pages.

Which statement can you add to the SAS program to ensure the inclusion of the '(Continued)' text?
  1. ods rtf file='report.rtf';
  2. ods tagsets.rtf file='report.rtf';
  3. ods tagsets.rtf file='report.rtf' break='Continued';
  4. ods file open='report.rtf' type=rtf break='(Continued)';
correct_answer = "B"
Question 10
What is the primary purpose of programming validation?
  1. Ensure that the output from both the original program and the validation program match.
  2. Efficiently ensure any logic errors are discovered early in the programming process.
  3. Justify the means used to accomplish the outcome of a program and ensure its accurate representation of the original data.
  4. Document all specifications pertaining to programmed output and ensure all were reviewed during the programming process.
correct_answer = "C"


SAS Advanced Predictive Modeling
Question 1
What is a linear Perceptron?
  1. A linear Perceptron is a general linear model.
  2. A linear Perceptron is a generalized linear model.
  3. A linear Perceptron is a non-parametric model.
  4. A linear Perceptron is a nonlinear model.
correct_answer = "B"
Question 2
Consider a Generalized Additive Neural Network (GANN) with 3 continuous inputs and 2 hidden nodes for each input.

How many parameters do you need to estimate when training the neural network?
  1. 19
  2. 21
  3. 22
  4. 25
correct_answer = "C"
Question 3
A predictive model uses a data set that has several variables with missing values.

What two problems can arise with this model? (Choose two.)
  1. The model will likely be overfit.
  2. There will be a high rate of collinearity among input variables.
  3. Fewer observations will be used in the model building process.
  4. New cases with missing values on input variables cannot be scored without extra data processing.
correct_answer = "C & D"
Question 4
When mean imputation is performed on data after the data is partitioned for honest assessment, what is the most appropriate method for handling the mean imputation?
  1. The sample means from the validation data set are applied to the training and test data sets.
  2. The sample means from the training data set are applied to the validation and test data sets.
  3. The sample means from the test data set are applied to the training and validation data sets.
  4. The sample means from each partition of the data are applied to their own partition.
correct_answer = "B"
Question 5
Refer to the exhibit:

[]

For the ROC curve shown, what is the meaning of the area under the curve?
  1. percent concordant plus percent tied
  2. percent concordant plus (.5 * percent tied)
  3. percent concordant plus (.5 * percent discordant)
  4. percent discordant plus percent tied
correct_answer = "B"
Question 6
Refer to the Eigenvalue plot from SAS Enterprise Miner shown below.
[]
According to the Kaiser-Guttman method, how many principal components should be retained?
  1. 6
  2. 4
  3. 10
  4. 1
correct_answer = "B"
Question 7
Refer to the fit summary from SAS Visual Statistics in the exhibit below.
[]
What can be concluded from the fit summary?
  1. Customer Value Level is not a significant predictor in this model.
  2. Customer Value Level C has no important variables associated with it.
  3. Average Sales is a significant predictor when Customer Value Level = E.
  4. Average Sales is an important predictor when Customer Value Level = C.
correct_answer = "C"
Question 8
What is the maximum number of response variables that SAS Visual Statistics allows for a decision tree?

Enter your numeric answer in the space below.


correct_answer = "1"
Question 9
Which statement is true for negative binomial and Poisson regression models?
  1. Poisson regression models are used for count data, and negative binomial models are used for binary responses.
  2. The canonical link function for Poisson regression is the log, while for negative binomial it is the logit.
  3. Negative binomial models accommodate negative integers while Poisson regression does not.
  4. Poisson regression is a special case of negative binomial regression.
correct_answer = "D"
Question 10
Which software does the SAS Enterprise Miner Open Source Integration node use to execute R programs?
  1. SAS/IML
  2. SAS/STAT
  3. SAS/ACCESS
  4. SAS/OR
correct_answer = "A"


SAS Text Analytics, Time Series, Experimentation and Optimization
Question 1
After creating a data source within the SAS Code node, which macro is used to modify the metadata of the data source (specifically changing the roles and levels for each variable)?
  1. %EM_REGISTER
  2. %EM_DECDATA
  3. %EM_PROPERTY
  4. %EM_METACHANGE
correct_answer = "D"
Question 2
What is a primary value of text mining as applied to forensic linguistics analysis?
  1. Determining the native language of a suspect can help identify where a suspect may reside.
  2. Word frequencies of written or spoken communication can help discriminate between suspects.
  3. The usage of certain emotion-based nouns, verbs, and adjectives indicate criminal pathology.
  4. Determines if the written or spoken communication is the subject's second language.
correct_answer = "B"
Question 3
In the Text Topic node, the Singular Value Decomposition (SVD) dimensions are rotated. What is the purpose of this rotation?
  1. To interpret each dimension with a set of terms.
  2. To determine the number of topics that are discovered.
  3. To ensure the topics are relevant to your interests.
  4. To avoid producing topics that are too similar
correct_answer = "A"
Question 4
What is an example of time series forecasting?
  1. A dried fruit company sends out marketing postcards and models who will respond.
  2. A glue manufacturer wants to know how long it will take for its glue to dry.
  3. A fire department wants to know how many fires it will likely need to fight during the holidays, so that it can staff accordingly.
  4. A hospital wants to know how long its patients will survive after open heart surgery so that adverse effects can be caught early.
correct_answer = "C"
Question 5
Which measure assesses predictive accuracy?
  1. AIC
  2. SBC
  3. MAE
  4. Ljung-Box
correct_answer = "C"
Question 6
What distinguishes a deterministic linear trend from other local linear trends?
  1. A deterministic linear trend is always linear; other local linear trends are only linear over certain intervals.
  2. A deterministic linear trend does not contain a seasonal component; other local linear trends do contain a seasonal component.
  3. A deterministic trend has a predetermined slope; other local linear trends do not have a pre-determined slope.
  4. A deterministic linear trend shows the same slope at all time periods; other local linear trends do not show the same slope at all time periods.
correct_answer = "D"
Question 7
What is desirable in experimental design?
  1. Replication for individual factors.
  2. Removal of nuisance terms from the model.
  3. Randomization across covariates levels.
  4. More levels for each factor.
correct_answer = "A"
Question 8
Refer to the exhibit below from an Incremental Response node from SAS Enterprise Miner.

[]

What can be inferred from the properties above?

  1. The expected revenue for individual customers is $10.
  2. The expected revenue for individual customers is $9.50.
  3. The expected revenue for individual customers is the estimated outcome from the model.
  4. The input data set contains an expected revenue variable, with values for individual customers.
correct_answer = "C"
Question 9
You have just built an optimization model with two constraints, Con1 and Con2. Below is partial code and output.
solve with LP;
print Con1.dual Con2.dual;

Con1.DUALCon2.DUAL
80

A binding constraint is a constraint that is equal to its limit. Which statement is true regarding Con1 and Con2?
  1. Both Con1 and Con2 are binding constraints.
  2. Both Con1 and Con2 are non-binding constraints.
  3. Con1 is a non-binding constraint and Con2 is a binding constraint.
  4. Con1 is a binding constraint and Con2 is a non-binding constraint.
correct_answer = "D"
Question 10
Why are iterative search algorithms used for solving non-linear programming (NLP) problems?
  1. NLP are not convex.
  2. A unique, optimal solution is not guaranteed.
  3. The gradient of the objective is un-bounded.
  4. NLP have only one local optimum.
correct_answer = "B"


Predictive Modeling Using SAS Enterprise Miner
Question 1

Open the diagram labeled Practice A within the project labeled Practice A. Perform the following in SAS Enterprise Miner:
  1. Set the Clustering method to Average.
  2. Run the Cluster node.
Use this project to answer the next two questions:

What is the Importance statistic for MTGBal (Mortgage Balance)?
  1. 0.32959
  2. 0.42541
  3. 0.42667
  4. 1.000000
correct_answer = "C" You must change the clustering method to average and run the cluster node first. Select view results and look in the output window and view the Variable Importance results.

What is the Cubic Clustering Criterion statistic for this clustering?
  1. 5.00
  2. 14.69
  3. 5862.76
  4. 67409.93
correct_answer = "B" Run the diagram flow and view the results. From the results window, select View -> Summary Statistics -> CCC Plot and mouse over where the data point and the line intersect. This will display the CCC statistic.
Question 2
  1. Create a project named Insurance, with a diagram named Explore.
  2. Create the data source, DEVELOP, in SAS Enterprise Miner. DEVELOP is in the directory c:\workshop\Practice.
  3. Set the role of all variables to Input, with the exception of the Target variable, Ins (1= has insurance, 0= does not have insurance).
  4. Set the measurement level for the Target variable, Ins, to Binary.
  5. Ensure that Branch and Res are the only variables with the measurement level of Nominal.
  6. All other variables should be set to Interval or Binary.
  7. Make sure that the default sampling method is random and that the seed is 12345.
Use this project to answer the next questions. (Note: only 2 of 7 questions are displayed for this example)

The variable Branch has how many levels?
  1. 8
  2. 12
  3. 19
  4. 47
correct_answer = "C" This information can be obtained by viewing the PROC FREQ output.

What is the mean credit card balance (CCBal) of the customers with a variable annuity?
  1. $0.00
  2. $8,711.65
  3. $9,586.55
  4. $11,142.45
correct_answer = "D" You can use a Stat Explore Node and view the output for the Descriptive Statistics for CCBal by level of the target variable.


SAS Statistical Business Analysis
Question 1
A financial analyst wants to know whether assets in portfolio A are more risky (have higher variance) than those in portfolio B. The analyst computes the annual returns (or percent changes) for assets within each of the two groups and obtains the following output from the GLM procedure:

[]

Which conclusion is supported by the output?
  1. Assets in portfolio A are significantly more risky than assets in portfolio B.
  2. Assets in portfolio B are significantly more risky than assets in portfolio A.
  3. The portfolios differ significantly with respect to risk.
  4. The portfolios do not differ significantly with respect to risk.
correct_answer = "C"
Question 2
An analyst has determined that there exists a significant effect due to region. The analyst needs to make pairwise comparisons of all eight regions and wants to control the experimentwise error rate.

Which GLM procedure statement would provide the correct output?
  1. lsmeans Region / pdiff=all adjust=dunnett;
  2. lsmeans Region / pdiff=all adjust=tukey;
  3. lsmeans Region / pdiff=all adjust=lsd;
  4. lsmeans Region / pdiff=all adjust=none;
correct_answer = "B"
Question 3
A linear model has the following characteristics:
  • a dependent variable (y)
  • one continuous predictor variables (x1) including a quadratic term (x12)
  • one categorical predictor variable (c1 with 3 levels)
  • one interaction term (c1 by x1)
Which SAS program fits this model?
  1. proc glm data=SASUSER.MLR;
       class c1;
       model y = c1 x1 x1sq c1byx1  /solution;
    run;
  2. proc reg data=SASUSER.MLR;
       model y = c1 x1 x1sq c1byx1  /solution;
    run;
  3. proc glm data=SASUSER.MLR;
       class c1;
       model y = c1 x1 x1*x1 c1*x1  /solution;
    run;
  4. proc reg data=SASUSER.MLR;
       model y = c1 x1 x1*x1 c1*x1;
    run;
correct_answer = "C"
Question 4
Refer to the REG procedure output:

[]

What is the most important predictor of the response variable?
  1. intercept
  2. overhead
  3. scrap
  4. training
correct_answer = "B"
Question 5
Which statement is an assumption of logistic regression?
  1. The sample size is greater than 100.
  2. The logit is a linear function of the predictors.
  3. The predictor variables are not correlated.
  4. The errors are normally distributed.
correct_answer = "B"
Question 6
When selecting variables or effects using SELECTION=BACKWARD in the LOGISTIC procedure, the business analyst's model selection terminated at Step 3.

What happened between Step 1 and Step 2?
  1. DF increased.
  2. AIC increased.
  3. Pr > Chisq increased.
  4. - 2 Log L increased.
correct_answer = "D"
Question 7
A predictive model uses a data set that has several variables with missing values.

What two problems can arise with this model? (Choose two.)
  1. The model will likely be overfit.
  2. There will be a high rate of collinearity among input variables.
  3. Fewer observations will be used in the model building process.
  4. New cases with missing values on input variables cannot be scored without extra data processing.
correct_answer = "C & D"
Question 8
An analyst is screening for irrelevant variables by estimating strength of association between each input and the target variable. The analyst is using Spearman correlation and Hoeffding's D statistics in the CORR procedure.

What would likely cause some inputs to have a large Hoeffding and a near zero Spearman statistic?
  1. nonmonotonic association between the variables
  2. linear association between the variables
  3. monotonic association between the variables
  4. no association between the variables
correct_answer = "A"
Question 9
When mean imputation is performed on data after the data is partitioned for honest assessment, what is the most appropriate method for handling the mean imputation?
  1. The sample means from the validation data set are applied to the training and test data sets.
  2. The sample means from the training data set are applied to the validation and test data sets.
  3. The sample means from the test data set are applied to the training and validation data sets.
  4. The sample means from each partition of the data are applied to their own partition.
correct_answer = "B"
Question 10
Refer to the exhibit:

[]

For the ROC curve shown, what is the meaning of the area under the curve?
  1. percent concordant plus percent tied
  2. percent concordant plus (.5 * percent tied)
  3. percent concordant plus (.5 * percent discordant)
  4. percent discordant plus percent tied
correct_answer = "B"


SAS BI Content Development
Question 1
When opening a registered SAS data file into a Microsoft Excel Worksheet, a user has the option to sort the data.

Which application performs the sort and where does the sort occur?
  1. SAS performs the sort on the server.
  2. SAS performs the sort on the local machine.
  3. Excel performs the sort on the server.
  4. Excel performs the sort on the local machine.
correct_answer = "A"
Question 2
When can you add a stored process as a data source to an information map?
  1. anytime
  2. when at least one table is selected as a data source
  3. when at least one OLAP cube is selected as a data source
  4. once an application server has been selected
correct_answer = "B"
Question 3
Refer to the exhibit.
[]
A SAS.IdentityGroups filter has been created in SAS Information Map Studio. There is a data item called "Group" that contains different metadata groups.

If the "Group" filter is applied to the map, how will it affect the data?
  1. All rows will be returned for any group that the user is a member of.
  2. Only rows that belong to the first group are returned.
  3. All rows will be returned for PUBLIC group only.
  4. All rows matching the group identity login are returned.
correct_answer = "A"
Question 4
A SAS data set is used as a data source for a SAS BI Dashboard data model.

Which type of code do you write to query the data?
  1. DATA Step
  2. PROC SQL
  3. a SQL/JDBC query
  4. MDX
correct_answer = "C"
Question 5
Refer to the exhibit.
[]
What causes this error message when executing a stored process?
  1. Stored process code cannot be a .TXT file.
  2. The stored process server is not running.
  3. The file that contains the stored process code is not in the specified location.
  4. An administrator deleted the stored process from the metadata.
correct_answer = "C"
Question 6
In a stored process, when using a range prompt named DateRange, which macro variables would you use in your SAS code?
  1. DateRange_START and DateRange_FINISH
  2. DateRange_BEGIN and DateRange_END
  3. DateRange_MIN and DateRange_MAX
  4. DateRange0 and DateRange1
correct_answer = "C"
Question 7
Upon initial install, all of the capabilities in the 'Web Report Studio: Report Creation' role are also included in which role?
  1. Web Report Studio: Report Viewing
  2. Web Report Studio: Advanced
  3. Web Report Studio: Content Management
  4. Web Report Studio: Administration
correct_answer = "B"
Question 8
A content developer would like to create a group of cascading prompts to use in multiple reports without recreating the prompts for each report.

What features of the prompt framework must the developer use?
  1. Cannot create shared cascading prompts for use in multiple reports.
  2. Dynamic Prompts and Shared Prompts
  3. Cascading Prompts and Standard Groups
  4. Cascading Prompts, Standard Groups, and Shared Prompts
correct_answer = "D"
Question 9
A SAS Information Map with a SAS OLAP Cube as a data source can be built from which of the following?
  1. multiple SAS OLAP Cubes
  2. a SAS OLAP Cube and a stored process
  3. one table joined with one SAS OLAP Cube
  4. one SAS OLAP Cube only
correct_answer = "D"
Question 10
Which statement is true regarding connection profiles used with the SAS platform applications?
  1. Each SAS platform application must have its own connection profile.
  2. Connection profiles are stored on the server machine.
  3. Connection profiles are stored on the machine where the SAS application is installed.
  4. All SAS platform applications share one connection profile.
correct_answer = "C"


SAS Visual Analytics Exploration and Design
Question 1
When using SAS Visual Analytics Explorer, what is the difference between importing a SAS data set on a server versus importing a local SAS data set?
  1. When importing from a server you have the ability to change column attributes, you cannot do this when importing a local SAS data set.
  2. When importing a local SAS data set you can change column attributes, you cannot do this when importing from a server.
  3. When importing from a server the SAS data set must be registered in metadata.
  4. When importing a local SAS data set you can preview the columns and rows of data.
correct_answer = "D"
Question 2
Refer to the exhibit below from SAS Visual Analytics Designer.

[]

Why is the value for Sales lower in the treemap than in the bar chart?
  1. The aggregation for Sales was changed in the treemap.
  2. A rank was established on the treemap to only show the top eight values.
  3. A data source filter was applied to the treemap.
  4. The measure in the treemap is Sales and the measure in the bar chart is Sales (millions).
correct_answer = "A"
Question 3
In SAS Visual Analytics Explorer, when a date data item is dragged onto an Automatic Chart visualization either a bar chart or a line chart will be created. What determines the type of chart created?
  1. The format applied to the date data item determines the type of chart displayed.
  2. A bar chart is created if the Model property of the data item is set to Discrete, and a line chart is created if the Model property is set to Continuous.
  3. The properties associated with the automatic chart determines the type of chart displayed.
  4. A line chart is created if the Model property of the data item is set to Discrete, a bar chart is created if the Model property is set to Continuous.
correct_answer = "B"
Question 4
Using SAS Visual Analytics Explorer, a content developer would like to examine the relationship between two measures with high cardinality. Which visualization should the developer use?
  1. Scatter Plot
  2. Heat Map
  3. Scatter Plot Matrix
  4. Treemap
correct_answer = "B"
Question 5
The content developer wants to email an exploration from SAS Visual Analytics Explorer to a coworker. Which statement is true?
  1. The From email address is not required.
  2. The exploration will be added as an attachment in the email.
  3. Explorations cannot be emailed from Explorer.
  4. The person who receives the email must log on to view the exploration.
correct_answer = "D"
Question 6
A content developer creates a display rule for a crosstab. What changes can the display rule apply to the crosstab?
  1. The crosstab can be hidden if no results are returned by the display rule.
  2. The brightness of the crosstab can be changed.
  3. Individual cells can be color highlighted.
  4. Rows can be color highlighted.
correct_answer = "C"
Question 7
Refer to the bar chart from SAS Visual Analytics Designer.

[]

Philip is 16 years old. Barbara is 13 years old. What happens to the graph above if the content developer creates a Display Rule to set the graph to red if "Age > 14"?
  1. The Philip bar would turn red.
  2. None of the bars change.
  3. On the graph only the Philip bar displays.
  4. Age replaces the Weight measure.
correct_answer = "A"
Question 8
Refer to the exhibit below.

[]

A content developer has a created a report that contains the Prompt Container pictured above. Which set of properties matches what is shown in the Prompt Container?
  1. []
  2. []
  3. []
  4. []
correct_answer = "A"
Question 9
Refer to the exhibit below.

[]

A content developer has created the report that appears in the exhibit. Which interaction has been created between the Bar Chart and Pie Chart?
  1. Filter interaction
  2. Brush interaction
  3. Info Window link
  4. Brush link
correct_answer = "B"
Question 10
In SAS Visual Analytics Designer, which sharing option would require a report job to be created?
  1. E-mail option
  2. Batch E-mail option
  3. Distribute Reports option
  4. Report Alerts option
correct_answer = "C"


SAS Big Data Preparation, Statistics, and Visual Exploration
Question 1
How do you access the Data Management Studio Options window?
  1. from the Tools menu
  2. from the Administration riser bar
  3. from the Information riser bar
  4. in the app.cfg file in the DataFlux Data Management Studio installation folder
correct_answer = "A"
Question 2
How are the Field name analysis and Sample data analysis methods similar?
  1. They both utilize a match definition from the Quality Knowledge Base.
  2. They both require the same identification analysis definition from the Quality Knowledge Base.
  3. They both utilize an identification analysis definition from the Quality Knowledge Base.
  4. They both require the same match definition from the Quality Knowledge Base.
correct_answer = "C"
Question 3
A sample of data has been clustered and found to contain many multi-row clusters. To construct a "best" record for each multi-row cluster, you need to select information from other records within a cluster. Which type of rule allows you to perform this task?
  1. Clustering rules
  2. Record rules
  3. Business rules
  4. Field rules
correct_answer = "D"
Question 4
Which option in the properties of a Clustering node allows you to identify which clustering condition was satisfied?
  1. Condition matched field prefix
  2. Cluster condition field matched
  3. Cluster condition field count
  4. Cluster condition met field
correct_answer = "A"
Question 5
A Data Quality Steward creates these items for the Supplier repository:
  • A row-based business rule called Monitor for Nulls
  • A set-based business rule called Percent of Verified Addresses
  • A group-based rule called Low Product Count
  • A task based on the row-based, set-based, and group-based rules called Monitor Supplier Data
Which one of these can the Data Quality Steward apply in an Execute Business Rule node in a data job?
  1. set-based business rule called Percent of Verified Addresses
  2. row-based business rule called Monitor for Nulls
  3. group-based rule called Low Product Count
  4. task based on the row-based, set-based, and group-based rules called Monitor Supplier Data
correct_answer = "B"
Question 6
A financial analyst wants to know whether assets in portfolio A are more risky (have higher variance) than those in portfolio B. The analyst computes the annual returns (or percent changes) for assets within each of the two groups and obtains the following output from the GLM procedure:

[]

Which conclusion is supported by the output?
  1. Assets in portfolio A are significantly more risky than assets in portfolio B.
  2. Assets in portfolio B are significantly more risky than assets in portfolio A.
  3. The portfolios differ significantly with respect to risk.
  4. The portfolios do not differ significantly with respect to risk.
correct_answer = "C"
Question 7
A linear model has the following characteristics:
  • a dependent variable (y)
  • one continuous predictor variables (x1) including a quadratic term (x12)
  • one categorical predictor variable (c1 with 3 levels)
  • one interaction term (c1 by x1)
Which SAS program fits this model?
  1. proc glm data=SASUSER.MLR;
       class c1;
       model y = c1 x1 x1sq c1byx1  /solution;
    run;
  2. proc reg data=SASUSER.MLR;
       model y = c1 x1 x1sq c1byx1  /solution;
    run;
  3. proc glm data=SASUSER.MLR;
       class c1;
       model y = c1 x1 x1*x1 c1*x1  /solution;
    run;
  4. proc reg data=SASUSER.MLR;
       model y = c1 x1 x1*x1 c1*x1;
    run;
correct_answer = "C"
Question 8
When selecting variables or effects using SELECTION=BACKWARD in the LOGISTIC procedure, the business analyst's model selection terminated at Step 3.

What happened between Step 1 and Step 2?
  1. DF increased.
  2. AIC increased.
  3. Pr > Chisq increased.
  4. - 2 Log L increased.
correct_answer = "D"
Question 9
In SAS Visual Analytics Explorer, when a date data item is dragged onto an Automatic Chart visualization either a bar chart or a line chart will be created. What determines the type of chart created?
  1. The format applied to the date data item determines the type of chart displayed.
  2. A bar chart is created if the Model property of the data item is set to Discrete, and a line chart is created if the Model property is set to Continuous.
  3. The properties associated with the automatic chart determines the type of chart displayed.
  4. A line chart is created if the Model property of the data item is set to Discrete, a bar chart is created if the Model property is set to Continuous.
correct_answer = "B"
Question 10
Using SAS Visual Analytics Explorer, a content developer would like to examine the relationship between two measures with high cardinality. Which visualization should the developer use?
  1. Scatter Plot
  2. Heat Map
  3. Scatter Plot Matrix
  4. Treemap
correct_answer = "B"


SAS Big Data Programming and Loading
Question 1
In the example below, the input data set is a Hive table accessed using a SAS/ACCESS to Hadoop LIBNAME statement.
proc freq data=hivelib.myhivetable;
  class month;
  by year;
run;
Which statement is true about this program?
  1. The procedure will fail unless the table HIVELIB.MYHIVETABLE is already stored ordered by YEAR.
  2. SAS will generate a HiveQL query to return the data to SAS ordered by YEAR so that the procedure receives the data ordered by YEAR as required.
  3. BY statements do not require the data be received by the procedure in any specific order.
  4. BY statements are not supported for Hive tables because it is not possible to order data that is distributed on different nodes of the Hadoop cluster.
correct_answer = "B"
Question 2
When working with data stored in Hadoop, which SAS function is NOT passed to Hive by default?
  1. DATE
  2. HOUR
  3. VAR
  4. UPCASE
correct_answer = "A"
Question 3
What is an advantage of using a LIBNAME statement to interact with your Hadoop cluster?
  1. It enables you to submit user-written HiveQL code to Hive.
  2. The GENERATE_PIG_CODE= option enables you to bypass Hive and generate Pig Latin code.
  3. It enables some SAS procedures to push processing into Hive.
  4. It ensures that Hive will handle all processing.
correct_answer = "C"
Question 4
Refer to the log message shown below:
58         proc ds2;
59          data test;
60           dcl double date;
61            method run();
62              set work.one;
63              mm=2;
64            end;
65            enddata;
66           run;
ERROR: Compilation error.
ERROR: Parse encountered type when expecting identifier.
ERROR: Parse failed on line 60: dcl double  >>> date <<< ;
NOTE: PROC DS2 has set option NOEXEC and will continue to prepare statements.
67           quit;
Which of the following changes will fix the errors shown in the log?
  1. Replace line 60 with dcl double 'date';
  2. Replace line 60 with dcl double "date";
  3. Replace line 60 with dcl string date;
  4. Replace line 60 with dcl double 'date'n;
correct_answer = "B"
Question 5
Which statement creates a temporary array within DS2?
  1. vararray double a[2];
  2. vararray double a(2);
  3. array a(2) s1-s2;
  4. dcl double a[2];
correct_answer = "D"
Question 6
The following SAS program is submitted:
proc ds2;
data work.sasorders;
  dcl timestamp order_timestamp;
 dcl double order_datetime;
 method run();
  set orders;
  order_timestamp = to_timestamp(order_datetime);
 end;
enddata;
run;
quit;
What happens when the program is executed?
  1. -- The variable order_timestamp is created and processed as an ANSI timestamp value in the DS2 program.
    -- The order_timestamp value is converted to a SAS datetime when it is written to the output SAS data set.
  2. -- The variable order_timestamp is created and processed as an ANSI timestamp value in the DS2 program.
    -- The output data set stores the values as a SAS timestamp value.
  3. -- The variable order_timestamp is converted to a SAS time value.
    -- The output data set stores this as the number of seconds since midnight.
  4. -- The program does not execute because order_datetime is a SAS datetime value.
correct_answer = "A"
Question 7
Which operator is NOT a diagnostic operator for testing a Pig program?
  1. DUMP
  2. ILLUSTRATE
  3. EXPLAIN
  4. SPLIT
correct_answer = "D"
Question 8
Web server logs are written in an HDFS directory. The following lines indicate the format and an example of the comma-separated values for one line in the log file.
# IP address, timestamp, request, status, size
192.168.12.41,24/Nov/2015:10:09:58 -0500, "GET /services/config.xml HTTP/1.1",200,816
Which CREATE TABLE statement enables a Hive query to access each of the fields?
  1. create external table weblogs (ip string, dt string, req string, status int, sz string) row format delimited fields terminated by ',' location '/data/weblogs';
  2. create external table weblogs (ip string, dt string, req string, status int, sz string) fields terminated by ',' location '/data/weblogs';
  3. create external table weblogs (ip string, rest string) row format delimited fields terminated by ',' location '/data/weblogs';
  4. create external table weblogs (ip string, dt string, req string, status int, sz string) fields delimited fields by ',' location '/data/weblogs';
correct_answer = "A"
Question 9
Many temporary tables may be created in the LASR server by PROC IMSTAT analysis actions. What happens to temporary tables when a PROC IMSTAT session is terminated?
  1. All temporary tables are saved to the SAS server WORK library.
  2. All temporary tables are purged from the LASR server.
  3. The last temporary table created is saved to the SAS WORK library.
  4. The last temporary table created is saved to storage in the HDFS.
correct_answer = "B"
Question 10
This question will ask you to provide a line of missing code.

Which line of code would you insert to get the mean and standard deviation of INCOME and AGE, calculated separately for GENDER variable values F (female) and M (male)?

proc imstat;
  table mylasr.bankdata(tag="&TagString");
  <insert code here>
run;
  1. summary income age / groupby=gender;
  2. crosstab income*gender age*gender;
  3. summary income age / by=gender;
  4. univariate income age / by=gender;
correct_answer = "A"


SAS Data Integration Development
Question 1
Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?
  1. SAS Metadata Server
  2. SAS Workspace Server
  3. SAS/CONNECT Server
  4. SAS Content Server
correct_answer = "D"
Question 2
Which products are needed on the local host in order to access data from an MS Access Database using an ODBC Data Source name?
  1. SAS/ACCESS interface to DSN
  2. SAS/ACCESS interface to MDB
  3. SAS/ACCESS interface to PC Files
  4. SAS/ACCESS interface to ODBC
correct_answer = "D"
Question 3
Which statement is true regarding external files?
  1. External file objects are accessed with SAS INFILE and FILE statements.
  2. External files contain only one record per line.
  3. External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
  4. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.
correct_answer = "A"
Question 4
Within SAS Data Integration Studio's SQL Join transformation, the option to turn on debug is located in which Properties pane?
  1. Select Properties
  2. Create Properties
  3. SQL Join Properties
  4. Job Properties
correct_answer = "C"
Question 5
Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?
  1. only job reports
  2. only table reports
  3. both job reports and table reports
  4. No reports can be stored as document objects.
correct_answer = "C"
Question 6
You want to create a job to extract only the rows that contain information about female employees from a table that contains information about both male and female employees. The new table should have observations in ascending order of age. Refer to the job flow diagram in the exhibit. Where would you set the options to filter and sort the data?
[]
  1. Where tab and Group By tab
  2. Where tab and Order By tab
  3. Where tab and Parameters tab
  4. Group By tab and Parameters tab
correct_answer = "B"
Question 7
Within SAS Data Integration Studio's Table Loader transformation, which load style choice does NOT exist?
  1. Delete where
  2. Append to Existing
  3. Replace
  4. Update/Insert
correct_answer = "A"
Question 8
In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?
  1. Data Validation
  2. SQL Join
  3. Lookup
  4. SCD Type 2 Loader
correct_answer = "D"


SAS Data Quality Steward
Question 1
How do you access the Data Management Studio Options window?
  1. from the Tools menu
  2. from the Administration riser bar
  3. from the Information riser bar
  4. in the app.cfg file in the DataFlux Data Management Studio installation folder
correct_answer = "A"
Question 2
How are the Field name analysis and Sample data analysis methods similar?
  1. They both utilize a match definition from the Quality Knowledge Base.
  2. They both require the same identification analysis definition from the Quality Knowledge Base.
  3. They both utilize an identification analysis definition from the Quality Knowledge Base.
  4. They both require the same match definition from the Quality Knowledge Base.
correct_answer = "C"
Question 3
A sample of data has been clustered and found to contain many multi-row clusters. To construct a "best" record for each multi-row cluster, you need to select information from other records within a cluster. Which type of rule allows you to perform this task?
  1. Clustering rules
  2. Record rules
  3. Business rules
  4. Field rules
correct_answer = "D"
Question 4
Which option in the properties of a Clustering node allows you to identify which clustering condition was satisfied?
  1. Condition matched field prefix
  2. Cluster condition field matched
  3. Cluster condition field count
  4. Cluster condition met field
correct_answer = "A"
Question 5
A Data Quality Steward creates these items for the Supplier repository:
  • A row-based business rule called Monitor for Nulls
  • A set-based business rule called Percent of Verified Addresses
  • A group-based rule called Low Product Count
  • A task based on the row-based, set-based, and group-based rules called Monitor Supplier Data
Which one of these can the Data Quality Steward apply in an Execute Business Rule node in a data job?
  1. set-based business rule called Percent of Verified Addresses
  2. row-based business rule called Monitor for Nulls
  3. group-based rule called Low Product Count
  4. task based on the row-based, set-based, and group-based rules called Monitor Supplier Data
correct_answer = "B"
Question 6
How do you test a real-time data service from the Data Management Server riser bar?
  1. Select the action menu pull down and select the Test button.
  2. Right click on Data Management Server, select the Test button, and then select the real-time data service to test.
  3. There is no way to test the real-time data service in the Data Management Server riser bar
  4. Select the action menu pull down and select the Create WSDL Service button to automatically test.
correct_answer = "A"
Question 7
Refer to the exhibit below.
[]
What process job node would you replace the blue box to complete this flow?
  1. If Then
  2. Fork
  3. Parallel Iterator
  4. Echo
correct_answer = "A"
Question 8
Which Expression Engine Language (EEL) statement assigns the macro variable MY_VAR to the value of 10?
  1. setvar("MY_VAR") = 10
  2. %%MY_VAR%% = 10
  3. &MY_VAR = 10
  4. setvar("MY_VAR",10)
correct_answer = "D"
Question 9
Given these circumstances:
  • The Marketing table contains 150 rows
  • A data job reads from the Marketing table using a Data Source node
  • The number of rows shown in the preview pane is 75
When the data job executes, how many rows are read if the MAX_OUTPUT_ROWS advanced property for the Data Source node is null?
  1. 0 rows
  2. 150 rows
  3. The node produces an error.
  4. 75 rows
correct_answer = "B"
Question 10
While building a data job that creates match codes on a data element, you realize some match codes are not being generated as expected. You suspect the problem might be in the parsing step that is being used by the Match Definition. Which steps do you take to identify the Parse Definition being used by the Match Definition to begin the debugging process?
  1. Open the QKB in Data Management Studio, and then double click on the Match Definition to open it in the appropriate editor.
  2. Access the Match Definition Quick Editor to identify which Parse Definition is being used to tokenize the data values.
  3. Open the Data Management Studio Customize interface to open the Match Definition in the appropriate editor.
  4. Run an impact analysis on the Match Definition to determine which Parse Definition is being used.
correct_answer = "A"


SAS Platform Administration
Question 1
The location of the repository manager physical files can be found in:
  1. SAS Management Console.
  2. the metadata server's omaconfig.xml file.
  3. the foundation repository.
  4. the metadata server's sasv9.cfg file.
correct_answer = "B"
Question 2
Every SAS platform implementation includes:
  1. a foundation repository and a repository manager.
  2. a foundation repository and a custom repository.
  3. a custom repository and a repository manager.
  4. multiple project repositories.
correct_answer = "A"
Question 3
Which procedure allows a platform administrator to update table metadata?
  1. METAUPDATE_RULE
  2. METASELECT
  3. METATABLE
  4. METALIB
correct_answer = "D"
Question 4
Which statement regarding pre-assigned libraries is true?
  1. Pre-assigned libraries reduce the initialization time for a workspace server.
  2. Pre-assigned libraries always connect to an RDBMS at server initialization.
  3. Pre-assigned libraries always connect to a base SAS library at server initialization.
  4. Pre-assigned libraries do not have to be identical across all SAS client applications.
correct_answer = "C"
Question 5
A platform administrator needs to retrieve from the metadata a complete LIBNAME statement including the user ID and password.

To complete this task, the platform administrator must be connected to SAS Management Console with what type of user access in the metadata?
  1. Access to the credentials associated with libraries created with the METALIB procedure.
  2. Access to credentials established by the LIBNAME engine.
  3. Access to credentials associated with users in the outbound login.
  4. Access to credentials for the authentication domain associated with the database server.
correct_answer = "D"
Question 6
By default, which groups have WriteMetadata on the Foundation repository?
  1. PUBLIC
  2. SASUSERS
  3. ADMINISTRATORS ONLY
  4. SAS SYSTEM SERVICES ONLY
correct_answer = "B"
Question 7
Given the following authorization settings for Library Sales2:
  • Library Sales2's parent folder has an explicit grant of RM for Mary.
  • Library Sales2 has an explicit denial of RM for PUBLIC.
Which statement is true?
  1. Mary can see Library Sales2.
  2. Mary can see data flagged as PUBLIC in Library Sales2.
  3. Mary cannot see Library Sales2.
  4. Mary can see Library Sales2, but not any data flagged as PUBLIC.
correct_answer = "C"
Question 8
Which statement is FALSE regarding the WriteMemberMetadata (WMM) permission?
  1. By default, it mirrors the WriteMetadata permission.
  2. It only applies to folders.
  3. If WriteMetadata is granted, then you should not deny WMM.
  4. WMM is inherited from one folder to another folder.
correct_answer = "D"
Question 9
A user needs to access data in a cube. The user has the following characteristics:
  • is in Enterprise Guide: OLAP role
  • does not have Read and ReadMetadata permissions for the cube.
What will be the result when the user attempts to access data in the cube?
  1. The user will be able to access the data since Read and ReadMetadata permissions are not required.
  2. The user will be able to access the data since they are using Enterprise Guide.
  3. The user will be able to access the data since they are in the OLAP Role.
  4. The user will not be able to access the data.
correct_answer = "D"

Free SAS Tutorials for supplemental learning

View SAS Training "how to" videos, tutorials, and demos to learn tips and tricks for working with SAS software.

Not all of the tutorials apply to the content on the exams.