A00-420無料問題集「SASInstitute SAS Viya Intermediate Programming」

質問 1

Which CAS-enabled procedure is used to fit regression models?

（A）CASPROC

（B）CASREG

（C）CASANALYZE

（D）CASTAT

正解：B 解答を投票する

質問 2

Which CAS action is used to join multiple tables in SQL programming?

（A）MERGE

（B）UNION

（C）JOIN

（D）CONCATENATE

正解：C 解答を投票する

質問 3

Which CAS action is used to identify potential duplicate records in a CAS table?

（A）cas.verify

（B）cas.check

（C）cas.duplicate

（D）cas.identify

正解：C 解答を投票する

質問 4

Which CAS statement is used to create a new column in a CAS table?

（A）CASWHERE

（B）CASSET

（C）CASTABLE

（D）CASCOMPUTE

正解：D 解答を投票する

質問 5

What is the syntax for submitting a SAS Viya program in SAS Studio?

（A）PROCESS;

（B）EXECUTE;

（C）RUN;

（D）SUBMIT;

正解：D 解答を投票する

質問 6

What is the file extension used for SAS Viya programs?

（A）sql

（B）sas

（C）py

（D）viya

正解：B 解答を投票する

質問 7

Which SQL clause is used to sort rows in a CAS table based on specified variables?

（A）SELECT

（B）ORDER BY

（C）FROM

（D）GROUP BY

正解：B 解答を投票する

質問 8

Which CAS action is used to append rows to an existing CAS table?

（A）ALTER TABLE

（B）LOAD

（C）EXPORT

（D）APPEND

正解：D 解答を投票する

質問 9

Which SQL clause is used to calculate summary statistics for variables in a CAS table?

（A）SELECT

（B）FROM

（C）GROUP BY

（D）HAVING

正解：C 解答を投票する

質問 10

Which PROC CAS step will transpose the CLASS table so that the values of the NAME column are used to create the column names in the output table?

（A）proc cas;
transpose.transpose /
table={caslib="casuser", name="class"} ,
id={"name"},
casout={caslib="casuser", name="outclass", replace=true};
quit;

（B）proc cas;
transpose.transpose /
table={caslib="casuser",name="class"},
transpose={"name"},
casout={caslib="casuser", name="outclass", replace=true};
quit;

（C）proc cas;
transpose.transpose /
table={caslib="casuser", name="class", groupby={name="name"}},
casout={caslib="casuser", name="outclass", replace=true};
quit;

（D）proc cas;
transpose.transpose /
table={caslib="casuser", name="class", orderby={name="name"}},
id={"age"},
casout={caslib="casuser", name="outclass", replace=true};
quit;

正解：A 解答を投票する

質問 11

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'"};

正解：A 解答を投票する

質問 12

Complete the CASL statement below to save the result stored in r to a SAS data set named class in the mylib library.
saveresult r _________ =mylib.class;

正解：

Dataout

質問 13

Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.
proc mdsummary data=casuser.orders;
var cost;
groupby continent /_______;
run;

正解：

casuser.cost_cont

質問 14

Which PROC CASUTIL statement will save the in-memory table cars in the casuser caslib to a SAS data set named cars in the public caslib?

（A）savedata caslib='casuser' casdata='cars' dataout='cars.sas7bdat' outcaslib='public';

（B）save incaslib='casuser' casdata='cars' casout='cars.sas7bdat' outcaslib='public';

（C）savedata incaslib='casuser' casdata='cars' casout='cars.sas7bat' library='public';

（D）save caslib='casuser' casdata='cars' out='public.cars';

正解：B 解答を投票する

A00-420 無料問題集「SASInstitute SAS Viya Intermediate Programming」

弊社を連絡する

関連リンク

トップ試験