A00-415 exam

Assume all caslib names follow libref naming conventions. Which code assigns librefs of the same name to each caslib?A . caslib _all_ assign;B . caslib assign _all_;C . caslib libref assign;D . caslib assign libref;View AnswerAnswer: A

Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?A . proc casutil;   save casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees.csv" replace; quit;B . proc casutil;     save casdata="employees" incaslib="casuser"     outcaslib="casuser" casout="out_employees.csv"; quit;C . proc casutil;    ...

What data types does FedSQL support in CAS?A . BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARYB . CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIMEC . INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOATD . INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)View AnswerAnswer: D

Which CAS-enabled procedure is used to combine multiple CAS tables based on a common key variable?A . CASMERGEB . CASCOMBINEC . CASTABLED . CASEJOINView AnswerAnswer: A

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 / table={caslib="casuser", name="clientes"};C . table.tableInfo / caslib="casuser", name="clientes";D . table.columnInfo / caslib="casuser", name="clientes";View AnswerAnswer: B

Which CAS action is used to remove duplicate records from a CAS table?A . cas.distinctB . cas.uniqueC . cas.dedupD . cas.removeView AnswerAnswer: C

Which CAS action is used to load data from an external file into a CAS table?A . cas.loadB . cas.fetchC . cas.uploadD . cas.importView AnswerAnswer: D

Which code can be used to load a SAS data set, sashelp.cars, into caslib public?A . proc casutil; load data=sashelp.cars caslib=public; quit;B . proc casutil; load data=sashelp.cars outcaslib="public"; quit;C . libname public cas sessref=public; data public.cars; set sashelp.cars; run;D . data public.cars / sessref=casuser; set sashelp.cars; run;View AnswerAnswer: B

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...

Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?A . PROC MEANSB . PROC SQLC . PROC FREQD . PROC GLMView AnswerAnswer: C