A00-420試験無料問題集（256題）「SASInstitute SAS Viya Intermediate Programming 認定」

出題：1

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

A. WHERE

B. SELECT

C. SUBSET

D. FILTER

正解：A 解答を投票する

出題：2

Which DATA step function is supported in CAS?

A. CATX

B. RANUNI

C. FILEREF

D. SYMGET

正解：A 解答を投票する

出題：3

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

正解：B 解答を投票する

出題：4

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

A. CASANALYZE

B. CASPROC

C. CASTAT

D. CASREG

正解：D 解答を投票する

出題：5

Which SAS procedure is used for generating descriptive statistics?

A. PROC SUMMARY

B. PROC REPORT

C. PROC TABULATE

D. PROC MEANS

正解：D 解答を投票する

出題：6

Given the following SAS program:
data casuser.national;
set casuser.baseball(where=(league='National'));
r=ranuni(625);
drop league;
run;
Why is the above program processed by the Compute Server rather than the CAS server?

A. The RANUNI function is not supported.

B. The DROP statement is not supported.

C. The SESSREF= option is not specified in the DATA statement.

D. The WHERE option is not supported in the SET statement.

正解：A 解答を投票する

出題：7

Which CAS statement is used to select specific columns from a CAS table?

A. CASWHERE

B. CASSELECT

C. CASTABLE

D. CASCOLUMN

正解：C 解答を投票する

出題：8

Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?
proc cas;
table.altertable / caslib="casuser", name="cars",
<enter code segment here>;
quit;

A. columns={{rename="make" , name="veh_make"}};

B. columns=[[name="make" , rename="veh_make"]];

C. columns={name="make" = "veh_make"};

D. columns={{name="make" , rename="veh_make"}};

正解：D 解答を投票する

出題：9

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

A. Using the BY statement automatically sends all DATA step processing to a single thread.

B. The data must be sorted before the DATA step begins processing.

C. The DATA step orders the rows within a BY group and then orders the BY groups in the output.

D. Every row in a BY group is sent to the same thread and processed as a group.

正解：D 解答を投票する

出題：10

Which CAS-enabled procedure is used to import data into a CAS table?

A. CASLIB

B. CASIMPORT

C. CASTABLE

D. CASDATA

正解：B 解答を投票する

出題：11

Which CAS-enabled procedure is used to perform market basket analysis?

A. CASPROC

B. CASSTAT

C. CASMINER

D. CASASSOC

正解：D 解答を投票する

出題：12

What data types does FedSQL support in CAS?

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

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

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

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

正解：D 解答を投票する

出題：13

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

A. COMPUTE

B. GROUP BY

C. FORMAT

D. SUMMARY

正解：B 解答を投票する

出題：14

In the space provided, enter the text for ensuring the table is available to any subsequent CAS session.
table.loadTable / caslib="public", path="sales.xlsx",
casOut={caslib="public", name="sales",______=true};

正解：

promote

出題：15

Which CAS action is used to calculate the sum, minimum, maximum, and mean for numeric variables in a CAS table?

A. cas.summarize

B. cas.aggregate

C. cas.describe

D. cas.statistics

正解：A 解答を投票する

出題：16

Which CAS action is used to import data into CAS?

A. ALTER TABLE

B. LOAD

C. CASLIB

D. EXPORT

正解：B 解答を投票する

A00-420試験無料問題集「SASInstitute SAS Viya Intermediate Programming 認定」