최신 A00-420 무료덤프 - SASInstitute SAS Viya Intermediate Programming

문제1

Given the dictionary myDict defined using the following statement: mydict = {age = 16, characteristics = {hair = "dark", eyes = "brown"}}; Which code segment correctly assigns the value brown to the variable x?

A. selection = "eyes";
x = myDict[characteristics][selection];

B. x = mydict.characteristics[eyes];

C. selection = "eyes";
x = myDict["characteristics"][selection];

D. x = myDict{"characteristics"}{"eyes"};

정답: C

문제2

Which SAS procedure is used for generating descriptive statistics?

A. PROC REPORT

B. PROC TABULATE

C. PROC MEANS

D. PROC SUMMARY

정답: C

문제3

Which statement will show all available caslibs in the log?

A. caslib all list;

B. caslib _all_ list;

C. caslib listall;

D. caslib list;

정답: B

문제4

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

A. CASTAT

B. CASREG

C. CASPROC

D. CASANALYZE

정답: B

문제5

Given an array cars with an unknown number of elements, use a CASL function to complete the following program segment to complete the DO loop:
do i=1 to _________
;
print cars[i];
end;

정답:

dim(cars)

문제6

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

A. SUMMARY

B. GROUP BY

C. COMPUTE

D. FORMAT

정답: B

문제7

Which PROC MDSUMMARY step produces results?

A. proc mdsummary data=casuser.orders;
var profit;
run;

B. proc mdsummary data=casuser.orders;
var profit;
output out=casuser.sumorders;
run;

C. proc mdsummary data=casuser.orders;
var profit / out=casuser.sumorders;
run;

D. proc mdsummary data=casuser.orders;
var profit;
out casuser.sumorders;
run;

정답: B

문제8

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

문제9

What is the purpose of the LIBNAME statement in SAS Viya?

A. Controlling the flow of the program

B. Executing SQL queries

C. Declaring and initializing variables

D. Defining a library or a location for SAS datasets

정답: D

문제10

Which CAS action is used to export data from the CAS environment?

A. WRITE

B. OUTPUT

C. EXPORT

D. SAVE

정답: C

문제11

Which SAS Viya component is responsible for executing CAS-enabled procedures?

A. SAS Data Connector

B. SAS Metadata Server

C. CAS server

D. SAS Studio

정답: C

문제12

Which statement is FALSE regarding loading data into CAS?

A. Both DATA step and PROC COPY can be used to load data into CAS.

B. Excel files can be loaded directly into CAS.

C. JSON files can be loaded directly into CAS.

D. Data Connectors are required to load DBMS data directly into CAS.

정답: C

문제13

Which CAS action is used to create a new variable in a CAS table based on a conditional expression?

A. cas.transform

B. cas.derive

C. cas.calculate

D. cas.generate

정답: B

문제14

Which CAS action is used to perform a cross-tabulation of two categorical variables in a CAS table?

A. cas.tabulate

B. cas.pivot

C. cas.crosstab

D. cas.summary

정답: C

문제15

How can you associate a user-defined format with a variable in SAS?

A. Using the WHERE statement in PROC SQL

B. Using the FORMAT statement in the DATA step

C. Using the LABEL statement in PROC FORMAT

D. Using the BY statement in PROC FORMAT

정답: B

문제16

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", groupby={name="name"}},
casout={caslib="casuser", name="outclass", replace=true};
quit;

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

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

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

정답: C

문제17

Which statement is true about the Compute Server?

A. It processes distributed data in multiple threads.

B. It supports the creation and execution of Macro programs.

C. It generally outperforms the CAS server for data sources that are larger than 50 Gigabytes.

D. It processes programs written in SAS, Python, Java, and other open source client languages.

정답: B

문제18

Which DATA step function is used to concatenate character variables in CAS programming?

A. CONCAT

B. CATS

C. CAT

D. LENGTH

정답: B

최신 A00-420 무료덤프 - SASInstitute SAS Viya Intermediate Programming

우리와 연락하기

유용한 링크

최신 업데이트