SAS Viya Intermediate Programming (A00-420) Certification Exam Sample Questions

A00-420 Dumps Free, A00-420 PDF Download, SAS Viya Intermediate Programming Dumps Free, SAS Viya Intermediate Programming PDF Download, A00-420 Free DownloadHere are the sample questions which will help you be familiar with SAS Viya Intermediate Programming (A00-420) exam style and structure. We encourage you to try our Demo SAS Viya Intermediate Programming Certification Practice Exam to measure your understanding of exam structure in an environment which simulates the SAS Viya Intermediate Programming Certification test environment.

To make your preparation more easy for SAS Viya Intermediate Programming (A00-420) exam, we strongly recommend you to use our Premium SAS Viya Intermediate Programming Certification Practice Exam. According to our survey with certified candidates, you can easily score 85% in your actual SAS Certification exam if you can score 100% in our premium SAS Viya Intermediate Programming Certification practice exams.

SAS A00-420 Sample Questions:

01. Which statement is true about SAS Viya?
a) It contains the SAS launcher server, which is the primary server for processing big data.
b) It supports only single-threaded DATA step processing.
c) It can employ multiple servers to execute programs.
d) Its primary interface for submitting programs is the SAS Windowing Environment.
 
02. You want to use the MEANS procedure to summarize data using the CAS server. Which statement is true?
a) Statistics that are supported by PROC MEANS are also supported on the CAS server.
b) You must specify a CAS engine libref with the input table name.
c) You must sort the data before using BY-group processing on the CAS server.
d) All PROC MEANS statements are supported for CAS processing.
 
03. Which DATA step function is supported in CAS?
a) SYMGET
b) CATX
c) FILEREF
d) RANUNI
 
04. Which CASL program will fetch all 428 rows from the cars table?
a) proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=1000;
 quit;
b) proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_all_;
 quit;
c) proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_maxrows_;
 quit;
d)  proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1;
 quit;
 
05. Given the following SAS program?
caslib _all_ assign;
proc sgplot data=casuser.cars;
vbar Make;
run;
What will the program do?
a) Produce an error because the SGPLOT procedure cannot access the CAS table.
b) Execute the SGPLOT procedure on the CAS server.
c) Summarize the results in CAS and process the summarized results on the Compute Server.
d) Transfer the data to the Compute Server and then execute the SGPLOT procedure.
 
06. Which table.update parameter specifies the column to update?
a) Assign
b) Update
c) Set
d) ComputedVars
 
07. The regnm format has been created and stored in an CAS format library. Which program associates the format regnm with the region column in the orders table?
a) proc casutil;
load data=work.orders casout="orders" outcaslib="public";
format region regnm.;
quit;
b) proc casutil;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
format region regnm.;
quit;
c) proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
quit;
d) proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public";
quit;
 
08. Which action from the table action set lists the files in a caslib's data source?
a) tableInfo
b) fileInfo
c) tableDetails
d) caslibInfo
 
09. The dataPreprocess.impute action preforms data matrix (variable) imputation. Which imputation methods can be used?
a) MIDRANGE, MODE, RANDOM, VALUE
b) MIDRANGE, MODE, RANDOM, CUSTOM
c) MODE, RANDOM, VALUE, CUSTOM
d) MIDRANGE, RANDOM, VALUE, CUSTOM
 
10. Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?
a) Option A
b) Option B
c) Option C
d) Option D

Answers:

Question: 1 Answer: c Question: 2 Answer: b
Question: 3 Answer: b Question: 4 Answer: a
Question: 5 Answer: d Question: 6 Answer: c
Question: 7 Answer: d Question: 8 Answer: b
Question: 9 Answer: a Question: 10 Answer: a

Note: Please write us on feedback@analyticsexam.com if you find any data entry error in these SAS Viya Intermediate Programming (A00-420) sample questions.

Rating: 5 / 5 (75 votes)