SAS Viya Intermediate Programming (A00-420) Free Practice Test

Question 1

Assume all caslib names follow libref naming conventions.
Which code assigns librefs of the same name to each caslib?

A. caslib assign libref;

B. caslib _all_ assign;

C. caslib assign _all_;

D. caslib libref assign;

Correct Answer: B

Question 2

Which CAS action is used to perform aggregations and summary statistics in the DATA step?

A. SUMMARY

B. GROUP BY

C. COMPUTE

D. FORMAT

Correct Answer: B

Question 3

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

A. CASFACTOR

B. CASSCORE

C. CASPROC

D. CASANALYZE

Correct Answer: A

Question 4

Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?

A. cas.uniq

B. cas.count

C. cas.distinct

D. cas.frequency

Correct Answer: A

Question 5

Which CAS object is used to store and manage data?

A. CASLIB

B. CASDATA

C. CASTABLE

D. CASSET

Correct Answer: B

Question 6

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

A. WHERE

B. FORMAT SASDATE

C. GROUP BY

D. FORMAT

Correct Answer: D

Question 7

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

Correct Answer: C

Question 8

What is the purpose of the SET action in CAS language programming?

A. To define the output format

B. To sort the data

C. To perform data summarization

D. To specify the input data source

Correct Answer: D

Question 9

Which PROC TRANSPOSE step will execute entirely in CAS?

A. proc transpose data=work.table out=work.table_transposed;
id group;
run;

B. proc transpose data=work.table out=casuser.table_transposed;
id group;
run;

C. proc transpose data=casuser.table out=work.table_transposed;
id group;
run;

D. proc transpose data=casuser.table out=casuser.table_transposed;
id group;
run;

Correct Answer: D

Question 10

What data types does FedSQL support in CAS?

A. CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME

B. BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY

C. INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)

D. INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT

Correct Answer: C

Question 11

In which situation is it best to leverage the CAS server?

A. When executing BY statements with high cardinality variables.

B. When you need to use the LASR procedure to access data.

C. When using large data and computationally complex code.

D. When you need to SORT all of your data before processing.

Correct Answer: C

Question 12

Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?

A. table.tableInfo /
table={caslib="casuser", name="clientes"};

B. table.columnInfo /
caslib="casuser", name="clientes";

C. table.columnInfo /
table={caslib="casuser", name="clientes"};

D. table.tableInfo /
caslib="casuser", name="clientes";

Correct Answer: C

Question 13

Complete the code below to create an in-memory table named cars_cas in the casuser caslib.
proc casutil;
load data=sashelp.cars outcaslib="casuser" casout=__________;
run;

Correct Answer:

"cars_cas"

Question 14

How can you associate a user-defined format with a variable in SAS?

A. Using the FORMAT statement in the DATA step

B. Using the LABEL statement in PROC FORMAT

C. Using the WHERE statement in PROC SQL

D. Using the BY statement in PROC FORMAT

Correct Answer: A

Welcome to TestSimulate

SASInstitute SAS Viya Intermediate Programming (A00-420) Free Practice Test