最新的SASInstitute A00-420免費考試真題

問題1

In SAS Viya, what is the purpose of the SAS Studio application?

A. To perform data visualization

B. To create interactive reports

C. To build machine learning models

D. To write and execute SAS programs

正確答案: D

問題2

Which program will display ODS output?

A. proc cas;
simple.summary / table={caslib="casuser" name="class"};
quit;

B. proc cas;
print casuser.class;
quit;

C. proc cas;
table.fetch result=r / table={caslib="casuser" name="class"};
quit;

D. proc mdsummary data=casuser.class;
var height;
output out=casuser.result;
run;

正確答案: A

問題3

Which statement is used to define a user-defined format in SAS Viya?

A. FORMAT statement

B. LENGTH statement

C. LABEL statement

D. INFORMAT statement

正確答案: A

問題4

Given the following CASL program:
proc cas;
table.tableInfo result=res / caslib="casuser";
do row over res.tableInfo;
print row;
end;
run;
quit;
Which statement best describes the variable row in the above program?

A. Row is comma separated string containing name and additional information of tables in caslib casuser.

B. Row is a dictionary containing key=value pairs with information on each table in caslib casuser.

C. Row is an array containing the values with information on each table in caslib casuser.

D. Row is string type variable that contains the name of a table in caslib casuser.

正確答案: B

問題5

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

A. CASSET

B. CASWHERE

C. CASTABLE

D. CASCOMPUTE

正確答案: D

問題6

Which action loads the cars.csv file from the casuser caslib into memory?

A. table.loadTable / caslib="casuser" , path="cars.csv";

B. table.upload / table={caslib="casuser", path="cars.csv"};

C. table.upload / caslib="casuser" , path="cars.csv";

D. table.loadTable / table={caslib="casuser", path="cars.csv"};

正確答案: A

問題7

Which PROC TRANSPOSE step will execute entirely in CAS?

A. proc transpose data=work.table out=work.table_transposed;
id group;
run;

B. proc transpose data=casuser.table out=work.table_transposed;
id group;
run;

C. proc transpose data=casuser.table out=casuser.table_transposed;
id group;
run;

D. proc transpose data=work.table out=casuser.table_transposed;
id group;
run;

正確答案: C

問題8

Which CAS action is used to create a new CASLIB?

A. CASLIB

B. EXPORT

C. LOAD

D. ALTER TABLE

正確答案: A

問題9

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

A. CASIMPORT

B. CASDATA

C. CASLIB

D. CASTABLE

正確答案: A

問題10

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. Primary_school should be in double quotes.

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

C. The teachers table does not exist in-memory in the primary_school caslib.

D. The user does not have the permissions to drop tables from this caslib.

正確答案: C

問題11

Which CASL program will create the sample2 table in the casuser caslib?

A. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class;
y=ranuni(123)*100;
run;
";
run;

B. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class(firstobs=3);
run;
";
quit;

C. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class;
by age;
if first.age then y=age;
run;
";
quit;

D. proc cas;
datastep.runCode result=r/
code="
data casuser.sample1;
set casuser.class;
y=1;
run;
data casuser.sample2;
set casuser.class;
y=2;
run;
";
quit;

正確答案: C

問題12

When loading a data set into memory using PROC CASUTIL and the LOAD statement, what option will set the in-memory table's scope to GLOBAL?
Enter your answer in the space below: _________

正確答案:

promote

問題13

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

A. cas.verify

B. cas.duplicate

C. cas.check

D. cas.identify

正確答案: B

問題14

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

A. To filter rows based on conditions

B. To define the output columns

C. To group rows based on common values

D. To sort the result set

正確答案: C

問題15

In PROC CASUTIL, what does the LOAD FILE= statement do?

A. It loads the data from a CAS table to a file on the Compute Server.

B. It loads a file from a file location on the Compute Server to the CAS controller file system.

C. It loads a file from a file path on the Compute Server to a CAS table.

D. It loads files from a file path on the CAS server to a CAS table.

正確答案: C

最新的SASInstitute SAS Viya Intermediate Programming - A00-420免費考試真題

聯系我們

站內鏈接

最新更新