correct_answer = "B"
Item 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?
A. Mary can see Library Sales2.
B. Mary can see data flagged as PUBLIC in Library Sales2.
C. Mary cannot see Library Sales2.
D. Mary can see Library Sales2, but not any data flagged as PUBLIC.
correct_answer = "C"
Item 8
Which statement is FALSE regarding the WriteMemberMetadata (WMM) permission?
A. By default, it mirrors the WriteMetadata permission.
B. It only applies to folders.
C. If WriteMetadata is granted, then you should not deny WMM.
D. WMM is inherited from one folder to another folder.
correct_answer = "D"
Item 9
Content has been exported from a SAS 9.1.3 environment into a SAS 9.2 development environment.
After the export, the platform administrator attempts to promote an object from the SAS 9.2 development environment into a production environment.
What will be the result of this promotion attempt?
A. The promotion will not be allowed because objects from SAS 9.1.3 cannot be promoted to SAS 9.2.
B. The promotion will not be allowed because objects in a development environment cannot be promoted to a production environment.
C. The promotion will be allowed assuming the object type is allowed for promotion.
D. The promotion will not be allowed because objects exported from a previous environment cannot be promoted.
correct_answer = "C"
SAS Data Integration Developer for SAS 9
Item 1
Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?
A. SAS Metadata Server B. SAS Workspace Server C. SAS/CONNECT Server D. SAS Content Server
correct_answer = "D"
Item 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?
A. SAS/ACCESS interface to DSN B. SAS/ACCESS interface to MDB C. SAS/ACCESS interface to PC Files
D. SAS/ACCESS interface to ODBC correct_answer = "D"
Item 3
Which statement is true regarding external files?
A. External file objects are accessed with SAS INFILE and FILE statements.
B. External files contain only one record per line.
C. External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
D. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.
correct_answer = "A"
Item 4
Within SAS Data Integration Studio's SQL Join transformation, the option to turn on debug is located in which Properties pane?
A. Select Properties B. Create Properties C. SQL Join Properties D. Job Properties
correct_answer = "C"
Item 5
Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?
A. only job reports B. only table reports
C. both job reports and table reports
D. No reports can be stored as document objects.
correct_answer = "C"
Item 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?
A. Where tab and Group By tab
B. Where tab and Order By tab C. Where tab and Parameters tab
D. Group By tab and Parameters tab correct_answer = "B"
Item 7
Within SAS Data Integration Studio's Table Loader transformation, which load style choice does NOT exist?
A. Delete where B. Append to Existing C. Replace
D. Update/Insert
correct_answer = "A"
Item 8
In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?
A. Data Validation B. SQL Join C. Lookup
D. SCD Type 2 Loader correct_answer = "D"
SAS BI Content Developer for SAS 9
Item 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?
A. SAS performs the sort on the server.
B. SAS performs the sort on the local machine.
C. Excel performs the sort on the server.
D. Excel performs the sort on the local machine.
correct_answer = "A"
Item 2
When can you add a stored process as a data source to an information map?
A. anytime
B. when at least one table is selected as a data source C. when at least one OLAP cube is selected as a data source
D. once an application server has been selected correct_answer = "B"
Item 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?
A. All rows will be returned for any group that the user is a member of.
B. Only rows that belong to the first group are returned.
C. All rows will be returned for PUBLIC group only.
D. All rows matching the group identity login are returned.
correct_answer = "A"
Item 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?
A. DATA Step B. PROC SQL
C. a SQL/JDBC query D. MDX
correct_answer = "C"
Item 5
Refer to the exhibit.
What causes this error message when executing a stored process?
A. Stored process code cannot be a .TXT file.
B. The stored process server is not running.
C. The file that contains the stored process code is not in the specified location.
D. An administrator deleted the stored process from the metadata.
correct_answer = "C"
Item 6
In a stored process, when using a range prompt named DateRange, which macro variables would you use in your SAS code?
A. DateRange_START and DateRange_FINISH B. DateRange_BEGIN and DateRange_END C. DateRange_MIN and DateRange_MAX D. DateRange0 and DateRange1
correct_answer = "C"
Item 7
Upon initial install, all of the capabilities in the 'Web Report Studio: Report Creation' role are also included in which role?
A. Web Report Studio: Report Viewing B. Web Report Studio: Advanced
C. Web Report Studio: Content Management D. Web Report Studio: Administration
correct_answer = "B"
Item 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?
A. Cannot create shared cascading prompts for use in multiple reports.
B. Dynamic Prompts and Shared Prompts C. Cascading Prompts and Standard Groups
D. Cascading Prompts, Standard Groups, and Shared Prompts correct_answer = "D"
Item 9
A SAS Information Map with a SAS OLAP Cube as a data source can be built from which of the following?
A. multiple SAS OLAP Cubes
B. a SAS OLAP Cube and a stored process C. one table joined with one SAS OLAP Cube D. one SAS OLAP Cube only
correct_answer = "D"
Item 10
Which statement is true regarding connection profiles used with the SAS platform applications?
A. Each SAS platform application must have its own connection profile.
B. Connection profiles are stored on the server machine.
C. Connection profiles are stored on the machine where the SAS application is installed.
D. All SAS platform applications share one connection profile.
correct_answer = "C"
SAS Statistical Business Analyst Using SAS 9
Item 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?
A. Assets in portfolio A are significantly more risky than assets in portfolio B.
B. Assets in portfolio B are significantly more risky than assets in portfolio A.
C. The portfolios differ significantly with respect to risk.
D. The portfolios do not differ significantly with respect to risk.
correct_answer = "C"
Item 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?
A. lsmeans Region / pdiff=all adjust=dunnett;
B. lsmeans Region / pdiff=all adjust=tukey;
C. lsmeans Region / pdiff=all adjust=lsd;
D. lsmeans Region / pdiff=all adjust=none;
correct_answer = "B"
Item 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?
A. proc glm data=SASUSER.MLR;
B. class c1;
C. model y = c1 x1 x1sq c1byx1 /solution;
D. run;
E. proc reg data=SASUSER.MLR;
F. model y = c1 x1 x1sq c1byx1 /solution;
G. run;
H. proc glm data=SASUSER.MLR;
I. class c1;
J. model y = c1 x1 x1*x1 c1*x1 /solution;
K. run;
L. proc reg data=SASUSER.MLR;
M. model y = c1 x1 x1*x1 c1*x1;
N. run;
correct_answer = "C"
Item 4
Refer to the REG procedure output:
What is the most important predictor of the response variable?
A. intercept B. overhead C. scrap D. training
correct_answer = "B"
Item 5
Which statement is an assumption of logistic regression?
A. The sample size is greater than 100.
B. The logit is a linear function of the predictors.
C. The predictor variables are not correlated.
D. The errors are normally distributed.
correct_answer = "B"
Item 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?
A. DF increased.
B. AIC increased.
C. Pr > Chisq increased.
D. - 2 Log L increased.
correct_answer = "D"
Item 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"
Item 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?
A. nonmonotonic association between the variables B. linear association between the variables
C. monotonic association between the variables D. no association between the variables
correct_answer = "A"
Item 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?
A. This accuracy rate is redundant with the misclassification rate.
B. It is pessimistically biased since it is calculated from the data set used to train the model.
C. This accuracy rate is redundant with the average squared error.
D. It is optimistically biased since it is calculated from the data used to train the model.
correct_answer = "D"
Item 10
Refer to the exhibit:
For the ROC curve shown, what is the meaning of the area under the curve?
A. percent concordant plus percent tied B. percent concordant plus (.5 * percent tied) C. percent concordant plus (.5 * percent discordant) D. percent discordant plus percent tied
correct_answer = "B"</b.seven<>