Practice Free A00-420 Exam Online Questions
In order to use a user-defined format in CAS, which condition must be true?
- A . The format must be saved to the FORMATS caslib.
- B . The format must exist in a CAS format library.
- C . The format name must begin with the prefix ‘cas’.
- D . The system option CASFORMATS=True must be specified.
What are two valid data types for a CAS table column? (choose two)
- A . varchar
- B . binary
- C . varbinary
- D . decimal
Which CAS-enabled procedure is used to apply user-defined formats to variables?
- A . CASUTIL
- B . CASTABULATE
- C . CASFORMAT
- D . CASPROC
Which CAS action is used to validate the integrity of relationships between variables in a CAS table?
- A . cas.integrity
- B . cas.relationship
- C . cas.validate
- D . cas.link
Given the following CASL program:
proc cas;
table.tableInfo result=res /
caslib="casuser";
do row over res.tableInfo;
print row;
end;
run;
quit;
Which statement best describes the variable row in the above program?
- A . Row is string type variable that contains the name of a table in caslib casuser.
- B . Row is comma separated string containing name and additional information of tables in caslib casuser.
- C . Row is a dictionary containing key=value pairs with information on each table in caslib casuser.
- D . Row is an array containing the values with information on each table in caslib casuser.
Which transpose.transpose action parameter specifies the name of the column in the input table that provides labels for the transposed output columns?
- A . idLabel
- B . label
- C . prefix
- D . name
What is the purpose of the CASLIB statement in SAS Viya?
- A . To create a new CASLIB
- B . To import external data into CAS
- C . To delete a CASLIB
- D . To assign a CASLIB reference
When submitted, this program runs normally on the Compute Server and produces a cross-tab report:
proc freq data=casuser.cars;
by descending origin;
table type*make / nocol
norow nopercent;
run;
What happens when this program is submitted instead?
proc freqtab data=casuser.cars;
by descending origin;
table type*make / nocol
norow nopercent;
run;
- A . The program runs normally on the Compute Server and produces a cross-tab report.
- B . The program runs normally on the CAS server and produces a cross-tab report.
- C . The program produces an error indicating the DESCENDING option is not supported in the BY statement.
- D . The program produces an error indicating the NOPERCENT option is not supported in the TABLE statement.
Which CAS action is used to join multiple tables in SQL programming?
- A . MERGE
- B . JOIN
- C . UNION
- D . CONCATENATE
Which CAS action is used to compute derived variables or transformations on variables in a CAS table?
- A . cas.transform
- B . cas.compute
- C . cas.modify
- D . cas.derive