A00-415試験無料問題集（257題）「SASInstitute SAS Viya Fundamentals of Programming 認定」

出題：1

Which programming language is primarily used in CAS?

A. R

B. SAS

C. Python

D. Java

正解：B 解答を投票する

出題：2

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=_maxrows_;
quit;

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

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

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

正解：C 解答を投票する

出題：3

Which CAS action is used to remove duplicate records from a CAS table?

A. cas.distinct

B. cas.unique

C. cas.dedup

D. cas.remove

正解：C 解答を投票する

出題：4

Which CAS action is used to generate a random sample from a CAS table?

A. cas.sample

B. cas.fetch

C. cas.random

D. cas.select

正解：A 解答を投票する

出題：5

Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?

A. table.columnInfo /
table={caslib="casuser", name="clientes"};

B. table.tableInfo /
table={caslib="casuser", name="clientes"};

C. table.columnInfo /
caslib="casuser", name="clientes";

D. table.tableInfo /
caslib="casuser", name="clientes";

正解：A 解答を投票する

出題：6

Which CAS action is used to load data from an external file into a CAS table?

A. cas.fetch

B. cas.load

C. cas.import

D. cas.upload

正解：C 解答を投票する

出題：7

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 produces an error indicating the DESCENDING option is not supported in the BY statement.

B. The program produces an error indicating the NOPERCENT option is not supported in the TABLE statement.

C. The program runs normally on the Compute Server and produces a cross-tab report.

D. The program runs normally on the CAS server and produces a cross-tab report.

正解：A 解答を投票する

出題：8

What is the purpose of the GROUP BY clause in SQL programming?

A. To group rows based on common values

B. To define the output columns

C. To filter rows based on conditions

D. To sort the result set

正解：A 解答を投票する

出題：9

Which statement can execute successfully using PROC FEDSQL?

A. create table work.age12 as
select Name, Height, Weight
from casuser.class
where age=12
;

B. select Species, SepalWidth, SepalLength
from casuser.iris
where Species ^= "Setosa"
;

C. create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
from casuser.heart
where cholesterol is null
;

D. select HouseID, Brand, exp(logPrice) as Price
from casuser.margarin
where calculated Price > 5
;

正解：C 解答を投票する

出題：10

In the DATA step, which statement is used to output the processed data?

A. SAVE statement

B. PRINT statement

C. OUTPUT statement

D. EXPORT statement

正解：C 解答を投票する

出題：11

What is the purpose of the APPEND action in CAS language programming?

A. To concatenate multiple CAS tables vertically

B. To add new observations to an existing CAS table

C. To append columns to an existing CAS table

D. To merge multiple CAS tables horizontally

正解：B 解答を投票する

出題：12

The following SAS program is submitted:

What is the output to the log?

A. A syntax error

B. A list of all active CAS sessions for all users

C. A NOTE with information about the new CAS session listsessions

D. A list of CAS sessions associated with the current user

正解：C 解答を投票する

出題：13

Which SAS Viya component is responsible for storing and managing user-defined formats?

A. SAS Studio

B. CAS server

C. SAS Metadata Server

D. SAS Data Connector

正解：C 解答を投票する

出題：14

Which CAS statement is used to assign a CAS table to a CAS library?

A. CASLIB

B. CASSET

C. CASTABLE

D. CASDATA

正解：A 解答を投票する

出題：15

What is the purpose of the WHERE clause in CAS actions?

A. To specify the target variable for analysis

B. To define the data types of variables

C. To join multiple tables together

D. To filter rows based on specified conditions

正解：D 解答を投票する

出題：16

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

出題：17

Which statement is used to sort a SAS dataset in ascending order?

A. PROC SORT

B. SORT DSN

C. SORT DESCENDING

D. ORDER BY

正解：A 解答を投票する

出題：18

Which CAS action is used to load data into the CAS environment?

A. INPUT

B. LOAD

C. IMPORT

D. READ

正解：B 解答を投票する

出題：19

Which CAS action is used to convert a character variable to a numeric variable in a CAS table?

A. cas.cast

B. cas.convert

C. cas.change

D. cas.transform

正解：A 解答を投票する

出題：20

Which SAS procedure is used for generating descriptive statistics?

A. PROC SUMMARY

B. PROC REPORT

C. PROC TABULATE

D. PROC MEANS

正解：D 解答を投票する

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