Welcome! Preparing for the SAS Viya Intermediate Programming (A00-420) certification exam can be a daunting task, but we're here to make it easier for you. Here are the sample questions that will help you become familiar with the SAS A00-420 exam style and structure. We encourage you to try our Demo SAS Viya Programming Specialist Certification Practice Exam to measure your understanding of the exam structure in an environment that simulates the actual test environment.
Why Use Our SAS Viya Programming Specialist Sample Questions?
To make your preparation easier for the SAS A00-420 exam, we strongly recommend you to use our Premium SAS Viya Programming Specialist Certification Practice Exam. According to our survey with certified candidates, you can easily score more than 85% in your actual SAS Certified Associate - Intermediate Programming Using SAS Viya exam if you score 100% in our premium 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 to us at feedback@analyticsexam.com if you find any data entry errors in these SAS Viya Intermediate Programming (A00-420) sample questions.
Get Started Today!
Equip yourself with the best resources and practice exams to ace your SAS Certified Associate - Intermediate Programming Using SAS Viya exam. Explore our comprehensive study materials and take the first step towards certification success.