A00-415 Exam Training Practice Tests (SASInstitute SAS Viya Fundamentals of Programming)]

Question 1

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;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
quit; B. proc casutil;
load data=work.orders casout="orders" outcaslib="public";
format region regnm.;
quit; C. proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public";
quit; D. proc casutil;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
format region regnm.;
quit;

Correct Answer: C

Question 2

Which statement is true regarding BY group processing in the CAS DATA step?

A. Every row in a BY group is sent to the same thread and processed as a group. B. The DATA step orders the rows within a BY group and then orders the BY groups in the output. C. The data must be sorted before the DATA step begins processing. D. Using the BY statement automatically sends all DATA step processing to a single thread.

Correct Answer: A

Question 3

Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?

A. CASCLUSTER B. CASSTAT C. CASKMEANS D. CASPROC

Correct Answer: A

Question 4

The set parameter of the table.update CAS action requires a specific type of value.
Which type is correct?

A. an array of arrays B. a dictionary of dictionaries C. a dictionary of arrays D. an array of dictionaries

Correct Answer: D

Question 5

Which CAS action is used to sort data based on one or more variables?

A. SORT B. ARRANGE C. ORDER D. ORGANIZE

Correct Answer: A

Question 6

Which statement is used to apply a user-defined format within a PROC SQL query?

A. FORMAT B. FORMAT SASDATE C. GROUP BY D. WHERE

Correct Answer: A

Question 7

Which CAS action is used to create a new CAS table based on specified conditions?

A. FILTER B. WHERE C. SUBSET D. SELECT

Correct Answer: B

Question 8

Given the dictionary inTable : {caslib="casuser",name="cars"}
Which CASL statement will successfully add a where parameter to subset the data?

A. simple.mdsummary / table=inTable || {where="origin = 'Europe'"}; B. simple.mdsummary / table=inTable !! [where="origin = 'Europe'"]; C. simple.mdsummary / table=inTable || [where="origin = 'Europe'"]; D. simple.mdsummary / table=inTable !! {where="origin = 'Europe'"};

Correct Answer: A

Question 9

Which programming language is primarily used in CAS?

A. SAS B. R C. Java D. Python

Correct Answer: A

Question 10

Which statement is true about SAS Viya?

A. Its primary interface for submitting programs is the SAS Windowing Environment. B. It supports only single-threaded DATA step processing. C. It contains the SAS launcher server, which is the primary server for processing big data. D. It can employ multiple servers to execute programs.

Correct Answer: D

SASInstitute SAS Viya Fundamentals of Programming - A00-415 Exam Practice Test