A00-415無料問題集「SASInstitute SAS Viya Fundamentals of Programming」

質問 1

Which CAS-enabled procedure is used for descriptive statistics and data summarization?

（A）PROC GLM

（B）PROC SQL

（C）PROC FREQ

（D）PROC MEANS

正解：D 解答を投票する

質問 2

Which statement is used to read data from an external file into a SAS dataset?

（A）MERGE statement

（B）SET statement

（C）PROC SQL

（D）OUTPUT statement

正解：B 解答を投票する

質問 3

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

（A）cas.count

（B）cas.distinct

（C）cas.frequency

（D）cas.uniq

正解：D 解答を投票する

質問 4

After submitting the following SAS program, the log below is created.
Code:
proc casutil;
droptable incaslib='primary_school' casdata="teachers";
quit;
Log:
ERROR: The table teachers could not be located in caslib primary_school of Cloud Analytic Services.
ERROR: The action stopped due to errors.
Why is the table not dropped?

（A）The user does not have the permissions to drop tables from this caslib.

（B）The casdata= option should be before the incaslib= option.

（C）Primary_school should be in double quotes.

（D）The teachers table does not exist in-memory in the primary_school caslib.

正解：D 解答を投票する

質問 5

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

（A）CASPROC

（B）CASMINER

（C）CASASSOC

（D）CASSTAT

正解：C 解答を投票する

質問 6

Employees is a 5,000 row table.
Which program executes in CAS using a single thread?

（A）data casuser.employees /single=yes;
set casuser.employees;
totcomp = sum(salary,bonus);
run;

（B）data casuser.employees;
set casuser.employees;
by department;
totcomp = sum(salary,bonus);
run;

（C）data casuser.employees /single=yes;
set work.employees;
totcomp = sum(salary,bonus);
run;

（D）data casuser.employees;
set work.employees;
by department;
totcomp = sum(salary,bonus);
run;

正解：A 解答を投票する

質問 7

What is the purpose of the SET statement in the DATA step?

（A）To specify conditional logic

（B）To apply formatting to variables

（C）To define the input data source

（D）To create a new variable

正解：C 解答を投票する

質問 8

Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as markup_N from casuser.cars"; run;

（A）put(markup,'best12.')

（B）cast(markup,'best12.')

（C）input(markup,'best12.')

（D）inputn(markup,'best12.')

正解：D 解答を投票する

質問 9

Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

（A）MAXOBS=

（B）NOCOMPUTE

（C）CASDATALIMIT=

（D）MAXDATA=

正解：C 解答を投票する

質問 10

Which CASL program will fetch all 428 rows from the cars table?

（A）proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=1000;
quit;

（B）proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1;
quit;

（C）proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_all_;
quit;

（D）. proc cas;
table.fetch /
table={name="cars", caslib="casuser"},
from=1,
to=_maxrows_;
quit;

正解：A 解答を投票する

質問 11

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

（A）SUBSET

（B）FILTER

（C）SELECT

（D）WHERE

正解：D 解答を投票する

質問 12

Which CAS-enabled procedure is used for data exploration and visualization?

（A）PROC SQL

（B）PROC SGPLOT

（C）PROC FREQ

（D）PROC MEANS

正解：B 解答を投票する

質問 13

What data types does FedSQL support in CAS?

（A）INT64, CHAR(n), DOUBLE, INT32, VARBINARY, VARCHAR(n)

（B）BIGINT, CHAR(n), DATE, DOUBLE, DECIMAL, VARBINARY

（C）CHAR(n), DOUBLE, VARCHAR(n), TIMESTAMP, DATE, TIME

（D）INT64, CHAR(n), DOUBLE, INT32, VARCHAR(n), FLOAT

正解：A 解答を投票する

質問 14

Given that this program:
simple.numRows /
table={caslib="casuser",name="cars"};
produces this output in the Log:
{numrows=428}
Which program produces the following output in the Log?
Table casuser.cars has 428 rows.

（A）simple.numRows results=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " x[numrows] "rows.";

（B）simple.numRows result=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " x.numrows "rows.";

（C）simple.numRows results=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " numrows[x] "rows.";

（D）simple.numRows result=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " numrows.x "rows.";

正解：B 解答を投票する

A00-415 無料問題集「SASInstitute SAS Viya Fundamentals of Programming」

弊社を連絡する

関連リンク

トップ試験