Signetsoft (Corporate Training / Online Training / Classroom Training in Bangalore)

SAS Certification Sample Questions (BASE, Advance, Stat, Clinical,..etc)

SAS  Certification Sample Questions and Answers for the following Tests:

1. SAS Base Programming
2. SAS Advanced Programming
3. Clinical Trials Programming
4. Predictive Modeling Using SAS Enterprise Miner
5. SAS Statistical Business Analysis
6. SAS BI Content Development
7. SAS Visual Analytics Exploration and Design
8. SAS Data Integration Development
9. SAS Data Quality Steward
10. SAS Platform Administration

 

1. 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?

Name Age

---------------------

John 35

Name Age

---------------------

John (missing value)

Name Age

---------------------

(missing value) (missing value)

1. 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?

Id Char1 Char2

--- ----- -----

182 M

Id Char1 Char2

--- ----- -----

182 Q

Id Char1 Char2

--- ----- -----

182 M Q

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?

Var1 Var2 Var3 Var4

------ ------ ------ ------

RED ORANGE RED ORANGE

BLUE INDIGO BLUE INDIGO

CYAN WHITE CYAN WHITE

GRAY BROWN GRAY BROWN

Var1 Var2 Var3 Var4

------ ------ ------ ------

RED ORANGE BLUE INDIGO

CYAN WHITE GRAY BROWN

Var1 Var2 Var3 Var4

------ ------ ------ ------

RED ORANGE YELLOW GREEN

BLUE INDIGO PURPLE VIOLET

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

1. X = 5, Index = 5

1. X = 5, Index = 6

1. 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?

proc print data = SASUSER.CLASS;

var test;

format test score;

run;

proc print data = SASUSER.CLASS;

var test;

format test score.;

run;

proc print data = SASUSER.CLASS format = score;

var test;

run;

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?

keep Total;

retain Total 0;

Total = 0;

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_});

1. Qtr1 = month{1} + month{2} + month{3};

1. Qtr1 = sum(of month{*});

1. 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

1. Change the ** in the BMI formula to a single *

1. Change bmi to BMI in the WHERE statement

1. 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

1. 34

1. 345

1. 2345

correct_answer = “D”

2. 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. 

1. 

1. 

1. 

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?

proc sql;

create table three as

select *

from one full join two

where one.num = two.num;

quit;

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;

proc sql;

create table three as

select one.num, char1, char2

from one full join two

on one.num = two.num;

quit;

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

1. SYMGET

1. %SYMGET

1. &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?

proc print data = sasdata.sales;

by date;

run;

proc print data = sasdata.sales;

where month(date) = 3;

run;

data march;

set sasdata.sales;

if '01mar2002'd < date < '31mar2002'd;

run;

data march;

set sasdata.sales;

where date < '31mar2002'd or revenue > 50000;

run;

correct_answer = “A”

Question 5

Given the following SQL procedure output:

Table	Physical Obs	% Deleted
EMPLOYEE_ADDRESSES	424	5.0%
EMPLOYEE_PAYROLL	424	5.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?

select MEMNAME 'Table', NOBS 'Physical Obs'

, DELOBS/NOBS '% Deleted' format=percent6.1

from dictionary.tables

where LIBNAME='ORION' AND DELOBS/NOBS >= .05;

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;

select MEMNAME 'Table', NLOBS 'Physical Obs'

, DELOBS/NLOBS LABEL='% Deleted' format=percent6.1

from dictionary.tables

where LIBNAME='ORION' AND DELOBS/NLOBS >= .05;

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

1. 4+3+2+1

1. 7

1. 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

1. Reduce length of character variables to 28 bytes

1. Compress the data set with binary compression

1. 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 theSASUSER.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

1. only when the WORK.BAD_DATA view is used

1. both when the code is submitted and the view is used

1. never, the use of _null_ in a view is a syntax error

correct_answer = “B”

 3. Clinical Trials Programming

Question 1

What is the main focus of Good Clinical Practices (GCP)?

1. harmonized data collection

1. standard analysis practices

1. protection of subjects

1. standard monitoring practices

correct_answer = “C”

Question 2

Vital Signs are a component of which SDTM class?

1. Findings

1. Interventions

1. Events

1. Special Purpose

correct_answer = “A”

Question 3

Which option in the PROC EXPORT procedure overwrites an existing file?

1. NEW

1. OVERWRITE

1. REPLACE

1. 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

1. 6

1. 7

1. 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;

1. types trt trt*day;

1. by trt day;

1. 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

1. Adverse

1. &&&Root&Suffix

1. 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’ ;

1. define day / order order=data ‘Day’ ;

1. define day / order noprint ‘Day’ ;

1. 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’;

1. ods tagsets.rtf file=’report.rtf’;

1. ods tagsets.rtf file=’report.rtf’ break=’Continued’;

1. 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.

1. Efficiently ensure any logic errors are discovered early in the programming process.

1. Justify the means used to accomplish the outcome of a program and ensure its accurate representation of the original data.

1. Document all specifications pertaining to programmed output and ensure all were reviewed during the programming process.

correct_answer = “C”

4. 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.

1. 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

1. 0.42541

1. 0.42667

1. 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

1. 14.69

1. 5862.76

1. 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.

1. Create the data source, DEVELOP, in SAS Enterprise Miner. DEVELOP is in the directory c:\workshop\Practice.

1. Set the role of all variables to Input, with the exception of the Target variable, Ins (1= has insurance, 0= does not have insurance).

1. Set the measurement level for the Target variable, Ins, to Binary.

1. Ensure that Branch and Res are the only variables with the measurement level of Nominal.

1. All other variables should be set to Interval or Binary.

1. Make sure that the default sampling method is random and that the seed is 12345.

Use this project to answer the next <b.seven< b=””>questions. (Note: only 2 of 7 questions are displayed for this example)

The variable Branch has how many levels?

1. 8

1. 12

1. 19

1. 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

1. $8,711.65

1. $9,586.55

1. $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.

5. 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.

1. Assets in portfolio B are significantly more risky than assets in portfolio A.

1. The portfolios differ significantly with respect to risk.

1. 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?

lsmeans Region / pdiff=all adjust=dunnett;

lsmeans Region / pdiff=all adjust=tukey;

lsmeans Region / pdiff=all adjust=lsd;

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?

proc glm data=SASUSER.MLR;

class c1;

model y = c1 x1 x1sq c1byx1 /solution;

run;

proc reg data=SASUSER.MLR;

model y = c1 x1 x1sq c1byx1 /solution;

run;

proc glm data=SASUSER.MLR;

class c1;

model y = c1 x1 x1*x1 c1*x1 /solution;

run;

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

1. overhead

1. scrap

1. training

correct_answer = “B”

Question 5

Which statement is an assumption of logistic regression?

1. The sample size is greater than 100.

1. The logit is a linear function of the predictors.

1. The predictor variables are not correlated.

1. 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.

1. AIC increased.

1. Pr > Chisq increased.

1. – 2 Log L increased.

correct_answer = “D”

Question 7

The LOGISTIC procedure will be used to perform a regression analysis on a data set with a total of 10,000 records. A single input variable contains 30% missing records.

How many total records will be used by PROC LOGISTIC for the regression analysis?

Enter your numeric answer in the space below. Do not add leading or trailing spaces to your answer.

Click the calculator button to display a calculator if needed.

correct_answer = “7000”

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

1. linear association between the variables

1. monotonic association between the variables

1. no association between the variables

correct_answer = “A”

Question 9

An analyst builds a logistic regression model which is 75% accurate at predicting the event of interest on the training data set. The analyst presents this accuracy rate to upper management as a measure of model assessment.

What is the problem with presenting this measure of accuracy for model assessment?

1. This accuracy rate is redundant with the misclassification rate.

1. It is pessimistically biased since it is calculated from the data set used to train the model.

1. This accuracy rate is redundant with the average squared error.

1. It is optimistically biased since it is calculated from the data used to train the model.

correct_answer = “D”

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

1. percent concordant plus (.5 * percent tied)

1. percent concordant plus (.5 * percent discordant)

1. percent discordant plus percent tied

correct_answer = “B”

6. 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.

1. SAS performs the sort on the local machine.

1. Excel performs the sort on the server.

1. 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

1. when at least one table is selected as a data source

1. when at least one OLAP cube is selected as a data source

1. 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.

1. Only rows that belong to the first group are returned.

1. All rows will be returned for PUBLIC group only.

1. 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

1. PROC SQL

1. a SQL/JDBC query

1. 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.

1. The stored process server is not running.

1. The file that contains the stored process code is not in the specified location.

1. 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

1. DateRange_BEGIN and DateRange_END

1. DateRange_MIN and DateRange_MAX

1. 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

1. Web Report Studio: Advanced

1. Web Report Studio: Content Management

1. 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.

1. Dynamic Prompts and Shared Prompts

1. Cascading Prompts and Standard Groups

1. 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

1. a SAS OLAP Cube and a stored process

1. one table joined with one SAS OLAP Cube

1. 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.

1. Connection profiles are stored on the server machine.

1. Connection profiles are stored on the machine where the SAS application is installed.

1. All SAS platform applications share one connection profile.

correct_answer = “C”